[00:00:47] (03CR) 10CI reject: [V: 04-1] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930729 (owner: 10Wfan) [00:05:15] (03PS1) 10Wfan: Fix mid-tier to 5 years [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930730 (https://phabricator.wikimedia.org/T336305) [00:05:17] (03PS1) 10Wfan: Data Axle project - update segment 1 [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930731 (https://phabricator.wikimedia.org/T336891) [00:05:19] (03PS1) 10Wfan: Update code references to Contribution tracking: wmf_civicrm_get_contribution_tracking in tracking.inc [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930732 (https://phabricator.wikimedia.org/T339158) [00:05:21] (03PS1) 10Wfan: Update silverpop in vendor [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930733 [00:05:23] (03PS1) 10Wfan: Updated generated triggers [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930734 (https://phabricator.wikimedia.org/T336305) [00:05:25] (03PS1) 10Wfan: Update RecurringQueueConsumer to handle donation upgrades [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930735 (https://phabricator.wikimedia.org/T335827) [00:06:52] (03CR) 10CI reject: [V: 04-1] Updated generated triggers [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930734 (https://phabricator.wikimedia.org/T336305) (owner: 10Wfan) [00:06:58] (03CR) 10CI reject: [V: 04-1] Update silverpop in vendor [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930733 (owner: 10Wfan) [00:07:06] (03CR) 10CI reject: [V: 04-1] Update RecurringQueueConsumer to handle donation upgrades [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930735 (https://phabricator.wikimedia.org/T335827) (owner: 10Wfan) [00:09:43] (03Abandoned) 10Wfan: Update silverpop in vendor [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930733 (owner: 10Wfan) [00:09:49] (03Abandoned) 10Wfan: Updated generated triggers [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930734 (https://phabricator.wikimedia.org/T336305) (owner: 10Wfan) [00:09:55] (03Abandoned) 10Wfan: Update RecurringQueueConsumer to handle donation upgrades [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930735 (https://phabricator.wikimedia.org/T335827) (owner: 10Wfan) [02:08:42] thanks for engaging on all that eileen_ . For the cancel brainstorm doc - I think ultimately they want to be able to run reports and segment in the future based on the reason for recurring cancels, and it feels like a drop down that will give consistent language to each cancel reason will help them with queries . So whether that's in the existing cancel field or a new custom field doesn't matter (I think) [02:08:55] Whatever is more sustainable for us longer term (e.g. if a new reason is added). [02:09:06] ok cool [02:09:57] I think a custom field is probably going to make future us like current us more [02:12:31] I don't know if there are any downsides to a custom field, or if the existing [old] field would cause confusion if people try to use it instead of the custom field. [02:12:59] also feel free to direct any google doc pings to me [02:13:19] I'll go check out the one you mentioned [02:13:24] thanks [02:15:46] your failed suggestion makes sense to me - the goal would be that we could look at a supporter's record (or create a report several months/years down the line to pull out a segment) and tell why they cancelled. We could create a special communication for those who cancelled because of financial issues for example. And... [02:16:53] yeah - I think ejegg|away made the point that they really want it in the same field thought [02:17:29] ...if an existing monthly donor, who all of a sudden has consecutive credit card failures [i.e. a monthly donation and subsequent retries fail] then I do think it makes sense that we are somehow automatically able to populate this field with that information - whether we call it failed or whatever. A bonus [that they haven't asked for] would be to indicate the payment processor failure code if we have that [02:19:48] also eileen_ I can take on shopping around the https://phabricator.wikimedia.org/T339314 task to fundraising next week to ensure folks input? I do think like you said that ops should be the decider... [02:19:54] yeah - this is the bit of our code where we set to cancelled [02:19:54] if ($cancelRecurringDonation) { [02:19:54] // @todo note the core terminology would moe accurately set this to Failed [02:19:54] // leaving cancelled for something where a user or staff member made a choice. [02:19:54] $params['contribution_status_id'] = 'Cancelled'; [02:19:55] $params['cancel_date'] = UtcDate::getUtcDatabaseString(); [02:19:55] } [02:20:18] that's cool [02:20:55] anilk: yeah re those fields - Erica seems to have made a call - I just want to cover our bases by ensuring that if anyone's pov was missed in that then they get a chance to express it [02:21:00] maybe it's too confusing to ask for the decline codes, I have no idea if they are consistent across providers/markets [02:21:17] nothing is consistent across providers [02:22:12] wah - okay that would be real messy then [02:22:21] failed and date makes sense to me [11:24:48] (03CR) 10Damilare Adedoyin: "recheck" [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/929763 (https://phabricator.wikimedia.org/T335912) (owner: 10Wfan) [11:26:51] (03CR) 10CI reject: [V: 04-1] Cancel recurring upgrade [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/929763 (https://phabricator.wikimedia.org/T335912) (owner: 10Wfan) [11:38:50] (03CR) 10Damilare Adedoyin: "Thanks wfan for the work on this, left some comments inline." [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/930515 (https://phabricator.wikimedia.org/T335912) (owner: 10Wfan) [11:52:47] (03CR) 10Damilare Adedoyin: "wfan thanks for all the work on this patch, looks like some files have lint issues and I dropped one comment inline." [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/929763 (https://phabricator.wikimedia.org/T335912) (owner: 10Wfan) [12:02:22] (03PS4) 10Damilare Adedoyin: Update code references to contribution_tracking in recurring_get_contribution_tracking_id [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/930204 (https://phabricator.wikimedia.org/T339157) [12:02:39] (03CR) 10CI reject: [V: 04-1] Update code references to contribution_tracking in recurring_get_contribution_tracking_id [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/930204 (https://phabricator.wikimedia.org/T339157) (owner: 10Damilare Adedoyin) [12:10:20] (03PS5) 10Damilare Adedoyin: Update code references to contribution_tracking in recurring_get_contribution_tracking_id [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/930204 (https://phabricator.wikimedia.org/T339157) [13:37:24] (03PS6) 10Damilare Adedoyin: Update code references to contribution_tracking in recurring_get_contribution_tracking_id [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/930204 (https://phabricator.wikimedia.org/T339157) [13:40:18] (03CR) 10Damilare Adedoyin: "Thanks eileen for the CR, I've made the recommended changes." [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/930204 (https://phabricator.wikimedia.org/T339157) (owner: 10Damilare Adedoyin) [13:43:22] 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog, 10Patch-For-Review: Data Axle project - List pull from Civi - https://phabricator.wikimedia.org/T336891 (10ERoden-WMF) Hi @AnnWF just wanted to check I haven't missed a message here (Melanie is out until next week). Is the upd... [13:57:42] 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Recurring-Donations, and 2 others: Update RecurringQueueConsumer to handle donation upgrades - https://phabricator.wikimedia.org/T335827 (10MSuijkerbuijk_WMF) @Ejegg and @JMando I wanted... [15:16:28] (03PS1) 10Damilare Adedoyin: Add additional details to recur upgrade Activity [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/930811 (https://phabricator.wikimedia.org/T335827) [16:04:57] 10Fundraising-Backlog: Fundraising Superset access request for mobile apps - https://phabricator.wikimedia.org/T339372 (10mpopov) [16:06:13] 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog, 10Patch-For-Review: Data Axle project - List pull from Civi - https://phabricator.wikimedia.org/T336891 (10AnnWF) >>! In T336891#8938796, @ERoden-WMF wrote: > Hi @AnnWF just wanted to check I haven't missed a message here (Mel... [16:13:47] 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog, 10Patch-For-Review: Data Axle project - List pull from Civi - https://phabricator.wikimedia.org/T336891 (10ERoden-WMF) Thanks @AnnWF, appreciate it. I'll take a look once it's ready and then we should be able to send over the... [16:46:11] (03Abandoned) 10Wfan: Fix mid-tier to 5 years [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930730 (https://phabricator.wikimedia.org/T336305) (owner: 10Wfan) [16:46:25] (03Abandoned) 10Wfan: Update code references to Contribution tracking: wmf_civicrm_get_contribution_tracking in tracking.inc [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930732 (https://phabricator.wikimedia.org/T339158) (owner: 10Wfan) [17:09:51] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-dlocal, 10Recurring-Donations: dLocal recurring INR success rates for 2nd month, post on-demand switch - https://phabricator.wikimedia.org/T338351 (10Cstone) The 2 ones I manually updated to one day later successfully sent the prenotification and... [17:14:19] 10Fundraising-Backlog, 10fundraising-tech-ops: Fundraising Superset access request for mobile apps - https://phabricator.wikimedia.org/T339372 (10greg) Hey, thanks for this! We'll probably get to this next week, but next week is also when we have a "maintenance window" (where our Ops folks do a lot of downtown... [17:32:39] 10Fundraising-Backlog, 10fundraising-tech-ops: Fundraising Superset access request for mobile apps - https://phabricator.wikimedia.org/T339372 (10Dwisehaupt) @greg @mpopov As a note, for access they will require a ssl client certificate and access request. Details on what is needed and the process we go throug... [17:33:49] (03PS5) 10Wfan: Update recurring upgrade for consume and for getUpgradeable [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/930515 (https://phabricator.wikimedia.org/T335912) [17:36:08] (03CR) 10Wfan: [C: 03+2] Data Axle project - update segment 1 [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930731 (https://phabricator.wikimedia.org/T336891) (owner: 10Wfan) [17:39:58] (03Abandoned) 10Wfan: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930729 (owner: 10Wfan) [17:45:18] (03PS2) 10Wfan: Data Axle project - update segment 1 [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930731 (https://phabricator.wikimedia.org/T336891) [17:45:20] (03PS1) 10Cstone: Merge commit 'ccffb4f3bfabe1f78462e704c5559272982d2012' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930850 [17:46:24] (03PS2) 10Cstone: Merge commit 'ccffb4f3bfabe1f78462e704c5559272982d2012' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930850 [17:47:49] (03CR) 10Wfan: [C: 03+2] Data Axle project - update segment 1 [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930731 (https://phabricator.wikimedia.org/T336891) (owner: 10Wfan) [17:48:35] (03Abandoned) 10Cstone: Merge commit 'ccffb4f3bfabe1f78462e704c5559272982d2012' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930850 (owner: 10Cstone) [17:48:40] (03Merged) 10jenkins-bot: Data Axle project - update segment 1 [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/930731 (https://phabricator.wikimedia.org/T336891) (owner: 10Wfan) [17:53:04] !log civicrm upgraded from d61220cd to b11db56d [17:53:06] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [18:09:33] (03PS1) 10Damilare Adedoyin: Update code references to contribution_tracking: civicrm_api3_fredge_get in wmffraud/api/v3/Fredge/Get.php [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/930851 (https://phabricator.wikimedia.org/T339160) [18:11:18] 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog: Data Axle project - List pull from Civi - https://phabricator.wikimedia.org/T336891 (10AnnWF) >>! In T336891#8939078, @ERoden-WMF wrote: > Thanks @AnnWF, appreciate it. I'll take a look once it's ready and then we should be able... [18:11:44] 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog: CT-to-Civi-Phase 1.5 - Update code references to contribution_tracking: from() in Wmffraud/form/report/Fraud.php - https://phabricator.wikimedia.org/T339381 (10Damilare) [18:13:03] 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog, 10Patch-For-Review: CT-to-Civi-Phase 1.5 - Update code references to contribution_tracking - https://phabricator.wikimedia.org/T334537 (10Damilare) [18:20:34] 10Fundraising-Backlog, 10fundraising-tech-ops: Fundraising access request for Shay Nowick - https://phabricator.wikimedia.org/T339382 (10greg) [18:20:37] 10Fundraising-Backlog, 10fundraising-tech-ops: Fundraising access request for Jazmin Tanner - https://phabricator.wikimedia.org/T339383 (10greg) [18:22:06] 10Fundraising-Backlog, 10fundraising-tech-ops: Fundraising Superset access request for mobile apps - https://phabricator.wikimedia.org/T339372 (10greg) Created T339382 and T339383 as subtasks to track the individual requests. [18:24:38] (03PS5) 10Wfan: Cancel recurring upgrade [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/929763 (https://phabricator.wikimedia.org/T335912) [18:24:50] (03CR) 10Wfan: Cancel recurring upgrade (031 comment) [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/929763 (https://phabricator.wikimedia.org/T335912) (owner: 10Wfan) [18:26:22] (03CR) 10CI reject: [V: 04-1] Cancel recurring upgrade [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/929763 (https://phabricator.wikimedia.org/T335912) (owner: 10Wfan) [18:40:44] (03PS6) 10Wfan: Cancel recurring upgrade [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/929763 (https://phabricator.wikimedia.org/T335912) [18:52:38] (03PS7) 10Wfan: Cancel recurring upgrade [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/929763 (https://phabricator.wikimedia.org/T335912) [19:04:26] 10Fundraising-Backlog, 10fundraising-tech-ops: Fundraising access request for Shay Nowick - https://phabricator.wikimedia.org/T339382 (10Dwisehaupt) [19:05:01] 10Fundraising-Backlog, 10fundraising-tech-ops: Fundraising access request for Jazmin Tanner - https://phabricator.wikimedia.org/T339383 (10Dwisehaupt) [19:06:41] 10Fundraising-Backlog, 10MediaWiki-extensions-DonationInterface, 10FR-Email: Make unsubscribe work in EmailPreferences, delete Unsub extension - https://phabricator.wikimedia.org/T223330 (10AKanji-WMF) Thanks @Ejegg - have added to Sprint +2 [20:28:37] 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog: Data Axle project - List pull from Civi - https://phabricator.wikimedia.org/T336891 (10ERoden-WMF) Thanks @AnnWF I've just reviewed and all looks good. We can send to Data Axle in one file. Please name the file "Wikimedia_Data_0... [20:30:38] 10Fundraising Sprint Go Your Own Pay, 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising Sprint Juggalology 2022, 10Fundraising Sprint Kermit hopping principle, and 7 others: Currency code/currency symbol in Thank You emails received by Donors issu... - https://phabricator.wikimedia.org/T309349 [21:07:17] PROBLEM - check_mysql on frdata2001 is CRITICAL: Slave IO: Connecting Slave SQL: Yes Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdata2001&service=check_mysql [21:08:04] ^^^ that's me. i'm rebuilding frdata1002. i'll put in the downtime. [22:27:16] RECOVERY - check_mysql on frdata2001 is OK: Uptime: 5508 Threads: 4 Questions: 4534 Slow queries: 0 Opens: 88 Open tables: 82 Queries per second avg: 0.823 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdata2001&service=check_mysql [22:30:52] 10Fundraising Sprint Cheese String Theory, 10Fundraising Sprint Discworld reformatted as ntfs, 10Fundraising Sprint High velocity swallows, 10Fundraising Sprint Incantation optimisation, and 7 others: Syn group to Acoustic should remove any existing queues before c... - https://phabricator.wikimedia.org/T306855 [22:30:54] 10Fundraising Sprint Cheese String Theory, 10Fundraising Sprint Discworld reformatted as ntfs, 10Fundraising Sprint e^🥧👀=yum, 10Fundraising-Backlog, and 2 others: Civi Searchkit should allow user to export list to acoustic - https://phabricator.wikimedia.org/T301514 (10AKanji-WMF) [22:33:41] 10fundraising-tech-ops: reimage fundraising data (frdata) role servers to Bullseye - https://phabricator.wikimedia.org/T335446 (10Dwisehaupt) [22:34:26] 10fundraising-tech-ops: reimage fundraising data (frdata) role servers to Bullseye - https://phabricator.wikimedia.org/T335446 (10Dwisehaupt) frdata1002 has been rebuilt. We can shift services back there at any point. [22:58:02] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10Dwisehaupt) [22:58:45] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10Dwisehaupt) 05Open→03Resolved a:03Dwisehaupt [23:11:08] 10Fundraising-Backlog, 10fundraising-tech-ops: Fundraising Superset access request for mobile apps - https://phabricator.wikimedia.org/T339372 (10Dwisehaupt) Access approval request sent to Lisa via email.