What can we improve?

Documentation

(Edit)

Translation is in progress...
Not all topics are available at the moment and content links may be broken.

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
Deutsche Webseite verfügbar
Go to cart
Any questions?