What fields are available for imports?

Official response from Adriel Hampton

Below is a list of the fields supported for standard imports.

Click here for more info on donor history imports; and here for voter data import info (voter personal information and voting history are imported separately under the voter data import). And here's a look at the process for starting a standard import. If you are doing multiple imports of the same kind, you will want to reuse your field mappings.

We recommend not using fields as proxies for other data - doing so makes it difficult to manage your nation and for others to query data relevant for their workflow. Tags are a good place to store extra data points, and you can add multiple tags separated by commas. 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

Items in italics are unique identifiers for NationBuilder. Unique identfiers can only be assigned to one signup record. An email address is a unique identifier and doesn't require a first or last name to be defined with the import. The other unique identifiers must have a first name and last name mapped during the import in order for the signup record to be imported into the nation.

Field Name	Constrictions
email	must contain valid email address (can be repeated up to four times per profile)
email_opt_in	Y/N
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	i.e. William instead of Bill
employer
occupation
sex	Must be M/F/O
party	1 character Party abbreivation - full list of political parties
religion
church
ethnicity
marital_status	C/D/M/P/S/W -(civil union, divorced, married, domestic partner, single, widowed)
is_deceased	Y/N
DOB	Birthdate - must be in the form MM/DD/YYYY
phone_number
work_phone_number
mobile_number
mobile_opt_in	Willing to receive text messages from nation - Y/N
is_mobile_bad	Indicates mobile number is bad and will not accept text messages - Y/N
federal_donotcall	On US Federal Do Not Call list - Y/N
do_not_call	Does not want to be called by nation - Y/N
do_not_contact	Does not want to be contacted by nation - Y/N
fax_number
website	Must be valid URL
language	Primary spoken language - Two character abreviation
created_at	Date joined or imported to nation - must be in the form MM/DD/YYYY
support_level	1 =very strong support and 5 = very strong oppose
inferred_support_level	1(very strong inferred support) to 5 (very weak inferred support)
priority_level	value of 1 through 5, with 1 being low priorty and 5 being high priority
background	Background field which shows at top of the person's profile
availability
household_size	Must be numerical
demo	Demographic information
tag_list	Tags separated by commas which will be added to person's profile. See Overwrite non-blank fields FAQ entry for more information.
assistant_id	NationBuilder ID for assistant
assistant_name_or_email	Must be valid member of nation
recruiter_id	NationBuilder ID of the recruiter for this person
recruiter_name_or_email	Recruiter's name or email address - Must be valid member of nation
parent_id	NationBuilder ID for point person for this profile
point_person_name_or_email	Point person's name or email address - Must be valid member of nation
nationbuilder_id	NationBuilder ID for this person - Must be blank for imports. Must be numerical for updates
facebook_uid
twitter_login
twitter_id	At most one Twitter account per record. At most one record per Twitter account.
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
VOLUNTEER ADDON
is_volunteer	Y/N
DONOR ADDON (*indicates has bank account with the NYC option checked)
is_fundraiser	Y/N
is_ignore_donation_limits	Y/N
donations_to_raise_amount
*doing_business_with_nyc_agency
*doing_business_with_nyc_business_category
MEMBERS ADDON	Learn about setting up memberships
membership_level_name	Must exist in nation
membership_started_at	must be in the form MM/DD/YYYY
membership_expires_at	must be in the form MM/DD/YYYY

Back to top

---

What is the the difference between precinct codes and precinct numbers?

Official response from Adriel Hampton

Precinct numbers are numerical codes unique to each of the precincts within the state. Precinct codes are the names associated with those numbers. The list of precincts you have created for your nation can be found at in your control panel under People > Precincts.

NationBuilder expects your nation to have distinct precinct codes for each precinct. Precincts can also have distinct names for each precinct. 

If you are searching for the voters in a specific precinct, you can search for either the name of the precinct or the code assosciated with that name. You are not able to search for both at the same time.

For most states, the name and the code each indicate the same precinct. In some states such as AZ, precincts are defined with a combination of the code and name. If your state uses a name and number combination to indicate distinct precincts, you need to create precinct names for each precinct that contain both the name and the number (you can do this by concatenating the name and code field in Excel).

For example M0002 Apache. M is the county code, 0002 is the precinct code, and Apache is the name of the precinct. Each of the three pieces is needed to define the precinct, so precincts in AZ need to be defined as precinct names in NationBuilder instead of as precinct codes.