SAP Knowledge Base Article - Public

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

Symptom

While performing Employee Import via Admin Center or scheduled job, you see errors below:

  • 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;

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

Scenario 01:

  1. Go to Update user information;
  2. Download Basic Import template;
  3. Validate this file;
  4. Error occurred;

Scenario 02:

  1. Go in Provisioning;
  2. Monitor Job > Search by Employee Import >
  3. Select Details option to see the error

Cause

Please find below the potetial 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.

Resolution

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

  • You are 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;
    • You should configure your environment to read encrypt files, please, follow the KBA 2296971 - Generating and Importing PGP Keys - SAP for Me
  • This instance has enabled pre-day1 feature and the user record has no onboarding id
    • Please make sure that the imported user has onboarding id.

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.

See Also

Keywords

employee import job, user import, user import failling, import error, no file from FTP server matched this file name pattern , KBA , LOD-SF-PLT , Platform Foundational Capabilities , How To

Product

SAP SuccessFactors HCM Suite all versions