Digital Taxonomy Information Center Support Center

Contact Us

Re-Importing data

Introduction
Using the import tools within Codeit, it is entirely possible to import the same set of records multiple times into the same wave.
This page describes what happens when you do this and outlines some of the settings available to control this behaviour.

Duplicate Records
When you import records into Codeit you are required to specify an Id column that contains a unique value for each record.
These Id values must be unique within any given wave. If you provide a record containing an Id value that already exists (within the relevant wave) then Codeit will consider this as the same record.
Codeit does not allow duplicate Id values and therefore will consider an import against an existing Id value as an update to an existing record.
How this update is handled depends on the data values supplied and the current overwrite settings, as follows:

Existing Id values with existing variables

If data is imported for existing records and existing variables, the behaviour of Codeit depends on whether a) the existing data values differ from the new data values and b) whether the "Allow Overwrite" setting is enabled.

For example, consider the following existing data:

ID        Q1
-------------
1         A

Further, suppose an attempt is made to import the following record (in the same wave):

ID        Q1
-------------
1         A

In this case, the imported value for "Q1" is ignored, because it is the same as the existing value.
Suppose instead, that an attempt is made to import the following record (in the same wave):

ID        Q1
-------------
1         B

Then, the value for "Q1" will be updated if "Allow Overwrite" is enabled, otherwise an error will be thrown during the import.
Note: If the value for "Q1" in this case was left blank, then the Codeit import would simply ignore this value and the original "A" value would remain.  Importing a blank value does not imply a delete.

Duplicate Id values with additional variables

If data is imported for existing records with new/additional variables then these are simply appended to the corresponding existing record. 

For example, if an attempt is made to import the following record (in the same wave):

ID      Q1      Q2
-------------------
1       B       X

Then the variable "Q2" is appended to the record and given the value "X"

Powered by HelpSite