[00:37:29] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10fundraising-tech-ops: Install `coworker` and `cv` on prod - https://phabricator.wikimedia.org/T324611 (10Eileenmcnaughton) @Dwisehaupt and I dicovered the staging issue with cv today and fixed it After that I tried to get it to run an import using ba... [02:15:49] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Fix import date handling to deal with truncated time - https://phabricator.wikimedia.org/T342716 (10Eileenmcnaughton) [02:26:41] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Unplanned-Sprint-Work: Error upon event import (Stripe) - https://phabricator.wikimedia.org/T336895 (10Eileenmcnaughton) @Jsimmonds I took another look at this & imported the handful of rows in the spreadsheet. The underlying issue is that Stripe ha... [02:29:40] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Imports to CiviCRM - make it possible to specify the default for a field without having to have a column - https://phabricator.wikimedia.org/T342717 (10Eileenmcnaughton) [02:40:40] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Make 'Full Name' available as an import field - https://phabricator.wikimedia.org/T342718 (10Eileenmcnaughton) [02:42:18] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Make 'Full Name' available as an import field - https://phabricator.wikimedia.org/T342718 (10Eileenmcnaughton) [03:00:29] (03PS1) 10Eileen: Update segment status calculation to latest understanding of specification [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941545 (https://phabricator.wikimedia.org/T342165) [04:02:19] (03PS1) 10Eileen: Update triggers to freeze 'now' to the end of financial year [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941548 [04:05:56] (03CR) 10CI reject: [V: 04-1] Update triggers to freeze 'now' to the end of financial year [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941548 (owner: 10Eileen) [04:46:36] 10Fundraising-Backlog: Civi receipt lag 26 July 2023 - https://phabricator.wikimedia.org/T342719 (10KHancock99) [04:52:57] 10Fundraising-Backlog: Civi receipt lag 26 July 2023 - https://phabricator.wikimedia.org/T342719 (10KHancock99) [04:53:12] 10Fundraising-Backlog: Civi receipt lag 26 July 2023 - https://phabricator.wikimedia.org/T342719 (10Eileenmcnaughton) We should check what the load was from the banner test [05:19:22] (03PS3) 10Eileen: Update Segment calculation to consider financial years [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/939393 (https://phabricator.wikimedia.org/T342165) [05:39:49] (03PS2) 10Eileen: Update Segment and status calculation to most recent interpretation. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941545 (https://phabricator.wikimedia.org/T342165) [05:47:04] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Import template editing issue - https://phabricator.wikimedia.org/T342722 (10Eileenmcnaughton) [05:55:40] 10Fundraising-Backlog: Certificate replacement for “signed.adyen.com" domains on August 30th, 2023 - https://phabricator.wikimedia.org/T342723 (10RKumar_WMF) [05:59:20] (03Abandoned) 10Eileen: Update Segment calculation to consider financial years [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/939393 (https://phabricator.wikimedia.org/T342165) (owner: 10Eileen) [05:59:34] (03Abandoned) 10Eileen: Update triggers to freeze 'now' to the end of financial year [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941548 (owner: 10Eileen) [05:59:48] (03Abandoned) 10Eileen: Update segment status calculation to latest understanding of specification [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/939778 (https://phabricator.wikimedia.org/T342165) (owner: 10Eileen) [06:12:52] 10Fundraising-Backlog: Civi receipt lag 26 July 2023 - https://phabricator.wikimedia.org/T342719 (10KHancock99) Confirming now, at 6am UTC same day, that this issue has resolved itself. We have returned to the usual 4-6 minute interval between donation reach and receipt send. [07:06:56] (03CR) 10CI reject: [V: 04-1] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] (REL1_38) - 10https://gerrit.wikimedia.org/r/941603 (owner: 10L10n-bot) [12:59:39] (03CR) 10Abijeet Patro: [V: 03+2] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] (REL1_38) - 10https://gerrit.wikimedia.org/r/941603 (owner: 10L10n-bot) [13:42:34] (03CR) 10Jgleeson: [C: 03+2] "LGTM! Thanks." [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941001 (https://phabricator.wikimedia.org/T341263) (owner: 10Eileen) [13:58:27] (03Merged) 10jenkins-bot: Remove trilogy import [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941001 (https://phabricator.wikimedia.org/T341263) (owner: 10Eileen) [14:01:01] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Smashpig Recurring job hangs if there is no previous donation and no invoice_id - https://phabricator.wikimedia.org/T341886 (10Damilare) @Cstone I wasn't able to reproduce the bug that causes this process to hang. However, I came across a scenario when te... [14:02:20] (03PS1) 10Damilare Adedoyin: Throw error in SmashPigRecurringProcessor when invoice_id is missing [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941937 (https://phabricator.wikimedia.org/T341886) [14:27:40] (03CR) 10Jgleeson: "I seem to be getting an unrelated error when testing this patch. I'm seeing the following when attempting to import a test recurring donat" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941545 (https://phabricator.wikimedia.org/T342165) (owner: 10Eileen) [15:05:46] 10fundraising-tech-ops: Find a new home for fundraising_query_collector prometheus collector - https://phabricator.wikimedia.org/T342779 (10Jgreen) [15:24:12] 10Fundraising Sprint Never gonna git you update, 10Fundraising-Backlog: Implement Auto-Rescue createPayment updates - https://phabricator.wikimedia.org/T341099 (10AnnWF) a:03AnnWF [15:27:40] 10fundraising-tech-ops: overhaul fundraising_query_collector prometheus collector - https://phabricator.wikimedia.org/T342779 (10Jgreen) [15:54:41] 10fundraising-tech-ops: overhaul fundraising_query_collector prometheus collector - https://phabricator.wikimedia.org/T342779 (10Jgreen) [15:59:02] 10fundraising-tech-ops: overhaul fundraising_query_collector prometheus collector - https://phabricator.wikimedia.org/T342779 (10Jgreen) [16:00:53] 10Fundraising Sprint Never gonna git you update, 10Fundraising-Backlog, 10acl*WMF-FR: Braintree Refund implement and write a batch maintenance script - https://phabricator.wikimedia.org/T342788 (10AnnWF) [16:13:56] (03PS1) 10Wfan: wip: Implement Auto-Rescue createPayment updates [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/941959 (https://phabricator.wikimedia.org/T341099) [16:28:38] PROBLEM - check_log_messages on frav1003 is CRITICAL: CRITICAL: check_endpoints_critical (Paypal:3) 3 [=1] https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frav1003&service=check_log_messages [16:58:35] PROBLEM - check_log_messages on frav1003 is CRITICAL: CRITICAL: check_endpoints_critical (Paypal:3) 3 [=1] https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frav1003&service=check_log_messages [17:10:28] 10fundraising-tech-ops: overhaul fundraising_query_collector prometheus collector - https://phabricator.wikimedia.org/T342779 (10Jgreen) p:05Triage→03Medium [17:13:18] PROBLEM - check_log_messages on frav1003 is CRITICAL: CRITICAL: check_endpoints_critical (Paypal:3) 3 [=1] https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frav1003&service=check_log_messages [17:18:20] RECOVERY - check_log_messages on frav1003 is OK: OK https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frav1003&service=check_log_messages [17:18:36] 10fundraising-tech-ops: overhaul fundraising_query_collector prometheus collector - https://phabricator.wikimedia.org/T342779 (10Jgreen) 05Open→03Resolved [17:43:33] (03PS2) 10Wfan: Implement Auto-Rescue createPayment updates [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/941959 (https://phabricator.wikimedia.org/T341099) [17:49:40] 10Fundraising-Backlog: EFT Matching import testing - https://phabricator.wikimedia.org/T342796 (10MDemosWMF) [17:51:51] 10Fundraising-Backlog: EFT Matching import testing - https://phabricator.wikimedia.org/T342796 (10MDemosWMF) This just came up when I hit "back" on the queue screen. Not sure if it is helpful: {F37150742} [18:01:53] 10Fundraising-Backlog: EFT Matching import testing - https://phabricator.wikimedia.org/T342796 (10MDemosWMF) Just tested the Individual matching EFT import and that one worked! Will try to see if I can find out what the difference was there.. [18:08:32] 10Fundraising-Backlog: EFT Matching import testing - https://phabricator.wikimedia.org/T342796 (10MDemosWMF) Looks like there was one thing I miscoded at the top of the import and one wrong field map, so I fixed those and the organization import was successful as well! This ticket can be closed out. :) [18:49:40] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Matching import - duplicate contribution error - https://phabricator.wikimedia.org/T339050 (10MDemosWMF) No duplicate contribution ID errors popped up! Seems good! [19:35:57] 10Fundraising-Backlog: EFT Matching import testing - https://phabricator.wikimedia.org/T342796 (10Eileenmcnaughton) @MDemosWMF - ah - cos I tried clicking import on them & they came up as duplicates - which was a good thing in the end! https://civicrm.wikimedia.org/civicrm/search#/display/Import_654/Import_654 [20:31:27] 10Fundraising-Backlog: EFT Matching import testing - https://phabricator.wikimedia.org/T342796 (10Eileenmcnaughton) 05Open→03Resolved a:03Eileenmcnaughton [20:41:51] jgleeson: I'm not having that meeting with Nora now - I'm gonna have a shower but if you have questions after that I can connect [20:44:09] (03PS2) 10Damilare Adedoyin: Throw error in SmashPigRecurringProcessor when invoice_id is missing [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941937 (https://phabricator.wikimedia.org/T341886) [20:48:10] (03PS3) 10Damilare Adedoyin: Throw error in SmashPigRecurringProcessor when invoice_id is missing [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941937 (https://phabricator.wikimedia.org/T341886) [20:50:30] ty eileen [21:01:33] 10Fundraising-Backlog: Figure out if we can make the queue delay graph better with audit import lag - https://phabricator.wikimedia.org/T342812 (10Cstone) [21:01:54] eileen: could I steal you for a searchkit question if you are free right now? [21:05:35] damilare: thanks for the update. I think the !$array['val'] will trip up if they key isn't set whereas if !empty($asrray['val']) guards against that. With your new check and exception, we can clear out the original one on line 420 I think. [21:06:19] s/they/there/ [21:09:11] cstone: yep [21:10:43] do you want a video call eileen ? or i can type it out [21:10:52] whichever you prefer [21:11:00] want to go back into standup? [21:11:12] meet.google.com/ksg-mnkt-buh [21:11:17] or come to stand up haha [21:32:23] dwisehaupt: did you see my comments on the coworker pipe exit error issue? [21:36:14] eileen: if I cancel my recurring donation, should I still be seeing "active recurring" and "recurring donor" as my segment id / donor status id ? [21:36:39] jgleeson: yeah - it's on the contribution not on the recurring status [21:37:02] we would have to join in another table to change that - but it wasn't in the spec [21:37:30] it will age out soon enough for their purposes I think [21:37:49] ok fine just checking [21:37:53] thanks [21:39:55] I can see the case for it - but I'm not gonna suggest anything that will expand the spec! [21:41:45] eileen: i did but didn't get back to it after the carnage that was this morning. [21:41:57] ah - I missed that :-) [21:42:16] dwisehaupt: if jgleeson is able to approve the patch I'm hoping to reload triggers today too [21:43:33] ok. i should be around for a while. except for the afternoon dog walk in a little. [21:45:26] cool [21:46:58] oh, so the /usr/local/bin/cv wrapper runs the cv command via sudo as the www-data user. [21:47:01] eileen: quick one [21:47:13] yep [21:47:15] that may explain why there was a difference when you specified the other path. [21:47:20] currently NEW criteria looks like this: [21:47:22] ['from' => '6 months ago', 'to' => $this->getFinancialYearEndDateTime(), 'total' => 0.01] [21:47:33] shouldn't it be from => startYearEndDate() [21:47:51] well that would be more than 6 months [21:48:03] https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/941545/2/drupal/sites/default/civicrm/extensions/wmf-civicrm/Civi/WMFHooks/CalculatedData.php#b1085 [21:48:38] but if you look at the awful stuff that interprets what '6 months ago' means it actually adjusts the meaning if you get past the financial year end [21:49:04] when I was checking, the start date was the beginning of this month [21:49:21] as in 01 July 2023 to end of June 2024 [21:49:32] hmm - that sounds wrong - I did just change that yesterday so could have made an error [21:50:20] but it should be 6 months before today - but with some hard coding affecting the triggers so it doesn't change once the financial year ticks over [21:50:50] wanna hop on today's tech-talk [21:51:48] sure [21:52:19] 10Fundraising-Backlog: Need a list of active monthly recurring subscription for India - https://phabricator.wikimedia.org/T342328 (10Cstone) @RKumar_WMF the searchkit is here https://civicrm.wikimedia.org/civicrm/search#/display/India_Recurring_Donors_on_MONTHLY It will show a donors name multiple times as it h... [22:10:03] (03PS3) 10Jgleeson: Update Segment and status calculation to most recent interpretation. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941545 (https://phabricator.wikimedia.org/T342165) (owner: 10Eileen) [22:12:21] (03CR) 10Jgleeson: [C: 03+2] "I've tested this locally and everything looks good to me. thanks for all the work on this!" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941545 (https://phabricator.wikimedia.org/T342165) (owner: 10Eileen) [22:16:55] (03CR) 10Jgleeson: [C: 04-1] "Thanks for the updates. just two small things." [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941937 (https://phabricator.wikimedia.org/T341886) (owner: 10Damilare Adedoyin) [22:27:03] (03Merged) 10jenkins-bot: Update Segment and status calculation to most recent interpretation. [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/941545 (https://phabricator.wikimedia.org/T342165) (owner: 10Eileen) [22:31:01] 10Fundraising Sprint Never gonna git you update, 10Fundraising-Backlog: Using Financial Type= Recurring Gifts for all recurring contributions in civi - https://phabricator.wikimedia.org/T341370 (10jgleeson) a:05jgleeson→03None [23:03:29] (03PS3) 10Wfan: Implement Auto-Rescue createPayment updates [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/941959 (https://phabricator.wikimedia.org/T341099)