jenkins-bot has submitted this change and it was merged. (
https://gerrit.wikimedia.org/r/380667 )
Change subject: The big group clean up.
......................................................................
The big group clean up.
Bug: T174407
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
---
A sites/all/modules/wmf_civicrm/update_7545.php
M sites/all/modules/wmf_civicrm/wmf_civicrm.install
2 files changed, 330 insertions(+), 0 deletions(-)
Approvals:
jenkins-bot: Verified
Ejegg: Looks good to me, approved
diff --git a/sites/all/modules/wmf_civicrm/update_7545.php
b/sites/all/modules/wmf_civicrm/update_7545.php
new file mode 100644
index 0000000..25dbbab
--- /dev/null
+++ b/sites/all/modules/wmf_civicrm/update_7545.php
@@ -0,0 +1,320 @@
+<?php
+
+function _wmf_civicrm_cleanup_groups() {
+ civicrm_initialize();
+
+ $groupsToAssignToLeanne = array(
+ 258 => 'Major Gifts Reporting Group',
+ 263 => 'All $1000 donors - RL',
+ 264 => 'Organization $1000+ - RL',
+ 265 => 'Individual $1000+ - RL',
+ 266 => 'Monthly Figures - Foundation Gifts under $999.99',
+ 268 => '$500+ smart group',
+ 269 => '$5k+ smart group',
+ 270 => '$1k+ smart group',
+ 272 => '100000k+ donors',
+ 287 => 'Recently modified recurring',
+ 288 => 'Total giving $1000+',
+ 289 => 'Total giving $500+',
+ );
+
+ $groupsToAssignToDanny = array(
+ 296 => '1k+ in three years to today',
+ 297 => 'Wikimedia in review newsletter',
+ 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',
+ 217 => 'Fundraiser 2010 Donors - 100-500',
+ 218 => 'Fundraiser 2010 Donors - 50-99.99',
+ 219 => 'Fundraiser 2010 Donors - 25-49.99',
+ 220 => 'Fundraiser 2010 Donors',
+ 221 => 'Fundraiser 2010 Donors - 0-24.99',
+ 244 => 'FR2011 - Past - 0200-249.99',
+ 245 => 'FR2011 - Past - 0-4.99',
+ 283 => 'Recent Worldpay donors 2',
+ 284 => 'Incomplete JP Morgan import',
+ 243 => 'FR2011 - Past Donors',
+ // 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',
+ 12 => 'Persons of Interest',
+ 14 => 'Admins_EN_WP',
+ 21 => 'Questionables',
+ 23 => 'Large Acknowledged Donors',
+ 38 => '1K+ October 2008 MG 1 Master Group',
+ 39 => 'Recipients of 10/08 $1000 exactly major gifts email',
+ 40 => 'Recipients of 10/08 $1001 - $9999 major gifts emailing',
+ 41 => 'WMF Office Bulk Mailing List',
+ 42 => 'Exclude group for MG 1 10/08 (Recent and special donations)',
+ 43 => 'Snail Mail Group for MG 10/08 Mailing',
+ 60 => 'Recipient of 12/12/08 Paper Mailing of Major Gifts Prospects',
+ 61 => 'Dexia Import Records',
+ 64 => '07/08 $1k+ Donors',
+ 71 => 'WMF Board Members 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',
+ 80 => 'Gift Renewal Email for 09-10 Fundraising Drive',
+ 83 => 'Prospects',
+ 84 => 'Open House 12/03/09 Attendees',
+ 85 => 'Fraud',
+ 86 => 'US Fraud',
+ 99 => 'WAC event Feb. 2010 (Invited)',
+ 104 => '100.00-499.99 donors 07/01/08-01/29/10',
+ 105 => 'London Prospects',
+ 107 => 'Delivered Wikimedias 2008-09 Annual Report (100.00-499.99)',
+ 108 => '02/10 Tulsa Oklahoma Prospects',
+ 111 => '2000 English Donors for Wikipedia Supporters Discussion Group',
+ 112 => 'WAC event Feb. 2010 (RSVP)',
+ 113 => 'Los Angeles Prospects',
+ 114 => '2010 Discussion Group',
+ 115 => 'Volunteered after 2010 Discussion Group was full',
+ 121 => '08/09 Annual Report Snail Mailing',
+ 122 => 'Trial Group for CiviReport',
+ 123 => 'November 09 Stewardship',
+ 125 => 'Citibank France Feb. 2010',
+ 126 => 'Stewardship Statistics General',
+ 128 => 'New York City Prospects',
+ 130 => 'Hyperlink Renewal Email Spring 2010',
+ 144 => 'Wikimedia in Peru (Responded)',
+ 145 => 'a personal thank you (Responded)',
+ 146 => 'WAC event Feb. 2010 (Attended)',
+ 149 => 'Goldman Sachs Employees',
+ 153 => 'San Francisco Bay Area Prospects',
+ 156 => 'Harnisch Inside the Globe Invitees',
+ 157 => 'July 2010 $500+ Donor Report',
+ 158 => 'Major Gifts Prospects',
+ 159 => 'Hyperlinked Benefactors Current',
+ 162 => 'Survey Group 1 (07/10)',
+ 163 => 'Survey Group 2 (07/10)',
+ 166 => 'Harnisch Inside the Globe Invitations Responded',
+ 168 => 'Harnisch Inside the Globe Invitations RSVP "Yes"',
+ 173 => 'Open Call',
+ 175 => 'Harnisch Inside the Globe Attended',
+ 176 => 'Harnisch Inside the Globe No-shows',
+ 184 => 'Harnisch Inside the Globe Regrets Email',
+ // 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',
+ 210 => 'Do Not Email Ever - Duplicates',
+ 229 => 'Quality Assurance',
+ 231 => 'JVD Group',
+ 234 => 'Wikimedia Deliverability Addresses',
+ 242 => 'Fundraiser 2011 - Donor Duplicates',
+ 250 => 'Matching Gift Soft Credits',
+ 251 => 'Imported checks to review',
+ 252 => '2011-12 5000+ and 0',
+ 253 => '100 to 299 SF',
+ 254 => 'Jimmy snail mail 2013',
+ 255 => 'hand written thank you letters 7/1/13-9/30/13',
+ 256 => '1000 and over in NYC',
+ 259 => 'Annual Report Mail out 2014',
+ 260 => 'TSmart Import',
+ 271 => 'Office Visit - Interested In',
+ // 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
+ 226 => 'Fundraiser 2010 - Email 2.r4',
+ 227 => 'Fundraiser 2010 - Email 2.r5',
+ 228 => 'Fundraiser 2010 - Email 2.r6',
+ 211 => 'Fundraiser 2010 - Donor Duplicates',
+ 212 => 'Fundraiser 2010 - Past Donors',
+ 213 => 'Fundraiser 2010 Past Donors - 100-500',
+ 214 => 'Fundraiser 2010 Past Donors - 50-99.99',
+ 215 => 'Fundraiser 2010 Past Donors - 25-49.99',
+ 216 => 'Fundraiser 2010 Past Donors - 0-24.99',
+ 222 => 'Fundraiser 2010 - Email 2.r1',
+ 223 => 'Fundraiser 2010 - Email 2.r3',
+ 224 => 'Fundraiser 2010 - Email 2.r2',
+ 196 => 'Fundraiser 2010 - Email 1.2',
+ 197 => 'Fundraiser 2010 - Email 1.3',
+ 198 => '$500+ Donors General Email',
+ 199 => 'Fundraiser 2010 - Email 1.4',
+ 200 => 'Fundraiser 2010 - Email 1.5',
+ 202 => 'Fundraiser 2010 - Email 1.6',
+ 203 => 'Fundraiser 2010 - Email 1.7',
+ 204 => 'Fundraiser 2010 - Email 1.8',
+ 205 => 'Fundraiser 2010 - Email 1.9',
+ 206 => 'Fundraiser 2010 - Email 1.10',
+ 207 => 'Fundraiser 2010 - Email 1.11',
+ 87 => 'Recipient of 01/10 AR mailing (100.00-499.99)',
+ 88 => 'Recipient of 01/10 AR mailing (75.00-99.99)',
+ 89 => 'Recipient of 01/10 AR mailing (50.00-74.99)',
+ 90 => 'Recipient of 01/10 AR mailing (35.00 to 39.99)',
+ 91 => 'Recipient of 01/10 AR mailing (40.00 to 49.99)',
+ 92 => 'Recipient of 01/10 AR mailing (30.00 to 34.99)',
+ 93 => 'Recipient of 01/10 AR mailing (25.00 to 29.99)',
+ 94 => 'Recipient of 01/10 AR mailing (20.00-24.99)',
+ 95 => 'Recipient of 01/10 AR mailing (15.00 to 19.99)',
+ 96 => 'Recipient of 01/10 AR mailing (10.00 to 14.99)',
+ 97 => 'Recipient of 01/10 AR mailing (5.00 to 9.99)',
+ 98 => 'Recipient of 01/10 AR mailing (1.00 to 4.99)',
+ 45 => 'Recipient of the 10/31/08 $5 Group A email',
+ 46 => 'Recipient of the 10/31/08 $5 Group B email',
+ 47 => 'Recipient of the 10/31/08 $5.01-$9.99 Group A email',
+ 48 => 'Recipient of the 10/31/08 $5.01-$9.99 Group B email',
+ 49 => 'Recipient of 10/31/08 $10 Group A email',
+ 50 => 'Recipient of 10/31/08 $10 Group B email',
+ 51 => 'Recipient of 10/31/08 $10.01 to $14.99 Group A email',
+ 52 => 'Recipient of 10/31/08 $10.01 to $14.99 Group B email',
+ 53 => 'Recipients of 10/31/08 $15.00-$19.99 Group email',
+ 54 => 'Recipients of the 10/31/08 $20 Group email',
+ 55 => 'Recipients of the 10/31/08 $20.01 to $29.99 Group email',
+ 56 => 'Recipients of the 10/31/08 $30.00 to $49.99 Group email',
+ 57 => 'Recipient of the 10/31/08 $50 Group email',
+ 58 => 'Recipient of the 10/31/08 $50.01 to $100.00 Group email',
+ 59 => 'Recipient of 10/31/08 $100.01 to $999.99 Group email',
+ 150 => 'Wikipedias new look email recipients (05/10)',
+ 151 => 'Wikipedias new look email replied (05/10)',
+ 152 => 'Wikipedias new look email opened',
+ 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+)',
+ // 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',
+ 132 => '4/16/10-4/23/10 Paypal',
+ 133 => 'April 2010 Missing Contributions',
+ 134 => 'April 2010 Import 2',
+ 135 => 'April 29 Import',
+ 136 => '5/4/10',
+ 137 => '4/29',
+ 138 => 'April Errors',
+ 140 => '5/5/10 Import',
+ 142 => 'Temporary',
+ 143 => '5/7/10',
+ 147 => '5/10/10',
+ 148 => 'Sample Group 5/14',
+ 109 => 'Nov. 2010 Moneybookers Import',
+ 110 => 'Dec. Moneybookers Import',
+ 116 => 'Citibank France Dec. 2009',
+ 117 => 'Jan. 2010 Citibank France Import',
+ 118 => 'Dec. 2009 Citibank France Import',
+ 119 => 'Jan. 2010 Moneybookers Import',
+ 120 => 'Nov. 2009 Citibank France Import',
+ // 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)',
+ 81 => 'Megans Import Group 11/17/2009',
+ 82 => 'Missing Contribution Import 11/18/2009',
+
+
+ // empty
+ 154 => 'Bay Area Prospects',
+ 155 => 'Sample Group 6/3/10',
+ 261 => 'Current Donors US (Foundations) (empty)',
+ 262 => 'Benefactor Donors - Rosie Lewis (empty)',
+
+ // Tests & broken.
+ 235 => 'FR2011',
+ 267 => 'Test - Scheduled Reminders',
+ 236 => '$20 Test Group 1',
+ 237 => '$20 Test Group 2',
+ 238 => '$20 Test Group 3',
+ 239 => '$20 Test Group 4',
+ 240 => '$20 Test Group 5',
+ 241 => '$20 Test Group 6',
+ 25 => 'CiviTest',
+ 26 => 'Test',
+ 27 => 'Saras Spreadsheet for Rhandler',
+ 29 => 'Community Gifts Test Group',
+ 275 => 'International Checks - Test France',
+ 232 => 'JVD TEST GROUP',
+ 233 => 'Jamess Civi Test Group',
+ 230 => 'Josh TEST',
+ 225 => 'Peters Ltd Test Group',
+ 195 => 'Brians Delivery Test Group',
+ 188 => 'Brian Sisolaks Test Group',
+ 189 => 'Cookie Experiment Group 1',
+ 190 => 'Cookie Experiment Group 2',
+ 191 => 'Cookie Experiment Group 3',
+ 192 => 'Peters Test Group',
+ 174 => 'Staff test group - Open Call Mailing',
+ 185 => 'Webitects Fundraiser Testing Email Group 2',
+ 186 => 'Webitects Testing Email Group 3',
+ 15 => 'Rand Test',
+ 17 => 'Robs Test Group',
+ 75 => 'Rand Deleter 1',
+ 100 => 'Tomasz Test',
+ 129 => 'Stevens Test Group',
+ 181 => 'Webitects Fundraiser Testing Email',
+ 183 => 'Cookie Experiment Master Group',
+ 248 => 'Test Donor Search Group',
+ 34 => 'Email Address Known to be Invalid',
+ 63 => 'Chars Wanted USA email',
+ 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) {
+ civicrm_api3('Group', 'create', array('id' => $group_id, 'created_id' =>
11027170));
+ }
+ foreach (array_keys($groupsToAssignToDanny) as $group_id) {
+ 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));
+ }
+
+}
\ No newline at end of file
diff --git a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
index 331df2c..18ec7dd 100644
--- a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
+++ b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
@@ -3122,3 +3122,13 @@
}
}
+
+/**
+ * Clean up CiviCRM groups.
+ *
+ * T174407.
+ */
+function wmf_civicrm_update_7545() {
+ require_once('update_7545.php');
+ _wmf_civicrm_cleanup_groups();
+}
--
To view, visit https://gerrit.wikimedia.org/r/380667
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I2385a06632c761695e199397c5d56b7d04b8ce14
Gerrit-PatchSet: 5
Gerrit-Project: wikimedia/fundraising/crm
Gerrit-Branch: master
Gerrit-Owner: Eileen <[email protected]>
Gerrit-Reviewer: Ejegg <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
