A SFTP Integration exports a CSV File over SFTP protocol once a day.
The export will use the CSV Format field from the DeviceTypes Tableconfig to define the columns of the csv. (For Details about Table Confog see: Table Config)
The export will create one CSV file per DeviceType. Named as exportTime_DeviceType.csv. (2021-02-18_15-31_Lobaro-NB-IoT-wMBus-Gateway.csv)
The export will be executed once a day at the configured time. It will Export all Data from devices matching the filter since the last successful export.
| Config Param | Examples | Comment |
|---|---|---|
| Target Host/IP Adress | example.com 127.0.0.1 | Domain or IP Adress for your SFTP Server |
| Port | 22 | Port your server uses. Default for SFTP is 22. |
| Path on Server | uploads/lobaro | Directory path to use on the server. The CSV Files will be put into thes directory. When the directory doesn't exist and the user has create rights he will create the folder. |
| Username | foobar | username to login with. Make sure the user has permission to write into the target directory. |
| Password | MySecretPassword2Use | password for the user. |
| Filter | NB-IoT-Gateway-Filter | Filter to use for the integration. (Defined under Integration → Filter) Only Devices Matching the filter will be exported. |
| Time to run | 04:30 | Time to execute the integration daily. |