In this window, you define the links between the source and the target data fields at the end of the import setup process, after you have defined the import link and if required, you have modified the import parameters.
The Import Link window opens after you have selected import links in the Link Explorer window and you select to view the link mapping or to import data to one or more tables in Smart Instrumentation.
Source
This pane contains all the fields of the source file or database. Select the required field and drag it to the appropriate target field in the Target pane.
Select to find a source name in the Source pane. A window, Search in the source column list, opens. Type the string corresponding to the required source name. As you type, fields that correspond to the typed string are selected.
Select to open the Source Data dialog where you can view the source data.
Target
This pane contains all the columns belonging to the target tables. If you selected to import data using the Module method, the individual tables are shown separated by bold horizontal lines, the table names are displayed in bold blue font, and an additional Table Name column displays the name of the table as defined in the target database. To define mapping, you select the row corresponding to the required source field in the Source pane and drag it to the appropriate row under the Source Name column in the target table.
Scissors
The icon appears next to a Source Name field if the total length of the source column values is longer than the target column length indicated under Length. This means that this value will be truncated.
Source Name
Contains all the source column values that you can import to the target field. Type the required value or drag the appropriate value from the Source pane. You can also select to open a pop-up window which provides you with more space to enter the required value. In this window, you can perform the following actions:
-
Drag one or more selected columns from the Source Name pane to the Source Name field. Whenever you drag an additional source field to the Source Name pane, a + sign is automatically added before the additional source field.
-
Type known source field names.
-
Enter a fixed string instead of linking source data. The fixed string must be enclosed in single quotes '... '.
-
When defining an import link, you can use various string operators in the Source Name field. For details, see String Operators in Import Links.
-
For import sources that are codes, you can concatenate sources. For details, see Example of Concatenated Sources.
-
It is also possible to use formulas and arithmetic functions. For details, seeFormulas and Arithmetic Functions in Import Links.
-
Under Source Name, you can enter @PROC_FUNC_NAME to use the predefined process function macro. You can use this macro only if you have defined the required process function on the Source tab of the Link Properties dialog and selected the Assign check box. This macro is entered into the Source Name field automatically whenever the target table includes the PROC_FUNC_NAME column.
Target Name
Contains the target columns into which you are about import the selected data. Each target name is marked with a specific color:
Red
Marks the primary key column (required)
Blue
Marks foreign key columns
Black
Marks regular columns
Magenta
Marks columns defined as NOT NULL and which are also defined as NOT DEFAULT on the Table Definition dialog.
If you are importing data using the Single table method, the Target Name column displays the actual table column name in the Smart Instrumentation database. If you are importing data using the Module method, the Target Name column displays the column name definition as it appears in the Smart Instrumentation interface. In this case, you can view the corresponding database value under Column Name.
In the current <unit>, beside the tag number and loop number fields, a naming convention mask appears, for example, AAA-FFFF-9999\S. This mask only applies to loops and conventional instruments. The naming convention mask depends on the naming conventions defined for the current <unit> the Administration module. The maks represents naming convention segments as follows:
-
Each letter stands for a single character/digit, for example, AAA stands for a three character part.
-
Each group of repeating letters stands for a different segment/part of the naming convention, for example, EBBBB describes two segments/parts, where the E part contains one character part and BBBB describes a four character part.
-
Separators appear as selected for the target domain, for example, - (hyphen), \ (backslash), and so forth.
When defining the source column value for Smart Instrumentation instrument tags belonging to different classes, you need to define mapping for the Tag Class (CMPNT CAT ID) column. For details, see Tag Class Mapping Codes for Instrument Index Import.
Type
Indicates the type of data that you can import into the selected column.
Length
Indicates the length of the target field. If the total value of the source field is longer than the indicated length, the value will be truncated (the icon indicates this fact).
Column Name (only available when importing data using the Module method)
Displays the target table column name in the Smart Instrumentation database.
Table Name (only available when importing data using the Single table method)
Displays the table name to which the target column belongs.
Selecting opens the Import Comparison List dialog, where you can compare source and target rows and this way select the rows you want to include in the import process.