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.
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.
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.
(This Topic Last updated 27/10/2008)