XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Jon GallegosSubject: Translate two files into one
Author: Jon Gallegos
Date: 03 Mar 2009 03:52 PM
I have two files. One XML one comma delimited. I need to take both files and translate them into one XML file. And just to make it more difficult, I need the file names to be dynamic.

I have read in this forum how to take two XML files with status names and translate into one XML file. But somthing like this I have not been able to find.

Postnext
Jon GallegosSubject: Translate two files into one
Author: Jon Gallegos
Date: 04 Mar 2009 04:37 PM
Just to make this a bit more complicated than it already is, I need the two files to be dynamic. So i can not use statis names in the select statement;

<xsl:template match="/">
<Outfile>
<xsl:apply-templates select="document('file:///c:/File1.xml')"/>
<xsl:apply-templates select="document('file:///c:/File2.xml')"/>
</Outfile>
</xsl:template?

Posttop
Jon GallegosSubject: 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 &gt; &apos;&apos;">
<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>

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.