SAP Knowledge Base Article - Public

2489655 - Unable to Import Legacy Picklist

Symptom

When attempting to import a picklist, the process is ended without any message or errors - nothing happened and the picklist was not updated.

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Go to Admin Center;
  2. Search for Picklists Management;
  3. Select Import Picklist option;
  4. Import a picklist using an excel file type or CSV;
  5. The UI will suddenly change from the import screen to the admin center.

Cause

There are three possible causes for this issue:

  1. This behavior is caused by the incorrect file type being used like an Excel file (.xls);
  2. The picklist import template has been incorrectly modified or has deleted fields;
  3. The encoding of the .csv file is not set to UTF-8.

Resolution

To import picklists, please use the CSV file (.csv) type for import, and make sure to select UTF-8 in the encoding type. If you experience the same symptom even when using a CSV file, please check that the correct picklist template is being utilized. You can do this by using the 'Export data format' button in Picklists Management. No fields should be removed from the template as the system expects these fields during the upload.

Also, please ensure that no external codes are maintained for deleted picklist values. These fields should be blank.

Keywords

Legacy Picklist Import, Admin center, blank screen, while trying to invoke the method java.util.ArrayList.size() of a null object loaded from local variable 'languages', Import, Picklist, Template, , KBA , LOD-SF-PLT-PCK , Picklist Management Issue , Problem

Product

SAP SuccessFactors HXM Suite all versions