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

 

 

 

Related posts

See more entries

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
ISO 50001 Energy Management Software Standard, Certification & Requirements

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

    Technology Update

    Check out our latest offering:

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