Performing supplemental data imports
On occasion, users have the need to supplement records in their database without removing data already stored for those records. An example would be if you have a data source that provides you all the crash data you need except for direction from intersection. You have another source that can provide direction from intersection and uses the same caseid number that the first data source uses. This is a use for Supplemental importing.
Normally when Intersection Magic imports, it reads a record from your ASCII file and identifies the CASE ID number field. It then searches it’s database for that CASE ID. If it finds it, it deletes that record from the database and begins importing the new data. Thus, overwriting the original data.
This behaviour is normally what one would desire. However, on occasion, as described above, it is desirable to locate the existing record and then just fill in any fields that are specified in the new import definition. In this case, Intersection Magic reads a record from the ASCII file, searches for it in its database, if it finds it, it loads it for editing. Then it imports the fields specified in the import definition and only updates those fields for which there is new data. The log file reflects this by indicating the case id number and the note “supplementing” for that record.
As with any data manipulation, be sure to backup any data currently on your system so that it can be conveniently replaced should anything go wrong during the data manipulation process.
There are two parts to performing a supplemental import. The first part is to prepare a new import definition. (Pd’ Programming offers this service for $500 each) This new import definition must specify the caseId field so that the existing record can be located, it should then specify any fields in the new ASCII file that should be imported into the existing database. Once this import definition is complete, you are ready to import (as described below).
A supplemental import is performed by selecting Utilities / Database / Import as usual. Then select the new data file containing the data to be appended to each record; the new import definition that specifies only those fields to add data to; and finally check the “perform partial record importing” box at the bottom of the dialog.
example dialog box for this process