After mapping fields for import, the next step is deciding whether to overwrite existing data.
This checkbox refers to signup fields in your import. Signup fields are directly connected to a person's profile. If you check the box to overwrite existing data, the signup data contained in your .CSV file will permanently replace data already stored in your database. The only signup field not affected by this checkbox is the tag field.
- Decide where the most accurate data is
- Importing tags
- Donation imports
- Membership imports
- Related HOWTOs
Decide where the most accurate data is
Overwriting existing data is a good option if:
- You invite people to an event and they give you their current contact information. You place this information in a spreadsheet and then upload it to your nation.
- You attend a conference, meeting in person with people you previously only contacted online. They give you their personal contact details. You place this information in a spreadsheet and upload it to your nation.
Ultimately, you're completely confident that the information you are importing into your nation was gathered more recently and is more accurate than the information that already exists in your database.
You should not overwrite existing data if:
- You're importing a list of people who signed a petition six months ago.
- You're importing an event attendee list from a year ago.
- You're importing information from a defunct chapter of your organization that hasn't been active in three years.
Basically, if you aren't confident that the information being imported is more recent and more accurate than the information in your nation, do not overwrite existing data.
Existing data cannot be cleared by importing empty fields. Imports can overwrite data with new information, they cannot remove data without replacing it. A few fields can be cleared using batch update. If you need help removing information from your nation, please email email@example.com. Our services team may be able to help you.
Tags will be appended to a person's profile during most imports. Tags are appended to a person's profile during a one-time import, a voter file import, and a voter history import. If you map to the "tag_list" field in a donation import, the donor's tag list will be overwritten by the tags imported. You cannot map to the "tag_list" field during a membership import.
Tags added to every record imported using the "Add tags to each person" text box on the import screen will always be appended to a profile.
In a donation import, the "overwrite existing data" checkbox refers to signup fields being imported, not to donations.
Individual donations exist in a separate table from profile information. Most donation imports will add new transactions to a nation's financial database. If you include a NationBuilder donation ID on an imported donation record, an existing donation will be updated. Mapping to a NationBuilder donation ID will always overwrite existing financial information. This is true whether or not you check the "overwrite existing data" checkbox.
Similarly, membership information exists in a separate table from profile information. A person can have multiple membership types, but only one membership per type. Therefore, membership imports always update membership information associated with a person.
The "overwrite existing data" checkbox in a membership import refers to signup fields, not to information related to a membership.