Table of Contents |
---|
...
Creating the Tag CSV File for Monitoring
...
Points
If you want to set individually monthly figures, you can create the Budget, then use the Importing Activity to add the figures.
It is important to fill out the CSV correctly to avoid creating incorrect data. Use the below guide to help you:
- The Black writing indicates the Tags or default values (Do NOT change)
- The Red writing indicates data that you will need to add
Note: The file can have as many rows as you need.
Remember to save the File as a CSV in order to import it.
...
Monitoring Point Example Tag CSV File
View file
Example Import CSV File for importing Budgets using Monitoring Points (v2).csv
Note: Click Click on the above link, then click then and click on to download the CSV file.
Explaining the Tag CSV File
...
Column | Requirement |
---|---|
Column B, Row 1 | Organisation name |
Column B, Row 2D | Site Group Name |
Column B, Rows 3 onwardsF | Site Name |
Column DH | Monitoring Point Name (same as Column G)K |
Column FJ | Budget Group Name |
Column GK | Monitoring Point Name (same as Column DH) |
Column IM | Target (leave blank if you want to use the same figure as the Budget |
Column JN | Start Date of the Budget |
Column KO | End Date of the Budget |
Columns L P to WAA | The monthly Budget figures |
Creating the Tag CSV File for Monitoring Points in more than one Site Group
...
Importing the Tag CSV File
...