-
We recommend proceeding cautiously with the import process, as some of the Import Utility features change the structure and contents of the target database.
-
The import process is irreversible: once you carry out the import process, you cannot undo the changes import made to the target database. We therefore recommend that you first use the test mode to check the import process before carrying out the actual data transfer. The test results provide you with information about the expected outcome of the actual import process. For details, see Test the Import Process.
-
If you intend to import a large number of records (more than 400 records) in one import session, you must create a new section in the Intools.ini file called [Rules] and add the following parameter: disable=y.
-
If you are importing from Smart P&ID, Smart P&ID must be closed before starting the import session, to ensure that any modifications made to the drawings are properly imported to Smart Instrumentation.
-
Select the import method, which can be either Module (multiple tables) or Single table.
-
Select the target Smart Instrumentation table or module for the import.
When importing data to tables, the order of the import is important. You should first
import data into a table that the next table refers to. For example, before importing
data into the COMPONENT table, you should import data into the COMPONENT_LOCATION table, if you want to import both instrument locations and instrument tag numbers.
-
Define the import link properties as you require, using the Link Properties dialog options. For details, see Defining Import Link Properties Common Tasks.
-
Establish a link between the source and the target data. You can do one of the following:
-
Use an existing link that was saved previously
-
Build a new link and save it (see step 5).
-
-
To build a new link, do the following:
-
Set the appropriate parameters for the import.
-
Where appropriate, define the structure of the import link.
-
Define the link mapping between the source and the target table columns.
-
You can modify the source definition after creating the link to ensure that all required data exists in your source database.
-
If required, you can reset the import order as well as select the reference tables to import. To learn how to control the import order, see Target Table Definition.
-
-
Run an import test (recommended) For details, see Test the Import Process.
-
Perform the import process by selecting
in the Import Link window.
-
On the Import Progress dialog, review the following information:
|
Data Field |
Description |
|---|---|
|
Source Table Rows: Total / Current |
The total number of rows and number of rows currently imported in the currently selected source table. |
|
Target Table Rows |
The number of rows of the current table that have already been processed by the Import Utility during the current import session, according to their status: Inserted, Updated, Deleted, or Rejected. |
|
Tables / Rows in current table (progress bars) |
The percentage of data which has already been processed for an import link assigned to the Module (multiple tables) method for the entire module and for the table currently being processed. |
|
Progress bar |
The percentage of data which has already been processed for an import link assigned to the Single table method. |
|
Cancel |
Stop the import process during execution. |
|
Report |
View the report on rejected rows. This button is available only if any rejected rows occurred and if you selected the Rejected data report check box on the Link Properties dialog. This option allows you also to generate a hard copy of the current report. This button becomes active only after the import process was stopped or was completed. |
|
Information |
View the import process information: the target table name and the row count before and after import. This button becomes active only after the import process was stopped or was completed. |