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

SmartPlant Electrical Import Manager Help

PPMProductFamily
Engineering and Schematics
PPMProduct
Intergraph Smart Electrical
PPMCategory
Help
Version_SPEL_custom
2015 R1 (7.1)
Version_SPI_custom
(none)

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

Do the following in Smart Instrumentation:

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

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