[00:50:14] (03CR) 10Eileen: [C:03+2] Upgrading wikimedia/smash-pig (v1.2.4.13 => v1.2.4.15) [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304921 (owner: 10Eileen) [00:50:44] (03CR) 10Eileen: [C:03+2] Upgrading wikimedia/smash-pig (v1.2.4.13 => v1.2.4.15) [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/1304922 (owner: 10Eileen) [00:51:50] (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/1304930 [00:52:00] (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/1304930 (owner: 10Eileen) [00:53:59] (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/1304930 (owner: 10Eileen) [00:55:56] (03PS1) 10Eileen: Further 6.16 fixes - takes us to f5068baf71 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304931 [01:01:37] (03PS21) 10Eileen: Add Chariot audit processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1281984 (https://phabricator.wikimedia.org/T419044) [01:01:37] (03PS2) 10Eileen: Fix monolog DSN [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1303618 [01:01:37] (03PS1) 10Eileen: Port https://github.com/civicrm/civicrm-core/pull/36053 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304933 [01:05:40] 03Fundraising Sprint: Kondo-approved bare room, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Donation-Processing, and 2 others: Engage <> Gr4vy for Direct Mail CC and ACH - https://phabricator.wikimedia.org/T417842#12043318 (10Eileenmcnaughton) OK - I'm fixing the backend_gateway, gateway,... [01:07:08] 03Fundraising Sprint: Kondo-approved bare room, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Donation-Processing, and 2 others: Engage <> Gr4vy for Direct Mail CC and ACH - https://phabricator.wikimedia.org/T417842#12043320 (10Eileenmcnaughton) Fix for 144852880 ` echo '{"values":{"contribu... [01:15:11] (03PS3) 10Ejegg: Update SmashPig container to trixie [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/1288928 (https://phabricator.wikimedia.org/T424774) [01:26:19] (03CR) 10CI reject: [V:04-1] Fix monolog DSN [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1303618 (owner: 10Eileen) [01:26:40] (03CR) 10CI reject: [V:04-1] Port https://github.com/civicrm/civicrm-core/pull/36053 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304933 (owner: 10Eileen) [01:26:41] (03PS1) 10Ejegg: Remove privatebin [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/1304940 [01:26:48] (03CR) 10CI reject: [V:04-1] Add Chariot audit processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1281984 (https://phabricator.wikimedia.org/T419044) (owner: 10Eileen) [01:29:15] (03PS7) 10Ejegg: Remove special subscr_id for gravy/paypal [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1275995 (https://phabricator.wikimedia.org/T423638) [01:29:27] (03CR) 10Lars SG: [C:03+2] Further 6.16 fixes - takes us to f5068baf71 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304931 (owner: 10Eileen) [01:30:58] Cleaning up a no-longer-needed special case: https://gerrit.wikimedia.org/r/1275995 [01:38:39] 03Fundraising Sprint: Kondo-approved bare room, 06Fundraising-Backlog, 13Patch-For-Review: Create Chariot IPN listener in smashpig - https://phabricator.wikimedia.org/T428007#12043404 (10Ejegg) @Jgreen or @Dwisehaupt when you have a moment could you apply this patch from my homedir on frpm1002? 0001-Add-sho... [01:39:05] (03PS2) 10Ejegg: Add config for chariot listener [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/1296696 (https://phabricator.wikimedia.org/T428007) [01:39:11] (03CR) 10Ejegg: [V:03+2 C:03+2] Add config for chariot listener [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/1296696 (https://phabricator.wikimedia.org/T428007) (owner: 10Ejegg) [01:41:28] oh i should define a new jobs queue in that same puppet patch [01:41:50] 06Fundraising-Backlog, 10FR-Smashpig: Add logic to Chariot listener to verify and send to queue - https://phabricator.wikimedia.org/T429859 (10Ejegg) 03NEW [01:49:47] (03Merged) 10jenkins-bot: Further 6.16 fixes - takes us to f5068baf71 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304931 (owner: 10Eileen) [02:08:39] ah i should mark the attempt table as not for logging [02:25:44] 03Fundraising Sprint: Kondo-approved bare room, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Donation-Processing, and 2 others: Engage <> Gr4vy for Direct Mail CC and ACH - https://phabricator.wikimedia.org/T417842#12043468 (10Eileenmcnaughton) OK - the process for fixing these is pretty pa... [04:27:54] (03PS1) 10Eileen: Use specific duplicate contact exception in our helper [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304949 (https://phabricator.wikimedia.org/T419044) [04:35:33] (03PS2) 10Eileen: Use specific duplicate contact exception in our helper [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304949 (https://phabricator.wikimedia.org/T419044) [04:35:33] (03PS22) 10Eileen: Add Chariot audit processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1281984 (https://phabricator.wikimedia.org/T419044) [04:35:33] (03PS3) 10Eileen: Fix monolog DSN [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1303618 [04:35:34] (03PS2) 10Eileen: Port https://github.com/civicrm/civicrm-core/pull/36053 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304933 [04:55:03] (03CR) 10CI reject: [V:04-1] Port https://github.com/civicrm/civicrm-core/pull/36053 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304933 (owner: 10Eileen) [04:56:13] (03CR) 10CI reject: [V:04-1] Fix monolog DSN [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1303618 (owner: 10Eileen) [05:52:28] FIRING: OOM: OOM killer active on fransw1003.frack.eqiad.wmnet:9100 - https://alerts.wikimedia.org/?q=alertname%3DOOM [05:57:28] RESOLVED: OOM: OOM killer active on fransw1003.frack.eqiad.wmnet:9100 - https://alerts.wikimedia.org/?q=alertname%3DOOM [06:52:39] FIRING: HighPaymentFraudMessages: More than 10 payment fraud messages in the past hour [13.4] - https://alerts.wikimedia.org/?q=alertname%3DHighPaymentFraudMessages [07:52:39] RESOLVED: HighPaymentFraudMessages: More than 10 payment fraud messages in the past hour [12.6] - https://alerts.wikimedia.org/?q=alertname%3DHighPaymentFraudMessages [08:04:44] 03Fundraising Sprint: Kondo-approved bare room, 06Fundraising-Backlog, 10FR-payments-general, 07fr-current-sprint, 13Patch-For-Review: 2nd Recurring Failure Email in Civi - https://phabricator.wikimedia.org/T365488#12043908 (10MSuijkerbuijk_WMF) Hi team - is this email set and going out? We haven't recei... [08:33:08] (03PS23) 10Eileen: Add Chariot audit processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1281984 (https://phabricator.wikimedia.org/T419044) [08:33:08] (03PS4) 10Eileen: Fix monolog DSN [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1303618 [08:45:50] (03CR) 10D3r1ck01: [C:03+1] Use ObjectCacheFactory getLocalCluster method (031 comment) [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1040856 (https://phabricator.wikimedia.org/T363770) (owner: 10Wandji collins) [08:53:20] (03CR) 10CI reject: [V:04-1] Fix monolog DSN [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1303618 (owner: 10Eileen) [09:29:58] !log payments-wiki upgraded from 71cba440 to ab4fd16b [09:30:00] Logged the message at https://wikitech.wikimedia.org/wiki/Fundraising/SAL [09:33:30] (03PS24) 10Eileen: Add Chariot audit processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1281984 (https://phabricator.wikimedia.org/T419044) [09:33:30] (03PS5) 10Eileen: Fix monolog DSN [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1303618 [09:46:39] FIRING: HighPaymentFraudMessages: More than 10 payment fraud messages in the past hour [18.9] - https://alerts.wikimedia.org/?q=alertname%3DHighPaymentFraudMessages [09:52:51] (03CR) 10CI reject: [V:04-1] Fix monolog DSN [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1303618 (owner: 10Eileen) [10:03:47] (03CR) 10Jgleeson: [C:03+2] Fix timezone name for PHP 8.4 [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1304897 (https://phabricator.wikimedia.org/T425578) (owner: 10Ejegg) [10:04:05] (03CR) 10Jgleeson: [C:03+2] Fix warnings in PHP8.4 [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1304894 (https://phabricator.wikimedia.org/T425578) (owner: 10Ejegg) [10:04:39] (03Merged) 10jenkins-bot: Fix warnings in PHP8.4 [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1304894 (https://phabricator.wikimedia.org/T425578) (owner: 10Ejegg) [10:04:43] (03Merged) 10jenkins-bot: Fix timezone name for PHP 8.4 [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1304897 (https://phabricator.wikimedia.org/T425578) (owner: 10Ejegg) [11:01:39] RESOLVED: HighPaymentFraudMessages: More than 10 payment fraud messages in the past hour [12.6] - https://alerts.wikimedia.org/?q=alertname%3DHighPaymentFraudMessages [11:18:46] (03CR) 10Ejegg: [C:03+2] Use specific duplicate contact exception in our helper [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304949 (https://phabricator.wikimedia.org/T419044) (owner: 10Eileen) [11:28:11] (03CR) 10Ejegg: "Your code is looking good so far. Unfortunately tests are failing for me under PHP 8.4 because TheIconic\NameParser is stale and unmaintai" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1281984 (https://phabricator.wikimedia.org/T419044) (owner: 10Eileen) [11:35:53] (03CR) 10Ejegg: "ok, this fork of TheIconic\NameParser seems like a candidate for the replacement: https://github.com/CodeByZach/name-parser I'm about half" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1281984 (https://phabricator.wikimedia.org/T419044) (owner: 10Eileen) [11:38:00] 06Fundraising-Backlog, 06FR-donorrelations, 07Documentation: Document existing payment error messages - https://phabricator.wikimedia.org/T379197#12044886 (10krobinson) Hi folks! Just pinging to see if there is an update on this, as we're quiet right now and had hoped to do our piece before we get busy again... [11:41:22] (03Merged) 10jenkins-bot: Use specific duplicate contact exception in our helper [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304949 (https://phabricator.wikimedia.org/T419044) (owner: 10Eileen) [11:44:39] FIRING: HighPaymentFraudMessages: More than 10 payment fraud messages in the past hour [16.4] - https://alerts.wikimedia.org/?q=alertname%3DHighPaymentFraudMessages [12:39:39] RESOLVED: HighPaymentFraudMessages: More than 10 payment fraud messages in the past hour [10.1] - https://alerts.wikimedia.org/?q=alertname%3DHighPaymentFraudMessages [12:43:39] FIRING: HighPaymentsMedianRiskScore: Median payments risk_score is running high [76.9] - https://alerts.wikimedia.org/?q=alertname%3DHighPaymentsMedianRiskScore [12:48:39] RESOLVED: HighPaymentsMedianRiskScore: Median payments risk_score is running high [75.6] - https://alerts.wikimedia.org/?q=alertname%3DHighPaymentsMedianRiskScore [12:52:38] (03PS11) 10Jgleeson: Add skeleton ComboWiki special page [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1302165 (https://phabricator.wikimedia.org/T427981) [12:52:38] (03PS6) 10Jgleeson: WIP: Implement ComboWiki Payment Form in Vue [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1303431 (https://phabricator.wikimedia.org/T428019) [12:53:53] (03PS7) 10Jgleeson: WIP: Implement ComboWiki Payment Form in Vue [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1303431 (https://phabricator.wikimedia.org/T428019) [12:56:28] (03PS8) 10Jgleeson: WIP: Implement ComboWiki Payment Form in Vue [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1303431 (https://phabricator.wikimedia.org/T428019) [12:58:35] (03CR) 10CI reject: [V:04-1] WIP: Implement ComboWiki Payment Form in Vue [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1303431 (https://phabricator.wikimedia.org/T428019) (owner: 10Jgleeson) [13:21:03] (03CR) 10Damilare Adedoyin: [C:03+1] "LGTM, I just added a comment about a missing config variable." [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/1295075 (owner: 10Ejegg) [13:48:03] thanks for the CR dami! [13:48:12] Let me get those settings fixed [13:51:02] (03PS12) 10Ejegg: Add fundraising-ml db setup and config [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/1295075 [13:51:02] (03PS1) 10Ejegg: Payments service config to point to fraud service [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/1305135 (https://phabricator.wikimedia.org/T429605) [13:51:25] ok damilare, PS12 has it added [13:51:50] thanks for the fix! [13:51:52] I also pointed the archive and label tables at the civicrm db [13:52:01] so you'll need to make sure that is up to date [13:52:15] Ok, I'd pull that down and test again [13:52:40] I got 92% accuracy, so looks really promising [13:52:46] ooh, even better! [13:53:09] oh right, I was also going to share a list of manually tagged fraud txns [13:53:18] let me review that and see the best way [13:53:25] though not trained on the full dataet yet, just a subset I downloaded today [13:53:30] oh cool [13:53:41] right, let me add some for today too [13:53:50] I'm just wondering why some features have NaN in the correlation values [13:54:34] yeah, and there was something else a few days back with a crazy big time_zone_offset that I need to add error handling for [13:55:59] Over in the CRM table, there's one more patch needed to actually see the stuff in searchkit: https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1304841?usp=search [13:56:34] (03CR) 10Damilare Adedoyin: [C:03+2] Add API4 entities for PaymentAttempt + Label [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304841 (https://phabricator.wikimedia.org/T429607) (owner: 10Ejegg) [13:56:38] thanks! [13:58:59] yesterday i finally got pycharm attaching a debugger to the running webservice [13:59:21] so i'm hoping to track down the problem with the scaler today [13:59:27] and actually get some scores back [13:59:33] cool, so does this mean we won't be needing a db on the same cluster anymore. since both tables are now on civi [13:59:49] damilare: so the primary table will stay on the new machine [13:59:53] oh nice! I was going to look into that to step through the code [13:59:58] just the archive table + label table [14:00:14] want to do a video call in 15 min or so to go through the debugger setup? [14:00:19] okk makes sense [14:00:39] sure, but give me a sec to setup pycharm [14:07:45] laurabar: would you like to set up pycharm and take a look at the ML code with us? [14:08:03] https://www.jetbrains.com/pycharm/download [14:08:39] If you've already set up a jetbrains account to install phpstorm it should just install w/o any additional account steps [14:09:49] laurabar is currently in transit now [14:10:30] maybe we can record for her and Daniel to catch up with they are settled [14:12:37] oh right [14:12:42] travel day [14:12:50] sure, let's record it [14:13:18] (03PS4) 10Lars SG: WIP: Use Failed status for recurring contribution that have failed [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304872 (https://phabricator.wikimedia.org/T429806) [14:13:34] (03CR) 10CI reject: [V:04-1] WIP: Use Failed status for recurring contribution that have failed [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304872 (https://phabricator.wikimedia.org/T429806) (owner: 10Lars SG) [14:15:10] ejegg we could use the tech talk meeting. I'm on it, please join in whenever you're ready. [14:15:24] (03Merged) 10jenkins-bot: Add API4 entities for PaymentAttempt + Label [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304841 (https://phabricator.wikimedia.org/T429607) (owner: 10Ejegg) [14:15:29] (03PS5) 10Lars SG: WIP: Use Failed status for recurring contribution that have failed [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304872 (https://phabricator.wikimedia.org/T429806) [14:16:39] (03CR) 10CI reject: [V:04-1] WIP: Use Failed status for recurring contribution that have failed [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304872 (https://phabricator.wikimedia.org/T429806) (owner: 10Lars SG) [14:17:58] ok damilare I'll join [14:21:33] (03PS6) 10Lars SG: WIP: Use Failed status for recurring contribution that have failed [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304872 (https://phabricator.wikimedia.org/T429806) [14:22:47] 03Fundraising Sprint: Kondo-approved bare room, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Donation-Processing, and 2 others: Engage <> Gr4vy for Direct Mail CC and ACH - https://phabricator.wikimedia.org/T417842#12045868 (10MDemosWMF) @Eileenmcnaughton - @Cstone Said in slack that these... [14:42:13] (03CR) 10CI reject: [V:04-1] WIP: Use Failed status for recurring contribution that have failed [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304872 (https://phabricator.wikimedia.org/T429806) (owner: 10Lars SG) [14:51:45] (03Abandoned) 10Ejegg: FOR STAGING: add csvreader [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1303563 (owner: 10Ejegg) [14:54:52] (03PS2) 10Lars SG: Add hasValue() for pre hook to check if a value is included without confusing null [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1301454 (https://phabricator.wikimedia.org/T386961) [14:59:15] (03PS3) 10Lars SG: Add hasValue() for pre hook to check if a value is included without confusing null [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1301454 (https://phabricator.wikimedia.org/T386961) [14:59:15] (03PS1) 10Lars SG: Add MG Stage Change activity when user edits [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305148 (https://phabricator.wikimedia.org/T386961) [14:59:33] (03PS2) 10Lars SG: Add MG Stage Change activity when user edits [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1300277 (https://phabricator.wikimedia.org/T386961) [14:59:43] (03CR) 10Lars SG: Add MG Stage Change activity when user edits (031 comment) [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1300277 (https://phabricator.wikimedia.org/T386961) (owner: 10Lars SG) [15:00:21] (03Abandoned) 10Lars SG: Add MG Stage Change activity when user edits [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305148 (https://phabricator.wikimedia.org/T386961) (owner: 10Lars SG) [15:01:17] (03PS3) 10Lars SG: Add MG Stage Change activity when user edits [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1300277 (https://phabricator.wikimedia.org/T386961) [15:15:22] 03Fundraising Sprint: Kondo-approved bare room, 06Fundraising-Backlog: Create Chariot IPN listener in smashpig - https://phabricator.wikimedia.org/T428007#12046136 (10Jgreen) Done! [15:23:35] (03CR) 10Damilare Adedoyin: [C:03+2] "Thanks for all the work on this, LGTM!" [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/1295075 (owner: 10Ejegg) [15:23:39] (03CR) 10Damilare Adedoyin: [V:03+2 C:03+2] Add fundraising-ml db setup and config [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/1295075 (owner: 10Ejegg) [15:25:16] Woohoo! [15:25:18] thank you damilare [15:26:16] np thanks for all the work on it also, glad to see it taking shape nicely [15:26:25] I've also approved the gitlab mr [15:27:45] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, 07fr-acoustic, 07FR-Audience-Dev: Populating both_funds_latest_donation_source field - https://phabricator.wikimedia.org/T379700#12046256 (10MSuijkerbuijk_WMF) @Lars We decided to pause on the calculated asks due to a new... [15:44:18] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, 07fr-acoustic, 07FR-Audience-Dev: Populating both_funds_latest_donation_source field - https://phabricator.wikimedia.org/T379700#12046566 (10Lars) @MSuijkerbuijk_WMF Let's just decouple this then, it's not a big project.... [16:00:25] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, 07fr-acoustic, 07FR-Audience-Dev: Populating both_funds_latest_donation_source field - https://phabricator.wikimedia.org/T379700#12046664 (10MSuijkerbuijk_WMF) Thank you @Lars [16:00:34] (03PS1) 10Ejegg: WIP labelAsFraud action [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305169 [16:00:34] (03PS1) 10Ejegg: SearchKit task to label payment attempts as fraud [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305170 (https://phabricator.wikimedia.org/T429607) [16:01:09] woot, using ^^^ is way easier than the grep-fu I was trying to use to label things before [16:01:44] oh those should be squashed [16:01:59] (03CR) 10CI reject: [V:04-1] WIP labelAsFraud action [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305169 (owner: 10Ejegg) [16:02:12] (03PS2) 10Ejegg: SearchKit task to label payment attempts as fraud [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305169 (https://phabricator.wikimedia.org/T429607) [16:02:26] (03Abandoned) 10Ejegg: SearchKit task to label payment attempts as fraud [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305170 (https://phabricator.wikimedia.org/T429607) (owner: 10Ejegg) [16:26:10] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, 03Civi RoadMap FY 26-27, 07fr-acoustic: Enabling Comms Newsletter Subscription management (and list capture) in Civi - https://phabricator.wikimedia.org/T396430#12046931 (10SBurnett-WMF) From my meeting with Ina, this see... [16:36:35] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, 10FR-Donation-Processing, 0725 Dec Q3 Planning: New batch data entry update: Vague error description - https://phabricator.wikimedia.org/T404644#12047010 (10MDemosWMF) Thank you @Lars and core team! Looks like a great... [16:44:34] (03CR) 10Lars SG: [C:03+2] SearchKit task to label payment attempts as fraud [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305169 (https://phabricator.wikimedia.org/T429607) (owner: 10Ejegg) [16:46:23] thanks larssandergreen ! [16:47:01] ok, let's see if we can deploy some of this stuff [16:50:34] ejegg: totally fine as is, but if you wanted to get fancy in the future, I think you could do the whole thing directly in the task definition by using save with a match which would update if the paymentattemptlabel row existed and add if not [17:02:41] oho [17:02:52] that does sound clever [17:06:51] (03Merged) 10jenkins-bot: SearchKit task to label payment attempts as fraud [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305169 (https://phabricator.wikimedia.org/T429607) (owner: 10Ejegg) [17:07:52] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Create alerts for declined refunds - https://phabricator.wikimedia.org/T429973 (10Damilare) 03NEW [17:08:04] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Create alerts for declined refunds - https://phabricator.wikimedia.org/T429973#12047273 (10Damilare) p:05Triage→03High [17:41:42] damilare: now I'm thinking we should reserve that label table for manually-reviewed attempts [17:42:28] that'd take a while to fill up, no? [17:43:08] right, but we can still use the blocked_by_filter and fraud_flagged_by_processor columns when getting training data [17:43:43] just feels like there ought to be a way to tell which labels are human-created [17:44:20] then if we do figure out how to use the probabilities instead of 0/1 [17:44:41] we can treat the human labels as definitive and the inferred ones as not quite so certain [17:45:25] let me see how ugly that makes the SQL to select the labels for the training script [17:47:06] I'm wondering if we can have a multi label training [17:49:43] would that be one model trained on the human labels, another on the processor declines, and another on whether it's blocked by our rules? [17:50:55] yes essentially [17:55:25] (03PS9) 10Lars SG: Use Failed status for recurring contribution that have failed [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304872 (https://phabricator.wikimedia.org/T429806) [17:58:01] ok multi label is possible, but your criteria for using decimal values for our labels gotten from our rules might make it a bit difficult. [17:59:28] oh just reread your last response, seems one model can actually return the 3 outputs. But having multiple models might be a good one to explore [18:00:58] multiple models can output probabilities like probability of refund due to fraud given the assigned probability of been blocked by our rules [18:02:56] the multi label approach I was initially thinking about was having the probabilities for each scenario outputted like [0.9 0.1 0.5] [18:06:58] here's the docs for multi output: https://xgboost.readthedocs.io/en/stable/tutorials/multioutput.html [18:08:02] I guess it does makes sense to separate the labels [18:11:24] ok, cool, and it seems like the SQL won't be so bad in the short term if we need to train on a single 0/1 but just select from multiple columns [18:21:41] (03PS9) 10Jgleeson: WIP: Implement ComboWiki Payment Form in Vue [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1303431 (https://phabricator.wikimedia.org/T428019) [18:25:03] nice, I finally have the service returning a model score [18:30:26] fr-tech I'm at the point where I need to start thinking about bring in third party JS to combowiki and would like to chat about it on tech talk [18:31:20] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Create alerts for declined refunds - https://phabricator.wikimedia.org/T429973#12047679 (10Damilare) p:05High→03Medium [18:31:30] (03PS1) 10Damilare Adedoyin: Add Alert for declined notifications [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1305226 (https://phabricator.wikimedia.org/T429973) [20:05:01] sandwich just showed up. going to go eat somewhere that doesn't smell like burning. back in a few. [20:29:45] (03PS1) 10Lars SG: Don't log changes to civicrm_payment_attempts [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305244 [20:34:12] (03CR) 10Ejegg: [C:03+2] Change deprecated target_contact_id IN [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1300298 (https://phabricator.wikimedia.org/T428122) (owner: 10Lars SG) [20:38:14] (03CR) 10Eileen: "given the name parser is not new here maybe we could put this out & worry about that after - I'd love to try a couple of transactions on p" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1281984 (https://phabricator.wikimedia.org/T419044) (owner: 10Eileen) [20:50:35] (03CR) 10Eileen: [C:03+2] Don't log changes to civicrm_payment_attempts [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305244 (owner: 10Lars SG) [20:53:02] (03Merged) 10jenkins-bot: Change deprecated target_contact_id IN [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1300298 (https://phabricator.wikimedia.org/T428122) (owner: 10Lars SG) [20:53:22] (03CR) 10Eileen: [C:03+2] Add hasValue() for pre hook to check if a value is included without confusing null [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1301454 (https://phabricator.wikimedia.org/T386961) (owner: 10Lars SG) [20:57:58] 03Fundraising Sprint: Kondo-approved bare room, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Donation-Processing, and 2 others: Engage <> Gr4vy for Direct Mail CC and ACH - https://phabricator.wikimedia.org/T417842#12048209 (10Eileenmcnaughton) @MDemosWMF yes - I found & updated them - it w... [21:02:04] (03PS1) 10Ejegg: Fix monolog menu path [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305249 [21:05:31] (03PS10) 10Lars SG: Use Failed status for recurring contribution that have failed [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1304872 (https://phabricator.wikimedia.org/T429806) [21:12:26] (03CR) 10Lars SG: [C:03+2] Fix monolog menu path [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305249 (owner: 10Ejegg) [21:33:58] (03Merged) 10jenkins-bot: Fix monolog menu path [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1305249 (owner: 10Ejegg) [22:42:43] 10fundraising-tech-ops: Fundraising access request for Daniel Miranda - https://phabricator.wikimedia.org/T429276#12048513 (10Dwisehaupt) [22:44:09] 10fundraising-tech-ops: Fundraising access request for Daniel Miranda - https://phabricator.wikimedia.org/T429276#12048515 (10Dwisehaupt) 05Open→03Resolved Verified ssh access working. Added dmiranda entries to git reviewer portions on mediawiki. Closing this request. [22:56:25] 10fundraising-tech-ops: Fundraising access request and new user setup for Stann-Omar Jones - https://phabricator.wikimedia.org/T427292#12048536 (10Dwisehaupt) [22:57:24] 10fundraising-tech-ops: Fundraising access request and new user setup for Stann-Omar Jones - https://phabricator.wikimedia.org/T427292#12048542 (10Dwisehaupt) 05Open→03Resolved Verified ssh and other access has been working. superset login hasn't been verified but is is on the path to deprecation so that... [22:59:42] 06Fundraising-Backlog, 10fundraising-tech-ops, 10FR-Tech-Analytics: Grant Maya Kampurath access to the dbt repo - https://phabricator.wikimedia.org/T423466#12048545 (10Dwisehaupt) IIRC this was provided by a tar.gz of the repo. Will verify with @AStein-WMF tomorrow that it can be closed. Also of note, this r...