2622008 - National ID missing the last three digits if the report is being exported in .CSV format

• National ID missing the last three digits if the report is being exported in .CSV format
• Any field with more that 15 digits gets rounded off while exporting in .CSV format
• .CSV formats exports give scientific notation for long number fields

SuccessFactors BizX

Online report designer

Create a report using national Id field (only numbers if applicable) and try exporting the same in .CSV format
Any numerical field that holds more than 15 digits as well can be used.

.CSV format treats the columns by default in number format and hence it rounds it off in scientific notation if the length exceeds 15 digits.

This is an expected behaviour and the advisable format to export such data is .xlsx
This is a limitation with the file format itself and SuccessFactors has no control over it

https://en.wikipedia.org/wiki/CSV_application_support

http://answers.google.com/answers/threadview/id/455565.html

https://stackoverflow.com/questions/27801193/how-to-prevent-excel-from-truncating-numbers-in-a-csv-file

scientific notation, truncated number, wrong format, round off number, export to csv for number fields, lengthy numbers, national id, CSV, E+ , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem