Status SR-A101230/FDBK-16900
Hi,
May I ask about the case status of SR-A101230/FDBK-16900?
I have been reading on this issue https://collaborate.pega.com/discussion/csv-export-import-function-japanese-excel and it seems we currently experience the same issue in Pega Platform 8.6.2, so the solution of these cases might be helpful to us.
Thanks and best regards!
Updated: 15 Jun 2022 5:05 EDT
Pegasystems Inc.
GB
@LilyH043 I have checked and the enhancement is still open.
----> Could you provide a specific use case and configuration used in your example?
Note that this is an expected behavior and is a 3rd party issue with csv file.
This we can confirm by the following - If you open the downloaded CSV in Notepad++(UTF-8 supported editor), data appears with japanese characters.
The following links also talks regarding the same.
https://superuser.com/questions/871189/excel-export-csv-file-with-japanese-character
The reason for this is if the CSV is opened using Excel, excel adds special characters to it. This is not within Pega's control.
As a workaround for it we have to follow the below steps -
Use notepad++ to correctly set the encoding and character set. (also check the File Encoding of the CSV file. If it's not UTF-8, please change the file encoding to UTF-8 and try to import it. Ref : https://community.pega.com/video-library/support-guide-how-troubleshoot-special-characters-during-csv-file-import)
@LilyH043 I have checked and the enhancement is still open.
----> Could you provide a specific use case and configuration used in your example?
Note that this is an expected behavior and is a 3rd party issue with csv file.
This we can confirm by the following - If you open the downloaded CSV in Notepad++(UTF-8 supported editor), data appears with japanese characters.
The following links also talks regarding the same.
https://superuser.com/questions/871189/excel-export-csv-file-with-japanese-character
The reason for this is if the CSV is opened using Excel, excel adds special characters to it. This is not within Pega's control.
As a workaround for it we have to follow the below steps -
Use notepad++ to correctly set the encoding and character set. (also check the File Encoding of the CSV file. If it's not UTF-8, please change the file encoding to UTF-8 and try to import it. Ref : https://community.pega.com/video-library/support-guide-how-troubleshoot-special-characters-during-csv-file-import)
Open the excel file -> go to data tab and select 'From Text/CSV' select the file and click on import
Can you confirm that you have already found the workarounds in support article Chinese characters export as junk characters on exporting data and in question changing file encoding from MS932 to UTF-8?
The FDBK item relates to the following:
CSV export & import function for Japanese with Excel
Many of Japanese customers want to use Excel for CSV import & Export.
However, CSV import & export's character code is UTF-8.
Saving file in Excel with Japanese character will generate a CSV file with Shift-JIS, so we are not able to import file by using "pxUploadCSVResults" for import and " ConvertResultsToCSV " for export.
request is: 1. to have parameters or something else to specify import character code for "pxUploadCSVResults" 2. to have parameters or something else to specify with BOM or without BOM for "ConvertResultsToCSV " (note that a workaround writing the BOM for this was provided in the post)
I will check internally to see if an SME can comment further.