SAP Knowledge Base Article - Public

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

Symptom

'UserID' and '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.

Environment

  • Employee Central
  • Import Employee Data
  • Basic import

Reproducing the Issue

  1. Go to Admin Centre > Import Employee Data
  2. Click on the dropdown arrow in 'Download a blank CSV template'

    Import_Employee_Data.png
  3. Select 'Basic Import'
  4. Downlaod and Open the CSV file
  5. Note that 'STATUS' and 'USERID' are displayed in Columns A and B respectively, but are also displayed in 2 other columns in the template file


 UserID_Status.png


Duplicates.png

Cause

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.

Resolution

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"

    Search.png
  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"/>

    USERID_STATUS_Data_Model.png
  7. Highlight and delete these 2 lines only > Save this file

    Delete_Lines.png
  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

Keywords

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

Product

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 HXM Suite all versions