XML, XSLT and XPATH

XML, XSLT and XPATH RSS

Help with getting info from a poorly structured XML Tree using XSLT

•

Join Date: Mar 2008

Posts: 78

Reputation: rickya100 is an unknown quantity at this point

Solved Threads: 1

rickya100

Offline

Junior Poster in Training

Help with getting info from a poorly structured XML Tree using XSLT

Nov 28th, 2008

Hi,

I have been trying to get resorts from an XML tree but I have found that it seems to be very flat and not helpful at all in terms of targeting information.

Attribute names are all the same whether it is the world element, region of world element, country element, region of country element or a resort in a region element.

Here is a section of it. I need to find out the Resorts per country region.

 Help with Code Tags 
 XML Syntax (Toggle Plain Text) 
<Child AccommodationCount="12" >
<Resort ResortId="2472"  ResortName="Andorra"  CountryCode="AD" ></Resort>
<Child>
<Resort ResortId="3961"  ResortName="Canillo"  CountryCode="AD" ></Resort>
<Child AccommodationCount="52" >
<Resort ResortId="1720"  ResortName="Soldeu"  CountryCode="AD" ></Resort>
</Child>
<Child AccommodationCount="36" >
<Resort ResortId="2476"  ResortName="Pas de la Casa"  CountryCode="AD" ></Resort>
</Child>
</Child>
<Child AccommodationCount="1" >
<Resort ResortId="3962"  ResortName="La Massana"  CountryCode="AD" ></Resort>
<Child>
<Resort ResortId="16120"  ResortName="Pal-Arinsal"  CountryCode="AD" ></Resort>
<Child AccommodationCount="40" >
<Resort ResortId="1722"  ResortName="Arinsal"  CountryCode="AD" ></Resort>
</Child>
</Child>
</Child>
</Child>
<Child AccommodationCount="12" >
<Resort ResortId="2472"  ResortName="Andorra"  CountryCode="AD" ></Resort>
<Child>
<Resort ResortId="3961"  ResortName="Canillo"  CountryCode="AD" ></Resort>
<Child AccommodationCount="52" >
<Resort ResortId="1720"  ResortName="Soldeu"  CountryCode="AD" ></Resort>
</Child>
<Child AccommodationCount="36" >
<Resort ResortId="2476"  ResortName="Pas de la Casa"  CountryCode="AD" ></Resort>
</Child>
</Child>
<Child AccommodationCount="1" >
<Resort ResortId="3962"  ResortName="La Massana"  CountryCode="AD" ></Resort>
<Child>
<Resort ResortId="16120"  ResortName="Pal-Arinsal"  CountryCode="AD" ></Resort>
<Child AccommodationCount="40" >
<Resort ResortId="1722"  ResortName="Arinsal"  CountryCode="AD" ></Resort>
</Child>
</Child>
</Child>
</Child>

Can anyone help me with the XPath required to target this. I have worked on this for days and cannot pull it off.

If anyone knows the fix please post it up or even a quick tip in the right direction.

Many thanks

Last edited by rickya100; Nov 28th, 2008 at 10:14 am. Reason: Spelling mistake