Subject: [xsl] XSLT Simple Transformation? From: HSA <henrysa69@xxxxxxxxx> Date: Tue, 28 Oct 2003 13:54:43 -0800 (PST) |
Hello..I currently work with PeopleSoft 8.4 and I am working with application messaging between our HR database and our Financials database. I have the FUND_CF_SYNC message working between the two databases however, I have discovered that the message to be transformed. In Financials we have a SETID defined as 'XXX'. In HR, the SETID needs to publish as 'XXX01'. So what I need is a simple XSLT transformation program that concats the "01" to the end of 'XXX'. I am new to the XSLT language and I havent had any prior training with XML or XSLT. My XML message is as follows: Does anyone have any insight on what my XSLT code should look like? I have attempted to write some XSLT but I dont know if I am on the right track. I have included this example below the XML: Thanks in advance, Henry <?xml version="1.0"?> <FUND_CF_SYNC> <FieldTypes> <FUND_TBL class="R"> <SETID type="CHAR"/> <FUND_CODE type="CHAR"/> <EFFDT type="DATE"/> <EFF_STATUS type="CHAR"/> <DESCR type="CHAR"/> <DESCRSHORT type="CHAR"/> </FUND_TBL> <PSCAMA class="R"> <LANGUAGE_CD type="CHAR"/> <AUDIT_ACTN type="CHAR"/> <BASE_LANGUAGE_CD type="CHAR"/> <MSG_SEQ_FLG type="CHAR"/> <PROCESS_INSTANCE type="NUMBER"/> <PUBLISH_RULE_ID type="CHAR"/> <MSGNODENAME type="CHAR"/> </PSCAMA> </FieldTypes> <MsgData> <Transaction> <FUND_TBL class="R"> <SETID>XXX</SETID> <FUND_CODE>96666</FUND_CODE> <EFFDT>2003-10-28</EFFDT> <EFF_STATUS>A</EFF_STATUS> <DESCR>TEST</DESCR> <DESCRSHORT>TEST</DESCRSHORT> </FUND_TBL> <PSCAMA class="R"> <LANGUAGE_CD>ENG</LANGUAGE_CD> <AUDIT_ACTN>A</AUDIT_ACTN> <BASE_LANGUAGE_CD>ENG</BASE_LANGUAGE_CD> <MSG_SEQ_FLG/> <PROCESS_INSTANCE>0</PROCESS_INSTANCE> <PUBLISH_RULE_ID/> <MSGNODENAME/> </PSCAMA> </Transaction> </MsgData> </FUND_CF_SYNC> XSLT: <!-- This program will transform XXX Setid to XXX01 --> <?xml version="1.0"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:template match="FUND_CF_SYNC"> <FUND_CF_SYNC> <xsl:apply-templates/> </FUND_CF_SYNC> </xsl:template> <xsl:template match="node() | @*"/> <xsl:copy> <xsl:apply-templates select="node() | @*"/> </xsl:copy> </xsl:template> <xsl:template match="FUND_TBL"> <FUND_TBL><xsl:attribute name="class"><xsl:value-of select="@class"/></xsl:attribute> <xsl:variable name="temp" select="SETID"/> <SETID><xsl:value-of select="concat($temp,01)"/></SETID> <FUND_CODE>/> <EFFDT>/> <EFF_STATUS>/> <DESCR/> <DESCRSHORT/> </FUND_TBL> <PSCAMA class="R"> <LANGUAGE_CD type="CHAR"/> <AUDIT_ACTN type="CHAR"/> <BASE_LANGUAGE_CD type="CHAR"/> <MSG_SEQ_FLG type="CHAR"/> <PROCESS_INSTANCE type="NUMBER"/> <PUBLISH_RULE_ID type="CHAR"/> <MSGNODENAME type="CHAR"/> </PSCAMA> </FieldTypes> </xsl:template> </xsl:stylesheet> __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] XSL, when elements don't , Tanya S Buchanan | Thread | RE: [xsl] XSLT Simple Transformatio, Lars Huttar |
Re: [xsl] Data not displaying in HT, Wendell Piez | Date | Re: [xsl] table cell issues, J.Pietschmann |
Month |