ITSS applications are built using DBF data-base files . These are normally located on a central server and shared by users of the application. If the server is powered down or crashes while users have these files open , this may lead to corruption of the data files. This will be listed in the error log as for example

1) h:\xyzapp\data\campaigns.dbf is not a table
2) Memo file h:\xyzapp\data\campaigns.fpt is missing or is invalid
3) h:\xyzapp\data\campaigns.dbf has become corrupted. The table will need to be repaired before using again
4) Error loading file - record number 10. Formset <or one of its members>. Parent : Structural .CDX file is not found
5) h:\xyzapp\data\campaigns.dbf , Index does not match the table. Delete the index file and re-create the index

In most cases, ITS will connect in remotely and do the file repair, but in the unlikely event of ITS not being available, the following steps can be carried out by any PC-aware person

1) Using any standard FTP client e.g. FileZilla, connect to    https://fm.ols18.com  user ittsuser  password hello

2) Go to folder FILEFIX . Download the 3 files,  filefix.exe, filefix.dbf and filefix.fpt   The folder from where you run your main ITS exe program is the most convenient target location.

b) In the case of situations 1,2,3 above, run FILEFIX, select the damaged file and repair using basic recovery. Retry the application, if there is still the same error, try extended recovery as described below.

c) In the case of 4,5 above it is necessary to use extended recovery. This requires a definition file pair rebuild.dbf / fpt to exist in the same folder as the damaged file. This definition file is pre-built from the latest ITS program details and must also be downloaded from https://fm.ols18.com.   Locate your site / folder ( that corresponds to the folder containing the damaged file ) and download both files  into the folder that contains the damaged file  Then run FILEFIX with extended recovery ticked.

The information contained in rebuild.dbf does NOT hold any data, only some layout details , so to avoid passwording complications all user sites are just listed as is.

d) In some cases ( e.g. case 4 above )  , the file name may not be explicitly given. In that case, use the folder option in FILEFIX to detect any damaged files. The data folder is generally just below the main exe folder but in some cases you may need to do a little file exploration. Then repair any files that are reported as damaged, using the options above.

e) If the error is (5) above, you need to locate the file e.g. h:\xyzapp\data\campaigns.dbf and delete it's associated index file h:\xyzapp\data\campaigns.cdx. Then run FILEFIX on h:\xyzapp\data\campaigns.dbf with the extended option selected.