Column Name | Definition | Location in N-PEARS | Helpful Notes |
external_story_id | Unique numeric identifier for each story | | Create any number that is unique to reference the Success Story. NOTE: If you re-import the template for the same report, and reuse these identifiers, ensure the identifiers match the intended stories that were already imported. Any story with the same identifier will be updated with the new story name and other information. |
title | Title of the story | Success Stories > Success Story Name | |
external_site_ids | Unique numeric identifier for each site | Success Stories > Success Story > Sites and Indicators > Site(s) or Organization(s) | This number should be the same unique number you used to reference this site in the sites sheet |
other_sites | Name of any site not listed | Success Stories > Success Story > Sites and Indicators > Other Sites | |
location | Location of the story | Success Stories > Success Story > Background > Location | |
description | Description of the story | Success Stories > Success Story > The Story > Project/Nonproject Activity Description |
narrative | Narrative of the story | Success Stories > Success Story > The Story > Story Narrative | |
quote | Quote from the story | Success Stories > Success Story > The Story > Favorite Quotes | |
projects | A comma separated list of project names | Success Stories > Success Story > Background > Report Projects | If this does not exactly match projects in the system, it will create a new project. |
activities | A comma separated list of activity names | Success Stories > Success Story > Background > Report Activities | If this does not exactly match activities in the system, it will create a new activity. |
partner_types | Type(s) of partner organization | Success Stories > Success Story > Background > Types of partners involved | These values will need to match the keys indicated in the partner_types section of the Key Mapping sheet. |
related_indicators | Related indicator(s) | Success Stories > Success Story > Sites and Indicators > Related Framework Indicators | These values will need to match the keys indicated in the Indicators section of the Key Mapping sheet. |