- This topic has 0 replies, 1 voice, and was last updated 19 years ago by
.
-
Posts
-
Customer Database Purge Utility
CusPurge 4.01Last edited: December 15, 2003 08:07 AM
This utility is for use with version 4 customer databases. It is a more convenient way to purge records than deleting them one at a time. Additionally, it can be used when CUS_MGR errors out when the number of customers exceeds 12,000. CusPurge is NOT a customer database repair utility.
CUSPURGE {/DAYS=x} {/DEBUG}
* /DAYS= x where x is the number of days back to preserve the data. For example /DAYS=365 will save data back one year. If this switch is omitted, a default of two years is used.
* /DEBUG – Primarily designed for in-house troubleshooting, this replaces normal video output with record information.Technical Information
CusPurge first renames the DAT files as 001 file, then rebuilds the DAT files using only records that are to be kept. If CusPurge errors out, the original database can be rebuilt by copying the 001 files back to DAT files. If CusPurge errors out twice with no restore of the 001 files, this backup is lost. For this reason, CusPurge should be done only by trained personnel and only after a separate backup of the original DAT files has been made.
CusPurge purges any records that do not have an account number. Additionally, it will purge any records that have a last order date that is more than two years old or as specified by the /DAYS= switch. If there is no last order date, the record will not be purged. CusPurge can selectively purge customer databases up to 32,766 records. Any records beyond that are automatically purged.
Revisions9/22/98 4.01
Added /DAYS= command line switch to allow the user to define a range of other than two years for the Last Order Date.
- You must be logged in to reply to this topic.