A new connector that manages multiple tables in a database to make them appear as a single table.
This approach avoids complex database “joins” and makes the retrieval of data efficient. From a
user’s perspective, data access is selected from a single tag browser displaying columns across all the
tables.
Historical Values (narrow multi-column)
The current Historical Values (narrow) connector is used for “narrow” data tables that only contain a
single data column. This new connector expands the functionality to handle narrow tables that have
multiple columns of data.
Data Management
Data Export to Database
This is an enhancement to the existing export capability where data in a report is exported to a
database. When exporting is performed to Microsoft SQL Server database, a Bulk Copy is available to
exports a range of values to the database quickly and efficiently.
Function
The Function Category provides a collection of functions to perform tasks not easily available in
spreadsheets. For instance, this category offers TimeStamp Convert which converts Universal Time
(UTC) to local time and vice versa, accounting for daylight savings adjustments.
Custom
The Custom Category is for users who wish to integrate their own business logic by providing them in
.NET classes. XLReporter orchestrates the transfer of raw data from the report to the external .NET
class for processing and places the output of the class onto the report.
Improvements/Issues Fixed
Alarm Module
Increased Performance
A performance increase is provided by the alarm module when used against the Rockwell Alarms and Events database.
Siemens WinCC/PCS7 Alarms
In some cases, when requesting alarm data from the WinCC/PCS7 alarms database an error would occur about the syntax of the query.
Client Wait Time
If requests to a database took longer than 20 seconds a timeout error would be returned regardless of the Client Wait Time set in the connector.
No Alarms Message
When scheduled, if no alarms were logged over the time period requested a popup message could appear which would halt schedule execution.
Design Studio
Template New
The import template option now supports importing existing Excel files with .xls and .xlsm file extensions.
Template Library
Any template configured for historical data connectors now lists analytic and manual data entry connectors to select.
In addition, when either of these is selected a second option is available to specify which analytic or specific data entry form to use.
Windows Client
Manual Data Entry
When running the Manual Data Entry application on a Windows client, if connection to the network where the server is running is lost,
the application does not close down, preserving any data that has been entered. Once network connectivity is restored and the client
is logged back in, data in the form can be stored to the database.
Web Portal
If the web portal was configured to an https protocol, when attempting to view reports published in HTML format, an error would appear indicating the file does not exist.