Several months ago, an import was done that ended up to have a significant percentage of bad addresses. Basically what we want to do is start over, get rid of all of those constituents and import a new list known to have correct addresses. Our organization is farily new to importing, but I know that...

Sometimes it's easy to figure out why there are duplicate rows (looking at gifts and donor has more than one or output field has potential for more than one entry - ex: phone, attribute, code) and other times it's a challenge. As Jason suggested, removing output fields may resolve issue. Sometimes...

We just converted to Student Billing 7 and now have hundreds of duplicate records in the database. We also use Blackbaud Admissions and Registrar modules, so their database and the Student Billing database are now together. Has anyone faced this problem? How did you resolve it? Going through each student...

Hi Carla, As Melissa mentioned, you can modify your duplicate criteria in Configuration. If you have it set on something fairly general like last name and first name, you can point to the file that you are planning to import and choose the options 'Validate data only' and 'Use duplicate criteria...

If you use the gift ID field, you could just pull a query with the "gift date between" for the time period you need to look in and output the gift ID and export this to access and run a query there to find duplicates. Then you can manually correct if there aren't too many. If you don't...

We have a group of gifts which may have been entered twice. We're in the midst of a staff change and gift entry is split between me and another person. I found at least (1) tribute for a gift which had already been entered. I only checked because I am familiar with this constituent's giving history...

Ah I see how what I wrote is confusing. In the Event Module, when you have an organization attending an event you have the ability to specify a Contact (via a drop down in the Partcipant/Registrant window). The individual relationship should be marked/checked as a Contact in order for the name to appear...