In Texas, crash data is available to agencies through the CRIS data system. By following the steps included here, you can download and unzip data files suitable for import into Crash Magic. You also have the option to FTP the data to our servers rather than using the browser interface. That process is described at the bottom of this article.
Crash Magic Online > Importing
There are two methods for importing data into Crash Magic. The first is the standard manual process using the Crash Magic Online web pages. The second method utilizes FTP for automatic processing.
Georgia DOT has a crash database managed by Lexis Nexus that can be accessed by any jurisdiction in Georgia. You will need to request access, and fill out a user agreement in order to receive a login and password.
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.
How to obtain data from Washington State Dept of Transportation for Crash Magic
Crash data can be imported from many sources. This article describes the case where the data is provided as an XML file. If your data is being provided in XML format, you also have the option to FTP the data to our servers rather than using the browser interface.
In order to read and/or compare XML files it can be handy to format them in a common way. This article describes one method for doing this. It relies on a free 3rd party product that needs to be downloaded first.
When an MS Access (.mdb) database is moved from one computer to another, which have different versions of Access, attempting to reference macro/VB libraries will fail. This is because the most recent edits to the file caused Access to select libraries that may not be on the new computer.