Page MenuHomePhabricator

Clean up supplemental address 1 data in CiviCRM
Closed, ResolvedPublic

Description

To be completed before Dec 1 before next Faircom export.

From email:
For the Supplemental Address 1, we have 123k. Here's a SearchKit if you want to take a look. There are a significant percentage that are the contact's name again and some where it is the same as the Street Address field (these are presumably auto-fill failures on the donor's end). I could delete the supplemental address in these two cases, if that would be helpful. But overall, I mostly see apartments, PO boxes or street addresses when we have PO Boxes in the Street Address, and business names, which seem like reasonable data that we would want on letters.

Event Timeline

Lars triaged this task as Medium priority.Nov 19 2025, 9:25 PM
Lars moved this task from Triage to Chaos Crew Backlog on the Fundraising-Backlog board.
Lars updated the task description. (Show Details)

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

[wikimedia/fundraising/crm@master] Set supplemental address to NULL where it is equal to display name

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

I covered the case where the street and supplemental address were the same via UI as it was not a large number.

Change #1207934 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Set supplemental address to NULL where it is equal to display name

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

@MRitch-WMF @JMando These extraneous supplemental addresses have been cleaned up.

XenoRyet set Final Story Points to 2.