IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only
  • 1.  Logic behind generating MQ messages

    Posted 01/06/11 05:26 PM

    Originally posted by: tothiz


    Hello,

    I have to create a transformation which generates a number of MQ messages from one incoming XML file. The file looks like:

    <people_list>
    <person>
    <name>Fred Bloggs</name>
    <birthdate>2008-11-27</birthdate>
    </person>
    <person>
    <name>Jessica Shepard</name>
    <birthdate>2000-01-27</birthdate>
    </person>
    </people_list>

    I would like to create an MQ message for every "person" record.

    I've checked the example included for MQ adapter and that one works quite perfectly with the input file and generates an MQ message for every line in the file.
    My problem is that whatever I try, I get only one MQ message containing the first record.

    It would be very nice to have some documentation / pointers how is this working.
    I'm quite confused about the logic of splitting the incoming data into independent messages.

    Thank you in advance,
    Kind regards,
    Istvan
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: Logic behind generating MQ messages

    Posted 01/07/11 03:12 AM

    Originally posted by: paul.brett


    Post your input and output typetrees, and I'll have a go at the mapping.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: Logic behind generating MQ messages

    Posted 01/07/11 05:42 AM
      |   view attached

    Originally posted by: tothiz


    Here is a project from design studio.
    WTX version is 8.3.0.3.

    I also have an output card which puts data into file. I can see both records in the file (b.txt), but only one in MQ.

    Input type tree is input.mtt (generated from DTD).
    Output type tree is mq.mtt (from the example of Design Studio).

    Thanks,
    Istvan
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender

    Attachment(s)



  • 4.  Re: Logic behind generating MQ messages

    Posted 01/11/11 02:28 AM

    Originally posted by: SystemAdmin


    Hi,

    I dont have the Wtx 8.3 version but i suspect the type trees ,can you please check if ur input & output type tree record mention the range as (0:s)
    Thanks.
    Siva
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange