Training

Duration: 3 training days, 8 hours per day.

The program:

1. iFIX Instalation

2. Creating projects

• system configuration (SCU)
• creating new projects
• backups
• transferring projects

3. iFIX Workspace

• creation and real time display of pictures
• management of multiple pictures in the app

4. iFIX Process database – structure and tools

5. Pictures

• creation and management methods
• multi-monitor app

6. Keyboard macros – switching windows using function keys

7. Simulation registers – creation of advanced picture simulations

8. Alerts

9. iFIX application protection system – control of access to pictures and variables

10. Using schedules to handle events

11. Reference Locator, Global Search & Replace tool – introducing changes to multiple pictures simultaneously

12. Archiving Process Data – Proficy Historian industrial database

13.Tag Group technology

14. PLC drivers

15. Additional tools

• using the .NET controls
• activeX
• groups of diagrams

16. Network Solutions

Duration: 3 training days, 8 hours per day.

The program:

1. Diagnostics

• Troubleshooting network problems
• Database diagnostic tools
• Picture scripts – VBA debugger

2. Advanced alerting– different types of alerting in iFIX system
3. Alerts to ODBC – transmission of alerts to the relational database
4. VisiconX Object – data presentation
5. Electronic signatures
6. Advanced data blocks – SQT and SQD
7. Multiple monitors applications
8. Block group technology – TGD as Global Glossary
9. Language versions
10. Dynamo Objects – animated elements of synoptic screens
11. Optimizing Application
12. Application Validator – checking file versions during remote operation
13. Redundancy
14. Discovery & Auto Configure tool – downloading block information from PLC driver program files or OPC servers
15. DDE in IGS – communication protocol between applications when changing data values
16. OPC – remote connection configuration
17. Webspace – configuration and control panel

Duration: 1 or 2 training days, 8 hours per day.

The program:

1. Administering the Proficy Historian server

• system statistics
• screen displaying operations on tags, collectors and data files
• system message screen

1. Data storage – screen displaying operations on data storage and archives
2. Access protection
3. Entering data into Historian system data collectors

• installing a Historian system data collector
• configuring the Historian system data collector for automatic start-up
• collector redundancy

1. iFIX system data collector
2. OPC collector
3. ODBC collector
4. File collector
5. Types of data identified by the user
6. Enumeration variables
7. Historian clients

• Historian Interactive SQL application
• Proficy Real Time Information Portal SQL
• Microsoft Excel
• Microsoft SQL Server linked servers
• VisiconX
• Visual Basic and ADO

12. Excel Add-inn for the Historian system – defining reports
13. OLE DB

• working with the syntax of SQL, SELECT, SET formulas
• general guidelines for preparing a query
• parametrized SQL queries
• connecting to OLE DB Provider

14. Logging alerts and events
15. Linking servers
16. Historian server as the source for OPC HDA

• supported Historian OPC HDA server attributes and quality values
• configuring Windows XP or Vista system firewalls to operate with remote OPC servers
• connecting and disconnecting from the OPC HDA server

17. Calculation collector

• performing calculations, calculation tab
• source, target and trigger type tags
• creating calculation formulas using a wizard and types of supported functions

18. Server-to-server collector – collecting data from other servers
19. Historian Server-To-Server
20. Historian Trend Client

Duration: 2 training days, 8 hours per day.

The program:

1. What is Visual Basic language?
2. VBA environment in iFIX

• editor screen elements
• FIX environment code writing

3. VBA language description

• language keywords
• mathematical and logical operators
• types of data in VBA
• constants and variables
• declaration of constants, variables and objects
• data structures
• dialog boxes
• comments
• object-orientation in VBA language

4. Functions and procedures

• writing functions and procedures in VBA language
• methods for calling functions and procedures
• sending function and procedure parameters
• DoEvents statement
• GoTo statement
• conditional statements If…Then…Else, Select Case

5. Do Loop, For Next loops
6. Panels and collections
7. Fixed values

• enum enumeration type
• const type variables
• environmental variables

8. References
9. VBA Debugger

• code navigation
• code breakpoints
• variable value view
• running the code
• debugging using MsgBox
• error management
• Immediate box

10. File operations
11. Advanced file operations
12. Win API – Declare statement
13. Toolbars

Duration: 3 training days, 8 hours per day.

The program:

1. Advanced iFIX project structure

• module composition
• class implementation

2. iFIX ribbon – adding own functionality to the iFIX context menu ribbon
3. Block group technology

• advanced iFIX applications using TGD files
• creating TGD files from the VBA level

4. Proficy Historian

• access to historical data using SDK
• operating the file collector (working with XML and CSV files)

5. Relational databases

• SQL operations on a relational database
• ADO technology
• iFIX diagram with relational database data
• access to historical data using ADO and the GE Historian OLE DB source

6. Advanced iFIX diagram functions

• adding / deleting markers
• marker color change
• navigation in time

7. Interfering in IDE during code execution

• adding procedures
• adding modules

8. Using MS Office

• creating a report in xls, pdf format
• creating a report in doc, pdf format

9. Advanced data presentation tools – using msfFlexGrid

Duration: 2 training days, 16 hours.

The program: Reporting in Dream Report

1. DREAM REPORT INSTALLATION
2. CREATING A PROJECT
3. DRIVER CONFIGURATION
4. DATA REGISTRATION GROUPS
5. REPORT SETTINGS
6. DATA FIELD OBJECTS
7. SERIES
8. TABLES
9. DIAGRAMS
10. INDEXES
11. EXPORTING REPORTS TO EXCEL
12. USER MANAGEMENT
13. SQL MANAGER
14. SYSTEM FIELDS
15. WEB PORTAL

Duration: 1 training day, 8 hours.

During training, a theoretical knowledge on the library will be passed and practical exercises of a gradually developing programming project implemented. The outcome of the project is an application covering the major Client Access API library functionalities.

The training requires basic knowledge on C# language, object programming and the industrial Proficy Historian database.

The program:

1. .NET and Historian requirements
2. Project configuration
3. Database connection
4. Tag operations
5. Data management
6. Server management
7. Archive
8. Data storage
9. Collector
10. Data type
11. Enumeration

Duration: 1 training day, 8 hours.

The program:

1. Introduction

• General information
• Possibilities

2. Historian Excel Add-In installation

• Equipment and software requirements
• Installation
• Add-in configuration
• Defining reports
• Excel Add-in – Administrator

3. Historian Excel Add-In functionality

• Searching
• Editing
• Administrator
• Settings and support

4. Beginner exercises

• Running the add-in
• Creating queries concerning Tags variables
• Creating queries concerning current variable values
• Exporting variable information from Historian
• Modifying and importing data using Excel

5. Advanced exercises

• Shift report
• Batch production
• Daily consumption of utilities report
• Statistical data analysis
• Event report

Duration: 3 training days, 8 hours per day.

The program: Proficy Plant Applications – Efficiency & Quality module

1. INTRODUCTION

1.1. Plant Application – MES software

1.2. Monitoring the effectiveness of production process

1.3. System Architecture

1.4. – Equipment and software requirements

2. PLANT APPLICATIONS SOFTWARE USE

2.1. Plant Applications Administrator

2.2. Plant Applications Client

3.CONFIGURATION OF A DEMONSTRATION PRODUCTION PLANT IN THE PLANT APPLICATIONS SYSTEM

3.1. Description of the demonstration production plant

3.2. Transfer of data to the industrial database

3.3. Connecting the system to the industrial database

3.4. Virtual plant configuration

3.5. Web server operation – sample reports

3.6. Example of report generating in Excel Add-In

3.7. Example of Excel report publication in the form of a web page

3.8. Reporting in Vision

3.9. Integration of the HMI/SCADA IFIX system

The program:

1. Managing GE licences within the plant,
2. iFIX project management
3. Historian management
4. Drivers configuration and modification,
5. Database configuration and modification,
6. Historian configuration and modification,
7. Picture modifications,
8. Alerting,
9. Historical alerts,
10. Security system management,
11. Creating simple Dynamo objects,
12. Creating reports in Historian Trend Client,
13. Downloading data in Excel Add-In (simple report creation)
14. Elements of debugging with Visual Basic

Optional: presentation of Webspace software, WIN 911, Web HMI

New:

For clients from one company, there is an option to analyze the existing client’s application.

Q&A session

Duration: 2 training days, 8 hours per day.

The program:

1. INTRODUCTION
2. System protection
3. Advanced point parameters
4. Graphics
5. Smart objects
6. Alerting
7. Data logging
8. VISCONX
9. Trends
10. Signals generator – scripts
11. Automatic application launcher
12. Web Clients, VisiconX