SAP Knowledge Base Article - Public

2785274 - Answer column returns date value in the Item Evaluation By Individual Response (CSV) report

Symptom

  • The answer column on the Item Evaluation CSV and the Item Evaluation By Individual Response (CSV) report is not showing the correct values.
  • The output is expected to show <user rating> - <max rating>, but instead it is showing a date value.

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. References > System Administration > Rating Scales >

2. Add New > Create your Rating Scale ID with the below format >

ratinglabel.png

3. Associate your rating scale to a survey, then associate your survey to an item >

4. Have users completing the survey, then run the Item Evaluation By Individual Response (CSV) report, for example > Notice the answer column showing a date value >

kba csv results.png

5. Expected results: The value should be <user rating> - <max rating>.

kba expected results.png

Cause

When the report is opened with MS Excel, after downloading it from Learning reports, it detects the value and auto formats it to a date. E.g.: Instead of 1 - 1, it becomes January 1st.

Resolution

  1. When running the csv report, open and save it as a .txt file >

kba open with notepad.png

  1. Notice that when you open the file in a Notepad, the value is showing correctly >

kba notepad.png

  1. Once you have it saved as a .txt file, open with MS Excel >
  2. On the menu, go to Data > Get Data > From File > From TXT/CSV > Select the file >

kba excel.png

  1. Make sure that the delimiter is comma > Save the file as xlsx.

kba excel2.png

Keywords

lms, learning, item, evaluation, by, individual, response, csv, item, report, rating, scale, LRN-53986, answer, column value, excel , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-EVA , Surveys , Problem

Product

SAP SuccessFactors Learning all versions