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.
 
Downloadable template:

 

comments_upload_template.csv  

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.
 
These include:
*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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Reviewing errors. 
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 

screen-shot-2019-02-07-at-10-19-28-am_1_orig.png
screen-shot-2019-02-11-at-3-12-25-pm_orig.png
screen-shot-2019-02-11-at-3-09-45-pm_orig.png
screen-shot-2019-02-11-at-3-13-36-pm_orig.png
screen-shot-2019-02-07-at-10-13-34-am_orig.png