FTP-import File Specifications

EnergyID can read your measurements via FTP. The directory and file structure has to be such so that it can be automatically detected by EnergyID.

1. Directory structure

In the main directory (root), create a sub-directory per record. You have to select this sub-directory later when configuring the integration, so the system knows where to find your files.

2. Naming the files

Each file that contains measurements needs to have a file name that starts with the SiteCode: a unique name for each record. You are free to choose the name.

Per sub-directory, the system expects one CSV-file per day. The file name of this CSV-file has to be structured like SiteCode_YYYY-MM-DD.CSV, where SiteCode is the unique name of the record, and YYYY-MM-DD is the date in ISO8601 notation, ie. 2015-11-10.

Example, for a record with the name Mainstreet55:

           Mainstreet55_2015-11-10.CSV

           Mainstreet55_2015-11-11.CSV

           etc.

3. Structure of the CSV-files

Use these CSV-conventions:

Decimal: “.”

Seperator: “,”

Thousands: none

TimeStamp: YYYY-MM-DD hh:mm:ss (local time)

Option 1: Multi Column CSV

The first column is a TimeStamp, followed by a column per meter. The header of each column that contains measurements, is a unique MeterCode, that will be coupled with a meter in the integration configuration.

Example:

Timestamp,MeterCode1,MeterCode2

2015-11-01 00:00:00,4361.45,2057.67

2015-11-01 00:15:00,10153.23,3407.34

2015-11-01 00:30:00,15945.01,4757.01

Option 2: Single Column CSV

The first column is a TimeStamp, the next column is the unique MeterCode which you have to couple to a meter later during the integration configuration. The last column contains the measurements.

Example:

Timestamp,MeterCode,Value

2015-11-01 00:00:00,MeterCode1,2057.67

2015-11-01 00:15:00,MeterCode1,3407.34

 

2015-11-01 00:00:00,MeterCode2,21736.79

2015-11-01 00:15:00,MeterCode2,27528.57