| Author |
Message
|
| kumar.shanj |
 Posted: Thu Dec 16, 2010 3:31 am Post subject: How to get output data in Excel file in Message Broker 6.0 |
 |
|
Apprentice
Joined: 18 Nov 2010
Posts: 49
|
I am using Message Broker 6.0 and this version is not having File Output node.
I want to put the output data into an Excel file.
I am clue less on how to do it.
Please help me regarding this. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Thu Dec 16, 2010 4:02 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Broker v6 goes out of support in April of next year.
Upgrade to v6.1 at least, and then use FileOutput. |
|
| Back to top |
|
|
| kumar.shanj |
| Posted: Thu Dec 16, 2010 4:05 am Post subject: |
|
|
Apprentice
Joined: 18 Nov 2010
Posts: 49
|
I cant take decision on that as of now.... they are planning for migration only aroung feb end...
Can i get any plug in node for the file output node in Message Broker v6.0?? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Dec 16, 2010 4:08 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You can easily tell them that the requirement can't be met until they migrate.
There's no mechanism to run the FileOutput node in version 6.0.
I don't believe there's a SupportPac version either.
There is no mechanism in ESQL to write out to files. That is not true of other programming options you have in Broker. |
|
| Back to top |
|
|
| broker_new |
| Posted: Thu Dec 16, 2010 4:28 am Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
try email with attachment in .csv format or use Java compute node 
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
|
| bsiggers |
| Posted: Thu Dec 16, 2010 10:25 am Post subject: Java Excel |
|
|
Acolyte
Joined: 09 Dec 2010
Posts: 53
Location: Vancouver, BC
|
Would suggest a JavaCompute node, as there are a couple of decent java-based open-source solutions to work with Excel files directly:
This one I have used previously, works fine:
http://jexcelapi.sourceforge.net/
This one I haven't worked with, but may be better supported.
http://poi.apache.org/
Of course, you can probably generate a CSV file without using these libraries, if that's what you want to do. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Dec 16, 2010 10:43 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
you could take the sample WMQ program amqsput.c and make a few simple changes (buffer size and change the open to read a supplied parameter and then to read the whole file as a single record and then send it to Broker over WMQ.
Anyone half decent in C coding could do it in under 30 minutes.
Then you have an app to stick in your dev toolbox. Want to send any form of data that could reside in a file to Broker over MQ, and there you go... The star of the show,
It is fast and quick.
Hacking some Java is not the only solution. (only saying...)
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Dec 16, 2010 11:58 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Except that kumar.shanj would like to hack amqsGET.c, not amqsPUT.c |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Dec 16, 2010 12:05 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
That is covered in Broker 'Useful Utilities 102. Due for presentation ... 04 Jan 2011'
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Dec 16, 2010 12:10 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Once it's been put by MQOutput, it's not a Broker problem any more.
There's more than one reason MQ FTE has been augmented to handle File->Queue/Queue->File... |
|
| Back to top |
|
|
| billybong |
| Posted: Tue Dec 21, 2010 4:01 am Post subject: |
|
|
Disciple
Joined: 22 Jul 2005
Posts: 150
Location: Stockholm, Sweden
|
I get fond memories of my days as a junior integration developer when I used some open source Excel ODBC adapter to integrate to excel, treating the file as a database.
It actually turned out quite well, each book would be a table, and you did get row queries etc.
Might be an option? Probably depends on the complexity of your excel integration.
But I heavily suggest a csv file based integration instead to minimize your moving parts.
_________________
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Integration Developer V6.0
IBM Certified System Administrator - WebSphere MQ V6.0
IBM Certified Solution Developer - WebSphere DataPower |
|
| Back to top |
|
|
|
|
