Each Smart Instrumentation table contains a primary key data field, which, like the primary key table column, is used as a prime key for accessing the table data. The difference between the primary key table column and the primary key data field is that you can only access the latter, whereas the primary key table column is an internal database key used by Smart Instrumentation only.
Example
The COMPONENT table contains a primary key table column, CMPNT_ID, which is an internal Smart Instrumentation database key, and a primary key CMPNT_NAME, which contains the tag number.
If you import data using the Single table method you can:
-
Allow the Import Utility to generate the primary key data field automatically according to the naming conventions that you will enter; to do this you will need to manually define appropriate naming conventions for both the tag and the loop. This way, the primary key data field will contain the value Computed, which means that its contents have been predetermined by the Import Utility, based on the naming conventions you have entered.
-
Use the naming conventions in the link; this way you will need to manually create the primary key data field contents and naming conventions by specifying the appropriate parts (for example, PREFIX, SUFFIX). This way, you define the value of all the target data fields that you require either by typing in the appropriate value in the target data field, or by selecting the appropriate source table column and linking it to the target data field.
If you select to import data using the Single table method you must define the links
of all primary key data fields. If you have selected to import data using the Module
(multiple tables) method, you do not need to define the links to all the primary key
data fields, because it is possible to limit the import of data only into certain
target tables.
At this stage you can also:
-
Make a more precise selection by selecting the source and target rows that will be processed during the import process.
-
Select the reference tables you want to import.
-
Save the current link to be used in future import sessions.
-
View the source rows.
-
Perform a test run to evaluate the import process results.
-
Carry out the import process.
After you map all the source and target data you can make a more precise selection. You do this by selecting the source and target rows to be inserted updated or deleted during the import process.
When you finish defining the mapping between the target and the source, you will come to the end of the import setup process at which point you will be able to carry out the actual import of data.