FTP-import
In EnergyID, you can automatically import meter readings via FTP (File Transfer Protocol). To ensure a smooth process, follow these guidelines:
Folder structure
If you have multiple locations to monitor, you can organize your data by creating subfolders for each location under the FTP root folder. This step is recommended to maintain a structured data hierarchy.
File naming conventions
Create one CSV file per location per day. Ensure that each file follows this naming convention:
SiteCode_YYYY-MM-DD.csv
- SiteCode: Use a unique name or code per location.
- YYYY-MM-DD: Represents the date in ISO8601 format (e.g., 2023-06-10).
For example, for a site named Main Office:
<ftp_root>/MainOffice/MainOffice_2023-06-10.csv
<ftp_root>/MainOffice/MainOffice_2023-06-11.csv
etc.
Choose your CSV-format
We support two different formats: multi-column and single column. The following conventions apply to both formats:
Decimal: "."
Separator: ","
Thousands: none
Timestamp: YYYY-MM-DD hh:mm:ss (in the timezone of the building or location)
Multi-column CSV
The first column represents the Timestamp, followed by one column per meter. To ensure proper identification, the header of each column containing measurement data should correspond to a unique MeterCode. During the integration setup in EnergyID, each MeterCode will be associated with its corresponding EnergyID meter.
Example:
| Timestamp | GAS | ELEC |
|---|---|---|
| 2023-01-01 00:00:00 | 4361.45 | 2057.67 |
| 2023-01-02 00:00:00 | 10153.23 | 3407.34 |
| 2023-01-03 00:00:00 | 15945.01 | 4757.01 |
Single-column CSV
The first column represents the Timestamp, the next column is the unique MeterCode, and the last column is the measurement value.
Example:
| Timestamp | MeterCode | Value |
|---|---|---|
| 2023-01-01 00:00:00 | GAS | 2057.67 |
| 2023-01-02 00:00:00 | GAS | 3407.34 |
| 2023-01-01 00:00:00 | ELEC | 538.01 |
What kind of values do we support?
Each meter reading is characterized by a timestamp and a value. The value can be interpreted in three ways:- cumulative - The actual value of an incremental counter. The value can only reset when the counter reaches its maximum possible value.
- total - The value measured during a time interval. The timestamp indicates the start of the time interval. E.g. 2023-01-01 00:00:00,GAS,45.34 represents a daily consumption of 45,34 kWh on the 1st of January 2023.
- delta - The value measured during a time interval. The timestamp indicates the end of the time interval. E.g. 2023-01-02 00:00:00,GAS,45.34 represents a daily consumption of 45,34 kWh on the 1st of January 2023.