Set Up SFTP

Available from the Business plan.

The SFTP connection type uploads your meters' readings as a CSV file to an SFTP server, on a schedule you choose. This suits systems that read files from a directory rather than receiving them by email: energy management software, a data warehouse, or an accounting system with an import folder.

As with Email & CSV delivery, each delivery contains the previous day's values (T-1) for the assigned meters. The difference is the delivery path: an upload to a server instead of an email attachment.

Set Up a Connection

SFTP configuration: host, port, username and password, target path, plus the CSV format and a preview of the uploaded file.
SFTP configuration: host, port, username and password, target path, plus the CSV format and a preview of the uploaded file.
  1. Go to Data → Data Outputs → New Data Output.
  2. Select the type SFTP.
  3. Configure the connection:
Field Description
Host Server hostname, without a protocol prefix (e.g. sftp.example.com)
Port Default: 22
Username SFTP username
Password SFTP password. Username and password are stored encrypted.
Path Target directory on the server (default: /)
  1. Save the connection and assign the meters you want under Routes.

File Format

The file format matches Email & CSV delivery: UTF-8 with a configurable column and decimal separator. The default is the Austrian convention (semicolon as the column separator, comma as the decimal separator), compatible with Microsoft Excel and LibreOffice Calc.

Schedule

In the Delivery schedule section, set when the CSV files are uploaded: daily, weekly, or monthly. The default is daily at 06:00 (local time).

Notes

  • If the upload fails 5 times in a row, the connection is deactivated and you receive a notification. Status and error details are available under Delivery Logs & Errors.
  • For delivery as soon as new data arrives instead of on a schedule, use Webhooks or MQTT.