1. Open the mass importer
In the left-hand navigation click Database, then open the Create profiles button and choose Mass import.
2. Upload your file
Choose a .csv or .xlsx file. One row is one person, and you can import up to 10,000 rows per upload. First Name, Last Name and Email are required, and a row with no email address cannot be imported. Add anyone without an email with Single profile instead, selecting This profile does not have an email address.
One sheet per workbook. An Excel workbook containing more than one sheet will fail to upload. If your file has several tabs, save the one you want as its own file first.
3. Map your fields
Every column in your file has to be pointed at a Vome field before you can continue, so delete the columns you do not want to bring over rather than leaving them in.
If your column titles already match the field names in Vome, they are matched for you automatically and you only adjust the rest.
4. Check file errors
Vome validates the file and lists anything that will not import, with the row number. Nothing is imported until those are gone. Fix them in your spreadsheet and upload the corrected file from that same step, keeping the column titles identical between the two versions.
5. Customize & Assign
This step decides what happens to profiles that already exist, sets default values for fields your file has no column for, and applies bulk assignments to everyone in the import.
You can assign the whole file to:
- Opportunities. Worth doing. People who are approved for an opportunity can start reserving shifts as soon as they claim their account. Without one, someone claiming their account lands on your organization page instead, because Vome assumes they still have to find something to sign up for.
- Profile tags. For your own filtering and grouping. Users never see the tags on their profile, which makes them ideal for marking an imported cohort, for example a corporate or school group.
- Shifts. Puts people straight onto a one-time or recurring set of shifts. This also approves them for whatever opportunity those shifts belong to, and they see the reservations as soon as they claim their account.
- Sequences. Useful when the people you are importing are mid-onboarding.
- Groups and Sites.
6. Review & Save
The last step shows the summary and decides whether anyone is contacted.
Leave Invite all profiles to claim their Vome account off and the profiles simply appear in your database with nobody emailed. Turn it on and everyone in the file is emailed an invitation from noreply@vomenotifications.com to claim their account. You can add a custom welcome message and set whether those emails go out in English or French.
Invitations cannot be recalled. On a first migration, import quietly, check the data landed the way you expected, and invite people from the database afterwards.
Related Articles
How do I prepare my spreadsheet to import into my database?
Most import problems are decided before you upload anything. This page covers what the file should look like. For the upload itself, see How do I mass import a contact list into my database via a spreadsheet? Decide what this file is for before you ...
How do I upload my spreadsheet into my database?
This page has moved. Uploading a spreadsheet into your database is now covered in one place, with screenshots of each step. Read this instead: How do I mass import a contact list into my database via a spreadsheet? Two related articles, depending on ...
How do I create offline profiles in my database?
Overview An offline profile is a record you create and maintain yourself, for somebody who does not have a Vome account. You can assign them opportunities and shifts and record their hours exactly as you would anybody else. They exist because plenty ...
How do I mass import profiles into my database?
Overview The Database is where every person your organization works with lives. If you are moving to Vome from another system, or from a pile of spreadsheets, the mass importer brings that whole list in at once: you upload a file, tell Vome what each ...
What does the People metric represent?
Overview The People card counts every profile in your database. This metric was previously labelled Volunteers, and then Profiles. If you are looking for either of those, People is the same card. 1. Does it only count people who are actively ...