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 >
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 >
5. Expected results: The value should be <user rating> - <max rating>.
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
- When running the csv report, open and save it as a .txt file >
- Notice that when you open the file in a Notepad, the value is showing correctly >
- Once you have it saved as a .txt file, open with MS Excel >
- On the menu, go to Data > Get Data > From File > From TXT/CSV > Select the file >
- Make sure that the delimiter is comma > Save the file as xlsx.
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