Import Panels - Intergraph Smart Instrumentation - Help

1. Create a link group for placing the link you are going to create and links defined for panel constituents, for example, wiring equipment, terminal strips, and terminals.

2. 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 Panels.

   2. Under Import method, select Single table.

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

   4. Complete the import link creation.

3. 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.

   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 panel manufacturer in your source does not match the manufacturer that already exists in Smart Instrumentation, the software indicates that this manufacturer 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.

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

   

   • If your import source 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.

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

6. 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 panel names.

   2. Depending on your source panel type, define a mapping value for the PANEL_CATEGORY and PANEL_SUB_CATEGORY columns. For example, to import a Field Bus Plug and Socket Device Panel you would select PANEL_CATEGORY = 4 and PANEL_SUB_CATEGORY = 430 or for a Junction Box with a Patch Panel PANEL_CATEGORY = 1 and PANEL_SUB_CATEGORY = 140. For details, see Mapping Codes for Wiring Data Import.

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

   4. If you need to specify a panel location, for the PANEL_LOC_NAME/PANEL_LOC_ID column, enter the target location, for example, Building+'/'+Room

   In Smart Instrumentation, the imported panel location hierarchy appears in the folder Panels by Location.

7. 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.

8. In the link group containing links defined for panels and their constituent items, prioritize the links so that the Panels link has the highest priority. For details, see Prioritize Links in a Link Group.

9. Run the links in this order.

   If you must create a single link for importing panels and their child items, you need to select PANEL_STRIP_TERM as the target table and select Insert data into reference tables check box on the Link Properties dialog. Bear in mind that such a link opens more slowly than a single-table link due to a large number of reference tables that the PANEL_STRIP_TERM table has. Also, when running such a link, you are more likely to come across various errors due to the mapping complexity. Troubleshooting these errors may be time consuming.

See Also

Create a Link Group
Importing Wiring Data
Mapping Codes for Wiring Data Import
Flow of Activities for Importing Data into Smart Instrumentation