I have 2 emails coming over daily from an external system that are in excel. Currently I open them in excel and copy and paste them together to get one big file. Or I wait a couple of weeks because I hate doing this and make one huge file. Than I save as 123, and import into a notes database.How can I automate this?
Please help. I’ll send you a box of candy.
Thanks.
Subject: script gurus please assist
If you must use LotusScript, the only way that comes to mind is to change the format of the in-coming attachments to CSV and try to import them on a schedule. If the file format is beyond your control, I can’t think of a way to truly automate the process although you could certainly make it a little less painful with a little script. If you can use Java instead of LotusScript, you could try accessing & importing the files on the server by way of a Java agent and the Jakarta POI.
hth,
dgg
Subject: script gurus please assist
Brian,
It is not that hard to do. You will need to write an agent to run local or on the server - if on the server - then you might need to to have admin give you a place to detach the files.
in any case, when the email comes in, have the script detach the spreadsheet to a dircetory, then open it up with com. read each row of the spreadsheet and load up your dB.
There are examples in the sandbox on how to read an excel spreadsheet.
If you any good with script it should not take you much more than an hour or two. Naturally I don;t that much of how the import goes.
John
Subject: RE: script gurus please assist
If it is to be a server-based process, MS Excel would need to be installed on the server to use COM/OLE – most admin types will avoid that like the plague! That’s why I suggested using CSV over the proprietary Excel format.dgg