Re: [BPCS-L] Electronic Data Transfer

[KASP6281@xxxxxxx]

I am assuming that you are using Client Access or Net Soft or Power Term or 
some emulation package with and download and upload capability.

1.  Create a query for each of the files that you would like to create an 
upload file to represent.  This is best done with a separate library such as 
UPLOAD or IMPORT or FILES or something that represents your file uploads.

2.  The query should be for one record from each of the files that you want 
to load electronically.  Send the output of the query to the file such as IIMUP 
or RCMUP.

3.  There is a download function in the emulator and you should download the 
file from that library to the PC.  I typically like to download the file using 
the .CSV file format.  I don't include the file name extension though simply 
downloading the file as IIMUP for example.

4.  You can open the file up by importing it is a delimited file using a "," 
as the delimiter.

5.  Copy and past the data for each field into the file you opened up and 
save the file as the .csv format.  By far, the most common mistake is not 
having 
the correct data in the file.  For example, you load a numeric field with 
alpha data or the alpha field holds 6 characters and you try to add 8 
characters.  
These problems will always lead to a problem uploading the data.  Be careful.

6.  Rename the file to drop the .csv file extension.

7.  Create the upload to replace the one record query result in the library 
on the AS/400.

8.  Run some tests on the data to see that the data is good (eg. the item 
master has item class AA and there is an item class AA setup.

9.  Copy the data into a test library and randomly open records to see if the 
edit programs catch something wrong.

10.  Once all the data appears to be justified, copy to the live environment.

Good luck.


John Kasper
J.D. Kasper & Associates, Inc.
(847) 529-1099
KASP6281@xxxxxxx