Import codes

Defining transaction dates

Up to four dates can be associated with a transaction: created, succeeded, failed, and canceled. 

The format used in all four fields is "MM/DD/YYYY" or "MM/DD/YYYY hh:mm:ss" (without quotes). 

When someone donates or pays an invoice on a website built on NationBuilder, at least two of these dates will be recorded. 

1. Created_at is the date the transaction was created in NationBuilder. 

2. Succeeded_at is the date the transaction was successfully processed by the credit card processor. 

3. Failed_at is the date an unsuccessful attempt to process the transaction was done by the credit card processor.

4. Canceled_at is the date the transaction was canceled/refunded by the credit card processor.

These date fields are handled automatically for credit card transactions created in your control panel or on a website built on NationBuilder.


Importing donations

When importing donations, the created_at field will be added to the transaction and will record the date of the import, i.e. the date the transaction was created in NationBuilder.

We strongly recommend never mapping a date to the created_at field. By allowing your nation to define this field, you will retain a history when each import occurred.

Importing credit card donations

Credit card transactions include either a succeeded_at or a failed_at date, and may include a canceled_at date. 

It is possible to import a date to this field. We strongly recommend not mapping to the created_at field.

Importing other payment types, including cash or check donations

You may have only one date associated with cash, check, or other types of payment. We recommend importing this date to the succeeded_at field. That way, you will have an accurate history of when the donation was received and when the donation was created within your Finances section.

Payment types

There are 10 payment types that can be set for a given donation import. The following table correlates the NGP codes, payment types, and payment type IDs:

payment_type_ngp_code payment_type_name payment_type_id
C Cash 1
D Credit Card 2
K Check 3
M Money Order 4
E EFT 5
I In-Kind 6
T Wire Transfer 7
O Other 8
D Square 9
O ActBlue 10

Note that NGP does not distinguish between the ActBlue and Other payment categories, therefore they share the NGP code "O."

FEC codes

There are 9 Federal Election Commission transaction types that can be set.

When importing transactions, the following table correlates the NGP FEC codes, FEC type names, and FEC type IDs: 

fec_type_ngp_code fec_type_name fec_type_ID
C Contribution 1
E Exempt legal expense 2
F Offsets 3
G Debt owed to committee 4
I Interest 5
L Loan 6
M Loan from candidate 7
T Transfer 8
O Other 9

Election period

There are ten election periods that can be set on a transaction. 

When importing transaction, the following table correlates the election period's NGP code and name.

One of these election periods must be included when importing vote history.

Period name ngp_code
Primary P
Presidential Primary PP
General G
Special S
Recount E
Runoff R
Convention C
Previous Campaign H
Other O
Unknown U

Marital status

A person's marital status can be imported. When you edit a profile, you can update marital status from Edit > Settings. 

The following are the marital status values NationBuilder supports:

Marital status Code for import
Civil union C
Divorced D
Married M
Domestic partner P
Single S
Widowed W

When importing marital status, the one letter codes listed above are the only values accepted in the marital status field.

Language spoken

A person's language can be imported. When you edit a profile, you can update language from Edit > Settings. 

Use these codes if you want to import language to a profile. Each profile can include one language.

Code Language
AR Arabic
BG Bulgarian
CA Catalan
CS  Czech
CY Welsh
DA Danish
DE  German
DE-AT  German (Austria)
DE-CH  German (Switzerland)
EL  Greek
EN  English
EN-AU  English (Australia)
EN-GB  English (UK)
EN-IN  English (India)
EN-US  English (US)
ES  Spanish
ES-AR  Spanish (Argentina)
ES-CL  Spanish (Chile)
ES-CO  Spanish (Colombia)
ES-MX  Spanish (Mexico)
ES-PE  Spanish (Peru)
ET  Estonian
FA  Persian / Farsi 
FI  Finnish 
FR  French 
HI  Hindi 
HR  Croatian 
HU  Hungarian 
IS  Icelandic 
IT  Italian 
IW  Hebrew 
JA  Japanese 
KO  Korean 
LT  Lithuanian 
LV  Latvian 
MK  Macedonian 
NL  Dutch 
NO  Norwegian 
PA  Punjabi 
PL  Polish 
PS  Pashto
PT  Portuguese  
PT-BR Portuguese (Brazil) 
PT-PT  Portuguese (Portugal) 
RO  Romanian
RU  Russian 
SK  Slovak 
SL  Slovenian 
SV  Swedish 
TA  Tamil 
TH  Thai 
TL  Tagalog 
TR  Turkish 
UR  Urdu 
UK  Ukranian
VI  Vietnamese 
ZH  Chinese 
ZH-YUE  Cantonese 
ZH-CMN  Mandarin 

When importing language, the codes listed above are the only acceptable values. You cannot import the full name of a language.

Demographic codes

The demographic field in profiles is based on the United States Census race categories. Only the following six categories can be imported:

Code Demographic category
A Asian
B African American
H Hispanic
W White / Caucasian
O Other
U Unknown

Only the above one-letter codes will be accepted to import into the demo field. 

If you need a broader range of categories, the ethnicity field is an open-ended text field - any ethnicity can be imported using that field. You can also import information on a person's primary language.

Political party codes

NationBuilder strives to provide strong support for political organizing wherever you are and regularly adds country or province-specific parties when there is a user base to support that. If you have enabled voter specific features, the political parties you see in profiles are determined by the country listed in Settings > Contact and by the state or province listed in Settings > Political > Office.

When importing voters, you must use the one-letter code for the voter's political party.

When importing vote history, political party is only included if the ballot received was unique to a particular political party. For example, in many U.S. primary elections, voters can receive either a Republican ballot, a Democratic ballot, or an Independent ballot. During a vote history import, the entire name of the political party must be imported - spelled exactly as it appears below. 

Current regional parties supported:

United States

  • American Independent, A
  • Constitutional, C
  • Democrat, D
  • Green, G
  • Independent, I
  • Justice, J
  • Libertarian, L
  • Peace and Freedom, P
  • Reform, E
  • Republican, R
  • Socialist, S
  • Undeclared, U
  • Working Families, W
  • Other, O

New York state, U.S.

Must type "NY" as the state in Settings > Political > Office to see these options.

  • American Independent, A
  • Conservative, C
  • Democrat, D
  • Green, G
  • Independent, I
  • Justice, J
  • Libertarian, L
  • Peace and Freedom, P
  • Reform, E
  • Republican, R
  • Right to Life, F
  • Undeclared, U
  • Working Families, W
  • Other, O

Rhode Island, U.S.

Must type "RI" as the state in Settings > Political > Office to see these options.

  • American Independent, A
  • Constitutional, C
  • Democrat, D
  • Green, G
  • Independent, I
  • Justice, J
  • Libertarian, L
  • Moderate, M
  • Peace and Freedom, P
  • Reform, E
  • Republican, R
  • Undeclared, U
  • Working Families, W
  • Other, O

Australia 

  • Democrat, D
  • Drug Law Reform, W
  • Family First, F
  • Green, G
  • Katter, K
  • Labor, L
  • Liberal, B
  • National, N
  • Nick Xenophon Team, T
  • One Nation, E
  • Pirate, P
  • Sex, X
  • Socialists, S
  • Other, O

Canada 

  • Bloc Québécois, Q
  • Conservative, C
  • Green, G
  • Liberal, L
  • New Democratic, D
  • Other, O

Alberta, Canada

Must type "AB" as the province in Settings > Political > Office to see these options.

  • Alberta, A
  • Bloc Québécois, Q
  • Communist, C
  • Conservative, V
  • Evergreen, E
  • Green, G
  • Liberal, L
  • New Democratic, D
  • Progressive Conservative, P
  • Separation, N
  • Social Credit, S
  • Wildrose Party, W
  • Other, O

Great Britain

  • Alliance, A
  • British National, B
  • Conservative, C
  • Democratic Unionist, U
  • Green, G
  • Labour, L
  • Liberal Democrats, D
  • Plaid Cymru, P
  • Sinn Féin, F
  • SNP, S
  • Social Democratic, T
  • UK Independent, U
  • Ulster Unionist, N
  • Other, O

France

  • Autre (O), A
  • Debout la République (DLR), B
  • Divers (DIV), Y
  • Divers droite (DVD), K
  • Extrême droite (EXD), U
  • Extrême gauche (EXG), Q
  • Front de gauche (FG), F
  • Front national (FN), C
  • Guadeloupe unie (GUSR), G
  • Les Républicains (LR), P
  • Les Verts (EELV), E
  • Ligue du sud (LDS), L
  • Mouvement démocrate (MoDem), M
  • Mouvement pour la France (MPF), H
  • Mouvement pour la Réunion (MPLR), I
  • Mouvement républicain et citoyen (MRC), J
  • Nouvelle Donne (ND), N
  • Parti chrétien-démocrate (PCD), O
  • Parti Communiste Français (PCF), Z 
  • Parti de Gauche (PG), X
  • Parti progressiste martiniquais (PPM), R
  • Parti radical de gauche (PRG), T
  • Parti sociliste (PS), S
  • Rassemblement démocratique martiniquais (RDM), V
  • Union démocratique bretonne (UDB), W
  • Union des démocrates et indépendants (UDI), D

Kenya

  • FORD-Asili, A
  • FORD-Kenya, R
  • FORD-People, E
  • KANU, K
  • Mazingira Green Party of Kenya, M
  • NARC, N
  • NARC-Kenya, C
  • ODM, D
  • ODM-Kenya, Y
  • PNU, P
  • Safina, S
  • Shirikisho Party of Kenya, H
  • Sisi Kwa Sisi, I
  • UDM, U
  • Other, O

New Zealand

  • ACT, T
  • Alliance, A
  • Conservative, C
  • Democratic, D
  • Focus, O
  • Green, G
  • Labour, L
  • Legalise Cannabis, E
  • Mana, S
  • Māori, M
  • National, N
  • New Zealand First, F
  • United Future, U

Scotland

Please talk to your community strategist if you don't see these options and would like them.

  • Conservative, C
  • Green, G
  • Independent, I
  • Labour, L
  • Liberal Democrats, D
  • SNP, S
  • SSP, P
  • Other, O

Switzerland

  • Alternative Left, A
  • Christian Democratic People's Party, C
  • Christian Social Party, H
  • Conservative Democratic Party, D
  • Evangelical People's Party, E
  • FDP.The Liberals, F
  • Federal Democratic Union, U
  • Geneva Citizens' Movement, V
  • Green Liberal Party, R
  • Green Party, G
  • Party of Labour, L
  • Social Democratic Party, S
  • Swiss People's Party, P
  • Ticino League, T

Precinct

A precinct is a geographical unit of a city or town. Generally, it is the smallest district involved in a political campaign. You must enable voter features in order to view precincts. Enable these features at Settings > Defaults > Basics. 


How precincts are created

1. When a voter file is imported from the NationBuilder Election Center, precinct is included automatically.

Within NationBuilder, a precinct is defined by its precinct_code and precinct_name. This means that if one record is imported with precinct_code "001" and precinct_name "nil" (i.e. an empty field) and a second record is imported with precinct_code "001" and precinct_name "Wells Ward," the records will be placed in separate precincts. 

2. Precincts can also be imported in one-time and voter imports.

3. New precincts can also be created in People > More > Precincts.


View precincts

You must have voter features enabled to view precincts. A list of precincts is available in People > More > Precincts.

view all precincts in People section


Precinct captains

A point person can be assigned to each precinct - creating precinct captains.

In People > More > Precincts, click on the edit button next to the name of a precinct. This will take you to the settings section of the precinct.

edit precinct settings

Select the name of the point person, then click the "Save precinct" button. 


Delete precincts

Go to People > More > Precincts.

edit or delete precincts

To delete a single precinct, click the trash icon to the right of the precinct name. Deleting a precinct does not delete the profiles assigned to that precinct. You can remove profiles individually or batch remove people

Empty precincts can be deleted en masse. Click the "Delete empty precincts" button at the top of the Precincts section.


How to import a voter file

Fields available for import

How to remove a profile

How to batch remove people

Vote methods

When importing vote history, a word used to indicate how a person voted. Vote methods must be all lowercase.

Vote method Description
voted Person voted.
early Person voted early. 
absentee Person voted using an absentee ballot.  

If you’re unclear on how this feature works, please ask a question. If you would like to see changes to this feature, please submit a suggestion.