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

SAP Knowledge Base Article - Public

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

Symptom

1. In 'Group member list' report, the language with multi-byte characters are broken when dowloaded.

2. 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: Report

Reproducing the Issue

1. Login to SAP Jam

2. Go to a Jam group

3. Click on Report

4. Download the Group Member List report

5. By default CSV file is downloaded, however the language in special characters will be broken.

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 , SAP Jam , Problem

Product

SAP Jam Collaboration all versions