Microsoft Dynamics AX (Archived)

'Invalid character' in data export to Excel

(0) Share

Report

Posted on by Taraka rama prasad ...

Hi,

when i export data to excel error came.

An error occurred consider contacting your system administrator about this problem

Hexadecimal value 0x15, is an invalid character.

Please help me.

Regards,

Tarak

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Tarak,

Did you simply exporting some AX data by selecting CTRL+T or did you make use of the AIF and an Excel template?

What data did you try to export?

Best regards,

Ludwig

Was this reply helpful? Yes No
Taraka rama prasad ... 54 on at

Like (0)

Report

Hi Ludwig,

i am exporting AX data like release products, counting journal line and select by CTRL+T.

Regards,

Tarak

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report

I would expect that it's a problem in your data, so you could identify the problematic record and remove the character in question.

Was this reply helpful? Yes No
Taraka rama prasad ... 54 on at

Like (0)

Report

Hi Martin,

Data is correct but in product name and product search name fields length modified 60 characters to 90 characters. when i hide those columns in AX form and export(CTRL+T) its working fine. i need to export product name also.

Regards,

Tarak

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report

You claim that the data is correct, but the rest of your reply suggests that you have a problem with data in either product name and product search field (or both).

Was this reply helpful? Yes No
Suggested answer

Zain Bokhari 3,208 Moderator on at

Like (1)

Report

Hi Taraka,

If you don't get the error by hiding those two columns. It suggests that the character causing this error is in one of these two columns in some record. Like Martin suggested you need to find that record with this character and correct it before you can export data.

Was this reply helpful? Yes No
Taraka rama prasad ... 54 on at

Like (0)

Report

Hi,

Issue was resolved. user enters special characters in Product name.

Thanks for valuable suggestions.

Regards,

Tarak

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

Like (1)

Report

Great! The only remaining thing is marking this thread as answered. Notice "Did this answer your question?" beside each reply, which are used to indicate which replies answer the question.

Was this reply helpful? Yes No