Mwalker has uploaded a new change for review.
https://gerrit.wikimedia.org/r/115814
Change subject: Look for email opt outs, not mail optouts
......................................................................
Look for email opt outs, not mail optouts
Change-Id: I8dd523e3a108149e9464b92ba3e5845307a50373
---
M silverpop_export/update_table.sql
1 file changed, 2 insertions(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools
refs/changes/14/115814/1
diff --git a/silverpop_export/update_table.sql
b/silverpop_export/update_table.sql
index e1e7526..bb63f04 100755
--- a/silverpop_export/update_table.sql
+++ b/silverpop_export/update_table.sql
@@ -63,7 +63,7 @@
SELECT
e.id, e.contact_id, e.email, c.first_name, c.last_name,
IF(SUBSTRING(c.preferred_language, 1, 1) = '_', 'en',
SUBSTRING(c.preferred_language, 1, 2)),
- (c.is_opt_out OR c.do_not_mail)
+ (c.is_opt_out OR c.do_not_email)
FROM civicrm.civicrm_email e
LEFT JOIN civicrm.civicrm_contact c ON e.contact_id = c.id
WHERE
@@ -73,7 +73,7 @@
first_name = c.first_name,
last_name = c.last_name,
preferred_language = IF(SUBSTRING(c.preferred_language, 1, 1) = '_', 'en',
SUBSTRING(c.preferred_language, 1, 2)),
- opted_out = (c.is_opt_out OR c.do_not_mail);
+ opted_out = (c.is_opt_out OR c.do_not_email);
-- 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/115814
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I8dd523e3a108149e9464b92ba3e5845307a50373
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/tools
Gerrit-Branch: master
Gerrit-Owner: Mwalker <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits