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:
<!-- Since you expect to refer to lookups.xml many times, it's a good idea
to create a top-level
variable to refer to it -->
<xsl:variable name="doc-lookups" select="document('lookups.xml')"/>
<!-- the store-specific template; notice we traverse the lookup document
like any other document -->
<xsl:template match="store">
<store>
<name><xsl:value-of select="RetailStoreName"/></name>
<id><xsl:value-of select="$doc-lookups/stores/store[(_at_)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(_dot_)shetty(_at_)gmail(_dot_)com>
Reply-To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] 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
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--