[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Conversions for PeopleSoft input

Subject: RE: Conversions for PeopleSoft input
From: "Michael Kay" <mhk@xxxxxxxxx>
Date: Tue, 11 Mar 2003 10:50:46 -0000
peoplesoft substring
The most likely explanation, without seeing your code, is that EndDate
is not a child of the context node at the point where you do this
computation.

Michael Kay
Software AG
home: Michael.H.Kay@xxxxxxxxxxxx
work: Michael.Kay@xxxxxxxxxxxxxx 

> -----Original Message-----
> From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx 
> [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of 
> Shoe, Bridget
> Sent: 10 March 2003 20:46
> To: 'xsl-list@xxxxxxxxxxxxxxxxxxxxxx'
> Subject: RE:  Conversions for PeopleSoft input
> 
> 
> EndDate is a element in the input. It's all very large, so 
> I've cut some of it out...
> 
> Input data looks like this
> 
> <?xml version="1.0"?>
> <AsyncRequest>
>   <data PsNonXml="Yes">
>     <![CDATA[<SiebelMessage
>  MessageId=""
>  MessageType="Integration Object"
>  IntObjectName="Quote">
> <SiebelQuote>
> <Quote>
> <QuoteNumber>1-D5G2O</QuoteNumber>
> <Revision>1</Revision>
> <EndDate>02/06/2003 00:00:00</EndDate> 
> <CurrencyCode>USD</CurrencyCode> <PaymentTerm></PaymentTerm> 
> <CountryofInstallation>United Kingdom</CountryofInstallation> 
> ... Lots of additional fields/nodes <QuoteItems> <QuoteItem> 
> <LineNumber>1</LineNumber> <PartNumber>0074060079</PartNumber>
> <ItemPrice>19.53</ItemPrice>
> <Quantity>1</Quantity>
> <UnitofMeasure>Each</UnitofMeasure>
> </QuoteItem>
> <QuoteItem>
> <LineNumber>2</LineNumber>
> <PartNumber>0074060079</PartNumber>
> <ItemPrice>20.53</ItemPrice>
> <Quantity>1</Quantity>
> <UnitofMeasure>Each</UnitofMeasure>
> </QuoteItem>
> ....
> </QuoteItems>
> </Quote>
> </SiebelQuote>
> </SiebelMessage>
> ]]>
>   </data>
> </AsyncRequest>
> 
> -----Original Message-----
> From: David N Bertoni/Cambridge/IBM 
> [mailto:david_n_bertoni@xxxxxxxxxx]
> Sent: Monday, March 10, 
> 2003 3:09 PM
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: Re:  Conversions for PeopleSoft input
> 
> 
> 
> 
> 
> 
> > Hi,
> >            Can someone tell me why this does not work?  I 
> am trying to 
> > convert the date from a Siebel format to a PeopleSoft format.
> >
> > Input data is date in format:  MM/DD/YYYY HH:MM:SS
> > i.e: 02/06/2003 00:00:00
> >
> > I need the output as YYYY-MM-DD
> >
> > XSLT that I am trying to use to transform this is:
> >
> > <QUOTE_DUE_DATE><xsl:value-of 
> select="concat(substring(EndDate, 7, 4),
> '-',
> > substring(EndDate, 1, 2), '-', substring(EndDate, 4, 2))"/>
> >                                                </QUOTE_DUE_DATE>
> 
> It would help if you gave us more information.  For example, 
> what does the input data look like?  Is EndDate an element in 
> the input XML, does it contain the correct string, and is it 
> a child of the current node?  Or perhaps EndDate is a 
> variable, and you simply forgot the '$' character?
> 
> <QUOTE_DUE_DATE>
>   <xsl:value-of select="concat(substring($EndDate, 7, 4), 
> '-', substring($EndDate, 1, 2), '-', substring($EndDate, 4, 
> 2))"/> </QUOTE_DUE_DATE>
> 
> Dave
> 
> 
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> 
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> 


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.