Crash Magic Online
  Intersection Magic
  Map Magic
  Knowledge Base
  Contact Us


Knowledge Base Article:IMW34 

Registration keys moved to client area: Select login on the left menu bar.

Search home page  

Performing supplemental data imports

Article created: May 09 2000, updated: May 09 2000

Background:  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.

Status:  Info - "how to" article
Keywords:  supplemental,supplementing,data,import,append,replace,ascii,delimited,fixed,fields,partial,record,add,new
Categories:   *Configuration* *Importing* *Data*

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
October 23, 2019 4:24AM

© 1999-2019 Pd' Programming, Inc - Lafayette, CO USA