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

Related posts

See more entries

Wattics and Wattwatchers partner to deliver advanced level IoT energy management solutions

  Wattics is pleased to officially announce its partnership with Australian digital energy company, Wattwatchers, to deliver IoT-enabled energy…

Read more
Energy Wastage in the Retail Sector – A Modern Solution

Traditional methods of survival have already been deployed such as wage cuts, roster changes and job losses. In an industry seeking a quick fix, short…

Read more
Upload electricity data to your Wattics platform through CSV files

A video tutorial to upload electricity data to your Wattics platform through CSV files…

Read more
Get your energy data to Wattics via FTP

Having the right energy management tools helps develop effective strategies to reduce energy use and uncover operational and mechanical…

Read more
Using Wattics to Achieve the ISO 50001 Energy Management Standard

Discover how the powerful features of the Wattics Energy Management Software can be effectively used to achieve the ISO 50001 certification for your…

Read more
Choosing the Best Energy Conservation Software & Tools

There is not one single data acquisition solution that fits all projects. The need to understand unique project requirements will drive the selection…

Read more

Sign up to our blog posts

Sign up to keep up-to-date with what’s happening within the industry

Energy Learning
community online

Be part of the big picture, share your knowledge and get access to experience and expertise from others

Visit our forums