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