Page MenuHomePhabricator
Create Task
Maniphest T420992

Backfill location type for emails for existing contacts using Apple, Google, Amazon, Venmo or PayPal
Open, MediumPublic
Actions

Description

Now that we've updated our logic, we should backfill this data for existing contacts.

We will need to base this on current recurring donation where present, most recent donation where there is no recurring and to check for changes to the email since the most recent donation (which might indicate the email has been changed in email prefs center or by DR) and not update emails which have been changed since then.

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Backfill email location type when current primary is Main or Billing (all types including ACH).wikimedia/fundraising/crmmaster+105 -3
Backfill primary email location types based on latest donation payment methodwikimedia/fundraising/crmmaster+25 -19
Backfill contact with ach location typewikimedia/fundraising/crmmaster+131 -8
Backfill primary email location types based on latest donation payment methodwikimedia/fundraising/crmmaster+46 -0
Customize query in gerrit

Related Objects

Event Timeline

Lars created this task.Mar 23 2026, 7:41 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 23 2026, 7:41 PM
Lars moved this task from Triage to Chaos Crew Backlog on the Fundraising-Backlog board.Mar 23 2026, 7:42 PM
SBurnett-WMF triaged this task as Medium priority.Mar 30 2026, 8:22 PM
Lars mentioned this in T422051: Demote rather than overwrite non-Home email types when changing email in email preferences center.Apr 1 2026, 3:42 PM
AnnWF claimed this task.Apr 9 2026, 6:27 PM
AnnWF moved this task from Backlog to In Progress on the Fundraising Tech - Chaos Crew board.
gerritbot added a comment.Apr 10 2026, 3:19 AM

Change #1269791 had a related patch set uploaded (by Wfan; author: Wfan):

[wikimedia/fundraising/crm@master] Backfill contact with special location type

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

gerritbot added a project: Patch-For-Review.Apr 10 2026, 3:19 AM
AnnWF moved this task from In Progress to Ready for Review on the Fundraising Tech - Chaos Crew board.Apr 10 2026, 3:19 AM
AnnWF moved this task from Ready for Review to Being Reviewed on the Fundraising Tech - Chaos Crew board.Apr 14 2026, 6:05 PM
gerritbot added a comment.Tue, Apr 28, 12:11 AM

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

[wikimedia/fundraising/crm@master] Backfill primary email location types based on latest donation payment method

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

gerritbot added a comment.Tue, Apr 28, 12:51 AM

Change #1277798 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Backfill primary email location types based on latest donation payment method

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

AnnWF moved this task from Being Reviewed to Pending Deployment on the Fundraising Tech - Chaos Crew board.Tue, Apr 28, 7:16 PM
gerritbot added a comment.Tue, Apr 28, 8:18 PM

Change #1269791 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Backfill contact with ach location type

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

Maintenance_bot removed a project: Patch-For-Review.Tue, Apr 28, 8:32 PM
AnnWF moved this task from Pending Deployment to Done on the Fundraising Tech - Chaos Crew board.Tue, Apr 28, 11:41 PM
gerritbot added a comment.Fri, May 1, 12:53 PM

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

[wikimedia/fundraising/crm@master] Backfill primary email location types based on latest donation payment method

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

gerritbot added a project: Patch-For-Review.Fri, May 1, 12:53 PM
gerritbot added a comment.Fri, May 1, 1:47 PM

Change #1281488 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Backfill primary email location types based on latest donation payment method

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

Lars moved this task from Done to Pending Deployment on the Fundraising Tech - Chaos Crew board.Fri, May 1, 1:52 PM
Maintenance_bot removed a project: Patch-For-Review.Fri, May 1, 2:31 PM
gerritbot added a comment.Sat, May 2, 12:23 PM

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

[wikimedia/fundraising/crm@master] Backfill email location type when current primary is Main or Billing (all types including ACH).

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

gerritbot added a project: Patch-For-Review.Sat, May 2, 12:23 PM
gerritbot added a comment.Sat, May 2, 12:48 PM

Change #1281757 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Backfill email location type when current primary is Main or Billing (all types including ACH).

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

Maintenance_bot removed a project: Patch-For-Review.Sat, May 2, 1:30 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits