Moving data from one system to another can be a complicated process. During your trial, we offer a free data import. If you continue to need help, our Services Team can provide custom data work - handling large scale migrations, cleanup, and deduping. Pricing for custom data work may be subject to an initial scoping and is available upon request. Please email email@example.com for more information. We also have detailed instructions on how to import different types of information, as outlined below.
Each nation has a single relational database with connected tables. Information directly connected to a profile is in the signup table. Donations are stored in the financial table and memberships are stored in the membership table.
Imports must be formatted as UTF-8 standardized, comma separated files (CSV). Certain fields only accept data in a particular format and some fields are only available in particular types of imports. Detailed information is available on fields available for import. Files must be 1000 MB or smaller to be imported. Your computer may have problems opening a CSV file that is larger than 50 MB - a macro is available for splitting large files.
Before you import
Detailed instructions are available on preparing for an import. Important highlights:
- If you already have data in your nation, take a snapshot before starting an import. The snapshot must finish before you begin the import.
- Make sure your file includes unique identifiers.
- Understand how importing affects existing data.
- Mapping fields ensures data isn't lost or placed incorrectly.
- Some fields only accept data in a particular format - pay attention to any restrictions indicated (Note: Commas should be deleted from your CSV, with the exception of the "tag_list" field. A list of tags should be separated by commas).
There are 7 types of imports:
This handles importing most profile information for both people and organizations. You can import from a CSV file. A list or filter shared by another nation can also be imported using the one-time import. Begin a new import and review status of previous imports at People > More > Import > One time import.
A list or filter shared by another nation can be imported using the recurring import. Public information connected to a Twitter account can also be imported using recurring import. Twitter followers imports people who follow a particular Twitter account. Twitter followings imports the profiles followed by a particular Twitter account. Begin a new recurring import at People > More > Import > New recurring import. Review and edit previous recurring imports at People > More > Import > X recurring import. "X" represents the number of active recurring imports in your nation.
This type of import requires that you enable voter features at Settings > Defaults > Basics. Import profile information for voters. This import allows you to import a larger number of signup fields, including voting districts and party affiliation. You can also request a U.S. voter file from the NationBuilder Election Center. This requires you to enable voter features in your nation. Begin a new import and review status of previous imports at People > More > Import > Voter file import.
This type of import requires that you enable voter features at Settings > Defaults > Basics. View a historical record of when elections occurred and whether an individual voted in that election. Voters must already exist in the nation for you to import vote history through the control panel. Once voters exist, ballots can be imported in the People section at People > More > Import > Ballots import.
Import information collected during a phone bank or door knock using scannable sheets. Scannable sheets include the results of a survey. Begin a new import and review status of previous imports at People > More > Import > Scanned survey import.
This type of import requires that you enable donor features at Settings > Defaults > Basics. Import donation records. Each record represents a separate transaction. Donations are stored in the financial stable, which is connected to a particular signup profile by unique identifiers. Begin a new import and review status of previous imports at Finances > More > Import donations.
This type of import requires that you enable membership features at Settings > Defaults > Basics. Memberships are stored in the membership table and are connected to a particular signup profile by unique identifiers. A signup can have more than one type of membership, but only one membership per type. Begin a new import and review status of previous imports at Settings > Defaults > Membership types > Import memberships.