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 Go to previous topicPrev TopicGo to next topicNext 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
Alberto MassariSubject: XSLT transformation
Author: Alberto Massari
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
Alberto MassariSubject: XSLT transformation
Author: Alberto Massari
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.

 
Topic Page 1 2 3 4 5 6 7 8 9 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.