Versions Compared

Key

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

Table of Contents

...

Accounts Example Tag CSV File

Image RemovedImage Added

                                                                Image RemovedImage Added


Example Import CSV File for importing Account with different Site Groups.csv

Note:  Click on the link above, then click Image Modified and click on Image Modifiedto download the CSV file.


Explaining the Tag CSV File

Image RemovedImage Added

                                                                Image RemovedImage Added



Column/RowRequirement
Column BOrganisation name, ie TRAINING ACADEMY
Column DSite Group Name, ie Local Authority
Column FSite Name, ie LA Dixon Control Centre
Column HAccount Number (same as Column L), ie 1005682
Column ICommodity, ie Electricity
Column KBudget Group Name, ie Budget 20/21
Column LAccount Number (same as Column H), ie 1005682
Column NTarget (leave blank if you want to use the same figure as the Budget, ie -5
Column OStart Date of the Budget, ie 01/04/2020
Column PEnd Date of the Budget, ie 01/04/2021
Columns Q to ABThe monthly Budget figures, ie 6975.68

Importing the Tag CSV File

...