If a donor donates twice within the same flat file, Omatic Cloud will generate duplicate records for that donor in Raiser's Edge (because it sends records all at once). In contrast, ImportOmatic sends records one at a time, so if a new donor gives twice, it will be matched the second time.

This is especially problematic for events, when a donor will both buy a registration ticket and make a donation within the same flat file. Multiply this by the majority of the attendees for the event and it results in an excessive number of duplicates. This is a big problem for us.

Pressing "reprocess all" when a duplicate is found was provided as the only fix. However, when dealing with large files, it is impossible for the person importing to catch all the duplicates. Sorting the list by last name helps, as it groups together the duplicates but it is twice the work, scanning all records for duplicates, then processing all records.

We generated over 200 duplicates over a 2 month period (for 2 large events).

Please resolve.