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
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.
[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
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.
----- Mensagem Original -----
De: Bob Derdak <bderdak@xxxxxxxxxxxx>
Enviada: 5 de dezembro de 2008 18:11
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.