SAP Knowledge Base Article - Public

2387756 - Import data functionality works on custom column entities

Symptom

  • How to import users or other entities using the Import Data feature?
  • How to input custom columns in an entity template file from Import Data?
  • Error: The following custom column does not exist.

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

Reproducing the Issue

  1. Create the desired custom field(s) > Try to import data using the Import Data feature >
  2. System Administration > System Management Tools > Import Data.

Cause

The "Custom Column Name" column in the entity template file contains the custom column number instead of the label name or the custom field label doesn't exist in the system.

Resolution

Please, make sure that the custom field and its label exist in the system: System Administration > Custom Fields > Search/Choose and access the desired entity.

Ex.: User custom field > The custom field is labeled as "DIVISION".

sample1.png

How to import data the data:

  1. System Administration > System Management Tools > Import Data >
  2. The "Custom Column Name" column should contain custom field label value not the ID/number >

KBA 2387756 resolution.png

  1. After filling out the file, proceed with the import > Submit > Run/Schedule the job >
  2. Then, verify the record to confirm the creation/update.

See Also

Keywords

lms, learning, custom, field, column, name, label, import, data, tool, entity, entities, reference, The following custom column does not exist , KBA , LOD-SF-LMS-IMP , Import Data Tool , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-ADM , System Admin, Global Variables, References , How To

Product

SAP SuccessFactors Learning all versions