2529511 - Employee Import job fails due to "Field Label in column" errors

While performing Employee Import via Admin Center or scheduled job, error is displayed:

• Field Label in column -1 does not match the required field name;
• Field Label in column -2 does not match the required field name;
• Field Label in column -3 does not match the required field name;

SAP SuccessFactors HCM Suite

• Error During Basic Import Validation

1. 1. Navigate to Update User Information.
   2. Download the Basic Import Template.
   3. Validate the file.
   4. An error occurs during validation.

• Checking Error Details in Provisioning

1. 1. Navigate to Provisioning.
   2. Go to Monitor Job and search for Employee Import.
   3. Select the Details option to view the error.

Potential causes for each error:

• Field Label in column -1 does not match the required field name
  • You are placing an encrypt file in the SFTP, however the system is not configured yet to read encrypt files.

• Field Label in column -2 does not match the required field name
  • It means the file has no user data.

• Field Label in column -3 does not match the required field name
  • It means this instance has enabled pre-day1 feature and the user record has no onboarding ID.

To fix these issues, the below checks must be performed:

• Placing an encrypt file in the SFTP, however the system is not configured yet to read encrypt files.
  • Removing the encryption from the file. If you are trying to import the file via Schedule Jobs from Provisioning, you should remove the .pgp extension from the file name as well.
  • Configure your environment to read encrypt files, please, follow the KBA 2296971 - Generating and Importing PGP Keys - SAP for Me
• The file has no user data. For this error, please input user's information.
  Ensure the file being imported follows the template. For that, make sure to download the template as explained at 2751107 - How to download the template for Employee Import?
• This instance has enabled pre-day1 feature and the user record has no onboarding id
  1. Add a header column "ONBOARDING_ID" in the csv file
  2. Ensure this header is the last column.
  3. Tick "Re-activate purged user" option
  4. Re-try the import 

NOTE: Whenever you see receive any error similar to the above, always ensure the import file follows the template from Employee Import page in Admin Center.

• KBA 2751107 - How to download the template for Employee Import
• KBA 2296971 - Generating and Importing PGP Keys

employee import job, user import, user import failing, import error, no file from FTP server matched this file name pattern, SuccessFactors, Field Label in column -1, Field Label in column -2, Field Label in column -3, Field Label, column, , KBA , LOD-SF-PLT-UIM , Employee Import Issues , LOD-SF-PLT , Platform Foundational Capabilities , LOD-SF-PLT-JOBS , Scheduled Jobs , How To