Table of Contents
...
Associated Data Channels can be created in bulk using a Tag CSV file. However, you can also use the Associated Data Wizard within Sigma. Click on the link for more information.
Creating the File
To create the Associated Data Channels in bulk, you will need to use a Tag CSV File.
...
Associated Data for creating Associated data channels for PPU - Ambulance station.csv
Note: Click then click on to download the CSV file.
...
Remember to save the File as a CSV in order to import it.
...
Column | Requirement |
---|---|
B | Organisation name, ie TRAINING ACADEMY |
D | Site Group name, ie Local Authority Training House |
F | Site name, ie LA Bowling Club Ambulance Station |
H | Account number, ie 654321 20419627 |
I | Commodity, ie Electricity Gas |
K | Associated Data Channel ID (the Data Load ID in the Channel) which has to be unique, ie 654321 Elec PPU Day Rate 20419627 PPU Gas (2201) It is important to add a unique Channel ID (Data Load ID) in order for the Associated Data Channel to be created - each Channel (PPU) will need a unique ID We suggest using the Account Number and the Channel Name, ie 123456 Elec PPU Day Rate. Using just the Account number would not allow you to have 2 Associated Data's under one Account, i.e. PPU Day Rate and PPU Night Rate. |
M | Associated Data Channel Name, (can be the same as the Data Load ID), ie 654321 Elec PPU Day Rate20419627 PPU Gas (2201) |
O | Associated Data Type, ie PPU Elec Day Rateie PPU Gas (2201) |
S | Time Zone, ie Europe/London |
Y | Date and Time to start using this value, ie leave blank if there isn't a end date or use the same format as above, ie 01/04/2021 00:00 |
Z | An end date can be added if applicable (can be left blank) |
AA | The PPU, ie 2 5.65654 (as the multiplier (column U default is 0.01, this will convert pence to pounds) ,meaning 25.65 654 will be 25.65 654 pence) |
Tip: Create a file with one example line in it. Upload the data (as described below). Check that the Channel has been created and that the value has been entered. Then create a file with as many lines as you need.
...
- Right click on the Associated Data Channel to see the details, then click Edit Data to see the Date/Time and Value.
Uploading the CSV File
Once you have created the CSV File, import via the Importing Activity:
...