PDA

View Full Version : Loop over a generic XML file


Too_Tall_Crown_Victoria
07-23-2007, 04:30 PM
I have an xml file that I need to loop over. The xml.bld example shows how to loop on attributes of a node. I need to loop on the contents of sub nodes. For example:

<dependencies>
<component>
<name>ProjA</name>
<version>1.2.3</version>
</component>
<component>
<name>ProjB</name>
<version>2.3.4</version>
</component>
</dependencies>

Is there a simple way to set this up and loop on each component and retrieve it's cooresponding version number?

Thanks

Tom

kinook
07-23-2007, 05:32 PM
Attached.

Too_Tall_Crown_Victoria
10-26-2007, 09:22 AM
I have an additional challenge with this:

If we assume:

<dependencies>
<component>
<name>ProjA</name>
<version>1.2.3</version>
</component>
<component>
<name>ProjB</name>
<version>2.3.4</version>
<file_name>myfile.dll</file_name>
<file_name>myfile2.dll</file_name>
<file_name>myexe.exe</file_name>
</component>
</dependencies>

We now have a need to have an optional <file_name> node. However when I use the selectsinglenode and a node is not there the vbscript errors out.

So how can I check to see if a node exists, and if it does how can I loop on it in this format.

Thanks in advance. Please ignore previous reply.

kinook
10-26-2007, 11:10 AM
See attachment.

Too_Tall_Crown_Victoria
11-01-2007, 11:35 AM
The script worked great for looping and reading the multi node that may or may not exist.

What I need now is to take this list and write it to a macro. I need this in a macro because I need to loop on each of these elements later in the script. How can I accomplish this?

kinook
11-01-2007, 02:15 PM
Attached.