Re: Automate upload of Excel data

Who gets the e-mail? Could you have your network guy make a share on that user's PC for a directory on the so they could do a drag 'n drop to the IFS on the System i, or do a save to that directory?

Then, writing an RPG program to read that csv file directly and add the distributor ID at that point is not a big deal. (I am guessing that the distributor ID does not vary and can be processed as a constant?)

Burns, Bryan wrote:

The data is coming from a big gorilla of a customer as a email attachment and I
don't know if we can require them to use FTP of HTTP.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
lgoodbar@xxxxxxxxxxxxxx
Sent: Wednesday, June 27, 2007 9:54 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Automate upload of Excel data


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?