| Author |
Message
|
| Thiagu |
 Posted: Mon Feb 10, 2003 7:15 pm Post subject: Conversion through MSQI |
 |
|
Newbie
Joined: 10 Feb 2003
Posts: 3
|
Hi, I am new to MQSI. I need very urgent help regarding data conversion through mqsi. I have Excel file in one system in which i need to pick the some of the data from the excel file and update into other system. Presently we are doing manually. Could you please suggest me that how to do the data conversion through MQSI.
Thanks in Advance
with regards
Thiagu |
|
| Back to top |
|
 |
| yaakovd |
| Posted: Tue Feb 11, 2003 4:34 am Post subject: |
|
|
Partisan
Joined: 20 Jan 2003
Posts: 319
Location: Israel
|
MQSI should to be able to "understand" your input format.
For example, if you can convert xls file to txt format like:
1 2 3 4
a b c d
qw we wt jh
then you can use MRM or NEON formatter for parsing and creation of output message.
Other option - export xls file into MQ SQL Server DB adn update data using MQSI DataBase nodes(it can be simply than Oracle or DB2, but supported fot MQSI on WIN NT or WIN 2000 only).
I don't heard about direct update of Excel file using MQSI.
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel |
|
| Back to top |
|
|
| wmqiguy |
| Posted: Tue Feb 11, 2003 7:20 am Post subject: |
|
|
Centurion
Joined: 09 Oct 2002
Posts: 145
Location: Florida
|
You can save your Excel spreadsheet as a comma delimited file. Then go from there. You will then have some planning framed around how big your file is. Do you want to:
1. Try and process the whole file (if small) as one message or,
2. Try and break each row into a message and then insert each one separately.
Hope this gets you started...Good Luck! 
Todd |
|
| Back to top |
|
|
| Yanghui |
| Posted: Wed Feb 12, 2003 3:44 am Post subject: |
|
|
Disciple
Joined: 08 May 2002
Posts: 151
Location: Dublin, Ireland
|
I wrote one pair of MS Excel MQ Adaptors by using Macro. On the sender side, one button within spreadsheet can trigger to send the data within the spreadsheet as a message on MQ queue. The msg would be delivered to other side of MQ world. On the receiver side, another Excel button can trigger to pick up the msg to do Excel file update. If you have data conversion or enrichment between the sender and receiver, then MQSI can be employed to achieve this easily.
Regards
-Yanghui |
|
| Back to top |
|
|
| Thiagu |
| Posted: Thu Feb 13, 2003 7:22 pm Post subject: Conversion through MSQI |
|
|
Newbie
Joined: 10 Feb 2003
Posts: 3
|
Hi, Thanks to all. I have converted the excel file to txt file. The excel file which has 20 rows and 10 columns. I have to pick up all the rows but only few columns.
Yaakov, as per your suggestion which one is better way to pick up the values either MRM or NEON format and pls explain me in detail how to do that.
Thanks in Advance
Thiagu |
|
| Back to top |
|
|
| yaakovd |
| Posted: Fri Feb 14, 2003 2:39 am Post subject: |
|
|
Partisan
Joined: 20 Jan 2003
Posts: 319
Location: Israel
|
It little big piece of information for one topic 
For example, if you use NEON formatter:
My assumption that all lines will have same format.
Create fields as number of columns in each row.
Create literals: delimiter A for each line (end line 0d0a), delimiter B for each field (may be you can define fixed lemgth?)
I think Excel create "tab" delimited file (?), but last field will be without delimiter.
Input controls delimited with A and B.
Simple input flat format will contain fields for one row.
Compound format will contain your simple format (repeating).
Try to define your text format as fixed (length, delimiters etc) as possible.
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel |
|
| Back to top |
|
|
|
|
