XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Translate two files into one
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Maximum XML File Size and Out ... (4)
-> + 64-bit version of Stylus Studi... (2)
-> + Generate xml schema from edi s... (3)
-> + License disabled (6)
-> + Stylus is not recognizing save... (5)
-> + WINE / CrossOver (3)
-> + Problem with FOP plugin (SS200... (5)
-> - XML diff engine - how to ignor... (1)
-> + How to configure Xerces J (2)
-> + Configuring xerces-2_9_1 (4)
-> + Release license to use stylus ... (5)
-> + Sorting Repeater row (3)
-> - Browse for Pipeline Input (1)
-> + Stylus 2010 and Win 7 problem ... (6)
-> + Cannot set XSLT source files w... (3)
-> - Simple TXT to HTML Convertor! ... (1)
-> + Invoking XSLT and FOP Processe... (2)
-> - Add Node and Pattern for Mutlp... (1)
-> - How to get xsl:message output ... (1)
-> + WSDL for Cvent Web Service (5)
-> - newbie question: IS there a "f... (1)
-> + Windows 7 64-bit Java. Stylus ... (3)
-> + Stylus Studio Enterprise crash... (2)
-> - XML to Access or SQL? Newbie N... (1)
-> - xml to flat file mapping using... (1)
-> + Missing Document Wizards (2)
-> - XSLT mapping and (1)
-> + Citrix Softgrid package proble... (2)
-> - xsl:import dropping the attrib... (1)
-> + XSLT mapping between schemas (5)
-> + Modifying/Creating existing CA... (9)
-> - Creating XML Sample Stream fro... (1)
-> - Integer to hex (1)
-> - Opening from and then Saving t... (1)
-> - Please help me find time query... (1)
-> + Need access to the 2007 versio... (2)
-> + Connecting to a iSeries DB2 da... (2)
-> + Windows 7 Enterprise and Stylu... (5)
-> + How do you create a record inc... (2)
-> + How to convert lines with no i... (6)
-> + http://www.milyn.org/schema/ed... (3)
-> + Using source configuration fil... (2)
-> + Is there any way that we could... (3)
-> - Water mark problem in PDF Gene... (1)
-> + Conversion file for swift mt10... (4)
-> + Stylus Studio converter error (7)
-> + Help for upgrade (6)
-> + Conversion File for a Header D... (2)
-> + Java Heap Space (9)
-> - Export mappings as text (1)
-> + XQuery, Pipeline generated jav... (2)
-> + Conditional XML Conversion? (2)
-> + iDoc to EDI (2)
-> + Pipeline XSLT Java Problem (6)
-> - Created XSLT... Now what? (1)
-> - Can I have Or Condition in the... (1)
-> - Error??? during a pipeline! (1)
-> + Opening from and then Saving t... (6)
-> + Unable to start SS 2010 ES - R... (2)
-> + proxy server settings (2)
-> - post upgrade failures and a fr... (1)
-> + Error java heap space (2)
-> + XML to XML? (4)
-> + Base64 - Encoding icone with T... (2)
-> - Pipeline: Multiple plain data ... (1)
-> + Convert and XML file to 837P (4)
-> + How to use a pipeline output i... (3)
-> + Web Service Call - SSL error (5)
-> + JVM settings cannot be edited ... (3)
-> + I am opening an xsl file SSE c... (2)
-> + Xml To Database mappings (2)
-> + Java pipeline (3)
-> + create dtd from schema (2)
-> + One file in, two files out (9)
-> + XMLConverter Licence (2)
-> + hide diagram pane (3)
-> + Getting error " xsl:template i... (2)
-> + How to reduce top margin in ev... (4)
-> + Can I do this with Stylus? (4)
-> + How to remove tabs in generati... (2)
-> + Maintain Support for Stylus St... (3)
-> + How to trim field to 2 decimal... (2)
-> + Recursively update node value ... (2)
-> + Compressed content in CADATA (4)
-> + Error in Converter when readin... (2)
-> + XML parser no longer working p... (5)
-> + Application failed to start (6)
-> + Web Service Call tester (14)
-> + temp directory writing issue (3)
-> + not able to set namespace defe... (2)
-> + Unable to open UBL in XSLT Map... (8)
-> - Compatability with Windows 7 (1)
-> + Stylus Studio 10 activation fa... (5)
-> + Way to bundle up a project? (3)
-> + Type could not be found (7)
-> + Not able to import the copy bo... (2)
-> + Stylus Studio 10 does not vali... (3)
-> + How to merge table cells using... (2)
-> + Collapsible Groups (2)
-> + Apply-template problem (2)
-- Previous [601-620] [621-640] [641-660] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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>

   
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.