Set Import Mode Parameters - Intergraph Smart Instrumentation - Help

1. On the Link Properties dialog, select the Import Mode tab.

2. Under Target database import mode, do one of the following:

   • Select Insert and update to enable the Import Utility to insert new source rows and update existing target rows during the import process.

   • Select Insert to prevent the Import Utility from updating target rows and to enable insertion of only new source rows in the target domain during the import process.

   • Select Delete to delete existing rows in the target domain during the import process.

   • Select Move to move the rows in the target domain to a different <unit> in the same domain.

   

   • The Delete and Move modes are only available when using the Single table import method.

   • If you selected Insert and update, the Update operation is carried out automatically whenever a source row contains the same key definition as the target row.

3. If you chose the Insert and update option in step 2, under Target database update condition, select any combination of the following check boxes:

   1. If the source contains a NULL value

      • Select to overwrite the target table column even if the corresponding source table column contains a NULL value.

      • Clear to skip source table columns that contain a NULL value.

   2. If the source contains a space or a zero value

      • Select to overwrite the target table column even if the corresponding source table column contains a space value or a zero value.

      • Clear to skip source table columns that contain a space value or a zero value.

      

      • Some database drivers interpret spaces in a source table column as a NULL value. To avoid incorrect overwriting of data in the target, it is highly recommended that you select both or neither of the above two check boxes.

      When inserting NULL values for table columns of data type String that can normally accept a NULL value, you can specify the insertion of a single space instead of NULL. To do so, in the Intools.ini file, under the [Import] section, type the line:

      FillSpace=Y

   3. Do not insert

      • Select to skip inserting source rows that do not exist in the target table.

      • Clear to insert source rows that do not exist in the target table.

See Also

Target Table Definition
Refresh Previously Imported Data