The Sage 300 CRE Doctor is IN!

Schedule Routine Software Checkups!

Did you know that your Sage 300 Construction and Real Estate software comes equipped with its own built-in medical staff? File Doctor is a tool you’ll find in Desktop > Common Tasks computer-doctor> Tools. Just like any good medical doctor, File Doctor provides routine health checkups and cures for illness in your Sage 300 CRE data files. Unlike making a visit to your personal physician, however, there are some precautions to consider before using File Doctor.

 Preparing for Your First Visit

The good news is, you won’t have to fill out pages and pages of medical history!  You DO need to know that when you first launch File Doctor, you will be asked, “Do you have a current backup of your data files?” If the answer is no, do not continue with File Doctor! Always make a backup of the file(s) on which you intend to use File Doctor.

After you have backup up your data and relaunched File Doctor, you are able to select one or more files in either the current data folder (the one from which you launched File Doctor) or all of the data folders in your Open Company selection list. File Doctor checks every record in every file, so if you have multiple data folders and you choose all folders and all files, File Doctor could take a long time to complete. Plan accordingly! Ensure that all users have exited Sage 300 CRE and that no users will access the software before File Doctor has completed.

After selecting the data folder(s) and file(s), File Doctor will:

  • Always examine selected files and check for corruption by verifying that all records and keys are linked properly. Use this feature as often as you like to check the health of your data files and be aware of potential issues. File Doctor will require you to print to a file the printout of results. This printout should be reviewed thoroughly after File Doctor has completed.
  • Optionally reduce the amount of disk space occupied by the selected file(s). Mark the “Compact good files” checkbox to perform this task.
  • Optionally restore (fix) the selected file(s) by correcting records and keys that are not linked properly. Mark the “Fix and compact bad files” checkbox to perform this task.

Best Practices

As a best practice, whenever using File Doctor, run it first with no optional checkboxes marked to only check files for corruption, and then review the File Doctor printout to identify files that require fixing. Backup the specified files and Run File Doctor again to fix and compact only those files identified as requiring fixes. Also, File Doctor should only be used by those who have advanced knowledge of your Sage 300 CRE database. Otherwise, contact your local Sage Business Provider for assistance in using File Doctor.

Need more help with File Doctor or some private consulting time? Click below!