| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| xml to csv format |
« View previous topic :: View next topic » |
| Author |
Message
|
| hornbeam123 |
 Posted: Wed Apr 07, 2004 1:31 pm Post subject: xml to csv format |
 |
|
Centurion
Joined: 01 Nov 2003
Posts: 101
|
 Looking for some tips please on how to achieve XML input to CSV (comma separated varibles) output transformation under Mqsi 2.1. The xml message does not have rfh2. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Apr 07, 2004 1:37 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Umm. Can you be more specific?
Because otherwise I'm going to have to answer "Using the MRM and ESQL."
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| hornbeam123 |
| Posted: Thu Apr 08, 2004 12:26 am Post subject: xml to csv format |
|
|
Centurion
Joined: 01 Nov 2003
Posts: 101
|
Jeff,
Thanks for your reply.
Ok i'd assumed mrm and esql but how what do you define in the mrm apart from the xml input. Can you use tdwf features? How do you remove the tags for the output. Need some pointers on approach, techniques etc. Fairly new to this black art. |
|
| Back to top |
|
|
| kimbert |
| Posted: Thu Apr 08, 2004 3:53 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
The lack of an RFH2 header is not a problem - you can put the information into the MQInput node properties. If you are not changing the data (just the format), you can even get away without using any ESQL - you can just use a ResetContentDescriptor (RCD) node.
You will need to:
a) model your message (or import the DTD/Schema which describes it). This will give you a logical message model.
b) add two physical formats to the message set which you created in a). An XML physical format to describe the input, and a TDS physical format to describe the output. You'll probably find that the default XML settings are correct, but the TDS settings need some work.
c) create a message flow containing an MQInput node, an RCD node and an MQOutput node. The MQInput node propertes should specify the domain (MRM) message set and message format (XML). The message type does not need to be specified - it will be deduced by the MRM XML parser (it looks at the root tag in the input document).
Let me know if you need help with the TDS settings. I'll probably need more info on the exact structure of the your message for that, though. |
|
| Back to top |
|
|
| hornbeam123 |
| Posted: Thu Apr 08, 2004 8:23 am Post subject: xml to csv format |
|
|
Centurion
Joined: 01 Nov 2003
Posts: 101
|
Kimbert,
Excellent.
Something to get teeth into after the Easter break.
Will talk again I expect next week.
Many thanks.
Hornbeam123 |
|
| 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
|
|
|
|
