Importing new crash data – w/Convert

Issue

Crash data can be imported from many sources. This article describes the case where the data is provided as an ASCII file or other files that can be read by MS ADO such as MS Access or DBF.

Explanation

When crash data is provided as an ASCII delimited file, or group of files, or as DBF, the following steps are taken:

  1. Package the files into a zip file (Note: SWITRS and ALISS files are already zipped when they arrive)
  2. Upload the zip file to Crash Magic
  3. Convert the zip file to XML files
  4. Import the XML files
When crash data is provided as an MDB, simply zip that file.

The steps for completing this process follow.

Solution
  1. If your data files are not already zipped, create a zip file and add them to it.  Do not add any folders, or any other files to the zip.  An easy way to accomplish this is to use the Windows Explorer.
    • Locate the required files and hold down the CTRL key while selecting each of them. 
    • With the desired files selected, place your cursor over any one of them. 
    • Click with the right mouse button and choose “Send to..”. Then choose “Compressed (zipped) folder”. 
    • A new file will be created and selected.  It is usually a good idea to rename it.
    • This is the Zip file you will upload to the “Convert data to XML” page.
  2. Log in to Crash Magic as an administrator.
    • Proceed to www.GovernmentTools.com.
    • Enter your login information and select your user group.
    • Click the “Show advanced options” link below the logo of your agency.  New buttons and links will become available.
    • Select the “Group Admin” button.
  3. Navigate to your user group “Convert data” screen
    • When you have successfully logged in, you will be presented with the administrator console.  In the tree on the left, locate the user group for your agency.  It will be your state abbreviation @ your agency. (i.e. CA@LakeForest) It will usually be the last user group in the list.    Click on your user group name to select it.
    • On the page for your agency, there will be a number of tabs across the top.  Locate “Convert data to XML” and select it.
  4. Proceed with converting the data to XML
    • In the “Select DB to XML definition” list, select the appropriate convert definition.  There may be a couple in there, so look them over. The standard converter for SWITRS is “SWITRS ASCII to XML”.  
    • Click the “Browse” button and locate the zip file that you created earlier.  Select that file.
    • Now click the “Upload to queue” button and the file will be uploaded.
    • When you see the file in the box on the left, press the “Begin processing” button.  This will start a process that will read your ASCII file and create a new XML file for each crash record found.  Those files will appear in the list on the right, labeled “XML Output files”. 
    • You will see a box titled “Threads currently processing”. You can click the blue arrow below it to cause it to update.  Wait until it finishes and the converting message is gone.
  5. Import the XML files
    • Locate the tab titled “Import XML data” and select it.
    • In the “Select DB to XML definition” list, choose the import definition that matches your data source.  The SWITRS default is “SWITRS XML to DB”.  The ALISS conversion selections include an option to overwrite existing records or to skip over existing identical records.  For most agencies, the default is to overwrite existing records. (This is the default if you don’t have both options)
      Upon making your selection, the “Files in queue for import” will show your recently converted files.
    • Select the “Begin processing” link to start the import.
    • Once again, the box at the bottom showing “Threads currently processing” will display progress.  The blue button below it can be used to update the status. (please give the status a few minutes to calculate it’s percent and time to completion)
    • When the “Threads currently processing” box is empty, the import is complete.
  6. Check your status
    • You can check the results of the most recent, or any other import in the “import history” box.  Each entry includes the date and time of the import, as well as a brief summary in the box to the right.
    • You can also click on the “Basic log” link for a more detailed description, especially if the summary indicates that errors have occurred.
    • Any of the reports in the program will reflect this new data.  In addition, you should be able to find a query in the administrator panel called “Crashes by year”.  It will be located either in your own user group, or the one above it, under the “.shared” user, in the “Query – General” section.  The blue tab of this report can provide you with a quick, simple summary of the data in your system. Note: you must put a * in the designated location, and press the database button as shown below:
       
Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
How Can We Improve This Article?