The Auto-Restore utility, in conjunction with the deleted items database, allows you to recover database records deleted from a main case database. Even coding information can be restored to a database when the Enable Tracking option is set in the main program.
Auto-Restore can be launched either from the Sanction II Utilities menu or directly from the Start menu – Programs - Sanction II group.
When you first launch the utility, the case (or current case) is automatically selected and loaded. The tree view will fill with the group names of any deleted records, and Deleted Folders List will display any deleted Presentations or User Folders.
You may select a different case database from the drop down combo box.
Important – every Sanction II case has a corresponding deleted items database. This file is located in the \Deleted subdirectory off of the main case directory.
Selecting Items
To select an item for restoring, click on the check box next to the group or folder name. You may select multiple items to restore. If you wish to view the item details, such as date deleted, and field information, double click on the item. This will fill the Detail list view.
Restoring Items to a Case
Once you have selected all of the items you wish to restore, click on the appropriate Restore button. When the items have been added, you will be prompted with a message box.
Important – restoring an item does not remove it from the deleted items database. This is by design. If you wish to clear items from the deleted items database, you must use the Purge feature.
Restoring Transcripts and Associated Videos
When you restore a transcript which has associated video files, you should always re-associate the transcript to the correct video files. In addition, you may need to run the Reset Clip Source Indices feature from the Tools menu, if existing clip segments do not play back properly.
Replacing Existing Items
In some cases, you may find that you have deleted an item but then added it back in again through some other method (drag and drop, load file, etc.). If you wish to restore the original item, choose the Replace Existing option. If an item with the same name as a deleted item is located, all of the field information fro the item will be replaced with the information in the deleted items database.
If this option is not selected, and an item with the same ID already exists in the main case database, the item will not be restored.
Purging Items
When you restore an item from the deleted items database, while the item is added back to the main case database, it is not removed from the deleted items database. The reason for this is to avoid accidentally replacing the wrong data. To remove items from the deleted items database, use the Purge feature. Purging the database allows you to permanently remove selected items (as well as all items) in the deleted items database. In addition, any time the Purge operation is completed, the deleted items database is automatically compacted.
Important – the deleted items database does not account for duplicate items. Thus if you delete an item from the main case, add it back in and then delete it again, unless you have purged the deleted items database, the item will appear twice. This by design. If more than one user has added items with the same name and then deleted them, this allows you to restore the correct records. As a general practice, you should always purge the deleted items database when you restore duplicate items.