Subject:Easiest way to split many documents from one large document Author:Bob Chauvin Date:10 Oct 2007 11:40 AM Originally Posted: 10 Oct 2007 10:18 AM
I have an xml file exported from MSAccess with the format similar to Fig A, and want to create individual documents that match the schema in Fig B. I have SS 2007 r2 EE and would like to know if I can do this w/in SS, or should use some other method.
Thanks for your assist.
P.S. The input file Fig A is large (~67MB).
PP.S I need all thos processing instructions and namespaces at the top of each document.
Subject:Easiest way to split many documents from one large document Author:(Deleted User) Date:10 Oct 2007 11:47 AM
Hi Bob,
one approach is to create an XSLT 2.0 stylesheet and, using mapper, map the fields of the input document with the PepContact element from the schema; create a for-each block from 'estate' to 'PepContact', then map cl_number to ClientNumber, cl1_alive with IsLiving and so on (with some data transformation in the middle, to change the "Y" values to "true"). Once you have the data layout you need, wrap the children nodes of the xsl:for-each within a <xsl:result-document href="estate-{cl_number}.xml"> element, and this will send the single clients into separate files.
Subject:Easiest way to split many documents from one large document Author:(Deleted User) Date:10 Oct 2007 12:21 PM
Hi Bob,
have you tried adding a -Xmx600m option to the JVM command line in the Java Virtual Machine section of the Tools | Options dialog? That would raise the maximum amount of memory that Saxon is allowed to use while grouping your 67Mb file.
Subject:Easiest way to split many documents from one large document Author:Bob Chauvin Date:10 Oct 2007 12:58 PM Originally Posted: 10 Oct 2007 12:44 PM
The transform doesn't appear to be looping through any rows, so I suspect my for-each-group is wrong.