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

'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 HCM 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, SuccessFactors, Platform, SuccessFactors , KBA , LOD-SF-PLT-MNG , Manage user Issues , Problem