Page MenuHomePhabricator

Chariot imports Do some name grooming
Closed, ResolvedPublic

Description

We have an issue with Chariot data hygeine being 'a work in progress' - @MDemosWMF & I agreed to try some normalisations within our code

  1. if full_name (individual full name) is the same as 'donor_advised_fund_grant.organization_name' then treat full_name as empty
  2. if full_name ends in Fund or Account then do the same
  3. parse full_name through our name parsing library - we might already do this but in the case of https://civicrm.wikimedia.org/civicrm/contact/view?reset=1&action=view&cid=69873411 it seems the partner is not in our Partner field

Event Timeline

Change #1313455 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Chariot: audit - use getValue() function a little more, move trim

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

Change #1313472 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Chariot: Discard individual fields if they look like they are fund

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

Change #1313548 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Chariot: use our name parsing library to parse full names

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

Change #1313455 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Chariot: audit - use getValue() function a little more, move trim

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

Change #1313472 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Chariot: Discard individual fields if they look like they are fund

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

Change #1313548 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Chariot: use our name parsing library to parse full names

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