Consumption Data is generally used for Scope 3 reporting.  It is added into the Consumption Data Channel and then used in Energy Intelligence for reporting on.

If you want to add them in manually, move to the Entering Consumption Data Values in manually  page.


This page shows how to enter Consumption Data Values in bulk:


Creating the Import CSV File

You can have more than one Value and more than one Channel in the CSV File.

The CSV File will need to look like this:

This example has 12 Consumption Values for one Consumption Data Channel and the Columns are explained below.

You can have more than one Channel in a CSV File, add lines for your data for the first Channel, then your second, third etc

 


ColumnDescription
A

Consumption ID - this is the Data Load ID field in the Consumption Data Editor

This number is unique to any other Consumption Data Channel.

B

From Date  - relating the Consumption Value.  This needs to be in the following format:  01/01/2020  

Note: Sigma uses the beginning of this date 

C

To Date - relating the Consumption Value.  This needs to be in the following format:  31/01/2020

Note: Sigma uses either the beginning or end of this date, depending on the options chosen below - see Importing Options

D

Consumption Value for the above period, for example:  200

Downloading the CSV sample File

Saving the completed CSV File

Note: Before saving your data, remove the example line

Importing the File

Choosing the Importer

The File is imported using the Consumption Data Importer CSV  Importer, in the Importing Activity

Note:  If the Consumption Data Importer CSV Importer is not in your favourites list, you need to add it using the green +

         


Importing Options

From the Importer Options section, tick or untick as necessary.

         


                   


OR

Source Options

         



Refreshing the Importing Activity

Once you have clicked Finish, you can refresh the Activity to see if the File has imported successfully.

         


Checking for any Validation Issues

Once the File has imported and shows in the Run History, we recommend you check the Log File to see if there are any Validation issues.

Alternatively 

         


Example Log File 

Successful Import

         

Example Validation Warning - Value will be imported

         

Example Validation Failed - Value will not be imported

         

Viewing the Data

Once the data has been imported it can be viewed in the Consumption Data Channel

                       



Common Importing Error

If you create the CSV using the below formula and then UNTICK the Add day to date, the data will not import correctly: