History

Fx2020 keeps history data in folder /HDisk/Fidelix/Data/History. File History.dat contains configuration and collected data is in separate file for each point. Number of points to be collected is not limited but maximum sample count for one point is 20000 and minimum sampling interval is 5 seconds. Using 5 minute interval and 20000 samples you can keep data for 69 days. Disk space usage is 8 bytes per sample, max size file takes 160kB.

Example: Define 100 points with 5 minute interval and 5000 samples per point.

Required disk space is 100 * 5000 * 8 = 4MB Saving period is 5000 * 5min / 60 / 24 = 17days

Note

If saving tolerance is used, period is extended because samples are not saved at every interval if value has not changed.

Maximum saving capacity is 120 samples per minute. If you define 100 points to be saved with interval of 10 seconds it makes 10 saves per second. That loads Fx2020 too much and the software will automatically increase interval for each point so that maximum will not be reached.

SQL server

In version 10.97 it is possible to define data replication to external SQL server. Feature has been tested with MS SQL Server Express 2005/2008/2012.

The feature is activated in “Settings - System settings” menu. Connection is using SQL server authentication.

Database and user with enough rights to access it must be created manually in SQL server.

Fx creates automatically all necessary tables into database.

Table “Facilities” contains list of facilities.

Each facility has own table that contains list of points to be saved.

Each point has table for storing the data.

Size of data table is automatically limited to same sample count as defined in history.

All point names in history must be in form faclility_xxx That is at least two fields separated with underscore or dash. First field is the facility.

Name of the data table is same as point name.

Data update interval is 5min + history point count * 10sec. Data contains GMT time stamp.

Since version 11.00.01 also points with type ‘energy’ work correctly.

After version upgrade this feature is available in: - Fx2025A with CE version CE60_102 - Fx2025 with CE version CE50_009 and files of CE50_SQL_01.zip in Bin folder.

Sending history via email

You can define automatic email sending for each group separately. Email is sent automatically just after midnight or manually using Test button.

Send interval has following choices: - Daily, once a day - Weekly, once a week at selected day of week - Monthly, always at day 1 of month - Energy report, data of previous 31 days once a day (only energy channels)