Ejegg has uploaded a new change for review.
https://gerrit.wikimedia.org/r/175479
Change subject: Do not export email addresses for deleted contacts
......................................................................
Do not export email addresses for deleted contacts
Change-Id: I9008d74410be67fb6819486b0846ab95c00c7d6a
---
M silverpop_export/update_table.sql
1 file changed, 1 insertion(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools
refs/changes/79/175479/1
diff --git a/silverpop_export/update_table.sql
b/silverpop_export/update_table.sql
index 5d868d2..6145f89 100755
--- a/silverpop_export/update_table.sql
+++ b/silverpop_export/update_table.sql
@@ -69,6 +69,7 @@
LEFT JOIN civicrm.wmf_donor d ON d.entity_id = c.id
WHERE
e.email IS NOT NULL AND e.email != '';
+ AND c.is_deleted = 0;
-- Populate data from contribution tracking; because that's fairly
-- reliable. Do this before deduplication so we can attempt to make
--
To view, visit https://gerrit.wikimedia.org/r/175479
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I9008d74410be67fb6819486b0846ab95c00c7d6a
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/tools
Gerrit-Branch: master
Gerrit-Owner: Ejegg <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
