Customer Database Repair Utility
CusFix 6.00

Last edited: December 15, 2003 08:07 AM

CusFix is designed to recover valid records located within a corrupted customer database file. It will then automatically reindex the index files and purge the customer order file if necessary. It does not check the content of individual fields but assumes a valid record when the length of the record is correct. CusFix is intended for use in-house or by a qualified computer technician. It should not be given to an end user or installed on their system. CusFix will run with either version 5 or version 6 applications.
Syntax

CUSFIX {/DEBUG}

    *      /DEBUG – Primarily designed for in-house troubleshooting, this replaces normal video output with record information.

Technical Information

CusFix first renames CUSTOMER.DAT as CUSTOMER.001. It then does the same with the index files. If an 001 file already exists it will be erased. For this reason it is recommended that a backup be made of the customer data files prior to running this utility, as multiple iterations will erase the original files.The database is then read sequentially, using the twin pipe characters (||) to locate the beginning and end of each record. If the record length is 357 bytes, the record is assumed to be valid and is kept. Otherwise, the data is written to CUSTOMER.BAD, where the data can be reviewed for fragments of valid data.

When the database has been rebuilt, it is then reindexed using the same subroutines as used by Customer Manager. Since there is no way to verify the validity of the last order file(CUSORDER.DAT), it is purged; again using the same subroutines as used by Customer Manager. As a safety, this purging will only occur if bad records are found.