Data Manager Fundamentals - SS4 - TRN016690 - 10002 - Metric
Data Manager Fundamentals - SS4 - TRN016690 - 10002 - Metric
Data Manager Fundamentals - SS4 - TRN016690 - 10002 - Metric
Fundamentals
V8i
Metric
TRN016690-1/0002
Trademark Notice
Bentley and the "B" Bentley logo are either registered or unregistered trademarks or
service marks of Bentley Systems, Incorporated. All other marks are the property of their
respective owners.
AccuDraw, MDL, MicroStation, and SmartLine are registered trademarks; PopSet and
Raster Manager are trademarks.
Copyright Notice
Course Description
Bentley Data Manager is a powerful relational database management tool for
storing, creating, and customizing project instrumentation, equipment, piping,
and valve data. Bentley Data Manager is the ideal tool for plant engineering,
maintenance, and operation departments.
Bentley Data Manager provides quick and easy access to the Bentley project data
and provides quick, easily-modified reports in a standard format.
Target Audience
This course is designed for engineers, designers, and drafters who are using the
AutoPLANT software and will need to access the data within their projects.
Prerequisites
The student needs to have a working knowledge and at least six months
experience using either AutoPLANT or Microstation.
Course Objectives
After completing this course, you will be able to:
• Log in to Data Manager and use the Data Manager interface.
• Create, edit, and delete tags, and view a tag's properties.
• Sort and filter data displayed in a Data Manager view.
• Modify the view format, create a new view, and change the default view.
• Use the Search and Replace tools and the Database tools.
• Import or export data into or out of Data Manager.
• Open, review, create, and modify Data Manager reports.
Modules Included
The following modules are included in this course:
• Introduction to Data Manager
• Data Manager Tags
• Data Manager Views
• Navigating through Project Data
• Data Manager Reports
Installation Directories:
For AutoPLANT (SELECTseries 4) there are differences in the installation
directories for Windows XP, Windows 7 or Windows Server 2008. The following
tables provide the paths to the software files.
System Requirements
You must have a CD drive or internet access for product installation. The following
prerequisites are required to run the modules included in the AutoPLANT Plant
Design V8i or AutoPLANT Plant Design V8i x 64 (Version 08.11.09.140) or
AutoPLANT P&ID V8i or AutoPLANT P&ID V8i x 64 (Version 08.11.09.140) or
Bentley Process and Instrumentation V8i or Bentley Process and Instrumentation
V8i x 64 (Version 08.11.09.140).
Note: The latest applicable service packs must be used for all of the above products.
Databases Supported
Note: The Bentley I&W applications are only supported on a Microsoft Access
database in a single user, non-networked environment. For a multi-user, server
based project environment, SQL Server or ORACLE® must be deployed.
Note: Please see Known Issues section of this ReadMe for more information
regarding the deployment of Bentley I&W with ORACLE in a 64-bit environment.
Note: Note: Please see Known Issues section of this ReadMe for more information
regarding the deployment of ORACLE 11.2.0.3 in both 32-bit and 64-bit
environment.
Recommended Configuration
Windows 7 Enterprise (64-bit), or Ultimate (64-bit) with:
• Intel® Core™ i7 Extreme, or Intel® Xeon® 5600 processor
• AMD Phenom ™, or AMD Phenom™ II processor
• 8 GB RAM (minimum)
• 1 GB Microsoft Direct3Dcapable workstation-class graphics card
• 2 GB (minimum) available disk space
• AutoCAD 2012 (64-bit)
• Microsoft Office 2010 Professional (64-bit)
• Microsoft SQL Server 2008 R2
Prior to creating a project P&ID, a project must be created. A project has been
provided for your convenience. You will need to unzip this project onto the drive
of your choice. The exercise below installs the project onto the C:\ drive.
Note: You cannot create a project root directory under a project directory.
Therefore, in order for this option to be available in the File menu, you
must select something at the primary root level of the navigation tree.
9 Select C:\Bentley Training Project.
10 Click OK.
Note: The project root folder, C:\ Bentley Training Project, now appears in the
navigation tree at a primary level.
Module Overview
This module will introduce you to the Data Manager application. You will be
guided through Data Manager and become familiar with the interface. You will
then learn about Data Manager's security feature by changing the login and
logging in as a guest.
Module Prerequisites
• Six months experience with AutoCAD or Microstation.
• Familiarity with Microsoft Access.
Module Objectives
After completing this module, you will be able to:
• Open a project using Data Manager.
• Use the Data Manager interface.
• Change login name to increase or decrease permissions within Data Manager.
Note: If you previously logged into another application and set the Save
Password check box, you will not see the Login dialog. You can access
this dialog by selecting File > Log on as a Different User.
Note: Users or groups are granted access to individual projects by your System
Administrator. Bentley Data Manager defaults to logging in with
supervisor privileges by populating the Login Name field with
Supervisor.
6 Click OK.
Views
The views are the main data retrieval and data entry point for project data.
They are how Bentley Data Manager displays the project data to the user.
Views may be modified by delegated project users. As part of this training
course, you will learn how to use views to display and edit data. You will also
learn how to modify a project view to display additional data.
Note: The PID-based views commonly recognized by the AT_ prefix are no
longer a part of the Data Manager application and can be found in the
Project Administrator tool.
Reports
Reports are Microsoft Access reports, which allow project data to be
displayed or published to paper or electronic format. Reports may be
modified by delegated project users. In this course, you will learn how to
display and modify reports.
Macros
The Microsoft Access macro facility provides a way of automating Bentley
Data Manager tasks. This feature will not be covered in this course.
Tables
Tables provide access to the underlying project tables. Generally, this access
should be restricted, and project tables should be hidden from user access to
safeguard project data. Modifications of the tables will not be covered in this
course.
To view the name of the command that will be executed by any toolbar button,
position the cursor over an item and pause. A "tool tip" will display describing
that item.
Project Toolbar
Toolbar Icon Description
Open Project Displays the Open Project dialog, which enables you to
locate and open an existing project
View Toolbar
Toolbar Icon Description
Equipment List Displays the Equipment List view, which shows the
database details for all equipment defined in the current
project. From this view, you can create new equipment
or edit existing equipment details, filter and sort data,
and modify data using a powerful search and replace
engine.
Motor List Displays the Motor List view, which shows the database
details for all motors defined in the current project.
From this view, you can create new motors or edit
existing motor details, filter and sort data, and modify
data using a powerful search and replace engine.
Instrument List Displays the Instrument List view, which shows all of the
instruments defined in the current project. From this
view, you can create new loops, edit existing loops, or
edit individual instruments on a field-by-field basis, filter
and sort data, and modify data using a powerful search
and replace engine.
Refresh Immediately updates displayed information with current
data
Tools Toolbar
Toolbar Icon Description
New Tag Creates a new tag number within the current view
Delete Tag Deletes an existing tag number from the current view
Applications Toolbar.
Toolbar Icon Description
Data Sheet Editor Launches the Datasheets module
Logging On
Bentley provides for different levels of security that can be applied to both
project data and application tasks. While you are not provided details on how
to implement the security, you are introduced to the security within Data
Manager. Security within Data Manager can be applied to either user or
group level, with Bentley recommending a user-level implementation. The
first tasks should be to change the Supervisor password and to set up users.
During this course, you will learn some of the restrictions that are
implemented as standard.
4 Click OK.
Note: Every time a Bentley application is opened, the Login dialog will appear.
If you do not wish to keep clicking OK or entering your password, you
can set the Save Password check box, which will prevent the dialog
from appearing until the Logon as a Different User option is selected.
The Login dialog disappears and Data Manager is displayed. As ChiefEng,
you have the right to modify project data.
5 Select View > Process Instrument List.
6 Select Tools > New Tag.
The Select Type dialog opens.
7 Select AT_INST_.
8 Click OK.
The Tag Number dialog opens to allow you to create a new tag.
9 Click Cancel.
The dialog closes.
4 Click OK.
The Login dialog disappears and Data Manager is displayed.
5 Select the Process Instrument List.
Note the entire view is grey.
6 Select Tools > New Tag.
Note: When you log in as a Guest, you do not have permission to add a new
instrument.
7 Click OK.
To close the New Tag dialog.
8 Select File > Log on as a Different User.
9 Type Supervisor in the Login Name field.
10 Type Supervisor in the Password field.
11 Click OK.
Module Overview
In this module, you will learn the importance of the tagging system within Bentley
applications. You will learn to create several types of component tags, to edit and
delete tags, and to view a tag's properties.
Module Prerequisites
• Familiarity with the Data Manager Interface.
• Using the AutoPLANT tagging system.
Module Objectives
After completing this module, you will be able to:
• Create new tags.
• Edit a tag number.
• Delete tags.
• Modify tag data via the tag information dialog.
• Modify multiple tag data via the tag information dialog.
AutoPLANT Tags
A tag is a generic reference to a physical item in the plant, such as a valve,
instrument, pump, vessel, etc. Each of these items is assigned a tag.
Tags are grouped by type, and each tag type is stored with a tag code in a specific
location to assist the project implementation. AutoPLANT is very flexible in the
handling of tag types and is easily customized.
Every AutoPLANT application works with the same tagged items in the project
database, and each allows the creation, modification, and deletion of tags.
AutoPLANT does not enforce a working method on users and aims to provide a
flexible toolset for all projects. The project managers should decide upon the
tools their users will use to create tags within an AutoPLANT project.
For the purposes of this training manual, it should be pointed out that while
pumps and vessels can be created with AutoPLANT Data Manager, nozzle tags
cannot be created with an association to the pumps or vessels. The association
can only be created using AutoPLANT P&ID.
Note: AutoPLANT displays the Select Type dialog because the Process
Instrument List view displays multiple tag types.
3 Select AT_INST_.
4 Click OK.
Note: The New Tag dialog is closed and the Process Instrument List displays.
Note how the tag number is split into component fields. This is a
feature of the tag type and can be used to assist searches and sort
orders.
Note: Clicking Next will add one to the current value in the Num field. Clicking
Max will return the maximum number for the Num field for the current
Typ field.
6 Click OK.
The Process Instrument List is updated with the new instrument.
By separating the tags into the different tag types, reports and views can be
customized to be tag specific. For example, a user could build a report to
contain only Control Valves.
You have now created some instrument tags in the project database
which are available to all project personnel and visible to all applications
across the project. These instruments can either be inserted into a P&ID
or a 3D MODEL, connected to junction boxes using Instrumentation and
Wiring, and/or be allocated to Datasheets and Hookups.
Note: Within the Status group box, the tag type has changed to Hand Valve.
2 Type BA-100 in the Tag Number field.
3 Click OK.
The valve list is updated with the new tag number.
Note: There is no TYP field on the dialog because the tag format does not
contain TYP.
4 Repeat this exercise to create valve tags GA-100 and GA-200.
Note: The Edit Tag dialog is exactly the same as the New Tag dialog.
3 Type GA-100 in the Tag Number field.
4 Click OK.
The Bentley DataBase Message dialog is displayed, indicating that the tag
number already exists.
5 Click OK.
6 Type CHK-100 in the Tag Number field.
7 Click OK.
The valve number is updated in the Valve List.
Deleting a Tag
By default, tags that are deleted are removed from the project database. Your
project administrator can set the project properties to prevent tags from being
deleted from the database.
3 Click Yes.
The valve is deleted and is removed from the Valve List and the project.
4 Select PID-01-H-11.
5 Select Tools > Delete Tag.
Because the valve has links to project documents it cannot be deleted from
the Valve list.
6 Click Ok.
Tag Information
Tag information refers to the project data that is stored with each tag. This can be
updated by project users. The properties that are displayed for a tag are
particular to the tag type and to the current view. This makes it possible for views
to be created which display only the relevant information for a specific task.
In the previous exercises, we have seen that instruments and valves can have
different formats. You will now see that instruments and valves can have
different data stored with them, and also that similar tag formats such as
instruments and control valves can have different data stored with them. In fact,
the project can define what data can be stored with a tag. If an item needs to be
handled differently than another item, a new tag type will need to be defined.
Data Manager has many ways of entering information. Like the Windows
standard Cut, Copy and Paste, Bentley allows data to be entered against many
tags simultaneously.
1 Select 100-TT-100.
2 Select View > Properties Window.
The Tag Number field in the Property Sheet turns to ** when all of the
instruments are selected.
Module Overview
In this module, you will learn to sort and filter data displayed in a Data Manager
view and modify the view format. You will also learn to create a new view.
Module Prerequisites
• Familiarity with the Data Manager interface.
• Adding, editing, and deleting tags.
Module Objectives
After completing this module, you will be able to:
• Manipulate a view.
• Modify a view.
• Lock a column.
• Highlight columns.
• Make a column read-only.
• Create a new view.
Note: Any field can be used to sort the current view, but the field must be
selected before using the sort option. Generally, when the view is
created, the sort order is decided. A user can override the sort order by
using the sort option.
Note: Only the FT records are displayed. The application window title is
updated to display the filter. A quick filter uses the whole contents of
the current field to filter the records.
4 Select Filter > Count Filtered Rows from the context menu.
5 Click OK.
4 Click Test.
5 Click OK.
6 Click Help.
The Data Manager help displays for this particular dialog.
7 Close the Help screen.
The Filter Builder dialog is still active.
8 Click OK.
The filtered records are displayed, and the application window title is
updated to display the current filter.
9 Select Tools > Filter > Clear Filter.
The filter is removed and all of the records are displayed.
3 Click Design.
The MANUFACTURER and MODEL NO fields are now shown with blue text.
3 Set the From current View Process Instrument List radio button.
4 Click OK.
Microsoft Access is loaded with the view displayed in the query builder.
Note: Bentley Data Manager uses Microsoft Access to design queries and
reports. This provides an established interface and allows queries and
reports from user applications to be easily migrated.
10 Select the Criteria cell for the ITYP field.
11 Type "FT" in the Criteria cell.
Module Overview
In this module you will learn to use the Search and Replace tools and the
Database tools. You will learn how to change your default view and how to
import or export data into or out of Data Manager.
Module Prerequisites
• Familiarity with Data Manager's interface.
• Adding, editing and deleting tags in Data Manager.
Module Objectives
After completing this module, you will be able to:
• Find and replace project data.
• Use the database tools.
• Define a default view.
• Import and export data.
8 Click OK.
9 Click Close.
Warning: There is no UNDO feature, so you should always be careful that the Find
What and Replace With values are exactly what you want. There is no
warning with the Replace command, and it is possible to alter many
project records using it.
Database Tools
Bentley Data Manager is a database-based system, and as such requires a limited
amount of housekeeping.
Warning: For SQL Server and Oracle based projects, this should be carried out by a
qualified DBA (Database Administrator) who is responsible for the server
and data. For other types of projects, a standard toolkit is sufficient for
most scenarios.
Compact Database
This command is used to synchronize your version of the report or view with the
master copy. Due to the multi-user nature of databases, it may be possible that
another user has updated the design of a report or view that you are using. This
task is only required if you have been working on the project for a long time and
you are aware that there have been changes to a report. This task is not
necessary if you open and close Bentley Data Manager at regular intervals (for
breaks or work procedures).
This feature will allow the project database to be checked against the tag type
rules. If Bentley applications are used exclusively to create tags, this option
should never be required. Bentley provides functionality to create tags through
other methods.
This feature will check and update the link tables if any modifications are done.
6 Click OK.
3 Click OK.
The Options dialog closes.
4 Select File > Exit.
5 Re-open Bentley Data Manager.
My Instrument List displays in the right-hand panel.
By default, Bentley Data Manager assumes that an export will NOT be re-
imported to the project. However, this course will cover the ability to modify the
export so the data can be re-imported back into the Bentley project.
8 Click Save.
12 Click OK.
13 Close Data Manager.
14 Open Windows Explorer.
15 Browse to C:\Bentley Practice Projects\Metric Training.
16 Double-click on ValveList.xls.
The data is exported along with all of the fields for the Valve List view.
The exported spreadsheet (or database, text file etc) can be used by third-
party applications or for review by project users without Bentley access.
11 Click OK.
12 Click OK.
The Import message will indicate the success of the action.
13 Click OK.
14 Refresh the Valve List view to see the imported data.
Module Overview
In this module, you will learn about Bentley Data Manager's Reports. You will
learn to open and review reports, create reports, and modify existing reports.
Module Prerequisites
• Ability to navigate through the Data Manager interface.
• Proficiency in editing data.
• Skills required to import and export data.
Module Objectives
After completing this module, you will be able to:
• Open a report.
• Create a new report.
• Modify the record source for a report.
• Add a company logo to a report.
• Modify the format of existing fields in a report.
Bentley Data Manager uses the Microsoft Access report engine to produce
reports, independent of the back-end database engine used. This provides a
flexible and scalable solution to all of your project requirements. Most reports
that can be created in Microsoft Access are available in Bentley Data Manager. A
project created in Microsoft Access can migrate to MSDE and to SQL Server,
without requiring any changes to the reports or views.
Bentley does not register reports, nor does it log users who create or issue
reports.
Note: Reports can be printed to a printer using the Printer icon at the bottom
of the report preview window. For the purposes of this training course,
we will not produce a hard copy of the report.
6 Close the report.
Report Creation
In the following exercises, you will create a new report, open the report builder,
and modify the report structure. You will add a company logo, add text, and
modify the format of some of the existing fields.
This section requires some knowledge of Microsoft Access. While reports can be
created quickly and easily in Bentley Data Manager from existing reports, there is
little benefit in having a duplicate report. Therefore, new reports will be modified
in some way.
Note: If My Instrument List is already present, delete the existing report and
create a new one.
6 Type Transmitter List in the Description field.
7 Click OK.
My Instrument List is now an available report.
8 Double-click My Instrument List to open the report in Preview mode.
The My Instrument List report displays with exactly the same data as the
Process Instrument List report.
Note: All Microsoft Access reports are split into sections. The Report section is
printed once for every report, the Page section is printed once for every
page, and the Detail section is printed once for every record.
Note: The Report and Page sections have Headers and Footers. Headers are
printed at the top of the section, and footers are printed at the bottom
of the section.
Adding Graphics
Exercise 1: Add Graphics to the Report
1 Right-click on My Instrument List report.
2 Select Edit.
3 Click Design.
4 Right-click on the Bentley logo and select Properties.
5 Select the Page Header section.
6 Select the Format tab.
7 Select the Picture field and browse to: C:\Bentley Practice
Projects\Metric
Training\Standards\Instrumentation\Templates\Client.bmp.
8 Click OK.
10 Move the cursor between the Page Header section and the Detail section.
The cursor changes to the resize cursor.
11 Click and drag the Detail section to the smallest size possible.
12 Click and drag the Page Footer section to the smallest size possible.
If you look further at the report, you will see that the data displayed on
the Page Header section and the Detail section appear to be very similar.
However, the data on the Page Header section are labels, while the data
in the Detail section is text.
In the Page Header section, labels are used on a report to display
descriptive text such as titles, captions, or brief instructions. Labels don't
display values from fields or expressions, and they don't change as you
move from record to record, so the data displayed in the Page Header
section will always be the same. This is standard for a Page Header;
therefore, it will contain the field titles.
In the Detail section, text is used to display view values or calculated
values, which will change as you move from record to record. Therefore,
the data displayed in the Detail section will be different for every record in
the view. This allows us to display all of the information from the defined
record source.
13 Close the Microsoft Access window.
14 Click Yes to save the changes.
The My Instrument List is now displayed with only the Flow Transmitter
information and the AutoPLANT logo.
Note: The Toolbox toolbar will appear on the screen as a floating window, and
may appear outside of the Microsoft Access window.
3 Click Textbox on the Toolbox dialog.
When the cursor is moved over the report, the cursor changes to the text
cursor.
4 Click Properties to open the Properties Sheet.
5 Select the Format tab.
6 Scroll down until the Auto Label property is visible.
7 Select No from the list.
12 Select Properties.
13 Type 25.397cm in the Left field.
14 Type 0.3999cm in the Top field.
15 Type 1.998cm in the Width field.
16 Type 0.4cm in the Height field.
Note: A Text box can be bound to any field from the record source. You can
also assign text to calculated values.
The preview option gives a full preview of the report, using all of the data from
the record source. Using this option on a large record source may take some time.
The Layout Preview displays the report with a subset of data and allows an idea of
the layout of the report to be obtained. This is a much better option when
working with a large record source, or when there is a slow connection to the
project data.
Assessment is often equated with evaluation, but the two concepts are different.
Assessment is used to determine what an individual knows or can do.
Complete the assessment to see what you have gained from reviewing this
module or course (access to surveygizmo.com is necessary). When you complete
the online assessment, you will receive your Learning Units.
Note that assessments are for classroom or virtual classroom learning, and not for
OnDemand learning.
Questions
1 What is the command to change your login?
A. File > Log in
B. File > New User
C. File > Log in as a different user
D. Tools > Log in as a different user
2 Data modification must be on individual records
True
False
3 Which command would be used to show Manufacturers of a specific type
A. Build Filter
B. Filter
C. Sort
D. None of the above