User Tools

Site Tools


data_template

This is an old revision of the document!


Manage Data Template

Overview

  • This section enables Administrator users to customise the CSV template used by everyone in the organisation to upload bulk data.
  • Administrator users can add/remove fields from the CSV template
  • Administrator users can reorder the position of the fields in the CSV template
  • A unique CSV template is saved for each organisation.
  • Any changes to this template will affect all users for the organisation.
  • Any data file uploaded by a user in the Manage Upload Data section which is not in line with the organisation's CSV template will receive an error “Bad File”.

How to download the current CSV Template

Steps:

1. Navigate to Admin menu > Global Settings > Manage Data Template

2. Click on “Generate CSV Template” blue text in the top right hand corner.

3. A CSV file will download in your browser. This CSV file will simply contain 1 row of data headers.

4. Save this CSV file (in CSV format) on your desktop for future use.

2. The table that immediately appears includes all potential fields that can be added in the data template. There are 6 compulsory fields that must always be included in the data template (these will be automatically ticked).

The 6 compulsory fields are: a) Contribution (i.e. the consumption amount) b) Contribution_Unit (i.e. the unit of measure the consumption amount is reported in) c) Division (i.e. the “EntityID” of the entity you wish to add to the data to) d) Emission_Profile_Source (i.e. the “EmissionSourceID”of the emission source you wish to add the data to) e) End_Date (i.e. the last day of the period the data relates to) f) Start_Date (i.e. the first day of the period the data relates to)

3. After you

data_template.1423091809.txt.gz · Last modified: 2020/09/25 09:53 (external edit)