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