Home → EstiMate Version 2 → Error Messages → Error: Duplicate Index Value

4.9. Error: Duplicate Index Value

Q:  I just updated to the latest build and now when I click on New EstiMate I get an error message that says "Duplicate Index Value".  How can I fix this?

 

A:  This error means that somewhere in your database you have a duplicate entry.  It might be a material, tax, or a customer.  EstiMate 2 should not allow you to create duplicate entries, but it's possible that it happened in an earlier build of the software or possibly in your EstiMate 1 software.  EstiMate 2 now has a feature called the EstiMate Health Check which will allow you to make a backup of your data and then find and rename the duplicate entry. 

 

Here are the instructions for using the EstiMate Health Check utility:

• To use this utility you must be in single user mode.  To switch to single user mode click the EstiMate icon in the upper left and select "Switch to Single User Mode".

• Once you are in Single User Mode hold down the "Shift" key on your computer keyboard and again click on the EstiMate icon in the upper left.

• You will now see an option at the bottom of this menu called EstiMate Health Check.  Click on this option and the EstiMate Health Check window will appear.

• If you do not have a current backup of your data then you will want to make one here before you run the check.

• Click the "Backup Now" button on this screen and then when the Backup/Restore window comes up click the "Backup" button on that screen.

• Choose where you would like to save the file (e.g. Desktop, My Documents), give the backup a filename, and then click Save.

• Once your data is backed up you can click close on the Backup/Restore window.

• Now that you've made a backup you can click the "Click Here To Preform This Repair" button under the Duplicate Index Value Repair Tool tab.
  

• The utility will now run and it will show you the status of what it finds.  Any duplicates that it finds will get the number "2" added to the end of the name.  If you have lots of duplicates you can copy the text from this window and paste it into a document for future reference.

• Now that the tool has found and renamed the duplicates (remember the duplicates have the number 2 at the end of their name) you can change those items in you jobs and estimates to the original entry (i.e. name, material, etc).  You don't have to do this all at once, but if you want to delete the duplicates from the system you'll want to make sure you've changed them all back to the original first.