This section is a guideline for backing up your UltraMate Advanced Collision Estimating System. Please be aware that running the UltraMate Technical Assistance Utilities alone will not backup archive data or any other Mitchell application files.
Warning: Improper use of the UltraMate Technical Assistance Utilities could cause loss of user data or require UltraMate to be reinstalled or reconfigured. Mitchell recommends your computer consultant or system administrator perform this procedure.
Creating a backup using the Ultramate Technical Assistance Utilities
- Click Start, Windows 10 Professional - Go to Mitchell International, UltraMate System Administrator, UltraMate Technical Assistance Utilities.
- The Technical Assistance Utilities warning message appears. Click Yes to continue.
- Click Database Utilities, then Backup Files.
- Check all desired databases boxes to backup. Selecting any one of Useraux, Secusvr, Longexp, or Authgrop will cause a dialog box to appear that recommends selecting other grouped databases. Click Yes, and these databases will automatically be checked.
- For information about what each database contains, see 'Description of Databases in Backup User Files window' below.
- The Destination field is populated with the default name of the backup file, which consists of the year\month\day. (For example: 20090609.ARQ for a backup made on June 9, 2009). The Browse button can be used to change the destination or file name.
- Verify the destination and the files to be backed up are correct, and click OK.
- When finished, the Backup Completed window appears. Click OK.
- When finished, click Database Utilities, Exit.
Mitchell recommends storing a copy of the backup file in a safe location.
Restoring databases using the Ultramate Technical Assistance Utilities
- Click Start, Windows 10 Professional - go to Mitchell International, UltraMate System Administrator, UltraMate Technical Assistance Utilities.
- The Technical Assistance Utilities warning message appears. Click Yes.
- Click Database Utilities, then Restore Files.
- A warning box appears. Restore will overwrite existing data on this installation. Are you sure you want to continue? Click Yes.
- If the desired backup file is not listed, select to the correct drive and folder where the backup file is located. Click the file name of your backup, and click OK. All available databases are automatically selected.
- Clear the check boxes for any databases not being restored.
- Click OK.
- The Restore Completed window appears. Click OK.
- When finished, click Database Utilities, Exit.
Description of databases in the Backup User Files window
- Useraux - Contains profiles, MAPP settings, dispatches, profiles, reviewer IDs, and name & address lists. (UserCo database is included when Useraux is selected. It contains company data information.)
- Secusvr - Contains user IDs and passwords.
- Longexp - Contains long expansion groups and lists.
- Commsvr - Obsolete.
- Authgrop - Contains authorization groups. (these database files are located in the Useraux folder)
- Lexicon - Contains customized prompts. (screen customization)
- Syscon - Contains company heading, installation type, and preference settings. (Syscon will preserve ShopPak, EMS Settings, next Estimate/Repair Order number, etc. It is only available for backup and restore with single-user installs.)
- Userdata - Contains estimates, repair orders, and assignments.
Procedure to manually backup databases
The Technical Assistance Utilities should be the primary method of backing up UltraMate databases but the databases can also be manually backed up. A manual backup is recommended as an optional secondary backup to prevent accidental loss of data. To create a manual backup, it is recommended a copy of the following folders be created. It is required that each sub-directory be included with all of the files it contains. Do not attempt to take individual files from these directories.
Note: Replace x: with the drive letter where UltraMate is installed. (Single-user install is on C: Multi-user is typically on M: but can vary)
Critical Files - See 'Definitions of UltraMate Folders' below.
- x:\mitchell\aces\archive
- x:\mitchell\aces\lexicon
- x:\mitchell\aces\longexp
- x:\mitchell\mapp
- x:\mitchell\secusvr
- x:\mitchell\syscon
- x:\mitchell\useraux
- x:\mitchell\userco
- x:\mitchell\userdata
Non-Critical Files - See 'Definitions of UltraMate Folders' below.
- x:\mitchell\aces\export\
- x:\mitchell\aces\image\
- x:\mitchell\aces\import\
***Important: UltraMate should be installed before restoring any databases.
Definitions of UltraMate Folders:
Critical Files: Critical meaning the absence of one or more of the related files can cause that particular database to encounter a loss of data.
- Archive - If used, this directory contains archived estimates.
- Lexicon - Contains customized prompts (screen customization).
- Longexp - Contains long expansion groups and Lists.
- Mapp - Mitchell Alternate Parts Program (aftermarket parts search).
- Secusvr - Contains user IDs and passwords.
- Syscon - Contains installation type and preference settings.
- Useraux - Contains profiles, MAPP settings, authorization groups, dispatches, profiles, reviewer IDs and name & address lists.
- UserCo - Contains company name information
- Userdata - Estimates, Assignments, Repair Orders.
Non-Critical Files: Non-critical means that the absence of these files will not adversely affect the normal functionality of Ultramate.
- X:\Mitchell\aces\Export - Exported estimates.
- X:\Mitchell\aces\Image - Contains est, prn, pdf, and other print image type files.
- X:\Mitchell\aces\Import - Import files.
