If you need to add many new activities at once, instead of creating an activity individually, you can create multiple new activities in bulk by uploading a spreadsheet.
For the bulk import, you can upload all elements displayed in the index page for that activity except for:
- Any of the columns relating to its Partner Organizations (Primary Contact, Primary Organization, Partner Type, Phone, Fax, Email, Address)
- Any of the columns relating to its Budget, since these are calculated from Budget entries (Budget, Obligated, Disbursed, Remaining, Budget (Local), Obligated (Local), Disbursed (Local))
You can use this functionality to:
- Create new activities in bulk (enter new rows in the spreadsheet; anything without an awardID gets added)
- Edit existing activities in bulk (edit the spreadsheet as-is; anything with an awardID gets updated)
To create new activities in bulk, first go to Activities to open the Activities Index page.
On this page, use the gear button in the upper right corner to select the activity columns you want to use:
Once you have the columns you'd like, click the gear button and select "Export" to get an Excel template of all your existing activities:
You can delete all the rows from the export, but it's not necessary. Add the rows for your new activities at the bottom with a blank awardID:
(The five rows highlighted with no awardID are the new activities this import will create.)
For new rows in the spreadsheet:
- You can enter multiple Sectors separated by commas, for example: "Health, Education". These need to already exist in your site.
- You can enter multiple Tags separated by commas, for example: "Training, Engagement". These need to already exist in your site.
- Awarding Organization needs to reference an organization that already exists in your site.
Once you have your spreadsheet updated and saved with the new activities you want to add, click the gear icon again and select Import:
This will open a pop-up window to walk you through the upload process:
You can click the Choose file button to browse to the file or drag the file from your computer directly into this box and drop it here. The system will evaluate the spreadsheet for any invalid fields; it will warn you if it finds any problems with the sheet. If everything looks fine, you'll get a confirmation showing how many activities it found and will import:
(In this case, I'm seeing 12 activities because I left all of my existing activities in my sheet. Since I didn't make any changes to them, this is fine.) If the number for import looks wrong to you or you get errors that you need to fix, click the Clear upload button to remove the file, go edit and save it again, and then restart the process.
Once everything looks good, click the Continue button to complete the import:
You'll get a confirmation message once the import is complete; click the Done button to close it.
Once you click Done, your Activities Index page will refresh and you'll see your new activities there!
You can also use this tool to complete bulk updates to existing activities. To do so, follow the first few steps to download your Activities Index into Excel. Then edit the spreadsheet that you downloaded--for example, to add a new Sector or Tag to the Activities.
When you import the spreadsheet, it will update the activities in place.
Didn't answer your question? Please email us at firstname.lastname@example.org.