Cart
|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: merging multiple xml files
 I have multiple xml files that I wish to merge. An example of the files is below. Note that a file may contain thousands of <detail> nodes. Having chosen to use XSLT, all these nodes will need to be in memory in source node trees. I have been using a master xml file to try and merge but with no success in keeping the clients together. This is a grouping issue, and grouping across separate source files is very straightforward when using the variable-based grouping method. A working result is below (modulo how you want to handle the whitespace when indenting ... I advise that after confirming this is what you want to happen that you remove the <xsl:output> instruction because of the arbitrary indenting). You'll see that it isn't very long at all. Also, due to the size of the files, is using xsl:copy and xsl:copy-of the best way to approach this. "Best" in what sense? Any choice here will not impact on your memory capacity issues regarding storing the source node trees ... it is in the architecture of XSLT (much like with DOM) that the entire source node tree of any source file be loaded in memory before any node of that tree is accessed ... and there are no guidelines for garbage collection and freeing memory. I hope this helps. ................ Ken
T:\ftemp>type file1.xml
<client>
<name>A</name>
<subclient>
<name>a</name>
<detail>....</detail>
<detail>....</detail>
</subclient>
</client>T:\ftemp>type file2.xml
<client>
<name>A</name>
<subclient>
<name>b</name>
<detail>....</detail>
<detail>....</detail>
</subclient>
</client>T:\ftemp>type file3.xml
<client>
<name>B</name>
<subclient>
<name>c</name>
<detail>....</detail>
<detail>....</detail>
</subclient>
</client>T:\ftemp>type peterson.xsl
<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0"><xsl:output indent="yes"/> <xsl:template match="masterfile">
<merged>
<xsl:variable name="clients" select="document(doc/@filename)/client"/> <xsl:for-each select="$clients">
<xsl:if test="generate-id(.)=
generate-id($clients[name=current()/name])">
<client>
<xsl:copy-of select="name"/>
<xsl:copy-of select="$clients[name=current()/name]/subclient"/>
</client>
</xsl:if>
</xsl:for-each>
</merged>
</xsl:template></xsl:stylesheet> T:\ftemp>saxon -o peterson.out peterson.xml peterson.xsl T:\ftemp>type peterson.out
<?xml version="1.0" encoding="utf-8"?>
<merged>
<client>
<name>A</name>
<subclient><name>a</name> <detail>....</detail> <detail>....</detail> </subclient>
<subclient><name>b</name> <detail>....</detail> <detail>....</detail> </subclient>
</client>
<client>
<name>B</name>
<subclient><name>c</name> <detail>....</detail> <detail>....</detail> </subclient> </client> </merged>
G. Ken Holman mailto:gkholman@xxxxxxxxxxxxxxxxxxxx Crane Softwrights Ltd. http://www.CraneSoftwrights.com/s/ Box 266, Kars, Ontario CANADA K0A-2E0 +1(613)489-0999 (F:-0995) ISBN 0-13-065196-6 Definitive XSLT and XPath ISBN 0-13-140374-5 Definitive XSL-FO ISBN 1-894049-08-X Practical Transformation Using XSLT and XPath ISBN 1-894049-11-X Practical Formatting Using XSL-FO Member of the XML Guild of Practitioners: http://XMLGuild.info Male Breast Cancer Awareness http://www.CraneSoftwrights.com/s/bc XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list 
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! 
Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|
