The Datasheet Template Editor dialog gives users the capability to use the Standard control options such as Check Box, Radio Button List, Picture Box and Free Text Cell in datasheets template if required.
Mapping Checkbox to Datasheet Template Cells – A Worked Example
Check Box option is often used in datasheet template, if the desired database attribute to be mapped to the template has database attribute type “logical”.
To map a Check Box option to the datasheet template, select the preferred datasheet cell e.g.F18.
From the Standard Control menu double click on the “Check Box” option to assign the “Check Box” to the selected cell as shown:
www.aveva.com
In the “Properties” section of the Datasheet Template Editor dialog. Delete the Caption “Check Box” if is not required.
Datasheet Editor also supports the mapping of ‘CheckBox’ control to multiple cells.Drag the required database attribute in this case “Schematic Item Link” from the Data Source field to datasheet cells with the “Check Box”. If the mapping is successful the cell will become yellow.
157
www.aveva.com
© Copyright 1974 to current year.
Mapping Radio Buttons to Datasheet Template Cells – A Worked Example
Radio Button option is often used in datasheet template, if the required database attribute to be mapped to the template have defined list of values.
To map a Radio Button option to the datasheet template, select the preferred cell, and then double click on the “Radio Button List” option from the Standard Control menu to assign the “Radio Button List” to the selected cell as shown:
Drag and drop the preferred database attribute in this case “Fluid Phase” from the Data Source field to datasheet cells with the “Radio Button List”.
www.aveva.com
The orientation of the displayed list of values could either be vertical or horizontal. This can be modified via the“Properties” section of the Datasheet Template Editor dialog when the mapped “Radio Button List”. Cell is selected
Mapping Picture Box to Datasheet Template Cells – A Worked Example
Picture Box option is used in datasheet template, if user(s) wants to bind a picture file to the database template.
To bind picture file to the datasheet template, select the preferred cell. Double click on the “Picture Box”
option from the Standard Control menu to assign the “Picture Box” to the selected cell as shown:
159
www.aveva.com
© Copyright 1974 to current year.
In the “Properties” section of the Datasheet Template Editor dialog. Click the browse button in the
“Image” field and select the preferred picture file:
To display the properties fields of the picture box, the mapped picture box cell must selectedClick on the “Open” tab from the Open File dialog to bind the image to the datasheet template. The bound image size can be re-sized by selecting the preferred size from the “Size Mode” field.
The image URL can also be set to the mapped picture box in datasheet template if requiredTo replicate the mapped image on every page/sheet of the datasheet template, a ‘Repeating Area’ is added to the mapped image cell using the ‘Add Area’ mechanism as described below:
Select the mapped image cell and click on the Add Area button from the context menu / main toolbar to define the Repeating Area.
www.aveva.com
In the displayed Properties window, select the appropriate Area Type from the available pull-down list, in this case ‘Repeating’
Click on the AssoiciatedSheets field to select the desired page/sheet. In the example select the Sheet2 checkbox and click the OK button to save the settings.
Repeating Area could also be applied if required to free text, mapped cells, Header and Footer.161
www.aveva.com
© Copyright 1974 to current year.
Finally select datasheet template ‘Sheet 2’ to view the Repeating Area.
www.aveva.com
Mapping Free Text Cell to Datasheet Template Cells – A Worked Example
Free Text Cell option is used in datasheet template, if user(s) or Administrator wants the cell value to be editable, when datasheet instance is created in AVEVA Engineering (Tags).
To map a Free Text Cell to cells in the datasheet template, select the preferred datasheet cell as highlighted:
Double click on the “Free Text Cell” option from the Standard Control menu to assign the “Free Text” to the selected cell as shown:
163
www.aveva.com
© Copyright 1974 to current year.
The mapped cell color feedback can be modified by the Administrator if required via the Datasheet Template Setting form accessible via Datasheet menu in Lexicon main toolbar.Mapping Page Info to Datasheet Template Cells – A Worked Example
The Page Information option provides the capability to map page number to datasheet template. The toolbox provides the following properties:
Page Number- Displays the current Datasheet page number in a cell
Total Pages- Displays the total number of Datasheet pages in a cell
CurrentofTotal - Displays the value defined by the Paging Format property, e.g. Paging Format “{0}of {1}” where {0} represents the current page number and {1} the total number of pages
To map to the Page info. Select the “Page Info” control from Standard Controls and then drag and drop onto the cell. (e.g.O5)
www.aveva.com
Then update PageInfo properties to the preferred Paging format.
Complete the PageInfo properties field as shown:
Paging Information: From the available pull-down list select Current Of Total option.
Paging Format: Enter {0} of 3
Mapping Process Cases to Datasheet Template Cells – A Worked Example
In datasheet, Process cases can be represented in two ways:
Controlled Cases
Cases in Continuation AreaTo use the Case functionality appropriate cardinality must be defined for each distributed attributes that may be created. The cardinality defines the number cases the attribute has for each tagged item.
Cardinality definitions, defines the minimum and maximum number of each of the distributed attributes that may be created. A -1 in the maximum definition represent an infinite numberThe worked example below illustrates how to map process cases to datasheet template.
165
www.aveva.com
© Copyright 1974 to current year.
Mapping Case Control to Datasheet Template Cells - A Worked Example
Mapping a Case Control to datasheet template allows user(s) to display process case data and as well as control of the display of governing case data in the datasheet instance if required.
To map Case Control, select the Cases control from Standard Controls as shown below. Drag and Drop the Cases control onto a cell, in this example drag and drop it on cell F30.
Right-click on the preferred mapped cell and assign the appropriate the Case Group. In this example assign mapped cell ‘F24-27’ and F31-34 to Case Group (Case-Sheet1-31-6).
www.aveva.com
Select the Control case cell (e.g. GOV Case) to highlights the entire assigned mapped cell.
The Case control cell will display the number of cases corresponding to the predefined cardinality definition in the data model once it is assigned to mapped attribute cell with predefined cardinality definition.