Transferring information from one system to another can be tricky. This HOWTO provides information on how to run imports, understanding the options when importing, and reading import status information.
If this process feels overwhelming, please email email@example.com. Our Services Team can also provide custom imports. Pricing for custom data work may be subject to an initial scoping and is available upon request.
Table of Contents
Before you import
We suggest that you take a snapshot of your nation before running imports. This allows your nation to be easily restored to its previous state if you change your mind or something goes wrong.
Step 1: Upload your file
1. Click Choose Fileand select the file from your computer.
2. Click Upload CSV file.
Step 2: Map fields
Mapping fields means telling your nation what type of data can be found in each field (column). You must map to fields available for import. Check out a complete list of fields available for import. If your field cannot be imported, you might be able to map your data as a tag or custom field.
Do the fields need to be in a certain order?
Not necessarily, but typically people order them: First name, Last name, Unique ID, Phone number, Email address, etc.
Does NB have an example CSV?
We sure do. Here's a basic import file example.
To start mapping, select the data field from the dropdown menu at the top of each column.
Keep in mind, different fields of the same name exist under different category headers which produce different results.
For example, there are a variety of Address category choices (i.e. Mailing, Work, etc.), make sure that if you have an address with multiple lines, you are using Address 1, Address 2, Address 3 under the same heading.
E.g. if I'm entering a Mailing Address with multiple lines, I need to use Address 1/2/3 under Mailing Address.
While mapping you may see some error text, don't fret. Every time fields are mapped, the system will validate the first row of data to confirm it looks correct.
In the example above, I mapped fields, but missed a step. Since the first row in this example is a header row, a validation error is displayed. I will be unable to import the file until this error is fixed.
Checking the box next to "don't import" will tell the system the first row contains header information and the second row of data will be validated. After checking the box, the following displays:
Step 3: Customize your import
The third step is defining settings for the import. Seven options appear on one-time imports. Fewer choices are included in other imports.
1. Decide whether to overwrite existing signup data. The unique ID imported with a record could connect it to an existing profile in your nation.
2. Support status- Profiles always have a support status, which is supporter, non-supporter, or prospect.
If the records being imported are people who have opted into communication, select Supporters/Non-supporters. Any new profile created with an email address, mobile number, Facebook username/ID, or Twitter login/ID will be labeled a supporter. Other profiles will be created as non-supporters.
If the records being imported are people who have not opted into communication, select Prospects. When prospects is selected, all profiles created will be labeled prospects, including records with email address, mobile number, Facebook username/ID, or Twitter login/ID.
In certain circumstances, information being imported may override the rules above. Please see how support status is determined for more information.
3. Activity stream- Decide whether to show that each profile was added in the activity stream in the Dashboard section and on the person's profile. Sometimes, this can be useful. Other times, it is just clutter.
4. Add tags to each person- Tags are like virtual sticky notes that you can attach to a person’s profile to highlight certain criteria or characteristics. It's always recommended to add a tag to any import that may be updating data so that you can filter for this group after the fact.
If a tag or tags should be added to every record imported, include it in this text box. Tags can have spaces. Including a comma separates one tag from another tag. Tags included in this text box will be appended to the tag list for each person added/updated by the import.
5. Bypass webhooks- If you check this box, no signal will be sent to the API regarding the import. Checking the box will prevent external apps/API-based integrations from updating based on the import.
6. Start import button- Until fields are mapped, you will not be able to press this button. Fields must be mapped and a unique identifier must exist before the file can be imported.
Once you click the Start importbutton, the file is loaded into the import queue. A nation can import one file at a time.
Status of imports
After clicking the Start import button, a file is added to the import queue. The status displayed with that file will be "Queued for importing, but not started yet. Refresh to check."
Once an import starts, the status will change to "importing" or "working." Information available includes:
- Completion percentage for an in-progress import.
- Number of records processed.
- Total number of records to process.
- Estimated time until the import finishes.
Once an import finishes, the status will look something like this:
Source: Click on the name of the file and a copy of the imported CSV will download to your computer.
Size: The size of the imported file.
Added: Number of records added by the import. Clicking on the number takes you to a list of the records created by the import.
Updated: Number of records updated by the import. As mentioned above, it's always recommended to add a tag to any import that may be updating data so that you can filter for this group after the fact. The "updated" number will not be clickable.
Errors: Number of errors detected in the import. Click on download CSV to view the error file. The CSV error file will only contain the first 2 megabytes of errors. The last field in each record will contain the error logged.
Time spent: Amount of time spent importing the file.
Status: When the import finished in relative time, or the current status of a queued/working import.
Imported addresses can take 2-6 hours to geocode. This aspect of the import status can be reviewed in Settings > Database > Geocoding services.