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 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:

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: 

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.

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:

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.

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:

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
  • 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

Vote methods

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

Did this answer your question?