Bulk Uploading Connections with the Apex Data Loader
The Apex Data Loader is currently the only way to bulk upload Connections into HandsOn Connect. This walks you through connecting a list of Contacts to a specific Occurrence. The tutorial assumes that you have basic knowledge of Salesforce reporting and that you have set up the Apex Data Loader.
Create a report of the Contacts that you want to create Connections for
Create a report using the "Contacts & Organizations" type. Make sure that the report has the Contact ID field in it. Any other fields that you need to help you be sure you are getting the right Contacts can also be added. Set up any filters that you need to get only the Contacts that you need. If you know that you bulk uploaded all of the Contacts that you need on a specific day, you may want to limit the Created Date to that day. When you have run the report, click "Export Details." Export File Format should be "Comma Delimited .csv." Click Export.
Create a Connections template sheet.
Create a new spreadsheet with the following 6 columns: Contact, Volunteer Opportunity, Occurrence, Status, Attendance Status, and Role. Copy Contact ID from the exported report into the Contact column. Status should be Confirmed. Attendance Status should be whatever is appropriate, most likely Please Verify. Role should be either Volunteer or Volunteer Leader.