We have some integrity checks we have written but not mechanism to run them & ensure they stay clean - e.g send fail-mail if there are contacts with no primary address or blank location types
|Open||None||T218251 Metaissue for data integrity in Civi|
|Open||None||T150388 Write a script to generate fail mail when integrity checks fail|
Basically 'no information' contacts
select * from civicrm_contact c LEFT JOIN civicrm_contribution con ON c.id = con.contact_id LEFT JOIN civicrm_contribution_soft s ON s.contact_id = c.id LEFT JOIN civicrm_relationship r ON r.contact_id_a = c.id LEFT JOIN civicrm_relationship r2 ON r2.contact_id_b = c.id LEFT JOIN civicrm_group_contact gc ON gc.contact_id = c.id AND gc.group_id =173 LEFT JOIN civicrm_value_1_prospect_5 v ON v.entity_id = c.id WHERE con.id IS NULL AND s.id IS NULL AND is_deleted = 0 AND r.id IS NULL AND r2.id IS NULL AND gc.id IS NULL AND v.id IS NULL ORDER BY c.id DESC LIMIT 5000
This task has been assigned to the same task owner for more than two years. Resetting task assignee due to inactivity, to decrease task cookie-licking and to get a slightly more realistic overview of plans. Please feel free to assign this task to yourself again if you still realistically work or plan to work on this task - it would be welcome!
For tips how to manage individual work in Phabricator (noisy notifications, lists of task, etc.), see https://phabricator.wikimedia.org/T228575#6237124 for available options.
(For the records, two emails were sent to assignee addresses before resetting assignees. See T228575 for more info and for potential feedback. Thanks!)