Where would the data for item #3 come from in an automated process? Is
the distributor ID required for processing the file? If so, that appears
to be the biggest sticking point.
Can you change the distribution method from email to FTP or HTTP? Then
you could use HTTPAPI or FTPAPI to retrieve the file and process.
Loyd Goodbar
Senior programmer/analyst
BorgWarner
TS Water Valley
662-473-5713
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Burns, Bryan
Sent: Wednesday, June 27, 2007 08:31
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
