web stats
Mirth Community - View Single Post - Excel As Data Source
View Single Post
Old 05-25-2011, 07:14 AM
marmanold marmanold is offline
Mirth Newb
Join Date: Feb 2011
Location: Franklin, TN
Posts: 9
marmanold is on a distinguished road

The javascript is written to be generic. You can provide it with any Excel (.xls only) file and it will read in all the data on the first worksheet.

You shouldn't put any data in the inbound message template. It is simply the template used for the transformer in your destinations. You will put a <coln></coln> tag for each column used in your Excel report. Because this is read in as an array it's zero-based, so you start counting at zero. (E.g., column one is <col0></col0>, column two is <col1></col1>, etc.)

I can tell you that the Java library is a little memory/processor intensive. I was hitting 250MB memory used and 50% processor used while it was processing. I would say it took about five minutes or so to read my 319KB Excel file with about 500 rows.
Michael Arnold| Electronic Data Interchange Specialist

PlayMaker CRM
Sales Innovation for Home Care
A Division of The ADAM Group
115 Southeast Parkway Court | Franklin, TN 37064
866.930.6847 | F: 866.232.6470 | PlayMakerCRM.com
Reply With Quote