[MediaWiki-commits] [Gerrit] wikimedia...crm[master]: The big group clean up.
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 000..25dbbab --- /dev/null +++ b/sites/all/modules/wmf_civicrm/update_7545.php @@ -0,0 +1,320 @@ + '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 => '10k+ 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 - $ 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 =>
[MediaWiki-commits] [Gerrit] wikimedia...crm[master]: The big group clean up.
Eileen has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/379463 ) Change subject: The big group clean up. .. The big group clean up. Bug: T174407 Change-Id: Id7308add86b6abeddfe28dd6afb740f9450907c6 --- A sites/all/modules/wmf_civicrm/update_7545.php M sites/all/modules/wmf_civicrm/wmf_civicrm.install 2 files changed, 289 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm refs/changes/63/379463/1 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 000..081479b --- /dev/null +++ b/sites/all/modules/wmf_civicrm/update_7545.php @@ -0,0 +1,279 @@ + '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 => '10k+ 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', + ); + + $groupsToDelete = array( +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', + 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 - $ 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', +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', +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