[行业软件]SyTech XLReporter 15.0 [复制链接]

SyTech releases a new version of XLReporter 15. This release addresses Microsoft updates for DCOM and the Office 365 email server as well as making improvements to the Database (time series) Historical values (wide multi-table) and (narrow multi-column) connectors, making it easier to navigate for users.

XLReporter Version 15


New Features


Connectors

OPC DA and OPC HDA
- When connecting to an OPC DA or OPC HDA server on a remote machine, Microsoft’s DCOM technology is used.
- Microsoft is due to release an update to harden DCOM connectivity which requires OPC DA and OPC HDA clients like XLReporter to use higher level authentication to connect.
- To account for this, in the Settings of the OPC DA and OPC HDA connectors, the Use Packet Integrity Authentication Level option is provided. If the DCOM hardening has been applied to the machine where the OPC DA or OPC HDA server is running, this option should be checked.
Database (time series) Historical values (wide multi-table)
- 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.
- The Historical values (wide multi-table) connector now provides an interface to specify which tables and views to browse and request data from in the database connected to. Each table and view can be set with a Friendly Name to help users identify where to get their data from
Database (time series) 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.
- The Historical values (narrow multi-column) connector now provides an interface to specify the tag table and data table settings for all the tables and views to consider in the database for the connector. Each data table/view can be set with a Friendly Name to help users identify where to get their data from.

Email and SMS

Data Export to Database
- In an effort to bolster email security, Microsoft is phasing out basic authentication to the Office 365 SMTP server in favor of more advanced, modern authentication methods.
- To account for this, the Email and SMS application has been updated so that the Office 365 SMTP server can still be used as your mail server by using the OAuth2 authentication method.
- For more information, see Deprecation of Basic authentication in Exchange Online on Microsoft’s website.

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.

Database Consolidator

Timeout
- If requests to the source database took longer than 20 seconds a timeout error would be returned regardless of the Client Wait Time set in the connector.
Missing Data
- If the Source Date Storage is set to utc, after the initial consolidation of data, records from the beginning of the next request were not being logged to the Target Table.

Data Entry Forms

- When used from a Windows Client, if the table for the data entry form contained a reserved word in the database, an error would appear when the form was selected. For example, if the table contained a column named Level, the error would read “The LEVEL clause includes a reserved word or argument”.

Design Studio

- The import template option now supports importing existing Excel files with .xls and .xlsm file extensions.
- For older manual data entry form templates, a Save As action would cause the studio to crash.

FTP Transfer

- When uploading to an FTP Server, if the Clear Folder before transfer setting was checked on the Target tab and no files in the Target Folder matched the Source Filter specified, a “Failed to clear target folder” error message could be returned.

On-Demand Reports

- When selecting a tag with no description in an On-Demand Report, changing Display to Description and back to Name or Nickname would remove the tag from the panel.

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.
- The Chart Recorder library templates have been completely revamped.

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.

Microsoft Excel is indisputably one of the most widely used software applications in the world. XLReporter takes the best of this product and delivers it to an industrial environment, without needing Excel! The result is a secure, efficient reporting solution with around-the-clock robustness

With a scalable design, XLReporter has an edition to fit any budget. It is implemented in over 80 countries and endorsed by small municipal facilities as well as major international manufacturers and Fortune 500 companies.

XLReporter 14.4 advances Database (time series) connectors to support more complex database schemas such as those with multiple tables. It also addresses the Microsoft updates for OPC "hardening" and Office 365 email security elevation.

Welcome to XLReporter







SyTech develops reporting software to enable organizations to turn raw process data into actionable information, increasing efficiency and reducing costs. With a combined knowledge of business technology and the needs of automated systems, SyTech created XLReporter. The product is built on the Microsoft Open Office standard and is the leading reporting platform in industry to deliver workbook technology to an automated environment.

A private company founded in 1994 and headquartered in Massachusetts, SyTech provides solutions around the world and in virtually every industry, from small municipal facilities to major international manufacturers and Fortune 500 companies.

SyTech’s reporting solution is perfect for any sized system and budget. Automatic reports directly from a PLC, on-demand web reports from a historian, ISA 18.2 alarm analytics, CFR Part11 security features and automated email are a few of the many features to empower users with right report at the right time.

Product: SyTech XLReporter
Version: 15
Supported Architectures: x86 or x64
Website Home Page : www.sytech.com
Languages Supported: english
System Requirements: Windows *
Size: 166.8 mb


* System Requirements:

    

感谢楼主提供。

    

好好学习，感谢楼主提供，

谢谢楼主分享！！

    

    

感谢分享！！！