Define the Import Mapping - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
13.1
  1. In Import Link window, in the Target pane, review the status of the target data fields. The status is indicated by the following colors:

    • Red — Indicates a primary key column (must be defined in the link).

    • Blue — Indicates a foreign key column.

    • Black — Indicates a regular column in the specific target table.

    • Magenta — A column defined as NOT NULL and which is defined in the Table Definition dialog as NOT DEFAULT.

    When importing data using the Module method, you do not need to define the Primary Key links. However, if you want to import any part of a table, its supporting table, or its reference tables, you must define that table's Primary Key links.

  2. In the Target pane, under Source Name, do one of the following:

    • Select the row under Source Name, and then select one or more table columns in turn from the Source pane.

    • Type known source column values.

    • Type a fixed string (for example, a formula) instead of linking source data. The fixed string must be enclosed in single quotes ('...').

    • Drag one or more selected table columns from the Source pane to the row under Source Name in the Target pane.

    • Whenever you drag a new source table column to a field under Source Name, a + sign is automatically added before the new field, for example: CMPNT_NAME+FUNC_DESC+FUNC_TYPE

    • When defining import mapping for COMPONENT table columns, you must specify a correct value for the CMPNT CAT ID (Tag Class) column. For details, see Tag Class Mapping Codes for Instrument Index Import.

  3. If needed, in the Source Name fields, use formulas and arithmetic functions. For details, see Formulas and Arithmetic Functions in Import Links.

    SHARED Tip If the total length of the Source Name data field is longer than the target field length (in the Length data field of the Target pane), a scissors symbol (PPM All Outputs Graphic) appears to the left of the Source Name data field.

  4. In the Source Name column, modify the data fields as you require, using various string operators. For details, see String Operators in Import Links.

    SHARED Tip If you need to define import mapping for a process function (PROC_FUNC_NAME column), note that you can set the software to use the @PROC_FUNC_NAME macro, so that you do not need to define manual mapping for process function and instrument type fields. The software uses this macro if you have assigned process functions to instrument type fields using the Source tab options of Link Properties dialog. For details, see Set Source Fields as Instrument Type Fields. This macro appears in the Import Link window whenever the PROC_FUNC_NAME column exists in the target table.

  5. After defining all settings in the Import Link window, do one of the following:

    • Select to start an import test run that helps you evaluate the import results without saving data to the target table or tables. For details, see Test the Import Process.

    • Select to start the import process.

    • Select Save Icon 16bit to save the current link settings in the Import Utility. You can use the saved link in other import sessions.

See Also

String Operators in Import Links
Example of Concatenated Sources