How to export to CSV file in UTF-8 without BOM

(0) Share

Report

Posted on by Community Member

Dear all,

I try to export multi records to a CSV file in UTF-8 without BOM.

i used this code:

System.Text.Encoding encoding = new System.Text.UTF8Encoding(false);
;
System.IO.File::WriteAllText(@'C:\test.txt', "Data 123", encoding);

Is this right? And How can i export multi records with break line?

Please give me a advice. Thank you so much.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Mea_ 60,284 on at

Like (0)

Report
RE: How to export to CSV file in UTF-8 without BOM

Hi Hiep Nguyen,

You can use standard AX class commaTextIo to create CSV files, please refer to this blog post fro example

http://daxdilip.blogspot.co.nz/2011/08/commatextio-class-how-to-export-data-to.html

As you can see commaTextIo.write() is called in a loop to insert multiple records.

To set encoding you can use 3 parameter of commaTextIo constructor

commaTextIo = new CommaTextIo(fileitemdata,#io_write, 65001);

where 65001 is UTF-8

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to export to CSV file in UTF-8 without BOM

Thank you.

But it's only utf-8. I want to export CSV utf8 without BOM.

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report
RE: How to export to CSV file in UTF-8 without BOM

AX cannot create file without BOM, however, using you code you can resave it.

#File CommaTextIo commaTextIo; FileIOPermission permission; CustTable custTable; str fileName = @"c:\test.csv"; System.Text.Encoding encoding = new System.Text.UTF8Encoding(false); permission = new FileIOPermission(fileName,#io_write); permission.assert(); commaTextIo = new CommaTextIo(fileName,#io_write, 65001);
while select custTable { commaTextIo.write(custTable.AccountNum); } CodeAccessPermission::revertAssert(); commaTextIo = null; //save CSV without BOM new InteropPermission(InteropKind::ClrInterop).assert(); System.IO.File::WriteAllText(filename, System.IO.File::ReadAllText(filename), encoding); CodeAccessPermission::revertAssert();

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to export to CSV file in UTF-8 without BOM

Dear Ievgen Miroshnikov,

Thank you so much. I try your code and it run perfectly.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to export to CSV file in UTF-8 without BOM

Did anyone got this working in batch mode for AX 2012. I get below error in batch mode

“Can’t rewrite C:\Testing FOlder\Studio_Matrix.csv file without BOM”

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

Like (0)

Report

RE: How to export to CSV file in UTF-8 without BOM

Do you mean that WriteAllText() throws an exception? If so, what's the type and message? Isn't the file already open?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to export to CSV file in UTF-8 without BOM

The line "System.IO.File::WriteAllText(filename, System.IO.File::ReadAllText(filename), encoding);" doesn't seem to work in batch it throws error In batch resulting in the file is being saved with BOM. On client the WriteAll method rewrites the file without BOM.

Error message: “Can’t rewrite <C:\Testing FOlder\Studio_Matrix.csv> file without BOM”

I am I closing the file before it is rewritten

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
RE: How to export to CSV file in UTF-8 without BOM

Solution for this would be directly write the UTF-8 without BOM file using code where lobValue is a string data instead of trying to rewrite the file to convert to a file without BOM

System.IO.File::WriteAllText(textIoPathFileName,lobValue , encoding);

Was this reply helpful? Yes No
Suggested answer

sivakarthk 10 on at

Like (0)

Report

RE: How to export to CSV file in UTF-8 without BOM

Great!, solved.

Was this reply helpful? Yes No