| Author |
Message
|
| praneethm29 |
 Posted: Mon Mar 31, 2008 3:57 pm Post subject: starter: help on creating a message set to convert xl to xml |
 |
|
Newbie
Joined: 31 Mar 2008
Posts: 5
|
guys, I've just started of with the message broker and need to develop a flow to convert xl spread sheet to an xml format.....can anyone help me on this.....Thanks a ton....
...praneeth |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Mon Mar 31, 2008 7:54 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
One Question: 
How you are getting/extracting the message from Excel Spread sheet to Broker?
Answer this to us, then we will look in to rest of the part. 
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| praneethm29 |
| Posted: Mon Mar 31, 2008 8:28 pm Post subject: |
|
|
Newbie
Joined: 31 Mar 2008
Posts: 5
|
| Gaya3 wrote: |
One Question:
How you are getting/extracting the message from Excel Spread sheet to Broker?
Answer this to us, then we will look in to rest of the part.
Regards
Gayathri |
I have configured an ESB connector to pick the file up from a file system and place it in an mq node.
Regards
Praneeth |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Mon Mar 31, 2008 8:40 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
how the message looking like or message format in the queue now.
regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| praneethm29 |
| Posted: Tue Apr 01, 2008 12:17 am Post subject: |
|
|
Newbie
Joined: 31 Mar 2008
Posts: 5
|
i still did not get the xml message in to the queue but was wondering if I could parse the message as BLOB and do the required things in the compute nodes....
Regards
Praneeth |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue Apr 01, 2008 12:23 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| praneethm29 wrote: |
i still did not get the xml message in to the queue but was wondering if I could parse the message as BLOB and do the required things in the compute nodes....
|
Parsing in to blob is also fine, but
Why you are not getting XML messaeges in to the queue?
Did you configure it properly well ?
which tool you are using for transformation, confused by stating the point ESB connector and Broker later.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| praneethm29 |
| Posted: Tue Apr 01, 2008 1:07 am Post subject: |
|
|
Newbie
Joined: 31 Mar 2008
Posts: 5
|
Hi Gayatri,
I still did not try to get the message into the queue....the mechanism to get it by configuring the ESB connector has already been tested for other interfaces in the project i just joined...so that should'nt be a problem...so the issue I had was to parse the message into the input node of the broker using a Message set or BLOB( which i thought was a bit simpler from a very minimal knowledge i have)......after that i could convert into xml using java compute node using some java classes....is my approach a correct one.....
Thanks
Praneeth |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Apr 01, 2008 1:52 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
  
This is a basic transformation. You should use a message set, based on the CSV sample.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
