Importing

Automated import using FTP

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.
Read More

How to obtain data from GEARS

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.
Read More

Importing new crash data – XML

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. That process is described in the Automated import using FTP knowledge base article.
Read More

Formatting XML

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.
Read More

MS Access can’t find proper DAO library

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.
Read More