Symptom
The report 'Group member list' doesn't have option to download in other file format as it downloads the report automatically in csv file with broken characters if the language is not in English.
Environment
SAP Jam Collaboration
Reproducing the Issue
- Login to SAP Jam
- Go to a Jam group
- From the Overview dropdown, select Reports
- Select Group Member List report
- Click Request Report
Resolution
To properly use the content of CSV file with special character, please use Excel's "Text Import wizard" and make sure the "65001: Unicode (UTF-8)" is selected from the "File origin" options.
See https://support.office.com/en-us/article/Text-Import-Wizard-c5b02af6-fda1-4440-899f-f78bafe41857
Please try the following in the dialog:
- Choose "Delimited"
- Start import from row 2 if you see "sep=" in the preview. Otherwise start from row 1
- Select File Origin: "65001: Unicode (UTF-8)"
- Check "My data has headers"
- Next
- Pick Comma as the only delimiter
- Finish
Keywords
SAP Jam, Jam Group member list report, Jam reports , KBA , LOD-SF-JAM-REP , Reports , Problem