Unique identifiers (IDs) are profile fields that may not occur in more than one profile within a nation. Unique IDs are used to merge information from imports with records already existing in the nation and for deduping records in your nation.
A person's profile in NationBuilder has several options for unique IDs:
- email address
The best unique ID on an import is an email address. If you do not have an email address for a specific person, you may use one or more of the other unique IDs. However, the other unique IDs must have a first name and last name mapped during the import in order for the signup record to be imported into the nation.
Once the import has finished newly imported people in the nation will have a nationbuilder_ID assigned to them.
There will be times when there isn't anything the importer recognizes as unique on import. In this case, you can create a unique ID for each record.
- Open the CSV file in Excel
- Insert a new column to the left of the existing columns
- Name that column "NationBuilder_ID"
- Leave the rest of the column blank
- Save the CSV file
- Import your file mapping the new column to "nationbuilder_ID" (for one time and voter imports) or "signup_nationbuilder_ID" (for donation imports)
If an attempt is made to import a person whose unique ID(s) already exist in the nation, NationBuilder will update the existing profile with the information from the import file instead of creating a new profile.
Voters in your nation may have one or more of these unique IDs:
- DW_ID (also known as Catalist ID)
Donations have their own unique ID (donation_nationbuilder_id) along with one of the unique ID so NationBuilder knows who the donation belongs to. Donation imports connect the donor to the donation via the same fields used for a one time import. However, here is a slight difference for donations: each of these fields begins with "signup_".
C.J. MinsterCheng commented 2014-02-20 14:55:22 -0800Michael – you can map it to signup ID. Make sure you’re mapping to the ID listed under the word “Signup” rather than other IDs.
Michael Macfarlane commented 2014-02-12 16:26:01 -0800I am trying to import a donor list. I created the NationBuilder_ID column in the csv file, however there is no NationBuilder_ID choice to map to.
Michael Macfarlane tagged this with Not helpful 2014-02-12 16:24:04 -0800
Adriel Hampton tagged this with Important 2013-03-01 10:33:04 -0800