How do I read all tags of a XML file

Question

0.00/5 (No votes)

See more:

I have a console program that reads a XML File and prints some selected value in the console. When i run the program i get an exception Inner Exception 1:
InvalidOperationException: <export_header xmlns="http://www.siriusfs.com/SFI/Export/GL_Export/20051005"> was not expected. for the header tag in the file. HResult=0x80131509
Message=There is an error in XML document (2, 2).
Source=System.Xml

My generated class looks as follows :

C#

[XmlRoot(ElementName = "TRANSACTION")]
   public class TRANSACTION
    {

  public string Correspondence_country { get; set; }
        [XmlAttribute(AttributeName = "term")]
        public string Term { get; set; }
    [XmlAttribute(AttributeName = "mediatype_code")]
        public string mediatype_code { get; set; }
    }

     [XmlRoot(ElementName = "ContractData")]
    public class ContractData
    {
        [XmlElement(ElementName = "TRANSACTION")]
        public List<TRANSACTION> TRANSACTION { get; set; }
    }

Program.cs

C#

static void Main(string[] args)
        {
            Console.WriteLine("\n" + "Reading BidAskCurves XML File");
            Console.WriteLine("===========================================================");
                     
            //get filename        
            string fileName = @"C:\Users\tshumae\Documents\MyProjects\SSPPureSunSystems\Files\GLExport58oct.xml";          
            string path = @"C:\Users\tshumae\Documents\MyProjects\SSPPureSunSystems\Files\";
            string result;
            result = Path.GetFileName(fileName);

            // Create an instance of the XmlSerializer.
            XmlSerializer serializer = new XmlSerializer(typeof(ContractData));

            // Declare an object variable of the type to be deserialized.
            ContractData item;

            using (XmlReader reader = XmlReader.Create(fileName))
            {
                // Call the Deserialize method to restore the object's state.
                item = (ContractData)serializer.Deserialize(reader);

                //Write out the properties of the object. (Visual Only, not needed)
                Console.Write(
                    item.TRANSACTION[0].Term + "\t" +
                    item.TRANSACTION[0].mediatype_code + "\t" );
                   
            }

And the XML schema as as below :

XML

	<?xml version="1.0" encoding="utf-16"?>
<EXPORT_HEADER xmlns="http://www.siriusfs.com/SFI/Export/GL_Export/20051005" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.siriusfs.com/SFI/Export/GL_Export/20051005  GL_EXPORT.xsd" date_exported="2019-11-04T08:33:22.697" interface_name="GL_EXPORT" batch_id="212" batch_reference="GLX212" total_transactions="6109" total_amount="0.0000">
<TRANSACTION  mediatype_code="Zimbabwe" term="NB" />
  </TRANSACTION>
  </EXPORT_HEADER>

Any insight on what i might be doing wrong. Ideally the program should print all values.

What I have tried:

I have tried to decorate my root entity with the XmlRoot attribute . The program runs fine but only 1 value of the first row , first column is printed to the console :

C#

[XmlRoot(ElementName = "TRANSACTION")]
   public class TRANSACTION
    {

  public string Term { get; set; }
        [XmlAttribute(AttributeName = "term")]
        public string Term { get; set; }
    [XmlAttribute(AttributeName = "mediatype_code")]
        public string mediatype_code { get; set; }
    }

      [XmlRoot(Namespace = "http://www.siriusfs.com/SFI/Export/GL_Export/20051005", ElementName = "EXPORT_HEADER", DataType = "string", IsNullable = true)]
    // [XmlRoot(ElementName = "ContractData")]
//[XmlRoot(ElementName = "ContractData")]
    public class ContractData
    {
        [XmlElement(ElementName = "TRANSACTION")]
        public List<TRANSACTION> TRANSACTION { get; set; }
    }

Posted 16-Dec-19 4:16am

Tshumore

Updated 17-Dec-19 9:24am

Add a Solution

2 solutions

Solution 1

Put a try/catch block around your code so you can see where the exception is being thrown. BTW, it's an Invalid Operation exception.

Posted 16-Dec-19 4:48am

#realJSOP

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2019-12-17T09:25:00

There's a syntax error in your XML: the <TRANSACTION> element is self-closing, but it also has a closing tag.

Quote:
The 'EXPORT_HEADER' start tag on line 2 position 2 does not match the end tag of 'TRANSACTION'. Line 4, position 5.

Once that's fixed, your "What I have tried" code works to deserialize the XML correctly. You don't need the DataType and IsNullable attributes on the ContractData's XmlRoot attribute, and you don't need the XmlRoot attribute on the TRANSACTION class; but they don't affect the deserialization.

You're only seeing one value written to the console because there is only one value in your XML, and because you're only displaying the first value. If you want to display all values, you'll need to use a loop.

C#

item = (ContractData)serializer.Deserialize(reader);

foreach (TRANSACTION transaction in item.TRANSACTION)
{
    Console.Write("{0}\t{1}\t", transaction.Term, transaction.mediatype_code);
}