Importing Comments to Initiatives
Step 1. Download data templates for importing comments
To begin the import process you’ll first need to download the comments templates provided below.
This template is an empty CSV sheet ready for you to start populating with data.
Step 2. Populate with comment data
Using the template provided you can add comment data for one or multiple initiatives.
Things to consider when populating comment data.
To import data successfully, there are fields that must match - EXACTLY - to the data already in your Transition Card.
*The name of your Transition Card
*The name/s of your initiatives
Comments for multiple initiatives
You can add comments for multiple initiatives in one upload by adding additional initiatives columns to the CSV template.
To do this simply:
1. copy the initiative column and paste in the next column
Repeat as required.
Step 3. Import comment data
Before you import, you'll need to get your file ready, by:
1. Ensure that the titles of the Transition Card and Initiatives are an exact match to the information already in the Tool
2. Ensure it is saved as a .CSV file
To begin the Comment import process:
1. Go to the Transition Card Page
2. Select + Import Comments
From here you will need to select the file you wish to import.
Once your file has been successfully imported you will be able to see in your Transition Card:
new initiative characteristics ticked off and comments saved
existing initiative characteristics that have new / updated comments have been saved
If upon importing there were errors with your data, you will see a message like this.
This table highlights the rows and cells where data does not match.
In the first row there will be a message that will tell you the error that need to be corrected - for example Initiative "School Breakfast' Invalid.
You will need review each of these to ensure they are an Exact Match to the names in the Transition card, save these changes and then reimport amended records.
Records without errors will have been imported successfully