xsl-list
[Top] [All Lists]

Re: [xsl] Apply transform to document collection and summarize results in single output

2012-01-29 15:40:06
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(_at_)CraneSoftwrights(_dot_)com
Google+ profile: https://plus.google.com/116832879756988317389/about
Legal business disclaimers:    http://www.CraneSoftwrights.com/legal


--~------------------------------------------------------------------
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>
--~--

<Prev in Thread] Current Thread [Next in Thread>