| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Converting XMLNSC Domain Msg to CSV format |
« View previous topic :: View next topic » |
| Author |
Message
|
| JohnSmith |
 Posted: Wed Mar 17, 2010 7:14 am Post subject: Converting XMLNSC Domain Msg to CSV format |
 |
|
Voyager
Joined: 17 Mar 2010
Posts: 86
|
Hello Every1,
I have recently joined this forum, really glad to be here. I am working on Message Broker and MQ for the last 1 year. I am facing an issue while converting an XML file into CSV file.
Although I have been through samples and which tells exactly how to convert these 2 formats to each other, but I have a bit complex scenario.
I am generating my XML message using JavaCompute node which is generating a message with XMLNSC domain. I have tried the below 2 method to convert it into CSV format and writing it into the queue.
Method1 : Use the Compute node as shown in the samples, set the Message Set, Message Format and Message Type to the values as per CSV message set I have.The only difference between my scenarios and Samples is that the sample doesnt start with XMLNSC, whereas my message tree start with XMLNSC.
Method2. Use the ResetContentDescriptor Node where i have Reset the Message Domain(to MRM), Message Set(CSV), Message Type(CSV) and the message format(again CSV).
But , when I see the output message in the queue, it comes in the XML format and not in CSV format.
As I highlighted above, the only problem I believe is that my message tree starts with XMLNSC.
Guide me please.
John |
|
| Back to top |
|
 |
| kimbert |
| Posted: Wed Mar 17, 2010 7:33 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
I guess the samples use MRM XML on the input side of the message flow?
( that's not good practice, actually. ).
If my guess is correct, then the code which copies from InputRoot to OutputRoot needs to be adjusted very slightly. The MRM parser does not create a root node in the message tree to represent the document. All other parsers do. When copying from InputRoot.XMLNSC to OutputRoot.MRM, you need to copy InputRoot.XMLNSC.<root tag name>, rather than InputRoot.XMLNSC.
If my guess is wrong, I suggest that you take a user trace. It's not a scary thing, and it does show you exactly what the message flow is doing. |
|
| Back to top |
|
|
| JohnSmith |
| Posted: Wed Mar 17, 2010 9:41 pm Post subject: |
|
|
Voyager
Joined: 17 Mar 2010
Posts: 86
|
Kimbert wrote:
| Quote: |
| When copying from InputRoot.XMLNSC to OutputRoot.MRM, you need to copy InputRoot.XMLNSC.<root tag name>, rather than InputRoot.XMLNSC |
Thanks Kimbert, it works  |
|
| 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
|
|
|
|
