Skip to main content

Bulk-Import Volunteers

Volunteer Imports

Portal users have the ability to import volunteers in bulk using the import tool in Contacts > Imports. The only required fields for Volunteer imports are:

  • First and Last Name

  • Valid Email Address

  • State

We do not recommend matching other fields unless it is your intention to overwrite data.

Here's an example of what your file should look like:

mceclip0.png

Before Importing

  • Files are limited to 15 million bytes.

  • CSV is recommended format.

  • Make sure to read through your file and clean any data discrepancies before importing, such as incomplete records or special characters (super important!).

  • Ensure that state columns have state initials as values. 'Virginia' will not work, but 'VA' will.

  • Ensure that no duplicate emails exist in your file. i360 requires a unique email address to create a volunteer.

  • Review our Best Practices guide for additional recommendations.

Create Import

Access Imports from Contacts > Imports. To start a new import, click 'Create Import' in the action bar on the bottom right.

mceclip0.png

A window will appear to request the following information:

Upload File (.csv or .xlsx)

Import Name

Make As: Contacts OR Volunteers (select Volunteers)

      • Set Coordinator will assign the volunteers under a contact in the organization.

      • Ignore existing coordinator assignments will override any existing coordinator data.

      • Send Volunteers credential notification will notify volunteers that an account has been created for them (recommended).

      • Password is initially set by you. Volunteers have the ability to change it after it's been set.

Import Options:

      • Standard Import will insert the data into your MyData database and update the import data with records from i360's database (if you are confident in the accuracy of data in this file, this is the recommended option).

      • Insert Only will only add the import to your MyData database without updating it.

      • Update Only will only update the data you import without adding it to your MyData database.

Global Tags

      • This tag will be applied to all records in this import.

      • Keep the box checked for 'Auto-Generate Global Tag' to have an automated tag created for this import. Retrieve auto generated tags from Search > Basic > Tags > Tag Category: Imports.

mceclip2.png

Once this information is inserted, select 'Create Import' to move on to Map Fields.

Map Fields

Scroll past the 'IDs' column until you see 'Contact'. Match the First and Last Name options in this section.

Screen_Shot_2022-09-07_at_11.58.49_AM.png

Once you've matched all required, you can continue to the 'Tag Columns' page. We do not recommend matching any other fields unless you intend to add fields (like email) to contact profiles.

Tag Columns (Optional)

Tag Columns is an optional step for users to apply tags from their database with values in their file. See our Tag Creation guide for information on how to create tags.

If your file contains columns to tag, you may check those columns on this page. For example, this file contains columns for 'Support' and 'Donated' with 'x's marked in the columns to indicate that someone is a supporter or has donated:

mceclip0.png

We recommend creating tags prior to the 'Tag Values' step. If tags are not already created, they will not be available to select. You may leave the page to create them and return once they're done.

mceclip4.png

Select 'Next' to move on to the Tag Values tab.

Tag Values (Optional)

Tag Values will display the columns you chose in the previous step. Select the arrow to expand your selection to apply a matching category and tag.

mceclip5.png

Notice in the 'Support' example that two '+' icons appear. One appears in the row with a blank value and the other appears next to the 'x'. Be mindful of the rows that you apply tags to, as it is common that blank values will appear in this step.

mceclip6.png

Select the '+' in the 'x' row and apply relevant tags. Repeat this process for all tag columns and select 'Next' when finished.

Confirmation

The Confirmation page displays a summary of the Import ID, Import Name, File Name, Make As selection, Import Options, Mapped Fields, and Global Tags. Ensure all fields appear correct before selecting 'Import'.

mceclip3.png

After Importing

Users may track the progress of their import home page under the 'Status' column. Refer to the Status Legend at the bottom right of the screen (next to Create Import) for clarification on what each symbol means.

mceclip9.png

Double-clicking on a submitted import's name will display details for that import on the right. If an import has not been submitted yet, double-clicking will bring you back to the import draft.

mceclip10.png

If an import was unable to upload any records, an Exceptions download link will appear in the import row.

mceclip12.png

Selecting it will display those records so that the user may re-import them.

Screen_Shot_2022-06-20_at_12.36.18_PM.png

Please note that the Exceptions file will not display records that have misspelled states or incorrect State abbreviations, but will display records that failed for any other reason.

Import times can vary depending on the size of the file, number of tags applied, and site-wide import usage. If imports appear to take an unusually long time to load, please contact i360 Support.

Find My Volunteers

Once the import is complete, please allow a few minutes for volunteers to appear in Contacts > Management. You may use the filter option for Contact Type > Volunteers to locate volunteers in your database.

Help us keep up with articles!

Broken link or information out-of-date? Please let us know if an article needs work by submitting a note with link here.

Did this answer your question?