Mwalker has submitted this change and it was merged.
Change subject: Update to Silverpop Export Script for Bad Languages
......................................................................
Update to Silverpop Export Script for Bad Languages
Change-Id: Iaece4a456bf7ffa36949d41e7e0b1ac2aef5097b
---
M silverpop_export.sql
1 file changed, 2 insertions(+), 2 deletions(-)
Approvals:
Mwalker: Verified; Looks good to me, approved
diff --git a/silverpop_export.sql b/silverpop_export.sql
index 9a008fb..24da369 100755
--- a/silverpop_export.sql
+++ b/silverpop_export.sql
@@ -53,7 +53,7 @@
(contact_id, email, first_name, last_name, preferred_language)
SELECT
e.contact_id, e.email, c.first_name, c.last_name,
- SUBSTRING(c.preferred_language, 1, 2)
+ IF(SUBSTRING(c.preferred_language, 1, 1) = '_', 'en',
SUBSTRING(c.preferred_language, 1, 2))
FROM civicrm.civicrm_email e, civicrm.civicrm_contact c
WHERE
e.email IS NOT NULL AND e.email != '' AND
@@ -264,4 +264,4 @@
(SELECT (RAND() * (SELECT MAX(id) FROM silverpop_export)) AS id) AS r2
WHERE r1.id >= r2.id
ORDER BY r1.id ASC
- LIMIT 1000;
\ No newline at end of file
+ LIMIT 1000;
--
To view, visit https://gerrit.wikimedia.org/r/77921
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Iaece4a456bf7ffa36949d41e7e0b1ac2aef5097b
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/tools
Gerrit-Branch: master
Gerrit-Owner: Mwalker <[email protected]>
Gerrit-Reviewer: Mwalker <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
