Introduction
...
This example shows how to create Floor Area in bulk, using a Tag CSV File
Creating the File
To create the Associated Data Channels in bulk, you will need to use a Tag CSV File.
...
Below is an example CSV File format. Use this example to create your own CSV file, but remember to delete the top row! name View file
Associated Data for creating Associated data channels for PPU (1).csv
Note: Click then click on to download the CSV file.
...
Column | Requirement |
---|---|
B | Organisation name, ie DEMO |
D | Site Group name, ie LOCAL AUTHORITY |
F | Site name, ie LA Bowling Club |
H | Associated Data Channel ID (the Data Load ID in the Channel) which has to be unique (see notes below), ie LA Bowling Club Floor Area It is important to add a unique Channel ID (Data Load ID) in order for the Associated Data Channel to be created - each Channel (Floor Area) will need a unique ID. We suggest using the Site Name and the Channel Name, ie Validator Training Floor Area. Using just the Site Name would not allow you to have 2 Associated Data's under one Site, i.e. Floor Area and Occupancy. |
J | Associated Data Channel Name, ie LA Bowling Floor Area |
L | Associated Data Channel Name, ie Floor Area |
N | Asset Type (optional), ie Fiscal Grid Import |
P | The Floor Area unit, ie m2 |
R | Date and Time to start using this value, ie 10/04/2017 00:00 (typed in exactly this format) |
S | Date and Time to stop using this value, ie leave blank if there isn't an end date or use the same format as above |
T | Floor Area value, ie 1000 (1000 m2) |
...
) |
...
Loading the above details, will create an Associated Data Channel underneath the Site.
...