Map Database Fields to Cable Sizing Template Cells

To map AVEVA Electrical database fields to cells in an Excel template, either double-click on the template in the catalogue grid, or click Open in the Actions section of the List Tools - External Cable Sizing Catalogue tab. The External Cable Sizing Design window is displayed:

There are two types of fields must be mapped:

• Fields that will be completed with data extracted out of Electrical (Export fields).

• Fields that will be completed with the results of calculations that are to be imported into Electrical (Result fields).

There are two main areas to this window:

Datasheet Layout

The left-hand area contains the template spreadsheet layout and shows each cell as previously defined in Microsoft Excel. The layout cannot be changed in this window, it must be changed in Excel. The grey coloured cells indicate which cells have already been mapped (or linked) to a database field.

Note:
To see which DataLink (field) is mapped to a particular cell, click in the cell and the list view will highlight the DataLink. The feature works only when the Used checkbox is checked.

DataLinks List View

The right-hand area contains a list of all DataLinks (database fields). When the Design window is first shown the DataLinks List view show used DataLinks only, that means. those already mapped to a cell.

Whether used or unused DataLinks are displayed is controlled by the Used checkbox. To view only unused DataLinks, uncheck the Used checkbox. To display both used and unused DataLinks, clear the Used/Unused filter by clicking on the clear filter criteria button next to the Used checkbox.

The Object Type column states, for properties which may be of a load or supply, whether it is a load or supply. Cable Sizing Data properties are also indicated.

Map a DataLink to a Cell

Drag the required DataLink from the Fields list to the required cell and drop it onto that cell. If the mapping is successful the cell will become grey.

Un-map a Mapped Cell

Right-click on the cell to display a pop-up menu. From the menu select the Delete Datalink option.

To unlink the mapping from multiple cells hold the Ctrl key down while selecting them, the proceed as described above.

To removed all datalinks from a template, right-click on any mapped call and select the Delete all Datalinks option.

Select a Macro to be run after values have been exported

If a macro is required to perform the required calculations after they have been exported to the template, select it from the Select a Macro to execute after export of values list:

Command Buttons