Re: [xsl] Apply transform to document collection and summari

Cart

XML Editor - Download a Free Trial >

See What's New >

Buy Now >

[Home] [By Thread] [By Date] [Recent Entries]

Subject: Re: Apply transform to document collection and summarize results in single output
From: "G. Ken Holman" <gkholman@xxxxxxxxxxxxxxxxxxxx>
Date: Sun, 29 Jan 2012 16:37:39 -0500

At 2012-01-29 16:28 -0500, Sean Tiley wrote:

Hello,
I currently have a template that successfully processes a single xml file.

XSLT version 2
Using Saxon-SA 9.1.0.7,


I would like to iterate through a folder of XML source documents and
create a single output file

The XSLT 2 concept you are looking for is "collections". There are no standardized URI strings to represent a collection, but Saxon's URI convention is straightforward.

You don't show us your data format, but your example could be modified along the lines of:

My template that successfully processes my source file is

<?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="Account">

You now want to do the logic at the start of processing, so match="/".

<html>
       <body>
               <h2>LogEntries</h2>
          <table border="1">
            <tr bgcolor="#9acd32">
                 <th>Column1</th>
                 <th>Column2</th>
            </tr>

At this point you now want to walk all XML files and, I assume, process the document element named "Account" in each one as a row:

<xsl:for-each select="collection('./?select=*.xml')/Account">

            <tr>
                 <td>
                   <xsl:value-of select="Firstname"/>
                 </td>
                 <td>
                   <xsl:value-of select="Lastname"/>
               </td>
            </tr>

</xsl:for-each>

          </table>
       </body>
</html>
</xsl:template>

</xsl:stylesheet>

The output I want is basically a single html file
that includes a table with 2 columns

Column1                    Column2
Firstname1      Lastname1      (info from file1)
Firstname2      Lastname2      (info from file2)
Firstname3      Lastname3      (info from file3)

etc...

Not clear this is possible.

It certainly is.

I could code it in Java / C# to iterate
the docs but kinda feels like it should be possible with just XSLT
Any insight or reading would be appreciated.

I hope the above helps. Check the Saxon documentation for all of the features of the URI for collections.

. . . . . . . . . . Ken

--
Contact us for world-wide XML consulting and instructor-led training
Free 5-hour video lecture: XSLT/XPath 1.0 & 2.0 http://ude.my/uoui9h
Crane Softwrights Ltd.            http://www.CraneSoftwrights.com/s/
G. Ken Holman                   mailto:gkholman@xxxxxxxxxxxxxxxxxxxx
Google+ profile: https://plus.google.com/116832879756988317389/about
Legal business disclaimers:    http://www.CraneSoftwrights.com/legal

Current Thread
Apply transform to document collection and summarize results in single output Sean Tiley - 29 Jan 2012 21:28:28 -0000 Message not available G. Ken Holman - 29 Jan 2012 21:40:05 -0000 <= Sean Tiley - 30 Jan 2012 13:15:33 -0000

<- Previous	Index	Next ->
Apply transform to document c, Sean Tiley	Thread	Re: Apply transform to docume, Sean Tiley
Apply transform to document c, Sean Tiley	Date	Re: Apply transform to docume, Sean Tiley
	Month

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >