The upload of the file is pretty simple if you have Net.data loaded or PHP
through a browser. You will also need HTTP and Apache.
Any user can upload any file to the System i with a simple pgm and CLP that
is called. As far as updating the .csv, I don't see how that can be done
automatically as it is an attachment on the email.
HTH,
Craig
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Burns, Bryan
Sent: Wednesday, June 27, 2007 9: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
midrange.com
