Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

vbscript and going through xml documents

Posted on 2004-09-07
4
Medium Priority
?
279 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 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
Loops Section Overview
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

564 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