Workflow for Importing SmartPlant Instrumentation Cables - Intergraph Smart Instrumentation - Reference - Hexagon

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

Do the following in SmartPlant Instrumentation:

1. From the SQL Editor folder in the SmartPlant Instrumentation reference folder, import the Cable Connection.sql file, found in the SQL folder in the SmartPlant 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 SmartPlant 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 SmartPlant 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.

   SmartPlant Instrumentation reference cables (called cable types in SmartPlant Instrumentation) are imported into the SmartPlant 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 SmartPlant Instrumentation and how to define a name range in Microsoft Excel, refer to the pertinent topics in the documentation of SmartPlant Instrumentation and Microsoft Excel.