asked on

populating a node list

Help Please.
Hello XML'ers
I am pulling my hair out trying to figure out how to populate a NodeList object with all the YEARS from this following xml document.
I will pass the sFile variable to the object
I want all the "Survey year" nodes from the Structure Name

This is the VBA routine that i have. I am already loaded the XML file
Dim oYearNodeList As MSXML2.IXMLDOMNodeList
Dim sfile As String 'FileSystemObject

myXML.validateOnParse = False

sfile = ActiveDesignFile.Name
Set myXElem = myXML.documentElement

On Error GoTo BADTHINGS
Set oYearNodeList = myXML.selectNodes("Bridge_Scour/Structure[@Name='" & sfile & "']/Surveys[@year= " * "]

Debug.Print "how"
BADTHINGS:
MsgBox Error
End Sub

<?xml version="1.0"?>
<!DOCTYPE Bridge_Scour SYSTEM "Bridge_Scour.dtd">
<Bridge_Scour>
<Structure Name = "uw1.dgn">
<Surveys year="2000">
<Survey>
<Entry><Station>0</Station> <Elevation>926.7</Elevation></Entry>
<Entry><Station>17</Station> <Elevation>925.1</Elevation></Entry>
<Entry><Station>32</Station> <Elevation>922.7</Elevation></Entry>
<Entry><Station>47</Station> <Elevation>916.7</Elevation></Entry>
<Entry><Station>62</Station> <Elevation>911.6</Elevation></Entry>
<Entry><Station>100</Station> <Elevation>909.8</Elevation></Entry>
</Survey>
</Surveys>
<Surveys year="2001">
<Survey>
<Entry><Station>0.3</Station> <Elevation>123.47</Elevation></Entry>
<Entry><Station>0.4</Station> <Elevation>123.48</Elevation></Entry>
</Survey>
</Surveys>
</Structure>
<Structure Name = "uw2.dgn">
<Surveys year="2001">
<Survey>
<Entry><Station>0.5</Station> <Elevation>123.49</Elevation></Entry>
<Entry><Station>0.6</Station> <Elevation>123.50</Elevation></Entry>
</Survey>
</Surveys>
</Structure>
</Bridge_Scour>

PLEASE HELP..

Thanks so much
If i could give a thousand points i would.

ASKER CERTIFIED SOLUTION

Pierre Cornelius

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sherrick123

ASKER

I have been able to get all the years BUT i want just the years for a certain structure WITHOUT going through a looping routine. Their will be lots of years and i am concerned with processing time

SOLUTION

Carl Tawn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Gertone (Geert Bormans)

Hi sherrick123,
> Set oYearNodeList = myXML.selectNodes("Bridge_Scour/Structure[@Name='"
> & sfile & "']/Surveys[@year= " * "]

since we don't sem to get there the preceding-sibling way...

you can't use the '*' as a wildcard in XPath
just leaving that part out will give you all the surveys/@year

Set oYearNodeList = myXML.selectNodes("Bridge_Scour/Structure[@Name='" & sfile & "']/Surveys/@year")

will give you a list of years, not necessarily unique
you can then create an array of unique values from this nodeset
by looping over the nodeset and creatin a new item on the other array, if the value does not yet exist

I am still wondering why we can't get the preceding-sibling to work though...

Cheers!

Gertone (Geert Bormans)

sherrick123,

oh man I am late....
ignore my previous message
(and after that this one as well :-)