Sign up for our e-newsletter:
Name:
Email:
Company Name:
newsletter

Back to help Back to help contents

Settings - importing data

tl
tr
What does the import data function do?

If you are using any third party meters and would like to import the data you can do so using this method.
How do I import data?

Step 1 - Create CSV file

To import the data you must create a comma separated value file, also known as CSV. You can do this in any spreadsheet package (e.g. Excel) or in a text editor (e.g. Notepad).

Data can be imported for any hour and must be in the following format:

unique meter reference, year, month, day, hour, field identifier, value, cost, co2

Field Value
Unique meter reference This is a numeric value that can be up to 12 digits long. It should be unique for each of the meters for which you are importing data.
Year This refers to the year the reading is from and should be in format 'YYYY' e.g. 2011.
Month This refers to the month the reading is from and should be in format 'MM' e.g. 12 for December.
Day This refers to the day the reading is from and should be in format 'DD' e.g. 02 for the 2nd of the month.
Hour This refers to the hour the reading is from and should be in format 'HH' e.g. 00 for 12am.
Field identifier There are 2 options you can use: 'energy_delta' or 'energy_cumulative'.

'energy_delta' is used for importing how much energy was used during that hour e.g. 11.01 kWh.

'energy_cumulative' is used for importing an aggregrated amount of energy used so far, e.g. 102 kWh has been used since the meter was installed. The system will then check the last record to calculate the delta value, therefore it is important to enter the data in chronological order from top to bottom.
Value The value is dependent on the field identifier you have chosen. For energy the value is in kWh.
Cost Enter the cost incurred for the amount of energy used (leave as 0 if you do not know this value).
CO2 Enter the CO2 generated for the amount of energy used (leave as 0 if you do not know this value).

A sample CSV file looks like this (feel free to copy and paste this code as a starting point):

Unique meter reference (up to 12 digits),Year,Month,Day,Hour,Field Identifier,Value,Cost,CO2 12341234,2011,3,14,1,energy_delta,10.236,1.12596,5.803812 12341234,2011,3,14,2,energy_delta,11.236,1.23596,6.370812 12341234,2011,3,14,3,energy_delta,12.236,1.34596,6.937812 12341234,2011,3,14,4,energy_delta,13.236,1.45596,7.504812 12341234,2011,3,14,5,energy_delta,14.236,1.56596,8.071812 12341234,2011,3,14,6,energy_delta,15.236,1.67596,8.638812 12341234,2011,3,14,7,energy_delta,16.236,1.78596,9.205812 12341234,2011,3,14,8,energy_delta,17.236,1.89596,9.772812 12341234,2011,3,14,9,energy_delta,18.236,2.00596,10.339812 12341234,2011,3,14,10,energy_delta,19.236,2.11596,10.906812 12341234,2011,3,14,11,energy_delta,20.236,2.22596,11.473812 12341234,2011,3,14,12,energy_delta,21.236,2.33596,12.040812 12341234,2011,3,14,13,energy_delta,22.236,2.44596,12.607812 12341234,2011,3,14,14,energy_delta,23.236,2.55596,13.174812 12341234,2011,3,14,15,energy_delta,24.236,2.66596,13.741812 12341234,2011,3,14,16,energy_delta,25.236,2.77596,14.308812 12341234,2011,3,14,17,energy_delta,26.236,2.88596,14.875812 12341234,2011,3,14,18,energy_delta,27.236,2.99596,15.442812 12341234,2011,3,14,19,energy_delta,28.236,3.10596,16.009812 12341234,2011,3,14,20,energy_delta,29.236,3.21596,16.576812 12341234,2011,3,14,21,energy_delta,30.236,3.32596,17.143812 12341234,2011,3,14,22,energy_delta,31.236,3.43596,17.710812 12341234,2011,3,14,23,energy_delta,32.236,3.54596,18.277812 12341234,2011,3,14,0,energy_delta,33.236,3.65596,18.844812

The first row should stay intact and will be ignored when importing.

Step 2 - Go to the import page
Import CSV page

Log in to the account you wish to import the data to and then navigate to 'Settings' > 'Import data'.

Step 3 - Upload file and import data
Import CSV upload file

Now you have created your CSV file and populated it with data you must upload the file and import the data.

To do this click on the 'Browse' button to open a file browser, navigate to the CSV file on your computer and select it.

Click on the import button to begin the import process. It may take a minute to process depending on the amount of data you are importing.

Do not refresh the page or close the window until the process has finished. Doing so could result in data being imported twice or not all records being imported.

Step 4 - View the imported data
Import CSV success

When your data has finished importing you will see a success message.

You will be able to locate the meter by going to 'Settings' > 'Sockets' and then look for a meter called 'Imported meter' followed by the unique reference (you can change the name of the meter once in the system by clicking on the name).

The meter will show up in the reports as usual and can be assigned to groups and given a device type.

Troubleshooting

Why do I have a new controller on my account?

For a meter to be associated to an account it must be linked to a controller. When you do an import a new controller called 'Virtual Controller' with be added to your account. This is normal and ensures that only users of your account can view the data you have imported.

I am getting lots of errors - what should I do?

If there is an error on a line the system will skip it and move on to the next line.

Go through each error and correct the CSV file. If you still have any issues, send the CSV file to us and details of what is happening.

I have accidentally imported the wrong data and have strange values on my account - what should I do?

You can use the 'Reset historical data' function in the 'Settings' menu to delete data for a specific meter and then try to import the correct data.
bl
br
Energy Institute

Contact Us | Privacy Statement

© Copyright 2007-2012 Enistic Limited. All rights reserved. Patent Pending.