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 » XSLT Help and Discussion » XSLT transformation
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + Use of before and after string (3) Sticky Topic
-> - How do I substitute element ty... (1)
-> + How does one add working days ... (4)
-> - Help, I have existing XLT and... (1)
-> + Need help on XSLT issue - (2)
-> + EDI to XML Conversion (7)
-> - XML To JSON Conversion using X... (1)
-> + Formatting Paragraphs to same ... (2)
-> - Grouping of records (1)
-> + Problems with xsd 1.1 (4)
-> + XML to HL7 mapping (3)
-> + XSLT 3 and Iterate (2)
-> + XSL-FO to PDF preview (3)
-> + java.lang.RuntimeException: Er... (2)
-> + Create Acroforms with Stylus X... (2)
-> + How to change XSLT parameter s... (3)
-> + how to change format of the da... (2)
-> + Search "Next 8 Results " doesn... (2)
-> - Support for Git (1)
-> + newbee (8)
-- [1-20] [21-40] [41-60] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
syed bashaSubject: XSLT transformation
Author: syed basha
Date: 03 Jan 2008 03:33 PM
Iam trying to convert the inputted xml file using following xslt. Iam not getting the values for anything under "requestTransaction" tag?

XSLT:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:import href="header.xsl"/>
<xsl:import href="override.xsl"/>
<xsl:output omit-xml-declaration="yes" indent="no" encoding="UTF-8"/>
<xsl:template match="/vector">
<p1:multiTranRequest xmlns:p1="http://www.americafirst.com/20070315/AccountTransaction">
<xsl:call-template name="RequestHeader"/>
<xsl:call-template name="RequestOverrideData"/>
<xsl:call-template name="request"/>
</p1:multiTranRequest>
</xsl:template>
<xsl:template name="request">
<request>
<requestType>Test</requestType>
<sourceMemberID>1</sourceMemberID>
<cashBoxID>1</cashBoxID>
<numberOfTran>1</numberOfTran>
<requestTransactions>
<requestTransaction xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="p1:ShareWithdrawalRequest">
<accountID>
<xsl:value-of select="com.bankframe.bo.DataPacket/FINANCIAL_TRNSACTION_SOURCE_ACCOUNT_VO/ACCOUNT__NUMBER/string"/>
</accountID>
<subAccountID>
<xsl:value-of select="com.bankframe.bo.DataPacket/FINANCIAL_TRNSACTION_SOURCE_ACCOUNT_VO/SUB__ACCOUNT__ID/string"/>
</subAccountID>
<tranAmount>
<xsl:value-of select="com.bankframe.bo.DataPacket/FINANCIAL_TRNSACTION_SOURCE_ACCOUNT_VO/TRANSACTION__AMOUNT/string"/>
</tranAmount>
<folio>
<xsl:value-of select="com.bankframe.bo.DataPacket/FINANCIAL_TRNSACTION_SOURCE_ACCOUNT_VO/FOLIO/string"/>
</folio>
<description>
<xsl:value-of select="com.bankframe.bo.DataPacket/FINANCIAL_TRNSACTION_SOURCE_ACCOUNT_VO/DESCRIPTION/string"/>
</description>
<regDTransaction>
<xsl:value-of select="com.bankframe.bo.DataPacket/FINANCIAL_TRNSACTION_SOURCE_ACCOUNT_VO/REG__D__TRANSACTION/string"/>
</regDTransaction>
</requestTransaction>
</requestTransactions>
</request>
</xsl:template>
</xsl:stylesheet>


and the XML file:


<vector>
<com.bankframe.bo.DataPacket>
<REQUEST__CONTEXT>
<TIME__OUT__VALUE>
<string>0</string>
</TIME__OUT__VALUE>
<TXN__CODE>
<string>TX006</string>
</TXN__CODE>
<COMPANY__CODE>
<string>111111</string>
</COMPANY__CODE>
<BRANCH__CODE>
<string>60</string>
</BRANCH__CODE>
<IP__ADDRESS>
<string>10.97.2.215</string>
</IP__ADDRESS>
<CHANNEL__ID>
<string>2222222</string>
</CHANNEL__ID>
<PROCESSING__DATE>
<string>2007-07-02</string>
</PROCESSING__DATE>
<TXN__TYPE>
<string>AFCU</string>
</TXN__TYPE>
<HOST__TELLER__ID>
<string>6</string>
</HOST__TELLER__ID>
<EMPLOYEE__ID>
<string>0</string>
</EMPLOYEE__ID>
</REQUEST__CONTEXT>
</com.bankframe.bo.DataPacket>
<com.bankframe.bo.DataPacket>
<FINANCIAL__TRANSACTION__SOURCE__ACCOUNT__VO>
<SUB__ACCOUNT__ID>
<string>9</string>
</SUB__ACCOUNT__ID>
<ACCOUNT__NUMBER>
<string>23374</string>
</ACCOUNT__NUMBER>
<DESCRIPTION>
<string>DESC</string>
</DESCRIPTION>
<REG__D__TRANSACTION>
<string>false</string>
</REG__D__TRANSACTION>
<TRANSACTION__AMOUNT>
<string>5.0</string>
</TRANSACTION__AMOUNT>
<FOLIO>
<string>FOLIO</string>
</FOLIO>
</FINANCIAL__TRANSACTION__SOURCE__ACCOUNT__VO>
</com.bankframe.bo.DataPacket>
</vector>
Postnext
(Deleted User) Subject: XSLT transformation
Author: (Deleted User)
Date: 03 Jan 2008 03:59 PM
Hi,
if the XSLT is exactly what you pasted, there is a typo: the XML tag is FINANCIAL__TRANSACTION__SOURCE__ACCOUNT__VO, not FINANCIAL_TRNSACTION_SOURCE_ACCOUNT_VO

Alberto
Postnext
syed bashaSubject: XSLT transformation
Author: syed basha
Date: 03 Jan 2008 04:19 PM
I got that straighten up. Still the same result:

The result is:

<header>
<processingDate>2007-07-02</processingDate>
<companyID>111111</companyID>
<channelID>2222222</channelID>
<branchID>60</branchID>
<tellerID>6</tellerID>
<employeeID>0</employeeID>
<workstationID>10.97.2.215</workstationID>
<transactionID/>
<transactionRetry/>
</header>
<overrideData>
<overrideBranchID/>
<overrideTellerID/>
<overrideEmployeeID/>
</overrideData>
<request>
<requestType>Test</requestType>
<sourceMemberID>1</sourceMemberID>
<cashBoxID>1</cashBoxID>
<numberOfTran>1</numberOfTran>
<requestTransactions>
<requestTransaction xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<accountID/>
<subAccountID/>
<tranAmount/>
<folio/>
<description/>
<regDTransaction/>
</requestTransaction>
</requestTransactions>
</request>
</p1:multiTranRequest>
Postnext
(Deleted User) Subject: XSLT transformation
Author: (Deleted User)
Date: 04 Jan 2008 05:33 AM
Uhm, I would double check your fix; once I changed the name of the XML node, it worked for me.
This is my template:

<xsl:template name="request">
<request>
<requestType>Test</requestType>
<sourceMemberID>1</sourceMemberID>
<cashBoxID>1</cashBoxID>
<numberOfTran>1</numberOfTran>
<requestTransactions>
<requestTransaction xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="p1:ShareWithdrawalRequest">
<accountID>
<xsl:value-of select="com.bankframe.bo.DataPacket/FINANCIAL__TRANSACTION__SOURCE__ACCOUNT__VO/ACCOUNT__NUMBER/string"/>
</accountID>
<subAccountID>
<xsl:value-of select="com.bankframe.bo.DataPacket/FINANCIAL__TRANSACTION__SOURCE__ACCOUNT__VO/SUB__ACCOUNT__ID/string"/>
</subAccountID>
<tranAmount>
<xsl:value-of select="com.bankframe.bo.DataPacket/FINANCIAL__TRANSACTION__SOURCE__ACCOUNT__VO/TRANSACTION__AMOUNT/string"/>
</tranAmount>
<folio>
<xsl:value-of select="com.bankframe.bo.DataPacket/FINANCIAL__TRANSACTION__SOURCE__ACCOUNT__VO/FOLIO/string"/>
</folio>
<description>
<xsl:value-of select="com.bankframe.bo.DataPacket/FINANCIAL__TRANSACTION__SOURCE__ACCOUNT__VO/DESCRIPTION/string"/>
</description>
<regDTransaction>
<xsl:value-of select="com.bankframe.bo.DataPacket/FINANCIAL__TRANSACTION__SOURCE__ACCOUNT__VO/REG__D__TRANSACTION/string"/>
</regDTransaction>
</requestTransaction>
</requestTransactions>
</request>
</xsl:template>

And this is what I get:

<p1:multiTranRequest xmlns:p1="http://www.americafirst.com/20070315/AccountTransaction">
<request>
<requestType>Test</requestType>
<sourceMemberID>1</sourceMemberID>
<cashBoxID>1</cashBoxID>
<numberOfTran>1</numberOfTran>
<requestTransactions>
<requestTransaction xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="p1:ShareWithdrawalRequest">
<accountID>23374</accountID>
<subAccountID>9</subAccountID>
<tranAmount>5.0</tranAmount>
<folio>FOLIO</folio>
<description>DESC</description>
<regDTransaction>false</regDTransaction>
</requestTransaction>
</requestTransactions>
</request>
</p1:multiTranRequest>

Alberto

Posttop
syed bashaSubject: XSLT transformation
Author: syed basha
Date: 04 Jan 2008 11:38 AM
Thanks Alberto.
Finally I got that. Yes its a typo.
   
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.