search

SAP-samples / abap-alv-google-upload-sheet

Sample demonstrating export of ALV Grid data from SAP GUI directly to Google Drive and display exported data snapshots automatically in Google Sheets.
Apache License 2.0
35 stars 24 forks source link

French words converting into Special Characters while data upload using Google sheet API #13

Closed knvsg01 closed 2 years ago

knvsg01 commented 2 years ago

Hello Team,

We need your help in resolving the following issue. We are running a report in SAP and uploading the output in Google sheet folder using Google sheet API as mentioned in Github project. Some of the French words are converted into different special characters.

Please find the attached screenshot. If the data is in English it is showing correctly. If the data is in French ("Sécurité"), those are converted into special characters as "S��curit��".

SAPSM commented 2 years ago

Hi knvsg01,

You addressed the issue already via the SAP support, although this is a sample project without official maintenance pledge. Anyway, as also stated there. This looks like a typical encoding problem upon creating the data, that is then uploaded to Google Drive. The problem is to be found in the exporting step when encoding the data. When using the standard export measures, this problem won't arise.

Kind Regards, Sebastian

SAPSM commented 2 years ago

Closed as already handled on goodwill base in the official SAP maintenance channel. In a nutshell: Encoding problem in the exporting step beforehand the actual upload to Google Drive.