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 are 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: 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. In order to maintain an audit trail of the updates, make sure that you save this file in an archive directory.

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. It is unnecessary for you to remove the error information written in the last column, because the load ignores it.

Important: Save the file with a CSV format. Do not save it as an Excel workbook, or the load function is not able to use it.

Make sure that you store copies of the success and error files with meaningful names on a local drive or accessible file share, because these files can be useful for auditing at a later time. And also make sure that procedures are in place to back up the files.