Solved

Loop through XML file and read nodes

Posted on 2008-10-16
4
956 Views
Last Modified: 2012-05-05
need to loop through and XML file, and grab node vales ...

<users>
<user>
<name>Joe</name>
<oldfolderlocation> C:\oldfolder\ Joe </oldfolderlocation>
<newfolderlocation> C:\newfolder\ Joe </ newfolderlocation >
</ user >
< user >
<name>Tom</name>
<oldfolderlocation> C:\oldfolder\ Tom </oldfolderlocation>
<newfolderlocation> C:\newfolder\ Tom </ newfolderlocation >
</user>

</users>

Dim userNodes As XmlNodeList = doc.SelectNodes("people/ person")
 For Each userNodesNode As XmlNode In userNodes
My.Computer.FileSystem.CopyDirectory(userNodesNode("newfolderlocation ").InnerText, userNodesNode("oldfolderlocation").InnerText, False)

     Next
0
Comment
Question by:gvilla23
[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
  • 2
4 Comments
 
LVL 8

Expert Comment

by:rlh68
ID: 22737303

Not sure if it's ee or you xml but, make sure your xml doesn't have spaces in the elements tags, some of them did when I copied your xml to my code. The xmlDocument object may give you errors if your xml is not well formed.

i.e. this
 < user >
should be this
<user>
        Dim xDoc As New Xml.XmlDocument
        Dim xml As String
 
        xml = "<users><user><name>Joe</name><oldfolderlocation>C:\oldfolder\Joe</oldfolderlocation>" & _
           "<newfolderlocation>C:\newfolder\Joe</newfolderlocation></user><user><name>Tom</name>" & _
             "<oldfolderlocation>C:\oldfolder\Tom</oldfolderlocation><newfolderlocation>C:\newfolder\Tom</newfolderlocation></user></users>"
 
        xDoc.LoadXml(xml)
 
        Dim nl As Xml.XmlNodeList
        ' fill node list with users node
 
        nl = xDoc.GetElementsByTagName("users")
        ' loop each users
        For Each nUser As Xml.XmlNode In nl
            '' check for snippetIndex value we want to match
            'If n.SelectSingleNode("snippetIndex").InnerText = "0" Then
            '    ' show snippetName
            '    MessageBox.Show(n.SelectSingleNode("snippetName").InnerText)
            'End If
 
            Dim nName As Xml.XmlNode = nUser.SelectSingleNode("user/name")
            Dim nNewFolderLoc As Xml.XmlNode = nUser.SelectSingleNode("user/newfolderlocation")
            Dim nOldFolderLoc As Xml.XmlNode = nUser.SelectSingleNode("user/oldfolderlocation")
 
            MessageBox.Show(nName.InnerText & " | " & nNewFolderLoc.InnerText & " | " & nOldFolderLoc.InnerText)
 
        Next

Open in new window

0
 
LVL 8

Expert Comment

by:rlh68
ID: 22737309

oops, disregard the commented out code, it was from the original code that I used to write your example. I meant to delete it but forgot to.

Garbage code:
            '' check for snippetIndex value we want to match
            'If n.SelectSingleNode("snippetIndex").InnerText = "0" Then
            '    ' show snippetName
            '    MessageBox.Show(n.SelectSingleNode("snippetName").InnerText)
            'End If
0
 
LVL 19

Accepted Solution

by:
drichards earned 50 total points
ID: 22737983
If you are using the XML document for other purposes or if the document is small, the XmlDocument solution is fine.  If the document is large or performance is a concern then you will be better served by an XmlReader.

There are a number of approaches you could take with a reader, and I have included one here.  It's reasonably robust against XML comments and element whitespace.  It advances to each user node and then reads the name, oldfolderlocation, and newfolderlocation text elements.
        Dim rdr As XmlReader = XmlReader.Create(<xml file or stream>)
        While rdr.ReadToFollowing("user")
            rdr.ReadToFollowing("name")
            rdr.Read()
            Dim name As String = rdr.Value
            rdr.ReadToFollowing("oldfolderlocation")
            rdr.Read()
            Dim oldFolder As String = rdr.Value().Trim()
            rdr.ReadToFollowing("newfolderlocation")
            rdr.Read()
            Dim newFolder As String = rdr.Value().Trim()
            ' Do Copy here...
        End While

Open in new window

0
 

Author Closing Comment

by:gvilla23
ID: 31506981
Thank you very much for the explanation.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

632 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