ADV: index checking program
Richard Kreiss
rkreiss at gccconsulting.net
Sun Sep 10 18:39:07 PDT 2017
I have written a routine which will compare the information in the fpidxdat file with the file's map. A report of all mismatched is generated.
The report will only point out where a difference occurs. The decision as o whether this is a mistake that needs correcting or an intentional index length is up to the individual.
Possible reasons for difference:
1. Fpidxdat not update after a change in field size
2. Index for a file missed after adjusting field size
3. Intentionally using a smaller sort size when building index - (i.e. first 3 characters of a zip code)
4. Intentionally using a larger sort size (spanning 2 adjacent fields)
Just some of the possible reasons for an error.
I am supplying this program free to anyone interested.
This is written for a windows system and therefore would need to be renamed to run on a *nix system.
As of now the report generated is using filePro's PDF output option. This can easily be changed to generate a printed report or even a CSV file.
One caveat, as of now the program does not handle using associated fields.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 17808 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170911/b7f1dce9/attachment.bin>
More information about the Filepro-list
mailing list