Find Duplicate Appliance Id's

If you have imported one SimplyPats file into another, or have had to test the same appliance several times you may end up with several duplicate appliance id' in your file. This may also happen if you are testing on a client site where some appliance have a short retest period, e.g. hand tools on a building site, and you are trying to maintain a current complete asset register for your customer. You can quickly see which duplicated appliances you have by using the "Find Duplicates" option from the "Records Menu" will bring up the screen shown above, or by clicking on the Find Duplicates button from the main toolbar. See Also - The Toolbar

The find duplicates screen lists all the appliances with more than one test. On the left is the Newest Occurence of that appliance and on the right is the next newest occurence of that appliance. (If there are more than 2 occurences of the appliance they are not shown, so after deleting one of your duplicates you may need to run this screen again, however SimplyPats will remind you to do this if it finds 3 or more occurences of the same appliance.)

Count Of Duplicated Appliance Id's

The Cnt column shows a count of how many occurences of the Appliance Id have been found.

Failed Appliances

The Status column shows whether the appliance has passed or failed overall and is highlighted Red in the case of a fail. This is handy for example if you have tested an appliance twice because on the first attempt you did not get a satisfactory earth bond and had to retest it.

Differing Appliance Descriptions

If the Next Most recent Description column is highlighted in yellow then it shows this Description is different from the Newest Occurence of the appliance, handy to spot if the appliance is really a completely different one and you have just accidentally used the wrong id.

 

Selecting Appliances To Delete

You can select which appliances to delete by simply clicking the tick box next to the appliance.


Selecting Ranges Of Duplicates

You can use the CTRL and SHIFT keys to select ranges of duplicates that you wish to add ticks to. (see Selecting Records)

When you then use the Newest and Oldest buttons described below, only those records you have highlighted will be ticked.

 

Close

Closes the Find Duplicates screen.

Newest

Ticks all, or all the selected Newest Occurences of the Appliance. If you have not selected a range of records (see Selecting Records) then you will be prompted if you want to Tick all the newest occurences of the appliances. If you have selected a range of duplicates then just those highlighted records will be ticked.

Oldest

Marks all, or all the selected Oldest Occurences of the Appliance. If you have not selected a range of records (see Selecting Records) then you will be prompted if you want to Tick all the next newest occurences of the appliances. If you have selected a range of duplicates then just those highlighted records will be ticked.

Clear

Clears all the ticks from the list so that you can re-start making your selection.

Delete

Clicking on the Delete button will delete all those appliances that you have assigned a tick. WARNING! You should make a backup of your file before deleting large ranges of appliances! If you have made a mistake, remember not to save your SimplyPats file when you are prompted.

Print

You may wish to print out the list of duplicate appliances to give to an engineer or to have whilst checking a particular site or location. Simply click on the print button to be shown a print preview screen with the list of duplicated appliances.

Return To Contents

(This Topic Last updated 27/10/2008)