Mass importing custom data fields

How should I format my fields to successfully upload them to my database?

You can use the format below for each type of field to ensure a successful import.

Idea
There is a template that you can download attached to this article. You may fill out the template directly or use it as a reference to help you fill out your own Excel file.

WarningPlease note that you can only create, map and import custom fields using the Enterprise or Ultimate plan.
Both
Recruit and Pro plans will only offer the ability to import default database field data (see Type column below for more details).

Field Title
Type
Format
Example
Notes
Email*
Default
Valid email
name@example.com
This is a required field.

Ensure it is a valid email format without any extra spaces and there must be an "@" and ".XXX" in the string of text.

*Note: If the profile doesn't have an email address, you can make one up and put it in the email field, but it must be unique. Another option is to not import the profile via the mass import process, but create a single profile from Vome's database directly.
First Name*
Default
StringJaneThis is a required field.
Last Name*
Default
String
DoeThis is a required field.
Phone Number
Default
Integers
1231231234Ensure that you only include valid integers without any spaces, dashes or parentheses.
Profile picture
Default
URL
http://domain/media/files/database/attachments/810653cc-8547-49c0-8bed-e3bc0fc41106.png
This will need to be a valid image in URL format. It is mostly relevant if you are exporting this data from a different software. Otherwise, we recommend adding profile pictures individually by editing profiles in the database.
Date of Birth
Default
Date (YYYY-MM-DD)
1996-01-15
Please make sure it is the correct date format. You can change this on Excel if needed. When Date of Birth is imported, it will automatically calculate the age field on an ongoing basis.
Gender
Default
Integer


0= Male
1= Female
2= Other
3= Rather not say

0
You must use an integer to represent the gender for each user. If you would like to indicate a custom gender, you can input 2, and then add a new field for Gender text (see below).
Gender Text
Default
String
Genderfluid
This field is only permitted if you have the user's gender equal to 2 from the row above.
Occupation
Default
Integer

0= Student
1= Professional
2= Retiree
3= Other

1

You must use an integer to represent the occupation for each user. For student and professionals, if you would like to indicate an organization associated with them,  you can add that as a subsequent field (see below).
Organization
Default
String
Harvard University
This field is only permitted if you have the user's Occupation = 1 (Student), whereby the Organization is the name of a school, or 2 (Professional), where by it's the name of the company they work at,
Address
Default
String
298 Bd Décarie Montréal, QC H4N 2M2, Canada

You can include any string of text here (i.e. it could just by a City, State and Zip Code and doesn't require a full address.
Emergency Contact (Name)
Default
String
RyanInclude First Name and Last Name in the same field
Emergency Contact (Phone #)
Default
Integers
5149008000
Ensure that you only include valid integers without any spaces, dashes or parentheses
Emergency Contact (Relationship)
Default
String
Father
You can include any string of text here.
General
Custom field
String
Any string of text
You can include any string of text here.
Number
Custom field
Integers
99
You can include any number here.
Single selection (list)
Custom field
String
Blue
You must ensure that the value entered is a valid option for this field. 
Multiple selection (list)
Custom field
String
Blue or Blue,Green
You must ensure that the values entered are valid options for this field.

If there are multiple options for a given profile, separate them by a comma and no spaces.
Date
Custom field
Date (YYYY-MM-DD)
1998-08-12
Please make sure it is the correct date format. You can change this on Excel if needed.
Email
Custom field
Valid email
sample@email.com
Ensure it is a valid email format without any extra spaces and there must be an "@" and ".XXX" in the string of text.
Attachment
Custom field
URL
http://domain/media/files/volunteer-database/attachments/810653cc-8547-49c0-8bed-e3bc0fc41106.png
This will need to be a valid attachment. It is mostly relevant if you are exporting this data from a different software. Otherwise, we recommend adding attachments individually.
URL
Custom field
URL
www.domain.com
You must include a valid URL.
Unique ID
Custom field
String
928938983-ab0938
Any string of text, integers or special characters will work. However the value must be unique for each user in your database.
Boolean
Custom field
Boolean (True, False)
True
This is exclusively for True or False values. Can also be used for Yes or No type of fields.