Documentation
CSV ZIP Export
Require: IP-Symcon >= 5.5
This module provides the possibility to export the aggregated values of a variable as a CSV file in a ZIP archive.
function scope
- Exporting aggregated data of a variable or several variables
- Export data to CSV file in a ZIP archive
- Listing of all logged variables
- Period of aggregation can be freely selected
- Aggregation level can be selected
- Cyclic creation and sending of an archive by email or ftp/ftps/sftp
software installation
- Install the 'CSVZipExport' module via the Module Store.
Setting up instances in IP-Symcon
- Under "Add Instance", the 'CSV-ZIP-Export' module can be found using the quick filter.
- More information about adding instances in the Instances documentation
configuration page
| Name | Description |
|---|---|
| Export Options | Option whether one or more variables per file should be exported, or a single variable used by MySQL should be exported |
| Selected variables | [Export options: One file per variable, One file with multiple variables] List of variables that can be set for the CSV column |
| Filter | [Export options: MySQL] Filters the selection of logged variables |
| Logged Variables | [Export options: MySQL] Selection of the variable to be exported |
| Create zip file | Checkbox whether the file should be compressed into a zip archive |
| Decimal separator | Select whether point or comma should be used as decimal separator |
| Start of aggregation | Start of aggregation period |
| End of aggregation | End of aggregation period |
| Decimal separator | Selection of decimal separator comma or point. |
| Aggregation Level | Level of Aggregation |
| Export | The aggregated data of the variable will be exported |
| Cyclic send | |
| Enable cyclic send | Activates the cyclical sending of data |
| Interval | Interval at which data is sent. With “Weekly”, data is sent on Monday and with “Monthly”, data is sent on the 1st of the month at the selected time |
| Time | Time at which to send |
| Send by mail | Checkbox whether the data should be sent by mail |
| SMPT instance | Select the e-mail instance |
| Send mail now | Sends a mail manually |
| FTP, FTPS, SFTP | |
| Send via SFTP/FTP/FTPS | Checkbox whether the data should be sent via SFTP, FTP or FTPS |
| Connection type | Connection whether to send via SFTP, FTP or FTPS |
| Host | IP address of the server |
| Port | Port |
| Username | Username for the SFTP connection |
| Password | Password for the SFTP connection |