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

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

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

Whereas '*' refers to the affected column. The "Total Duration" column is T in the excel template. 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."

SAP SuccessFactors Learning

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.

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 1: 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.  Check the value after entering it via the UI and saving to clarify the format expected.

Note 2: If the values that were input in the template were copied from another file that might contain text formatting, this could be inherited from the source and impact in the data format expected in the template file. To avoid such issue, instead of copying the data from a Source File, type it in the template column cell.

If this is desired to copy and paste, consider to paste it first in a Notepad to remove any formatting. Once it's pasted in the Notepad, select it and copy it from the Notepad and then paste in the template.

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

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors Learning all versions