What fields are available for imports?
Below is a list of the fields supported for standard imports. Many of these are uncommon and you won't need to worry about them.
Click here for more info on donor history imports; and here for voter data import info, which requires our campaign edition (voter personal information and voting history are imported separately under the voter data import). And here's a look at the paths for starting a standard import.
Please do not use fields as proxies for other data - doing so will confuse important dependencies and make it more difficult to manage your nation. Tags are a good place to store extra data points, and you can add multiple tags separated by commas. We are regularly expanding our support for data needed to run your nation - if you have questions, drop us a line at help@nationbuilder.com. You can also suggest new features related to imports.
.CSV imports are limited to 20mb per file - if your list is larger than that, you will need to divide it into multiple files.
Standard import fields:
- email_opt_in
- prefix
- first_name
- middle_name
- last_name
- suffix
- name - the full name of someone, leave blank if you provide first/last/middle name separately.
- legal_name - ie William instead of Bill
- employer
- occupation
- sex - should be M or F
- party - a single letter, here's the full list of political parties
- church
- ethnicity
- marital_status
- is_deceased
- born_at
- phone_number
- work_phone_number
- mobile_number
- mobile_opt_in
- website
- language
- created_at
- support_level - should be 1,2,3,4 or 5 with 1 being very supportive and 5 being very opposed
- membership_level_name
- membership_started_at
- membership_expires_at
- is_volunteer
- is_fundraiser
- is_ignore_donation_limits
- note - shows as the top of the user record where "Add Background" is located.
- household_size
- federal_donotcall
- demo
- tag_list - comma separated, any tags here will beĀ added to a person
- assistant_id - the nationbuilder_id of another person who is this person's assistant
- assistant_name_or_email
- recruiter_id - the nationbuilder_Id of another person who is this person's recruiter
- recruiter_name_or_email
- parent_id - the nationbuilder_id of another person who is this person's point person.
- point_person_name_or_email
- nationbuilder_id
- facebook_uid (NationBuilder will deduplicate based on social network IDs)
- twitter_login
- twitter_id
- meetup_id
- civicrm_id
- external_id
- address_country_code
- address_country
- address_state
- address_city
- address_county
- address_zip
- address_address1
- address_address2
- address_address3
- address_fips
- work_country_code
- work_country
- work_state
- work_city
- work_county
- work_zip
- work_address1
- work_address2
- work_address3
- work_fips
- mailing_country_code
- mailing_country
- mailing_state
- mailing_city
- mailing_county
- mailing_zip
- mailing_address1
- mailing_address2
- mailing_address3
- mailing_fips