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

When processing gifts in the Luminate Online Management 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.

Ensure you are on version 1.4.5465 or above of the Luminate Online plug in. If the issue persists:

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 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.


 1.4.5359 ; 1.1.7

Was this article helpful?