Send feedback!
(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)
- 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 (.)
One set of data per row.
Values are seperated by comma (,).
The logged values are always stored in UTC, independent of the configured server time.
String values are stored Base64 encoded.
- db\2010\01\12345.csv
- db\2010\01\23456.csv
- db\2010\02\12345.csv
- db\2010\02\23456.csv
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
- db\12345.year.csv
- db\12345.month.csv
- db\12345.week.csv
- db\12345.day.csv
- db\12345.hour.csv