RE: New doubt !

Play the video

Subject: RE: New doubt !
From: "Aron Bock" <aronbock@xxxxxxxxxxx>
Date: Tue, 03 May 2005 05:18:16 +0000

Bharat, 2 people have answered to this by now, but I'm responding nonetheless because IMO those responses were either too involved or needlessly wordy.

You already know that external XML files may be accessed via the document() function. Thus, if you have an XSL file with document('lookups.xml') will access an XML file called 'lookups.xml' in the same folder as the XSL. Note that document('/') returns you the input XML document if you wanted that for some reason, and document('') returns the XSL document itself.

In every case, ceteris paribus, the document() function returns the root of the referenced document. You then navigate this simply by applying XPath expressions. For example, assume the lookup file is as follows:

lookups.xml
=======
<stores>
   <store name="Bangalore Central" ID="2345"/>
   <store name="Walmart" ID="4567"/>
</stores>

That your input XML file is as follows:
=======
<foo>
   <store>
       <RetailStoreName>Bangalore Central</RetailStoreName>
   </store
</foo>

And that you wanted to convert this to:
=======

<foo>
   <store>
       <name>Bamgalore Central</name>
       <id>2345>/id>
   </store>
</foo>

You'd create an XSL file with the usual trappings, then do this:

 <xsl:variable name="doc-lookups" select="document('lookups.xml')"/>

 <xsl:template match="store"> <store> <name><xsl:value-of select="RetailStoreName"/></name> <id><xsl:value-of select="$doc-lookups/stores/store[@name = RetailStoreName]/@name"/></id> </store> </xsl:template>

Regards,

--A

PS: Please try to use a more descriptive subjectline. "How do I traverse an external XML document?" would be more useful to people coming after you, than the one in this post.

From: Bharat Shetty <bharat.shetty@xxxxxxxxx>
Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject:  New doubt !
Date: Tue, 3 May 2005 08:29:11 +0530

Hi all,

I am glad I came across this group.

I need to transform a XML to other structure XML using XSLT.

Fine I have done that quite well according to my projects needs.

Now the problem is ....

When an input element of tag

<RetailStoreID>Bangalore Central</RetailStoreID> is encountered in the
input XML ( Please note that At this stage since this XML is genreated
from some transaction handling code, I will not know in advance what
store will appear in that tag . But eventually all of them are assumed
to be in some lookup table that i will explain now ) , my XSLT should
be able to refer to some other XML that stores in this format

Retail Store Name                      ID
===========================
Bangalore central                  2345
Walmart                               4567

like that ....

I tried using the document("reatilstoreids.xml") what to put in the
query after this is beating me ...

When Walmart is encountered i need to get 4567 and if Bangalore
central i shud get 2345 through some testing so that thats is
displayed in the Output XML . Just help me on how to get ids of the
names encountered in the input XML in this other XML called
RetailerStoreIDs.xml

_________________________________________________________________ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement

Current Thread
New doubt ! Bharat Shetty - 3 May 2005 02:59:32 -0000 Daniel Bibbens - 3 May 2005 04:40:28 -0000 Aron Bock - 3 May 2005 05:18:45 -0000 <= Bharat Shetty - 3 May 2005 06:03:16 -0000 <Possible follow-ups> omprakash . v - 3 May 2005 04:26:43 -0000

<- Previous	Index	Next ->
Re: New doubt !, Daniel Bibbens	Thread	Re: New doubt !, Bharat Shetty
Re: New doubt !, Daniel Bibbens	Date	Re: Xalan-Java Windows instal, N. Ganesh Babu
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >