Products
  
  
  Crash Magic Online
  
  Intersection Magic
  
  Map Magic
  
  Knowledge Base
  
  
  
  Contact Us
  
  Meeting
  
  Login
  

 

SWITRS users Year 2000 information 


Registration keys moved to client area: Select login on the left menu bar.

Product information Support Downloads (& demos)

Ready to go!

The California Highway Patrol has sent us the data and information needed to prepare an import definition for their new year-2000 compatible data format. We've tested our import routines and are ready to provide them to you.

Remember, this is only applicable to those of you who import the SWITRS data into Intersection Magic directly from the files sent to you by the state. If you are first importing it into another program (dBase/Access) this probably does not apply to you.

System requirements:

  1. In order to use the new importer, you must have Intersection Magic version 5.36 ( released March 96) or newer. You can check the version of Intersection Magic that you are running by selecting Help / About Intersection Magic from the main menu. The exact version number is in the title bar of this dialog box.
  2. You must not have modified your fields list (.LUS) file. It must be the default shipped by Pd' Programming. If you are not sure if yours has been modified, see The Process" below. If you have modified your .LUS file so that it is no longer compatible with the default, you will need to modify the import definition manually.

Cost:

  • If your upgrade and support plan is current, (paid for in the past 12 months) then there will be no charge for the new import definition. In fact, it's already in the mail! If you have not received it by Friday, April 24 1998, please contact us.
  • If your upgrade and support plan is not current, but you have Intersection Magic version 5.36 or newer, you have three choices:
    1. Upgrade to the current version of Intersection Magic ($750) or,
    2. Purchase only the new import definition ($50 + s&h) or,
    3. Change your import definition manually as described in the manual. Sorry, but we can not provide telephone support for non-current versions of the program.
  • If you have a version of Intersection Magic older than 5.36, you have two choices:
    1. Upgrade to the current version of Intersection Magic ($750) or,
    2. Change your import definition manually as described in the manual. Sorry, but we can not provide telephone support for non-current versions of the program.

The Process:

 

Procedure:

How:

1 BACK UP YOUR DATABASE AND CONFIGURATION FILES. If you installed the program to the default directory C:\MAGIC, then your database and configuration is found in the C:\MAGIC\DATA directory.


2
Determine if you are using the standard SWITRS lookup file, or if it has been modified at some time.

If you use SWITRS data directly from the state, your fields should match those to the right. If they do not, please stop here and contact us.

Note that if you use data provided by another source, your police department for example, or if you import your data into another program prior to importing it into Intersection, the year 2000 issue may not affect you. Please feel free to contact us if you are not sure.



IMPORTANT: If the fields to the right do not match the fields in your lookup file, you will corrupt your data by performing the update described below. Please do not proceed.
Select Utilities / Edit config files / Lookups / Edit.

SWIT.LUS should be the default. Select OK. Scroll down this file to the FIELDS section. (past the BASEFIELDS section)

The FIELDS list is a single column of numbered field names. The names and numbers should exactly match those below.
1 JURSDCTN
2 DAY
3 DIRECTION
4 INTERSECT
5 ROUTE
6 LOC TYPE
7 SEVERITY
8 KILL
9 INJURY
10 VIOL CAT
11 HIT RUN
12 COLL TYPE
13 INVOLVED WITH
14 PED ACTION
15 ROAD SURF
16 ROAD COND
17 WEATHER
18 LIGHTING
19 CONTROLS
20 VEH 1 AGE
21 VEH 2 AGE
22 VEH 3 AGE
23 VEH 1 SOBER
24 VEH 2 SOBER
25 VEH 3 SOBER
26 VEH 1 DRUG
27 VEH 2 DRUG
28 VEH 3 DRUG
29 VEH 1 DIR
30 VEH 2 DIR
31 VEH 3 DIR
32 VEH 1 VIOL
33 VEH 2 VIOL
34 VEH 3 VIOL
35 VEH 1 MOV
36 VEH 2 MOV
37 VEH 3 MOV
38 VEH 1 TYPE
39 VEH 2 TYPE
40 VEH 3 TYPE


3
Obtain and run the swit_up.exe program.

When this program is run, it will prompt you for an install directory. It will default to c:\magic\data, which is the default directory when Intersection Magic is installed. If you have installed elsewhere, you must specify that directory.
If you have not already received swit_up.exe, you will need to obtain it from Pd' Programming.

See the "cost" section above.


4
Test the updated import definition.

Please be sure that you have backed up your data before proceeding.
Import the new data the way you normally would. When the import is complete, generate a diagram containing data from this import.

If the accident date indicates an accident in 1996/1997 rather than 1919, the update was successful.

Note: We were recently asked what would happen if the wrong import definition was used for the data being imported. Unfortunately, while some of the data will be rejected, much of it may be imported and will contain completely inaccurate data. The good news is that since there will be a lot of errors generated, Intersection Magic will 'warn you' in the following manner:

Each time an import is completed, a dialog box is displayed which indicates "done importing". This dialog box may also contain a message such as: "see errorxx.log" or "see "cgfalnn.log". These files contain errors encountered during the import process. When presented with one of these messages, you should always open the indicated file and determine the cause of the errors. In the case of a mismatched import definition, there will be a lot of "bad date - record not imported" messages.

It is always a good idea to back up your data and configuration frequently. It is especially important to be sure that you have a backup of your database prior to importing new data. The import process can not be 'undone' in any automated fashion.

We generally recommend that SWITRS users keep the diskettes sent by the state in case a database is ever lost or corrupted. In addition, it is wise to keep a copy of your street changes file. This is the file which contains a list of bad street names / good streeet names. Combined with your data, this combination can reproduce your database if it is ever lost. Of course, you should also back up any reports, filters, etc. which you've created on your system.


Potentially useful links:

California Highway Patrol home page (we couldn't find anything on SWITRS data here)
California OTS home page (we couldn't find anything on SWITRS data here either)


Main year 2000 page

November 22, 2017 5:28AM

© 1999-2017 Pd' Programming, Inc - Lafayette, CO USA