SSDN - XSLT transformation

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

syed basha

Subject: 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>

(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

syed basha

Subject: 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>

(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

syed basha

Subject: 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

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.