CSV File Formats for FTP Integration

ftp

Download the CSV Template
Format 1

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

Download the CSV Template
Format 2

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

Download the CSV Template
Format 3

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

Download the CSV Template
Format 4

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

Download the CSV Template
Format 5

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

Download the CSV Template
Format 6

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

Download the CSV Template
Format 7

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

Download the CSV Template
Format 8

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

 


+353 (0)1415 1242 | info@wattics.com | Contact us

 

Anthony Schoofs

Chief Technical Officer at Wattics
Anthony drives Wattics' innovation on energy efficiency for industrial and grid environments. Anthony is also behind WSNbuzz.com, a blog covering technology advances within the smart grid and IoT markets, and was listed in 2011 amongst the top 100 IoT thinkers. Anthony was recently awarded the Globe Sustainability Research Award for his contribution to advancing knowledge on sustainability.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>