Summary Actions (CSV/ODBC)

<< Click to Display Table of Contents >>

Manual > Server Creation Guide > Action Edition > Action Reference >

Summary Actions (CSV/ODBC)

How to read the manual

This chapter is for reference information only.

Please refer to the following link for the construction procedure.

 

Building logging/trend graphs...Monitoring system building guide "Logging/trend graphs"

Building a daily report...Monitoring system construction guide "Daily report"

 

 

attention

There are two actions that provide logging functionality: "Summary Actions" (this action) and "Logger Actions". Each has its own characteristics. For example, if you want to perform daily report aggregation and report creation in addition to logging, select Summary Actions. For the differences between the two, please refer to the comparison table in "Differences with Logger Actions" on this page.

 

 

overview

Summary actions are actions that combine a "logging function" that logs tag values as historical data, and an "aggregation function" that automatically aggregates historical data in any unit such as Daily/Monthly/Yearly Report. Data stores supported are CSV files and ODBC databases (*Please refer to the notes below for compatible databases.).

 

The client application FA-Client can connect to the report data (Daily/Monthly/Yearly Report) created by the summary action and display the daily report screen. It can also display the historical data generated by the action on a trend graph screen.

 

c_action_0300_2

 

 

Summary Actions provide the following four main functions:

 

kinds

overview

Logging function

Tag values are read periodically and logged in chronological order as historical data.

 

Aggregation function

This function automatically aggregates data in preset aggregation units based on the historical data generated by the "logging function."

 

The unit of calculation can be freely set (you can freely set it to days, months, years, 10 minutes, 30 minutes, etc.).

 

The most common units of calculation are daily reports (hourly calculations: one line per hour * maximum of 24 lines), monthly reports (daily calculations: one line per day * maximum of 31 lines), and annual reports (monthly calculations: one line per month * maximum of 12 lines).

 

Report function

This is a report function for creating Daily/Monthly/Yearly Report etc. The report function is provided by summary actions (FA-Server) and the report screen (FA-Client).

In addition to displaying and printing daily reports from the screen, you can also automatically print reports as needed. You can also use the sub-report function to automatically generate CSV files and Excel files.

 

Historical data serverFeatures

Summary actions also have the functionality of Historical data server. Trend graph screens can be displayed on the client FA-Client.

 

 

 

Difference from Logger Action

Logger Action is a function developed in versions prior to Ver4, and is specialized only for logging processing. On the other hand, Summary Action is a new function added in Ver5, and is a functional configuration that integrates logging function, aggregation processing, and report creation function.

 

If you only want to build a process that logs tag values, you can use either a logger action or a summary action to achieve the logging process, but they each have the following characteristics. Which action to choose should be determined by the specifications and uses of each.

 

 

Comparison with Logger Action


Logger Actions

Summary Actions

High speed logging function

Logging is possible down to milliseconds.

For example, when saving to a CSV file, logging can be done in about a few tens of milliseconds, although this depends on the writing speed of the HDD and the communication speed with the PLC, etc.

Logging can be done at a maximum interval of 1 second. Logging at millisecond intervals is not supported.

How to set tags for logging

You can set the desired tags by dragging and dropping them on the FA-Server screen.

Each action corresponds to one database (one file for CSV, one table for ODBC). If you want to save to multiple CSV files or tables, you need to define multiple actions in parallel.

Set the tag path to be logged in the summary action configuration file "Tag Field Master" (text file).

Tag field masters are set manually using Excel or Notepad.

Furthermore, by defining the maximum number of columns in the database in advance, the data will be automatically split and generated into multiple databases (multiple files for CSV, multiple tables for ODBC) at runtime.

Log Format

In addition to general time-series logs, it is also possible to generate event-type logs.

 

Only general time-series logs are supported.

 

Aggregation function

none.

 

This action can only be used for logging. Furthermore, historical data generated by this action cannot be aggregated by summary actions.

 

Yes.

 

Based on the historical data (logging data) generated by Summary Action itself, it automatically performs aggregation processing using various statistical methods such as sum, average, maximum, and minimum.

You can also perform calculations between aggregated data from each field and save the results as aggregated data.

 

Reporting

none.

 

This action can only be used for logging. Furthermore, historical data generated by this action cannot be aggregated by summary actions.

 

Yes.

 

Built-in report creation function. Reports are created based on the data collected by Summary Action itself.

 

Historical data server Features

Yes.

 

You can connect to historical data from the client FA-Client and display trend graphs on the screen.

 

Yes.

 

(Same as left)

 

 

Hint

Use a logger action if you want to log at a high-speed interval such as milliseconds, or if you simply want to log. On the other hand, if a logging interval of 1 second or more is OK and you need to perform daily report aggregation, use a summary action (*If you need to perform daily report aggregation, you must select a summary action). For more information about logger actions, see "Logger".