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

Subject: Re: [xsl] Apply transform to document collection and summarize results in single output
From: Sean Tiley <sean.tiley@xxxxxxxxx>
Date: Mon, 30 Jan 2012 08:15:13 -0500
Thank you Ken, very clear.

I'll give it a whirl and get back, likely tomorrow.

Sean Tiley

On Sun, Jan 29, 2012 at 4:37 PM, G. Ken Holman
<gkholman@xxxxxxxxxxxxxxxxxxxx> wrote:
> 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
>



--
Sean Tiley
sean.tiley@xxxxxxxxx

Current Thread