Troubleshooting Annual Report Data Import

Overview National PEARS offers a data importer to ease data entry. When an error prevents the document from importing, the system will provide a variety of notifications to assist with completion of the document.  Clicking Download file with errors will download a spreadsheet that notates the issues preventing the importer from completing. Hovering over the red … Read more

Annual Report Data Import – Coalitions

Column Name Definition Location in N-PEARS Helpful Notes external_coalition_id Unique numeric identifier for each coalition   Create any number that is unique to reference the Coalition throughout the template. It does not matter what number you use, as long as it is not already used in this sheet. name Name of the coalition Coordination and … Read more

Annual Report Data Import – Success Stories

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 throughout the template. It does not matter what number you use, as long as it is not already used in this sheet. title Title of the story Success … Read more

Annual Report Data Import – Indirect Education

Column Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name If this does not exactly match projects in the system, it will create a new project. languages Language(s) used to deliver this program Project and Activity Results > Project > Indirect Education Channels > Languages Enter the … Read more

Annual Report Data Import – Social Marketing Channels

Column Name Definition Location in N-PEARS Helpful Notes project Project name  Project and Activity Results > Project Name This name must match the project name for this campaign in the Social Marketing sheet. If the project does not match exactly, it will create a new project. external_campaign_id Unique numeric identifier for each campaign   This … Read more

Annual Report Data Import – Social Marketing Segments

Column Name Definition Location in N-PEARS Helpful Notes project Project name  Project and Activity Results > Project Name This name must match the project name for this campaign in the Social Marketing sheet.  If the project does not match exactly, it will create a new project.  external_campaign_id Unique numeric identifier for each campaign   This … Read more

Annual Report Data Import – Social Marketing

Column Name Definition Location in N-PEARS Helpful Notes project Project name  Project and Activity Results > Project Name If this does not exactly match projects in the system, it will create a new project.  external_campaign_id Unique numeric identifier for each campaign   Create any number that is unique to reference this campaign throughout the template. … Read more

Annual Report Data Import – PSE Partners

This information will filter into Active Partners within a Project in the Projects and Activities module. Column Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name If this does not exactly match projects in the system, it will create a new project.  partner_type Type of partner organization … Read more

Annual Report Data Import – PSE Changes

Each row in Excel represents one PSE Change. To report multiple PSE changes for a site, create a new row for each PSE Change. Column Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name If this does not exactly match projects in the system, it will create … Read more

Annual Report Data Import – Direct Education

This information will filter into Direct Education within a Project in the Projects and Activities module. * denotes required field Column Name Definition  Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name If this does not exactly match projects in the system, it will create a new project.  method_in_person … Read more