Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Error reading certain lines of an XML

Posted on 2009-05-06
12
Medium Priority
?
197 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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
 

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 1000 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

636 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