Wednesday, 7 January 2015

XSLT transform not working as expected



I'm having a slight problem with my XSLT transform.


I have the following XSLT;



<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://ift.tt/tCZ8VR" version="1.0"><!-- removes the unrelated elements -->
<xsl:template match="@* | node()">
<xsl:copy>
<xsl:apply-templates select="@* | node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="master_version[not(ORDER = //order/ORDERPK)]"/>
<xsl:template match="press_section[not(ORDER = //order/ORDERPK)]"/>
<xsl:template match="version[not(ORDER = //order/ORDERPK)]"/>
<xsl:template match="task_info_press_section[not(ORDER = //order/ORDERPK)]"/>
<xsl:template match="task_info_post_press[not(ORDER = //order/ORDERPK)]"/>
<xsl:template match="post_press_version[not(ORDER = //order/ORDERPK)]"/>
<!-- removes specified nodes from all elements -->
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="ORDER"/>
<xsl:template match="ORDERPK"/>
<xsl:template match="PRESS_x0020_SECTION"/>
<xsl:template match="POST_x0020_PRESS"/>
<!-- Creates attributes against the ORDER element -->
<xsl:strip-space elements="*"/>
<xsl:output method="xml" indent="yes"/>
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="order">
<order job_id="{job_id}" site_code="{site_code}" replace="{replace}">
<xsl:apply-templates/>
</order>
</xsl:template>
<xsl:template match="job_id | site_code | replace | master_version"/>
<!-- identity transform -->
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="order">
<order job_id="{@job_id}" site_code="{@site_code}" replace="{Replace}">
<xsl:apply-templates select="node()"/>
<xsl:copy-of select="../master_version"/>
</order>
</xsl:template>
<xsl:template match="Replace | master_version"/>
<!-- renames element to specified name -->
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="task_info_press_section">
<xsl:element name="task_info1">
<xsl:apply-templates/>
</xsl:element>
</xsl:template>
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="task_info_post_press">
<xsl:element name="task_info2">
<xsl:apply-templates/>
</xsl:element>
</xsl:template>
</xsl:stylesheet>


My XML should look like this;



<?xml version="1.0"?>
<dataroot generated="2015-01-07T14:06:55" xmlns:od="urn:schemas-microsoft-com:officedata">
<order job_id="" site_code="" replace="true">
<job_description>TESTDATA</job_description>
<order_qty>1900</order_qty>
<finishing_style>PB</finishing_style>
<depth>10</depth>
<width>8</width>
<cover_pagination>4</cover_pagination>
<text_pagination>12</text_pagination>
<delivery_commence_date>15/12/2014</delivery_commence_date>
<delivery_complete_date>15/12/2014</delivery_complete_date>
<job_site>DG</job_site>
<managing_printer>DG</managing_printer>
<is_managing_printer>TRUE</is_managing_printer>
<cust_order_ref>776031</cust_order_ref>
<cust_code>Test</cust_code>
<site_cce_name>Jamie</site_cce_name>
<site_cce_email>JamesBrace@dstoutput.co.uk</site_cce_email>
<sales_person_name>Jamie Brace</sales_person_name>
<sales_person_email>JamesBrace@dstouput.co.uk</sales_person_email>
<master_version>
<version_id></version_id>
<version_code>COMM</version_code>
<version_common>true</version_common>
<version_finished>false</version_finished>
<version_description>Common</version_description>
<version_nett_qty>176262</version_nett_qty>
<version_special_qty>10</version_special_qty>
</master_version>
<master_version>
</order>


But it looks like this;



<?xml version="1.0"?>
<dataroot generated="2015-01-07T14:06:55" xmlns:od="urn:schemas-microsoft-com:officedata">
<order job_id="" site_code="" replace="true">
<job_description>TESTDATA</job_description>
<order_qty>1900</order_qty>
<finishing_style>PB</finishing_style>
<depth>10</depth>
<width>8</width>
<cover_pagination>4</cover_pagination>
<text_pagination>12</text_pagination>
<delivery_commence_date>15/12/2014</delivery_commence_date>
<delivery_complete_date>15/12/2014</delivery_complete_date>
<job_site>DG</job_site>
<managing_printer>DG</managing_printer>
<is_managing_printer>TRUE</is_managing_printer>
<cust_order_ref>776031</cust_order_ref>
<cust_code>Test</cust_code>
<site_cce_name>Jamie</site_cce_name>
<site_cce_email>JamesBrace@dstoutput.co.uk</site_cce_email>
<sales_person_name>Jamie Brace</sales_person_name>
<sales_person_email>JamesBrace@dstouput.co.uk</sales_person_email>
<master_version>
<ORDER>1</ORDER>
<version_id></version_id>
<version_code>COMM</version_code>
<version_common>true</version_common>
<version_finished>false</version_finished>
<version_description>Common</version_description>
<version_nett_qty>176262</version_nett_qty>
<version_special_qty>10</version_special_qty>
</master_version>
<master_version>
<ORDER>2</ORDER>
<version_code>COMM</version_code>
<version_common>TRUE</version_common>
<version_finished>FALSE</version_finished>
<version_description>Common</version_description>
<version_nett_qty>1900</version_nett_qty>
<version_special_qty>0</version_special_qty>
</master_version>


Any ideas?


Also I have been told that my XSLT isn't formatted very well, could anybody possibly help with that?


Thanks everyone!


No comments:

Post a Comment