Which IIQ version are you inquiring about?
8.2
When Exporting a Report results to CSV the names like “João” or “Tomás” the letters ã and á transforms into strange characters like “João”
How to prevent this ?
Thank you
Hi @RIsidoro,
try to add -Dfile.encoding=utf-8 to JAVA_OPTS and restart the tomcat
Hello
Tried that and didnt work, when downloading its the same
Hi @RIsidoro ,
Have you tried adding -Djava.locale.providers=COMPAT to the JAVA_OPTS parameter?
Also, are you opening the CSV file in Excel or a text editor?
Hello all still didnt work.
I am using excel.
The only workaround i found is to
"Click on Data Menu → Get Data → From File → From Text/CSV → Select the File → In the file Origin, Select Unicode (UTF-8) → Load the data. "
I have had the same experience.
This is an issue with Excel. Excel does not recognize the exported file to be UTF-8, unless a BOM (Byte Order Mark) character is inserted at the beginning of the CSV file.
You can open the CSV file with Notepad++ and then choose Encoding → UTF-8 BOM from the menu, then Save. This will insert the BOM character into the CSV file.
If you then open the CSV file with Excel, the diacritics will display correctly.
Thank you all !
I seems the only solution is to "Click on Data Menu → Get Data → From File → From Text/CSV → Select the File → In the file Origin, Select Unicode (UTF-8) → Load the data. "
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.