SAP Knowledge Base Article - Public

2087543 - Data Imports & Exports: User Import Employee Not Imported Due to Incorrect Date Format - Platform

Symptom

After importing user(s) through Employee Import on Admin Center, an email was generated that shows the 'process' completed successfully; however user(s) was/were still not updated.

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Import users into SuccessFactors;
  2. Receive e-mail notification about successful completion of import;
  3. Users were not created/updated.

Cause

One possible cause for the user not being updated correctly is that the date format used in the import file is not correct. Incorrect date format: DD/MM/YYYY.

Resolution

Successfactors requires the following Date Format: MM/DD/YYYY, and there is no way currently to change this format.

Below is an example of the information contained in the confirmation email. In this example, the 1 record was not imported even though the process itself completed successfully. It is important to review these emails as they provide insightful information indicating whether records have been imported or not. This may help you determine quickly if your data was imported as desired.

Total records: 1 (1 active user(s), 0 inactive user(s)).
Records with changes: 0.
Records without changes: 1.
Users imported/updated: 0; Failed: 0.
Users marked as inactive: 0; Failed: 0; No status change: 0.
Users transferred: 0; Failed: 0.
User Import Process has completed successfully.

Note: If this import file is generated through an SAP or any HRIS system you would also need to make sure you pass the 0's in the file, and that dates are in the format required by SuccessFactors.

See Also

2087504 - An Explanation of the Fields in the Employee Import File

Keywords

BizX, SuccessFactors, SF, SSFF, Data Import, Export User, Admin Center, Incorrect, Date Format, Date, MM/DD/YYYY , KBA , sf bizx system/platform , LOD-SF-PLT , Platform Foundational Capabilities , LOD-SF-PLT-UIM , Employee Import Issues , Problem

Product

SAP SuccessFactors HXM Suite all versions