Map Database Fields to Datasheet Cells

The Datasheet Design window is used to add or modify the database field to workbook/worksheet cell mappings for each form definition in the Datasheet Catalogue.

To display the window, elect the form definition from the Datasheet Form Catalogue Grid and click the Open option in the List Tools - Datasheet Catalogue tab.

The window shows the datasheet form layout as previously created using Microsoft Excel.

There are two main areas on this window:

• Datasheet Layout

  The left-hand area contains the spreadsheet layout and shows each cell as previously defined in Microsoft Excel. The layout cannot be changed here.This must be done using Microsoft Excel. The grey coloured cells indicate which cells have 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 in the DataLinks List View. The feature works only when the Used checkbox is checked in the DataLinks List View.

• DataLinks List View

  The right area contains a list of all DataLinks (database Fields) previously defined in AVEVA Electrical. This also contains system fields that are predefined in Datasheets to enable access to equipment and project data.

  Note:
  New properties and the fields to be used to represent them can be user-defined for equipment. Refer to Add New Property Definition. Refer the New Properties button.

  Note:
  The Print button in this window prints the datasheet form with Datalink mappings.

  When this window is first displayed, the DataLinks List view shows used DataLinks only.

  Note:
  Sort the lists by clicking on the column header.

  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.

Map a DataLink to a Cell

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

Note:
If the DataLink is for the first (Tag1) of a multiple tag datasheet then the dragging and dropping of a Tag1 field will auto-assign all other DataLinks of the same field name if both Tag1 TagNo and Tag2 TagNo fields are already mapped.
For example, if the user drags PressureMax for Tag1, if the Automatic Copy for multiple Tags checkbox (at top of window - only displayed for form definitions with multiple tags) is checked, then Engineer will attempt to assign DataLinks for PressureMax to Tags 2, 3 and 4 also, using the row/column offset between Tag1 and Tag2 to offset the other fields. The feature makes assigning mappings for multi tag datasheets far more efficient.

Note: It is recommended that the DataLink list view is sorted by Field to more easily identify the fields being mapped.

Note: If a picklist is assigned to a field in the Grid Manager (see the Common Functionality User Guide for details), the picklist will not automatically be available for that field when mapped to a cell in a datasheet. The pick-list must still be assigned to the cell using the facilities described below (see Assign a PickList to a Cell).

Unmap or Unassign a Mapped Cell

Right-click on the cell to display a menu and select the Delete DataLink option.

Note:
Multiple cells or ranges can be selected and multiple Datalinks deleted from using this option (hold the Ctrl key down to select multiple cells).

Command Buttons

Once saved, the new or modified Catalogue Form is ready to be used on the project. It is recommended that the mappings be tested thoroughly prior to use on a project.

Note:
Users should not modify these cell/field mappings for a datasheet type at the same time other users are accessing datasheets of the same Catalogue type.