Eileen has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/380667 )
Change subject: Changes to group clean up based on feedback from Caitlin.
......................................................................
Changes to group clean up based on feedback from Caitlin.
In response to Caitlin's feedback I have assigned the groups she queried to her
& removed from the delete list.
They can then be followed up on outside this bulk process, with Caitlin denoted
as the authority
Bug: T174407
Change-Id: I2385a06632c761695e199397c5d56b7d04b8ce14
---
M sites/all/modules/wmf_civicrm/update_7545.php
1 file changed, 55 insertions(+), 14 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm
refs/changes/67/380667/1
diff --git a/sites/all/modules/wmf_civicrm/update_7545.php
b/sites/all/modules/wmf_civicrm/update_7545.php
index 4aecea8..25dbbab 100644
--- a/sites/all/modules/wmf_civicrm/update_7545.php
+++ b/sites/all/modules/wmf_civicrm/update_7545.php
@@ -24,7 +24,28 @@
298 => 'Wikimedia board report recipients',
);
+ // These are all groups that Caitlin raised a query about.
+ // By assigning them to her we denote that she at least knows something about
+ // their possible future usefulness.
+ $groupsToAssignToCaitlin = array(
+ 72 => 'WMF Advisory Board 09',
+ 1 => 'WMF Staff',
+ 273 => 'Attended London Event 2014',
+ 276 => 'MG Year End Appeal 2014',
+ 277 => 'Receives WMF Quarterly Report',
+ 278 => 'Work Place Giving Donors 2014',
+ 279 => 'TSmart Import US and 5000+',
+ 280 => 'TSmart Import 50 - 150 miles of SF',
+ 281 => 'TSmart Import 0 - 150 miles of LA',
+ 187 => 'Do Not Email Ever',
+ 18 => 'RHandlers Spreadsheet',
+ 20 => 'Rebeccas Prospects',
+ 160 => 'News from Wikimedia Email',
+ 161 => 'News from Wikimedia Email Responded',
+ );
+
$groupsToDelete = array(
+ // per email
30 => 'Do Not Trade',
33 => 'Organizations',
37 => 'People Opted-Out',
@@ -38,7 +59,10 @@
283 => 'Recent Worldpay donors 2',
284 => 'Incomplete JP Morgan import',
243 => 'FR2011 - Past Donors',
- 1 => 'WMF Staff',
+ // Comment from Caitlin V:
+ // I don't need to keep these groups specifically, but I would like WMF
Staff and former board members noted in Civi. Is a group or a tag the correct
way to note that? (Staff has a tag right now)
+ //
+ // 1 => 'WMF Staff',
7 => 'Committees',
8 => 'Project Contacts',
11 => 'Vendors',
@@ -56,7 +80,9 @@
61 => 'Dexia Import Records',
64 => '07/08 $1k+ Donors',
71 => 'WMF Board Members 09',
- 72 => 'WMF Advisory Board 09',
+ // Comment from Caitlin V:
+ // I don't need to keep these groups specifically, but I would like WMF
Staff and former board members noted in Civi. Is a group or a tag the correct
way to note that? (Staff has a tag right now)
+ // 72 => 'WMF Advisory Board 09',
73 => 'Recurring Donors 09',
74 => 'Imported Moneybookers',
77 => 'Hyperlinked Benefactors Past',
@@ -99,7 +125,9 @@
175 => 'Harnisch Inside the Globe Attended',
176 => 'Harnisch Inside the Globe No-shows',
184 => 'Harnisch Inside the Globe Regrets Email',
- 187 => 'Do Not Email Ever',
+ // Comment from Caitlin
+ //This is a big group (32k). I looked at a sampling of them and none were
marked in our current best practice ways (Communication Preferences - Privacy -
Do Not Email). Is there way to update these records to the current best
practice.
+ //187 => 'Do Not Email Ever',
194 => 'Focus Group Appeal (Usability)',
208 => '2010 Snail Mail Campaign',
209 => '2010 Fundraiser Donors',
@@ -118,13 +146,15 @@
259 => 'Annual Report Mail out 2014',
260 => 'TSmart Import',
271 => 'Office Visit - Interested In',
- 273 => 'Attended London Event 2014',
- 276 => 'MG Year End Appeal 2014',
- 277 => 'Receives WMF Quarterly Report',
- 278 => 'Work Place Giving Donors 2014',
- 279 => 'TSmart Import US and 5000+',
- 280 => 'TSmart Import 50 - 150 miles of SF',
- 281 => 'TSmart Import 0 - 150 miles of LA',
+ // Comment from Caitlin:
+ // These are relatively recent groups. Is the membership in this group
noted in another way in Civi? Ie, If someone attended the 2014 London event, is
that noted as an activity in their record?
+ //273 => 'Attended London Event 2014',
+ //276 => 'MG Year End Appeal 2014',
+ //277 => 'Receives WMF Quarterly Report',
+ //278 => 'Work Place Giving Donors 2014',
+ //279 => 'TSmart Import US and 5000+',
+ //280 => 'TSmart Import 50 - 150 miles of SF',
+ //281 => 'TSmart Import 0 - 150 miles of LA',
282 => 'Recent Worldpay donors',
// Mailings related
@@ -184,8 +214,10 @@
193 => 'Fundraiser 2010 - Email 1',
101 => 'Recipient of 01/10 AR mailing (500.00-9999.99)',
102 => 'Recipient of 01/10 AR mailing (10,000+)',
- 160 => 'News from Wikimedia Email',
- 161 => 'News from Wikimedia Email Responded',
+ // Comment from Caitlin
+ //Do these groups have anything to do with the current MGF newsletter list?
+ // 160 => 'News from Wikimedia Email',
+ // 161 => 'News from Wikimedia Email Responded',
// kinda meaningless
131 => '4/28/10',
@@ -208,8 +240,9 @@
118 => 'Dec. 2009 Citibank France Import',
119 => 'Jan. 2010 Moneybookers Import',
120 => 'Nov. 2009 Citibank France Import',
- 18 => 'RHandlers Spreadsheet',
- 20 => 'Rebeccas Prospects',
+ // These are past major gift prospects, that KThaney and I should be aware
of. Let's keep them for now please.
+ //18 => 'RHandlers Spreadsheet',
+ // 20 => 'Rebeccas Prospects',
16 => 'To Be Reviewed',
249 => 'Edit List - Renee',
103 => '($100-499.99) Tagged for Review only (01/10 Mailing)',
@@ -263,6 +296,10 @@
293 => 'RL DAF TYLs test',
294 => 'DAF test',
+ // Missed off email but I think it is OK.
+ 139 => 'Wikipedia in Peru Video',
+ 79 => 'Open House Open House 12/03/09 RSVP',
+ 78 => 'Open House Open House 12/03/09',
);
foreach (array_keys($groupsToAssignToLeanne) as $group_id) {
@@ -272,6 +309,10 @@
civicrm_api3('Group', 'create', array('id' => $group_id, 'created_id' =>
15757664));
}
+ foreach (array_keys($groupsToAssignToCaitlin) as $group_id) {
+ civicrm_api3('Group', 'create', array('id' => $group_id, 'created_id' =>
4846156));
+ }
+
foreach (array_keys($groupsToDelete) as $group_id) {
civicrm_api3('Group', 'delete', array('id' => $group_id));
}
--
To view, visit https://gerrit.wikimedia.org/r/380667
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I2385a06632c761695e199397c5d56b7d04b8ce14
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/crm
Gerrit-Branch: master
Gerrit-Owner: Eileen <emcnaugh...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
