Convert 1 big XML to multiple smaller XML

victorcorey · March 19th, 2008, 03:12 PM

I have 1 big XML file that I need to process and create multiple smaller XML files. I need to create multiple XML files based on the lob attribute and the region node. (example XML snippet below). The dealrow can have 3 different lob values and 5 different region nodes. So I would need to create a separate XML file for the "hotelbased" lob in the "Southwest" region. Then possibly a "cruise" lob in the "North" region.

BIG XML FILE

Code:

<?xml version="1.0" encoding="utf-8"?>
<campaign>
    <dealrow lob="hotelbased">
       <region>Southwest</region>
       <subregion>Arizona</subregion>
       <destination>Page</destination>
       <hotelname><![CDATA[Quality Inn at Lake Powell]]></hotelname>
       <starrating>3</starrating>
       <traveleropinion>3.5</traveleropinion>
       <traveleropinioncount>40</traveleropinioncount>
       <price rank="1">89</price>
       <price rank="2">239</price>
    </dealrow>
</campaign>

--
Victor Corey

bonekrusher · March 20th, 2008, 05:59 AM

This is possible. If you are using XSLT 2.0 then use <xsl:resulting-document>

Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
xmlns:xs="http://www.w3.org/2001/XMLSchema"
 xmlns:fn="http://www.w3.org/2005/xpath-functions">
    <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
    <xsl:result-document href="myxml.xml">

    </xsl:result-document>
    <xsl:result-document href="my2ndxml.xml">

    </xsl:result-document>
</xsl:stylesheet>