SSDN - XSLT transformation

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Conferences

	Stylus Studio Feature Requests (1192)
	Stylus Studio Technical Forum (14621)
	Website Feedback (249)
	XSLT Help and Discussion (7625)
	XSLT Transformation (4)
	Generating hyperlinks (3)
	XSLT to PDF problem (with JAVA... (2)
	how to add onclick_ with try/c... (2)
	Keep table in one page. xsl-fo... (4)
	Cannot find a matching 2-argum... (3)
	Creating one string from a sub... (2)
	XSLT: Traversing XML twice for... (6)
	Copy element without namespace... (5)
	Create dynamic elemant name (2)
	XSLT: Traversing XML twice for... (3)
	Problem including Javascript (2)
	Looping through attributes (4)
	Transform values into elements... (4)
	Problem with deep node copy an... (2)
	Comparing Dates With ASP.NET 2... (3)
	Converting tree structure to h... (4)
	Attributes to element transfor... (2)
	XSLT transformation (2)
	XSLT transformation (5)
	XSLT transformation
	XSLT transformation
	XSLT transformation
	XSLT transformation
	Previous [721-740] [741-760] [761-780] Next
	XQuery Help and Discussion (2017)
	Stylus Studio FAQs (159)
	Stylus Studio Code Samples & Utilities (364)
	Stylus Studio Announcements (113)

Topic

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.

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.