Review Logs and Correct Errors

The load process creates three files on the server:

•	customers.csv contains the records exported from QAD EA.

•	customersuccess.csv contains the records last loaded successfully into QAD CSS.

•	customererror.csv contains the records that failed during the last load into QAD CSS.

These three files should be considered temporary. The customers.csv file is either overwritten or appended to, depending on your selection during the load. The error and success files are always overwritten during the next load.

Note: You should institute procedures for backing up and managing the files you save locally and update with additional QAD CSS information.

Use the Successfully Loaded link to view the customersuccess.csv file—displayed with Microsoft Excel—that contains all the records successfully added or updated in QAD CSS. You should save this file in an archive directory to maintain an audit trail of the updates.

Use the Failed Records link to view the records that were not loaded (customererror.csv). The last data column indicates the reason for the failure.

You can save this file in a work area and correct the data that caused errors. Then use Customer Load to reprocess the corrected records. You do not need to remove the error information written in the last column; it is ignored by the load.

Important: You must save the file with a CSV format. Do not save it as an Excel workbook or the load function will not be able to use it.

You should store copies of the success and error files with meaningful names on a local drive or accessible file share. These files may be useful for auditing at a later time. You should ensure that procedures are in place to back up the files.