Duplicate gifts are created from the Luminate Online plug in for The Raiser's Edge

When processing gifts in the RELO plugin, duplicate gifts are being created. The same gift may come into the plug in several hours or days after the first gift was processed into a batch. Usually, this occurs for TeamRaiser gifts given online.

Duplicate gifts can occur in the plugin from a variety of causes including editing processed gifts, delayed processing, or merging constituent records. Ensure you are on version 1.4.5465 or above of the Luminate Online plugin. If the issue persists explore the following:

This issue can be caused when gifts are missing the Luminate Online Gift ID attribute, or missing the value for that attribute which is usually a 4 to 6 digit number (the last 4 to 6 digits of the confirmation code on the gift in Luminate Online). The plug in uses this data to determine if the gift already exists in the database, so if it is missing, it's possible for gifts to download more than once. Ensure that all gifts that are downloaded into Batch from the Luminate Online plug in have this attribute with the 4 digit number. If they are missing the attribute, look in Luminate Online for the confirmation code and the last 4 digits, and query the database based on that number. If the gift is not yet in the database, manually enter the 4 digits into the Luminate Online Gift ID attribute description in Batch before committing.

If users see this occurring in the database, or are not sure if it is occurring, the best way to look for duplicated gifts will be to run a Raiser's Edge Gift query with the following criteria: 

Gift Information > Gift Date between [possible range affected]
AND Attributes > Specific Attributes > Luminate Online Gift ID > Luminate Online Gift ID Description not blank

Users can then output: 

Attributes > Specific Attributes > Luminate Online Gift ID > Luminate Online Gift ID Description

Sort by the same field and view the results to look for any potential duplications. On the gift, go to File > Properties to find the Batch number. Access the batch and note if the Luminate Online Gift ID attribute is missing or incomplete. The duplicated gifts may then be deleted after confirming they are duplicates. Ensure The Raiser's Edge has a current and useable backup before deleting anything from the database.

In instances where the above steps do not resolve Blackbaud has explored this as a possible issue and determined this is not a bug in the integration. Best practice to prevent duplicates is to process updates and transactions from the plugin as soon as possible. Database cleanup and merging duplicate constituent records outside the plugin should be done after all transactions have been cleared from the plugin, if possible.

Environment

 1.4.5359 ; 1.1.7
 1.4.5423

Was this article helpful?