If you are willing to roll your own, java can do it all quite easily. If you
would rather use RPG...
1. Getting the email. Look at pop3read at www.easy400.net or several places
that have wrapped the javamail APIs.
2. Copy the attachement out of the email to a file. With pop3read, the email
is copied to the IFS.
3. Once it is in a file, filling the additional field should be easy enough.
4. It is already on the iSeries--ready to pass on to some other program.
If you are rolling your own and the file is an excel file, you might want to
look at POI. Scott Klement did several stories with code and prototypes of
how to use. Start here
http://www.systeminetwork.com/provipcenter/index.cfm?fuseaction=ShowNewslett
erIssue&ID=17839.
Mike
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Burns, Bryan
Sent: Wednesday, June 27, 2007 8:31 AM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: Automate upload of Excel data
I've been asked to automate the manual process of uploading a file and I'd
like some suggestions. I've done some searching but can't find the exact
process I'm looking for. I've found a lot on loading Excel with iSeries
data but we want to do the reverse. We want to upload an Excel spreadsheet
to the iseries automatically.
The current process is to
1. open a Microsoft Outlook email
2. open the Excel CSV spreadsheet attachment that's part of the email 3.
alter the spreadsheet by adding a column and filling the column with a
distributor ID 4. upload the CSV file data to the iSeries using a saved
Client Access Transfer function
Is there a third party application that can perform 1, 2 and 3? Can item 4
be performed with a CLP?
Thanks in advance,
Bryan Burns
IBM Certified Specialist - iSeries System Command Operations V5R2 M.I.S.
Department ECHO, Incorporated www.echo-usa.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
