Knowledge Base

Search Results


Mitchell Estimating Backup and Restore

« Go Back


TitleMitchell Estimating Backup and Restore
SummaryGuideline to be used for backup, restore, or migration of Ultramate and the databases.
Guideline for backup and restore of UltraMate data.
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

  1. Click StartWindows 10 Professional - Go to Mitchell InternationalUltraMate System Administrator, UltraMate Technical Assistance Utilities.
  2. The Technical Assistance Utilities warning message appears. Click Yes to continue.
  3. Click Database Utilities, then Backup Files.
  4. Check all desired databases boxes to backup. Selecting any one of UserauxSecusvrLongexp, 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.
  1. 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.
  2. Verify the destination and the files to be backed up are correct, and click OK.
  3. When finished, the Backup Completed window appears.  Click OK.
  4. 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
  1. Click Start, Windows 10 Professional - go to Mitchell InternationalUltraMate System Administrator, UltraMate Technical Assistance Utilities.
  2. The Technical Assistance Utilities warning message appears. Click Yes.
  3. Click Database Utilities, then Restore Files.
  4. A warning box appears. Restore will overwrite existing data on this installation.  Are you sure you want to continue? Click Yes.
  5. 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. 
  6. Clear the check boxes for any databases not being restored.
  7. Click OK.
  8. The Restore Completed window appears. Click OK.
  9. When finished, click Database UtilitiesExit.
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.  
Additional NotesYou can also back up Ultramate configurations.

1. Click System Info, then place mouse over Configuration then click Export Configurations...
2. Click the Select All button which will put a check mark in all the boxes for Preferences, Communications and Company Data.
3. Then click the Browse button for the System Configuration Export File Destination and save the UMSYSCONFIG file where the desired destination path may be.
4. Then click the Export button and the file will be saved to desired path. (Default path is C:\Mitchell\aces\SysConfig\Export)
5. A Log Viewer window opens showing a successful Configuration Import/Export Log

Do the reverse to restore the Ultramate configurations.

1. Click System Info, then place mouse over Configuration then click Import Configurations...
2. Select the UMSYSCNFIG.cfg file from within the System Configuration Import window. and then click the Open button
3. A Log Viewer window opens showing a successful Configuration Import/Export Log
URL NameMitchell-Estimating-Backup-and-Restore-HT
Validation StatusValidated



Was this article helpful?



Please tell us how we can make this article more useful.

Characters Remaining: 255