What can we improve?

« Back to Product

Documentation

(Edit)

Data Format

Since version 4.0 of IP-Symcon CSV files are used for logging. Before, an SQL database was used.

The archive saves two different types of values.

  • Primaryly, all raw data is stored.
  • Secondaryly, the aggregated data is calculated and stored for different timespans (year, month, week, day, hour)

CSV Structure

  • all files include the VariableID in their name and end with .csv
  • Raw data is written into individual folders per year and month
  • Aggregation data is stored in the db mainfolder
  • Files are only created when data is available
  • The decimal seperator is always a dot (.)

Content of Raw Data

One set of data per row.
Values are seperated by comma (,).

  • Unix Timestamp
  • Raw Data

The logged values are always stored in UTC, independent of the configured server time.

String values are stored Base64 encoded.

Folder Structure of Raw Data

  • db\2010\01\12345.csv
  • db\2010\01\23456.csv
  • db\2010\02\12345.csv
  • db\2010\02\23456.csv

Content of Aggregation Data

One set of data per row.
Values are seperated by comma (,).

  • Unix Timestamp for Avg value
  • Avg value
  • Delta to the Unix Timestamp for Min value
  • Min value
  • Delta to the Unix Timestamp for Max value
  • Max value

Folder Structure of Aggregation Data

  • db\12345.year.csv
  • db\12345.month.csv
  • db\12345.week.csv
  • db\12345.day.csv
  • db\12345.hour.csv