Solved

Error reading certain lines of an XML

Posted on 2009-05-06
12
189 Views
Last Modified: 2013-11-26
I am having an issue reading a node from certain XML files. Below is the code I use to read most XML files that my app needs. However this code seems to have an issue reading a certain file. I believe it is because of:
<statuses type="array">

Is there a way to read this XML file?
Dim xml As Object

        Dim XMLDoc As New XmlDocument

        Dim nodeList As XmlNodeList

        Dim node As XmlNode
 

        XMLDoc.Load("c:\temp\update.xml")
 

        nodeList = XMLDoc.SelectSingleNode("/status/user").ChildNodes

        For i As Integer = 0 To nodeList.Count - 2 Step 2

            node = nodeList(i)

            Dim user As String = node.InnerText

            MessageBox.show(user)

        Next
 

'Reads this XML:
 

<?xml version="1.0" encoding="UTF-8"?>

<status>

 <user>Testing</user>

</status>
 

'However the code below will not read the XML below.
 

        Dim xml As Object

        Dim XMLDoc As New XmlDocument

        Dim nodeList As XmlNodeList

        Dim node As XmlNode
 

        XMLDoc.Load("c:\temp\times.xml")
 

        nodeList = XMLDoc.SelectSingleNode("statuses/status/text").ChildNodes

        For i As Integer = 0 To nodeList.Count - 2 Step 2

            node = nodeList(i)

            Dim text As String = node.InnerText

            MessageBox.show(text)

        Next
 

<?xml version="1.0" encoding="UTF-8"?>

<statuses type="array">

<status>

<text>Another Test</test>

</status>

</statuses>

Open in new window

0
Comment
Question by:zerogeek
  • 8
  • 4
12 Comments
 
LVL 8

Expert Comment

by:RyanAndres
ID: 24316748
Please include the xml data that is failing.
0
 

Author Comment

by:zerogeek
ID: 24316796
It is listed under the code I am using to read the XML:

<?xml version="1.0" encoding="UTF-8"?>
<statuses type="array">
<status>
<text>Another Test</test>
</status>
</statuses>

It doesn't fail. It runs thru the code but never shows the messagebox.
MessageBox.show(text)
0
 
LVL 8

Expert Comment

by:RyanAndres
ID: 24316852
Your nodes don't match..

<text>Another Test</test>

text and test. typo :]
0
 

Author Comment

by:zerogeek
ID: 24316903
Actually, I wrote that up really quick. It is an example of  the XML I am using.
0
 

Author Comment

by:zerogeek
ID: 24316925
I believe it has something to do with the code that reads the XML file. It seems to be getting hung up on the <statuses type="array"> and either skipping the entire XML or not getting deep enough into the nodes to read the innerText of <text>Another Test</text>
0
 
LVL 8

Expert Comment

by:RyanAndres
ID: 24317133
The problem was your for loop.

The SelectSingleNode found the xpath just fine.

See below for changes.
Dim xml As Object = Nothing

Dim XMLDoc As New XmlDocument()

Dim nodeList As XmlNodeList

Dim node As XmlNode
 

XMLDoc.Load("file.txt")
 

nodeList = XMLDoc.SelectSingleNode("statuses/status/text").ChildNodes

For i As Integer = 0 To nodeList.Count - 1

    node = nodeList(i)

    Dim text As String = node.InnerText

    MessageBox.show(text)

Next

Open in new window

0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:zerogeek
ID: 24317256
That seems to be working. Is there a way to make this grab up to 10 more from the file? Example of XML below
<?xml version="1.0" encoding="UTF-8"?>

<statuses type="array">

<status>

<text>Testing</text>

</status>

<status>

<text>Number 2</text>

</status>

<status>

<text>And so on...</text>

</status>

Open in new window

0
 

Author Comment

by:zerogeek
ID: 24317273
Their are multiple <status> tags in 1 XML file between the <statuses type="array"> and </statuses> tags
0
 
LVL 8

Accepted Solution

by:
RyanAndres earned 250 total points
ID: 24317310

Dim XMLDoc As New XmlDocument()

Dim nodeList As XmlNodeList
 

XMLDoc.Load("file.txt")

nodeList = XMLDoc.SelectNodes("statuses/status/text")
 

For Each node As XmlNode In nodeList

    Dim text As String = node.InnerText

Next

Open in new window

0
 

Author Comment

by:zerogeek
ID: 24317371
That did not work. It still only grabs the text from the first tag.
0
 

Author Comment

by:zerogeek
ID: 24317419
Nevermind. I didn't notice the change from XMLDoc.SelectSingleNode to SelectNodes

Thanks for all your help. :)
0
 

Author Closing Comment

by:zerogeek
ID: 31578522
Great help in a short amount of time. Much appreciated.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This video discusses moving either the default database or any database to a new volume.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now