cancel
Showing results for 
Search instead for 
Did you mean: 

MessageTransformBean in sender JMS Adapter flat file to xml conversion

Former Member
0 Kudos

Hi All,

The scenario is MQ (Flat File ) --->PI -


>Idoc

The flat file structure is

112233

AABBCC

The expected XML Structure after using MessageTransformBean in the sender JMS adapter is

<Record>

<Row>

<f1>11</f1>

<f2>22</f2>

<f3>33</f3>

</Row>

<Row>

<f1>AA</f1>

<f2>BB</f2>

<f3>CC</f3>

</Row>

</Record>

But I am getting 2 SEPARATE xml messages each with only one Row in it like the following

1st XML:

<Record>

<Row>

<f1>11</f1>

<f2>22</f2>

<f3>33</f3>

</Row>

</Record>

2nd XML:

<Record>

<Row>

<f1>AA</f1>

<f2>BB</f2>

<f3>CC</f3>

</Row>

</Record>

I would like to have one xml message with all rows in it.It seems the MessageTransformBean is not recognizing the end of line in the flat file.Do i need to use endSeparator explicitly.

I followed the "How to use Content Conversion in JMS Adapter " and configured the adapter,still no luck..

Any Help greatly Appreciated

Thanks,

C

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

What is the convesion type r u using- xml.conversionType - SimplePlain2XML?

Have u followed the correct sequence of conf as per the help link - Check the con of simple conversion.

http://help.sap.com/saphelp_nw04/helpdata/en/24/4cad3baabd4737bab64d0201bc0c6c/content.htm

chirag

Former Member
0 Kudos

Yes, I am using the same conversion type.

I have used all the configuration steps as per the document but the sequence changes when I save and activate it,would that be the issue,I would be surprised if it is so.But then how can i change it to be same sequence?

Thanks,

C

Former Member
0 Kudos

u have to make the correct sequence it got change when u save n activate it.

chirag

Former Member
0 Kudos

Hi Chirag,

The parameter name sequence changes alphabetically by itself when I save and activate it eventhough I enter as it is in the document.How to stop changing this sequence or put it the order as required in the Module Processor.

Currently my sequence is

Transform.Class

Transform.ContentType

xml.conversionType

xml.documentName

xml.documentNamespace

xml.fieldFixedLengths

xml.fieldNames

xml.processFieldNames

xml.structureTitle

Let me know how to change the sequence ,if that is the issue.

Thanks,

C

stefan_grube
Active Contributor
0 Kudos

That sequence is not the issue.

Do you have two seperate XI messages? Then you have also two different entries in MQ.

The MessageTransformBean is not able to create split XI messages.

Or did I understand the issue wrong?