Symptom
When exporting a Learning report to .csv, the leading 0s on IDs are missing when opened in MS Excel
Environment
SAP SuccessFactors Learning Management System (LMS)
Reproducing the Issue
- The LMS has Item IDs, User IDs, etc that are numeric only
- Logon to LMS as a user that can run reports
- Run a report that returns the numeric IDs and outputs to CSV
- Open the CSV in MS Excel
- Note that the leading 0s are removed
Cause
- This is the expected behavior of Microsoft Excel and is a 3rd party issue
- The 0s are being exported by the LMS Reporting Service
Resolution
- View the .csv export in a text editor such as Notepad and the 0s are visible
- To preserve the leading 0s when viewing the CSV in MS Excel, prior to saving, format the column containing the IDs to be Text
- Refer to the Microsoft support for additional assistance if needed
Keywords
SF SuccessFactors Learning LMS leading begin 0 zero trim missing remove gone incorrect wrong ID User Item export csv comma delimited Excel , KBA , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , Problem
Product
SAP SuccessFactors HCM Core 1711