TcHmiSqliteHistorize extension

When creating a new TwinCAT HMI project the TcHmiSqliteHistorize extension is also loaded and is located in the project under the server node with the Extensions. Alternatively, the package Beckhoff.TwinCAT.HMI.SqliteHistorize can be installed.

TcHmiSqliteHistorize extension 1:

Configuration

The extension configuration page is opened with a double-click on the extension in the Solution. Alternatively this can also be called via the server configuration page on the TcHmiSqliteHistorize tab.

TcHmiSqliteHistorize extension 2:

On the configuration page you have the option to create new historized symbols and to define the storage location of the database and all historized symbols. By default the historized symbols are stored on the local hard drive. Alternatively they can be saved directly in the computer's RAM.

Notice

Loss of data

If saved in the RAM, the data will be lost in the event of the PC being shut down.

Adding a historized symbol

In order for a symbol to be used as a historized symbol, it must be mapped. A historized symbol can be added in two different ways:

Configuration window (recommended):

A historized symbol can be added in the TwinCAT HMI Configuration window, where a dialog is available for adding the symbols. Instructions for this can be found here.

Extension configuration:

A new historized symbol can be added via the Add button on the configuration page of the TcHmiSqliteHistorize extension. A dialog then opens for adding the symbol.

TcHmiSqliteHistorize extension 3:
  1. Linked Server Symbol: Mapped server symbol to be historized. All mapped server symbols are displayed in the combobox.
  2. Interval Time: Interval at which the symbol is saved in the database.
  3. Maximum number of Entries: Maximum entries of the ring memory of the database. On the basis of the interval time and the maximum number of entries you can calculate the time period for which the data can be stored. If the time period is to be extended you can extend the interval time or increase the maximum number of entries.
  4. Recording enabled: Specifies whether the symbol is to be historized or whether historization is to be disabled.
  5. Row limit for filter: Maximum number of data records that are filtered by the TcHmiSqliteHistorize extension and forwarded to the trendline chart.