Import Device Panels as Cabinet Child Items - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

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

The following are prerequisites before importing device panels as cabinet child items:

  • Make sure you first import or create all the target cabinets.

  • Make sure that your import source contains the device panels that you want to import and the cabinets under which you want the device panels to appear in Smart Instrumentation.

  1. On the Link Definitions dialog, create an import link for panels as follows:

    1. In the Link box, type a unique link name, for example Device Panels Within Cabinets.

    2. Under Import method, select Single table.

    3. Under Name of module or table, select Panel.

    4. Complete the import link creation.

  2. Open the Link Properties dialog, and, on the General tab, do the following:

    1. Make sure that Import to supporting tables is cleared.

    2. Under Undefined NOT NULL fields, select Reject rows.

    SHARED Tip Selecting Reject rows is recommended to set the software to reject all source values that do not match foreign key values in the PANEL table. For example, if a cabinet model in your source does not match the model that already exists in Smart Instrumentation, the software indicates that this model does not exist. If you select the Use default value, in the PANEL table, the Import Utility will enter 0 (zero) values in all the columns whose values do not match the values in the import source.

  3. Because your import source contains device panels, you will need to associate them with instruments that exist in various <units> in Smart Instrumentation. Therefore, on the Import Level tab, under Hierarchy levels, select Apply and select the lowest plant hierarchy level. For details, see Import Data Into Multiple Plant Hierarchy Items.

    • For an import source that contains device panels, we recommend that the target <unit> for importing device panels be the same as the <unit> where the associated instrument tags appear.

    • Although, <plant> is the default import level for wiring data, specifying a <unit> level for wiring items allows you to filter the imported wiring data per <unit> in the Domain Explorer.

  4. Select Table Definition and create a new table definition based on the Default definition. For details, see Create a Table Definition Based on Another Definition.

  5. To create a new key definition, do the following:

    1. Select Foreign Key and close the Foreign Key List pop-up window.

    2. Select Clear to clear the Key definition working area and then, from the Column definition pane, drag the PARENT_ID column to the Key definition working area.

    3. Add the following key definition:

    PPM All Outputs Graphic

    1. In the Column definition pane, scroll right to display the Key Level column.

    2. Manually remove all the key levels from the PARENT_ID column.

    3. Save the new definition.

    SHARED Tip Adding the PARENT_ID foreign key into the PANEL table enables you to define cabinets as parent items of device panes in the same table. The new key definition allows the Import Utility to find cabinet names in the PANEL_NAME column of the PANEL table and write the matching PANEL_ID column values into the PARENT_ID column.

  6. In the Import Link window, open the import link.

  7. In the Target pane, define the import mapping as follows:

    1. Select the PANEL_NAME row, and then, from the Source pane, drag the column containing the source device panel names.

    2. Select the PARENT_ID row, and then, from the Source pane, drag the column containing the cabinets within which you want the device panels to appear.

    3. For the PANEL_CATEGORY column, type 4 as the mapping value.

    4. For the PANEL_SUB_CATEGORY column, type 410 as the mapping value. For details of various panel category mapping values, see Mapping Codes for Wiring Data Import .

    5. For the DEF_FLG flag, type N so that in Smart Instrumentation, the imported panels appear in the Domain Explorer.

    SHARED Tip If you define Y as a mapping value for the DEF_FLG flag, in Smart Instrumentation, the imported items appear in the Reference Explorer.

  8. If needed, complete the import mapping by dragging the appropriate column names from the Source pane or by entering strings or values in the fields in the Target pane.

  9. Run the import link.

See Also

Flow of Activities for Importing Data into Smart Instrumentation