CSV File Formats for FTP Integration // Wattics Energy Management Software

CSV File Formats for FTP Integration

ftp

Download the CSV Template

Format 1Interval kWh or numeric value
e.g. Orsis/NavitronA – “Description”
B – “Name”
C – “Unique Identifier”
D – Date and Time (DD/MM/YY HH:MM:SS)
E – Interval kWh or numeric valueFile Name: CSV-Template-Interval-1column-option1.csv

 

 

 

Download the CSV Template

Format 2Interval kWh or numeric valueA – Unique Identifier
B – Date and Time (YYYY-MM-DD HH:MM:SS)
C – Interval kWh or numeric valueFile Name: CSV-Template-Interval-1column-option2.csv

 

 

 

Download the CSV Template

Format 3Interval kWh or numeric valueA – Unique Identifier
B – Date and Time (DD/MM/YY HH:MM:SS)
C – Interval kWh or numeric valueFile Name: CSV-Template-Interval-1column-option3.csv

 

 

 

Download the CSV Template

Format 4Tab separated
Interval kWh or numeric valueA – Unique Identifier
B – Date and Time (MM/DD/YYYY HH:MM)
C – Interval kWh or numeric valueFile Name: CSV-Template-Interval-1column-option4.csv

 

 

 

 

Download the CSV Template

Format 5kWh readings (interval)
e.g. Automated Meter Reading (AMR) – StarkA – 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 valueFile Name: CSV-Template-Interval-48columns-30mn-option1.csv

 

 

 

Download the CSV Template

Format 6kWh readings (interval)
e.g. Automated Meter Reading (AMR) – STCEnergyA – 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 valueFile Name: CSV-Template-Interval-48columns-30mn-option2.csv

 

 

 

Download the CSV Template

Format 7kWh readings (accumulated and interval)
e.g. Automated Meter Reading (AMR) – Total Gas & Power LtdA – 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 UnitFile Name: CSV-Template-AccumulatedandInterval-48columns-30mn.csv

 

 

 

Download the CSV Template

Format 8kWh readings (accumulated and interval)
e.g. Automated Meter Reading (AMR) – ASL HoldingsA – 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 valueFile Name: CSV-Template-2Channels-AccumulatedandInterval-48columns-30mn.csv

 

 

 

Sign up to our blog posts

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

    Technology Update

    Check out our latest offering:

    “WatticsAir – Air Quality Monitoring and Analytics”
    Go to page