IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
 View Only
  • 1.  WTX XmL Query

    Posted Tue October 09, 2007 09:56 AM

    Originally posted by: SystemAdmin


    Problem summary: - Extracting structured information from the xml tag element.

    Problem scenario: -
    1. Input received in xml file, this contains Swift transaction with in the xml element <Payload>

    Example: -
    <?xml version="1.0" encoding="utf-8"?><Request><Payload>{1:F01PBNKDEFTXTIC0000000000}{2:O1031224060705POFICHBTXTIC00000082020000000000N}{3:{108:060705DE0007}{901:EUR} {902:060707}{903:20}{904:SHA}}{4:
    :20:060705DE00070001
    :23B:CRED
    :32A:060707EUR0,74
    :33B:CHF1,1
    :36:1,4865
    :50K:/700047901
    LARDELLI LORENZO
    PFAFFIKON SZ
    :53A:PBNKDEFT
    :57D:/198
    :59:EMPFANGER NAME
    9999 EMPFANGER ORT
    :70:MITTEILUNGSZEILE-1
    MITTEILUNGSZEILE-2
    :71A:SHA
    -}{5:{NOM:1}{TOT:2,24}{MAC:00000000}{PDF:0}}</Payload></ Request>

    2. I need to formulate a structured xml using the elements in the xml and the transaction in <Payload>.
    3. The type tree for the transaction in <Payload> tag is available.
    4. I modified the property of Payload to be of group type and added the type tree for the transaction in the payload group type.
    5. For Payload group type literal <Payload> is specified as initiator and </Payload> as the terminator in the properties.
    6. But I am not able to extract the structured information from the transaction (For example LtAddress in block 1 of the transaction); I tried extracting it and writing it to a file.

    Please provide your inputs for the above.

    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 2.  Re: WTX XmL Query

    Posted Wed October 10, 2007 08:39 AM

    Originally posted by: SystemAdmin


    AshUK - can you contact me please?
    Thx,
    DavePage
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: WTX XmL Query

    Posted Wed October 10, 2007 10:28 AM

    Originally posted by: SystemAdmin


    Hi Dave,
    Thanks for the help,I got on this forum.
    I am working on some of the options that were given here and hope I am able to achieve the task.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 4.  Re: WTX XmL Query

    Posted Wed February 20, 2013 10:53 PM

    Originally posted by: SystemAdmin


    Hi

    Can you please provide the solution or link to the above problem.

    Even i too have a same problem. I need to extract the swift message payload elements into separate variables through WTX by creating the type tree's of the same structure. Is it possible to create type tree for swift messages without PACS.

    thanks
    sathish
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender