Ok, got it working.
Had some troubles with namespaces which still confuses me greatly but
its working.. let me explain.
The source XML files have the followng structure
<SiebelMessage
xmlns="http://www.siebel.com/xml/CPC%20FBE%20Outbound%20Internal%20IO">
<Message>
<Account Version="1.0.4">
<Value1/>
<Value2/>
...
</Account>
</Message>
</SiebelMessage>
The stylesheet is as follows
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:agr="http://www.siebel.com/xml/CPC%20FBE%20Outbound%20Internal%20IO">
<xsl:template match="/">
<html>
<body>
<h2>In file analysis</h2>
<table border="1">
<tr>
<th>Value1</th>
<th>Value2</th>
</tr>
<xsl:for-each
select="collection('file:///c:/tmp/?select=*.xml')/agr:SiebelMessage/agr:Message/agr:Account">
<tr>
<td>
<xsl:value-of select="agr:Value1"/>
</td>
<td>
<xsl:value-of select="agr:Value2"/>
</td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
I had thought that the matching expression should be something like
<xsl:template match="/agr:SiebelMessage/agr:Message"), then the
collection select would just have been <xsl:for-each
select="collection('file:///c:/tmp/?select=*.xml'/agr:Account">
No matter what I did I could not get that working, thought I'm sure
it's posible.
Seems I need to read up on namespaces and xslt as there is much I do
not understand
Thanks very much for all the help.
Much appreciated
Sean
On Mon, Jan 30, 2012 at 8:15 AM, Sean Tiley
<sean(_dot_)tiley(_at_)gmail(_dot_)com> wrote:
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(_at_)cranesoftwrights(_dot_)com> 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(_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>
--~--
--
Sean Tiley
sean(_dot_)tiley(_at_)gmail(_dot_)com
--
Sean Tiley
sean(_dot_)tiley(_at_)gmail(_dot_)com
--~------------------------------------------------------------------
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>
--~--