SAP Knowledge Base Article - Public

2387756 - How Import data functionality works on custom column entities - LMS

Symptom

  • How to import users or other entities using Import Data tool Functionality
  • How to input custom columns in an entity template file from the Import Data Tool
  • Error: column doesn't exists when trying to import data

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

Environment

SAP SuccessFactors Learning Management System

Reproducing the Issue

  1. After creating custom column/field, try to import data using Import Data tool.
  2. System Admin > Tools > Import Data

Cause

  • The field Custom Column Name in the entity template contains the custom column number instead of the label name.
  • The custom column label does not exist in the system.

Resolution

  • Please make sure that the custom column/label exists in the system. (System Admin > Custom Columns > choose the affected entity > search)
  • In this example, USER custom column is being used. The custom column is labeled as DIVISION.

KBA 2387756 resolution2.png

How to import data using Import Data tool:

  1. System Admin > Tools > Import Data
  • Download and update the entity template correctly. The field Custom Column Name should contain Column Name or Label and not column ID/Number.

KBA 2387756 resolution.png

  1. After updating the file, select Action: Import Data and select the appropriate import data required fields > Submit > Run Job
  2. To verify, go to the user record of the new user that has been imported

 KBA 2387756 resolution1.png

See Also

 2372689 - Adding custom fields/columns in LMS of a particular data type

Keywords

SF, Success Factors, LMS, learning, Custom Column Name field, import data tool, entities, labels, reference , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , How To

Product

SAP SuccessFactors Learning all versions