Split large XML to Smaller XML using XSLT

mhkay · March 20th, 2012, 06:45 PM

For the output layout, just use

Code:

<xsl:output indent="yes"/>

Could I recommend reading my book?

chilly · March 20th, 2012, 06:45 PM

i took care of it after posting it. Sorry :(

<xsl:output omit-xml-declaration="no" indent="yes"/>

chilly · March 23rd, 2012, 09:17 AM

Hi Mike, i have one more requirement on how many CARRIER i am writing. The target system is not liking sending too many files. The requirement is put 50 CARRIER tags in one file. can you let me know how this can be done easy. I am thinking of using variable with counter and increase at the end of each loop and if it hits the max number, it will be set to 0. Is that a good approach?

Here is the final code i am using currently

Code:

<?xml version="1.0"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output indent="yes"/>
	<xsl:template match="/">
		<xsl:for-each select="receipt/prod/carrier">
			<xsl:variable name="id">
				<xsl:value-of select="tokenize(document-uri(/), '/')[last()]"/>
			</xsl:variable>
			<xsl:result-document method="xml" href="file:///C:/Users/chillhx/Desktop/Phv/0322/output/{$id}_{position()}.xml">
				<receipt>
					<manufacturer>
						<xsl:value-of select="/receipt/manufacturer"/>
					</manufacturer>
					<manufacturer_gln>
						<xsl:value-of select="/receipt/manufacturer_gln"/>
					</manufacturer_gln>
					<transfer_recipt>
						<xsl:value-of select="/receipt/transfer_recipt"/>
					</transfer_recipt>
					<prod>
						<product_GTIN>
							<xsl:value-of select="/receipt/prod/product_GTIN"/>
						</product_GTIN>
						<product_LOT>
							<xsl:value-of select="/receipt/prod/product_LOT"/>
						</product_LOT>
						<production_date>
							<xsl:value-of select="/receipt/prod/production_date"/>
						</production_date>
						<expire_date>
							<xsl:value-of select="/receipt/prod/expire_date"/>
						</expire_date>
						<xsl:copy-of select="../@* | ."/>
					</prod>
				</receipt>
			</xsl:result-document>
		</xsl:for-each>
	</xsl:template>
</xsl:stylesheet>

Martin Honnen · March 23rd, 2012, 09:50 AM

If you use XSLT 2.0 and want to put a certain amount of elements into one result document then use an approach like

Code:

<xsl:param name="size" select="50"/> 

    <xsl:template match="/">
        <xsl:for-each-group select="receipt/prod/carrier" group-by="(position() - 1) idiv $size">
            <xsl:variable name="id" select="tokenize(document-uri(/), '/')[last()]"/>
 
            <xsl:result-document method="xml" href="file:///C:/Users/chillhx/Desktop/Phv/0322/output/{$id}_{position()}.xml">
                <result>
                   <xsl:for-each-group select="current-group()">
                      <!-- put code here to output details of each carrier element -->

chilly · March 23rd, 2012, 10:07 AM

Thanks for the example

I am getting the following error

XTSE1080: Exactly one of the attributes group-by, group-adjacent, group-starting-with, and group-ending-with must be specified

Do i need to declare $div as well, if yes with what value?

Martin Honnen · March 23rd, 2012, 10:13 AM

I am sorry, the inner "for-each-group" in the code sample I posted should simply be "for-each"

Code:

<xsl:param name="size" select="50"/> 

    <xsl:template match="/">
        <xsl:for-each-group select="receipt/prod/carrier" group-by="(position() - 1) idiv $size">
            <xsl:variable name="id" select="tokenize(document-uri(/), '/')[last()]"/>
 
            <xsl:result-document method="xml" href="file:///C:/Users/chillhx/Desktop/Phv/0322/output/{$id}_{position()}.xml">
                <result>
                   <xsl:for-each select="current-group()">
                      <!-- put code here to output details of each carrier element -->

chilly · March 23rd, 2012, 10:38 AM

Thanks, that works.

Is it simple to convert this into XSLT 1.0?

Also for the following, i am not getting the file name correct, the file name comes as this "PV_SER~3.XML_1". Here is the syntax i am suing

<xsl:value-of select="tokenize(document-uri(/), '/')[last()]"/>

Thanks for your help

Martin Honnen · March 23rd, 2012, 10:46 AM

XSLT 1.0 does not have any feature to create several result elements so there is no way to achieve this with XSLT 1.0, unless you look for an XSLT 1.0 processor with an extension.
As for the file name problem, you might want to start a new post for it, stating clearly the code you have, the input you have, the result you want and the one you get. That makes it easier for anyone wanting to help to suggest a solution, with the current post it looks like I would have to read through lots of old posting to try to find that information.

roychan · February 28th, 2013, 12:05 PM

If my xml looks something like this

<?xml version="1.0" encoding="UTF-8"?>
<receipt>
<manufacturer>1</manufacturer>
<manufacturer_gln/>
<transfer_recipt/>
<prod>
<product_GTIN/>
<product_LOT/>
<production_date/>
<expire_date/>
<carrier id="123">
<carrier_type>1</carrier_type>
</carrier>

<carrier id="456">
<carrier_type>1</carrier_type>
</carrier>
<person id="123">
<fn>Life</fn>
</person>
<person id="456">
<fn>Life1</fn>
</person>

</prod>
</receipt>

can i split the xml using xslt into two xml files based on checking the id attribute of carrier and person

File1.xml
<?xml version="1.0" encoding="UTF-8"?>
<receipt>
<manufacturer>1</manufacturer>
<manufacturer_gln/>
<transfer_recipt/>
<prod>
<product_GTIN/>
<product_LOT/>
<production_date/>
<expire_date/>
<carrier id="123">
<carrier_type>1</carrier_type>
</carrier>

<person id="123">
<fn>Life</fn>
</person>

</prod>
</receipt>

File2.xml

<?xml version="1.0" encoding="UTF-8"?>
<receipt>
<manufacturer>1</manufacturer>
<manufacturer_gln/>
<transfer_recipt/>
<prod>
<product_GTIN/>
<product_LOT/>
<production_date/>
<expire_date/>

<carrier id="456">
<carrier_type>1</carrier_type>
</carrier>

<person id="456">
<fn>Life1</fn>
</person>

</prod>
</receipt>

mhkay · February 28th, 2013, 12:44 PM

Please don't add a new question to an old thread. And please say whether you are using XSLT 2.0 or whether you are constrained to 1.0.