Symptom
When importing user data via 'Import Data Tool', received following error message.
Validation Error:
Please correct the following errors before proceeding:
- The following column heading is not in the expected column: Include in government reporting, Spreadsheet User, Column BJ.
- The following column heading is not in the expected column: 2483 Legal Entity, Spreadsheet User, Column BK.
- The following column heading is not in the expected column: 2483 Employee Class, Spreadsheet User, Column BL.
- The following column heading is not in the expected column: Hourly Rate, Spreadsheet User, Column BM.
- The following column heading is not in the expected column: Hourly Rate Currency, Spreadsheet User, Column BN.
- The following column heading is not in the expected column: Native DeepLink User, Spreadsheet User, Column BO.
- The following column heading is not in the expected column: Adjusted Hourly Rate, Spreadsheet User, Column BP.
- The following column heading is not in the expected column: Adjusted Hourly Rate Currency, Spreadsheet User, Column BQ.
- The following column heading is not in the expected column: Date of Birth, Spreadsheet User, Column BR.
- The following column heading is not in the expected column: Disability Classification ID, Spreadsheet User, Column BS.
- The following column heading is not in the expected column: Gamification User ID, Spreadsheet User, Column BT.
- The following column heading is not in the expected column: License User Type, Spreadsheet User, Column BU.
- The following column heading is not in the expected column: Login Site, Spreadsheet User, Column BV.
- The following column heading is not in the expected column: Shopping Account Type, Spreadsheet User, Column BW.
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- Follow KBA 2387756 to set up custom fields
- Add additional custom field in the user import template
- After filling out the file, proceed with the import > Submit > Run/Schedule the job
- Validation message received
Cause
The additional custom filed is added between the default headers. All of the column value positions in the default 'Import Data' user template are fixed. Once the default positions are changed, the system will not be able to read import data.
Resolution
As the columns in the template should not be deleted or moved, please download the default user template to upload data.
Frequent Q&A
1. Why the template is always in English?
The default language for the template is English, as it is the universal system language.
2. What if my system language is in other locales than English? e.g Japanese
It is required to use the default English template, but you can complete it in your preferred locale. Ensure that your admin preferred locales match when importing files.
3. Can we have the custom content to be in different locale and reflecting according to system language setting?
Learning does not support this function yet. SAP Customer Influence is a great program for customers and partners to share feedback / ideas that help enhance SAP solutions in production.
4. What is the maximum amount of Custom Fields can be added in the 'Import Data' template at once?
You can update up to 10 custom columns at once. Columns should not be deleted or moved, and the system ignores additional columns during data import.
See Also
Keywords
Validation error, import data, custom fields, column position, template, error message, data import, column heading is not in the expected column, maximum, column, user template , KBA , LOD-SF-LMS-IMP , Import Data Tool , Problem