CSV File Formats for FTP Integration

Interval kWh or numeric value
e.g. Orsis/Navitron

A – “Description”
B – “Name”
C – “Unique Identifier”
D – Date and Time (DD/MM/YY HH:MM:SS)
E – Interval kWh or numeric value

File Name: CSV-Template-Interval-1column-option1.csv

Interval kWh or numeric value

A – Unique Identifier
B – Date and Time (YYYY-MM-DD HH:MM:SS)
C – Interval kWh or numeric value

File Name: CSV-Template-Interval-1column-option2.csv

Interval kWh or numeric value

A – Unique Identifier
B – Date and Time (DD/MM/YY HH:MM:SS)
C – Interval kWh or numeric value

File Name: CSV-Template-Interval-1column-option3.csv

Tab separated
Interval kWh or numeric value

A – Unique Identifier
B – Date and Time (MM/DD/YYYY HH:MM)
C – Interval kWh or numeric value

File Name: CSV-Template-Interval-1column-option4.csv

kWh readings (interval)
e.g. Automated Meter Reading (AMR) – Stark

A – Unique Identifier
B – Date (DD/MM/YY)
C – Description/Name
D – 00:00 to 00:30 – Interval kWh or numeric value
E – 00:30 to 01:00 – Interval kWh or numeric value
F – 01:00 to 01:30 – Interval kWh or numeric value
G – 01:30 to 02:00 – Interval kWh or numeric value
etc until 23:30 to 24:00 – Interval kWh or numeric value

File Name: CSV-Template-Interval-48columns-30mn-option1.csv

kWh readings (interval)
e.g. Automated Meter Reading (AMR) – STCEnergy

A – Code
B – Location Name
C – Meter MPAN
D – Meter serial
E – Read Date
F – 00:00 to 00:30 – Interval kWh or numeric value
G – 00:30 to 01:00 – Interval kWh or numeric value
H – 01:00 to 01:30 – Interval kWh or numeric value
I – 01:30 to 02:00 – Interval kWh or numeric value
etc until 23:30 to 24:00 – Interval kWh or numeric value

File Name: CSV-Template-Interval-48columns-30mn-option2.csv

kWh readings (accumulated and interval)
e.g. Automated Meter Reading (AMR) – Total Gas & Power Ltd

A – Consumer Name
B – MPRN
C – MPRN Alias
D – Site
E – AMR Schedule
F – Read Date (DD-Month-YYYY)
G – Accumulated Reading
H – Consumption Profile Date (DD-Month-YYYY)
I – Profile Date Consumption
J – 00:00 to 00:30 – Interval kWh or numeric value
K – 00:30 to 01:00 – Interval kWh or numeric value
L – 01:00 to 01:30 – Interval kWh or numeric value
M – 01:30 to 02:00 – Interval kWh or numeric value
etc until 23:30 to 24:00 – Interval kWh or numeric value
Z – Reporting Unit

File Name: CSV-Template-AccumulatedandInterval-48columns-30mn.csv

kWh readings (accumulated and interval)
e.g. Automated Meter Reading (AMR) – ASL Holdings

A – Description/Name
B – Unique Identifier
C – Time and Date (HH:MM:SS DD/MM/YY)
D – Accumulated total on Channel 1
E – Accumulated total on Channel 2
F – 00:00 to 00:30 – Channel 1 interval kWh or numeric value
G – 00:30 to 01:00 – Channel 2 interval kWh or numeric value
H – 01:00 to 01:30 – Channel 1 interval kWh or numeric value
I – 01:30 to 02:00 – Channel 2 interval kWh or numeric value
etc until 23:30 to 24:00 – Interval kWh or numeric value

File Name: CSV-Template-2Channels-AccumulatedandInterval-48columns-30mn.csv