Import Cable Tray Data

Cable Trays User Guide

Import Cable Tray Data imports equipment tags, descriptions and other attributes from a CSV Excel file.

It is anticipated that this function is used near the beginning of a project to pre-populate a DESIGN database with a list of Cable Tray data from other Engineering data systems. It is not intended for the transfer of data from one Project to another. The geometry of the imported cable tray is not defined by this method. It is necessary to complete the definition of the cable tray by using the Design Equipment GUI.

The import is a two-stage process that initially analyses the import file and reports errors and identifies if the entry is new or appears to exist already in the database. The second stage is to import those entries that you want to, based on the results of the analysis.

The content of the import file used as the input for this function must follow certain rules as described below; otherwise the data import is rejected by the system.

Note:

The LEXICON Database must be correctly configured, and the supplied values must be valid for the User Defined Attribute (UDA) being set.

On the Cable Tray tab, in the Data group, click Import Cable Tray to display the CABLETRAY Data Import window.

From the CABLETRAY Data Import window, navigate to and highlight the required import file. Select an option from the Files of type: pulldown list.

Click Open to display the content of the selected spreadsheet in the Spread Sheet Import window.

At this stage no data has been loaded into the database. The window allows you to preview the data being loaded from the import file. When the file is loaded, some preliminary analysis of the data is carried out, and the icons, that display to the left of the table, indicate the result of that analysis.


	Indicates that a Cable Tray does not exist in the database. If this window is actioned, then the Cable Tray is created.
	Indicates that a Cable Tray already exists in the database. If the Load All Data function is actioned, then attributes of the Cable Tray are modified. No action is taken on rows with this Icon if the Load New Data option is actioned.
	Indicates that the system has identified a problem with this row of data. No action is taken on rows with this Icon when the Load All Data or Load New Data option is actioned. Selecting this row in the table displays a message in the Messages area of the window to indicate why this row cannot be processed. Clicking Load All Data processes all of the rows that create a new element or modify an existing element. Clicking Load New Data option only processes the rows that create new elements.

New data is created at the current location in the database if an owning element field is not included in the imported file. Note that the owning element is considered to be the current element when the file was loaded and the rows of data analysed, not the current element when a Load option is pressed. If an owning element field is provided in the import file, the system attempts to create elements under the specified owner.

Now the Icons on the window indicate the result of the load operation.


	Indicates that the creation or modification operation was successful. An element has been created or modified in the database.
	Indicates that the operation has not completed successfully because of an error found while the system was trying to create or modify an element. If an attribute value is incorrect, as in the example above, then the element has been created, but not all of its attribute data has been loaded. You can choose to use the undo function to remove all of the changes made by the load operation and revert the database back to its state before the load, or to deal with the erroneous elements individually.

Another import file can be loaded by using the File Open Icon, the Browse option or by typing a name directly into the filename field on the window.

The Reload Data option reloads the file shown in the filename field which may be necessary if the current element was incorrect or an owner element was missing when the file was first loaded.

The example above shows User Defined Element Types (UDETS), refer to the Lexicon Command Reference Manual, of equipment being created. If the imported file is carefully constructed it would be possible to import other element types provided that fields in the file contain all of the required data.