2559898 - Fields such as UserID and Status are Duplicated in Basic User Info Import Template File

• Basic Import is successfull, but users are not created in system.
• Basic import notification does not show failed users
• 'UserID' and/or 'Status' are displayed twice in different columns in the Basic User Info import template file.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP SuccessFactors HXM Suite

1. Go to Admin Centre > Import Employee Data
2. In "Select the action you want to perform" choose "Download Template"
   
   
   
3. Select 'Basic Import'
4. Click on "Generate Template" and open the CSV file
5. Notice that 'STATUS' and/or 'USERID' are displayed in Columns A and B respectively, but are also displayed in 2 other columns in the template file

 

This problem occurs when 'USERID' and 'STATUS' are defined as standard elements in the Succession Data Model.

These fields are hard-coded and so do not need to be defined in the Succession Data Model as they will display as the first 2 rows in the Basic Import template file anyway.

In order to remove the duplicate columns from the Basic Import template file, you will need to remove the defined standard elements 'UserID' and 'Status' from the Succession Data Model. This can be done via Manage Business Configuration or via a Data Model Upload in Provisioning;

Manage Business Configuration:

1. Via Admin Center navigate to Manage Business Configuration
2. Under the Employee Profile Section, expand View Template
3. Select sysUserDirectorySetting
4. Remove the userId and status fields using the trashcan 
5. Save

Data Model Upload: 

1. Access Provisioning > Succession Management > Import/Export Data Model
2. Select 'Export File' > Submit
3. Open the Export file and save a copy
    
4. Search (using 'Ctrl + f') for <view-template id="sysUserDirectorySetting"
   
   
5. Scroll down to the section where fields are being defined as '<standard-element-ref refid='
6. Here, look for <standard-element-ref refid="userId"/> and <standard-element-ref refid="status"/>
   
   
7. Highlight and delete these 2 lines only > Save this file
   
   
8. Access Provisioning > Succession Management > Import/Export Data Model
9. Select 'Import File' > Choose the saved file > Submit

Note: If you do not have access to provisioning please raise a ticket with SuccessFactors Support

Employee Central, Basic User Info Import, Basic Import, UserID, Status, Duplicate, Import Template, Import Employee Data,sysAllUserDirectorySetting , KBA , LOD-SF-PLT-UIM , Employee Import Issues , LOD-SF-EC-EDP , Import Employee Data (EC Core only) , Problem

SAP SuccessFactors Employee Central 1611 ; SAP SuccessFactors Employee Central 1702 ; SAP SuccessFactors Employee Central 1705 ; SAP SuccessFactors Employee Central 1708 ; SAP SuccessFactors Employee Central 1711 ; SAP SuccessFactors Employee Central 1802 ; SAP SuccessFactors HCM Suite all versions