About the import file format for WFM employees

The import file for new employees must follow the described format. Some values are mandatory, but most of them are optional.

Default values can be defined for the parameters Site and Team, Contract, Contract schedule and Part-time percentage. If default values are defined, they are used if no value is defined in the import file. See Set default values for the WFM employee import for more information.

The file should be an Excel file with the .xlsx format.

People import file columns

  • First name (mandatory)
  • Last name (mandatory)
  • Start date (mandatory). Use date format YYYY-MM-DD.
  • Site (optional if a default value is defined). If not defined in the file, the default value is used.
  • Team (optional if a default value is defined). If not defined in the file, the default value is used.
  • Contract (optional if a default value is defined). If not defined in the file, the default value is used.
  • Contract schedule (optional if a default value is defined). If not defined in the file, the default value is used.
  • Part-time percentage (optional if a default value is defined). If not defined in the file, the default value is used.
  • Employment number (optional). Must be unique, otherwise the row will give an error.
  • Email address (optional). Must be unique, otherwise the row will give an error.
  • Application logon name (optional). Must be unique, otherwise the row will give an error.
  • Identity logon (optional). Must be unique, otherwise the row will give an error.
  • Roles (optional). Only one role can be assigned in the import.
  • Workflow control set (optional).
  • Shift bag (optional). Set on the person period that is created with the given start date.
  • Budget group (optional). Set on the person period that is created with the given start date

Related topics