Cleaning Addresses Using Merge Files and Import
It is common to discover that street addresses have not been entered consistently. Cleaning this up can be accomplished by using the Create Merge File function to export records to Excel, cleaning them in Excel, and then importing the corrected information back in to Silent Partner.
Step 1. Create your Merge File
From the Donor screen, click the "Merge File" button.
Select "Extensive" (codes amounts etc.), and under "Merge format" select .csv. Next, tell Silent Partner where to save the file.
Close the Merge Statistics window without making any changes.
Silent Partner will create a .csv file that you can open in Excel. Delete any columns you don't need to update.
Do not delete the donor number column (donorno), and be careful to keep the correct Donor Number with the correct information!
The Donor Number tells Silent Partner where to upload the changes.
The Donor Number tells Silent Partner where to upload the changes.
Do Not Delete
Step 2. Correct the information in Excel
Excel provides great tools for finding the address details you need to correct, and replacing these with the corrected information, which makes it much faster and easier for you to make the changes you want to see.
Step 3. Import the corrected information back into Silent Partner
As mentioned above, Silent Partner uses the Donor Number to match the information in your Excel spreadsheet with the correct record in Silent Partner.
- From the main green screen, select Maintenance > Import Data.
- Select the "Update existing addresses" option.
- If the file includes headers indicating what is in each column, mark that option "yes."
- Search for the file and follow the prompts to import the updated addresses.
- Select which fields from the spreadsheet to import, and click 'OK".
You only need to import those fields where you have made changes. For example, if you have been cleaning up street addresses, only import those fields. The more fields you import the longer the import will take.
Note: DONORNO field is mandatory (the donor number). You must search for, and include, this field in the Import.
Our products got an upgrade!
Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!
Related Articles
Using a merge file to create a complete donor list
Using a merge file to create a complete donor list Version 2, last updated by sam.arcamone887488 at 2016-08-03 N.B This is for a customer that wants to create a donor contact list with all the information included when the donor list report just ...Bulk add Connectors and/or My Tags
Starting from your Green Screen, go to Maintenance and please click Import Data Here you will be presented with the External File Import wizard. You have the options of Updating existing addresses or Import new names/addresses (default) Under File ...Common receipt correction questions and solutions
These are some of the most commonly asked support questions about receipting. “The name/address is wrong on a donor’s receipt. How do I fix this?” Solution https://support.silentpartnersoftware.com/portal/en/kb/articles/new-receip “I receipted one ...Campaigns / Bulk Mail
From Silent Partner Cloud, go to Communications > Campaigns > Campaign Menu. With Bulk Mail you have the option to view current, active campaigns or to create new campaigns. Campaigns can be either email campaigns or print campaigns. In this ...Receipt Correction Process
The receipt correction process allows the user to choose between replacing a receipt or correcting a receipt, and whether or not to include "Cancels and Replaces" on the new receipt. Use the flowchart below to help you determine whether you need to ...
Societ Academy
Learn what you need to know, any time. Free!
- High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
- Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
- A certificate of completion - you can request a certificate of completion for every session you attend.