csv generation :improper data created

0
hi everyone, I am importing a xslx file and storing the data in mendix entity temporary and exporting it in csv file but the data that is generated in csv is not correct. The imported data is in Russian language and output data contains special symbols and other random text.What could be the cause of it.Here is the example of input and output data. And how do I correct this? Input data in xslx file   Data in mendix: Output data in csv file
asked
1 answers
0

Does the CSV output look correct if you load it into a text editor like VS Code?

 

If it does, then I think the problem is with your spreadsheet software not understanding the UTF-8 output from Mendix.

 

If this is Excel, the issue could be that it expects a BOM in the file. There is a workaround documented here.

https://support.microsoft.com/en-gb/office/opening-csv-utf-8-files-correctly-in-excel-8a935af5-3416-4edd-ba7e-3dfd2bc4a032

 

I hope this helps.

answered