xslt document function..

maddukuri · May 15th, 2008, 08:18 AM

Hi,

I am trying to loop through xml files and display the data using xslt..

xsl:template match="test">
    <xsl:variable name="t1" select="document('businessfiles.xml')"/>
      <xsl:for-each select="document(file/@href/parentnav/pagenav)">
        <li>

        I am able to see the files path here like c:\test\file1.xml;c:\test\file2.xml
        by using <xsl:value-of select="."/>

        How can i display the data existing in each file over here...
    <li>

  <xsl:template

any help would be much appreciated...

Cheers,

Martin Honnen · May 15th, 2008, 08:26 AM

The code

Code:

<xsl:for-each select="document(file/@href/parentnav/pagenav)">

does not make any sense as file/@href selects an attribute and that can't have any child nodes (like parentnav).
I guess you might want

Code:

<xsl:for-each select="document(file/@href)/parentnav/pagenav)">

instead but we can't really tell without knowing how your input XML looks and which data you want to select.

--
Martin Honnen
Microsoft MVP - XML

samjudson · May 15th, 2008, 08:27 AM

I think you have not done a very good job with the cut and paste here, as this bit of XSLT makes no sense.

Assuming that businessfiles.xml contains a list of file elements with href attributes then you can do something like this:

Code:

<xsl:template match="test">
  <xsl:variable name="mainfile" select="document('businessfiles.xml')"/>
  <xsl:for-each select="$mainfile/file">
    <xsl:variable name="file" select="document(@href)"/>
    ? <xsl:value-of select="$file/parentnav/pagenav"/> ?
  </xsl:for-each>
</xsl:template>

/- Sam Judson : Wrox Technical Editor -/

maddukuri · May 15th, 2008, 01:05 PM

Thanks for your response.
I am really sorry for posting the question in hurry.
As sam wrote, i am trying to loop through the files list exist in businessfiles.xml and display the xml data exist in those files..

Thanks
Maddukuri

maddukuri · May 16th, 2008, 03:30 AM

Here are the details..

BusinessFiles.xml

<?xml version="1.0"?>
<NavigationFiles>
  <file href="../../../../content/business/file1.xml"/>
  <file href="../../../../content/business/file2.xml"/>
</NavigationFiles>

file1.xml

<navigation>
  <navpage id="t1">Test</navpage>
  <navpage id="t2">Test2</navpage>
<navigation>

file2.xml

<navigation>
  <navpage id="s1">Test</navpage>
  <navpage id="s2">Test2</navpage>
<navigation>

Hope this helps..

Thanks

samjudson · May 16th, 2008, 03:40 AM

We still don't know what you are trying to output, but this should get you going:

Code:

<xsl:template match="test">
  <xsl:variable name="mainfile" select="document('businessfiles.xml')"/>
  <xsl:for-each select="$mainfile/file">
    <xsl:variable name="file" select="document(@href)"/>
    <xsl:for-each select="$file/navigation/navpage">
      Page <xsl:value-of select="@id"/> : <xsl:value-of select="text()"/> 
    </xsl:for-each>
  </xsl:for-each>
</xsl:template>

/- Sam Judson : Wrox Technical Editor -/

maddukuri · May 16th, 2008, 04:32 AM

Hi,
Thanks for your prompt response..

I am trying to display the data in xml files as links for sitemap..
Initially trying to display the text and i will extend xml files with url etc..

I am still not able to display @id value..

should i use <navigationfiles> anywhere OR am i missing anything?

Thanks

maddukuri

maddukuri · May 16th, 2008, 06:17 AM

I am still working on it,but could not get to display the values.

I am assuming the xml files are in <navigationfiles> root tag, which need to be handled in xsl.

Cheers

samjudson · May 16th, 2008, 06:31 AM

You seem to be having some very fundamental problems understanding what should be simple xpath expressions.

Yes, there should be a NavigationFiles element in the first for-each:

<xsl:for-each select="$mainfile/NavigationFiles/file">

/- Sam Judson : Wrox Technical Editor -/