Page MenuHomePhabricator

Creation of new anonymous records on donation import
Closed, ResolvedPublic

Description

@RLewis and @Elbar53 helped identify an issue with imports creating new anonymous records instead of them all going to CID 72. The gifts have been moved but the CIDs that were created are: 67781557, 67781556, 67781558. These were from the 5/5 dated Engage individual gift import. I checked the import and screenshotted the dedupe rule below, which is what it has always been set to. Not sure if it's connected to that or some other settings?

Screenshot 2025-05-19 at 2.57.25 PM.png (122×380 px, 13 KB)

Since we do imports weekly this could cause some congestion and multiple record creation in Civi, but we will try to keep an eye on it until it's fixed and manually move gifts as needed. Thanks!

Event Timeline

XenoRyet triaged this task as Medium priority.May 19 2025, 8:17 PM
XenoRyet moved this task from Triage to Chaos Crew Backlog on the Fundraising-Backlog board.
XenoRyet raised the priority of this task from Medium to High.May 20 2025, 6:03 PM

@MDemosWMF I'm seeing some recent examples of this (e.g. CID 68458130, 68458126 earlier this month), so this seems to be still a live issue. Would you be able to provide the rows from the csv that were imported for these or if not available, just a sample row of a similar import for the anonymous donor?

And just to confirm, when you're importing you're using the rule Email OR first + last + street (ref Melanie) (First Match)?

@Lars thanks for checking in on this! Yes, looks like the issue is still happening. I pulled the two transactions you found into a file saved here.

That looks like it's the dedupe rule we have the import set to. Here is the link to the template mapping as well: https://civicrm.wikimedia.org/civicrm/import_mapping?id=1285

Seems like both of those gifts were from the Engage Individual import (WMF not END)

Screenshot 2025-09-15 at 12.42.12 PM.png (238×678 px, 27 KB)

Lars lowered the priority of this task from High to Medium.Sep 22 2025, 1:16 PM
Lars renamed this task from Creation of new anonymous records to Creation of new anonymous records on donation import.Oct 8 2025, 3:51 PM
Lars removed Lars as the assignee of this task.Dec 4 2025, 6:14 PM

Change #1226402 had a related patch set uploaded (by Lars SG; author: Lars SG):

[wikimedia/fundraising/crm@master] Ensure anonymous donations are put on the anonymous contact

https://gerrit.wikimedia.org/r/1226402

Change #1226402 merged by Eileen:

[wikimedia/fundraising/crm@master] Ensure anonymous donations are put on the anonymous contact

https://gerrit.wikimedia.org/r/1226402

Change #1226465 had a related patch set uploaded (by Lars SG; author: Lars SG):

[wikimedia/fundraising/crm@master] Add test for ensuring anon donations added to anon contact

https://gerrit.wikimedia.org/r/1226465

There is also an additional task here: clean up all the duplicate Anonymous contacts created (I believe since April).

Change #1226465 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Add test for ensuring anon donations added to anon contact

https://gerrit.wikimedia.org/r/1226465

Change #1228567 had a related patch set uploaded (by Lars SG; author: Lars SG):

[wikimedia/fundraising/crm@master] Merge anonymous contacts

https://gerrit.wikimedia.org/r/1228567

Change #1228567 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Merge anonymous contacts

https://gerrit.wikimedia.org/r/1228567

About 2000 anon contacts have been merged.

Damilare set Final Story Points to 4.