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
Consumption ID - this is the Data Load ID field in the Consumption Data Editor
This number is unique to any other Consumption Data Channel.
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
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
Consumption Value for the above period, for example: 200
Downloading the CSV sample File
Saving the completed CSV File
- Save the File as a CSV File to ensure it can be imported
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
- Open the Importing Activity
- Click Run Now
Note: If the Consumption Data Importer CSV Importer is not in your favourites list, you need to add it using the green +
- From the Favourites list, highlight Consumption Data Importer CSV
- Click Next to move to the Importing Options
From the Importer Options section, tick or untick as necessary.
- Tick Has header row If your CSV has a header row
- Tick Add day to date to use the beginning of the FromDate to the end of the ToDate
- For example, the highlighted line below will import as the beginning of the 01/02/21 to the end of 28/02/21
- Untick Add day to date to use the beginning of the FromDate to the beginning of the ToDate
- For example, the highlighted line below will import as the beginning of the 01/02/21 to the beginning of 28/02/21
- Click Next to move to the Source Options
- From Source Options, click Upload File
- Choose the file and click OK
- Click Next
- From the Finish tab, click Run Now
- Click Finish to complete the process
Refreshing the Importing Activity
Once you have clicked Finish, you can refresh the Activity to see if the File has imported successfully.
- Click Refresh in the Run History pane
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.
- From the Run History, right click on the Import and click Download Log File
- Highlight the Import and click the Download Log File icon
Example Log File
- An example Success Import
Example Validation Warning - Value will be imported
- An example Warning where the Value is greater than the existing daily average
- This Value will be saved into the Consumption Channel
Example Validation Failed - Value will not be imported
- An example Failure where the date of the Value is in the future
- This Value will NOT be saved into the Consumption Channel
Viewing the Data
Once the data has been imported it can be viewed in the Consumption Data Channel
- Right click on the Consumption Data Channel and click Edit
- Click Show Data
- The Data Viewer will show all existing Values and the new Values that you have imported
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:
- Imported with the Add day to date UNTICKED