Bulk Imports

Users have the option to make many kinds of changes to their DevResults site in one place by using the Bulk Imports page. Additions of activities, indicators, locations, targets, and more can be done by completing and importing Excel templates. Most of the templates on this page can be accessed on the index page for each part of the system, but there are two tools that offer functionality not found elsewhere in DevResults: uploading assignments of users to activities, and uploading targets for multiple indicators at once. This article covers how to use the Bulk Imports page and things to consider when doing so.

Note: This page is currently only available to users who belong to permissions groups with the Owner role enabled.

Using the Bulks Import Page

The Bulk Import page can be found under the Tools > Bulk Imports


The Bulk Imports index page supports additions for:

  • Activities 
  • Users
  • Indicators
  • Locations
  • Organizations
  • Reporting Periods
  • Result Frameworks
  • Disaggregations 
  • Activity Roles
  • Indicator Targets

To add new activities (for example):

  1. Click on the Download Blank Template button in the activities section. Fill out the Excel template with new activities and save it. 
  2. Import the completed template by clicking on the Import Activities button and choosing your edited file. 
  3. Note: The Activities Index button takes you to the list of all of your activities. Navigate to this page if you want to access an activity or make edits to activities. 

Each section of the Bulk Imports page provides an different excel template that can be downloaded and populated with new information. For example, when adding multiple new disaggregations, download the blank template in the Disaggregations section. This template is same as the template you can download from the Disaggregations page, and can be uploaded in either place. The same is true for each template and the index page for that kind of information.

Back to top

Assigning Users to Activities

The Activity Roles section provides an import option not available elsewhere in DevResults. There are other easy tools for assigning users to activities, but this template enables you to use an Excel import to assign multiple users to multiple activities. 

In this template: 

  • Each row should contain the assignment of one user to one activity. Add as many rows as necessary for multiple users for an activity, or multiple activities for a user. 
  • The Role column is optional: this can be used to describe an individual's responsibility with regard to that activity. While someone's job title might be "Senior M&E specialist", their role for a particular activity might be "Reviewer", for example.

In this example, we're assigning three users to "Access to School Lunches" and two users to "Bednets Distribution Program". Aboubacar will be assigned to both activities:

Back to top

Importing Targets for Multiple Indicators

The Targets section provides an import option not available elsewhere in DevResults. While users can import targets for an individual indicator on that indicator's targets tab, this template enables you to use an Excel import to  assign multiple targets to multiple indicators and activities at one time. 

In this template: 

  • Each row should contain a single target for a single indicator for a particular date. (The date should align with the end of a reporting period.) 
  • The Activity column should be left blank for 1) global targets or 2) indicators not reported per activity. 

In this example, we're assigning targets to two indicators: 4.1 and 4.2. 

  • Indicator 4.1 will have 3 global targets, one for each of 3 different quarters
  • Indicator 4.1 will have:
    • 3 global targets
    • 3 activity targets for the Access to Learning activity
    • 3 activity targets for the Ed-Change activity

Note: Targets should be entered incrementally (the goal for just that period) or cumulatively (the total goal up to that point) depending on how target entry is defined for that indicator on the indicator's definition page.

Back to top

Didn't answer your question? Please email us at help@devresults.com.