Set Up SFTP

Available from the Pro 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 metering points. 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 deliveries → Add data delivery.
  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 Assigned metering points.

File Format

The file format matches Email & CSV delivery. The default is standard CSV for import: ISO 8601 timestamps with the Vienna offset, a comma as the column separator and a full stop as the decimal separator. You set the layout, the timestamps, the separators and the language of the names in the connection's CSV Format section.

Each file is named after the metering point and the delivery. When a failed delivery is sent again, its file keeps the name and replaces any earlier copy. Each file is uploaded under a .part extension first and renamed once it is complete, so your import never reads a half-written file.

Schedule

In the Delivery Schedule section, use Frequency and Time to set when the CSV files are uploaded: daily, weekly, or monthly. The default is daily at 08: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.