Workflow for Importing Smart Instrumentation Cables - Intergraph Smart Electrical - 10 - Help - Intergraph Process, Power & Marine Documentation

Intergraph Smart Electrical Import Manager Help

Intergraph Smart Electrical
Search by Category
Smart Electrical Version

The following workflow describes the necessary steps that are needed to import Smart Instrumentation cables and their To and From equipment.

Do the following in Smart Instrumentation:

  1. From the SQL Editor folder in the Smart Instrumentation reference folder, import the Cable Connection.sql file, found in the SQL folder in the Smart Instrumentation home folder.

  2. Generate a View only EDE using the Cable Connection.sql file.

  3. Save the results as an Excel.xls file

    The name of the Excel file must be SPIDomainCables.xls and you must save it in the same location where the SPI_Import.xml (supplied with Smart Electrical) is stored.

Do the following in Microsoft Excel:

  • Open the SPIDomainCables.xls and define a name range for a range that starts at A1 and includes the last cell in the PanelId2 column.

    The name must be SPI_Cables.

Do the following in Smart Electrical Import Manager:

  1. In the left pane, under Link Groups, select the SPI_Import group and then select all the links belonging to this group in the right pane.

  2. Click Tools > Update Source Connection.

  3. On the Data Link Properties dialog box, change the database name to SPI_Cables.xls and make sure that the path points to the location where you saved the SPI_Cables.xls file.

  4. Repeat steps 1 through 3 for the Ref. Cables group.

  5. In the left pane, select all the links belonging to the Ref. Cables group and run import.

    Smart Instrumentation reference cables (called cable types in Smart Instrumentation) are imported into the Smart Electrical cable list in order to create an association between the reference and plant cables. Note that the import procedure only imports the reference cable names without any other data. As a result, you must enter this data manually so that the imported reference cables have all the required data (for example, cable structure). If you decide to enter this data at a later stage and use these reference cables to create plant cables, the software will create these plant cables without any sets or conductors.

  6. In the left pane, select all the links belonging to the SPI_Import group and run import.

For information how to generate an SQL/EDE in Smart Instrumentation and how to define a name range in Microsoft Excel, refer to the pertinent topics in the documentation of Smart Instrumentation and Microsoft Excel.