Article - CS255971
CSV file created from ThingWorx Data Export widget displays random characters when opened from Microsoft Excel
Modified: 18-Oct-2024
Applies To
- ThingWorx Platform 6.6 to 9.4
Description
- When opening CSV File downloaded from ThingWorx Data Export widget with Excel, accented or non-latin characters are displayed as gibberish
- It is fine to open the CSV file by using NotePad++, however, it shows as gibberish when opening it with Microsoft Excel
- Invalid or garbled characters are displayed when opening a CSV file generated from Data Export Widget in Excel
- French, Japanese or Chinese characters replaced by "?" in export file but appear as expected in Composer
- Exports containing invalid characters fail to import with following errors in ThingworxStorage/Applicationlog.log:
- Error: com.thingworx.common.exceptions.InvalidRequestException: Invalid Name: [Auto_D?licat_40]
This is a printer-friendly version of Article 255971 and may be out of date. For the latest version click CS255971