|
|
 top
|
  Subject: Translate two files into one
Author: Jon Gallegos
Date: 06 Mar 2009 11:21 AM
|
OK
I got this tp work with three files trasnlating into one. But i still need to know how to do this dynamically.
The stylesheet is below.
<?xml version='1.0' ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:a="http://www.plmxml.org/Schemas/PLMXMLSchema" xmlns:b="http://www.w3.org/1999/xhtml" exclude-result-prefixes="a b">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/">
<document xmlns="http://www.lotus.com/dxl" version="6.5" maintenanceversion="4.0" replicaid="852574D4005615FD" form="DaichoForm-e"><!-- Log Information - Date -->
<xsl:variable name="WSCreateDate" select="document('file:///p:/ECRF/oFromTce/CRF0000000216__;1-Jon PLMXML Full Attribute Test.xml')/a:PLMXML/a:Form[@subClass = 'CRF Originator Form']/a:UserData/a:UserValue[@title = 'H_crfcreationdate']/@value"/>
<xsl:variable name="WSDate1" select="substring($WSCreateDate,8,4)"/>
<xsl:variable name="WSDate2" select="substring($WSCreateDate,4,3)"/>
<xsl:variable name="WSDate3" select="substring($WSCreateDate,1,2)"/>
<!-- ====================================================================== -->
<!-- Date the CRF was Created, modified existing data, revised CRF, last -->
<!-- accessed and last added new data -->
<!-- ====================================================================== -->
<noteinfo noteid="af6" sequence="1">
<xsl:choose>
<xsl:when test="$WSDate2 = 'Jan'">
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'01',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'01',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'01',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'01',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'01',$WSDate3)"/></datetime></addedtofile>
</xsl:when>
<xsl:when test="$WSDate2 = 'Feb'">
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'02',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'02',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'02',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'02',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'02',$WSDate3)"/></datetime></addedtofile>
</xsl:when>
<xsl:when test="$WSDate2 = 'Mar'">
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></addedtofile>
</xsl:when>
<xsl:when test="$WSDate2 = 'Mar'">
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></addedtofile>
</xsl:when>
<xsl:when test="$WSDate2 = 'Mar'">
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></addedtofile>
</xsl:when>
<xsl:when test="$WSDate2 = 'Mar'">
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></addedtofile>
</xsl:when>
<xsl:when test="$WSDate2 = 'Mar'">
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'03',$WSDate3)"/></datetime></addedtofile>
</xsl:when>
<xsl:when test="$WSDate2 = 'Aug'">
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'08',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'08',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'08',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'08',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'08',$WSDate3)"/></datetime></addedtofile>
</xsl:when>
<xsl:when test="$WSDate2 = 'Sep'">
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'09',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'09',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'09',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'09',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'09',$WSDate3)"/></datetime></addedtofile>
</xsl:when>
<xsl:when test="$WSDate2 = 'Oct'">
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'10',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'10',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'10',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'10',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'10',$WSDate3)"/></datetime></addedtofile>
</xsl:when>
<xsl:when test="$WSDate2 = 'Nov'">
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'11',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'11',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'11',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'11',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'11',$WSDate3)"/></datetime></addedtofile>
</xsl:when>
<xsl:when test="$WSDate2 = 'Dec'">
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'12',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'12',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'12',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'12',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'12',$WSDate3)"/></datetime></addedtofile>
</xsl:when>
<xsl:otherwise>
<created><datetime dst="true"><xsl:value-of select="concat($WSDate1,'01',$WSDate3)"/></datetime></created>
<modified><datetime dst="true"><xsl:value-of select="concat($WSDate1,'01',$WSDate3)"/></datetime></modified>
<revised><datetime dst="true"><xsl:value-of select="concat($WSDate1,'01',$WSDate3)"/></datetime></revised>
<lastaccessed><datetime dst="true"><xsl:value-of select="concat($WSDate1,'01',$WSDate3)"/></datetime></lastaccessed>
<addedtofile><datetime dst="true"><xsl:value-of select="concat($WSDate1,'01',$WSDate3)"/></datetime></addedtofile>
</xsl:otherwise>
</xsl:choose>
</noteinfo>
<!-- ====================================================================== -->
<!-- Log Information - Name only - From Team Center Log Report -->
<!-- ====================================================================== -->
<updatedby>
<xsl:for-each select="document('converter:HTML?file:///p:/ECRF/oFromTce/CRF0000000216.htm')/b:html/b:body/b:table/b:tbody/b:tr">
<xsl:if test="b:td > ''">
<xsl:variable name="WSName1" select="b:td[1]"/>
<xsl:variable name="WSName2" select="b:td[4]"/>
<xsl:variable name="WSName3" select="document('file:///p:/ECRF/oFromTce/automated_query_output.xml')/DisplayDefinitionTable/rows/row[(row_element = $WSName2)]/row_element[@property_name = 'user_name']"/>
<xsl:variable name="WSName4" select="document('file:///p:/ECRF/oFromTce/CRF0000000216__;1-Jon PLMXML Full Attribute Test.xml')/a:PLMXML/a:Form[@subClass = 'CRF Originator Form']/a:UserData/a:UserValue[@title = 'H_crfplant']/@value"/>
<xsl:variable name="WSName5" select="document('file:///p:/ECRF/oFromTce/CRF0000000216__;1-Jon PLMXML Full Attribute Test.xml')/a:PLMXML/a:Form[@subClass = 'CRF Originator Form']/a:UserData/a:UserValue[@title = 'H_crfrequestsrc']/@value"/>
<name><xsl:value-of select="concat('CN=',substring-before($WSName3,','),substring-after($WSName3,', '),'/OU=',$WSName4,'/OU=AM/O=',$WSName5)"/></name>
</xsl:if>
</xsl:for-each>
</updatedby>
<!-- Soto Geba Results -->
<item name="judge">
<text><xsl:value-of select="a:PLMXML/a:Form[@subClass = 'CRF HRA Response Form']/a:UserData/a:UserValue[@title = 'H_crfhrares']/@value"/></text>
</item>
</document>
</xsl:template>
</xsl:stylesheet>
|
|
|
|
|
next