[00:31:29] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: CiviCRM / Analytics data clean up - https://phabricator.wikimedia.org/T406193#11244442 (10Eileenmcnaughton) So this is how the php function is starting to look ` public function getChannel(): string { if (!empty($this->message['Gift_Data.Channel'])... [00:33:14] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: CiviCRM / Analytics data clean up - https://phabricator.wikimedia.org/T406193#11244443 (10Eileenmcnaughton) ALSO ` UPDATE civicrm_value_1_gift_data_7 INNER JOIN civicrm_contribution_tracking ON entity_id = contribution_id SET channel = 'Banner'' WHERE ut... [00:38:14] PROBLEM - check_mysql on frdb1004 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1279 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb1004&service=check_mysql [00:49:01] !lo config revision changed from 276d34f0 to 8fc1937c [00:53:14] PROBLEM - check_mysql on frdb1004 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1378 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb1004&service=check_mysql [00:58:14] RECOVERY - check_mysql on frdb1004 is OK: Uptime: 273779 Threads: 5 Questions: 27728634 Slow queries: 288 Opens: 1521 Open tables: 1376 Queries per second avg: 101.281 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb1004&service=check_mysql [03:03:50] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: CiviCRM / Analytics data clean up - https://phabricator.wikimedia.org/T406193#11244517 (10Eileenmcnaughton) ` /* 35968301 is a corporate donor that often makes small transfers. To prevent small transfers from being tagged as Online gif... [03:25:18] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Datepicker fields not working in CiviCRM - https://phabricator.wikimedia.org/T406439 (10Eileenmcnaughton) 03NEW [03:36:51] (03PS1) 10Eileen: Revert "Focus on date field or adjacent time field after selecting date in datepicker" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193586 (https://phabricator.wikimedia.org/T406439) [03:37:14] (03CR) 10Eileen: [C:03+2] Revert "Focus on date field or adjacent time field after selecting date in datepicker" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193586 (https://phabricator.wikimedia.org/T406439) (owner: 10Eileen) [03:57:31] (03Merged) 10jenkins-bot: Revert "Focus on date field or adjacent time field after selecting date in datepicker" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193586 (https://phabricator.wikimedia.org/T406439) (owner: 10Eileen) [04:46:26] (03PS1) 10Eileen: Process refund queue helper [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193588 [04:47:35] (03PS1) 10Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1193589 [04:47:52] (03CR) 10Eileen: [C:03+2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1193589 (owner: 10Eileen) [04:48:48] (03Merged) 10jenkins-bot: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1193589 (owner: 10Eileen) [04:49:39] !log civicrm upgraded from ff529ecf to 17092e23 [04:49:40] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [04:52:26] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Datepicker fields not working in CiviCRM - https://phabricator.wikimedia.org/T406439#11244663 (10Eileenmcnaughton) @Lars the revert fixed this which means the original patch has a problem https://github.com/civicrm/civicrm-core/pull/33654 [05:26:42] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 07fr-current-sprint, 07payments-orchestration: Enable SEPA via Gr4vy for EU countries. - https://phabricator.wikimedia.org/T392065#11244680 (10RKumar_WMF) Can you share the link to test one-time and recurring? Ty. [07:37:53] (03CR) 10CI reject: [V:04-1] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1193727 (owner: 10L10n-bot) [09:07:14] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 07FR-Audience-Dev, 07fr-current-sprint: Pre-renewal notice to Active Annual recurring donors - https://phabricator.wikimedia.org/T393432#11245284 (10MSuijkerbuijk_WMF) @AKanji-WMF Is it possible to receive a test email? I need to se... [09:24:16] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 06FR-donorrelations: wellness check on dLocal/Gravy recurrings - https://phabricator.wikimedia.org/T406090#11245350 (10MSuijkerbuijk_WMF) Thanks [12:52:51] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Fail Mail (civi1002) run-job: Silverpop emails - Check main database file uploade completed (DatabaseUpdate) failed with code 1 - https://phabricator.wikimedia.org/T406485 (10jgleeson) 03NEW [13:55:45] (03PS6) 10Eileen: Multiple fixes for Omnigroupmember.load [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1190382 (https://phabricator.wikimedia.org/T379702) [13:56:25] (03CR) 10Ejegg: [C:03+2] "This looks pretty good! I've been having trouble getting any records in local smoke testing, but the code seems fine to try out with real " [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1190382 (https://phabricator.wikimedia.org/T379702) (owner: 10Eileen) [14:02:08] (03PS2) 10Eileen: Declare recipient_id field [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193284 [14:02:17] (03CR) 10Ejegg: [C:03+2] Declare recipient_id field [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193284 (owner: 10Eileen) [14:16:13] (03Merged) 10jenkins-bot: Multiple fixes for Omnigroupmember.load [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1190382 (https://phabricator.wikimedia.org/T379702) (owner: 10Eileen) [14:18:49] (03Merged) 10jenkins-bot: Declare recipient_id field [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193284 (owner: 10Eileen) [14:34:54] (03PS3) 10Ejegg: Update index for pending table [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1193480 (https://phabricator.wikimedia.org/T406360) [15:20:02] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 07fr-current-sprint, 07payments-orchestration: Enable SEPA via Gr4vy for EU countries. - https://phabricator.wikimedia.org/T392065#11246575 (10Ejegg) >>! In T392065#11244680, @RKumar_WMF wrote: > Can you share the link to test one-t... [15:21:44] (03PS5) 10Ejegg: Better status merging with bitfields [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/1182171 (https://phabricator.wikimedia.org/T402845) [15:22:50] (03CR) 10Ejegg: "Thanks for all the review, Lars! I've made the fixes you suggested in PS5" [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/1182171 (https://phabricator.wikimedia.org/T402845) (owner: 10Ejegg) [16:02:22] 06Fundraising-Backlog, 06FR-donorrelations: small # of Adyen ApplePay contribs missing country in Civi - https://phabricator.wikimedia.org/T406505 (10MBeat33) 03NEW [16:05:45] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 07fr-current-sprint, 13Patch-For-Review: New batch data entry update: Tabbing after selecting gift date/postmark date - https://phabricator.wikimedia.org/T404642#11246813 (10Lars) And an [[ https:/... [16:24:55] 06Fundraising-Backlog, 06FR-donorrelations: Trustly bank selection form errors - https://phabricator.wikimedia.org/T406370#11246895 (10greg) Folks are reporting it works again, we'll uncomment that commented out line above ^. [16:29:42] 06Fundraising-Backlog, 06FR-donorrelations: Trustly bank selection form errors - https://phabricator.wikimedia.org/T406370#11246912 (10greg) done: https://donate.wikimedia.org/w/index.php?title=Template:2012FR/Form-countryspecific-control/US&action=history [16:32:17] (03CR) 10Lars SG: [C:03+2] "Nice!" [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/1182171 (https://phabricator.wikimedia.org/T402845) (owner: 10Ejegg) [16:33:42] (03Merged) 10jenkins-bot: Better status merging with bitfields [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/1182171 (https://phabricator.wikimedia.org/T402845) (owner: 10Ejegg) [16:51:56] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 07fr-current-sprint, 07Unplanned-Sprint-Work: Add batch size param to Gravy Pending Transaction job - https://phabricator.wikimedia.org/T404861#11247011 (10AnnWF) Update to 200 since /var/log/process-control/gravy_pending_resolver/g... [16:53:50] 06Fundraising-Backlog, 10MediaWiki-extensions-CentralNotice, 07I18n: CentralNotice should respect language fallbacks - https://phabricator.wikimedia.org/T34482#11247020 (10SBurnett-WMF) 05Open→03Resolved [16:54:32] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Gravy ApplePay 'Invalid cryptogram' errors - https://phabricator.wikimedia.org/T406510 (10jgleeson) 03NEW [16:55:03] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Gravy ApplePay 'Invalid cryptogram' errors - https://phabricator.wikimedia.org/T406510#11247037 (10jgleeson) I've raised this with Gravy on Slack [[ https://wikimedia.slack.com/archives/C070F1DVBRN/p1759769003728549 | here ]] [16:57:50] 06Fundraising-Backlog, 10MediaWiki-extensions-CentralNotice, 06Privacy Engineering, 07Privacy: Add state or city level geotargeting to CentralNotice - https://phabricator.wikimedia.org/T152297#11247058 (10SBurnett-WMF) 05Open→03Declined [17:06:54] 06Fundraising-Backlog: CiviCRM upgrade: Search bar: Default search field is name only - https://phabricator.wikimedia.org/T116310#11247068 (10SBurnett-WMF) Declining [17:07:16] 06Fundraising-Backlog: CiviCRM upgrade: Search bar: Default search field is name only - https://phabricator.wikimedia.org/T116310#11247069 (10SBurnett-WMF) 05Open→03Declined [17:09:11] (03PS1) 10Jgleeson: Add explanatory variable to make the exception clearer [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193905 (https://phabricator.wikimedia.org/T406485) [17:10:13] (03PS2) 10Jgleeson: Add explanatory variable to make the exception clearer [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193905 (https://phabricator.wikimedia.org/T406485) [17:10:52] (03PS3) 10Jgleeson: Add explanatory variable to make the exception clearer [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193905 (https://phabricator.wikimedia.org/T406485) [17:11:17] (03PS4) 10Jgleeson: Refactor: Add explanatory variable to make exception clearer [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193905 (https://phabricator.wikimedia.org/T406485) [17:13:56] 06Fundraising-Backlog: Chariot DAFpay button integration - donation form - https://phabricator.wikimedia.org/T405043#11247108 (10MDemosWMF) Thanks @AKanji-WMF ! They also offered to have their technical folks join a meeting with our team to answer any questions. I can loop them in once that is on the calendar. [17:14:39] ejegg: I'm gonna circle back to https://gerrit.wikimedia.org/r/c/mediawiki/extensions/DonationInterface/+/1185095 today [17:14:45] I think this is still an issue [17:15:03] I'll implement those speed improvements you kindly provided [17:15:22] (03PS19) 10Jgleeson: Update IP velocity filter to handle relay services. [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1185095 (https://phabricator.wikimedia.org/T402662) [17:21:24] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10FR-Donor-portal: Track Donor Portal navigation (with web beacons?) - https://phabricator.wikimedia.org/T404243#11247123 (10Jgreen) Could we get the info we need from the API side? Looking at this https://civicrm.org/extensions/api-rest-log [17:28:59] 10Fundraising analytics stack, 10fundraising-tech-ops, 13Patch-For-Review: Service monitoring for FR analytics platform. - https://phabricator.wikimedia.org/T386259#11247137 (10Jgreen) 05Open→03Resolved Closing b/c I think we're close enough, although we aren't alerting for HMS outages directly we'll... [17:29:16] 10fundraising-tech-ops: Q1:rack/setup/install franio100[1-3] - https://phabricator.wikimedia.org/T367820#11247141 (10Jgreen) a:05Jgreen→03None [17:29:33] 10fundraising-tech-ops: Q1:rack/setup/install frand200[12] - https://phabricator.wikimedia.org/T367804#11247142 (10Jgreen) a:05Jgreen→03None [17:29:56] cool jgleeson , will review when ready [17:35:00] (03PS1) 10Ejegg: Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/1193912 [17:35:02] (03CR) 10Ejegg: [C:03+2] Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/1193912 (owner: 10Ejegg) [17:35:40] (03Merged) 10jenkins-bot: Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/1193912 (owner: 10Ejegg) [18:01:32] !log fundraising python tools upgraded from 3fba9888 to 698309f1 [18:02:30] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [18:27:53] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10FR-dlocal, 06FR-donorrelations, 07Transaction-missing-in-CiviCRM: dLocal audit file question + missing reversed transaction - https://phabricator.wikimedia.org/T389245#11247306 (10Cstone) @MBeat33 Following up on an old task here, checking the two... [18:36:10] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 07FR-Audience-Dev, 07fr-current-sprint: Audience movement from LYBUNT (35) to New (25) - https://phabricator.wikimedia.org/T402845#11247329 (10Ejegg) We've deployed the fix for this! I do still need to flag the affected users for ex... [18:39:52] 14Fundraising Sprint Michelin Star, 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 07fr-current-sprint: 2nd Recurring Failure Email in Civi - https://phabricator.wikimedia.org/T365488#11247332 (10Cstone) a:03Cstone [18:49:28] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Civi-Dedupe, and 2 others: Civi search feature request - Find duplicates from referrals - https://phabricator.wikimedia.org/T383363#11247360 (10Lars) @SHust This has been implemented. You'll fin... [19:05:54] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10FR-dlocal, 06FR-donorrelations, 07Transaction-missing-in-CiviCRM: dLocal audit file question + missing reversed transaction - https://phabricator.wikimedia.org/T389245#11247416 (10MBeat33) Thanks, @Cstone we haven't done a dLocal refund at dLocal... [19:13:14] oops, meeting! [19:15:30] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 07fr-current-sprint: CiviCRM: Change default Activity status from "Scheduled" to "Complete" - https://phabricator.wikimedia.org/T115036#11247446 (10XenoRyet) 05Open→03Resolved [19:15:50] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 07fr-current-sprint: Change fundraising-dev standalone civicrm db name back to civicrm - https://phabricator.wikimedia.org/T404389#11247450 (10XenoRyet) 05Open→03Resolved [19:16:20] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 07fr-current-sprint, 07payments-orchestration: Enable SEPA via Gr4vy for EU countries. - https://phabricator.wikimedia.org/T392065#11247452 (10XenoRyet) 05Open→03Resolved [19:16:32] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 07fr-current-sprint, 05MW-1.45-notes (1.45.0-wmf.21; 2025-09-30): Do not show email update for donor with recurring active paypal - https://phabricator.wikimedia.org/T401006#11247454 (10XenoRyet) 05Open→03Resolved [19:17:06] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 07fr-current-sprint: Add fields for CiviCRM/Acoustic for 2026 calendar year donations - https://phabricator.wikimedia.org/T404925#11247459 (10XenoRyet) 05Open→03Resolved [19:17:22] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 07fr-current-sprint: Gravy error tracking: add BIN number to fraud list emails - https://phabricator.wikimedia.org/T404649#11247461 (10XenoRyet) 05Open→03Resolved [19:17:44] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10FR-email-preferences, 07fr-current-sprint: adding email template for email confirmation - https://phabricator.wikimedia.org/T396521#11247463 (10XenoRyet) 05Open→03Resolved [19:18:07] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 07fr-current-sprint: coworker - unhurt our brains with debug - https://phabricator.wikimedia.org/T405053#11247466 (10XenoRyet) [19:18:16] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 07fr-current-sprint: coworker - unhurt our brains with debug - https://phabricator.wikimedia.org/T405053#11247467 (10XenoRyet) 05Open→03Resolved [19:18:47] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10FR-Donor-portal, 10FR-email-preferences, 07fr-current-sprint: Implement recurring donation cancel via donor portal - https://phabricator.wikimedia.org/T388754#11247468 (10XenoRyet) 05Open→03Resolved [19:18:58] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 07FR-Audience-Dev, 07fr-current-sprint: Pre-renewal notice to Active Annual recurring donors - https://phabricator.wikimedia.org/T393432#11247471 (10XenoRyet) 05Open→03Resolved [19:20:15] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 07fr-current-sprint: Chargebacks not being handled for Adyen Gravy transactions - https://phabricator.wikimedia.org/T402876#11247480 (10XenoRyet) 05Open→03Resolved [19:20:30] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 07fr-current-sprint, 07Unplanned-Sprint-Work: Add batch size param to Gravy Pending Transaction job - https://phabricator.wikimedia.org/T404861#11247484 (10XenoRyet) 05Open→03Resolved [19:22:15] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10FR-Donor-portal, 05MW-1.45-notes (1.45.0-wmf.22; 2025-10-07): Add paused donations to inactive recurring list - https://phabricator.wikimedia.org/T404881#11247497 (10XenoRyet) 05Open→03Resolved [19:22:53] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Fail Mail (civi1002) run-job: Silverpop emails - https://phabricator.wikimedia.org/T406315#11247500 (10XenoRyet) 05Open→03Resolved [19:23:16] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Paypal vault API rate limiting through Gravy 2025-08-25 and 09-04 - https://phabricator.wikimedia.org/T403190#11247502 (10Cstone) After lots of email threads, Paypal said our account has been updated to have an exception to the rate limit [19:23:33] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Recurring-Donations: Update recurring failure email to account for annual - https://phabricator.wikimedia.org/T405834#11247507 (10XenoRyet) 05Open→03Resolved [19:24:13] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Do not allow pause paypal ec recurring - https://phabricator.wikimedia.org/T406520 (10AnnWF) 03NEW [19:24:31] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Paypal vault API rate limiting through Gravy 2025-08-25 and 09-04 - https://phabricator.wikimedia.org/T403190#11247526 (10XenoRyet) 05Open→03Resolved [19:25:48] 06Fundraising-Backlog, 10FR-Donor-portal: Do not allow pause paypal ec recurring - https://phabricator.wikimedia.org/T406520#11247537 (10AnnWF) [19:25:52] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Clean up active recurrings with next_sched dates in the past - https://phabricator.wikimedia.org/T404921#11247539 (10XenoRyet) 05Open→03Resolved [19:25:55] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 06FR-donorrelations, 07Transaction-missing-in-CiviCRM: recent Gravy / PayPal donations missing PII in Civi - https://phabricator.wikimedia.org/T402841#11247538 (10jgleeson) I'm gonna mark this one as complete. The original issue was fixed when Gravy a... [19:26:09] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Does 'Direct Mail' custom field group need to extend ALL activities? - https://phabricator.wikimedia.org/T404247#11247541 (10XenoRyet) 05Open→03Resolved [19:26:23] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Some gravy response null TypeError - https://phabricator.wikimedia.org/T403770#11247543 (10XenoRyet) 05Open→03Resolved [19:26:36] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Civi exclusion tags - multiple selections being parsed as one? - https://phabricator.wikimedia.org/T405686#11247545 (10XenoRyet) 05Open→03Resolved [19:27:06] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Gravy error tracking: Double fraud trxn IDs bug in alert emails - https://phabricator.wikimedia.org/T404799#11247547 (10XenoRyet) 05Open→03Resolved [19:27:45] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Standardize all extensions to have managed (not Managed subfolders) - https://phabricator.wikimedia.org/T405261#11247550 (10XenoRyet) 05Open→03Resolved [19:28:36] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 06FR-donorrelations: wellness check on dLocal/Gravy recurrings - https://phabricator.wikimedia.org/T406090#11247555 (10XenoRyet) 05Open→03Resolved [19:29:18] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Datepicker fields not working in CiviCRM - https://phabricator.wikimedia.org/T406439#11247559 (10Lars) The fix has been [[ https://github.com/civicrm/civicrm-core/pull/33733 | merged upstream ]] and we can just wait for our CiviCRM upgrade to deploy. [19:30:08] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Datepicker fields not working in CiviCRM - https://phabricator.wikimedia.org/T406439#11247561 (10Lars) [19:30:09] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Rejected transactions still getting recurring queue messages - https://phabricator.wikimedia.org/T403024#11247563 (10XenoRyet) 05Open→03Resolved [19:31:53] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 06FR-donorrelations, 07Transaction-missing-in-CiviCRM: recent Gravy / PayPal donations missing PII in Civi - https://phabricator.wikimedia.org/T402841#11247571 (10XenoRyet) 05Open→03Resolved [19:32:55] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13Patch-For-Review: Merging contacts via deduper deletes the user when contact has attached user - https://phabricator.wikimedia.org/T403774#11247581 (10XenoRyet) 05Open→03Resolved [19:33:26] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 07fr-current-sprint, 13Patch-For-Review: New batch data entry update: Tabbing after selecting gift date/postmark date - https://phabricator.wikimedia.org/T404642#11247584 (10Lars) [[ https://github... [19:33:56] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 07payments-orchestration: Refund shows as contribution line without original contribution line - https://phabricator.wikimedia.org/T393036#11247585 (10XenoRyet) 05Open→03Resolved [19:53:49] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Civi-Dedupe, and 2 others: Civi search feature request - Find duplicates from referrals - https://phabricator.wikimedia.org/T383363#11247627 (10Lars) Here's an [[ https://lab.civicrm.org/dev... [20:07:39] 10fundraising-tech-ops, 06DC-Ops, 10ops-eqiad, 06SRE: Q2:install (1) SSD each into franio100[1-3] - https://phabricator.wikimedia.org/T405983#11247674 (10VRiley-WMF) a:03VRiley-WMF [20:17:59] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Add Value date to Adyen audit reports - https://phabricator.wikimedia.org/T406435#11247701 (10Cstone) a:03Cstone Yeah we can look in the adyen UI let's see if that one is available [20:21:06] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 13Patch-For-Review: Fail Mail (civi1002) run-job: Silverpop emails - Check main database file uploade completed (DatabaseUpdate) failed with code 1 - https://phabricator.wikimedia.org/T406485#11247712 (10AnnWF) Add a doc in exception failmail for emai t... [20:24:11] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 06FR-donorrelations: small # of Adyen ApplePay contribs missing country in Civi - https://phabricator.wikimedia.org/T406505#11247714 (10AnnWF) [20:25:11] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 06FR-donorrelations: small # of Adyen ApplePay contribs missing country in Civi - https://phabricator.wikimedia.org/T406505#11247726 (10AnnWF) p:05Triage→03Medium [20:27:48] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 06FR-donorrelations: 2025-10-03 Trustly bank selection form errors - https://phabricator.wikimedia.org/T406370#11247733 (10AnnWF) p:05Triage→03Unbreak! [20:28:12] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 06FR-donorrelations: 2025-10-03 Trustly bank selection form errors - https://phabricator.wikimedia.org/T406370#11247738 (10Cstone) [20:28:14] 06Fundraising-Backlog, 07Epic: Gravy Chaos Epic - https://phabricator.wikimedia.org/T403769#11247739 (10Cstone) [20:30:30] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 07Epic: FR-Tech Real-Time Processing Anomaly Alerting - https://phabricator.wikimedia.org/T406132#11247751 (10AnnWF) [20:30:51] (03PS1) 10Eileen: Clearer function for isSubsequentRecurring [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193934 (https://phabricator.wikimedia.org/T406193) [20:30:51] (03PS1) 10Eileen: Calculate channel more accurately on ingress [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193935 (https://phabricator.wikimedia.org/T406193) [20:48:05] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Civi-Dedupe, and 2 others: Civi search feature request - Find duplicates from referrals - https://phabricator.wikimedia.org/T383363#11247791 (10SHust) As you mentioned, it is running a bit s... [20:49:07] (03CR) 10CI reject: [V:04-1] Clearer function for isSubsequentRecurring [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193934 (https://phabricator.wikimedia.org/T406193) (owner: 10Eileen) [20:49:40] (03CR) 10CI reject: [V:04-1] Calculate channel more accurately on ingress [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193935 (https://phabricator.wikimedia.org/T406193) (owner: 10Eileen) [20:56:53] (03PS1) 10Ejegg: Hide Log In link for the email preferences page [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1193938 (https://phabricator.wikimedia.org/T399581) [21:02:38] 03Fundraising Sprint: Spaghetti code and makefiles, 06Fundraising-Backlog, 07fr-current-sprint: Add monitoring for number of transactions imported with |dup-XXXXX appended to the invoice ID - https://phabricator.wikimedia.org/T402316#11247828 (10Jgreen) @ejegg, is this something we want to alert about or jus... [21:17:24] (03PS1) 10Eileen: Set is_major_gift on ingress [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193939 (https://phabricator.wikimedia.org/T406193) [21:19:09] (03PS1) 10Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1193940 [21:20:03] (03CR) 10Eileen: [C:03+2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1193940 (owner: 10Eileen) [21:21:04] (03Merged) 10jenkins-bot: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1193940 (owner: 10Eileen) [21:25:57] !log civicrm upgraded from 17092e23 to eac2de65 [21:25:59] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [21:33:35] (03CR) 10CI reject: [V:04-1] Set is_major_gift on ingress [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193939 (https://phabricator.wikimedia.org/T406193) (owner: 10Eileen) [21:37:38] !log config revision changed from 65339a1a to 02eee6ac [21:37:40] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [21:43:42] easy +2 on this one I think... https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1193588 [21:43:52] (ignore supposed conflicts) [21:51:26] (03PS2) 10Eileen: Clearer function for isSubsequentRecurring [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193934 (https://phabricator.wikimedia.org/T406193) [21:51:26] (03PS2) 10Eileen: Calculate channel more accurately on ingress [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193935 (https://phabricator.wikimedia.org/T406193) [21:51:26] (03PS2) 10Eileen: Set is_major_gift on ingress [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193939 (https://phabricator.wikimedia.org/T406193) [21:51:54] (03PS3) 10Eileen: Clearer function for isSubsequentRecurring [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193934 (https://phabricator.wikimedia.org/T406193) [21:51:54] (03PS3) 10Eileen: Calculate channel more accurately on ingress [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193935 (https://phabricator.wikimedia.org/T406193) [21:51:55] (03PS3) 10Eileen: Set is_major_gift on ingress [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193939 (https://phabricator.wikimedia.org/T406193) [21:53:41] also - this should allow us to record fee_amount correctly when we have it (from audit) - which is the minority but... https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1193484 [22:07:49] (03CR) 10CI reject: [V:04-1] Set is_major_gift on ingress [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193939 (https://phabricator.wikimedia.org/T406193) (owner: 10Eileen) [22:08:51] (03CR) 10Cstone: [C:03+2] Process refund queue helper [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193588 (owner: 10Eileen) [22:10:40] (03CR) 10CI reject: [V:04-1] Calculate channel more accurately on ingress [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193935 (https://phabricator.wikimedia.org/T406193) (owner: 10Eileen) [22:17:42] eileen: where did you find the value date info from? i dont see it in the settlement field options, booking date and authorised date are the two date filds [22:17:48] and pos date but i assume thats juts for pos [22:17:51] transactions [22:18:24] cstone: might have been AI - but the booking date & authorised date are not the settled date :-( [22:20:55] if we can't get the actual settled date I'm gonna do something like MAX(booking_date) [22:21:44] or probably rules based -ie based on when we expect to settle [22:24:32] I guess it picked up this https://help.adyen.com/knowledge/adyen-for-platforms/funds-transfers/what-is-value-date-and-when-are-funds-are-available-for-payout#:~:text=For%20every%20transaction%20returned%20in%20the%20API,to%20be%20available%20in%20the%20balance%20account. [22:25:30] Eileen are you just looking at the settlement report date but all transactions too [22:25:57] Lemme confirm what we are actually exploring it's confusing because we have two adyen accounts and there's 3 places where columns are listed [22:26:10] Er or all transactions too* [22:26:11] cstone: so I kinda want one date for the batch to say 'this is the date it settled on' & apply that to all transactions in the batch - we have a field [22:26:14] (03Merged) 10jenkins-bot: Process refund queue helper [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193588 (owner: 10Eileen) [22:47:20] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10FR-Donor-portal: Track Donor Portal navigation (with web beacons?) - https://phabricator.wikimedia.org/T404243#11248046 (10Dwisehaupt) For initial quick testing, this has been implemented and we are now logging requests to /beacon/. It is ready for use. No... [22:58:26] hmm eileen would that be the filename of the settlement file itself then? like if we only settle on fridays and that report is generated on friday is that the date you are after [22:59:00] cstone: yeah so maybe that is how I have to determine it [22:59:36] but I guess if I'm processing a past file ... I probably don't want to use file create or modified date - I don't think it's always in the name now? [23:04:10] hmm yeah that older one doesnt have the date in the name does it, we could add it? [23:13:00] if it's easy we might as well [23:13:22] yeah i can make a phab its in the download report job [23:14:04] 06Fundraising-Backlog: Add date to adyen settlement report name - https://phabricator.wikimedia.org/T406534 (10Cstone) 03NEW [23:29:50] hmmm actually we generated another one with the one that gets sent to gravy are we not downloading that one [23:31:03] ah okay its on a different auser [23:36:46] eileen: are you using that batch number in the filename or is it in the csv too? [23:37:04] cstone: it's in the csv too [23:37:22] are we still getting each settlement report twice? [23:37:33] was it downloading then? [23:37:45] the one with the _100 in the file name is our super old scheduled report [23:38:00] if we make one now looks like its a name with a date [23:40:11] ah okay I found the right account [23:40:23] so for example settlement_detail_report_batch_1130.csv is also settlement_detail_report_2025-10-02.csv [23:42:20] oh okay so we are processing both [23:42:42] eileen: I can just stop sending us the batch one would that work out then? that settlement_detail_report would then get a date in it [23:43:15] or well we wouldnt have 2 [23:43:29] cstone: if they are definitely duplicates - although it is kinda nice having the batch number there visually if we can have that and the date? [23:51:33] i cant set up a new one with the batch so I'm not sure if we should rely on it in the name [23:51:50] let me try again [23:52:35] oh i take it back i did do it [23:52:47] so like adyen_settlement_report_2025-10-02_batch_5? [23:53:25] or probably easier to stick date on the end [23:53:33] batch_5_2025-10-02 [23:59:58] (03PS1) 10Eileen: Allow file name to be passed in to test runAuditor function [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1193959