Problems with accented words exporting csv

(1) Share

Report

Posted on by Jesús García

580

Hi all, I am having problems exporting a set of data to a csv file. Those words that contain accents are being exported incorrectly.

here is a sample of the main code I use to configure the export. Thanks for your help!

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (0)

All responses (6)

Answers (1)

Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

Which encoding do you want to use? UTF-8?

Please forget Excel for now. Your code generates a text file, therefore use a text editor (such as Notepad++) to check the result. Verify that you're using the right encoding when interpreting the data (in Notepad++, use the Encoding menu).

Was this reply helpful? Yes No
Jesús García 580 on at

Like (0)

Report

Hi, I want to use UTF-8 or UTF-8 BOM encoding, and i think that i am using ANSI by default so, how can i change it?

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

The code page can be set as a parameter of CommaTextStreamIo::constructForWrite(). If you open code of CommaTextStreamIo class, you'll see that the default code page there is UTF-16LE.

Was this reply helpful? Yes No
Jesús García 580 on at

Like (0)

Report

Well, i tried to open csv in Notepad and encoding with UTF8 and accent problems are fixed, but its weird because i set the code to encoding the info with ut8 and i have the same problem:

By the way, the language i am using in this headers are spanish

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

If you're saying that it's correct if interpret the file is as UTF-8 text, then the data is correct, isn't it? The problem appears when you open the CSV in a table processor; it's apparently using a different encoding. If you're using Excel, use Data > From Text/CSV and then select the right encoding in the File Origin field.

Was this reply helpful? Yes No
Jesús García 580 on at

Like (0)

Report

Okey the code was correct, all this time the problem was Excel config. Thank you!

Was this reply helpful? Yes No