Topic
3 replies Latest Post - ‏2013-02-21T03:53:03Z by SystemAdmin
SystemAdmin
SystemAdmin
6184 Posts
ACCEPTED ANSWER

Pinned topic WTX XmL Query

‏2007-10-09T13:55:57Z |
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.
Updated on 2013-02-21T03:53:03Z at 2013-02-21T03:53:03Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    6184 Posts
    ACCEPTED ANSWER

    Re: WTX XmL Query

    ‏2007-10-10T12:39:27Z  in response to SystemAdmin
    AshUK - can you contact me please?
    Thx,
    DavePage
    • SystemAdmin
      SystemAdmin
      6184 Posts
      ACCEPTED ANSWER

      Re: WTX XmL Query

      ‏2007-10-10T14:28:09Z  in response to 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.
      • SystemAdmin
        SystemAdmin
        6184 Posts
        ACCEPTED ANSWER

        Re: WTX XmL Query

        ‏2013-02-21T03:53:03Z  in response to 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