2088061 - Standard Field not showing on exported user data file (UDF) and Basic Import template from Employee Export/Import Employee Data tools

When you run the Employee Export, the file is missing one more fields. The fields are also not present when you download the Basic Import template from the Import Employee Data tool.

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. Logon with admin user
2. Go to Admin Center
3. Go to Employee Export
4. Export the user data file (UDF)
5. When opening, you notice that there is a field that you setup on data model missing

If using the Import Employee Data tool:

1. Go to Admin Center
2. Go to Import Employee Data
3. Select 'Download Template': Basic Import
4. Click 'Generate Template'
5. Fields are missing from the template.

The cause is that when you create the standard-field on the data model, it was missed to include the field on the section sysVisibleUserDirectorySetting.

This section is where the fields on the employee export file and basic template are pulled from.

Refer to:

• 2267907 - Employee Import/Export file: supported standard-elements fields
• Guide Managing User Information - Chapter - Field Requirements for the User Data File

The solution is to include the missing field on the sysVisibleUserDirectorySetting section as example below for CUSTOM12 field.

You need to make sure that the field is already created on the data model before including it on the sysVisibleUserDirectorySetting.

To include the field, you need to follow the below steps:

Via BCUI:

• • Go to Manage Business Configuration > Employee Profile > View Template > sysUserDirectorySetting > sysVisibleUserDirectorySetting > add 'custom12' and save
  • Go to Manage Business Configuration > Employee Profile > View Template > sysUserDirectorySetting > sysAllUserDirectorySetting > add 'custom12' and save

1. Export the data model of your instance;
2. Open the exported data model
3. Search for the section <edit-template id="sysVisibleUserDirectorySetting">;
4. On that section check if the standard-element-ref to the field is not yet included;
5. If not included yet you need to insert it before the </edit-template> tag as example below (on bold what you need to include):

<edit-template id="sysVisibleUserDirectorySetting">
<label>User Directory Setting(Visible)</label>
...

      <standard-element-ref refid="username"/>
      <standard-element-ref refid="firstName"/>
      <standard-element-ref refid="lastName"/>

...

      <standard-element-ref refid="custom12"/>
</edit-template>

1. Save the file that you have changed;
2. Import the new data model file with the field into the instance.

With the change on the data model, you now should see the field on the Employee Export.

FAQ - Additional Information

Q) Where can I get information on this from the Guide?

A) Guide: 

Guide - Managing User Information - Exporting User Data

Guide Managing User Information - Chapter - Field Requirements for the User Data File

Guide: Configuring People Profile

• 2654248 - What is difference between <edit-template id="sysAllUserDirectorySetting"> and <edit-template id="sysVisibleUserDirectorySetting"> in the Data Model and BCUI

• 2267907 - Employee Import/Export file: supported standard-elements fields

• 2086718 - How to use manual Employee Import? HCM Suite

• 2088061 - Data Model: VisibleUserDirectorySetting Controlling Field Visibility - Platform
• 2576599 - View Template Section in Manage Business Configuration Tips and Tricks

• 2574481 - Basic Import Options

• 2643327 - Missing 'Company Exit Date' Field in User Profile for DRTM
• 2363922 - How to create an HRIS Sync Mapping between an Employee Central field and an Employee Profile Using Userinfo Element field
• 2555493 - Missing Standard elements filed "custom01 to custom10 in BCUI
• 2420282 - User Data File (UDF) | How to control the fields visibility and their order
• 2088061 - Standard Field not showing on exported user data file (UDF) from Employee Export
• 2547757 - Manage Business Configuration : some employee profile fields are missing

• 2576599 - View Template Section in Manage Business Configuration Tips and Tricks

• 2088099 - Manage Users: Column fields missing in Manage Users page - sysVisibleUserDirectorySetting - Platform
• 2088061 - Data Model: VisibleUserDirectorySetting Controlling Field Visibility - Platform
• 2091409 - Import & Export Process for Extended User Information in SuccessFactors HXM Suite

• 2751107 - How to download the template for Employee Import?

• 2087504 - Data Imports & Exports - Explanation of the Fields in the Employee Import File: User Import File

• 2080175 - How often does the Basic Organization Chart get updated? - Employee Central

 Data Model, sysAllUserDirectorySetting, sysVisibleUserDirectorySetting, UDF, Configure People Profile, basic import, BCUI, Manage Business configuration, standard-element-ref, employee export , KBA , LOD-SF-PLT-UEX , Employee Export Issues , LOD-SF-PLT , Platform Foundational Capabilities , LOD-SF-EC-BCI , Manage Business Configuration (BCUI) & Data Models (XML) , LOD-SF-EC-EDP-BIO , Biographical Information Import , LOD-SF-EC-HRS , HRIS Sync , Problem