Import Terminal Strips and Terminals - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

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

Before importing terminal strips and terminals, make sure you first import or create all the target panels.

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

    2. Under Import method, select Single table.

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

    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_STRIP table. For example, if a panel strip 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_STRIP 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. On the Link Properties dialog, select Table Definition and do the following:

    1. On the Table Definition dialog, select Definition.

    2. On the Table Definition Name dialog, select the definition that you require.

    • The Default definition is only suitable for importing terminal strips of DCS or PLC panels.

    • If you want to import terminal strips that do not have names, select the Panel Strip (by seq) definition.

    • If you want to import terminal strips of junction boxes, cabinets, device panels, or marshaling racks, select the Panel-Strip definition.

    • If you want to import terminal strips of wiring equipment, select the Panel-Apparatus-Strip definition, or a more complex definition, depending on the hierarchy of you wiring items.

    • If you do not find the definition that you require, you can create a new definition based on the Default definition. For details, see Create a Table Definition Based on Another Definition.

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

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

    1. Select the STRIP_NAME row, and then, from the Source pane, drag the column containing the terminal strip names.

    2. Depending on your table definition, map the remaining required columns marked in red bold.

    3. Define a mapping value for the STRIP_CATEGORY column. For example, a Regular Strip the mapping value = 0, for a Plug and Socket Box the mapping value = 2. For details, see Mapping Codes for Wiring Data Import.

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

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

  7. Repeat Steps 1-7 for creating a Terminals link for wires by selecting PANEL_STRIP_TERM as the target table and make sure you map all the required columns.

  8. If you have not imported panels and wiring equipment yet, do the following:

    1. Add the created links into the group containing links defined for panels and their constituent items.

    2. Prioritize the links so that the Terminal Strips link appears under the links defined for panels and wiring equipment and the Terminals link appears under Terminal Strips. For details, see Prioritize Links in a Link Group.

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