SAP Knowledge Base Article - Public

3059954 - Error "The data in the following cell is incorrectly formatted" - LMS

Symptom

Getting the following error when trying to Import Data for Exam:

"The data in the following cell is incorrectly formatted: (U)"

Whereas 'U' Column is for "Total Duration". This column ID can be any.

"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. System Administration --> System Management Tools --> Import Data
  2. Select Record Type 'Exam'.
  3. Import File --> Choose File and Upload it.
  4. Click Submit.
  5. Run the job.
  6. And then error shows up in logs after job finishes.

Resolution

  1. Data type for "Total Duration" is Long and the value should be in seconds.
  2. If you move/ hover mouse over the Column header, this will show the field properties.


  3. Make sure the right values are entered here in seconds or as shown as per screenshot above. For example, for 10 mins, the value should be 600.

Note: If you get this error or similar issue for other column, make sure the values entered in that column are correct. You can check by hovering over the Column Field name. This will show what Data type is required and also suggest type of values that can be entered.

Keywords

SuccessFactors, LMS, learning, column, seconds, mins, hours, long, double, string, integer, excel, export, template , KBA , LOD-SF-LMS-ASB , Assessment Builder , Problem

Product

SAP SuccessFactors HXM Core all versions ; SAP SuccessFactors Learning all versions