General Tab (Link Properties Dialog) - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
13.1

The options on the General tab allow you to set general properties for the import link.

General parameters

Generate rejected data report

Allows you to create a report of the rows rejected while importing your data. Selecting this check box may slow down the import process if any rejected rows are found.

Import to supporting tables only

Restricts the Import Utility to insert data only into the Smart Instrumentation supporting tables, that is, tag and loop data is not imported. Selecting this option disables the Tag/Loop Parameter settings. This check box is available only if you selected the Module import method on the Link Definitions dialog.

Insert data into reference tables

Allows the software to insert the imported data into reference tables when this data is missing in the target table. This check box is available only if you selected the Single table import method on the Link Definitions dialog.

Messages off

Select this option to cancel the display of messages during the import process.

Ignore duplicated source rows

Reduces all source rows to one if they contain field values that already exist in other source rows.

  • If your data source is an Excel file and there are source fields containing more than 256 characters, you must clear the Ignore duplicated source rows check box. Otherwise, the software only imports the first 256 characters from such fields. This is a limitation of Excel drivers.

Use reserved symbols with import

Allows you to do the following:

  • Check the source fields for a reserved symbol such as single quote.

  • Correct the target fields so that an SQL statement can be run after the import process is completed.

Selecting this check box slows down the import process to some extent.

Match case

Makes matching of source and target data values case sensitive. For example, if the value of a panel name in the source is ABC, and in the target, it is Abc, with the check box selected, the panel name does not exist in the target database, because the cases do not match. With the check box cleared, no check is made for the case match, so the value of the panel name is based on the string only, and in this example, it exists in the target. Note that selecting this check box improves the import performance and it is recommended to select it whenever possible.

Undefined NOT NULL fields

Use these options to define the way the Import Utility deals with data imported into a not null field (that is, a field that is required to contain some value) if that data does not match existing Smart Instrumentation data. Selecting one of these options determines how this mismatched data is imported.

Use default value

Sets the software to use the default value (zero) for the rows that contain reference fields that are undefined and that are not NULL. This situation can occur if you do not import data into the appropriate reference table. Selecting this option overrides any selections you make in the Default column in the Table Definition dialog.

Reject rows

Sets the software to reject the source row if it contains reference fields that are undefined and that are not NULL. This situation can occur when importing an instrument tag and the imported manufacturer ID number does not match any of the existing manufacturers defined in Smart Instrumentation.

Import revisions

Allows you to import revision data from the source database. This check box is available only when importing data into the Process Data module. If you select this option, you must define the link for the REVISION table in the Import Link window.

Use custom drawing names

Replaces the default document numbers with your own customized numbers. These numbers must be unique on the <plant> level. Clearing this check box allows you to use default document numbers. This check box is available only when importing data into the Process Data module.

Create calculation sheet

Creates a calculation data sheet for every tag that does not have a calculation sheet, and updates all the existing calculation sheets using the imported data. The calculation data is obtained from the source database according to the link that you define in when importing data to the module in the Import Link window. Selecting this option also creates a calculation revision record for the source tag associated with the new calculation sheet. You must define the link for the REVISION (Calculation) table in the Import Link window. This check box is available only when importing data into the Process Data module but not available for the import of line, level, and pressure data.

Create complementary elements

These options are only available when importing data into the Instrument Index module or instrument index-related table. Select the Create check boxes beside the complementary elements you want to create during the import process. Some elements, such as document numbers, are created in the target database while for other elements (for example, wiring data), only the appropriate connections between the relevant elements are established.