We don't use NetServer but if it streamlines things then I will.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[
mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Paul Nelson
Sent: Wednesday, June 27, 2007 10:00 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Automate upload of Excel data
Why use Client Access at all? Create a share via Netserver/iNav and let the
user save the csv file into that directory. Your System i app can get it
from there.
Paul Nelson
Cell 708-670-6978
Office 708-425-4198
nelsonp@xxxxxxxxxxxxx
-----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?
midrange.com
