bentley - c:usersmichelle.saucierdesktopoppa ......exercise 01: create new spec in this exercise, we...

Practice Workbook

This workbook is designed for use in Live instructor-led training and for OnDemand selfstudy. The explanations and demonstrations are provided by the instructor in the classroom, or in the OnDemand eLectures of this course available on the Bentley LEARN Server (learn.bentley.com).

This practice workbook is formatted for on-screen viewing using a PDF reader. It is also available as a PDF document in the dataset for this course.

DO NOT DISTRIBUTE - Printing for student use is permitted

OpenPlant Project Administrator CONNECT Edition Administration Configure Specification Generator

This workbook contains exercises to OpenPlant Project Administrator that allows users to automate a simple configuration and setup Specification Generator for OpenPlant Modeler.

Note: The exercises are meant to be worked on in the order of the exercises in each Practice Workbook. You can start at any Workbook by installing the accompanying dataset for that Workbook.

TRNC03594-1/0001

Copyright © 2019 Bentley Systems, Incorporated 2DO NOT DISTRIBUTE - Printing for student use is permitted

Description and Objectives

Course Description

This workbook contains exercises to OpenPlant Project Administrator that allows users to automate a simple configuration and setup Specification Generator for OpenPlant Modeler.

Skills Taught

Create New Spec

Edit Spec Table

Add and Edit Spec Header

Add Custom Constraints

Create Custom Description

Creating OpenPlant Catalog

Exercise 01: Create New Spec

In this exercise, we will open the OpenPlant Project Administrator and create a new Spec using Specification Generator.

1. Select the Start menu and navigate to and click OpenPlant Project Administrator CONNECT Edition.


2. In the navigation tree click OpenPlant Modeler to allow Tools from the tools ribbon to turn on.

3. Select Specification Generator.

Specs are created from the catalogs, the first step in any new spec is to add the base catalog.

4. Click New Spec.

5. Click Add Catalog to Spec.


6. Choose a catalog and click Open.


7. For this exercise we will add catalogs as shown below.

Note: this picture is for reference.

a. Import asme.mdb

b. Import Bonney Forged.mdb

c. Import Crane.mdb

d. Import Non-standars.mdb


8. Name your New catalog Admin_Training.

9. Select Save


Exercise 02: Edit Spec Table

In this exercise we will edit the spec table by adding rows and filtering conditions.

1. Click Add New Section then select PIPE from the drop-down menu as shown below.

2. Click OK to add the section.


3. Once PIPE is loaded we now need to edit the row by selecting Add New Row.

4. After Adding a New Row, we will begin by selecting options for PIPE that will be relevant to the project.


5. Options are in drop-down format in each sup-section.

a. In the first row select Class Name is PIPE, Min Size is 1/2, Max Size is 2, Schedule is 80, and End Condition 1 as PL.

b. In the second row select Class Name is PIPE, Min Size is 3, Max Size is 10, Schedule is 40, and End Condition 1 as BW.

c. In the third Row select Class Name is PIPE, Min Size is 12, Max Size is 20, Schedule is STD, and End Condition 1 as BW.


6. The categories should match the standard pipe as shown below.


7. Once the pipe information is selected the template should look as follows.

8. Right-click and select Preview Row.


From the Excel Spread Sheet we do not need 3+1/2 pipe, so lets filter the list.

9. Close the preview.

10. Select Edit then Add Spec Filter.


11. Use the spec list to filter out any unnecessary selections as shown below.

Note: Each Category has a drop-down list for the N.A selection.


12. Select Filter to allow for changes.

Note: Now the correct count for pipe is listed above.


13. Right-click the row to preview the results.

14. The selected row is now correct, as shown below.

Note: Notice that the 3+1/2 is now gone from the list.

15. Select Save Spec.


Exercise 03: Add and Edit Spec Header

In this exercise we will add and edit the Spec Header.

1. In the Edit menu select Add Spec Header as shown below.

2. Select Description and then click Delete Property.


3. Click Add Property.

4. Type in Code: for Enter the name of Property, then click OK.


5. Use the Code name from the excel sheet in the earlier exercise ANSI B31.1 as the description.

Fill out the remainder of the list as follows:

a. For Company type Bentley

b. For Spec.# type 101

c. For Description type Spec Tutorial

d. For Location type Training Exton

e. For Project type New

f. For Code type ANSI B31.1


The list should show as below.



Exercise 04: Create Custom Constraints

In this exercise we will add a custom constraint to our spec.

1. Minimize the Spec Header and Spec Filter grids, then select Look Up Table Editor.


2. In the drop-down menu locate Materials and select Add Lookup Value.


3. Type in ASTM A106 Gr B as the Code and Description.


4. Select Define Custom Fields and select User Field then Add User Field.

5. Type MyMaterials in the Field Name.


6. In the fields section select Lookup Fields and then select Add Lookup Field.

7. Locate MyMaterials in the drop-down under Column and Materials under Lookup Table.



9. Select Add / Remove Constraints from PIPE.


10. Select MyMaterials and move it to the Selected list.

11. Select the drop-down for MyMaterials and locate ASTM A106 Gr B from the selection list.



Exercise 05: Create Custom Description

In this exercise we will create a custom description for the newly created constrain.

1. Right-click inside the row and select preview row.

Note: the long description and its contents.


2. Right-click in the row and select Custom Description.

3. Select Add Description in the Description Fields.


4. In the Column field select LONG_DESCR and for Value type in <<EC_CLASS_NAME>>[, SMLS, SCH.]<<SCHEDULE>>[, ]<<MyMaterials>>.


5. Click the green check mark twice.


6. Right-click in the row and select preview row.

Note: You will need to repeat the steps for each row. Changing the material list will update long description.



Exercise 06: OpenPlant Catalogs

In this exercise we will create a custom OpenPlant catalog from our Admin_Training spec using OpenPlant Project Administrator.

1. From the main ribbon select Tools.

2. Click Specification Generator.

3. From OpenPlant Spec Generator select File then Catalog Editor.


4. From Catalog Editor select File and New.

5. Type in file name as Admin_Training, then click Save.


6. After the Edit Schema dialog opens click Import Data.

7. Click Import from Catalog from the drop-down menu.


8. Find and select the catalog asme.mdb.

9. Import from catalog by selecting TEE and Import Structure Only, then click Import.


10. Extra fields are available to add to the table, however in this exercise click Close.

11. From the drop-down select Tee and the table is added.

12. Under EC_CLASS_NAME select PIPE_TEE_REDUCING_BRANCH.


13. Right-click in the upper left most corner to select all records then Delete Record(s).

14. Under EC_CLASS_NAME select PIPE_TEE_REDUCING_ONE_RUN_AND_BRANCH.


15. Right-click in the upper left most corner to select all records then Delete Record(s).

16. In the remaining category EQUAL_PIPE_TEE locate the


17. Select one option for 3” pipe from the drop-down list, and delete all the rest of the records.

18. Press and hold the Ctrl key down then right-click in the left most corner to Delete Redord(s).


19. Customize your pipe tee by selecting the following drop-down elements.

a. change CTR_END_M to 6.

b. change SHORT_DESC to 6 in SS Equal Pipe Tee.

20. Select Catalog and then click Repair SysIDs.


21. The dialog for Repair Sys IDs will open.

22. Click Add.

23. Select Admin_Trainign.mdb and click Open.

24. Click Repair.


25. From Catalog Editor select file then Close.

26. From OpenPlant Specification Generator select Edit then Add Catalog.


27. Select the catalog Admin_Training.mdb then click Open.

Note: The resulting catalog list should consist of the following.


28. Click Add New Section and type in TEE then click OK.

29. Select Add class to section then find and add EQUAL_PIPE_TEE to the selected group.


30. Click Add a Row from Available fields select EC_CLASS_NAME and SHORT_DESC to that row.

31. Add a second row and in selected fields set the parameters as shown below.

Note: This will allow for selection choices in OpenPlant Modeler.



33. Launch OpenPlant Modeler.

34. Create a new file with the Name Test Catalog.

35. Once open, set Standard Preferences for Piping Component as shown below.

a. Under Specification select Admin_Training.

b. Under Nominal Diameter select 3.

36. From Piping Galleries > Tees > Place Tee.


37. The Equal Pipe Tee dialog box will open.

38. Select the 6in SS Equal Pipe Tee 3 from the list and click OK.


39. Place the component in the model.

Note: One end of the Pipe Tee is 6”.

bentley - c:usersmichelle.saucierdesktopoppa ......exercise 01: create new spec in this exercise, we...

Documents