Re: Downloading and uploading to ESP or CMF table

Use Client Access Data Transfer From Iseries to download the file first.
Make sure there is at least one record in the file. Save the downloaded file
with an .xls extension. Save, under the PC settings, Output device, put
file. Then click details. At the top, I use BIFF8(MS Excel 8), and at
bottom, pc description file, save to your desktop(I use a folder) as a FDF.
I name the .xls and the .fdf the same, and that is the file name. By placing
them in a folder, it is easy for me to upload/download data and reuse the
definitions.

Then, you can clear the file, but leave the headings(field names will be
displayed). I usually wait to clear the .xls file(or leave 1 record) till I
paste my data, that way I see all fields that need to be updated, such as
time/date stamps, etc..and shows you the format of the data.

If you were just going to change data, open in Excel, update and then save.

Then, do a Client Access Transfer TO the Iseries. For the file, browse to
your folder, select the xxx.xls file that you changed/updated/replaced.
Enter the system name, then LIBRARY/XXX(XXX) where XXX is the file name.
Click details, then put a check in Use PC file desc, and point this to your
FDF. Leave translate as ASCII. Then you need to select , from the Create
Iseries Object, either No,append to existing member( to add new records and
leave the existing ones) or No, replace member only(to clear the member
before loading your new records.Then click Transfer.


Jim



-----Original Message-----
From: bpcs-l-bounces+jmergen=pctcnet.net@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+jmergen=pctcnet.net@xxxxxxxxxxxx] On Behalf Of Renato
Sent: Friday, December 05, 2008 3:13 PM
To: BPCS ERP System
Subject: Re: [BPCS-L] Downloading and uploading to ESP or CMF table

Hi Bob,
The process is easy.
You should do a download throught client access with excel output format
creating a .fdf file also.
After that you could change this spreadshet and save as .xls format.
To upload the excel file you should use the ca/400 also using the .fdf file
only the details configuration.
I recommend that you create a copy table from each file on your private
library first to be able to upload the excel file.
Regards

----- Mensagem Original -----
De: Bob Derdak <bderdak@xxxxxxxxxxxx>
Enviada: 5 de dezembro de 2008 18:11
Para: BPCS-L@xxxxxxxxxxxx
Assunto: [BPCS-L] Downloading and uploading to ESP or CMF table

Does anyone have experience with downloading a table, ESP or CMF, into
EXCEL, changing values and then uploading table back onto the AS400? Can
the upload append data (add to)? With thousands of unique prices and costs
it is very time consuming to rekey data.



We use BPCS version 4.0 Release 2.



Bob Derdak

bderdak@xxxxxxxxxxxx