SAP Knowledge Base Article - Public

2462923 - How to download Group Member List report with special characters in SAP Jam

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

  1. Login to SAP Jam
  2. Go to a Jam group
  3. From the Overview dropdown, select Reports
  4. Select Group Member List report
  5. 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

Product

SAP Jam Collaboration all versions