List of Values Configuration Category

The List of Values set application pane is used to edit the lists of values available when labelling items.

A default set of lists of values is provided with the product. If online validation is active, data entered during labelling is checked against these lists, with only values in these lists being valid.

User-defined lists can also be created. These include lists of pipe attribute values that are linked to a selected pipe specification. If that spec is selected for a pipe, only the values in the associated list of values are available for the pipe attribute in question.

The application pane includes a drop down list:

Select the required validation data set from this list. The content of the data set is then displayed in the grid and may be edited as required. For more information see Principle and Concepts - Validation.

The list also includes any user-defined lists of values.

Note: Before Access by Area security can be enabled for the project, the list of project design areas must be allocated to the Design Area Attribute field in the Settings Sub-Category of the Drawing Configuration Category.
Refer to AVEVA P&ID Security help for details of Access by Area security.

Notable Lists of Values

USERLOV_MAJORREVIVISION and USERLOV_MINORREVIVISION Lists

The list includes the USERLOV_MAJORREVIVISION and USERLOV_MINORREVIVISION lists of values. This is used to specify major and minor revision identifiers.

If this functionality is enabled (in AVEVA P&ID Reports), when the revision of a drawing is incremented, the identifier of the new revision may be selected from the appropriate list of values.

USERLOV_PressureSystem and USERLOV_Hazard

These lists are supplied as default and example lists of values for use with the Engineering Groups functionality. Refer to User Defined Attributes Configuration Category for details.

AlphaNumeric/Numeric Equivalent Size List

The list also includes the AlphaNumeric/Numeric equivalent Size list of values. This is used to specify the numeric equivalents of alphanumeric size values, to be used when data is exported, for example, to a Schematic database.

In the above example, the alphanumeric size value of 20A has a numeric equivalent of 20. As a result, when size values of 20A are exported, they will automatically be converted to 20.

When creating a new entry in AlphaNumeric/Numeric equivalent Sizes, the Size value drop-down will be populated based on the type of project (metric/imperial). For example, for an imperial project, the Size value drop-down will be populated from "Imperial Sizes" list of values and for a metric project, it will be populated from "Metric Sizes" list of values.

Note: The Size Numeric column will always have a numeric value irrespective of the type of project (metric/imperial).

Note: The user is restricted to providing an alphanumeric value for the Size Numeric column using proper validations.

The above mapping will be used to populate the Nominal Diameter (Size Numeric) column in P&ID reports for all item types with a "Size" attribute field. This column will hold the "Numeric Size" which was mapped against the Size (Alphanumeric) under AlphaNumeric/Numeric equivalent Sizes grid in the Project Administrator List of Values.

Units List

The list also includes the Units list of values. This is used to specify the project standards for units.

In the above example, the description value of Pressure has been defined for Pascal, KiloPascal, MegaPascal and Bar units.

New units can be created.

In the Description field, the selection of a standard unit value is mandatory.

If a standard unit is not selected, a message is displayed requesting that the user selects a standard unit:

Created units can be deleted. Standard units cannot be deleted. If the user attempts to delete a standard unit, a message is displayed:

Instrument Label Positional Data

The list includes the default label positions applied to SPP fields for required symbols.

In the above example, default label positions have been defined for Prefix, Type, Number, Suffix and Tag.

If a field value is specified as “NO”, the default value for that particular field, for example, Add Block or Add Function, is set to “No” when the symbol is added to the drawing. The instrument label information is not added to the drawing and existing labels are deleted.

If a field value is specified, the default value for that particular field, for example, Add Block or Add Function, is set to “Yes” when the symbol is added to the drawing. The label information is added to the drawing.

The value for the label position fields can be overwritten using the AVEVA P&ID Instrument Properties dialog when the symbol is added to the drawing. The value is remembered for respective symbols.

To edit a value, select . The following dialog box is then displayed:

Select Yes from the Display Coordinates drop down list to activate the X Coordinate and Y Coordinate fields. If a default label position is not required, select No.

Enter the X Coordinate and Y Coordinate values and click OK.

Drawing-Specific Pipe Property Lists

Using the filter value set up for a drawing (refer to Create Pipe Property, Symbol and DataSet Filters based on Drawing Attributes for details), lists of values for pipe properties (Spec, Size, Fluid/Service and Area) may be created that are only available for that specific drawing (and other drawings that share that value), and which must be used when specifying pipe properties for that drawing.

In other words, only those lists of values will be available when selecting pipe properties for that drawing, and the "normal" list of values for pipe properties, and other drawing-specific pipe property lists of values will not be available.

The names of these lists of values must be in following format:

USERLOV_<PropertyName><FilterValue>

For example, where the filter value is 722:

USERLOV_SPEC722

USERLOV_METSIZES722 (for Metric projects)

USERLOV_IMPSIZES722 (for Imperial projects)

USERLOV_SERV722

USERLOV_AREA722

Symbol Exchange List

Used to create mappings between different types of symbols for use when globally exchanging symbols on a drawing (refer to Exchange Symbols Globally for details).

Add a Value to a List

If a value is to be added, select . The following dialog box is then displayed:

Enter a value and click OK. The dialog box will be closed and the entered new value will be displayed in the grid.

Note: The value must be unique, except in the case of equipment and instrument type letters.

Enter a description in the adjacent Description field.

To edit a value, select and enter the new value in the dialog that is then displayed.

Note: In order for reducers to automatically change orientation, so that the wide end is always connected to the larger pipe size and the narrow end is always connected to the smaller pipe size, the list of values for sizes used on the project (Metric Sizes or Imperial Sizes) must set up sorted from smallest size to largest size.

Edit Lists of Values with Import from Excel Spreadsheets

Existing lists of values can be efficiently edited by exporting them to an Excel spreadsheet, editing it in that spreadsheet, and then by importing the amended list back into AVEVA P&ID.

The procedure is as follows:

1. Select the list of values to be exported from the List of Values list.

2. Select the Export to Excel link. A message is then displayed requesting that the user confirm that the export is to take place:

   

3. Click Yes. The selected list is then exported to a spreadsheet. When the export is complete, a message is displayed to inform the user of this, and giving the location of the exported file. For example:

   

4. The list of values can now be edited in Excel. With the list of values selected, click the Open Excel link to open it. For example:

   

   Note: The Open Excel and Import from Excel links are disabled until an export takes place, and disabled again once the changed list of values is imported back into AVEVA P&ID.

5. Add, edit and delete values as required, and then save the file.

6. To import the changed list back into AVEVA P&ID, with the list of values selected, select the Import from Excel link. A message is then displayed requesting that the user confirm that the import is to take place. Click Yes to continue.

7. The list of values in the grid is then updated to reflect the changes made in the spreadsheet.

Edit Pipe Styles

Data entered on this application pane includes the pipe styles that are valid for the project. Select Pipe Styles from the drop down list. The grid then display the current list of pipe styles.

Update existing values, or add new pipe styles as required. If the style of a pipe that exists on a drawing is changed, the drawing will be updated with the new style when it is reloaded.

8. In the Multi-Line (Y/N) field enter Y if the new style is to consist of multiple lines, otherwise enter N. For further details on creating multi-lines, refer to AutoCAD documentation.

9. In the Line Type field, select the AutoCAD line type that the new style is to be based on.

   Note: The list of line types available for main pipes is specified by the USER_ISOLINETYPELIST user-defined directive in the Miscellaneous – Settings Sub-Category.

10. Enter a meaningful description in the Description field.

11. The default Line Type Scale value is 2. This may be changed if required. The entered value will be applied to the pipes of that type when they are created in the main application.

12. To change the drawing layer that pipes of a pipe style are to be placed on, double click on the appropriate field. Choose the required value from the list of values that is then displayed and press Enter to save the selection.

13. To change the colour of a pipe style, double click on the appropriate field. The colour box dialog button is displayed:

On selection of the button, the colour selection dialog box is displayed:

On selection of the button, the colour selection dialog box is displayed:

The Colour Code can be selected by the following four methods:

• Selection of one of the colours shown in the palette

• By double clicking the Assume Owner Colour hyperlink. Items will automatically assume the colours of the owning items. When there is no owning item, they will be set to the default colour.

• By double-clicking on the Assume By Layer hyperlink. Labels will automatically assume the colours of the layers they are inserted into, as set in the Layers Sub-Category the Drawing Configuration Category.

• By manually entering the Colour Code field.

  Following selection, press OK. The selected colour code will then be displayed in the grid.

Create User-Defined Lists of Values

To create a user-defined list of values, select this button in the User-Defined List of Values section of the pane: .

The following dialog box is then displayed:

Enter the name of the new list of values.

If the list is to be of a custom data type, check the Create New Custom Data Type checkbox, and then select the SQL data type of the new custom data type (e.g. integer, float, memo, currency etc.) from the list of values that is then displayed:

Check the Can Be Null checkbox if that is applicable for the custom data type.

Click OK. The dialog box will be closed and the name of the list will be displayed in the grid in the User-Defined List of Values section.

Note: Except in the case of custom data types, the application automatically prefixes the names of user-defined lists of values with "USERLOV_".

The LOV File Name field displays the filename of the list. This is automatically generated and cannot be changed.

Once a list of values has been created, it can be selected from the list of list of values at the top of the pane. The values that comprise the list can then be entered as described above.

The toolbar buttons in the User-Defined List of Values section work in the same way as those in the upper section, as described above. Use these to rename lists of values, sort the lists in the grid, delete lists etc.

To edit a list of values name, select and enter the new value in the dialog that is then displayed.

Create User-Defined Lists of Values linked to Pipe Specifications

Lists of pipe attribute values that are linked to a selected pipe specification can be created. If when labelling a pipe, that spec is selected for a pipe, only the values in the associated list of values are available for the pipe attribute in question.

Select this button in the User-Defined List of Values section of the pane: .

The following dialog is then displayed:

Select the required pipe specification and the associated pipe attribute/property from the dropdown lists:

Press OK. The dialog box then close and list will be added to the grid in the User-Defined List of Values section.

Its name will be the combination of the selected spec and attribute names, prefixed with "USERLOV_". For example:

Once the list of values has been created, it can be selected from the list of list of values at the top of the pane. The values that comprise the list can then be entered as described above.