SAP Knowledge Base Article - Public

2286384 - Report exported as CSV is displaying wrong/special characters on translated fields - Adhoc/ORD

Symptom

  • Adhoc Report exported as CSV file with Excel Special characters not displaying correctly.
  • Adhoc report not showing language translations correctly

Environment

  • SAP SuccessFactors Workforce Analytics
  • Adhoc
  • ORD Online Report Designer

Reproducing the Issue

  1. Run adhoc report (with field containing with special character) online or offline;
  2. Export file as csv;
  3. Open the file with Excel;
  4. Result display wrong character.  E.g. "Operateur de production" is displayed "Opérateur de Production".

Cause

This is a limitation of the Excel tool when opening CSV file. If the information is appearing correctly on the instance (running online) it is not an issue with the translation.

Resolution

  • It is required to Export the file as Excel XLS or XLSX or use the version online.
  • It is also possible to open the CSV file with Notepad ++.

Keywords

Adhoc - ORD - Translation - CSV - Special characters - Wrong characters , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors Workforce Analytics all versions