Trend Export

Trend Export is a powerful utility to handle the interchange of historical data with other applications. Whether your organization needs to integrate this data into common reporting tools such as Crystal Reports, other business intelligence tools or need to feed corporate applications such Enterprise Resource Planning (ERP) Systems, Trend Export makes this a painless process.

Trend Export has globalization features that support generating exports with different local date and time formats. Export configurations can specify the time zone to use for the exported data allowing remote users in different time zones to see the data in their own local time.

Trend Export will extract historical data from any OPC-Historical Data Access (HDA) compliant database and will place the data into a CSV or XML file. When Trend Export generates a CSV file, a pre-programmed Excel macro is supplied to interpret the data and to format it into a meanful report.

Trend Export Configuration

The Trend Export Configuration program is used to build the .XCF file which defines the tags to export, the range of data to export and the output format. There are three types of exports:

• UBE Export - Update-By-Exception exports all the raw data values within the selected range. No calculations are performed.

• Time Average Export - export a time-weighted average at each interval for all the data in the selected range. The time-average values are computed by Trend Export based on the raw data values.

• Aggregate Export - exports data in the selected time range. The data values are computed by the OPC-HDA server based on the aggregate type and aggregate interval.

Trend Export Monitor

To ensure the export is completed, Trend Export Monitor controls and provides the export operation. When the export is completed, you have the option of launching the client application that will use the exported data. One of options is to open Excel and run the formatting macro to build a user friendly report. Any client application can be added to the launch list. If required, you can cancel an export at any time.

Trend Export Command

The Trend Export Command enables third party applications, such as an HMI application to perform command-line driven exports via its embedded scripting capabilities, simplifying the export of information without having to use the Canary Labs UI.