Solved

vbscript and going through xml documents

Posted on 2004-09-07
4
274 Views
Last Modified: 2008-03-10
Hello,

I have an xml document that I would like to step through part of it and then search the rest of the document.
Overall layout is:
<profile>
  <network_drives>
    <network drive id="0" drive_letter="z:" drive_path="\\servername\share">
<network drive id="1" drive_letter="z:" drive_path="\\servername\share">
     there are a few more network drive elements exactly the same but different mappings
     </network_drives>
    <recent_documents>
     <recent_document id="2" document_name="blah" document_path="c:\desktop\folder1">
        <recent_document id="3" document_name="blah2.doc" document_path="c:\desktop\folder1">
      there are many recent documents if it matters all the id #'s are unique starting from 0 in network drives
     </recent_documents>
</profile>

Since there are few network drives I was trying to use
 set node = xmlDoc.selectSingleNode("\\network_drives\network_drive")
 but I got stuck because I did not know how to differentiate between the nodes within <network_drives> because they are all named network_drive but have different attributes. Also the command line spit out object required : 'node'

For the recent documents I basically want to do the same thing but I figure a loop would be better because there are far more entries. All I really care about is analyzing the path in the document and checking it against a variable.

Can anyone guide me in the correct way of using select single node and / or a loop to go through my xml document and get me the information i need?

Thanks in advance,
barry

0
Comment
Question by:barryk2
  • 3
4 Comments
 
LVL 26

Expert Comment

by:rdcpro
ID: 11999061
Well, you can use selectSingleNode on any node, so if you find a particular node you're interested in, you can use it for the basis of subsequent searches.  To refine the XPath for a particular network_drive node, use a predicate:

set node = xmlDoc.selectSingleNode("\\network_drives\network_drive[@drive_letter = 'z']")

or even drive_path="\\servername\share"

set node = xmlDoc.selectSingleNode("\\network_drives\network_drive[contains(@drive_path, 'sharedFolderName')]")

to use a variable in it:

folderName = "myFolder"

set node = xmlDoc.selectSingleNode("\\network_drives\network_drive[contains(@drive_path, '" & folderName & "')]")

Regards,
Mike Sharp
0
 

Author Comment

by:barryk2
ID: 11999106
when i past your top code I get an error:

msxml4.dll : Unexpected character in query stirng

-->\<--\network_drives\netowrk_drive[@drive_letter = 'z' ]

also to verify node got set could i just print it like this: WScript.Echo node.text?
0
 
LVL 26

Accepted Solution

by:
rdcpro earned 500 total points
ID: 11999546
Oops.  I copied your code, and modified it to show the predicate, but didn't notice the backslashes.  They need to be "/" not "\"

Regards,
Mike Sharp
0
 
LVL 26

Expert Comment

by:rdcpro
ID: 11999560
By the way, if you need to do something with a number of nodes, and they're all identified by the same XPath expression, you can use selectNodes() which returns a nodelist you can iterate over.

Regards,
Mike Sharp
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

820 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