Server Reference Guide - Wizcon

1 Server Reference Guide Version Information in this document is subject to change without notice. Wizcon or SyTech assumes no responsibility for any errors or omissions that may be in this document. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the prior written permission of Wizcon or SyTech WizReportTM XL is a trademark of Wizcon Systems SAS. WizReportTM XL is based on XLReporterTM from SyTech, Inc. Copyright 2000 - 2006 SyTech, Inc. All rights reserved. XLReporter and XLR are trademarks of SyTech, Inc. Microsoft is a registered trademark of Microsoft, Inc. All registered names are the property of their respective Contents Wizcon Systems - Wizcon 9 Setting up Wizcon ..9 Real Time Data.

2 9 OPC Tag Names ..9 OPC Tag History Group ..9 Main Dialog ..10 Select History Group History Group Dialog ..11 Columns Time Period Tab ..13 History Data Quality ..15 Database Connecting to the Database ..15 Alarm and Event Data ..15 Accessing Remote Data ..15 Real Time ..15 Historical ..15 GE Fanuc Proficy FIX and iFIX 16 Setting up FIX and Real Time Data ..16 History Group ..17 Main Dialog ..17 History Group Dialog ..17 Columns Time Period Tab ..19 Database Alarms and Event Data ..21 Remote Data Access ..21 Real Time ..21 Historical ..21 Starting the Scheduler ..22 Using the WizReport XL Programming Interface ..22 Issuing Commands from iFIX ..22 Issuing Commands from FIX ..22 Troubleshooting ..22 GE Fanuc - Proficy Historian 23 Overview ..23 History Group ..23 Database Setting up Proficy Historian.

3 24 History Group ..24 Main Dialog ..24 History Group Type Dialog ..24 History Group Dialog ..25 Setup Tab ..26 Columns Time Period Tab ..29 Filters Tab Raw and Calculated Values ..30 Filters Tab -Sampled Order Database Group ..35 Connecting to the Proficy Historian Server ..35 Accessing Remote Data ..35 Troubleshooting ..35 Rockwell Software - RSLinx 36 Overview ..36 Setting up RSLinx ..36 RSLinx configuration for OPC ..36 Real Time Data ..36 OPC Tag Browsing ..36 Tag Name Remote Data Access ..37 Troubleshooting ..37 Rockwell Software - RSView 38 Overview ..38 Setting up RSView32 ..38 Enabling the OPC Server ..38 Real Time Write Access ..39 Configuring a Data Log Model ..39 Alarm Log and Activities Log ..39 Real Time Data ..39 History Group ..39 Main Dialog ..39 History Group Type Dialog ..40 History Group Dialog ..41 Setup Tab.

4 41 Columns Time Period Tab ..44 Filters Tab Calculated Values, Raw Values and Raw Text ..46 Filter Tab Alarms and Order Database Group ..49 Accessing Remote Data ..50 Real Historical ..50 Starting the Scheduler ..50 Using the WizReport XL Programming Interface ..50 Emerson Process - DeltaV 51 Setting up Remote OPC and OPC HDA Connections ..51 OSI-PI History ..52 Real Time Data ..52 Application Station ..52 Pro Plus History Group - Main Dialog ..53 History Group Dialog ..54 Columns Time Period Tab ..55 History Group Setup Tab ..57 Columns Database Accessing Remote Data ..58 Real Time ..58 Historical ..58 Starting the Scheduler ..58 Using the WizReport XL Programming Interface ..58 Issuing Commands from Delta V versions with Issuing Commands from Delta V versions with OPC-HDA Servers 60 History Group.

5 60 Main Dialog ..60 History Group Type Dialog ..60 History Group Dialog ..61 Setup Tab ..62 Columns Time Period Tab ..65 Retrieving Raw Values ..67 Adding to the History Group Mode List ..67 Remote Data Access ..67 OPC Servers 68 Real Time Data ..68 OPC Tag Names ..68 OPC Tag Remote Data Access ..69 Wonderware - InTouch 71 Overview ..71 Setting up InTouch ..71 Configuration Settings ..71 ..71 Real Time Data ..71 History Group ..72 Main Dialog ..72 History Group Dialog ..72 Columns Time Period Tab ..75 Accessing Remote Data ..76 Real Starting the Scheduler ..76 Using the WizReport XL Programming Troubleshooting ..77 Wonderware - Industrial SQL Server 78 Overview ..78 Setting up Connecting to Summary Tables from InSQL ..78 History Group ..79 Main Dialog ..79 History Group Type Dialog ..79 History Group Dialog.

6 80 Setup Tab ..80 Columns Time Period Tab ..83 Retrieval Filters Tab ..87 Adding Summary Custom Durations ..88 Database Group ..88 Connecting to the InSQL Server ..88 Considerations for Configuring a Database Group ..88 Intech Instruments - MicroScan2000 90 Overview ..90 Setting up MicroScan ..90 Real Time Data ..90 Tag Using Cell References in History Groups 92 Overview ..92 Cell Reference Format ..92 Cell References for Date and Time ..92 The Using Variables in History Groups 95 Variable Format ..95 Variable Usage ..95 Register Functions ..95 DateTime Server Reference Guide Wizcon Systems - Wizcon 9 Wizcon Systems - Wizcon Overview Wizcon provides a number of data sources for reporting: Real-time data using OPC Real time data access is by the standard OPC interface. Historical data using the native interface Historical data is accessed from the local historian.

7 Historical data using the Database interface Historical data can be accessed from a relational database. Setting up Wizcon No setup is required. Real Time Data Real Time data is accessed through the OPC Server provided with Wizcon . OPC Tag Names In %Product%, the full specification of an OPC tag name consists of a node (if the tag is from a remote node), an OPC Server name and the name of a tag. The syntax is: <<Node>> < Server >Name The <<Node>> is not required if the OPC Server is local. Real time connections defined in the Connection Configurator (see the User Reference Guide ) only display the Name, after the tag has been selected from the OPC tag browser. However, by hovering over the tag, a tool tip will appear showing full name in the format shown above, , <<>> < > OPC Tag Browser See the OPC chapter for more information History Group History Groups are the interface for extracting information from a History Server .

8 Groups can be defined for raw values as well as calculations. In both cases, the group is configured with a time duration (span) over which the history data is retrieved. 10 Wizcon Systems - Wizcon Server Reference Guide In the case of calculations, an interval is also specified which defines the calculations. The calculation is repeated for each interval in the time duration. For example, if the time duration (span) is one day, and the interval is one hour, then the group calculation is performed 24 times, once for each hour of the day. Main Dialog The History Group is opened by right-clicking and the History Groups folder in the Project Explorer. It can also be opened in the Connection Configurator by setting the Source Type to History Group and clicking the browse button. Content Configured Displays a list of all the configured history groups.

9 Controls New Configure a new history group. Modify Modify the selected history group. Delete Delete the selected history group. Select History Group Dialog Opened by clicking New in the Main dialog. The dialog is used to select the type of history group required. The history group type determines the type of data retrieved from the History Server when the group is used for retrieval. Content Raw Values Raw numeric values, as stored in the Historical Server . Sampled Values Sampled values or interpolated values. Returns sampled values at the interval specified. Calculated Values Calculated values from raw samples in the Server over the interval; Calculations such as, average, total, maximum, minimum, etc., are provided. Raw Text Raw text values, as stored in the Historical Server . Server Reference Guide Wizcon Systems - Wizcon 11 History Group Dialog Opened by clicking OK from the Select History Group dialog or by clicking Modify from the Main dialog.

10 Content Name The name of the history group. Controls OK Saves the History Group configuration a file with extension GRP. Preview Displays a preview of the output of the History Group. Columns Tab The Columns tab shows the Server tags that have been selected for the group, along with other settings. Each selected tag will produce a column in the output of the group. Content Selected Columns Name The list of tags configured for the group. Selecting this column brings up the historical tag browser for tag selection. The name can also be a cell Reference , a variable or left blank. In the case of a blank name, the output column will also be blank. For more information, see the chapters on Using Variables in History Groups and Using Cell References in History Groups. Mode Defines the calculation to apply to the selected Name.