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.

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.

Please 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 for every profile. Ensure it is a valid email format without any extra spaces, and there must be an "@" and ".abc" 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	String	Jane	This is a required field for every profile.
Last Name*	Default	String	Doe	This is a required field for every profile.
Phone Number	Default	Integers	1231231234 (514) 123 - 4567	You can format the phone number as you see fit. You can include parentheses, spaces, dashes, etc. However, you cannot include text characters in this field.
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 1 2 3	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 profile's "Gender = 2" (i.e. Other).
Occupation	Default	Integer 0= Student 1= Professional 2= Retiree 3= Other	0 1 2 3	You must use an integer to represent the occupation for each user. For students 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), whereby 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 be a City, State and Zip Code and doesn't require a full address.
Emergency Contact (Name)	Default	String	Ryan	Include 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.
Start Date	Default	Date (YYYY-MM-DD)	2018-04-22	Please make sure it is the correct date format. You can change this in Excel if needed, using Date formatting.
General	Custom	String	Any string of text	You can include any string of text here.
Number	Custom	Integers	99	You can include any number here.
Single selection (list)	Custom	String	Blue	You must ensure that the value entered is a valid option for this field.
Multiple selection (list)	Custom	String	Blue Blue,Green Blue,Yellow,Green Red,Green,Blue,Yellow	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	Date (YYYY-MM-DD)	1998-08-12	Please make sure it is the correct date format. You can change this in Excel if needed, using Date formatting.
Email	Custom	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	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	URL	www.domain.com	You must include a valid URL.
Unique ID	Custom	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	Boolean (True, False)	True False	This is exclusively for True or False values. It can also be used for "Yes" or "No" type of fields.

• Related Articles

• How do I upload my spreadsheet into my database?

  If you have not yet prepared your spreadsheet, read this article Steps to import your spreadsheet into your database: 1. Login to Vome and using the left-hand side navigation, click Database 2. On the top-right of the page, click Create profiles 3. ...

• What is the difference between "Profile Tags" and "Custom Fields" in the database?

  The Pro plan only offers Profile Tags as a way to customize your database. You cannot import profile tags but can only assign them during the import process or once profiles are in your database. A profile tag can be anything you need it to be. It is ...

• Why Use the "Map Form Fields to Database Fields" Feature in Vome?

  Why Use the "Map Form Fields to Database Fields" Feature in Vome? Overview Vome’s "Map Form Fields to Database Fields" feature ensures that responses to custom form questions and attachments are automatically linked to a volunteer’s profile. Without ...

• Why can't an admin see a profile in the database?

  Why Can't an Admin User See a Profile in the Database? If you're an admin user and cannot see a specific profile in the database, there could be several reasons why. Below are the most common explanations and best practices for ensuring proper ...

• How should I onboard my existing volunteers?

  You have a few methods to successfully onboard your exist volunteer base. This is the flow we recommend for most organizations: 1. Upload your volunteer list into your Database (For detailed steps, read How do I prepare my spreadsheet to import into ...