Smart Instrumentation utilizes a predefined SQL query in order to export Smart Instrumentation cables to Smart Electrical. The SQL query is called Cable Connection and is found in the SQL folder that was installed in the folder where you installed Smart Instrumentation. After generating the Cable Connection.sql, you save the results as an Excel.xlsm file.
You can also generate the SQL query as a view only EDE, and then save it as an Excel.xlsm
file.
The following data is included in the SQL:
-
The cable names (including all the relevant KKS segments if working in KKS mode).
-
The cable types.
-
The item tag connected to the From side — the panel_name or cmpnt_name to which the cable is connected at its End 1.
-
The From description — cmpnt_serv (if it is an instrument)
-
The From category — the From panel/instrument category (instrument, device panel, junction box, cabinet, DCS or PLC panel, and so on).
-
The To item tag — the panel_name or cmpnt_name to which the cable is connected at its End 2.
-
The To description — cmpnt_serv (if this is an instrument).
-
The To category — the To instrument or panel category (instrument, device panel, junction box, cabinet, DCS or PLC panel, and so on).
-
The pulling area.
The From item tag and the To item tag values reflect the cable destinations, that is an instrument (cmpnt_name) or a panel (panel_name), depending on a particular case.
The destinations are included in the export so that Smart Electrical is able to create them as objects and add the relevant associations. The basic rules for these objects are:
-
For a device panel associated with a single instrument, the software retrieves the instrument name.
-
If multiple instruments are associated with the same device panel and run in the same cable, the software retrieves the first connected instrument.
Smart Instrumentation also exports all the equipment that that is associated with the cable ends regardless
of whether this equipment is connected or not.