/
Additional Install Instructions For Master Index

Badger TraCS Guides

Additional Install Instructions For Master Index

Owned by Geraldine Polster
Last updated: Jul 20, 2023
4 min read

Additional Instructions for Master Index Upgrade

The fall 2014 update package adds significant new functionality to TraCS. As a result, some additional follow up steps are required to fully install the update.

 

Your TraCS office database must be upgraded to accommodate new tables related to case management and master index features. The special one-time instructions below replace the standard update instructions found in task 5-2. Once these special instructions have been performed you can go back to using the standard procedures in task 5-2 for future WI Pack updates.

 

TraCS data will be unavailable to office users during the installation process. All office workstation users must log out of TraCS prior to beginning the installation process. (Field units running TraCS mobile may continue to write tickets and create other forms.) The total installation process will typically take 1 to 4 hours. If you are a SQL Server agency you will want your SQL Server admin on hand to run some scripts.

Read through the entire task before beginning. All steps must be done in order.

This is a major upgrade. Please make sure you have a current back up of your TraCS databases before proceeding.

IMPORTANT: If you currently have TraCS 10.05.47 installed because you also run MACH, you will need to delete the following tables from the tracs_data (SQL Server) or data.mdb (MS-Access) . These are empty “RMS” tables. The versions of the tables installed in 10.05.47 are incorrect and will be replaced during the installation of the new baseline. Be sure to make a back up copy of your database before starting and be sure not to accidentally delete other tables.

  • IndividualsToFormsMap

  • VehiclesToFormsMap

  • LocationToFormsMap

  • CarriersToFormsMap

  • MasterIndexFlags

  • Confidential

If you are unsure about how to delete these tables, please contact Badger TraCS for assistance.

  1. At the master computer: run the conversion utility to update your records to the upgraded database structure.

  2. Log into TraCS with your administrative account.

  3. From the Tools ribbon menu, select Configuration and Distribution | Folder/Index Conversion

  4. Click Yes to close TraCS.

  5. Click OK.

  6. Log in with your TraCS administrative ID when prompted.

  7. Remove the checkmark from Data Conversion and click Next.

  8. Click Next. (Screenshot will vary depending on if you use SQL Server or MS-Acccess.)

SQL

ACC

  1. SQL Server agencies will receive another confirmation dialog. Click OK.

  2. Click Exit.

    1. Note: the RMS Conversion Wizard will automatically restart. If you are using SQL leave the RMS Conversion Wizard open while you create tables in the next step. If you are using MS-Access, skip ahead to step 3k to finish the RMS conversion.

  3. SQL Server only: Before performing the data conversion step, you must run database scripts to add new tables and columns to your TraCS database.QL

    1. Start SQL Server Management Studio (SSMS)

    2. Create additional tables in the tracs_data database for the master Index upgrade. Run MasterIndexScripts.sql The script will be located in the TraCS network folder (from task 1-2, step 6b in the installation guide) under the DBData\SQLScripts folder.

    3. Create additional tables in the tracs_data database needed for the new Task and Vehicle Killed Wild Animal Permit forms by running the new the “Delta” SQL script. The script will be located in the TraCS network folder (from task 1-2, step 6b in the installation guide) under the DBData\SQLScripts folder. The name of the script takes the form of <Timestamp>Delta.sql. If there is more than one “Delta” script present, run the one with the most current timestamp.

Note: a common error is to run the script against the default database, which is typically not the tracs_data database. Either change the default database in SSMS to tracs_data or add the following lines to the script before running it—

USE [tracs_data] Go

  1. Sign into the RMS Conversion Wizard using your administrative account.e

  2. Remove the checkmark from Database Structure Upgrade and click Next.

  3. Choose folder conversion options.

    1. Choose Closed under Folder Status Default.

    2. Choose General under Folder Type Default.

    3. Click Next.

    4. Click Next.

    5. Do not enter a start date and click Next.

    6. Click Exit.

 



 

—Jenny 12/12/2014

Related content

email badgertracs@dot.wi.gov or call 608-267-2096