To apply user defined Unit sets to column headings or modify existing column headings Unit Sets the user must have the appropriate access right.
In this example, close all previous AVEVA Tags sessions and enter AVEVA Engineering-Tags module as TAGSADMIN user “A” with the following details: Username: A. TAGSADMIN; Password:
A; MDB:A-TAGS
Open ‘Lines list’ list view from Process Lines category.
Click the unit icon button in the “Maximum Design Temp” column to display default of units of measure.
In Unitssub -m e nu, th e curre nt Unit isse le cte d b y de fault. And If th e unit icon isnot disp lay e d, se le ct th e “Show Units in Column Headers” ch e ckb ox in th e Grid Options group of View tab to disp lay unitsiconTo apply desired unit sets to column headings or modify existing column headings Unit Sets, then click on theManageicon in the“List and Schedules”group, the “Manage Lists”form is then displayed.
www.aveva.com
From “Manage Lists”, select the preferred list e.g.”Line List” and click on the lowerPropertiesbutton, the List Managerform will be displayed.
Select the“Fields”tab from the “List Manager” form to display the Field tab content.
From the “Unit Sets” column, click on the pull-down window and select the appropriate Unit Set name, in this case “Temperature”.
Th e Unit se tsde finitionsare done in AVEVA Le x icon b y th e sy ste m Adm instrator. In List Manage rForm Unit Se tscolum ns, only disp lay UnitSe tsde finitionsnam e sif th e attrib ute h ave ap p rop riate unit dim e nsions.www.aveva.com
Then click on theOKbutton from theList Managerform to Save theFieldssettings and close theList Managerform. TheManage List formis then displayed as shown:
Finally, click on theOkbutton from theManager Listsform to confirm the settings and close theManage Listsform.
To refresh the displayed List (Line List) with the unit sets definitions, close and re-open the affected list.
Then click the unit icon button in the “Maximum Design Temperature” column to display user defined Unit Sets as highlighted above.
5.6.2 Changing Column Headings Units of Measure – A Worked Example
To change the units for a column, open ‘Lines list’ list view from Process Lines category.
If “Lines list’ view isp re viously op e ne d, do not re -op e n, sim p ly p roce e d with following ste p sb e low.Click the unit icon button in the column heading, and select the desired unit e.g “Kelvin” from the displayed list.
www.aveva.com
The values in the column are then re-calculated in accordance with the new unit of measurement as shown:
Th e unitsch ange isonly foruse rp re se ntation, it doe snot affe ct th e p roje ct de fault unitsTo increase the precision to preferred number of decimals, for example “3” decimal points.Click the unit icon button in the “Maximum Design Temperature” column heading and select thePrecisionoption.
Increase the precision to preferred number of decimals, for example 3 decimal points and click on the “OK”
button.
The attribute “Maximum Design Tempearture” precision are then increased to number 3 decimal points
www.aveva.com
To remove the “Trailing Zeroes”, click the unit icon button in the “Maximum Temperature” column heading and select the “Remove Trailing Zeroes” checkbox option.
5.7 Column Numbers Summaries Calculations
In a list view, if the Summaries icon is enabled, the actual summaries of values in the numeric column can be calculated and displayed beneath the column if desired. This is described in the following worked example.
5.7.1 Column Number Summaries Calculations – A Worked Example
To calculate the total numeric Average, Maximum and Minimum of the value in “Maximum Temperature”
column, Open ‘Process list’ list view from “Process Lines” category.
In th ise x am p le , close allp re viousAVEVA Engine e ring-Tagsse ssionsand e nte rAVEVA Engineering-Tags m odule asPROCENG use rwith th e following de tails: Use rnam e : A.PROCENG; Password: A;MDB: A-TAGS .
If th e “PROCENG” AVEVA Engineering-Tags se ssion isp re viously op e ne d, do not re -e nte rth e se ssion, sim p ly p roce e d with following ste p sb e low.If theColumn Summariesicon is not displayed, select the “Column Summaries” checkbox in the Grid Options group of View tab to display units icon as shown:
www.aveva.com
Click the“Column Summaries”icon from “Maximum Temperature” column. Then check the following Average, Maximum and Minimum checkboxes.
,
Th e Sum iconsare only disp lay e d in h e adingsof attrib ute with UDA ty p e Re al.Click theOKbutton from the “Select Summaries” form to confirm the selection. The total numeric sum of the value in “Maximum Temperature” column is then displayed beneath the column as shown:
To re m ove th e Sum m arie s colum ns, unch e ck th e following Average, Maximum and Minimum ch e ckb ox sfrom th e “Select Summaries” form and click th e OK b utton.5.8 Copying List Data
The copy functionality allows users to copy the content of a cell in a list. This can either be single or multiple cell copy as described in the worked example.
5.8.1 Single Cell Copy of List Data – A Worked Example
To copy single cell content in a list, open list view e.g “Line list” from “Process Lines” category.
Select the desired cell and clickCopyin the Clipboard group of the Home Tab, Or right-click and select Copyfrom the menu that is then displayed, alternatively press Ctrl+C.
To paste into a cell in a list, select the desired cell and clickPastein the Clipboard group of the Home Tab or right-click and selectPastefrom the menu, or press Ctrl+V.
www.aveva.com
5.8.2 Multiple Cells Copy of List Data -A Worked Example To copy the content of cell to multiple cells:
Click on the cell with the desired content (e.g B-56 “Fluid Code” cell) and use standard window selection methods (e.g. left mouse click plus Ctrl and Shift keys) to select other multiple empty cells to copy the data to as shown:
Once multiple cells have been selected right click on the edited cell and selectFill Downfrom the right-click menu.
The selected cells are then automatically updated as highlighted.
To cut th e conte nt of a ce llin th e list, se le ct th e list and click Cut in th e Clip b oard group of th e Hom e Tab , orrigh t –click and se le ct Cut from th e Me nu th at isth e n disp lay e d, orp re ssCtrl+ X5.9 Autonaming Records
Records in a list view can be renamed if required; this can be done by applying autonaming rules via the
“Auto naming” option or manually by clicking the “Rename”option from the “Edit”option in the Records group of the Home tab.
Automaning rules are usually defined by the system administrator in accordance with the company naming conventions or format. When the rules are activated and applied to new or existing records, the selected records are automatically named according to the current applicable rules. This is described in the following worked example.
Th e Autonaming Se tup form isin th e Admin Toolsgroup of th e Admin Tab . Th e Admin tab isonly disp lay e d if th e use risa m e m b e rof th e TAGADMIN te am . Form ore de tail, p le ase re fe rto TM3552-www.aveva.com
To illustrate this;
Click on “Line SeqNo” attribute cell for “B-56”.
Edit the value from “56” to “70”. The selected record is automatically renamed to display the updated attribute.
Autonam ing rule swillfailif th e nam e alre ady e x istsin th e list data ordatab ase .Autonaming rules can also be applied to existing records that are not named according to the current applicable rules.
To do this, select the record row “B-1”
Click on the down-arrow button next to theEditoption in the Records group of theHometab. From the menu that is then displayed, clickRenameoption.
www.aveva.com
The “Rename element”form is then displayed with the current value.
Enter the new name “/B-1-N” and clickOKbutton to apply the change as shown below:
Select the record row “B-1-N” and click on the down-arrow button next to theEditoption in the Records group of theHometab. From the menu that is then displayed, clickAutonamingoption.
Autonaming rules automatically update the selected record according to the current applicable rules as highlighted below.
www.aveva.com
5.10 Find and Replace Text in List Data
TheFind and Replacefunction enables users to find, highlight list data value or headings and optionally replaced any text string within a list. This is described in the example below.
5.10.1 Find and Replace Text in List Data – A Worked Example
To find heading text “Fluid Code” within the “Line List” list, enter the text (Fluid Code) to be searched for in theFINDfield in the Find Replace group of theHomeTab.
Click the pull list next to binoculars symbol and select the “Search in Headings”.
Click the button with the binoculars symbol next to theFindfield .The first row that contains a match is then highlighted and the cell that contains the match is selected.
To find data value text e.g “A-42” within the “Line List” list, enter the text (A-42) to be searched for in the
“FIND” field in the Find Replace group of theHomeTab.
www.aveva.com
Click the pull list next to binoculars symbol and select the “Search in Data Values”.
Click the button with the binoculars symbol next to the Find field .The first row that contains a match is then highlighted and the cell that contains the match is selected.
Alternatively, click“Find”or“Replace” icon in the drop-down list accessed from the arrow to the right of button next to the “Find”field, or right-click on a list and select the“Find and Replace”option from the menu.
The“Find and Replace”is then displayed as shown:
Exercise 2 - Create and Modify Records
1. Open “Linelist” list view and create the following records (B-81,B-82,B-83andB-84) using the“New”
button in the records groups of the home tab as described:
The Mandatory and Optional information fields should be completed as shown below:
Line Code Line Sequence Number Fluid Code
B 81 HC
B 82 HC
C 83 HC
C 84 HC
2. Add the following attribute data in the table to the newly created records.
New Record Line Size Fluid Phase Fluid Spec Stress
Critical
B-81 200 Liquid Hydrocarbon
A3B
B-82 250 Liquid Hydrocarbon A3B
C-83 80 Liquid /Gas Fuel Oil F1C
C-84 100 Liquid / Gas Fuel Oil F1C
www.aveva.com
3. Use the Multi-Record capability;
Add the following attribute value in the table to the newly created records.
New Record Line List Rev
B-81 1*
B-82 1*
4. Use the Multi-Record capability, edit existing attribute value for the following records.
New
5. Copy the “Line List Rev” attribute value of B-81 and B-82 to the
“Line List Rev”attribute value of C-83 and C-84 using the “Fill Down” option as shown.
6. Change column heading “Line size” units of measure from mm to inches as shown:
Th e unitsch ange isonly foruse rp re se ntation, it doe snot affe ct th e p roje ct de fault unitswww.aveva.com
6 Creating \ Editing Records Using Excel Import/Export Tool
This section describes how to use the Excel Import/Export tool in AVEVA Engineering Tags. The Excel Import and Export tool supports the import and export of Excel Workbook files to and from Engineering database. The Import/Export tool also provides the capability to highlights differences and accepts or rejects attribute data updates.
This tool is designed to support activities such as;
Import of attribute data such as operating pressures and temperatures from external system.
The import of elements generated in an external system, such as Equipment and Nozzles.
The round tripping of elements in and out of the Engineering database.