Crash Magic Online
Knowledge Base Article:
Registration keys moved to client area:
Select login on the left menu bar.
Search home page
Why does my new SWITRS data have only 3 characters for a CaseID?
Article created: Feb 19 2003, updated: Feb 19 2003
CA CHP introduced a new structure for SWITRS data beginning with data send after June 2002 (although most of this new format didn't ship until 2003) Pd' Programming made available a new configuration to read this data free-of-charge to all current subscribers to our Intersection Magic software.
On February 13, 2003 we identified a minor problem with the new configuration. The caseID format in this new CHP data structure is variable - it is different after 1/1/2000. This article describes how to correct your configuration and database if you downloaded the new configuration prior to 2/18/2003 and imported 2002 data using it.
Bug - under investigation
switrs,data,case_id,caseid,case id,serial,bar code,barcode,serial number,id number,2002,chp
If you downloaded the new configuration from our web site between 1/15/2003 and 2/18/2003 you should re-download it to obtain the corrected configuration.
If you imported 2002 data using the original downloaded configuration, you will need to delete thoses cases from your database.
The instructions below describe this process.
Step 1: Correct the configuration files
Download the corrected configuration:
Your personal page
on our web site for this file.
Run the configuration installer that you just downloaded
Verify that you have the updated configuration by checking the date on the cityid.txt file in your working (data) directory. It should be 2/17/2003.
Your system may now be used to import data in the new format.
Step 2: Update IMWEdit
This step is only necessary if you have imported 2002 data using the original configuration. It is also handy if you use IMWEdit regularly, as it has been improved a little.
Download an updated imwedit program:
our downloads page
and select the link to download imwEditx_6650.exe. (located just below the green area)
Install the IMWedit.exe program:
Run the file that you just downloaded and extract the imwedit.exe file to your magic directory. It will overwrite your existing imwedit.exe program.
Step 3: Delete the crash records with wrong (short) case id numbers
This step is only necessary if you have imported 2002 data using the original configuration.
Start Intersection Magic
Select Utilities / Database / Export
Set the date range to 1/1/2002 - 12/31/2002. Your selection may be corrected if less data exists. That's ok.
Select CaseId14.rpt as your report file format
Select ASCII fixed field as the export type
Set the export file name to "todelete.txt"
Select Ok to begin the export
When the export is complete, select Utilities / Database / IMWEdit to launch the data editor
Select Accidents / Delete list of records. Select the file called "todelete.txt". You will be presented with a list of case_ids that will be removed from the database. Verify that they are all short (i.e. 3 characters) and then select Ok
That's it. Your system is now ready for new switrs data and has had any erroneous records removed.
September 19, 2018 1:05AM
© 1999-2018 Pd' Programming, Inc - Lafayette, CO USA