How to copy elements to new file

geek.shrek · January 7th, 2010, 07:32 AM

Hi,

I'm using XSLT 2.0 with saxon9.
I would like to seperate my current xml into a few seperate files according to certain element.

Here's my input

Code:

<?xml version="1.0" encoding="UTF-8"?>
<Book version="1.1" Publisher="Wrox">
    <BookDetails NbrOfPages="15" Name="Novel 123">
        <Binding Name="ABC HELLO1" from="1" to="1"/>
        <Binding Name="DEF HELLO2" from="2" to="3"/>
        <Binding Name="GHI HELLO3" from="4" to="10"/>
        <Binding Name="JKL HELLO4" from="11" to="15"/>
        <Page Position="1" Name="page 1" start_writing="2010-02-17T00:17:50"/>
        <Page Position="2" Name="page 2" start_writing="2010-02-17T01:18:20"/>
        <Page Position="3" Name="page 3" start_writing="2010-02-17T01:18:20"/>
        <Page Position="4" Name="page 4" start_writing="2010-02-17T01:18:20"/>
        <Page Position="5" Name="page 5" start_writing="2010-02-17T01:18:20"/>
        <Paper Position="6" Name="page 6" start_writing="2010-02-17T01:18:20"/>
        <Page Position="7" Name="page 7" start_writing="2010-02-17T01:18:20"/>
        <Page Position="8" Name="page 8" start_writing="2010-02-17T01:18:20"/>
        <Page Position="9" Name="page 9" start_writing="2010-02-17T01:18:20"/>
        <Page Position="10" Name="page 10" start_writing="2010-02-17T01:18:20"/>
        <Page Position="11" Name="page 11" start_writing="2010-02-17T01:18:20"/>
        <Paper Position="12" Name="page 12" start_writing="2010-02-17T01:18:20"/>
        <Page Position="13" Name="page 13" start_writing="2010-02-17T01:18:20"/>
        <Page Position="14" Name="page 14" start_writing="2010-02-17T01:18:20"/>    
        <Page Position="15" Name="page 15" start_writing="2010-02-17T01:18:20"/>    
    </BookDetails>
</Book>

I would like to have this result

Code:

ABC.xml
<?xml version="1.0" encoding="UTF-8"?>
<Book version="1.1" Publisher="Wrox">
    <BookDetails NbrOfPages="1" Name="Novel 123">
        <Binding Name="ABC HELLO1" from="1" to="1"/>
        <Page Position="1" Name="page 1"/>
    </BookDetails>
</Book>

DEF.xml
<?xml version="1.0" encoding="UTF-8"?>
<Book version="1.1" Publisher="Wrox">
    <BookDetails NbrOfPages="2" Name="Novel 123">
        <Binding Name="DEF HELLO2" from="1" to="2"/>
        <Page Position="1" Name="page 2"/>
        <Page Position="2" Name="page 3"/>
    </BookDetails>
</Book>
GHI.xml
<?xml version="1.0" encoding="UTF-8"?>
<Book version="1.1" Publisher="Wrox">
    <BookDetails NbrOfPages="7" Name="Novel 123">
        <Binding Name="GHI HELLO3" from="1" to="7"/>
        <Page Position="1" Name="page 4"/>
        <Page Position="2" Name="page 5"/>
        <Paper Position="3" Name="page 6"/>
        <Page Position="4" Name="page 7"/>
        <Page Position="5" Name="page 8"/>
        <Page Position="6" Name="page 9"/>
        <Page Position="7" Name="page 10"/>     
    </BookDetails>
</Book>

JKL.xml
<?xml version="1.0" encoding="UTF-8"?>
<Book version="1.1" Publisher="Wrox">
    <BookDetails NbrOfPages="5" Name="Novel 123">
        <Binding Name="JKL HELLO4" from="1" to="5"/> 
        <Page Position="1" Name="page 11"/>
        <Paper Position="2" Name="page 12"/>
        <Page Position="3" Name="page 13"/>
        <Page Position="4" Name="page 14"/>    
        <Page Position="5" Name="page 15"/>    
    </BookDetails>
</Book>

Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet 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" 
    xmlns:f="http://local/functions"
    exclude-result-prefixes="xs f" version="2.0">
    <xsl:output method="xml" indent="yes"/>
 
     <xsl:template match="/">
            <xsl:apply-templates/>
     </xsl:template> 
    
    <xsl:template match="Book" name="book">
        <xsl:copy>
            <xsl:copy-of select="@*"/>  
            <xsl:apply-templates/>
        </xsl:copy>
    </xsl:template>
    
    <xsl:template match="BookDetails">
        <xsl:copy>
            <xsl:copy-of select="@*"/>
            <xsl:for-each select="//Binding">
                <xsl:variable name="name"><xsl:value-of select="@Name"/></xsl:variable>
                <xsl:variable name="filename"><xsl:value-of select="fn:substring(@Name,1,3)"/></xsl:variable>
                <xsl:result-document href="{$filename}.xml">
                   <!-- I'm stuck here -->
                 </xsl:result-document>       
            </xsl:for-each>
        </xsl:copy>
    </xsl:template>
    
    <xsl:template match="Page|Paper">
        <!-- 
        <xsl:if test="xs:integer(@Position) &gt;= 1 and xs:integer(@Position) &lt;= 121"> 
            <xsl:copy-of select=".|node()"/>
        </xsl:if>
        -->
    </xsl:template>
</xsl:stylesheet>

I understand that because I have the process of creating the file is inside the "for-each", the current node will be <Binding> so I tried to get parent element and copy the node to the file that created. But it didn't work, it keep start the xml file element as <Binding>.

Could someone please help me how can I achieve my result out of my xml.

Thanks.

samjudson · January 7th, 2010, 08:00 AM

Personally I'd wrap the whole lot around the result-document rather than trying to write the result-document at the bottom and then go back up.

Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
   <xsl:output method="xml" indent="yes"/>
   
   <xsl:template match="/">
         <xsl:for-each select="/Book/BookDetails/Binding">
               <xsl:variable name="N" select="substring-before(@Name,' ')"/>
               <xsl:result-document href="{$N}.xml">
                  <xsl:apply-templates select="/Book">
               <xsl:with-param name="binding" select="$N"/>
                  </xsl:apply-templates>
               </xsl:result-document>
           </xsl:for-each>
       </xsl:template>

   <xsl:template match="node() | @*">
      <xsl:param name="binding" select="''"/>
      <xsl:copy>
         <xsl:apply-templates select="node() | @*">
            <xsl:with-param name="binding" select="$binding"/>
         </xsl:apply-templates>
      </xsl:copy>
   </xsl:template>
       
   <xsl:template match="BookDetails">
           <xsl:param name="binding"/>
         <BookDetails>
         <xsl:variable name="B" select="Binding[contains(@Name, $binding)]"/>
         <xsl:apply-templates select="@*"/>
         <xsl:apply-templates select="$B">
            <xsl:with-param name="binding" select="$binding"/>
         </xsl:apply-templates>
         <xsl:apply-templates select="Page[@Position &gt;= $B/@from and @Position &lt;= $B/@to]">
            <xsl:with-param name="binding" select="$binding"/>
         </xsl:apply-templates>
         </BookDetails>
    </xsl:template>

</xsl:stylesheet>

mhkay · January 7th, 2010, 08:06 AM

First, change this

<xsl:for-each select="//Binding">
<xsl:variable name="name"><xsl:value-of select="@Name"/></xsl:variable>
<xsl:variable name="filename"><xsl:value-of select="fn:substring(@Name,1,3)"/></xsl:variable>
<xsl:result-document href="{$filename}.xml">

</xsl:result-document>
</xsl:for-each>

to this:

<xsl:for-each select="Binding">
<xsl:variable name="name" select="@Name"/>
<xsl:variable name="filename" select="fn:substring(@Name,1,3)"/></xsl:variable>
<xsl:result-document href="{$filename}.xml">

</xsl:result-document>
</xsl:for-each>

Your code isn't wrong here, it's just that it can be improved. In particular, using xsl:value-of within xsl:variable, and unnecessary use of //, are both habits to avoid.

Now the substance. As far as I can see, within the xsl:result document you want something like:

Code:

<xsl:apply-templates select="../(Page|Paper)[@Position = xs:integer(current()/@from) to xs:integer(current()/@to)]"

and the rest should be straightforward

geek.shrek · January 9th, 2010, 01:03 PM

Thanks for the improvement tips :)

It works, but how can I change the position attribute accordingly without having to copy the attribute one by one?

I also tried to remove the start_writing attribute just like in W3 documentation

Code:

<xsl:template match="Page|Paper">
         <xsl:copy>
         <xsl:copy-of select="@* |node()"/>
                <xsl:apply-templates select="@*"/>
         </xsl:copy>
</xsl:template> 

 <xsl:template match="start_writing"/>

but then the result is become something like

Code:

<Page Position="1" Name="page 1" start_writing="2010-02-17T00:17:50"/>1page 12010-02-17T00:17:50

Any idea what did I do wrong?

Martin Honnen · January 9th, 2010, 01:22 PM

xsl:copy-of select="@*" and xsl:apply-templates select="@*" in one template? What do you want to achieve with that?
And if you want to prevent processing the 'start_writing' attribute then you need

Code:

<xsl:template match="@start_writing"/>

geek.shrek · January 9th, 2010, 02:09 PM

I'm trying to copy the node without the start_writing attribute.

I've tried your suggestion to put '@' in front of start_writing. but the result is still the same.

I've also tried

Code:

<xsl:template match="Page|Paper">
         <xsl:copy>
                <xsl:apply-templates select="@*|node()"/>  
         </xsl:copy>
</xsl:template> 

 <xsl:template match="@start_writing"/>

the result become something like

Code:

<Page>1page 12010-02-17T00:17:50</Page>

it doesn't create the attribute name.

Martin Honnen · January 10th, 2010, 08:35 AM

If you want to copy all attributes except the 'start_writing' attribute then you can simply use (with XSLT 2.0)

Code:

<xsl:template match="Page | Paper">
   <xsl:copy>
     <xsl:copy-of select="@* except @start_writing"/>
   </xsl:copy>
</xsl:template>

That sample does not do anything with child nodes as I am not sure what you want to do with them, you can of course add an <xsl:copy-of select="node()"/> if you want to copy them as well.
If you want to transform some attributes, copy some, but don't want to copy the 'start_writing' attribute then you need the

Code:

<xsl:template match="Page | Paper">
   <xsl:copy>
      <xsl:apply-templates select="@* | node()/">
   </xsl:copy>
</xsl:template>

approach, then you need to add

Code:

<xsl:template match="@start_writing"/>

but you need to also ensure that other attributes are copied by adding

Code:

<xsl:template match="@*>
   <xsl:copy/>
</xsl:template>

as otherwise the default template for attributes is used which copies the value of the attribute to the output. That is why one of your attempts puts all those attribute values in the element content.