Problem in XML tag reading

(0) Share

Report

Posted on by Osama Anjum

530

I am having problem importing the XML file and the following error pops up:-
Error: The '[' character, hexadecimal value 0x5B, cannot be included in a name. Line 24, position 13.

Below is a part of the XML file.

<Txt>12345678</Txt> --Transaction Text
<Invoice>AXINV507005520</Invoice>
<Dimension[1]>XYZ</Dimension[1]>
<Dimension[2]> PQR</Dimension[2]>
<Dimension[3]>ABC</Dimension[3]>

The error is due to Dimension[] fields.

How to handle this situation?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (4)

Verified answer

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi Osama

What you are using for import the XML ?

About Dimension, the XML structure should be something like :

<Dimension>

<element>Department</element>

<element>Cost Center</element>

<element>Purpose</element>

</Dimension>

Take a look at msdn.microsoft.com/.../aa636469(v=ax.50).aspx

Was this reply helpful? Yes No
Verified answer

Hariharans87 3 on at

Like (0)

Report

Yes. There is a problem on the Dimension[] field. Xml read function can't read this node.

Please try to change the xml file dimension node or handle by program.

Please read the xml content in the text file read concept and replace the node text from "Dimension[1]" to Dimension1 and create the temp xml file with updated content.

Read the newly created temporary xml file.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi!!

You can create first the String XML and later create XML document

XmlDocument _XML = new XmlDocument();

_XML .loadXml(XMLText);

_XML .save(\\\\Server\\Folder\\DOCXML.XML);

Was this reply helpful? Yes No
Verified answer

Osama Anjum 530 on at

Like (0)

Report

Thank you everyone, I changed Dimension[1] to Dimension1 and things worked.

Was this reply helpful? Yes No