Restore from a backup from prior to the import.
Note : Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup article.
Note: If at all possible, we recommend restoring from a backup. Use this method only as a last resort. This may be a complex process. Only users with experience in Excel and Import who are also familiar with the constituents in the database should do the following. Otherwise, you could accidentally delete the wrong addresses.
- Create a constituent export and export the constituent name, constituent import ID or constituent id, address import ID, and address lines for the problem addresses. Export in Excel or CSV format.
Note: If the address type is not the same for all addresses accidentally imported (for example, home), you may have to export multiple addresses for each constituent.
- Open the file in Excel and ensure it includes the correct addresses. If it contains extra addresses, delete them from the Excel file. (Note: This is a manual process and requires you to look at each address in the import file. If this is not done, you may end up deleting the wrong addresses from the database.)
- Edit the file in Excel and change the address type to a new, unique address type that has never been used in the database.
- Update the addresses using Import
- Run the Alternate Address Deleter plug-in to globally delete this specific address type.