Import codes

A listing of all import codes for NationBuilder.

Updated over a week ago

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.

Did this answer your question?