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

Reply via email to