What data is contained within the CSV file download?

Export CSV Details
Purpose
This feature allows you to download the data that we have logged from your OWL Intuition electricity monitoring on our servers. This data is provided as a Comma Separated Values (“CSV”) file (http://en.wikipedia.org/wiki/Comma-separated_values). This file type can be opened by all common spreadsheet applications such as Excel or Numbers. You can then use these applications to manipulate the data and produce graphs etc. to meet your own specific needs and requirements. Please note OWL are unable to support you in doing this.
Date range
You can enter any start date and then select an end date up to 1 month later. If you need to cover a longer date range than this you will need to download multiple files, each up containing up to 1 month of data. If required these files can be combined using your spreadsheet application.
Data retention
The OWL Intuition servers will store and provide data at full 12 - 60 second resolution covering the prior 4 months. Between 4 and 13 months data will be stored and provided at daily resolution. Therefore if you wish to keep full resolution data for your own records you must download before the resolution is reduced to daily – if this is your requirement we recommend doing a CSV download once a month.
Data fields
The data consists of several columns of data fields, with one line of data for each data packet received from your Transmitter. Each column has a heading and the meaning of each heading is provided in the table below.
Important Notes:
• A full month of data is likely to be many tens of thousands of lines of data. This may take a while (potentially minutes) to create and download. Please be patient!
• Your system may not have / use all three Transmitter Sensor inputs.
• If you have a 3 channel CMR119 Transmitter then unfortunately the 3 channels are aggregated into a single value at the Transmitter. This value is shown in ‘curr_chan1’ and ‘day_chan1’ fields.

Column Heading

Description

Format / Units

timestamp

Date and Time

yyyy-mm-dd hh:mm:ss

curr_property

Live Electricity Consumption Power (Aggregated for all consumption channels)

Watt

curr_property_cost

Live Electricity Consumption Cost (Aggregated for all consumption channels)

Monetary sub units, eg, Pence or Cents

day_property

Accumulated Electricity Consumption Power since midnight (Aggregated for all consumption channels)

Watt/hour

day_property_cost

Accumulated Electricity Consumption Cost since midnight (Aggregated for all consumption channels)

Monetary sub units, eg, Pence or Cents

curr_solar_generating

Live Solar PV Generated Power

Watt

curr_solar_export

Live Solar PV Exported Power

Watt

day_solar_generated

Accumulated Solar PV Power Generated since midnight

Watt/hour

curr_chan1

Live Sensor 1 Power

Watt

curr_chan2

Live Sensor 2 Power

Watt

curr_chan3

Live Sensor 3 Power

Watt

day_chan1

Accumulated Sensor 1 Power since midnight

Watt/hour

day_chan2

Accumulated Sensor 2 Power since midnight

Watt/hour

day_chan3

Accumulated Sensor 3 Power since midnight

Watt/hour

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk