TM-6107 AVEVA Instrumentation (12 1) Integration Rev 3.0

AVEVA A VEVA Ins In s t r u m ent en t ati at i o n (12.1)

E DI

Integration

U G G NI NI A R

TM-6107

T www.aveva.com

AVEVA Instrumentation™ (12.1) Instrumentation Integration (TM-6107)

Copyright © 2014. AVEVA Solutions Limited and its subsidiaries. All rights reserved.

2

www.aveva.com


Revision Log Date Da te

Revisio Re visio n

27/05/2014

1.0

15/04/2015

2.0

24/05/2016

3.0

Descript De script ion of Re Revision vision

Approved for AVEVA Instrumentation Training 12.1 SP2 Approved for Training with AVEVA Instrumentation 12.1 SP3 Fix 4 Updated for AVEVA Electrical Training 12.1 SP4

Autho r

Reviewed Re viewed

Approv ed

GO/TG

TG

GC

KI/GO

TG

GC

JV

AG

GC

Updates All headings containing updated or new material will be highlighted.

Suggestion / Problems If you have a suggestion about this manual or the system to which it refers please report it to the AVEVA Group Solutions Centre at [email protected] This manual provides documentation relating to products to which you may not have access or which may not be licensed to you. For further information on which products are licensed to you please refer to your licence conditions. Visit our website at http://www.aveva.com

Disclaimer 1.1

AVEVA does not warrant that the use of the AVEVA software will be uninterrupted, error-free or free from viruses.

1.2

AVEVA shall not be liable for: loss of profits; loss of business; depletion of goodwill and/or similar losses; loss of anticipated savings; loss of goods; loss of contract; loss of use; loss or corruption of data or information; any special, indirect, consequential or pure economic loss, costs, damages, charges or expenses which may be suffered by the user, including any loss suffered by the user resulting from the inaccuracy or invalidity of any data created by the AVEVA software, irrespective of whether such losses are suffered directly or indirectly, or arise in contract, tort (including negligence) or otherwise.

1.3

AVEVA's total liability in contract, tort (including negligence), or otherwise, arising in connection with the performance of the AVEVA software shall be limited to 100% of the licence fees paid in the year in which the user's claim is brought.

1.4

Clauses 1.1 to 1.3 shall apply to the fullest extent permissible at law.

1.5

In the event of any conflict between the above clauses and the analogous clauses in the software licence under which the AVEVA software was purchased, the clauses in the software licence shall take precedence.


3

www.aveva.com


Copyright Notice All intellectual property rights, including but not limited to, copyright in this Training Guide and the associated documentation belongs to or is licensed to AVEVA Solutions Limited or its affiliates. All rights are reserved to AVEVA Solutions Limited and its affiliates companies. The information information contained in this Training Guide and associated documentation is commercially sensitive, and shall not be adapted, copied, reproduced, stored in a retrieval system, or transmitted in any form or medium by any means (including photocopying or electronic means) without the prior written permission of AVEVA Solutions Limited. Where such permission is granted, AVEVA Solutions Limited expressly requires that the Disclaimer included in this Training Guide and th is Copyright notice is prominently displayed at the beginning of every copy that is made. Licenses issued by the Copyright Licensing Agency or any other reproduction rights organisation do not apply. If any unauthorised acts are carried out in relation to this copyright work, a civil claim for damages may be made and or criminal prosecution may result. AVEVA Solutions Limited and its affiliate companies companies shall not be liable for any breach or infringement of a third party's intellectual property rights arising from the use of this Training Guide and associated documentation. @AVEVA Solutions Limited 2016

Trademark Trademark Noti ce AVEVA™, AVEVA Instrum entation™, Tribon and all AVEVA product and service names are tradem arks of AVEVA Group plc or its subsidiaries.

Use of these trademarks, product and service names belonging to AVEVA Group plc or its subsidiaries is strictly forbidden, without the prior written permission of AVEVA Group plc or AVEVA Solutions Limited. Any unauthorised use may result in a legal claim being made against you. Fluent is a trade mark of Microsoft Corporation. The Fluent user interface is licensed from Microsoft Corporation by AVEVA and use of the Fluent trademark is strictly forbidden. All other trademarks belong to their respective owners and cannot be used without the permission of the owner.


4

www.aveva.com

Contents 1

2

3

4

5

6

7

Introduction .............................................................................................................................................. 7 1.1 Ai m..................................................................................................................... m..................................................................................................................................................... ................................ 7 1.2 Objectives ......................................................................................................................................... 7 1.3 Prerequisites .................................................................................................................................... 7 1.4 Course Structure .............................................................................................................................. 8 1.5 Using this guide ............................................................................................................................... 8 AVEVA AVE VA In teg rat io n Ser vi ce ..................................................................................... ..................................................................................................................... ................................ 9 2.1 Micro sof t sof tware Prerequi sit es t o start AVEVA Int egratio n Service .... ....... ...... ...... ...... ...... ...... ...... ...... ...... ...... ...... ..... .. 9 2.2 Tur ni ng on Mic ro soft so ft Messag e Queu e (MSMQ) Featur e ........... ................. ........... ........... ........... ........... ........... ........... ........... ........... ........ 9 2.2.1 Start Message Queuing ........................................................................................................... 10 2.2.2 Start Message Queuing Triggers ........................................................................................ ............................................................................................. ..... 10 2.2.3 Allow Permission to User ................................................................ ......................................................................................................... ......................................... 11 2.3 Start AVEVA Int egr ati on Servi ce ........... ................ ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... .......... ..... 14 2.4 Ad di ng Data t o Ser vi ces fo r AVEVA Ins tr um ent ati on ................................................................ ................................................................ 16 2.5 Comp are/Upd ate Conf ig ur atio ns ........... ................ ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... .......... ..... 18 2.6 Comp are/Upd ate Colo ur Conf ig ur atio n .............. .................... ........... ........... ........... ........... ........... ........... ........... ........... ............ ........... ........... ........... ....... 24 1.6 Imp ort or t In st rument ru ment Tags fr om AVEVA Diagr ams 14.1 ........... ................ ........... ........... ........... ........... ........... ........... ........... ........... .......... ..... 25 25 Integration with AVEVA P&ID ............................................................................................................... 29 3.1 Overview - Workflow ...................................................................................................................... 29 3.1 AVEV A P& ID - Pro jec t Set up ................................................................ ......................................................................................................... ......................................... 30 3.2 AVEV A In st ru men tat io n - Pro jec t Set up ...................................................................................... ...................................................................................... 32 3.3 Imp ort or t Conf ig uratio ur atio n fo r AVEVA P&ID ............... ..................... ........... ........... ........... ........... ........... ........... ........... ........... ............ ........... ........... ........... ....... 33 3.4 Mapp in gs fo r Lo op : Elemen t Type ............... .................... ........... ........... ........... ............ ............ ........... ........... ........... ........... ........... ........... ........... ........... ........ .. 35 3.5 Mapp in gs fo r Inst ru ment : Elemen t Typ e ......... .............. ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... .......... ..... 36 3.6 Imp ort or t Lo op s fr om AVEVA P&ID .............. .................... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........ 37 3.7 Imp ort or t Inst rument ru ment Tags fr om AVEVA P&ID ............ ................. ........... ........... ........... ............ ............ ........... ........... ........... ........... ............ ........... ....... .. 40 3.8 AVEV A Dw g Vi ewer ........................................................ ........................................................................................................................ ................................................................ 44 Integrat Int egrat io n wi th AVEVA P&ID us usin ing g AIS ...... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... .......... ..... 45 4.1 Overview ......................................................................................................................................... 45 4.2 AVEV A P& ID - Pro jec t Set up ............................................................... ........................................................................................................ ......................................... 46 4.3 Integration Configuration – Configuration – AVEVA AVEVA P&ID PIDREPService ........................................................ 49 4.4 AVEV A In st ru men tat io n - Pro jec t Set up ..................................................................................... ..................................................................................... 55 4.5 Data Comp are and Impo rt Proc ess ........... ................. ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ...... 63 Integrat Int egrat io n wi th AVEVA Diagr ams ...... ............ ........... ........... ........... ........... ............ ............ ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........ .. 69 5.1 Overview - Workflow ...................................................................................................................... 69 5.2 AVEV A In st ru men tat io n - Pro jec t Set up ...................................................................................... ...................................................................................... 71 5.3 Imp ort or t Co nf ig uratio ur atio n f or AVEVA Diagr ams ........... ................ ........... ........... ........... ............ ............ ........... ........... ........... ........... ............ ........... ....... .. 72 5.4 Mappi Map pi ng s: SCOINSTRUMENT (Elemen t Typ e) ......................................................... ............................................................................ ................... 72 5.5 Mappings: SCINSTRUMENT (Element Type) .............................................................................. 73 5.5 Mappings: SCVALV (Element Type)............................................................................................. 75 5.6 Mapp in gs : SCACTUATOR (Elemen t Typ e) ............. .................. ........... ........... ........... ............ ............ ........... ........... ........... ........... ............ ........... ....... .. 76 5.7 Mappings: SCLOOP (Element Type) ............................................................................................ 78 5.8 Import Loops .................................................................................................................................. 80 5.9 Import Instrument Tags ................................................................................................................. 83 Integrat Int egrat io n wi th AVEVA Diagr ams us usin in g AIS ................ ..................... ........... ............ ............ ........... ........... ........... ........... ............ ........... ........... ........... ....... .. 87 6.1 Overview - Workflow ...................................................................................................................... 87 6.2 AVEV A Di agr ams co nf ig ur ati on s ................................................................................................. ................................................................................................. 88 6.3 AVEV A In teg rat io n Ser vi ce c on fi gu rat io ns ................................................................................. ................................................................................. 93 6.4 Comp are/Upd ate Conf ig ur atio ns ........... ................ ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... .......... ..... 95 6.5 Imp ort or t Lo ads from fr om AVEVA Diagr ams 14.1 .......... ................ ........... ........... ........... ........... ........... ........... ........... ........... ............ ............ ........... ........ ... 106 Integrat Int egrat io n wi th AVEVA Sch Schemati emati c Mod el Man ager ............. ................... ........... ........... ........... ........... ........... ........... ........... ........... ............ ......... ... 111 7.1 Overview Workflow ...................................................................................................................... 111 7.2 AVEV A In st ru men tat io n - Pro jec t Set up .................................................................................... .................................................................................... 112 7.3 Import Configuration for AVEVA Schematic Data Model......................................................... 113 7.4 Mappi Map pi ng s: SCOINSTRUMENT (Elemen t Typ e) ......................................................... .......................................................................... ................. 115 7.5 Mappings: SCINSTRUMENT (Element Type) ............................................................................ 116 7.6 Mappings: SCVALV (Element Type)........................................................................................... 117 7.7 Mapp in gs : SCACTUATOR (Elemen t Typ e) ............. .................. ........... ........... ........... ............ ............ ........... ........... ........... ........... ............ ........... ..... 118


5

www.aveva.com


7.8 appings: SCLOOP (Element Type) ............................................................................................. 119 7.9 Import Loops ................................................................................................................................ 120 7.10 Import Instrument Tags ............................................................................................................... 123 8 Integration with AVEV AVEVA A Engineering – Engineering –Tags Tags ......................................................... ..................................................................................... ............................ 127 8.1 Overview - Workflow .................................................................................................................... 127 8.2 AVEV A In st ru men tat io n - Pro jec t Set up .................................................................................... .................................................................................... 128 8.3 Imp ort or t Conf ig urati ur ati on fo r AVEVA Tags ........... ................ ........... ........... ........... ........... ........... ........... ........... ........... ........... ............ ........... ........... .......... .... 129 8.4 Mapp in gs fo r Inst ru ment s Equ ip ment Type ........... ................ ........... ........... ........... ............ ............ ........... ........... ........... ........... ............ ........... ..... 135 8.5 Mapp in gs fo r Lo op s Equi pm ent Typ e............ e................. ........... ........... ........... ........... ........... ........... ........... ........... ........... ............ ........... ........... .......... .... 136 8.6 Import Loops ................................................................................................................................ 137 8.7 Import Instruments ...................................................................................................................... 140 9 Integrat Int egrat io n Wit h AVEVA A VEVA Eng Engin ineerin eerin g us in g AIS ............... ..................... ........... ........... ............ ............ ........... ........... ........... ........... ............ ........... ..... 145 9.2 Over View - Wor kf lo w .............................................................. ................................................................................................................. ................................................... 145 9.3 AVEV A En gi neer in g c on fi gu rat io ns ............................................................... ........................................................................................... ............................ 146 9.4 AVEV A In teg rat io n Ser vi ce c on fi gu rat io ns ............................................................................... ............................................................................... 153 9.5 Comp are/Upd ate Conf ig ur atio ns ........... ................ ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........ ... 155 9.6 Data Compare and Updates ........................................................................................................ 166 10 Import process data in AI ................................................................................................................ 171 10.2 Process Data Import Import – Lex ic on conf co nf ig ur atio n ........... ................ ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........ ... 171 10.3 Comp are/Upd ate Conf ig ur atio ns ........... ................ ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........ ... 178 10.3.1 Import Process Equipment Data to AVEVA Instrumentation Project ..................................... 178 10.3.2 Import Process Line Data to AVEVA Instrumentation Project ............................................... 187 10.3.3 Import Process Line Data to AVEVA Instrumentation Project ............................................... ............................................... 194 10.4 AVEV A En gi neer in g Pr oc ess Data Set up .................................................................................. .................................................................................. 201 10.5 As so ci ati ng Pro ces s Dat a to Ins tr um ent s i n AVEVA Eng in eeri ng ......................................... 207 10.6 Data Compare and Updates ........................................................................................................ 209 10.6.1 Import of Process Equipment Data ........................................................................................ 209 10.6.2 Import of Process Lines Data .......................................................... ................................................................................................. ....................................... 213 10.6.3 Import of Instrument data along with associated pr ocess data .............................................. 217 11 AVEVA AVE VA Cab le Des ig n Dat a Int erf ace .................................................................. .............................................................................................. ............................ 223 11.2 Create a Tr aini ng Proj ect - TRA in E3D 2.1 ............ ................. ........... ........... ........... ............ ............ ........... ........... ........... ........... ............ ........... ..... 223 11.3 Catalo gu e conf co nf ig ur atio n in Parago n 2.1 ........... ................. ........... ........... ............ ............ ........... ........... ........... ........... ............ ........... ........... ........... ..... 226 11.4 Configuring READ/WRITE permissions to databases ............................................................. 233 11.4.1 Exclude the Databases in Administration .............................................................................. 233 11.4.2 Copy the databases to the present project ............................................................................ ............................................................................ 235 11.4.3 Add the databases to ALL MDB ................................................................. ............................................................................................. ............................ 238 11.5 Int egrat io n UDA def in it io n d atabas e ref erenc es. .............. ................... ........... ........... ........... ........... ........... ........... ........... ........... ........... ...... 241 11.6 AVEV A E3D Des ig n Im po rt Con fi gu rat io n ................................................................... ................................................................................. .............. 269 11.7 Import of cables to E3D 2.1 ......................................................................................................... 274 11.8 Import Cable length from AVEVA Instrumentation project ..................................................... 282 12 Publish to AVEVA NET .................................................................................................................... 287 12.2 AVEV A In st ru men tat io n - Pro jec t Set up .................................................................................... .................................................................................... 287 12.3 AVEV A NET Ex po rt Con fi gu rat io n Fi les .................................................................................... .................................................................................... 288 12.4 AVEV A In st ru men tat io n Eng E ng in eer – eer – Publi sh to AVEVA NET Confi gur ation ....... .......... ...... ...... ...... ...... ...... ..... 288 12.5 AVEV A In st ru men tat io n Eng E ng in eer – eer – Publ is h to AVEVA NET ........... ................ ........... ........... ........... ........... ........... ........... ....... .. 293 12.6 AVEV A In st ru men tat io n Wir W ir in g Manag M anag er – er – Publi Publi sh to AVEVA NET (Work (Work ed Exampl e) ..... ....... 294 294 12.7 AVEV A In st ru men tat io n Des ig ner – Publ is h to AVEVA NET ........... ................ ........... ........... ........... ........... ........... ........... ....... .. 295 13 Impor Imp orti ting ng Data fr om Oracl e us in ing g AIS ...... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........ ... 297 13.1 Overview – Overview – Workflow Workflow ................................................................................................................... 297 13.2 Oracl e Databas e conf co nf ig ur ati on s ........... ................ ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ......... .... 297 13.3 AVEV A In teg rat io n Ser vi ce c on fi gu rat io ns ............................................................................... ............................................................................... 303 13.4 Comp are/Upd ate Conf ig ur atio ns ........... ................ ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........... ........ ... 305 13.5 Data Compare and Updates ........................................................................................................ 314


6

www.aveva.com

CHAPTER 1

1

Introduction

This training guide has been developed for the instrumentation project administrator user who will be responsible for the setup and import data from other AVEVA Products. The sections covered within this guide attempts to describe all the relevant activities required to an AVEVA Instrumentation project and then import data from other AVEVA Product projects.

1.1

Aim

This guide aims to be a source of the administrative knowledge necessary to configure AVEVA Instrumentation to integrate with other AVEVA Products.

1.2

Objectives

At the end of this training course, the user will be able to:      

1.3

Configure and Integrate using AVEVA Integration Service Integrate with AVEVA P&ID Integrate with AVEVA Diagrams Integrate with AVEVA Engineering – Schematic Model and Tags Integrate with AVEVA PDMS or Outfitting Cable Design Integrate with AVEVA Net

Prerequisites

The following are some basic prerequisites for Trainees attending the Training Course in AVEVA Instrumentation 12.1: 







Familiar with Instrumentation and Process engineering data. Familiar with Instrumentation from a design or operations perspective, which includes various types of Instruments, Cabling and basic knowledge of Process Control System (PLC/DCS). Well versed with using Microsoft® Excel. Refer the AVEVA Instrumentation Installation User Guide for the system requirements both hardware and software.

AVEVA Instrumentation has been installed on the Trainee’s c omputers that they will be using for the duration of this training course.

Microsoft Office 2007, 2010, 2013 and 365 (Excel) has been installed on the Trainee’s computers that they will be using for the duration of this training course. Enterprise, Standard or Express versions of Microsoft SQL Server 2008 R2 (SP3) or 2012 (SP3) or 2014 (SP1) must be installed on each Trainee’s computer, or each Trainee must have access to an instance of Microsoft SQL Server installed elsewhere on the network the Trainees might be connected to. The name of the instance of Microsoft SQL Server that the Trainee has access to must be known to each Trainee. AutoCAD 2014, 2015 or 2016 is a prerequisite for this training course.


7

www.aveva.com


 If training is to be conducted in a stand-alone environment, then all four of the AVEVA Instrumentation modules are to be installed on each machine. This will include Security Manager. Each trainee is to have read and write access to the instance of the SQL server used for training, and have permissions set to be able to create databases on the instance of the SQL server used for training.

 If training is to be conducted in an administrative environment, then all four of the AVEVA Instrumentation Modules are to be installed on the AVEVA Instrumentation project administrators machine. This will include Security Manager. The AVEVA Instrumentation project administrator is to have read and write access to the instance of the SQL server used for training, and have permissions set to be able to create databases on the instance of the SQL server used for training.

 For assistance with SQL Server installation please refer to the AVEVA Instrumentation Installation guide.

1.4

Cours e Struc tur e

Training will consist of oral and visual presentations, demonstrations and set exercises. Each workstation will have a training project and supporting material. These will be used by the trainees to practice their methods, and complete the set exercises.

1.5

Using this guide

Certain text styles are used to indicate special situations throughout this document, here is a summary; Menu pull downs and button press actions are indicated by bold dark turquois e text. Information the trainee has to key-in will be in bold , red text. Annotation for trainees benefit:

 Additional information  Refer to other documentation

System prompts will be bold italic and in inverted commas i.e. 'Choose function' Example files or inputs will be in the courier new font.


8

www.aveva.com

CHAPTER 2

2

AVEVA Integr ation Servi ce

AVEVA Integration Service provides easy, quick and effective data transfers between different data source s (AVEVA and non-AVEVA product data) installed in different machines on the network. It provides a common platform for Plant, Marine and Engineering products for accessing and using data from other products so that the data management across Products can be done effectively.

2.1

Microsof t softw are Prerequisit es to start AVEVA Integration Service

Before configuring AVEVA Integration Service 1.0 there are some prerequisites that should be set up to run the Integration services.   

Microsoft Data Access Components (MDAC) 2.6 or later Microsoft .NET Framework 4 Microsoft Message Queue (MSMQ) Server

 For assistance with AVEVA Integration Services installation please refer to the AVEVA Integration Service Installation Guide.

2.2

Turni ng on Micr osof t Message Queue (MSMQ) Featur e

To Turn on the MSMQ Server Core Windows Features, select Control Panel > Programs > Programs and Features

Select the Turn Windows features on or off located on the side menu

Tick all the checkboxes under the Microsof t Message Queue Server and click OK


9

www.aveva.com


2.2.1

Start Message Queuing

The Message queuing service provides messaging infrastructure and development tool for creating distributed messaging application for Windows based networks and programs. If this service is disabled, any services that explicitly depend on it will fail to start. To enable the Message Queue Service, select Control Panel > All Control Panel Items > Administrative Tools > Services Click Start to run the services

2.2.2

Start Message Queuing Trigg ers

The Message Queuing Triggers provides rule-based monitoring of messages arriving in a message queue and, when the conditions of a rule are satisfied, invokes a COM component or a stand-alone executable program to process the message. To enable the Message Queue Trigger Service, select Control Panel > All Control Panel Items > Ad mi ni st rat iv e Too ls > Serv ic es Select the Click Start to run the services

The Message Queuing Triggers then displays Started in the Status Column


10

www.aveva.com


2.2.3

Allow Permiss ion to User

To enable the Message Queue Trigger Service, select Control Panel > All Control Panel Items > Ad mi ni st rat iv e Too ls > Com pu ter Managem ent

In the Computer Management (Local) explorer menu, select Services and Applic ation > Message Queuing > Private Queues

Right click integration_tasks and select Properties.

This opens the integration_tasks Properties window. Select the Security tab and click the Advan ced button


11

www.aveva.com


Select the Owner tab of the Advanced Security Settings window. Select Administrators in the Change owner to window and click Ap pl y .

Click the Permissions tab and click the Add button

In object name space provided enter a valid user name to configure the service. Click OK and the Permission Entry Window opens


12

www.aveva.com


Tick the Al lo w checkbox for Full Control to give the user all the permission right.

Click OK to accept changes

Click OK to close all the windows.


13

www.aveva.com


2.3

Start AVEVA Integrati on Service

Before using the AVEVA Integration Service, it must be configured as described below:    

AVEVA Integration Service Components Installed Location Starting the Services by giving the Appropriate Login Credentials Adding Data to Services for different Data Source Types Data Verification

 AVEVA Diagrams 14.1 and higher versions are compatible only with AVEVA Integration services To get access to AVEVA Integration Services, the user account that the service can use to log on needs to be specified. To enable the AVEVA Integration Service, select Control Panel > All Control Panel Items > Ad mi ni st rat iv e Too ls > Serv ic es Right click the AVEVA Integration Service and click Properties

This opens the the AVEVA Integration Properties window. Select the Log On Tab

To specify a Network service account, click This account Click Browse to specify a user


14

www.aveva.com


This open the Select User dialog box.

Enter a valid user name in the object name field provided using its appropriate object type and directory location by selecting Object Types and Locations respectively.

Click OK to close the dialogue box

Enter the Password for the user account in Password and in Confirm password

Click OK to close the form

In the Services window select the AVEVA In teg rat io n Serv ic e and click Start to run the services

The AVEVA Int egr ati on Serv ic e then displays Started in the Status column and the user account name in the Log On As column. Copyright © 2014. AVEVA Solutions Limited and its subsidiaries. All rights reserved.

15

www.aveva.com


2.4

Adding Data to Services for AVEVA Instrum entation

AVEVA Integration Services configurations involves adding data to the Service from different data source types and this is done via t he Integration Settings Editor : To start, select Start > All Progr ams > AVEVA > Integration > Integration Settings Edito r

 The Configure Integration Service short cut would appear in All Programs only if the component Integration Client is installed in the machine. Alternatively user can also run the InterOpIntegrationConfig.exe from the installed location …\Program Files\AVEVA\Shared\AVEVA Integration Service by double-clicking on it.

This opens the Integration Settings Editor window.

In the Av ail abl e Data Sour ces section the Data source and project can be selected to receive the data associated with it. Copyright © 2014. AVEVA Solutions Limited and its subsidiaries. All rights reserved.

16

www.aveva.com


From the drop down list for the Data Source Name select AVEVA Diag ram s

Click Add Con fi gu rat io n Plant login form.

to display

AVEV A

Select the Initialize button to select the required Project.

Enter the following details:

Project : Username : Password : MDB :

SAMPLE SYSTEM XXXXXX; SAMPLE

Then select the Login button.

Click the Save to save the configuration and Exit to close the form


17

www.aveva.com


2.5

Compare/Update Config urati ons

To use the Compare/Update facility in AVEVA Instrumentation relevant configurations must be set-up, e.g. attribute mappings between the AVEVA Instrumentation project and the data source, data filters etc. and this is done via the Integration Settings Editor : To start, select Start > All Progr ams > AVEVA > Integration > Configure Integration Service

This opens the Configuration Integration Service Location window.

Click the Test Service to confirm the Integration Service location is correct The Connection most match service address and service endpoint and service port connection Click Test Service to confirm the AVEVA Integration service is connected. The message will appear on the bottom left of the window


18

www.aveva.com


These configurations are created and edited using the Import Configuration option: Start AVEVA Instrumentation Engineer, select Project > Setup > AVEVA Integration Services > Import Configuration

The Confirmation window for the connection will appear. Click Yes to confirm


19

www.aveva.com


This opens the Service Import Configuration Settings window.

Select the source AVEV A Diagrams from the Select Sourc e list.

 If no services have been configured, the list will be empty.

After the source is selected, the user must then login to it. Select the Login button

The Select an AVEVA Diagrams Project dialog is then displayed for the selected data source.

Enter Password XXXXXX and click the Connect button.

Once the login is completed, the Select Actio n section of the form will be enabled to create, edit and delete configurations.


20

www.aveva.com


(Step 1 of 5): Choose mode of o peration

To create a new configuration, choose the desired mode of operation, for example. Select the Create new configuration option;

Click Next button to proceed to the next step.

 This

worked example illustrates how to create a new Service Import configuration for Instruments.

(Step 2 of 5): Source Object Type

Source: The source data is the data that will be the basis of comparison. In this case AVEVA Diagrams is selected Configuration Name : This will be the name which the configuration will be identified as. Enter the text Instruments in the text field. Group : This will be the group which the configuration will be created in. Enter the text AD001 in the text field. Object Type Mapping : Select the element type SCINSTRUMENT that the configuration is to utilise from the Object Type pull down list.


21

www.aveva.com


Name Attribu te : Select the NAME attribute from the available pull- down list. The selected element type will be utilised to find possible matches between the source AVEVA Diagrams items and target AVEVA Instrumentation items. Unique Attribute : Select the Unique Attribute DBREF from the available pull-down list. The selected attribute will serve as the unique key attribute of source items.

Click on the Next button to proceed to the next step.

(Step 3 of 5): Destination Element Type

This step provides the option to select the target data in the selected AVEVA Instrumentation database. Target data is compared against source data.

Object Type: From the Element Type list select the type of object in the Destination database e.g. Instrument . Name Attrib ute: Select the TagNo attribute from the available pull-down list. The selected object type will be utilised to find attribute matches in AVEVA Instrumentation items. Unique Attribute: Select the Unique Attribute InstKEY from the available pull-down list. The selected attribute will serve as the unique key attribute of the destination items Al lo w Ins ert io n : Check the checkbox, to allow for the creation of new items in the target database, if source items do not find a matching target item after comparison.



22

www.aveva.com


(Step 4 of 5): Define Source Filter(s)

Ad d Fi lt er : Retain the default blank entries. This allows for the definition of criteria which limit the population of source data that will be used in the comparison. Delete Filter : This button deletes any set filter.

Click on the Next button proceed to the next step.

to

(Step 5 of 5): Define Attri bute Mappings(s)

Attributes of the source element types can now be mapped to those of the corresponding target element type. Attribute selection and mapping indicates the attribute values to be obtained and/or compared against. Basic mappings for the import facility between AVEVA Instrumentation and AVEVA Diagrams can be setup as illustrated below. Click on the Add m app in g button to display a new mapping row. Mapped attributes can be selected and then deleted with the ‘Delete Mapping’ button. Select a source AVEVA Diagrams attribute from the pull-down list, then select a corresponding AVEVA Instrumentation attribute from its available list to map. Using the table below as a guide, map the following fields: AVEV A Di agr ams (Sour ce)

AVEV A In st ru men tat io n (Destin ati on )

NAME

TagNo

InstrumentationArea

Ar eaNo

InstrumentationTagFormat

TagFormatName

InstrumentClassName

ClassName

FUNC

ISAFunc

InstrumentationParentArea

Ar eaPath

DESC

Description

NUMB

LNumber

In the AVEVA Diagrams Column: Some User Defined Attributes are created and contain valid values to the mapped destination.


23

www.aveva.com


In the AVEVA Instrumentation column; AreaNo, TagNo , Clas sNam e,Tag Fo rm atNam e, Ar eaPath and Tag codes (In this example: ISAFunc and LNumber) are the mandatory fields and must be mapped by the user.

Click the Finish button, and then select the OK button from Message form

2.6

Compare/Update Colour Config urati on

To view the current meanings and change them if required, select Project > Setup > AVEVA Integration Services > Compare/Update Colour Configuratio n


24

www.aveva.com


1.6

Impor t Inst rum ent Tags fro m AVEVA Diagrams 14.1

Select the Home tab, and click Select > Instr uments (under Lists). The Instrument grid is then displayed. Select the Manage tab and click the dropdown list for Products found in the Service Integration Section. Click the AVEVA Di agr ams button from the Integration pane.

Click Connect to initialise the Service Integration connection.

This opens the Select an AVEVA Diagrams Proj ect dialogue

Enter Password XXXXXX and click the Connect button for the project.

From Groups in the Service Integration Section select AD001 from the dropdown list.

Select Import DataThe Integration operation will then take place. The values of the mapped attributes of a source (AVEVA Diagrams) item will be compared with the attributes values of any existing and matched corresponding destination (AVEVA Instrumentation) item. Copyright © 2014. AVEVA Solutions Limited and its subsidiaries. All rights reserved.

25

www.aveva.com


The list of Instrument Tags available are displayed on the Compare/Update window.

By clicking the At tr ib ut e Detai ls tab the mapped attributes for the items could be seen.

 The background colours of the rows in the Compare/Update grids indicate the status of the data in the rows according to chapter 1.6.

Check the check box against an individual item to import the data or click the Ac cept All to import all the items. Click the Update Database button on the menu


26

www.aveva.com


An Update database window is displayed, which indicates the number of Items analysed and required action in AVEVA Instrumentation.

Click the UpdateDB button

Click the Close and menu to exit the Compare/Update form.

button on the

The Instruments grid is now updated with the Instrument Tags, from AVEVA Di agr ams .


27

www.aveva.com


This page is intentionally left blank.


28

www.aveva.com

CHAPTER 3

3

Integration with AVEVA P&ID

3.1

Overview - Workf low

When integrating the two applications the user can import project data (e.g. Loops and Instrument Tags) from AVEVA P&ID into AVEVA In st ru men tat io n by following some basic steps:

Setup: AVEVA P&ID Im ort

Select the Project file (PID.prj)

Select Element Type (Loops)

Select Element Type

Set the Mapping

Set the Mapping

Import Process Loo s

Import Instrument Tags

 The above steps are performed in the Instrument Engineer module within the AVEVA Instrumentation suite.


29

www.aveva.com


3.1

AVEVA P&ID - Project Setup

Prior to importing the Loops and Instrument tags into AVEVA Instrumentation the user must select the appropriate settings from the AI Int egr ati on option on the Project tree view in the Project Administrator module of AVEVA P&ID. Click (expand) the AI In teg rat io n option and select AI Set ti ng s .

Under the heading AI Int egr ati on Sett in gs , select Prefix from the Derive Instrument AREA From pull down list. Similarly, select Prefix from the Derive Loop AREA from pull down list under the AI Lo op Ar ea Fiel d Mappings heading.

AVEVA PI&D has new UDAs (CLASSNAME, TAGFORMAT and AREAPATH) required in AVEVA Instrumentation to create a Loop or Instrument. These mandatory attribute in AVEVA P&ID must have valid AVEVA Instrumentation attribute values such as: Instruments AVEV A P& ID Attr ib ut es

At tr ib ut e Valu e

CLASSNAME

INS

TAGFORMAT

ISA with Area (delimiters)

AREA PATH

01

 The attributes value is based on the Instrumentation demo project default values.


30

www.aveva.com


Instruments t ab in AVEVA IPE project.

Instrument Lo op AVEV A P& ID Attr ib ut es

At tr ib ut e Valu e

CLASSNAME

ILP

TAGFORMAT

ISA with Area (delimiters)

AREA PATH

01

Instrument Loop tab in AVEVA IPE Project:

Once the above settings are configured by the user can then proceed to AVEVA Instrumentation for Instrument Tags and Loops import from AVEVA P&ID based on their Ar ea Num ber , Class Name, Parent Ar ea and Tag Format .


31

www.aveva.com


3.2

AVEVA Inst rum entation - Project Setup

Create a new project using the information below: Demo Project check box: Share with Electrical check box: Project Name or No text box: Project Description text box: Plant Name text box: Plant Location text box: Client Name text box: Client Project No text box: Project Folder: Design Database text box:

Checked Checked Integ-P&ID Integrate with AVEVA P&ID AVEV A In st ru men tat io n Dem o Local TPS TM6107 C:\AVEVA\AVEVA_InstrumentationTraining INTEG_AI_P&ID

Click the Save button to create the new project.


32

www.aveva.com


3.3

Impor t Config urati on for AVEVA P&ID

Start AVEVA Instrumentation Engineer , select Project > Setup > AVEVA P&ID Import Confi guration .

The AVEVA P& ID Data Import Configuration window is displayed.


33

www.aveva.com


Click the browse button next to the AVEVA P&ID Pro jec t fi le: field select the desired ‘ PID.prj’ file from the AVEVA P&ID project folder. In this example IPE ‘ PID.prj’ file.

The Element Types options (Instrument & Loop) are then accessible once the user has selected the desired project file.


34

www.aveva.com


3.4

Mappings for Loop: Element Type

Select the option Loop from the pull down list under Element Types . Using the table below as a guide, map the AVEVA P& ID fields to the AVEV A In st ru men tat io n fields using the pull down list: AVEV A P& ID Fiel d

AVEV A In st ru men tat io n Fiel d

TAGFORMAT

TagFormatName

Type

LoopType

Suffix

LoopSuffix

Loop Number

LoopNo

Number

LNo

CLASSNAME

ClassName

AREAPATH

Ar eaPath

Prefix

Ar eaNo

To facilitate the mapping process some default mappings are automatically set for both Instrument and Loop element type.

The AVEVA Instrum entation Field LoopNo , ClassName, TagFormatName, Ar eaNo and AreaPath , and TagCodes are mandatory fields and must be mapped by the user.


35

www.aveva.com


3.5

Mappings for Instrument: Element Type

Select the option Instrument from the pull down list under Element Types . Using the table below as a guide, map the AVEVA P&ID fields to the AVEVA In st ru men tat io n fields using the pull down list: AVEV A P& ID Fiel d

AVEVA In st ru men tat io n Fiel d

Instrument Label

TagNo

TAGFORMAT

TagFormatName

Suffix Label

Suffix

Inst Process Owner

PlantConnection

Drawing No

PIDNo

Instrument Loop Number

LoopKey

Loop Label

LNumber

Location

ISALocation

Type Label

ISAFunc

Closure

FailPosition

Instrument Description

Description

CLASSNAME

ClassName

AREAPATH

Ar eaPath

Prefix Label

Ar eaNo

The AVEVA Instrumentation Fields Ar eaNo , Ar eaPath , Clas sNam e, TagFor mat Name, TagNo , and TagCodes are mandatory fields and must be mapped by the user. Once the fields are mapped, click the Save button.

 The above mappings are typical and can vary from user to user. Copyright © 2014. AVEVA Solutions Limited and its subsidiaries. All rights reserved.

36

www.aveva.com


3.6

Impor t Loo ps fro m AVEVA P&ID

Select the Home tab, and click Select > Loop s (under Lists). Copyright © 2014. AVEVA Solutions Limited and its subsidiaries. All rights reserved.

37

www.aveva.com


Select the Manage tab and click the AVEVA P& ID Imp or t button from the Integration pane. Click the Yes button on the alert form to acknowledge the message and proceed with the import.

An Import from AVEVA P&ID window is displayed which indicates the number of Process Loops analysed and will be imported into AVEVA Instrumentation. Click the Batch Process All button to analyse the Instrument tags in bulk.

The list of Process Loops available to import are displayed on the Import Differences window. Check the Ac cep t All check box and click the Save button on the menu.


38

www.aveva.com


A Progress window is displayed while AVEVA Instrumentation performs the import. An Import Log is displayed, listing the number of valid Loops successfully imported. Click the Close button on the menu.

The Loops grid is populated with the Process Loops, imported from AVEVA P&ID .


39

www.aveva.com


3.7

Impor t Instr ument Tags fr om AVEVA P&ID

Select the Home tab, and click Select > Instr uments (under Lists).

The Instrument grid is then displayed.


40

www.aveva.com


Select the Manage tab and click the AVEVA P& ID Imp or t button from the Integration pane.

An Import from AVEVA P&ID window is displayed, which indicates the number of Instrument Tags analysed and will be imported into AVEVA Instrumentation.

Click the Batch Process All button to analyse the Instrument tags in bulk or click the Process one by one button to analyse each Instrument tag.


41

www.aveva.com


The list of Instrument Tags available to import are displayed on the Import Differences window. Check the Ac cep t All check box and click the Save button on the menu.

The Import Lo g displayed, listing the number of valid Instrument tags successfully imported. The updated values, newly created items and any error message can also be observed on the appropriate list view.


42

www.aveva.com


In this example tagged item ‘02 -AI-98’ failed to update because the import attribute value ‘20’ is not a valid area value in AVEVA Instrument.

Click the Close button on the menu to exit the Import Log form.

The Instruments grid is now populated with the Instrument Tags, imported from AVEV A P& ID.


43

www.aveva.com


3.8

AVEVA Dwg Viewer

Once the Instrument Tags have been imported into AVEVA Instrumentation, the user can then view the actual Instrument tag on the P&ID using the AVEV A Dw g Vi ewer application. On the Instruments grid, Select the Instrument tag FC-004 and click the the column P&ID No for the selected record.

command

button

under

The Instrument tag FC-004 is viewed on the AVEVA P&ID drawing 905676.

 The user is recommended to use the Zoom options from the menu. Click

the button on the top right to exit the AVEVA Dw g Vi ewer application.


44

www.aveva.com

CHAPTER 4

4

4.1

Integration wit h AVEVA P&ID using AIS

Overview

Using AVEVA Integrations services the user can import Instrument and Loops data from AVEVA Instrumentation and AVEVA P&ID to and fro.The Instrument and Instrument loop data created at the time of drawing creation can then be imported to AVEVA P&ID using this services.

Configure P&ID Report Service

Configure Integration Services to add AVEVA P&ID

Configure AVEVA Instrumentation

Select Element Type (Loops)

Select Element Type

Set the Mapping

Set the Mapping

Import Process Loops

Import Instrument Tags


45

www.aveva.com


4.2

AVEVA P&ID - Project Setup

In this example Instrument and Loop data present in TRA project is imported to the AVEVA Instrumentation project.TRA project is an out of the box project when AVEVA P&ID is installed in a system.The user needs to upgrade the project after installing the latest fix.The project can be upgraded using the Project Wizard module in AVEVA P&ID. The user needs to create certain datasets for importing the P&ID data to AVEVA Instrumentation. The user can create the datasets in the AVEVA P&ID project administration programme. Browse to Start >> All Programs >> AVEVA >> Engineer >> P&ID12.1SP2 >> Projects >> TRA >> Project Administrator

In the Password field Enter Admi n Click Login

Navigate to User Driven At tribu tes >> DataSet Create a new Dataset ‘Instrumentation by clicking Create New Dataset button with following attributes Ar ea,Ar eaPath,Cl ass Name,TagFo rm at

Apply these datasets for item_Group = Instrument

When the above symbols are placed in the AVEVA P&ID drawings,in the properties window these attributes will be visible where the user can insert the values.


46

www.aveva.com


In project administrator change the Instrument loop tag so that it matches with the AVEVA Instrumentation project. The display label format should be as highlighted

Browse to Start >> All Programs >> AVEVA >> Engineer >> P&ID12.1SP2 >> Projects >> TRA >> Au to CAD 2014

 AutoCAD 2014 is a shortcut to open the AVEVA P&ID application and this will have the corresponding version number which is used to create the project

Open drawing A0-01-2012-0001.dwg.

The 3 instruments FAL-115,FAH-115 and FE-115 are identified to be imported which are in the same Instrument Loop – 01-F-115 Open properties window of FAL-115. For demo purpose input of the dataset values are shown only for one Instrument but it should be done for all the three instruments.


47

www.aveva.com


Open AVEVA P&ID 12 Instrument properties by choosing Properties in the right click menu. Insert the corresponding values Ar ea – 01 Ar eaPath ClassName – INS TagFormat - ISA with Area (delimiters)

Click OK

The same values should be entered for other 2 instruments FAH-115 and FE-115

Save the drawing and execute Synchronise/Consolidate.


48

www.aveva.com


4.3

Integration Configuration – AVEVA P&ID PIDREPServic e

The Integration of AVEVA P&ID with other proucts are enabled using WCF service and for successful integration this service should be installed on the system where AVEVA P&ID is installed. The service is named AVEVA PID PIDREPServi ce which will be installed on the system when the user installs AVEVA MiddleTier Service 1.0.

 The installer for AVEVA Middle tier is bundled with the AVEVA P&ID Fix installer.It is recommended to install the Middle Tier version which is bundled along with the latest fix.

As shown below the AVEVA Middle Tier installer comes along with AVEVA P&ID Fix installer and this needs to be installed. The installer will be available in the PID121SP2_11Fix-64-Bit\Middle Tier installation ONLY fo lder

When the user installs the AVEVA_Schematic_MiddleTier 1.0.msi, a new service PIDREPService will be added in the services list.

AVEVA PID

The AVEVA PID PIDREPService by default is configured to run using Local System account,but this needs to be changed to current Users login.


49

www.aveva.com


The user need to change the log on details by doing a right click on the service and choose the log on tab

From the Log On tab,the Log on as: change the radio button local System accoun t to This account . Click on Brow se and select network and choos e the current user’s name and enter the password and confirm password fields. Click OK

After changing the log on as fields, the system will display a message that the new logon name will take effect after restart.

Click OK


50

www.aveva.com


The next step is to add the P&ID project in this service so that the AVEVA Integration Service can identify the project and allow import of records from that project When the Middle Tier application is installed ,the application creates a folder named ‘Shared’ which holds all the files related to AVEVA PID PIDREPService.By default this folder will be created at the location C:\Program Files (x86)\AVEVA\Shared\Aveva P&ID Reports Service

Execute ServiceEditor.exe The user is presented with PIDReportDataWinService Settings .Click on Add button to add TRA P&ID project

Browse to the project folder where PIPD.PRJ file is located.


51

www.aveva.com


Select the pid.prj file and click Open.

The TRA project will be added as new record in the PIDReportDataWinService Settings window.Click Save All.

Click on Exit button to close the window. The AVEVA P&ID projects added in the above service can now be visible in the AVEVA Integration Settings editor. Navigate to Start > All Programs > AVEVA > Integration > Integration Setting s Editor The Integration Settings Editor window will be displayed where the user can configure AVEVA P&ID as a data source and add the required projects.


52

www.aveva.com


In Av ail abl e Data Sou rc es section, Select AVEVA P& ID from the list of values as Data Source Name. The Data Source Type will be automatically point to AVEVA P& ID.

After selecting the Data Source Name as AVEVA P&ID, Click on Add Co nf ig ur ati on . The user will be presented with AVEVA P&ID Data Sou rc e Detai ls screen.The Data-Source Connection field will be populated with the details of the AVEVAPID PIDREPSer vi ce running in the system.

Click on Test button .The application gives the stat us of service below the Add r ow s button


53

www.aveva.com


Click Fill button The projects added in the AVEV A PID PIDREPServ ic e editor will be listed in Select rows to add: section and the user needs to select the project by clicking on the check box as shown below.

Click Add Ro ws .

The TRA project will be added in the Integration Setting Editor as shown below.

Click Save and the application gives a confirmation that the configuration is saved.

Click OK and close the Integration Settings Editor window by clicking Exit.


54

www.aveva.com


4.4

AVEVA Inst rum entatio n - Project Setup

For this exercise, integration configuration within the AVEVA Electrical product could begin with the creation of a new AVEVA Electrical project. This should be done using the standard project creation interface, and entering the details as shown: Start AVEVA Electrical Engineer application by browsing to Start >> All programs >> AVEVA >> Engineer >> AVEVA Electrical 12.1.4 >> Electrical Engineer 12.1.SP4

In the Select an AVEVA Electrical Project screen click on the New button Copy Demo Project check box: Share with Electrical check box: Project Name or No text box: Project Description text box: Plant Name text box: Plant Location text box: Client Name text box: Client Project No text box: Project Folder: Design Database text box:

Checked Checked Integ-PID-AIS Integrate with AVEVA P&ID using AIS AVEV A In st ru men tat io n Dem o Local TPS TM6109 C:\AVEVA_Instrumentation Training\Projects\Integ-PID-AIS INTEG_PID_AIS

Click Save The AVEVA Instrumentation application starts the project creation and shows the progress window..


55

www.aveva.com


Once the project is created, The AVEVA Elec tr ic al Pro jec ts window confirms that New project is created successfully

Open the newly created AVEVA Instrumentation project and browse to Project >> Setup >> AVEVA Integration Service >> Import Config uration .


56

www.aveva.com


The Confirmation window is displayed which shows the deta ils of the AVEVA Integration Services.

 By default Confirmation window shows the AIS running in local host but the user can change the service location to remote machine by clicking ‘ No ‘.

Click Yes

The below Service Import Configuration Settings screen is displayed In Actions Section, Select Service and in Select Source list box choose AVEVA P&ID.

Click Login


57

www.aveva.com


Click Connect’ button. On successful login, the Service Import Configuration Settings screen will be enabled and the user can Create or Edit or Delete configurations from this screen

 The project TRA is set as Windows Authentication,so the password field will be disabled. The first step is to create a new import configuration.Select the Create new configu ration from the select Ac ti on section

The Service Import settings window is visible where the user can configure the settings.


58

www.aveva.com


Click the Next button to advance to Step 2 of 5 :Source Element Type

In the step 2 enter these details Source : AVEVA P&ID (this is a disabled field and source is selected as per the project and Data Source ) Configuration Name : PIDAI001 Group : ‘PIDAI001 Object Type Mapping : INSTRUMENT Name Attribu te : Instrument Label Unique Attribute : ID

 The Fields provided in Name At tr ib ut e and Unique attribute are used to match the records present in the source and destination applications

Click on Next button to advance to Step 3 of 5: Destination Element Type In this example, the Instrument details from AVEVA P&ID are imported to AVEVA Instrumentation application.So the user need to select Instrument in the object type

This screen lists the corresponding matching fields in the destination application (for example AVEVA Instrumentation). The Name Attribute and Unique Attribute fields will be automatically populated with TagNo and InstKEY respectively.


59

www.aveva.com


In the Insert Option Section, check the Al lo w Ins ert io n checkbox so that new records can be imported to destination application


60

www.aveva.com


Click on Next button to go to Step 4 of 5 : Define Source Filter(s) screen . The user can filter the records which needs to be imported from Source application to Destination application by clicking Add Fi lt er button.Filters can be applied so that only instruments of particular type are imported to destination application.

 In this example no filters are applied.

Click on Next button to advance to Step 5 of 5: Define Att ribut e mappings In this last screen the user needs to map the fields in Source and Destination application so that the Compare Update functionality can compare the fields in both applications and import depending upon the current values.

AVEVA P&ID (Source) INSTRUMENTATION_Area

AVEVA Instrumentation (Destination) AreaNo

INSTRUMENTATION_AREA PATH

Area Path

INSTRUMENTATION_CLASSNAME

Class Name

INSTRUMENTATION_TAGFORMAT

TagFormatName

Type Label

ISAFunction

Loop Label

Lnumber

Prefix Label

Prefix

Suffix Label

Suffix

Instrument Label

TagNo

Instrument Loop No

LoopKEY

Instrument Description

Description


61

www.aveva.com


The mapping can be added or deleted using the Add Mapp in g and Delete mappin g buttons on the Service Import Configurations Settings The screen will displayed as shown below once all the above listed fields are mapped.

Click on Finish to create the configuration The applications gives a confirmation message that the configuration is created successfully.


62

www.aveva.com


4.5

Data Compare and Impor t Process

Open the Aveva Electrical application and open the Loads Tab by browsing to Home > Select > Loops .

Click on New button to create a new Instrument Loop.

 Instrument loops can also be imported by creating a configuration similar to configuration created for instruments.

In this example a new loop is created from AVEVA Instrumentation and all the instruments are imported to that loop. In the Add New lo op screen,Loop Tag Dialog pop up screen is automatically displayed. Insert the values Class – ILP Tag Format – ISA with Area (Delimiters) Loop Type - Flow Select from the list Ar ea – 01 Select from List Function – F Number – 115 Suffix –

Click OK. The new loop 01-F-115 will be listed in the list of records.


63

www.aveva.com


Browse to Home > Select > Instrum ents

Select the Manage tab, as the compare Update menus are featured in this tab. In the Service Integration section , select AVEVA P& ID in the Products list. Click ‘Connect’. The Select an AVEVA P&ID project window is displayed which lists all the AVEVA P&ID projects configured Aveva Integration Services service editor. Click Connect


64

www.aveva.com


The Refresh Groups button will be enabled after successful connection. Select PIDAI001 from the Groups list.

Click Import Data

The application gives a message that same project database will not be suitable for importing Aveva Engineering data or Aveva Diagrams data once Aveva P&ID data is imported.

Click on Yes button.in the AVEV A In st ru men tat io n Eng in eer window In Compare/Update window the application displays the data in P&ID database which the user choose one record (or bulk

Select the 3 Instruments 01-FAH-115, 01-FAL-115, 01-FE-115


65

www.aveva.com


Click on the Update Database button on the Compare/Update window


66

www.aveva.com


In the Update database screen the summary details like Unmatched objects to be inserted , Matched and Linked items to be updated are displayed

Click UpdateDB .

The Database update Results section displays the result of the import The user need to check if there is any errors mentioned and check for the values again


67

www.aveva.com


In Compare/Update below window, the following records are imported to successfully and status of the records are changed to linked with differences. The explorer window in Aveva Instrumentation displays the records inserted from Aveva P&ID Database.


68

www.aveva.com

CHAPTER 5

5 5.1

Integration wit h AVEVA Diagrams Overview - Workf low

When integrating the two applications the user can import project data (e.g. Instruments or Loops') from AVEV A Di agr ams into AVEVA In st ru men tat io n by following some basic steps:

Setup: AVEVA Diagrams Import

Select & Login: AVEVA Diagrams

Select Element Type: e.g. SCOINSTRUMENT, SCVALV, SCINSTRUMENT , SCACTUATOR , SCLOOP

Set the Mapping

Loops grid: Im ort Loo s

Instruments grid: Im ort Instrument

 AVEVA Diagrams 12.1 and lower versions are not compatible with AVEVA Integration services


69

www.aveva.com


AVEVA Diagrams - Project Setup AVEVA Diagrams sample projects will have the necessary user defined attributes in the dictionary database. If there is no user defined attribute available for the desired element(s), these could be added using t he Lexicon application. Please login to the Lexicon module using administrative privileges.

 The trainer will provide a macro file to be able to create the required UDA elements.

The hierarchy in Lexicon application should look as shown below.

The user defined attributed could be seen using the Shape Data Window (after a refresh has taken place) in AVEVA Diagrams:


70

www.aveva.com


5.2


Create a new project using the information below: Copy Demo Project check box:

Checked

Share with Electrical check box:

Checked

Project Name or No text box:

Integ-Diagrams

Project Description text box:

Integrate with AVEVA Diagrams

Plant Name text box:

AVEV A In st ru men tat io n Dem o

Plant Location text box:

Local

Client Name text box:

TPS

Client Project No text box:

TM6107

Project Folder:

C:\AVEVA_Instrumentation Training\Projects\Integ-Diagrams

Design Database text box:

INTEG_AI_Diagrams



71

www.aveva.com


5.3

Import Configuration for AVEVA Diagrams

Start AVEVA Instrumentation Engineer, and select Project > Setup > AVEVA Diagrams Import Configuration and login to the desired project.

Fill the details as shown in the image above entering XXXXXX (all upper case) for the Password and then click the OK button.

5.4

Mappi ngs: SCOINSTRUMENT (Element Type)

Using the table below as a guide, map the AVEVA Diagram fields to the AVEV A Ins tr um ent ati on fields using the pull down list: AVEV A Di agr ams Fiel d


NAME

TagNo(TagNo)

FUNC

ISAFunc(Function)

NUMB

LNumber(Number)

:InstrumentationArea

Ar eaNo(Area)

:InstrumentationParentArea

Ar eaPath

:InstrumentClassName

ClassName

:InstrumentationTagFormat

TagFormatName

DESC

Description()

:InstrumentationPIDNo

PIDNo(P&ID No)

PREFIX

Prefix(Prefix)

SUFFIX

Suffix(Suffix)

LOCA

ISALocation(Loc)

SCLORE

LoopKEY()


72

www.aveva.com



5.5

Mapping s: SCINSTRUMENT (Element Type)

Select the option SCINSTRUMENT from the pull down list under Element Types.


73

www.aveva.com


Using the table below as a guide, map the AVEVA Diag ram s fields to the AVEVA Ins tr um ent ati on fields using the pull down list: AVEV A Di agr ams Fiel d


NAME

TagNo(TagNo)

FUNC

ISAFunc(Function)

NUMB

LNumber(Number)


Ar eaNo(Area)


Ar eaPath


ClassName


TagFormatName

DESC

Description()


PIDNo(P&ID No)

PREFIX

Prefix(Prefix)

SUFFIX

Suffix(Suffix)

LOCA

ISALocation(Loc)

SCLORE

LoopKEY()

The AVEVA Instrumentation Fields Ar eaNo , Ar eaPath , Clas sNam e, TagFor mat Name, TagNo , and TagCodes are mandatory fields and must be mapped by the user.


74

www.aveva.com


5.5

Mapping s: SCVALV (Element Type)

Select the option SCVALV from the pull down list under Element Types.



NAME

TagNo(TagNo)

FUNC

ISAFunc(Function)

NUMB

LNumber(Number)


Ar eaNo(Area)


Ar eaPath


ClassName


TagFormatName

DESC

Description()


PIDNo(P&ID No)

PREFIX

Prefix(Prefix)

SUFFIX

Suffix(Suffix)

LOCA

ISALocation(Loc)

SCLORE

LoopKEY()



75

www.aveva.com


5.6

Mappi ngs: SCACTUATOR (Element Type)

Select the option SCACTUATOR from the pull down list under Element Types.


76

www.aveva.com


Using the table below as a guide, map the AVEVA Diag ram s fields to the AVEVA Ins tr um ent ati on fields using the pull down list:

AVEV A Di agr ams Fiel d


NAME

TagNo(TagNo)

FUNC

ISAFunc(Function)

NUMB

LNumber(Number)


Ar eaNo(Area)


Ar eaPath


ClassName


TagFormatName

DESC

Description()


PIDNo(P&ID No)

PREFIX

Prefix(Prefix)

SUFFIX

Suffix(Suffix)

LOCA

ISALocation(Loc)

SCLORE

LoopKEY()



77

www.aveva.com


5.7

Mapping s: SCLOOP (Element Type)

Select the option SCLOOP from the pull down list under Element Types.



NAME

LoopNo(Loop No)


Ar eaPath

:LoopClassName

ClassName


TagFormatName

DESC

LoopType(LoopType)

FUNC

LoopPV(LoopPV)

:LoopSuffix

LoopSuffix(Suffix)

:LoopPrefix

LPrefix(Prefix)

:how does

LNo(LNo)


AreaNo(Area)



78

www.aveva.com


Click the Save button on the AVEVA Diagrams Import Configuration form.


79

www.aveva.com


5.8

Import Loops

Select Home > Select > Loops (under Lists)

This will display the Loops grid. Select the Manage tab, and click the AVEVA Di agr ams Imp or t button from the Integration pane.

An AVEV A Ins tr um ent ati on Eng in eer alert form is displayed. Click the Yes button on the alert form to acknowledge the message and proceed with the import.


80

www.aveva.com


The AVEVA AVEV A Di agr ams Lo gi n form is displayed.

 The AVEVA Diagrams Login form will only appear if the user has exited Instrument Engineer after saving the mapping within the Import Configuration window. Enter the following details on the form. Project text box

SAM

Username text box

SYSTEM

Password text box

XXXXXX

Project MDB text box

SAMPLE

Click the OK button.

AVEVA Instrumentation will then login to the Diagrams model database and report the number of loops available for import. Click the Batch Process All button.

Check the Ac Accep cep t Al Alll checkbox and click the Save button from the menu on the Import Differences window.


81

www.aveva.com


A Progress window is displayed. The Import Log window appears which identifies the successfully and failed imported data.

Click the Close button to exit.

The imported Loops are displayed on the Loops grid.


82

www.aveva.com


5.9 5. 9

Import Instrument Ta Tags gs

Select Home > Select > Instruments (under Lists). Select the Manage tab, and click the AVEV AVEVA A Di agr ams Imp or t button from the Integration pane.

AVEVA Instrumentation will login to the Diagrams model database and report the number of Instrument Tags available for import.

Click the Batch Process All button.

 If there are matching Instrument tag items in AVEVA Instrumentation, these will be shown in the Import from Diagrams Model dialogue with number for the Existing Tags will be updated . Similarly, matching Instrument Tag items with no change in the mapped attributes will be shown with the number of Unchanged Existing Tags .


83

www.aveva.com


Check the Ac cep t Al l checkbox and then click the Save button from the menu on the Import Differences window.

A Progress window is displayed. The Import Log window is displayed which identifies the successfully and failed imported data.



84

www.aveva.com


The imported Instrument tags with their assigned Loops are displayed on the Instruments grid.


85

www.aveva.com




86

www.aveva.com

CHAPTER 6

6

6.1

Integration with AVEVA Diagrams usin g AIS


Aveva Instrumentation can be integrated with Aveva Diagrams using service mode also to do data exchange.Local mode of integration can be used only if the Aveva Instrumentation and Aveva Diagrams both coexist in the same machine. The service mode came into existence to get rid of this drawback and do data exchange even if the applications are installed in separate machines but in the some network.

Setup AVEVA Diagrams as Data Source in Inte ration Services

Create import mapping configurations in Integration Services


Select records and update the Database

Loops grid: Import Loops

Instruments grid: Import Instrument Ta s


87

www.aveva.com


6.2

AVEVA Diagrams config urations

For successful integration of AVEVA Ins tr um ent ati on with AVEVA Diag ram s specific UDAs need to be configured in the APS project. The required UDAs can be created from the Lexicon module of the AVEV A A dmi ni st rat io n application. Open AVEV A A dm in is tr ati on using Start > All Pro grams > AVEVA > Manage > AVEVA Adminis tration 1.4

Login to the administrator using the following credentials User : SYSTEM Password : XXXXXX MDB : ALL

Click on Lexicon.

The APS project should have the required UDAs already created by default under the UDA group; Dictio nary Wo rl* > UWRL PMGSchematicUdas > UGRO Comp areUpdateUDAS.

In this node, the UDA ClassName , UDA TagFormatName, UDA AreaPath , UDA AreaNo and UDA pmgsch-ai are listed.

 If the required UDAs are not present in the project, the user will need to create them manually, as explained below. If only part of the hierarchy is missing only the additionally required levels need to be added.


88

www.aveva.com


To create the UDA hierarchy, right click on the Dictionary Worl* > Create > UWRLD: User Defined At tr ib ut e Wor ld button as shown below

In the Current Element Editor window enter the details Name: PMGSchematicUdas Description: Udas for Schematic Integration


89

www.aveva.com


Right click on the UWRL PMGSchematicUdas node and create a User defined attribute Group by the path Create > UGROUP : User defined attribute group

In the Current Element Editor window enter the details Name: CompareUpdateUDAS Description: Schematic UDAs for Integration


90

www.aveva.com


The user needs to create the following 4 UDAs ClassName TagFormatName Ar eaPath Ar eaNo Right click on the UGRO Co mpareUpdat eUDAS node and create a UDA: User defined attri bute

 For the purpose of demonstration the procedure to create one UDA is explained below. The same procedure can be followed to create the remaining three UDAs

Select the newly created Node UDA1 and in the Current Element Editor insert the values as shown Name: ClassName Description: ClassName Ab br evi ati on Len gt h: 3 UDA type: text (Select from List) User-defined Name: ClassName

The Element types field must have its options selected through the (…) button For integration of AVEVA Diagrams with AVEVA Instrumentation, the Instrument and Loop data is being imported to AVEVA Instrumentation. This means the Element types to be selected are SCINSTRUMENT and SCLOOP


91

www.aveva.com


Upon clicking the (…) button the below screen is presented where the user can add these element types.

In the Filter text box enter SCIN which lists the SCINSTRUMENT in the Av ail abl e elem ent ty pes section. Select SCINSTRUMENT and click Add to List

Similarly in the Filter enter SCLO and SCLOOP will be listed. Select and click Ad d t o L is t

Click on OK button to add the Element t ypes once both have been added.

The Current Element Editor will be displayed as shown in the screen right.

Follow the same process to create the other UDAs.

The hierarchy should have the following form when all four have been added


92

www.aveva.com


6.3

AVEVA Integration Service confi gurations

Open the Integration Services Editor by browsing to Start > All Programs > AVEVA > Integration > Integration Settings Edit or

In the Av ail abl e Data So ur ces section, for the Data Source Name select AVEVA Diag ram s from the list

Click the Add Co nf ig ur ati on button

The user is presented with the below login screen. The Products field lists all the versions of AVEVA Diagrams present in the local machine. Select AVEVA Di agr ams 14.1.0 from the list and click Get Projects


93

www.aveva.com


When the Get Projects button is clicked the application list all the AVEVA Diagrams projects present in the system

Enter the following values Project : Username : Password : MDB :

ProjAPS SYSTEM XXXXXX AL L

Click the Login button

The APS Pr oj ect will be added as a new row in the AVEVA Integration Services window. Click on Save button and application gives a message Saved Datasource .Click Yes and then the Exit button on the below screen


94

www.aveva.com


6.4


To use the Compare/Update facility in AVEVA Instrumentation relevant configurations must be set-up,for example attribute mappings between the AVEVA Instrumentation project and the Data source, data filters . These operations can be done in AVEVA Instrumentation Application. These configurations are created and edited using the Import Configuration option: Start AVEVA Electrical Engineer application by browsing to Start > All programs > AVEVA > Engineer > AVEVA Instrumentation 12.1.4 > Instrumentation Engin eer 12.1.SP4

In the Select an AVEVA Instrum entation Project screen click on the New button

Create a new AVEVA Instrumentation project demo project with following details Select Demo Project radio button and click on SQL Server […] to provided the SQL server details In the corresponding fields provide the details as listed below. Project Name or No: Project Description: Plant Name: Plant Location: Client Name: Client Project No: Project Folder: Design Database:

AI_DIAG_A IS Integration wit h AVEVA Diagrams Using AIS AVEVA In st ru men tat io n Dem o Local AVEVA So lu ti on s L td TM6501-02 C:\AVEVA_Instrumentation Training\Projects\AI_DIAG_AIS AI_DIAG_A IS


95

www.aveva.com


Click on the Save Button to create the demo project.

 The user should have sufficient rights to the SQL Server to create the project as well as the database.


96

www.aveva.com


Open the newly created project and browse to the following location Project > Setup > AVEVA Integration Services > Import Conf iguration

The Confirmation window for the connection will appear. Click Yes to confirm.

 The Service Installed On: field should point to the machine where the AVEVA Integration Service is running. If the Integration service is running on the same machine the localhost value will work properly.


97

www.aveva.com


This opens the Service Import Configuration Settings window. Select the source AVEV A Diagr ams from the Select Sourc e list.

 If no services have been configured, the list will be empty. Login to the project after the source has been selected with the Login button The Select an AVEVA Diagrams Project dialog is then displayed for the selected data source.


98

www.aveva.com


Enter the Password XXXXXX and click the Connect button.


99

www.aveva.com


Once the login is completed, the Select Act ion section of the form will be enabled. It is used to create, edit and delete configurations. (Step 1 of 5): Choose mode of o peration

To create a new configuration, the desired mode of operation needs to be chosen.

 This worked example illustrates how to create a new Service Import configuration for Loads. Select the Create new config uration option, and then click the Next button to proceed to the next step.


100

www.aveva.com



Source: The source data is the data that will be the basis of the comparison. In this case make sure AVEVA Diagrams is selected Configuration Name : This will be the name the configuration will be identified as. Enter Instrument for this field. Group : This will be the group the configuration will be created in. Enter AI001 for this field. Object Type Mapping : This will be the element type that the configuration utilises. In this case select SCINSTRUMENT .

Name Attribu te : This will be the selected e lement type that is utilised to f ind possible matches between the source AVEVA Diagrams items, and target AVEVA Electrical items. Select the NAME option Unique Attribute : This will be the attribute that serves as the unique key attribute of source items. Select the DBREF option



101

www.aveva.com



This step provides the option to choose target data in the selected AVEVA Electrical database. Target data is compared against source data.

Object Type: This will be the type of object in the Destination database. Select Instrument for this option Name Attrib ute: This will be the objected type utilised to find attribute matches in AVEVA Electrical items. Select TagNo for this option. Unique Attribute: This will serve as the unique key attribute of the distination items. Select InstKey for this option.

Insert Option: This will allow for the creation of new items in the target database , if source items do not find a matching target item after comparison.

Select Allo w In ser ti on .



102

www.aveva.com



Ad d Fi lt er : Retain the default blank entries. This allows for the definition of criteria which limit the population of source data that will be used in the comparison.

This Delete Filter : button deletes any set filter.



Attributes of the source element types can now be mapped to those of the corresponding target element types. Attribute selection and mapping indicates the attribute values to be obtained and/or compared against. Basic mappings for the import facility between AVEVA Electrical and AVEVA Diagrams can be setup as illustrated below. Click on the Add m app in g button to display a new mapping row. Mapped attributes can be selected and then deleted with the Delete Mapping button. Select a AVEV A Diag ram s (Sou rc e) attribute from the pull-down list, then select a corresponding AVEVA Electrical (Destinatio n) attribute from its available list to map it to. Using the table below as a guide, map the following fields: AVEV A Di agr ams (Sour ce)

AVEVA El ect ri cal (Dest in ati on )

AreaNo

Ar eaNo

AreaPath

Ar eaPath

Classname

ClassName

TagFormatName

TagFormatName

NAME

TagNo

NUMB

LNumber

Suffix

Suffix

FUNC

ISAFunction


103

www.aveva.com


In the AVEVA Electrical column; AreaNo, Eq ui pm ent No, Cl ass Name, Tag For mat Name, A reaPath , and EqType are the mandatory fields and must be mapped by the user. The window should have the following form when the attributes have been mapped.

Click the Finish button, and then select the OK button from the message form.

Open the APS project in AVEVA Diagrams Start > All Pr ogr ams > AVEVA > Engi neer > AVEVA Diagrams 14.1.0


104

www.aveva.com


To import instrument from AVEVA Diagrams to AVEVA Instrumentation the user needs to change some of the values in the existing Instrument as shown below. The application has an instrument with Name: LV-114. Select this instrument and enter the following values which are used in configuration mapping. Name: 01-LV-114 Function : LV ClassName: INS NUMB : 114 Suffix : TagFormatName : ISA with Area (delimiters) Ar eaNo - 01

Similarly another instrument FV-115 has given values as below Name: 01-FV-115 Function : FV ClassName: INS NUMB : 115 Suffix : TagFormatName : ISA with Area (delimiters) Ar eaNo - 01

After changing the values the fields will be highlighted in blue as shown. Save the values by clicking the Save button in the menu.


105

www.aveva.com


6.5

Impor t Loads fro m AVEVA Diagrams 14.1

Select the Home > Select > Instru ment option.

The Instruments displayed.

grid

is

then

On the Manage tab, in the Service Integration group, select AVEVA Diagrams from the Products options list.


This opens the Select an AVEVA Diagrams Proj ect window

Enter the following Password: XXXXXX Click the button.

Connect

On the Manage tab, in the Servic e Integration group, select AI001 from the Groups options list.


106

www.aveva.com


Select Import Data The Integration operation will then take place. The values of the mapped attributes of a source (AVEVA Diagrams) item will be compared with the attributes values of any existing and matched corresponding destination (AVEVA Electrical) item. Click the Yes button

The list of Instruments available are displa yed on the Compare/Update window.


107

www.aveva.com


Clicking the At tr ib ut e Detai ls tab displays the mapped attributes for the items

.

 The background colours of the rows in the Compare/Update grids indicate the status of the data according to chapter 2.6.

The check boxes can be used to import the data for individual items, the Ac cep t All can be used to import all the items. In the AI001 ( 16 Items - 16 Changed ) tab select the 01-LV-114 and 01-FV-115 instrument and click the Update Database button on the menu


108

www.aveva.com


An Update database window is displayed, in which the number of Items analysed and the required action in AVEVA Electrical is indicated.

Click the UpdateDB button.

Click the Close to exit the Update database window and then Close again to exit the Compare/Update form. The Instrument grid is now updated with the Load Tags, from AVEVA Di agr ams .


109

www.aveva.com




110

www.aveva.com

CHAPTER 7

7 7.1

Integration with AVEVA Schematic Model Manager Overview Workflow

When integrating the two applications the user can import project data (e.g. Offline instruments, inline instruments, valves, actuators or loops) from AVEVA Sch emat ic Mod el into AVEVA Ins tr um ent ati on by following some basic steps:

Setup: AVEVA Schematic

Select & Login: AVEVA Schematic Model Import Version


Set the Ma in


Instruments grid: Import Instrument

 The Project setup for the Schematic Model is the same as previously described for AVEVA Diagrams.


111

www.aveva.com

AVEVA Instrumentation (12.1) Instrumentation Integration (TM-6107)

7.2


Create a new project using the information below: Copy Demo Project check box: Checked Share with Electrical check box: Checked Project Name or No text box: Integ-SMM Project Description text box: Integrate with AVEVA SMM Plant Name text box: AVEV A In st ru men tat io n Dem o Plant Location text box: Local Client Name text box: TPS Client Project No text box: TM6107 Project Folder: C:\AVEVA_Instrumentation Training\Projects\Integ-SMM DesignDatabase text box: INTEG_AI_SMM Click the Save button to create the new project.


112

www.aveva.com


7.3

Impor t Config urati on for AVEVA Schematic Data Model

Start AVEVA Instrumentation Engineer, and select Project > Setup > AVEVA Diagram Import Configuration > AVEVA Schematic Model Import Configu ration.

Select the appropriate PDMS version e.g. 12.1SP4.

Login into the project by selecting the Login button.


113

www.aveva.com


Fill in the details as shown. Click on the OK button Project: SAM Username: SYSTEM Password: XXXXXX MDB: SAMPLE


114

www.aveva.com


7.4

Mappi ngs: SCOINSTRUMENT (Element Type)

Using the table below as a guide, only map the following fields: AVEV A Sc hem ati c Mo del Fiel d

AVEV A In st ru men tat io n Fiel ds

NAME

TagNo(TagNo)

FUNC

ISAFunc(Function)

NUMB

LNumber(Number)


Ar eaNo(Area)


Ar eaPath


ClassName


TagFormatName

DESC

Description()


PIDNo(P&ID No)

PREFIX

Prefix(Prefix)

SUFFIX

Suffix(Suffix)

LOCA

ISALocation(Loc)

SCLORE

LoopKEY()

Under AVEVA In st ru men tat io n Fi eld s : AreaNo , AreaPath , ClassName , TagFormatName , TagNo , ISAFunc and LNumber are the mandatory fields and must be mapped by the user.


115

www.aveva.com


7.5

Mappi ngs: SCINSTRUMENT (Element Type)

Using the table below as a guide, only map the following fields: AVEV A Sc hem ati c Mod el Fi eld


NAME

TagNo(TagNo)

FUNC

ISAFunc(Function)

NUMB

LNumber(Number)


Ar eaNo(Area)


Ar eaPath


ClassName


TagFormatName

DESC

Description()


PIDNo(P&ID No)

PREFIX

Prefix(Prefix)

SUFFIX

Suffix(Suffix)

LOCA

ISALocation(Loc)

SCLORE

LoopKEY()

Under AVEVA In st ru men tat io n Fi eld s : AreaNo , AreaPath , ClassName , TagFormatName , TagNo , ISAFunc and LNumber are the mandatory fields and must be mapped by the user.


116

www.aveva.com


7.6

Mapping s: SCVALV (Element Type)

Using the table below as a guide, only map the following fields: AVEV A Sc hem ati c Mod el Fi eld


NAME

TagNo(TagNo)

FUNC

ISAFunc(Function)

NUMB

LNumber(Number)


Ar eaNo(Area)


Ar eaPath


ClassName


TagFormatName

DESC

Description()


PIDNo(P&ID No)

PREFIX

Prefix(Prefix)

SUFFIX

Suffix(Suffix)

LOCA

ISALocation(Loc)

SCLORE

LoopKEY()

Under AVEVA Ins tr um ent ati on Fiel ds : AreaNo , AreaPath , ClassName, TagFormatName , TagNo , ISAFunc and LNumber are the mandatory fields and must be mapped by the user.


117

www.aveva.com


7.7

Mappi ngs: SCACTUATOR (Element Type)

Using the table below as a guide, only map the following fields: AVEV A Sc hem ati c Mo del Fiel d


NAME

TagNo(TagNo)

FUNC

ISAFunc(Function)

NUMB

LNumber(Number)


Ar eaNo(Ar ea)


Ar eaPath


ClassName


TagFormatName

DESC

Description()


PIDNo(P&ID No)

PREFIX

Prefix(Prefix)

SUFFIX

Suffix(Suffix)

LOCA

ISALocation(Loc)

SCLORE

LoopKEY()

Under AVEVA Ins tr um ent ati on Fiel ds : AreaNo , AreaPath , ClassName, TagFormatName , TagNo , ISAFunc and LNumber are the mandatory fields and must be mapped by the user.


118

www.aveva.com


7.8

Mapping s: SC SCLOOP LOOP (Element Type)

Using the table below as a guide, only map the following fields: AVEV A Sc hem ati c Mod M od el Fi eld

AVEV A In st ru men tat io n Fiel F iel d

NAME

LoopNo(Loop No)


Ar eaPath

:LoopClassName

ClassName


TagFormatName

DESC

LoopType(LoopType)

FUNC

LoopPV(LoopPV)

:LoopSuffix

LoopSuffix(Suffix)

:LoopPrefix

LPrefix(Prefix)

:LoopNum

LNo(LNo)


AreaNo(Area)

Under AVEVA AVEV A Ins tr um ent ati on Fiel ds : LoopNo(Loop No), AreaPath , ClassName and TagFormatName are mandatory fields and must be mapped by the user.


119

www.aveva.com


7.9 7. 9

Import Loops

Select Home > Select > Loops (under Lists) This will display the Loops grid. Select the Manage tab, and click the AVEV AVEVA A Di agr am Im po rt > AVEVA AVE VA Sch S ch emat ic Mo Model del Imp or t button from the Integration pane.

An AVEVA AVEV A In st ru men tat io n En gi neer alert form is displayed. Click the Yes button on the alert form to acknowledge the message and proceed with the import.


120

www.aveva.com


The AVEVA AVEV A Sc hem ati c Mo del Lo gi n form is displayed.

 The AVEVA Schematic Model Login form will only appear if the user has exited Instrument Engineer after saving the mapping within the Import Configuration window.

Enter the following details on the form. Project text box

SAM

Username text box

SYSTEM

Password text box

XXXXXX

Project MDB text box

SAMPLE

Click the OK button.

AVEVA Instrumentation will then login to the Schematic Model database and report the number of loops available for import. Click the Batch Process All button.

Check the Ac cep t Al l checkbox and click the Save button from the menu on the Import Differences window.


121

www.aveva.com






122

www.aveva.com


7.10 7. 10 Import Instru Instru ment Ta Tags gs Select Home > Select > Instruments (under Lists). Select the Manage tab, and click the AVEV AVEVA A En gi neer in g Im po rt > AVEV A Sc hem ati c Mo del Imp or t button from the Integration pane.

AVEVA Instrumentation will login to the Schematic Model database and report the number of Instrument Tags available for import.


 If there are matching Instrument tag items in AVEVA Instrumentation, these will be shown in the Import from Schematic Model dialogue with number for the Existing Tags will be updated . Similarly, matching Instrument Tag items with no change in the mapped attributes will be shown with the number of Unchanged Existing Tags .


123

www.aveva.com


Check the Ac Accep cep t Al Alll checkbox and then click the Save button from the menu on the Import Differences window.

A Progress window is displayed and Import Log window is displayed which identifies the successfully and failed imported data.



124

www.aveva.com




125

www.aveva.com




126

www.aveva.com

CHAPTER 8

8

Integration with AVEVA Engineering –Tags

8.1


When integrating the two applications the user can import project data (e.g. Loops and Instrument Tags) from AVEVA Eng in eeri ng into AVEVA In st ru men tat io n by following some basic steps:

Setup: AVEVA Tags Import Configuration

Select & Login: AVEVA Ta s Version

Select Element Type: e.g. :INSTTAG , :LOOPTAG

Set the Mapping Values


Instruments grid: Import Instrument

 The above steps are performed in the Instrument Engineer module within the AVEVA Instrumentation suite.


127

www.aveva.com


8.2


Create a new project using the information below: Copy Demo Project check box:

Checked

Share with Electrical check box:

Checked

Project Name or No text box:

Integ-Tags

Project Description text box:

Integrate with AVEVA Tags

Plant Name text box:

AVEV A In st ru men tat io n Dem o

Plant Location text box:

Local

Client Name text box:

TPS

Client Project No text box:

TM6107

Project Folder:

C:\AVEVA_Instrumentation Training\Projects\Integ-Tags

Design Database text box:

INTEG_AI_Tags



128

www.aveva.com


8.3

Import Configuration for AVEVA Tags

Start AVEVA Instrumentation Engineer, and select Project > Setup > AVEVA Engineering Integration Configuration and login to the project.


129

www.aveva.com


The AVEVA En gi neer in g Imp or t Co nf ig ur ati on is then displayed. Select the appropriate version e.g. AVEVA Engineering 14.1.0.

Login to AVEVA Engineering and fill in the appropriate project details as shown. Click on theOK button Project: ACE Username: SYSTEM Password: XXXXXX MDB: ADMIN-LEXICON


130

www.aveva.com


Once logged on, the available AVEVA Eng in eeri ng Elem ent s are displayed. The form defaults to the Instruments equipment type.

Select Loops from the options under the Equipment Type pull down list.


131

www.aveva.com


Similarly, select the Engineering Element :INSTLOOP and click the > button. This will place the Engineering Element :INSTLOOP into the Selected Elements column.

Select Instruments from the options under the Equipment Type pull down list.


132

www.aveva.com


Then select the Engineering Element :INSTRUMENT and click the > button. This will place the Engineering Element :INSTRUMENT into the Selected Elements column.

Click the Next button on the AVEVA Eng in eeri ng Data Im po rt Con fi gu rat io n window.


133

www.aveva.com


This will open the mappings form where AVEVA Engineering attributes can be mapped to the AVEVA Instrumentation attributes:


134

www.aveva.com


8.4

Mapping s for Instruments Equipment Type

Using the table below as a guide, only map the following fields: AVEVA En gi neer in g Fi eld

AVEV A In st ru men tat io n

NAME

TagNo(TagNo)

:TagFormatName

TagFormatName(TagFormat Name)

:SUFFIX

Suffix (Suffix)

:PREFIX

Prefix (Prefix)

:PIDNO1

PIDNo(P&ID No)

:MODELNO

ModelNo

:MANUFACTURER

Manufacturer(Manufacturer)

:LNumber

LNumber(Number)

:ISERVICE1

IService1(InstrumentService)

:ISALocation

ISALocation(Loc)

:Instrument-Type-Code

ISAFunc(Function)

:Instrument-Type

Description

:DCSIO\:INSTRUMENT-DATA

DCSIO(DCSI/O)

:InstClassCode

ClassName(Class Name)

:AreaPath

Ar eaPath (Ar ea Path )

:AREANO

Ar eaNo(Ar ea)

The AVEVA Instrumentation Fields Ar eaNo , Ar eaPath , Clas sNam e, TagFor mat Name, TagNo , and TagCodes are mandatory fields and must be mapped by the user. Copyright © 2014. AVEVA Solutions Limited and its subsidiaries. All rights reserved.

135

www.aveva.com


8.5

Mapping s for Loops Equipment Type

Select Loops from the Equipment Type pull down list.

Using the table below as a guide, only map the following fields: AVEV A En gi neer in g Fi eld

AVEV A In st ru men tat io n

:TagFormatName

TagFormatName(TagFormatName)

:COMMENTS\:INSTLOOP-DATA

Remarks(LoopRemarks)

:Name

LoopNo

:LoopClassCode

ClassName

:AreaPath

Ar eaPath

:AreaNo

Ar eaNo

:LNo

LNo(LNo)

The AVEVA Instrum entation Field LoopNo , ClassName, TagFormatName, Ar eaNo and Ar eaPath , and TagCodes are mandatory fields and must be mapped by the user.

 The mandatory fields must be mapped for the import to be successful: Ar eaNo, Ar eaPath , ClassName, FormatName, LoopNo and Tag codes (In this example: LoopType, LNo and LoopSuffix).

Click the Save button to exit the AVEVA Tag s Im po rt Con fi gu rat io n window.


136

www.aveva.com


8.6

Import Loops

Select Home > Select > Loops (under Lists)

This will display the Loops grid.

Select the Manage tab, and click the AVEVA En gi neer in g Im po rt button from the Integration pane.

An AVEVA In st ru men tat io n En gi neer alert form is displayed.

Click the Yes button on the alert form to acknowledge the message and proceed with the import.


137

www.aveva.com


 The trainer will provide a macro file to create loop elements for those who do not have any AVEVA Engineering data in their database.

An Import from AVEVA Tags Model window is displayed which indicates the number of Loops analysed and will be imported into AVEVA Instrumentation.

 The trainer will provide a macro file to create loop elements for those who do not have any AVEVA Engineering data in their database.

Click the Batch Process All button to analyse the Instrument tags in bulk or click the Process one by one button to analyse each Loop.


138

www.aveva.com


The list of Process Loops available to import are displayed on the Import Differences window. Check the Ac cep t All check box and click the Save button on the menu.

A Progress window is displayed while AVEVA Instrumentation performs the import. The Import Log form is then displayed, listing the number of valid Loops successfully imported. Click the Close button on the menu.


139

www.aveva.com



8.7

Import Instrum ents

Select Home > Select > Instruments (under Lists).


140

www.aveva.com


Select the Manage tab, and click the AVEVA En gi neer in g Im po rt button from the Integration pane.

AVEVA Instrumentation will login to the Tags model database and report the number of Instrument Tags available for import.


 If there are matching Instrument tag items in AVEVA Instrumentation, these will be shown in the Import from Tags Model dialogue with number for the Existing Tags will be updated . Similarly, matching Instrument Tag items with no change in the mapped attributes will be shown with the number of Unchanged Existing Tags .


141

www.aveva.com


Check the Accep t All checkbox and then click the Save button from the menu on the Import Differences window.



142

www.aveva.com


In this example tagged item ‘LI -114’ failed to upda te because the import Class Name does not exists in AVEVA Instrument. Click the Close button on the menu to exit the Import Log form.



143

www.aveva.com




144

www.aveva.com

CHAPTER 9

9 9.2

Integration With AVEVA Engineering using AIS Over View - Workf low

The integration between the AVEVA Instrumentation application and the AVEVA Engineering application involves the pulling in of data from Engineering (Engi) databases. Integration of Aveva Instrumentation and Engineering requires Aveva Integration Services to be installed in the system that Aveva Engineering is installed in. The required project in Engineering should be added in integration settings editor and using the AIS, the Engineering data can be transferred to Aveva Electrical.

Setup AVEVA Engineering as Data Source in Integration

Create Import Mapping configurations in AVEVA Instrumentation Services

Select Element Type: e.g. :INSTTAG , :LOOPTAG

Select records to import and Update the Database


Instruments grid: Import Instrument Tags


145

www.aveva.com


9.3

AVEVA Engineering confi gurations

For successful integration of AVEVA Ins tr um ent ati on with AVEVA En gi neer in g specific UDAs first need to be configured in the ACE project. The required UDAs can be created from the Lexicon module of the AVEV A A dmi ni st rat io n application. Open AVEV A A dm in is tr ati on using Start > All Pro grams > AVEVA > Manage > AVEVA Adminis tration 1.3

Login to the administrator using the following credentials

User: SYSTEM Password: XXXXXX MDB: ADMINLEXICON

Click on Lexicon.

The ACE project should have the required UDAs already created by default under the UDA group; Dicti onary Worl* > UWRL PMGSchematic Udas > UGRO CompareUpdateUDAS.

In this node, the UDA ClassName , UDA TagFormatName, UDA AreaPath , UDA AreaNo and UDA pmgsch-ae are listed.

 If the required UDAs are not present in the project, the user will need to create them manually, as explained below. If only part of the hierarchy is missing only the additionally required levels need to be added.

To create the UDA hierarchy, right click on the Dictionary Worl* > Create > UWRLD: User Defined At tr ib ut e Wor ld button as shown below


146

www.aveva.com


In the Current Element Editor window enter the details Name: PMGSchematicUdas Description: Udas for Schematic Integration


147

www.aveva.com


Right click on the UWRL PMGSchematicUdas node and create a User defined attribute Group by the path Create > UGROUP : User defined attribute group

In the Current Element Editor window enter the details Name: CompareUpdateUDAS Description: Schematic UDAs for Integration


148

www.aveva.com


Create the following four UDAs: ClassName TagFormatName Ar eaPath Ar eaNo

Right click on the UGRO CompareUpdat eUDAS node and create a UDA: User defined attri bute

 For the purpose of demonstration the procedure to create one UDA is explained below. The same procedure can be followed to create the remaining three UDAs

Select the newly created Node UDA1 and in the Current Element Editor insert the values as shown Name: ClassName Description: ClassName Ab br evi ati on Len gt h: 3 UDA type: text (Select from List) User-defined Name: ClassName

The Element types field must have its options selected through the (…) button For integration of AVEVA Diagrams with AVEVA Electrical, the Equipment and Subequipment data is being imported to AVEVA Electrical. This means the to be selected are Element types SCINSTRUMENT ,SCOINSTRUMENT an d SCLOOP


149

www.aveva.com


Upon clicking the (…) button the below screen is presented where the user can add these element types. In the Filter text box enter SCI which lists the SCINSTRUMENT in the Av ail abl e elem ent ty pes section. Select SCINSTRUMENT and click Add to List

Similarly in the Filter enter SCO and SCOINSTRUMENT will be listed. Select and click Add t o L is t In the Filter enter SCL and SCLOOP will be listed.Select and click Add to List. Click on OK button to add the Element types once both have been added.



The hierarchy should have the following form when all four have been added


150

www.aveva.com


In addition to the above UDAs a group of UDAs related to electrical equipment must be created. In the Lexicon application create another set of UDAs inside a UWRL named ElectricalIntegrationUDAs. Right click on Dictionary WORL * and create a UWRLD: User defined attribute world. In the Current Element Edito r enter the details Name: ElectricalIntegrationUDAs Description: Udas for Electrical Integration

Add following UDAs inside this group by right click on UWRL ElectricalIntegrationUDAs and then selecting UDA: User defined attribu te

UDA Name/Description E_Frequency

Abbreviation Length 3

UDA Type Text

UDA Length 15

SUBEQUIPMENT

User Defined Name E_Frequency

E_Phases

3

Text

15

SUBEQUIPMENT

E_Phases

E_PowerFactor

3

Text

15

SUBEQUIPMENT

E_PowerFactor

E_RatedFLC

3

Text

15

SUBEQUIPMENT

E_RatedFLC

E_RatedPower

3

Text

15

SUBEQUIPMENT

E_RatedPower

E_Voltage

3

Text

15

SUBEQUIPMENT

E_Voltage


151

Element Type

www.aveva.com


The Dictionary WORL* should have the following hierarchy once these UDAs have been added Perform a Savework to finish this section.


152

www.aveva.com


9.4



In the Av ail abl e Data So ur ces section, for the Data Source Name select AVEVA Eng in eeri ng from the list

Click the Add Co nf ig ur ati on button

The user is presented with the below login screen. The Products field lists all the versions of AVEVA Engineering present in the local machine. Select AVEVA Eng in eeri ng 14.1.1 from the list and click Get Projects


153

www.aveva.com


When the Get Projects button is clicked the application list all the AVEVA Engineering projects present in the system

Enter the following values Project : Username : Password : MDB :

ACE SYSTEM XXXXXX ADMIN-L EXICON

Click the Login button

The ACE Pr oj ect will be added as a new row in the AVEVA Integration Services window. Click on Save and the application gives a message Saved datasourc e. Click OK and then the Exit button in the Integration Settings Editor .


154

www.aveva.com


9.5


To use the Compare/Update facility in AVEVA Instrumentation relevant configurations must be set-up, for example attribute mappings between the AVEVA Instrumentation project and the Data source, data filters. These operations can be done in the AVEVA Electrical Application. These configurations are created and edited using the Import Configuration option: Start AVEVA Electrical Engineer application by browsing to Start > All programs > AVEVA > Engineer > AVEVA Electrical 12.1.4 > Electrical Instrumentation 12.1.SP4



155

www.aveva.com


Create a new AVEVA Instrumentation project demo project with following details Select Demo Project radio button and click on SQL Server […] to provide the SQL server details In the corresponding fields provide the details as listed below. Project Name or No: Project Description: Plant Name: Plant Location: Client Name: Client Project No: Project Folder: Design Database:

AIDEMO_ENGG_AIS Integration with AVEVA Engineering Using AIS AVEVA In st ru men tat io n Dem o Local AVEVA So lu ti on s L td TM6501-02 C:\AVEVA_InstrumentationTraining\Projects\AIDEMO_ENGG_AIS AIDEMO_ENGG_AIS




156

www.aveva.com






157

www.aveva.com


This opens the Service Import Configuration Settings window. Select the source AVEV A En gi neer in g from the Select Sourc e list.


Login to the project after the source has been selected with the Login button

The Select an AVEVA Engi neering Project dialog is then displayed for the selected data source.

Enter the XXXXXX

Password:

Then click the Connect button.


158

www.aveva.com






159

www.aveva.com



Source : The source data is the data that will be the basis of the comparison. In this case make sure AVEVA Engineering is selected Configuration Name: This will be the name the configuration will be identified as. Enter AIENGG01 for this field. Group : This will be the group the configuration will be created in. Enter AIENGG01 for this field. Object Type Mapping : This will be the element type that the configuration utilises. In this case select INSTRUMENT .

Name Attribu te : This will be the selected e lement type that is utilised to f ind possible matches between the source AVEVA Diagrams items, and target AVEVA Electrical items. Select the NAME option Unique Attribute : This will be the attribute that serves as the unique key attribute of source items. Select the REF option



160

www.aveva.com



This step provides the option to choose target data in the selected AVEVA Instrumentation database. Target data is compared against source data. Object Type: This will be the type of object in the Destination database. Select Instrument for this option Name Attribu te: This will be the objected type utilised to find attribute matches in AVEVA Instrumentation items. Select TagNo for this option. Unique Attribute: This will serve as the unique key attribute of the destination items. Select InstKEY for this option.


Select Allo w In ser ti on . Click on the Next button to proceed to the next step.


161

www.aveva.com


(Step 4 of 5): Define Source Filter(s) Ad d Fi lt er : Retain the default blank entries. This allows for the definition of criteria which limit the population of source data that will be used in the comparison.




162

www.aveva.com



Attributes of the source element types can now be mapped to those of the corresponding target element types. Attribute selection and mapping indicates the attribute values to be obtained and/or compared against. Basic mappings for the import facility between AVEVA Instrumentation and AVEVA Engineering can be setup as illustrated below. Click on the Add m app in g button to display a new mapping row. Mapped attributes can be selected and then deleted with the Delete Mapping button. Select a AVEV A Eng in eeri ng (Sou rc e) attribute from the pull-down list, then select a corresponding AVEV A In st ru men tat io n (Destin ati on ) attribute from its available list to map it to. Using the table below as a guide, map the following fields: AVEV A Di agr ams (Sour ce)

AVEV A El ect ri cal (Dest in ati on )

AREANO

Ar eaNo

AreaPath

Ar eaPath

InstClassCode

ClassName

TagFormatName

TagFormatName

NAME

TagNo

InstrumentType

ISAFunc

TAGNUMBER

LNumber

PREFIX

Prefix

SUFFIX

Suffix

DESC

Description

In the AVEVA Instrumentation column; AreaNo, Eq ui pm ent No, Cl ass Name, TagFo rm atNam e, Ar eaPath , and InstrumentType are the mandatory fields and must be mapped by the user. The window should have the following form when the attributes have been mapped.


163

www.aveva.com




164

www.aveva.com


Open the ACE project in AVEVA Engineering To import equipment from AVEVA Engineering to AVEVA Instrumentation the us er needs to change some of the values in the existing Instrument as shown below.

The application has 3 instruments with Name: FE-222, FV-222 and LV-119. Select these instruments and enter the following values which are used in configuration mapping.

Attributes AreaNumber AreaPath Desc FormatName InstrumentClass Code InstrumentType Lnumber NAME Prefix Suffix

00 Unset Orifice Plate ISA with Area (delimiters)

Instruments to be imported 00 Unset Flow Valve ISA with Area (delimiters)

00 Unset Level Control Valve ISA with Area (delimiters)

INS

INS

INS

FE

FV

LV

222 00-FE-222 Unset Unset

222 00-FV-222 Unset Unset

119 00-LV-119 Unset Unset

After changing the values the fields will be highlighted. Save the values by clicking the Save button in the menu.


165

www.aveva.com


9.6

Data Compare and Updates

Open AVEVA Instrumentation application by navigating to Start > All Programs > AVEVA > Engineer > AVEVA Instrumentation 12.1.4 > Instrumentation Engin eer 12.1.4

Open the AIDEMO_ENGG_A IS project Open the Instruments tab by browsing Home > Select > Loads

The Instruments grid is then displayed. On the Manage tab, in the Service Integration group, select AVEV A Eng in eeri ng from the Products options list.



166

www.aveva.com


This opens the Select an A VEVA Engineering Project window


Connect

On the Manage tab, in the Servic e Integration group, select AENGG01 from the Groups options list.

Select Import Data

Click the Yes button in the confirmation window.

The Integration operation will then take place. The values of the mapped attributes of a source (AVEVA Engineering) item will be compared with the attributes values of any existing and matched corresponding destination (AVEVA Instrumentation) item.


167

www.aveva.com




.



168

www.aveva.com


The check boxes can be used to import the data for individual items, the Ac cep t All can be used to import all the items. In the AIENGG01 ( 111 Item s - 1111 Chan ged ) tab select the 00-FE-222, 00-FV-222 and 00-LV-119 instruments and click the Update Database button on the menu




169

www.aveva.com


Click the Close to exit the Update database window and then Close again to exit the Compare/Update form. The Instrumentation grid is now updated with the Instrument Tags, from AVEVA En gi neer in g .


170

www.aveva.com

CHAPTER 10

10

Import process data in AI

A new enhancement is done in Aveva Instrumentation where the user can import the process data (process Equipment and Process Lines) if they are associated with the Instruments in AVEVA Engineering.In previous versions of Aveva Instrumentation process data import functionality was not supported and association was done after the import.

There are some prerequisites to be done before process data can be imported from Aveva Engineering to AI.The user need to create UDET for Process Equipment and process lines and create DBview in Lexicon module so that the UDA’s are available for mapping in the compare Update configuration.

10.2

Process Data Impor t – Lexicon configuration

To demo this functionality APS project is used for importing process data to AVEVA Instrumentation. Browse to Start > All programs > AVEVA > Manage > AVEVA Administration 1.3.0

Enter the login details User – SYSTEM Password – XXXXXX MDB – AL L

Click Lexicon


171

www.aveva.com


In the Dictionary Explorer browse to Dictionary WORL* > Create > UDETWL:User Defined Element World

Name – ProcessData Description – UDET for Process Data Import

Create a UDET ProcessEquipmentTag inside this UDETWL Proc essData In the Dictionary Explorer browse to Dicti onary WORL* > UDETWL Pro cessData > Create > UDET : User Defined Element


172

www.aveva.com


Name – ProcessEquipmentTag Description – ProcessEquipmentTag User-Defin ed Name – ProcessEquipmentTag Base Type - ENGITE

 In the list of UDETS the application displays the text entered in the User-Defined Name field.So it is mandatory to fill this column otherwise this UDET will not be available for the member types – ENGITE


173

www.aveva.com


The user needs to create the following UDAs ClassName TagFormatName Ar eaPath Ar eaNo ProcessEquipment ProcessLines Suffix Function Lnumber PipeSize Spec ServicePL

Right click on the UGRO Co mpareUpdat eUDAS node and create a UDA: User defined attri bute

 For the purpose of demonstration the procedure to create one UDA is explained below. The same procedure can be followed to create the remaining UDAs


174

www.aveva.com


Select the newly created Node UDA1 and in the Current Element Editor insert the values as shown Name: ProcessEquipment Description: ProcessEquipment Ab br evi ati on Len gt h: 3 UDA type: reference (Select from List) Referred Types : ProcessEquipmentTag User-defined Name: ProcessEquipment

The Element types field must have its options selected through the (…) button For integration of AVEVA Instrumentation with AVEVA Engineering, the Process Data and Instrument Tag is being imported. This means the Element types to be selected are :INSTTAG , :LINETAG and :ProcessEquipmentTag


175

www.aveva.com


Upon clicking the (…) button the below screen is presented where the user can add these element types.

In the Filter text box enter :Pro which lists the the :ProcessEquipmentTag in Av ail abl e elem ent ty pes section. Select :ProcessEquipmentTag and click Ad d t o L is t

Similarly in the Filter enter :INST and :INSTTAG will be listed. Select and click Ad d t o L is t

Click on OK button to add the Element t ypes once both have been added.



The hierarchy should have the following form when all UDAs have been added


176

www.aveva.com


Open the Database base View Editor and for view ENG – Instrument Tags ,add the newly created UDAS as shown in below screen.

 The UDAs need to be added to the view,so that it will appear as attributes in the Tag Editor.


177

www.aveva.com


10.3


The process Equipment data and Process Lines dat a should be first imported to AVEVA Instrumentation Process Engineer application. Once the Process Data is imported to project ,the application automatically associates this to Instrument when they are imported from AVEVA Engineering to AVEVA Instrumentation.

10.3.1

Impor t Process Equipm ent Data to AVEVA Inst rum entatio n Project

Start AVEVA Instrumentation Process Engineer module by browsing to Start > All pr ograms > AVEVA > Engineer > AVEVA Instru mentation 12.1.4 > Instru mentation Pro cess Engin eer 12.1.SP4



178

www.aveva.com



Process Data Import Process Data Import Process Data Import Local AVEVA So lu ti on s L td TM6501-02 C:\Program Files (x86)\AVEVA\Electrical12.1.3\Projects\Process Data Import Process Data Import




179

www.aveva.com






180

www.aveva.com




Login to the project after the source has been selected with the Login button The Select an AVEVA Engineering Project dialog is then displayed for the selected data source.


Once the login is completed, the Select Act ion section of the form will be enabled. It is used to create, edit and delete configurations.


181

www.aveva.com


(Step 1 of 5): Choose mode of o peration




182

www.aveva.com



Source: The source data is the data that will be the basis of the comparison. In this case make sure AVEVA Engineering is selected Configuration Name : This will be the name the configuration will be identified as. Enter PROCESSEQUIP for this field. Group : This will be the group the configuration will be created in. Enter PROCESSEQUIP for this field. Object Type Mapping : This will be the element type that the configuration utilises. In this case select ProcessEquipmentTag .

Name Attribu te : This will be the selected element type that is utilised to find possible matches between the source Oracle items, and target AVEVA Instrumentations items. Select the NAME option Unique Attribute : This will be the attribute that serves as the unique key attribute of source items. Select the REF option



183

www.aveva.com



This step provides the option to choose target data in the selected AVEVA Electrical database. Target data is compared against source data. In the Object Type list,Choose Process Equipment as Destination Element Type since this configuration is being created for importing Process Equipment Data from Engineering to AVEVA Instrumentation.

Object Type: This will be the type of object in the Destination database. Select Process Equipment for this option Name Attribu te: This will be the objected type utilised to find attribute matches in AVEVA Electrical items. Select TagNo for this option. Unique Attribute: This will serve as the unique key attribute of the destination items. Select OnjectID for this option.





184

www.aveva.com


(Step 4 of 5): Define Source Filter(s) Add Fi lt er : Retain the default blank entries. This allows for the definition of criteria which limit the population of source data that will be used in the comparison. Delete Filter : This button deletes any set filter.



Attributes of the source element types can now be mapped to those of the corresponding target element types. Attribute selection and mapping indicates the attribute values to be obtained and/or compared against. Basic mappings for the import facility between AVEVA Instrumentation and AVEVA Engineering can be setup as illustrated below. Click on the Add m app in g button to display a new mapping row. Mapped attributes can be selected and then deleted with the Delete Mapping button. Select a Oracle DB (Source) attribute from the pull-down list, then select a corresponding AVEVA Electrical (Destinatio n) attribute from its available list to map it to. Using the table below as a guide, map the following fields: AVEV A En gi neer in g (So ur ce)


AreaNo

Ar eaNo

AreaPath

Ar eaPath

ClassName

ClassName

TagFormatName

TagFormatName

NAME

TagNo

Suffix

Suffix

FUNCTION

Type

LNUMBER

Number


185

www.aveva.com





186

www.aveva.com


10.3.2

Impor t Process Line Data to AVEVA Inst rum entatio n Project

As Explained in Section 9.2.1 , the same import configuration needs to be done to import Process Lines data to AVEVA Instrumentation Process Engineer. Browse to Project > Setup > AVEVA Integration Services > Import Config uration




187

www.aveva.com







188

www.aveva.com






189

www.aveva.com



Source: The source data is the data that will be the basis of the comparison. In this case make sure AVEVA Engineering is selected Configuration Name : This will be the name the configuration will be identified as. Enter PROCESSLINES for this field. Group : This will be the group the configuration will be created in. Enter PROCESSLINES for this field. Object Type Mapping : This will be the element type that the configuration utilises. In this case select LINETAG .

Name Attribu te : This will be the selected e lement type that is utilised to f ind possible matches between the source Oracle items, and target AVEVA Instrumentations items. Select the NAME option Unique Attribute : This will be the attribute that serves as the unique key attribute of source items. Select the REF option



190

www.aveva.com



This step provides the option to choose target data in the selected AVEVA Electrical database. Target data is compared against source data. In the Object Type list,Choose ProcessLines as Destination Element Type since this configuration is being created for importing Process Line Data from Engineering to AVEVA Instrumentation.

Object Type: This will be the type of object in the Destination database. Select ProcessLines for this option Name Attribu te: This will be the objected type utilised to find attribute matches in AVEVA Electrical items. Select TagNo for this option. Unique Attribute: This will serve as the unique key attribute of the destination items. Select ObjectID for this option. Insert Option: This will allow for the creation of new items in the target database, if source items do not find a matching target item after comparison.




191

www.aveva.com


(Step 4 of 5): Define Source Filter(s) Add Fi lt er : Retain the default blank entries. This allows for the definition of criteria which limit the population of source data that will be used in the comparison.




Attributes of the source element types can now be mapped to those of the corresponding target element types. Attribute selection and mapping indicates the attribute values to be obtained and/or compared against. Basic mappings for the import facility between AVEVA Instrumentation and AVEVA Engineering can be setup as illustrated below. Click on the Add m app in g button to display a new mapping row. Mapped attributes can be selected and then deleted with the Delete Mapping button. Select AVEVA Engineering (Source) attribute from the pull-down list, then select a corresponding AVEV A Electrical (Destinatio n) attribute from its available list to map it to.


192

www.aveva.com


Using the table below as a guide, map the following fields: AVEV A En gi neer in g (So ur ce)


AreaNo

Ar eaNo

AreaPath

Ar eaPath

ClassName

ClassName

TagFormatName

TagFormatName

NAME

TagNo

ServicePL

Service

Spec

Spec

PipeSize

Size

Suffix

Suffix

LNumber

Number

In the AVEVA Electrical column; AreaNo, Equ ip men tNo, Clas sNam e, TagFor mat Name, AreaPath , and EqType are the mandatory fields and must be mapped by the user. The window should have the following form when the attributes have been mapped.



193

www.aveva.com


10.3.3

Impor t Process Line Data to AVEVA Inst rum entatio n Project

In this section , create an import configuration for Instrument tag fr om Engineering to AVEVA Instrumentation. The first two configuration will import process data to the AVEVA Instrumentation project and the configuration created in this section will automatically assign the process data to the Instrument. This configuration should be created in the AVEVA In st ru men tat io n En gi neer mo du le . Start > All programs > AVEVA > Engineer > AVEVA Electrical 12.1.4 > Electrical Instrumentation 12.1.SP4

Browse to Project > Setup > AVEVA Integration Services > Import Config uration




194

www.aveva.com


 This opens the Service Import Configuration Settings window. Select the source AVEV A En gi neer in g from the Select Sourc e list.





195

www.aveva.com






196

www.aveva.com


(Step 2 of 5): Source Object Type Source: The source data is the data that will be the basis of the comparison. In this case make sure AVEVA Engineering is selected Configuration Name : This will be the name the configuration will be identified as. Enter INSTTAG for this field. Group : This will be the group the configuration will be created in. Enter INSTSTAG for this field. Object Type Mapping : This will be the element type that the configuration utilises. In this case select INSTTAG.

Name Attribu te : This will be the selected element type that is utilised to find possible matches between the source Oracle items, and target AVEVA Instrumentations items. Select the NAME option Unique Attribute : This will be the attribute that serves as the unique key attribute of source items. Select the REF option



197

www.aveva.com



This step provides the option to choose target data in the selected AVEVA Electrical database. Target data is compared against source data. Object Type: This will be the type of object in the Destination database. Select Instrument for this option Name Attribu te: This will be the objected type utilised to find attribute matches in AVEVA Electrical items. Select TagNo for this option. Unique Attribute: This will serve as the unique key attribute of the destination items. Select InstKEY for this option. Insert Option: This will allow for the creation of new items in the target database, if source items do not find a matching target item after comparison.




198

www.aveva.com



Ad d Fi lt er : Retain the default blank entries. This allows for the definition of criteria which limit the population of source data that will be used in the comparison.




Attributes of the source element types can now be mapped to those of the corresponding target element types. Attribute selection and mapping indicates the attribute values to be obtained and/or compared against. Basic mappings for the import facility between AVEVA Instrumentation and AVEVA Engineering can be setup as illustrated below. Click on the Add m app in g button to display a new mapping row. Mapped attributes can be selected and then deleted with the Delete Mapping button. Select a AVEV A Eng in eeri ng (Sou rc e) attribute from the pull-down list, then select a corresponding AVEV A In st ru men tat io n (Destin ati on ) attribute from its available list to map it to.


199

www.aveva.com


Using the table below as a guide, map the following fields: AVEV A En gi neer in g (So ur ce)


AreaNo

Ar eaNo

AreaPath

Ar eaPath

ClassName

ClassName

NAME

TagNo

ProcessEquipment

ProcessEquipment

ProcessLines

ProcessLines

Suffix

Suffix

Function

ISAFunction

LNumber

Number

TagFormatName

TagFormatName

In the AVEVA Electrical column; AreaNo, Equ ip men tNo, Clas sNam e, TagFor mat Name, AreaPath , and EqType are the mandatory fields and must be mapped by the user. The window should have the following form when the attributes have been mapped.



200

www.aveva.com


10.4

AVEVA Engin eerin g Process Data Setup

This section explains the process data setup in AVEVA Engineering and associating them to Instrument.Once the process data is associated with the Instrument,using import mapping created in previous sections, the instrument along with the Process Data can be imported to AVEVA Instrumentation. Open AVEVA Engineering APS project. Start > All programs > AVEVA > Engineer > AVEVA Engineering 14.1.1

Log in to the AVEVA Engineering using the following credentials User: SYSTEM Password: XXXXXX MDB: ALL

Click on Tags.

Browse to the Admi n Tab and click on Explore to display the Explorer window. In the APS project a new ProcessEquipmentTags world should be created to store the Process Equipment data


201

www.aveva.com


Engineering Worl* > ENGWRL World: World fo r Engineering data

Enter processEquipmentTagsWorld in the NAME field of newly created ENGWLD

Click on processEquipmentTagsWorld and from the right click menu select Group Level

ENGGRP: Engineering

Enter ProcessEquipmentTags in the NAME field of newly created ENGGRP


202

www.aveva.com


The following hierarchy will be created in the Explorer window

Create a ProcessEquipmentTag item as shown below


203

www.aveva.com


For the newly created processEquipmentTag,enter the details as shown below


204

www.aveva.com


Similarly create 2 more ProcessEquipmentTag items and enter the values as per the table be low

NAME

01-P-4001A

01-H-3001A

01-P-2001A

Lnumber

4001

3001

2001

Function

P

H

P

Suffix

A

A

A

Process Equipment

unset

unset

unset

ClassName

EQU

EQU

EQU

TagFormatName

Equip Tag with Area (delimeters)

AreaPath

unset

unset

unset

AreaNo

01

01

01

Once the Process Equipment data is created ,create Process Lines data in AVEVA Engineering . To create Process Lines data browse to Engineering Wor l* > ENGWLD LineTagsWorld

In the ENGWLD LineTagsWorld select 3 line Tags and assign the values as per the table shown below


205

www.aveva.com


AreaNo

01

01

01

AreaPath

unset

unset

unset

ClassName

PMA

PMA

PMA

DESC

Stabilizer Bottoms

Stabilizer Bottoms

Reboiler Feed

Lnumber

L444

L555

L333

NAME

30-L444-WC-L1C2-S1

250-L555-WC-L1C2-S1

200-L333-WC-L1C2-S1

PipeSize

30

250

200

ProcessEquipment

unset

unset

unset

ProcessLines

unset

unset

unset

ServicePL

WC

WC

WC

Spec

L1C2

L1C2

L1C2

Suffix

S1

S1

S1

TagFormatName

Line Tag with Spec (delimeters)

Browse to Engineering WORL* > ENGWLD InstrumentTagsWorld > ENGGRP InstrumentTags.


206

www.aveva.com


Select the 3 instruments PT-109, FCV-114, and FE-117 Enter the values as per the table below

AreaNo

01

01

01

AreaPath

unset

unset

unset

ClassName

INS

INS

INS

Function

PT

FCV

FE

Lnumber

109

114

117

NAME

PT-109

FCV-114

FE-117

TagFormatName

10.5

ISA (delimiters)

Associ ating Process Data to Instruments in AVEVA Engineering

In the earlier sections,process Equipment data as well as Process Line data has been configured in AVEVA Engineering application.This data should be associated with the Instruments. In the AVEVA Engineering application browse to Home Tab.In the List and Schedules section select Instrumentation and Instruments as shown Click the Open button to list the Instruments

The Equipment process data and Process Lines data can be associated by clicking on […] in the ProcessEquipment and ProcessLines column

Click on […]


207

www.aveva.com


The reference browser screen is displayed which lists the ProcessEquipment data created in AVEVA Engineering.

Select :ProcessEquipmentTag 01-P-4001A and Click OK The data is associated with Instrument PT-109 as shown in below screen.

Similarly Process Lines data can also be associated with the Instrument.


208

www.aveva.com


10.6

Data Comp are and Updates

10.6.1

Impor t of Process Equipm ent Data

Open AVEVA Instrumentation application by navigating to Start > All Programs > AVEVA > Engineer > AVEVA Instrumentation 12.1.4 > Instru mentation Process Engin eer 12.1.4

Open the Process Data Import project Open the ProcessEquipment tab by browsing Home > Select > Process Equipment

The Process Equipment grid is then displayed. On the Manage tab, in the Service Integration group, select AVEV A Eng in eeri ng from the Products options list.



209

www.aveva.com


This opens the Select an A VEVA Engineering Project window


Connect

On the Manage tab, in the Service Integration group, select PROCESSEQUIP from the Groups options list.

Select Import Data




210

www.aveva.com


The list of Process Equipment data available are displayed on the Compare/Update window.


.


The check boxes can be used to import the data for individual items, the Ac cep t All can be used to import all the items. In the PROCESSEQUIP ( 3 Items - 3 Changed ) tab Check Accept All and click the Update Database button on the menu



211

www.aveva.com



Click the Close to exit the Update database window and then Close again to exit the Compare/Update form.

The Instrumentation grid is now updated with the Process Equipment data from AVEVA En gi neer in g .


212

www.aveva.com


10.6.2

Impor t of Process Lin es Data

Open AVEVA Instrumentation application by navigating to Start > All Programs > AVEVA > Engineer > AVEVA Instrumentation 12.1.4 > Instru mentation Process Engin eer 12.1.4

Open the Process Data Import project Open the Process Lines tab by browsing Home > Select > Process L ines

The Process Lines grid is then displayed. On the Manage tab, in the Service Integration group, select AVEV A Eng in eeri ng from the Products options list.


213

www.aveva.com



This opens the Select an A VEVA Engineering Project window Enter the following Password: XXXXXX Click the button.

Connect

On the Manage tab, in the Service Integration group, select PROCESSLINES from the Groups options list.

Select Import Data



214

www.aveva.com



The list of Process Equipment data available are displayed on the Compare/Update window. Clicking the At tr ib ut e Detai ls tab displays the mapped attributes for the items

.

The background colours of the rows in the Compare/Update grids indicate the status of the data according to chapter 2.6.


215

www.aveva.com


The check boxes can be used to import the data for individual items, the Ac cep t All can be used to import all the items. In the PROCESSLINES ( 17 Items - 17 Changed ) tab select 30-L444-WC-L1C2-S1, 250-L555-WC-L1C2S1,200-L333-WC-L1C2-S1 and click the Update Database button on the menu An Update database window is displayed, in which the number of Items analysed and the required action in AVEVA Electrical is indicated.




216

www.aveva.com


The Instrumentation grid is now updated with the Process Lines data from AVEVA En gi neer in g .

10.6.3

Import of Instrument data along wit h associated process data

Open AVEV A In st ru men tat io n En gi neer application by navigating to Start > All Programs > AVEVA > Engineer > AVEVA Instrumentation 12.1.4 > Instrumentation Engin eer 12.1.4

Open the Process Data Import project Open the Instruments tab by browsing Home > Select > Instrum ents


217

www.aveva.com


The Instruments grid is then displayed. On the Manage tab, in the Service Integration group, select AVEV A Eng in eeri ng from the Products options list.


This opens the Select an A VEVA Engineering Project window Enter the following Password: XXXXXX Click the button.

Connect

On the Manage tab, in the Servic e Integration group, select INSTTAG from the Groups options list.

Select Import Data



218

www.aveva.com


The Integration operation will then take place. The values of the mapped attributes of a source (AVEVA Engineering) item will be compared with the a ttributes values of any existing and matched corresponding destination (AVEVA Instrumentation) item.

The list of Instruments available are displa yed on the Compare/Update window. Clicking the At tr ib ut e Detai ls tab displays the mapped attributes for the items

.

The background colours of the rows in the Compare/Update grids indicate the status of the data according to chapter 2.6. The check boxes can be used to import the data for individual items, the Ac cep t All can be used to import all the items. In the INSTTAG ( 62 Items - 62 Changed ) tab select PT-109, FCV-114 and FE-117 and click the Update Database button on the menu Copyright © 2014. AVEVA Solutions Limited and its subsidiaries. All rights reserved.

219

www.aveva.com






220

www.aveva.com


As shown in below screen shots, the Instrument PT-109 are imported along with the associated Process Equipment and Process Lines data


221

www.aveva.com




222

www.aveva.com

CHAPTER 11

11

AVEVA Cable Design Data Interf ace

The design lengths of cables in AVEVA Cable Design can be compared with the lengths of cables recorded in Wiring Manager. This is done through importing the lengths from AVEVA Cable design. The design lengths can be used to update the estimate lengths of cables as required.

11.2

Create a Train ing Proj ect - TRA in E3D 2.1

For the purposes of this integration the user should be using the AVEVA Everything3D – Training setup 2.1 which can be downloaded from the AVEVA Int ern al Sup po rt Sit e Training Collateral > Plant Training Collateral . The zipped version of the project “TM-1800 AVEVA Plant Everything3D Training Setup Data *.*.zip”, should be downloaded and saved locally. To install the AVEVA E3D™ Training Setup, navigate to the directory C:\AVEVA\Plant directory and unzip the training setup macros from the training setup zip file. This will create the following folders and sub folders under the directory: C:\AVEVA\Plant\PlantTraining2.1\Training

Admin Global mdspmllib pmllib pmlui Project_Data Project_Macros Reports testencrypt userdata

-

Example Batch used during Admin Training Example Global batch Files Example macros used during MDS Admin Training Additions / updates to the PML 2 Forms, Menus and Macros Additions / updates to the PML 1 Forms, Menus and Macros Reconfigure files used to populate the project Example Macros used during HVAC Admin Training Example Reports used Lexicon Training Simple Macros used during PML Publisher Training in Admin Training Example data files (Excel Spreadsheet)

Add the following lines to the bottom of the custom_evars.bat file located in the Project directory typically C:\Users\Public\Documents\AVEVA\Projects. Make sure to leave a blank line at the bottom of the file.

set pmllib=C:\AVEVA\Plant\E3DTraining\Training\pmllib;%pmllib% set pmlui=C:\AVEVA\Plant\E3DTraining\Training\pmlui;%pmlui%

 For each training course it is recommended that a New Training project is created using the Project Creation Wizard. However, the Training Setup utility may also be used on an existing Training project. It is also advised that the customers do not run the Training Setup on the AVEVA supplied sample projects such as APS, ACP, etc.


223

www.aveva.com


Enter the newly created Project via the AVEVA Administration shortcut: Start > All Programs > AVEVA> Manage Manage > AVEVA AVEVA Admini stration

Type in with following credentials to open the Project - Training User - SYSTEM Password- XXXXXX

Click the Ad Admi mi n button.

From the home page select Utilities > Training Setup … to display the Training Setup form.


224

www.aveva.com


Set the Number of Designers .to 2 When the number of designers has been provided, the Create Project Data button in the form will be enabled. Before clicking this button make sure the Command Window is displayed:

From the main menu, select Display > Command Window . Click the Create Proj Proj ect Data button. A progress bar is displayed, along with text in the command window.

Once the setup has been run on the project in Administration individual courses can be set up in the constructor modules (Model, Draw, etc). A Training set up button will be displayed in the Tools tab. Course set up information is displayed in the respective tab relating to the discipline being considered. Check the Setup Se tup Training Cour se checkbox then the Ap Appl pl y button to set up each course.

Once the setup is completed,the application gives a confirmation that the setup is completed successfully


225

www.aveva.com


11.3 11. 3

Catalog Ca talog ue conf igu ratio n in Paragon 2.1

The Cable catalogue details from AVEVA Elec tr ic al can be placed in a catalogue database named PPROJECT/CATA and a properties database named PPROJECT/PROP PPROJECT/PROP.. The user needs to create the above databases from AVEVA Ad mi n is tr ati on 1.4.0 with READ/WRITE access. The step by step procedure to create these new databases are explained below. Login to Av eva Ad mi ni st rat io n 1.4.0 by browsing to Start > All Programs > AVEVA> Manage > AVEVA Administrator 1.4.0

Select the TRA project and login using User – SYSTEM Password – XXXXXX MDB – ALL

None value value can be selected but this is not mandatory  For the STAMP field the None

Select the Admin module by clicking the Ad Admi mi n button.

 The Configurations related related to TEAMS , Users, databases ,MDB’s can be created from the Admin Module

Login to the AVEVA AVEV A A dm in is tr ati on module for the TRA project The AVEVA AVEV A Ad mi ni st rat io n application opens with the Ad mi n Exp lo rer and a section to configure the Teams/Databases etc as shown below.


226

www.aveva.com


In the TYPE section select Teams and click the Create button.

In the Create Team screen, enter the following details Name – Name – PPROJECT Description - PLANT Project Project f or Integration

In this example we are using SYSTEM user login; choose SYSTEM from the Project Users and click on the down button as shown above.


227

www.aveva.com



228

www.aveva.com


The SYSTEM user will be added in the Team Members section. Click on the Ap Appl pl y button. This will add a Team PPROJECT in the system. Close this window through clicking the Cancel button After creating the TEAM the user needs to create databases CATA and PROP. To do this choose Databases & Extracts in the TYPE section and click Create

In the new Databases & Extracts create screen, choose Master DB and click OK


229

www.aveva.com


The below Create Database screen appears where the database Name, Team and DB Type (database type) should be specified. Select PPROJECT as the Owning Team and key-in the details as below Name – CATA Description – Catalogue Db for Cable Integration Database Type – Catalogue Element Type – Catalogue Ac ces s Mo de – Multiwrite

Click Ap pl y and then OK


230

www.aveva.com


Similarly we need to create a PROP database as shown below; In Databases & Extracts in the TYPE section select Create In the new Databases & Extracts create screen, choose Master DB and click OK

Select PPROJECT as the Owning Team and key-in the details as shown Owning Team – PPROJECT Name – PROP Description – Properties Db for Cable Integration Database Type – Properties Element Type – Component World Ac ces s Mode – Multiwrite

Click Appl y and then OK

After making the above changes, click on Save Work to save the changes.

The application asks for a confirmation message .Click on Yes and the changes are saved.


231

www.aveva.com


Once the databases are created the MDBs needs to be added in the ALL MDB which is used for this exercise. Select MDBs in the TYPE section and select ALL database, then click on the Modify button.

In the Modify Multiple d atabase window choose the newly created databases from the list and click on the down arrow button as shown in the screen shot.

Click Appl y once the newly created databases have been added below. Copyright © 2014. AVEVA Solutions Limited and its subsidiaries. All rights reserved.

232

www.aveva.com


11.4 11. 4

Confi gur ing READ READ/WR /WRIT ITE E permi ssi ons to databases

For Importing cable data into E3D, the user SYSTEM must be given Read/Write access to the following database:

 E3D will give a message if there is only READ permissions which is the default option. MASTER/CABLECATA MASTER/CABLEPROP MASTER/DICT MASTER/PROP MDS/PROP

These are foreign databases which are read-only by default. The method to change the access-mode of these databases to read-write permission consists of three steps. 1. Exclude the databases 2. Copy them to the present project 3. Add the databases to ALL MDB

11.4.1 11. 4.1

Exclu de the Databa Databases ses in Admi nis trati on

The first step is to exclude the above list of databases from the list.This configuration needs to be done in AVEV A A dm in is tr ati on . Login to AVEVA AVEV A A dm in is tr ati on 1.4.0 Start > All p rograms > AVEVA > Manage Manage > AVEVA AVEVA Admi nist ration 1.4.0 1.4.0 Enter the user credentials as below User – – SYSTEM Password – Password – XXXXXX MDB – MDB – ALL is not Stamp mandatory.


233

www.aveva.com


Select Data Databases bases & Extracts in the TYPE column, then filter records according to Team – MASTER and DBType – DBType – MASTER

In the list, select any database and click the Exclude button.

Once the Exclude button is clicked, the Exclude Foreign Databases Databases window will appear where the user can multi select all the required databases to be exclude from the project.

Select the following databases and then click the Exclude button MASTER/CABLECATA MASTER/CABLEPROP MASTER/DICT MASTER/PROP MDS/PROP

Exclude all the databases one by one by clicking Yes.


234

www.aveva.com


11.4.2 11. 4.2

Copy the databases to the present proj ect

Once the Foreign Databases are excluded, the user needs to copy them back to the current project locally. Select Da Databases tabases & Extracts in the TYPE section and click on the Copy Foreign button.


235

www.aveva.com


The user is presented with Copy Foreign Database screen shown below where the databases can be made READ/WRITE. In this example PROJACP is the Foreign Project from where the databases required in MASTER are copied. In the below screen select PROJACP as the Foreign Projects . In the Ac ces s Pro jec t as section provide the Username /Password by which the user is going to access the present project. SYSTEM and and Password – USERNAME – USERNAME – SYSTEM Password – XXXXXX Select MASTER/CABLECATA from the Foreign Databases list Target Database Names will be automatically configured and click the Ap Appl pl y button

In the above method the user needs to do the same operation for the remaining databases individually, MASTER/CABLEPROP , MASTER/DICT, MASTER/PROP, MDS/PROP


236

www.aveva.com


After successfully copying co pying the foreign databases, they will be listed in the explorer in bold, as they are not saved

Do a savework The newly created databases are saved in the current project as LOCAL.


237

www.aveva.com


11.4.3 11. 4.3

Add th e databases to ALL MDB

Although the databases are added to the current project, they are not added to the MDB used (in this example ALL). This will mean that they will not be available when the user logs in to the current project using that MDB

To add the databases to the MDB: Choose MDBs in the TYPE section, select AL ALL L (the MDB the user is using) and click on the Modify button.


238

www.aveva.com


Again, select the following databases and then click on the down arrow, followed by Appl y as indicated below. MASTER/CABLECATA MASTER/CABLEPROP MASTER/DICT MASTER/PROP MDS/PROP

This will copy all the selected databases to the below list. Once it has completed click the Appl y button.


239

www.aveva.com


After a successful copy, the databases are listed in under MDB ALL in the explorer.

After all the operations are completed click on Save Work to save the changes


240

www.aveva.com


11.5

Integr ation UDA defin iti on database references.

To import Cable catalogue/Equipment and Cable details from AVEVA Electrical, UDAs must be defined in LEXICON. This will allow the matching process to use them for storing source database references. The UDAs may be created in any UGROUP in a current dictionary database. If used in conjunction with the specific module, it is suggested to include these UDAs in the same group. The Integration UDAs should be created as Indexed UDAs with the following details: UDA Name(s) UDA Type UDA Lengt h Element Types

pmg-design-ai

text

50

pmg-design-ae

text

50

pmg-cata-ai

text

50

pmg-cata-ae

CABLE EQUIPMENT INSTRUMENT SUBEQUIPMENT

CABLE EQUIPMENT

TABITEM GPART CABDATA SCOMPONENT CCORSET CABCORE TABQUESTION

 For the purpose of demonstration screen shots are shown for adding one of the UDA – pmg-design-ae is shown, but the user need to do the same procedure for all the four UDA’s.

The above UDAs need to be added in LEXICON module. This is explained below.


241

www.aveva.com


To open Lexicon module browse to Start > All Programs > AVEVA > Manage > AVEVA Administration 1.4.0

Choose the TRA project and for the credentials provide

Username – SYSTEM Password – XXXXXX MDB – ALL

Click on the Lexicon button on the below screen.


242

www.aveva.com


In the LEXICON module, the user should create the required UDAs for Integration in a hierarchical order. UDAWORLD >> UDAGROUP >> UDA In this example the order is created as shown below Dictionary WORL* UWRL PMGSchematicUdas UGRO PMGUdaGroup All UDA’s To create the UDA World , right click on Dictionary world and choose UWRLD: User defined Attribute World

Enter the name PMGSchematicUdas in the Name field as indicated in the screenshot


243

www.aveva.com


To create a UDA Group; right click on the PMGSchematicUdas node and choose UGROUP: User defin ed attribute group as shown below.

Enter the name PMGUdaGroup in the Name field as indicated in the screenshot

To create the required UDAs in the PMGUdaGroup , right click on it and select UDA: User Defined At tr ib ut e.


244

www.aveva.com


Create the 4 UDAs with the following specifications as previously mentioned. UDA Name(s)

pmg-design-ai

pmg-design-ae

pmg-cata-ai

UDA Type text

text

text

UDA Length

Element Types

50

CABLE EQUIPMENT INSTRUMENT SUBEQUIPMENT

50

50

pmg-cata-ae

CABLE EQUIPMENT

TABITEM GPART CABDATA SCOMPONENT CCORSET CABCORE TABQUESTION

Below is an example for adding the first UDA; pmg-design-ai

Name – PMGdesignai Ab br evi ati on len gt h – 11 Uda length – 50 Uda type – Text Uda length – 50 User-defined name – Pmg-design-ai


245

www.aveva.com


For Adding Element types , click on the [ … ] button at the end of the Element types line.

The Select Element Types window will be displayed as shown below. In the Av ail abl e elemen t t ypes filter, enter in the required element and then select Add t o l is t . Add the following elements to the list Element Types: CABLE EQUIPMENT INSTRUMENT SUBEQUIPMENT

Continue to add the 3 other UDAs pmg-design-ae and pmg-cata-ai, pmg-cata-ae


246

www.aveva.com


When the 4 UDAs have been created the explorer should have the following form.


247

www.aveva.com


The next step is to create place holders in the catalogue application to import the cable data from AVEVA Electrical or AVEVA Instrumentation. This configuration is to be done in the AVEVA Cat alo gu e Application. Start > All p rog rams > AVEVA > Manage > AVEVA Catalogue 2.1

Provide details

the

following

Project - TRA Username – SYSTEM Password – XXXXXX MDB – ALL

Click on Paragon


248

www.aveva.com


In the Paragon application the user needs to add a hierarchical structure to save the cable catalogue data from AVEVA Electrical/Instrumentation. By default when paragon is opened the GENERAL view will be displayed. This should be changed to ELECTRICAL

As a first step we need to create a catalog in the project to bring the AVEVA Cable Catalogue to the E3D project.

In this example the catalogue is being created in the PPROJECT/CATA . Select this MDB and click on the Catalogue button in the ribbon Menu.


249

www.aveva.com


The Create Catalogue window is appeared where the user needs to key in the following Name - /CATA/ELEC Purpose – CORE

Click OK to confirm

 By default CORE will not be one of the options in the Purpose drop down menu.

Underneath this cata we need a Section element. So select the CATA/ELEC node in the explorer and click on the Section button in ribbon menu

The Create Section windows will automatically populate with Name and Purpose. For the demo we can continue with this information entered.

Click OK to confirm

The next step is to create a Cores Category underneath the section created.

Select the CATA/ELEC.SECT node in the explorer and click on Cores Category button in ribbon menu.

Here also continue with the automatically populated Name and Purpose by clicking OK .

Upon clicking OK in the above screen a new window Model View:CATA/ELEC.SECT.CATE will display (shown below). There is no need to perform any changes in this screen and the user can close the window.


250

www.aveva.com


The following hierearchy should be created in the Catalogue Explo rer window.

For this demo only TEXT CATA/ELEC.SECT.CATE-PA1 is needed, delete PTSE 1, CCORSE 1, SCOM 1 from the explorer by selecting, right clicking and then choosing Delete.


251

www.aveva.com


The application asks for confirmation while deleting. Click on OK button all the three nodes.

Do Save Work to save the changes.

The next step is to create a Part World which can be created by clicking the Part Worl d button in the ribbon menu

The Part Worl d should be created from the main node PPROJECT/CATA Enter the following details Name – ELECPTWL Purpose – CORE


252

www.aveva.com


Next, create a Part Family by clicking the Part Family button The name and purpose will be automatically populated according to the name provide for part World.

Upon clicking OK in the above screen a new window Part Family: /ELECPTWL.PRTELE will display (shown below). There is no need to perform any changes in this screen and the user can close the window.


253

www.aveva.com


The application needs a place holder for the Cable specification data. This is done by creating the Specification World data in the application. To create the specification go to the SPECIFICATION Tab

Selecting the PPROJECT/CATA node in the explorer and click on Specification World to create a specification for the cable import. Enter the following details Name – ELECSPWL Purpose – CABL

 CABL is not available in the Purpose list, so the user needs to key in this data.

Click on OK to create the Specification.

 This specification is different from Pipe Specification or Equipment Specification

A Selection Table is also needed which can be created by clicking on the Selection Table button in the ribbon menu.

Keep the default Name and change the Purpose to CABL and then click the OK button


254

www.aveva.com


On clicking OK in the previous window, the following form will be displayed.

Add Headings by clicking the Add Head in g link.

Enter Description – NUMBER OF CORES


255

www.aveva.com


Clicking on the Ap pl y button, then gives the opportunity to name the newly created heading.

Provide details as below and then click the Appl y button Name – NOCORES Purpose – CABL

The following hierarchy should be created in the Catalogue Explorer window


256

www.aveva.com


Once the Table Header is created, the user must create Heading Questions which will be the next step. Access the following set of options by clicking the Back button Click on Edit Heading Questions

In the new screen as shown below click on Add Qu est io n as shown below


257

www.aveva.com


Enter the details as shown below and then click Appl y Purpose – NCOR Description – NUMBER OF CORES Question Type – Text Question – NUMBER OF CORES

Add a second question with the following details and then click Appl y Purpose – INSU Description – TYPE OF INSULATION Question Type – Text Question – TYPE OF INSULATION

After these configurations in PPROJECT/CATA the hierarchy shown to the left should be created in the Catalogue Explorer window


258

www.aveva.com


The application also needs a place holder for all the properties of the cable while importing from AVEVA Electrical or AVEVA Instrumentation. For this the user needs to create a component in the Properties Database. In the Property WORL , select the node PPROJECT/PROP DB created earlier and click on the Material Properties menu button


259

www.aveva.com


In the new Properties window for New select CMPW

Upon the selection of CMPW the following attributes will be listed. Enter the Name – PROP/ELEC


260

www.aveva.com


Under New there will now be another entry available named CMPT (for Component). Clicking on CMPT will list the following attributes

Enter the Name –ELEC/CMPT

Save the work by clicking Save Work

All the configurations required for the cable import have now been completed now the user can import cable data from AVEVA Elec tr ic al .


261

www.aveva.com


Open the AVEVA Cat alo g application Start > All Pr ogr ams > AVEVA > Manage > AVEVA Catalog ue 2.1

Enter the following user credentials and then click on Paragon User – SYSTEM Password – XXXXXX MDB – ALL


262

www.aveva.com


On the MANAGE tab, in the Integration group, select Open from the Compare / Update / Link options list

In the new COMPARE/UPDATE tab choose AVEVA Ins tr um ent ati on and Cable Catalogue from the Source Selection list as indicated below.

A Login button in the Source group will be enabled once Cable Catalogue has been selected.

To show all the available projects in the system click the Login Button.

If the following message displays, click Yes

The user should then choose the project containing the cable catalogue to be imported to E3D. Choose the E3D Cable Design project and then click the Select button


263

www.aveva.com


The applications will then check the cable catalogues present in the project and list all of them in the Compare/Update window.

 If the selected project has a large number of cable catalogue, the comparison process will take a long time. To reduce the time it takes the user can apply filters for the import of cable catalogs

 There is no need to create any configurations since the application is designed to list all the catalogues present in the AVEVA Electrical project once the configuration, is selected


264

www.aveva.com


Once Compare has completed all the cable catalogues present in the project will be listed. Choose the required cables catalogues which need to be imported into E3D by checking their tick boxes in the Ac cep t column.


265

www.aveva.com


Choose the place holders as shown in the window. CABDATA – ELEC/CMPT CCORSET – CATA/ELEC.SECT.CATE SCOMPONENT – CATA/ELEC.SECT.CATE GPART – ELECPTWL.PRTELE TABITEM - NOCORES

Click on Update button.

The selected cables will be imported to the E3D 2.1 project.

After the update the Update Catalogue Database window shows the summary of the import. Click Close and the values in the Matched column should show Yes , as shown below.


266

www.aveva.com



267

www.aveva.com


The cable catalogue IPF183AA001 and IEF184AA001 has now been imported to the Catalogue application as shown above.

Click on Save Work to commit the changes

 For training this Instrumentation project is provided as a package. Use the package to create a project named “E3D cable Integration


268

www.aveva.com


11.6

AVEVA E3D Design Import Confi gur ation

Start > All Programs > AVEVA > Design > AVEVA Everything 3D 2.10

Enter the following credentials and then click Model User - SYSTEM Password XXXXXX MDB – ALL


269

www.aveva.com


The E3D application will open with the def ault view. Add, by dragging from the Model Explorer into the middle of the drawing, the following areas, to see the 3D model of the electrical equipment and cables.

  

SITE-CABLE-AREA01, SITE-CABLE-AREA02, SITE-CABLE-AREA03 SITE-ELECTRICAL-AREA01 , SITE-ELECTRICAL-AREA02 , SITE-ELECTRICAL-AREA05 SITE-EQUIPMENT-AREA01, SITE-EQUIPMENT-AREA02, SITE-EQUIPMENT-AREA03

The 3D model should look like the below image after adding the required areas in the model window


270

www.aveva.com


The following steps are still required in AVEVA Everyting 3D, as explained below.  

Import Equipment data Import Cable data

 The cable Catalogue should be imported to AVEVA Catalogue application prior to this import Change the GENERAL discipline to EQUIPMENT from the pull down list.

In the MANAGE tab in the Integration group select the Open option from the Compare / Update / Link button list

In the newly available COMPARE/UPDATE tab in the Source selection group select AVEVA Instrumentation from the first drop down menu and Equipment from the second.

Once the above selections have been completed the login button will become enabled.


271

www.aveva.com


Login to the AVEVA Instrumentation project by c licking Login button

Select the E3D Integration project from the list.

 The user should use AVEVA Instrumentation project supplied along with this training module

In the compare update window all the selected equipment in the AVEVA Instrumentation project is listed. Select the Equipment required to be imported to E3D Design.

In the COMPARE/UPDATE tab in the Configuration group select the Al l Dis pl ayed option from the Ac cept button list

Then click on Update Database in the Destination group


272

www.aveva.com


Click Update in the new window

The following message displayed,Click on ‘ Yes’ .

window

is

The following Equipment and Cables are imported to E3D

Cable No

From

To

CatalogueNo

CBLC-PMP-7

ST-002

PMP-7/CONTROL

IPF183AA001

CBLP-PMP-9

MCC-1A

PMP-9/POWER

IEF184AA001

In this example we are using the equipment which are already present in the E3D Design as the cables are already routed and cable length should be imported from the E3D to AVEVA Electrical and AVEVA Instrumentation.So when the user try to import Equipment from the AVEVA Electrical project they will all be matched.


273

www.aveva.com


11.7

Impor t of cables to E3D 2.1

The next step is to import the cables from the AVEVA Instrumentation application to E3D. This is similar to importing the equipment.

So prior to import the cables the configuration need to be edited so that CBSTA and RANEQUIP values are imported to E3D from AVEVA Instrumentation. To add these values in mapping fields, in the COMPARE/UPDATE tab in the Configuration group click on the Options.

In the Options screen Click Manage

In the Manage Configurations & Groups screen , the Source Databases lists all the Configurations created for the project.Browse to AVEVA In st ru men tati on > Cabl e.In right Click menu choose Edit


274

www.aveva.com


The applications gives a message as shown in left.Click OK

The Compare/Update Configu ration Wizard screen is displayed.Click on Login button

Select the AVEVA Instrumentation project from the list in the Select an AVEVA Instrumentation Project

Click Select


275

www.aveva.com


The Type , Name Attribute, Unique Attribute fields will be populated with the values and in disabled state

Click Next buttons in all the consecutive screens and in Step 7 of 7 : Define Attribute Mappings screen,add two mappings by clicking Ad d Map pi ng Button.

AVEVA Electrical Attribute

Design Attribute

Routing Status

CBSTA

2000mm

RANEEQUIP

 The other four mapping fields are already present and should not be removed.

Click Finish Copyright © 2014. AVEVA Solutions Limited and its subsidiaries. All rights reserved.

276

www.aveva.com


Click Login in Source Selection group

Compare/Update application gives message as shown below.Click OK

After editing the configuration, click on Update database which imports the cables from AI project to E3D. The Update Design database screen shows a summary of the number of cables which are to be imported to E3D design.

Click on the Update button.


277

www.aveva.com


In the below screen the application show the result of Compare/Update operation.

The Compare/Update will list the summary of the Import operation.

The next step is to route the cables in E3D design , and then import them back into the AVEVA Instrumentation project, so that the cable length is imported. Copyright © 2014. AVEVA Solutions Limited and its subsidiaries. All rights reserved.

278

www.aveva.com


Change the EQUIPMENT discipline to CABLING SYSTEM from the pull down list.

On the CABLING SYSTYEM tab, in the Tools group, click the Cable Data button to display the Cabla data form

The cable data form displays all the zones where the cables are present in the E3D project. Select all the zones and click on Load cables for selected zones .

The E3D application will list all of the cables from the selected zone. The next step is to select and route the cables which were imported from AVEVA Instrumentation application.


279

www.aveva.com


The custom filters can be used to select the cables which are required for import into the AVEVA Electrical project Once selected click Route Selected Cable(s)


280

www.aveva.com


The Cables are routed in the AVEVA E3D application. The status has been changed to 1 which is Routed

Do a Savework to commit the changes


281

www.aveva.com


11.8

Import Cable length from AVEVA Instrum entation project

The cables are routed in AVEVA E3D and this data should be imported back into AVEVA Ins tr um ent ati on . Open the AVEVA In st ru ment ati on Wir in g Manag er module.

Select the AVEVA Instrumentation project the user wants to import the cable lengths to.

Select the Home > Select > Cable Schedule

In this project there are only 2cables created for this exercise. Select all the cables with


282

www.aveva.com


On the Manage tab in the Local Integration group, click the AVEVA Cab le Des ig n Im po rt button.

In the AVEVA Cabl e Desi gn Lo gi n window enter the credentials of the E3D Design project as indicated below.

Project – TRA Username – SYSTEM Password – XXXXXX Project MDB - ALL

The application brings the cable data f rom E3D which matches in the AVEVA Electrical application.

Click on the Batch process all button


283

www.aveva.com


The Import cable Length Differences window is displayed with all the cables which is routed in E3D Design application.

Click on the Ac cep t All checkbox and then click on Save. All the cables lengths are updated in AVEVA Instrumentation.


284

www.aveva.com


As shown in the below screen, the cable Free length Route Node List details are imported to AVEVA Instrumentation from AVEVA E3D.


285

www.aveva.com




286

www.aveva.com

CHAPTER 12

12

Publi sh to AVEVA NET

Publish to AVEVA NET Configuration is applicable to four of the modules in the AVEVA Instrumentation product suite: AVEVA Instrumentation Engineer. AVEVA Instrumentation Wiring Manager. AVEVA Instrumentation Designer. AVEVA Instrumentation Process Engineer.

12.2


If the user has no project setup in place then the database backup file TM6107_II01.bak can be extracted to the folder C:\AVEVA_InstrumentationTraining\DatabaseBackUps .

The file TM6107_II01.bak is to be restored onto the users’ instance of MS SQL Server and setup using AVEVA Ins tr um ent ati on Secu ri ty Manag er. Instrumentation Project Administrator/s.

This task will be performed by the users AVEVA

In each user instance, the above database backup is to be restored as TM6101_01_XX, where XX is to represent the respective user’s initials. Navigating to the folder path created for this restored project, C:\AVEVA_InstrumentationTraining\Projects\TM6101_01_XX , replace the application created TM6101_01_XX folder with the backup TM6101_01_XX folder provided by the trainer. This folder contains the final deliverables for the whole set of AVEVA Instrumentation Training guides (TM-6101, TM-6102, TM6103, TM-6104).

Create the following directory structure on the Users C: drive:

C:\AVEVA_NET_PortalStagingArea\AVEVA_Instrumentation\TM6101_01_XX\AVEVA_NET_LogF iles Where XX represents the user’s initials.

 Typically the staging area would be on a network server remote from the users local hard drive, for example: \\ukcamsgsc102\Staging


Areas\Instrumentation\TM6101_01_XX

287

www.aveva.com


12.3

AVEVA NET Expor t Confi gur ation Files

The following configuration files will be used by the AVEVA Schematic Gateway to Process the data exported from AVEVA Instrumentation:    

Project Configuration Attributes Mapping Classes Mapping Presentation Mapping (Drawing and Installation Detail Drawing)

All of these configuration files are of XML format and are best edited in a XML editor, but Notepad or any text editor can also be used. It is recommended for the user to have one configuration file of each type mentioned above per element to be exported to AVEVA NET. All of these files are provided as input to the Gateway.

 For more information on elements and attributes of these configuration files please see the out of the box Common Functio nality User Guide , Chapter B AVEVA NET Export Config uration Files

12.4

AVEVA Inst rum entatio n Engin eer – Publish to AVEVA NET Configuration

Start AVEVA Instrumentation Engineer. Select Home > Select > Instruments / Select Home > Select > Loops . This is for preparation to publish the grids to AVEVA NET. Select Project > Setup > Publish to AVEVA NET Configuratio n .

This will open the Export Configuration form. The default Equipment type is Instruments. To see a list of the available equipment types, select the down arrow to the right of the Name button.


288

www.aveva.com


Name:

This is where the user will select the equipment type to be published by selecting the down arrow and then selecting an item from the list. Logging Options:

If the Log Enabled check box is checked, the Log File: text box becomes available. If the user wishes to create a log file, then the user can use the Select Lo g File button to the right of the text box.

An example is shown in the image above. For the purposes of this training, leave the Log Enabled check box unchecked .


289

www.aveva.com


Staging Options:

The staging area is where the Published files are stored and from where AVEVA NET will import the data. This could be on a network somewhere. For the purposes of this training the folder:

C:\AVEVA_NET_PortalStagingArea\AVEVA_Instrumentation\TM6101_01_XX (where XX represents the user’s initials) that was created earlier is to be used as the staging area.

Using the browse button to the right of the Staging Area text box, browse to the folder

TM6501_01_XX and then select OK . (where XX represents the users initials)

Create Trigger File:

This check box when selected will create a trigger file on the staging area. A trigger file is created so every time a user Publishes data to AVEVA NET, the trigger file will initiate an Import into the AVEVA NET automatically. It is recommended that this box remains unchecked to avoid in inadvertent imports/exports. Output File per Object:

This check box is selected if any object exported, it is required to have a separate output file generated. For the purpose of this training this box should remain unchecked Settings:

Selecting this button opens the Non-CAD Mapping Configu ration form. Selecting the Copy Sample Files will copy sample Configuration file into the Object Mapping and Class Mapping text Boxes.

Selecting the Edit Object Mapping File button


will open the configuration file in Notepad.

290

www.aveva.com


C:\ true Likewise, if the Edit Class Mapping File button is pressed, the configuration file will open in Notepad. Click the OK button and this will return the user to the AVEV A Net Exp or t Co nf ig ur ati on form. Click the Appl y button to apply the settings. Before closing the AVEVA Net Exp or t Con fi gu rat io n form select Loops from the Name pull down pick list and repeat the above. When the user selects Setting > Copy Sample Files


291

www.aveva.com


A message will pop up. This is because a duplicate Class Mapping file is created. Select Yes to Clear the message.

Click the OK button and this will return the user to the AVEV A Net Exp or t Co nf ig ur ati on form. Click the Appl y button to apply the settings. Click the Close button to close the form. The configuration files are stored in the project root folder: C:\AVEVA_InstrumentationTraining\Projects\TM6101_01_XX


292

www.aveva.com


12.5

AVEVA Inst rum entatio n Engin eer – Publis h to AVEVA NET

Once the configuration files are set, the user can then publish the data to AVEVA NET. If the Instruments grid is not open, open it. If the Loops grid is not open, open it. Give the Instruments grid the focus by selecting it. The user can select a single item, or the user can select multiple items. In this worked example, select all of the load items.

On the Manage tab select Publish to AVEVA NET.

A Progress window will appear briefly followed by an Export Report . Select Close to close the form.

Select the Loops grid, select all of the loop items and then select Publish to AVEVA NET on the Manage tab. Publish to AVEVA NET from AVEVA Instrumentation Engineer is now complete and ready to be imported into the AVEVA NET Portal.

Two files have been created and are placed in the staging folder specified earlier.

.


293

www.aveva.com


12.6 AVEVA Inst rum entatio n Wirin g Manager – Publi sh t o AVEVA NET (Worked Example) Using the knowledge gained above and with the help of the below information the user can publish the Cable Schedule and Cable Catalogue s to AVEVA NET.


294

www.aveva.com


12.7

AVEVA Inst rum entatio n Desig ner – Publis h to AVEVA NET

The procedure for publishing the drawings to AVEVA NET is the same as described for AVEVA Instrumentation Engineer above. Select the Drawing grid, select the Manage tab. Select the AJB-101, F-222, FMC-110 and L-114 drawing and then select Publish to AVEVA NET. When completed, an Export Report is generated:

 Only drawings existing in the Projects Drawings folder will be published to AVEVA NET because the configuration setting was only for the drawings. To publish the Hookup Drawings and Reports to AVEVA Net, they should both be configured first as the example above.


295

www.aveva.com


Once published, a set of XML files are created and placed in the Project Drawings folder:

In the staging area, XML files and svg files are created:


296

www.aveva.com

CHAPTER 13

13 13.1

Importin g Data from Oracle using AIS Overview – Workflow

The integration between the AVEVA Instrumentation application and the Oracle Database involves the pulling in of Instrument Loop/Instrument data from Oracle DB. The Instrumentation project ,Oracle Db and Integrations Service server can be in a distributed environment across in a network.

13.2

Oracle Database con fig urati ons

The data stored in Oracle DB server can be imported to AVEVA Electrical using AVEVA Integration Services.For the demo purpose a data stored in an Equipment table is imported to AVEVA Electrical. In this example Oracle SQL Developer is used as front end tool to create table in Oracle Db ,but any similar software can be used. Open the Oracle SQL developer tool and click

 The process of adding new connections will be different for different tools


297

www.aveva.com


Login to the Oracle database server using the credentials Connection Name – UKCAMSVPEDB2 Username – VPE2 Password – VPE2 Hostname – UKCAMSVPEDB2 Port – 1521 SID – VPE2

Click Connect . In the Connections explorer,the Server with all the tables will be listed.


298

www.aveva.com


In the right click context menu Click New Table

In Create Table screen,the user can create required table. Enter the details as below Name – AI_INSTRUMENTS


299

www.aveva.com


The columns can be added by using the add button shown below Add columns NAME ID AREA AREA PATH CLASSNAME TAGFORMATNAME INSTTYPE LNUMBER FUNCTION

Click OK


300

www.aveva.com


In the newly created table the user needs to add the data which needs to be imported to AVEVA Instrumentation project. Select AI_INSTRUMENTS table from the explorer and in right pane navigate to Data as shown highlighted.


301

www.aveva.com


Click on Insert Row button to insert new records.

Insert the records and do a commit to save the changes.


302

www.aveva.com


13.3



In the Av ail abl e Data So ur ces section, for the Data Source Name select Oracle from the list

Click the Add Co nf ig ur ati on button The user is presented with the Select Oracle Database screen. Enter the values as shown below Host – UKCAMSVPEDB2 Port – 1521 SID – VPE2 Username – VPE2 Password – VPE2

Click OK


303

www.aveva.com


The Oracle DB will be added as a new row in Integration Settings Editor screen as shown below

Click on Save button and application gives a message Saved Datasource .Click Yes and then the Exit button on the below screen


304

www.aveva.com


13.4


To use the Compare/Update facility in AVEVA Instrumentation relevant configurations must be set-up, for example attribute mappings between the AVEVA Instrumentation project and the Data source, data filters . These operations can be done in AVEVA Instrumentations Application. These configurations are created and edited using the Import Configuration option: Start AVEVA Instrumentation Engineer application by browsing to Start > All programs > AVEVA > Engineer > AVEVA Instrumentation 12.1.4 > Instrumentation Engin eer 12.1.SP4



305

www.aveva.com



AI-ORA CLE-Int eg AI-ORA CLE-Int eg AI-ORA CLE-Int eg Local AVEVA So lu ti on s L td TM6501-02 C:\AVEVA_Instru mentationTraining \Projects\AI-ORACLE-Integ AI-ORA CLE-Int eg




306

www.aveva.com






307

www.aveva.com


This opens the Service Import Configuration Settings window. Select the source Oracle from the Select Sourc e list.


Login to the project after the source has been selected with the Login button

The Select an Oracle Project dialog is then displayed for the selected data source. Enter the Password VPE2 and click the Connect button.


308

www.aveva.com






309

www.aveva.com


(Step 2 of 5): Source Object Type Source: The source data is the data that will be the basis of the comparison. In this case make sure Oracle is selected Configuration Name : This will be the name the configuration will be identified as. Enter INST for this field. Group : This will be the group the configuration will be created in. Enter AI-ORA 001 for this field. Object Type Mapping : This will be the element type that the configuration utilises. In this case select AI_INSTRUMENTS.

Name Attribu te : This will be the selected e lement type that is utilised to f ind possible matches between the source Oracle items, and target AVEVA Instrumentations items. Select the NAME option Unique Attribute : This will be the attribute that serves as the unique key attribute of source items. Select the ID option



310

www.aveva.com



This step provides the option to choose target data in the selected AVEVA Electrical database. Target data is compared against source data. Object Type: This will be the type of object in the Destination database. Select Instrument for this option Name Attrib ute: This will be the objected type utilised to find attribute matches in AVEVA Electrical items. Select TagNo for this option. Unique Attribute: This will serve as the unique key attribute of the destination items. Select InstKEY for this option. Insert Option: This will allow for the creation of new items in the target database, if source items do not find a matching target item after comparison.




311

www.aveva.com



Ad d Fi lt er : Retain the default blank entries. This allows for the definition of criteria which limit the population of source data that will be used in the comparison. Delete Filter : This button deletes any set filter.



Attributes of the source element types can now be mapped to those of the corresponding target element types. Attribute selection and mapping indicates the attribute values to be obtained and/or compared against. Basic mappings for the import facility between AVEVA Electrical and Or acle can be setup as illustrated below. Click on the Add m app in g button to display a new mapping row. Mapped attributes can be selected and then deleted with the Delete Mapping button. Select a Oracle DB (Source) attribute from the pull-down list, then select a corresponding AVEVA Electrical (Destinatio n) attribute from its available list to map it to. Using the table below as a guide, map the following fields: Oracle DB (Sourc e)

AVEVA Electri cal (Desti natio n)

AREA

Ar eaNo

AREAPATH

Ar eaPath

CLASSNAME

ClassName

TAGFORMATNAME

TagFormatName

NAME

TagNo

INSTTYPE

Description

FUNCTION

ISAFunc

LNUMBER

Lnumber

SUFFIX

Suffix


312

www.aveva.com





313

www.aveva.com


13.5

Data Comp are and Updates

Open AVEVA Electrical application by navigating to Start > All Programs > AVEVA > Engineer > AVEVA Instrumentation 12.1.4 > Instrumentation Engin eer 12.1.4

Open the Loads tab by browsing Home > Select > Instru ments

The Instruments grid is then displayed. On the Manage tab, in the Servic e Integration group, select Oracle from the Products options list.



314

www.aveva.com


This opens the Select an Oracle Project window

Enter the following Password: VPE2 Click the Connect button.

On the Manage tab, in the Servic e Integration group, select ORA001 from the Groups options list.

Select Import Data The Integration operation will then take place. The values of the mapped attributes of a source (Oracle) item will be compared with the attributes values of any existing and matched corresponding destination (AVEVA Electrical) item.

Click the Yes button



315

www.aveva.com



.


The check boxes can be used to import the data for individual items, the Ac cep t All can be used to import all the items. In the AI-ORA001 ( 2 Items - 2 Changed ) tab select the 00-FV-100 and 00-LV-200 instruments and click the Update Database button on the menu


316

www.aveva.com






317

www.aveva.com

TM-6107 AVEVA Instrumentation (12 1) Integration Rev 3.0

Recommend Documents