Table of Contents
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 12 payment types that can be set for a given donation import. The following list correlates the NGP codes and payment types.
📌 Note: If you're importing payment_type_ngp_code, you must also include the payment_type_name field in your import file.
Payment_type_ngp_code: payment_type_name
C: Cash
D: Credit Card
K: Check
M: Money Order
E: EFT
I: In-Kind
T: Wire Transfer
O: Other
D: Square
O: ActBlue
D: Google Pay
D: Apple Pay
FEC codes
There are 9 Federal Election Commission transaction types that can be set.
When importing transactions, the following list 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 list correlates the election period's NGP code and name.
One of these election periods must be included when importing vote history.
ngp_code: Period name
C: Convention
E: Recount
G: General
H: Previous Campaign
P: Primary
PP: Presidential Primary
R: Runoff
S: Special
U: Unknown
O: Other
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
C: Civil union
D: Divorced
M: Married
P: Domestic partner
S: Single
W: Widowed
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.
AA: Afar
AB: Abkhazian
AF: Afrikaans
AM: Amharic
AR: Arabic
AS: Assamese
AY: Aymara
AZ: Azerbaijani
BA: Bashkir
BE: Byelorussian
BG: Bulgarian
BH: Bihari
BI: Bislama
BN: Bengali
BO: Tibetan
BR: Breton
CA: Catalan
CO: Corsican
CS: Czech
CY: Welsh
DA: Danish
DE: German
DE-AT: German (Austria)
DE-CH: German (Switzerland)
DZ: Bhutani
EL: Greek
EN: English
EN-AU: English (Australia)
EN-GB: English (UK)
EN-IN: English (India)
EN-US: English (US)
EO: Esperanto
ES: Spanish
ES-AR: Spanish (Argentina)
ES-CL: Spanish (Chile)
ES-CO: Spanish (Colombia)
ES-MX: Spanish (Mexico)
ES-PE: Spanish (Peru)
ET: Estonian
EU: Basque
FA: Persian / Farsi
FI: Finnish
FJ: Fiji
FO: Faeroese
FR: French
FY: Frisian
GA: Irish
GD: Gaelic
GL: Galician
GN: Guarani
GU: Gujarati
HA: Hausa
HI: Hindi
HR: Croatian
HU: Hungarian
HY: Armenian
IA: Interlingua
IE: Interlingue
IK: Inupiak
IN: Indonesian
IS: Icelandic
IT: Italian
IW: Hebrew
JA: Japanese
JI: Yiddish
JW: Javanese
KA: Georgian
KK: Kazakh
KL: Greenlandic
KM: Cambodian
KN: Kannada
KO: Korean
KS: Kashmiri
KU: Kurdish
KY: Kirghiz
LA: Latin
LN: Lingala
LO: Laothian
LT: Lithuanian
LV: Latvian
MG: Malagasy
MI: Maori
MK: Macedonian
ML: Malayalam
MN: Mongolian
MO: Moldavian
MR: Marathi
MS: Malay
MT: Maltese
MY: Burmese
NA: Nauru
NE: Nepali
NL: Dutch
NO: Norwegian
OC: Occitan
OM: Oromo
OR: Oriya
PA: Punjabi
PL: Polish
PS: Pashto
PT: Portuguese
PT-BR: Portuguese (Brazil)
PT-PT: Portuguese (Portugal)
QU: Quechua
RM: Rhaeto-Romance
RN: Kirundi
RO: Romanian
RU: Russian
RW: Kinyarwanda
SA: Sanskrit
SD: Sindhi
SG: Sangro
SH: Serbo-Croatian
SI: Singhalese
SK: Slovak
SL: Slovenian
SM: Samoan
SN: Shona
SO: Somali
SQ: Albanian
SR: Serbian
SS: Siswati
ST: Sesotho
SU: Sudanese
SV: Swedish
SW: Swahili
TA: Tamil
TE: Tegulu
TG: Tajik
TH: Thai
TI: Tigrinya
TK: Turkmen
TL: Tagalog
TN: Setswana
TO: Tonga
TR: Turkish
TS: Tsonga
TT: Tatar
TW: Twi
UK: Ukrainian
UR: Urdu
UZ: Uzbek
VI: Vietnamese
VO: Volapuk
WO: Wolof
XH: Xhosa
YO: Yoruba
ZH: Chinese
ZH-CMN: Mandarin
ZH-YUE: Cantonese
ZU: Zulu
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:
A: Asian
B: African American
H: Hispanic
I: American Indian
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
A: American Independent
C: Constitutional
D: Democrat
G: Green
I: Independent
J: Justice
L: Libertarian
P: Peace and Freedom
E: Reform
R: Republican
S: Socialist
U: Undeclared
W: Working Families
O: Other
New York state, U.S.
Must type "NY" as the state in Settings > Political > Office to see these options.
A: American Independent
C: Conservative
D: Democrat
E: Reform
F: Right to Life
G: Green
I: Independent
J: Justice
L: Libertarian
P: Peace and Freedom
R: Republican
U: Undeclared
W: Working Families
O: Other
Rhode Island, U.S.
Must type "RI" as the state in Settings > Political > Office to see these options.
A: American Independent
C: Constitutional
D: Democrat
E: Reform
G: Green
I: Independent
J: Justice
L: Libertarian
M: Moderate
P: Peace and Freedom
R: Republican
U: Undeclared
W: Working Families
O: Other
Australia
A: Liberal Democrats
B: Liberal
D: Democrat
E: One Nation
F: Family First
G: Green
J: Animal Justice Party
K: Katter
L: Labor
M: Independents for Climate Action Now
N: National
P: Pirate
R: Australian Progressives
S: Socialists
T: Nick Xenophon Team
W: Drug Law Reform
X: Sex
Y: Christian Democratic Party
Z: Liberal National Party of Queensland
O: Other
Canada
C: Conservative
D: New Democratic
G: Green
L: Liberal
Q: Bloc Québécois
O: Other
Alberta, Canada
Must type "AB" as the province in Settings > Political > Office to see these options.
A: Alberta
C: Communist
D: New Democratic
E: Evergreen
F: Pro-Life
G: Green
I: Independence
L: Liberal
N: Separation
P: Progressive Conservative
Q: Bloc Québécois
R: Reform
S: Social Credit
T: Advantage
V: Conservative
W: Wildrose Party
O: Other
Great Britain
A: Alliance
B: British National
C: Conservative
D: Liberal Democrats
F: Sinn Féin
G: Green
H: Change UK
I: UK Independent
L: Labour
N: Ulster Unionist
P: Plaid Cymru
S: SNP
T: Social Democratic
U: Democratic Unionist
X: Brexit Party
O: Other
France
A: Autre (O)
B: Debout la République (DLR)
C: Front national (FN)
D: Union des démocrates et indépendants (UDI)
E: Les Verts (EELV)
F: Front de gauche (FG)
G: Guadeloupe unie (GUSR)
H: Mouvement pour la France (MPF)
I: Mouvement pour la Réunion (MPLR)
J: Mouvement républicain et citoyen (MRC)
K: Divers droite (DVD)
L: Ligue du sud (LDS)
M: Mouvement démocrate (MoDem)
N: Nouvelle Donne (ND)
O: Parti chrétien-démocrate (PCD)
P: Les Républicains (LR)
Q: Extrême gauche (EXG)
R: Parti progressiste martiniquais (PPM)
S: Parti sociliste (PS)
T: Parti radical de gauche (PRG)
U: Extrême droite (EXD)
V: Rassemblement démocratique martiniquais (RDM)
W: Union démocratique bretonne (UDB)
X: Parti de Gauche (PG)
Y: Divers (DIV)
Z: Parti Communiste Français (PCF)
Kenya
A: FORD-Asili
C: NARC-Kenya
D: ODM
E: FORD-People
H: Shirikisho Party of Kenya
I: Sisi Kwa Sisi
K: KANU
M: Mazingira Green Party of Kenya
N: NARC
P: PNU
R: FORD-Kenya
S: Safina
U: UDM
Y: ODM-Kenya
O: Other
New Zealand
A: Alliance
C: Conservative
D: Democratic
E: Legalise Cannabis
F: New Zealand First
G: Green
L: Labour
M: Māori
N: National
O: Focus
S: Mana
T: ACT
U: United Future
Scotland
Please contact us at [email protected] if you don't see these options and would like them.
C: Conservative
D: Liberal Democrats
G: Green
I: Independent
L: Labour
P: SSP
S: SNP
O: Other
Switzerland
A: Alternative Left
C: Christian Democratic People's Party
D: Conservative Democratic Party
E: Evangelical People's Party
F: FDP.The Liberals
G: Green Party
H: Christian Social Party
L: Party of Labour
P: Swiss People's Party
R: Green Liberal Party
S: Social Democratic Party
T: Ticino League
U: Federal Democratic Union
V: Geneva Citizens' Movement
Vote methods
When importing vote history, a word used to indicate how a person voted. Vote methods must be all lowercase.
voted: Person voted.
early: Person voted early.
absentee: Person voted using an absentee ballot.