| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| xml to flat file using dfdl in wmb/IB v9 |
« View previous topic :: View next topic » |
| Author |
Message
|
| vdharanikota |
 Posted: Tue Oct 28, 2014 5:37 am Post subject: xml to flat file using dfdl in wmb/IB v9 |
 |
|
Novice
Joined: 07 Jul 2014
Posts: 18
|
Hi all, I have an issue while using dfdl, for transforming a message from xml to flat file.
Sample Input:
<Root>
<CreatedDate>28/10/2014</CreatedDate>
<CreatedBy>Dharanikota</CreatedBy>
<CreationId>12345</CreationId>
<CreatedFormat>pdf</CreatedFormat>
</Root>
Expected Flat File:
CreatedDate CreatedBy
28/10/2014 Dharanikota
CreationId CreatedFormat
12345 pdf
to do the above
I have created a message model in which i have used Record-Oriented text and then I opted for Create an empty DFDL schema file, I will model my data using the DFDL schema editor
In this, I have created a Message and all its local element and when I debug it using Test Serialize Model I am able to see the Tree view and XML view
Problem:
to convert the input xml message to expected flat file, I was tried some initiators as CreatedDate%LF for CreatedDate and for CreatedBy I have used %HTCreatedBy. But, I was unable to the set the appropriate properties in Delimiters Tab.
I looking for suggestions. Any suggestion or a link related to the above problem will be very helpful for me. Thanks in advance. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Oct 28, 2014 5:44 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The transformation is completely separate from the serialization and model development.
Use the DFDL Test Serialization view to develop your model, until the tree view you populate creates the correct flat file for that data.
Then develop the message flow that uses XMLNSC to parse the input message and transform the logical message tree into one that will use the DFDL model to serialize the data. |
|
| Back to top |
|
|
| akil |
| Posted: Tue Oct 28, 2014 10:30 am Post subject: |
|
|
Partisan
Joined: 27 May 2014
Posts: 338
Location: Mumbai
|
On IIB 9:
You need two models, for the XML create a schema ( message model / other XML ), and for the flat file create a DFDL.
Then create a message map, ( this is the simplest ), choosing the 2 models, the left one is the source and the right one is the destination...
_________________
Regards |
|
| Back to top |
|
|
| vdharanikota |
| Posted: Tue Oct 28, 2014 11:00 pm Post subject: |
|
|
Novice
Joined: 07 Jul 2014
Posts: 18
|
| Thank you for your replies... I'll work as per your suggestions and let you know if I have any other issues. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
