Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

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! View filename


Associated Data for creating Associated data channels for PPU (1).csvheight250


Note:  Click  then click on to download the CSV file.

...

ColumnRequirement
BOrganisation name, ie DEMO
DSite Group name, ie LOCAL AUTHORITY
FSite 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.

JAssociated Data Channel Name, ie LA Bowling Floor Area
LAssociated Data Channel Name, ie Floor Area
NAsset Type (optional), ie Fiscal Grid Import
PThe Floor Area unit, ie m2
RDate and Time to start using this value, ie   10/04/2017 00:00  (typed in exactly this format)
SDate and Time to stop using this value, ie   leave blank if there isn't an end date or use the same format as above
TFloor Area value, ie 1000  (1000 m2)

...

)

...



Loading the above details,  will create an Associated Data Channel underneath the Site.         

...