[03:04:04] 10Fundraising-Backlog, 10FR-Tech-Analytics: Some Recent Email Send have No Clicks Or Donations - https://phabricator.wikimedia.org/T355974 (10MSuijkerbuijk_WMF) Is there a way to bring that information into Superset? @JMando @Cstone Or could you share final numbers for sp73859020 and sp73859018, if possible? [06:01:14] (03CR) 10CI reject: [V: 04-1] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] (REL1_39) - 10https://gerrit.wikimedia.org/r/993554 (owner: 10L10n-bot) [13:59:22] (03CR) 10Ejegg: [C: 03+2] Port https://github.com/civicrm/civicrm-core/pull/29062 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992257 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [14:00:10] (03PS3) 10Ejegg: Fix failure to calculate donor_status 90 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992836 (https://phabricator.wikimedia.org/T355851) (owner: 10Eileen) [14:00:30] (03PS4) 10Ejegg: Fix failure to calculate donor_status 90 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992836 (https://phabricator.wikimedia.org/T355851) (owner: 10Eileen) [14:00:34] (03CR) 10Ejegg: [C: 03+2] Fix failure to calculate donor_status 90 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992836 (https://phabricator.wikimedia.org/T355851) (owner: 10Eileen) [14:01:06] (03PS2) 10Ejegg: IDE formatting [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992838 (owner: 10Eileen) [14:01:08] (03CR) 10Ejegg: [C: 03+2] IDE formatting [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992838 (owner: 10Eileen) [14:06:52] (03PS5) 10Ejegg: Apply IDE formatting for short-array syntax [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992270 (owner: 10Eileen) [14:07:04] (03CR) 10Ejegg: [C: 03+2] Apply IDE formatting for short-array syntax [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992270 (owner: 10Eileen) [14:10:24] (03CR) 10Jgleeson: [C: 03+2] "I really like the idea of encapsulating the creation of test entities in traits, Nice!" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992832 (https://phabricator.wikimedia.org/T353907) (owner: 10Eileen) [14:10:51] hah, beat me to it jgleeson [14:11:09] lemme just rebase that over the stack that's pending merge [14:11:15] did you move to that chain? [14:11:40] (03PS4) 10Ejegg: Use EntityTrait & createTestEntity creating contacts [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992832 (https://phabricator.wikimedia.org/T353907) (owner: 10Eileen) [14:11:49] I saw the irc chatter so went higher up the list and thought that was on a different patch chain [14:12:07] i was doing a bunch of uncorrelated ones, but was rebasing them as I went to make a chain [14:12:15] then I hopped over to the trait one [14:12:23] not fast enough [14:12:25] :D [14:12:49] it would sure be nice to have all of our CRM tests using the same way of creating and cleaning up entities! [14:12:52] those testy creator traits are pretty neat [14:13:26] this one looks distinct https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/992214 [14:13:31] definitely seems right to have the descriptive key rather than the id => id way we're doing it in our own base test [14:14:07] latest email: Spreedly Marketing Team - Orchestrate your payments success in 2024! [14:15:03] presumably signing up for a developer account also means send me all the sales emails [14:16:19] (03Merged) 10jenkins-bot: Port https://github.com/civicrm/civicrm-core/pull/29062 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992257 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [14:18:04] (03Merged) 10jenkins-bot: Fix failure to calculate donor_status 90 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992836 (https://phabricator.wikimedia.org/T355851) (owner: 10Eileen) [14:18:47] (03Merged) 10jenkins-bot: IDE formatting [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992838 (owner: 10Eileen) [14:23:08] ah jgleeson i just clicked into that one you linked. I'm leaning towards trying our eileen's idea of a WmfMessage class to encapsulate those arrays some [14:23:34] take it I'll jump to the other onn top of the test [14:23:50] I was just looking for something else to look at for 5 minutes [14:24:15] before opening up the mac and trying to recreate the symlink problem cstone ran into on friday https://etherpad.wikimedia.org/p/fr-tech-docker-updates [14:24:20] (03Merged) 10jenkins-bot: Apply IDE formatting for short-array syntax [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992270 (owner: 10Eileen) [14:24:59] huh, civibuild not in path? I guess due to the failure to symlink? [14:26:17] maybe although it worked last time I tried so I need to figure out what broke [14:27:06] I did add some code to stop it checking to install buildkit repeatedly if it was already there between wmff civicrm and civicrm core [14:27:14] maybe that broke something [14:28:41] "Error response from daemon: unable to find user invalid-user: no matching entries in passwd file" .. hmm that would happen if there was now .env file [14:29:01] the .env file feeds the env vars used by docker compose [14:29:10] which then inturn injects them into the container [14:29:46] invalid-user is a guard Andy added to prevent us running at a non-intended user [14:29:52] as* [14:46:32] (03CR) 10Jgleeson: [C: 03+2] "thanks for the test!" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992833 (https://phabricator.wikimedia.org/T353907) (owner: 10Eileen) [14:46:44] (03CR) 10CI reject: [V: 04-1] Add test for unspecified contact ID bug [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992833 (https://phabricator.wikimedia.org/T353907) (owner: 10Eileen) [14:46:55] (03PS3) 10Ejegg: Add test for unspecified contact ID bug [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992833 (https://phabricator.wikimedia.org/T353907) (owner: 10Eileen) [14:51:01] (03CR) 10Jgleeson: [C: 04-1] "I did a similar find-and-replace as part of the WIP work on the wider updates. In the interest of skipping the merge conflict dance, could" [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/985943 (https://phabricator.wikimedia.org/T352992) (owner: 10Eileen) [15:38:34] (03CR) 10Ejegg: "This looks useful for our big file imports! Too bad the UploadedFile has to re-implement a lot of logic from the core CSV class. Might be " [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992258 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [15:42:59] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Standardize CiviCRM tests on EntityTrait and createTestEntity - https://phabricator.wikimedia.org/T356066 (10Ejegg) [15:54:08] 10Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2324Q3 maintenance window - https://phabricator.wikimedia.org/T337581 (10Jgreen) [16:10:04] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Recurring-Donations: Improvements to failed recurring charge logic - https://phabricator.wikimedia.org/T356073 (10Ejegg) [16:15:48] 10Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2324Q3 maintenance window - https://phabricator.wikimedia.org/T337581 (10Jgreen) [16:17:03] (03PS1) 10Ejegg: Set next_sched date when entering autoRescue [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/993725 (https://phabricator.wikimedia.org/T353294) [16:18:45] (03CR) 10Nikerabbit: [V: 03+2] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] (REL1_39) - 10https://gerrit.wikimedia.org/r/993554 (owner: 10L10n-bot) [16:19:08] 10Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2324Q3 maintenance window - https://phabricator.wikimedia.org/T337581 (10Jgreen) [16:20:01] (03PS1) 10Ejegg: Add missing use statement [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/993726 [16:37:03] (03CR) 10CI reject: [V: 04-1] Set next_sched date when entering autoRescue [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/993725 (https://phabricator.wikimedia.org/T353294) (owner: 10Ejegg) [16:37:23] (03CR) 10CI reject: [V: 04-1] Add missing use statement [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/993726 (owner: 10Ejegg) [16:40:48] 10Fundraising-Backlog: Gift date in Civi thank you for stock gift imported from Overflow is wrong - https://phabricator.wikimedia.org/T355452 (10Ejegg) The date on that gift is December 20th, 2023 2:00 AM (UTC), so when we translate that to Hawaii time (as we do for Thank You letters, to get last-minute donors i... [16:43:00] (03PS2) 10Ejegg: Add missing use statement [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/993726 [16:43:03] (03PS2) 10Ejegg: Set next_sched date when entering autoRescue [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/993725 (https://phabricator.wikimedia.org/T353294) [16:43:33] 10Fundraising-Backlog: Gift date in Civi thank you for stock gift imported from Overflow is wrong - https://phabricator.wikimedia.org/T355452 (10MDemosWMF) Thanks for that insight Elliot. I'm not sure if there's anything that can be tweaked on the import side, but here is the link if that's helpful: https://civi... [16:51:15] 10Fundraising-Backlog: Gift date in Civi thank you for stock gift imported from Overflow is wrong - https://phabricator.wikimedia.org/T355452 (10Ejegg) Does the date in the import file have a time zone on it? The only import tweak I can think of is that we could make sure that we're importing against the right t... [17:00:35] (03CR) 10CI reject: [V: 04-1] Set next_sched date when entering autoRescue [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/993725 (https://phabricator.wikimedia.org/T353294) (owner: 10Ejegg) [17:03:24] (03PS3) 10Ejegg: Set next_sched date when entering autoRescue [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/993725 (https://phabricator.wikimedia.org/T353294) [17:05:19] (03CR) 10Damilare Adedoyin: [C: 03+2] Add missing use statement [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/993726 (owner: 10Ejegg) [17:15:01] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for jadams - https://phabricator.wikimedia.org/T355900 (10Dwisehaupt) Renewed certificate and sent via email. Password sent via SMS. [17:18:19] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for ewhite - https://phabricator.wikimedia.org/T355970 (10Dwisehaupt) Renewed certificate and sent via email. Password sent via SMS. [17:21:40] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for jianwong - https://phabricator.wikimedia.org/T355971 (10Dwisehaupt) Renewed certificate and sent via email. Password sent via SMS. [17:24:43] (03Merged) 10jenkins-bot: Add missing use statement [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/993726 (owner: 10Ejegg) [17:25:09] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for sguseman - https://phabricator.wikimedia.org/T355969 (10Dwisehaupt) Renewed certificate and sent via email. Password sent via SMS. [17:59:53] 10Fundraising-Backlog, 10FR-Tech-Analytics: Some Recent Email Send have No Clicks Or Donations - https://phabricator.wikimedia.org/T355974 (10JMando) @MSuijkerbuijk_WMF @RLopez-WMF do each of these individual emails ('sp73859018','sp73859020','sp73863609','sp73863614') have a different utm_campaign? If so, I c... [18:03:35] 10Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2324Q3 maintenance window - https://phabricator.wikimedia.org/T337581 (10Dwisehaupt) [18:04:35] 10Fundraising-Backlog: FY2324 Q3: Need to map new Civi fields over to Acoustic - https://phabricator.wikimedia.org/T353386 (10KHaggard) Hi, so I've paused the data jobs in Acoustic now and I'm changing the existing fields to the new names and purging the old values. I'll update when finished and when I'm ready f... [18:30:01] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Determine if we need to have 1-click unsubscribes on our thank you etc emails - https://phabricator.wikimedia.org/T354586 (10XenoRyet) Per Danny: We have just received confirmation that we can remove th... [18:35:03] 10Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2324Q3 maintenance window - https://phabricator.wikimedia.org/T337581 (10Dwisehaupt) [18:48:17] (03PS1) 10Damilare Adedoyin: WIP: Add wmf_* fields for analytics [wikimedia/fundraising/tools/DjangoBannerStats] - 10https://gerrit.wikimedia.org/r/993757 (https://phabricator.wikimedia.org/T355166) [18:48:58] (03CR) 10CI reject: [V: 04-1] WIP: Add wmf_* fields for analytics [wikimedia/fundraising/tools/DjangoBannerStats] - 10https://gerrit.wikimedia.org/r/993757 (https://phabricator.wikimedia.org/T355166) (owner: 10Damilare Adedoyin) [18:49:13] (03PS2) 10Damilare Adedoyin: WIP: Add wmf_* fields for analytics [wikimedia/fundraising/tools/DjangoBannerStats] - 10https://gerrit.wikimedia.org/r/993757 (https://phabricator.wikimedia.org/T355166) [18:49:56] (03PS3) 10Damilare Adedoyin: WIP: Add wmf_* fields for analytics [wikimedia/fundraising/tools/DjangoBannerStats] - 10https://gerrit.wikimedia.org/r/993757 (https://phabricator.wikimedia.org/T355166) [18:57:24] 10Fundraising-Backlog, 10FR-Tech-Analytics: Some Recent Email Send have No Clicks Or Donations - https://phabricator.wikimedia.org/T355974 (10Cstone) @JMando we get those values on the donations from the utm_source. If they do have different utm_campaigns I could backfill the utm_source data from that too on o... [19:04:21] 10Fundraising-Backlog: FY2324 Q3: Need to map new Civi fields over to Acoustic - https://phabricator.wikimedia.org/T353386 (10KHaggard) Actually, let me clarify, you can send over the mapping file whenever you're ready, I just won't be able to map until closer to my end of day since reorganizing the fields is ta... [19:13:09] 10Fundraising-Backlog: Gift date in Civi thank you for stock gift imported from Overflow is wrong - https://phabricator.wikimedia.org/T355452 (10MDemosWMF) @Ejegg There is no timestamp in the import file, so that makes me wonder if the 2AM time is some sort of setting in the import template itself? Not the file,... [19:16:57] 10Fundraising-Backlog: Gift date in Civi thank you for stock gift imported from Overflow is wrong - https://phabricator.wikimedia.org/T355452 (10Ejegg) Huh, weird, that example donor you linked has stock gifts with very specific timestamps, all different hours. I'll try to figure out where they came from. So th... [19:21:17] 10Fundraising-Backlog: Gift date in Civi thank you for stock gift imported from Overflow is wrong - https://phabricator.wikimedia.org/T355452 (10MDemosWMF) Thanks for looking into it! I can also share an example of an import file. Saved one here: smb://filesrv1/Fundraising/Tech/Fr-Ops/Overflow import/Overflow WM... [19:42:28] (03CR) 10Wfan: [C: 03+2] Set next_sched date when entering autoRescue [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/993725 (https://phabricator.wikimedia.org/T353294) (owner: 10Ejegg) [19:43:26] thanks wfan ! [19:44:14] np ~ originally I think we should also update the success patch, then realized not necessary, haha, so all looks good [19:59:36] 10Fundraising-Backlog, 10FR-Tech-Analytics, 10FR-tech-data-integrity: FRU Donors Missing Country Info - https://phabricator.wikimedia.org/T355959 (10Ejegg) OK @JMando these addresses have been backfilled. In the end I used a slight variation of the above SQL, with two temp tables: `lang=sql CREATE TEMPORAR... [20:00:39] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Tech-Analytics, 10FR-tech-data-integrity: FRU Donors Missing Country Info - https://phabricator.wikimedia.org/T355959 (10Ejegg) [20:03:41] (03Merged) 10jenkins-bot: Set next_sched date when entering autoRescue [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/993725 (https://phabricator.wikimedia.org/T353294) (owner: 10Ejegg) [20:06:46] (03CR) 10Ejegg: "let's also add this to the dependencies for wmf-civicrm for new installs" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/992258 (https://phabricator.wikimedia.org/T341902) (owner: 10Eileen) [20:22:24] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog: EFT Matching Organization Import - Duplicate error override not working - https://phabricator.wikimedia.org/T353907 (10XenoRyet) 05Open→03Resolved [20:23:02] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog: Add IP for new endpoints for Adyen - https://phabricator.wikimedia.org/T355846 (10XenoRyet) 05Open→03Resolved [20:23:25] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10fundraising-tech-ops: Create ipset for mws.amazonservices.com - https://phabricator.wikimedia.org/T354816 (10XenoRyet) 05Open→03Resolved [20:23:45] 10Fundraising Sprint - Yesterday (UTC), 10Fundraising Sprint Uptown cURL, 10Fundraising-Backlog, 10Patch-For-Review: All Ingenico/Worldline active tokens will be migrated to Adyen - https://phabricator.wikimedia.org/T344645 (10XenoRyet) [20:23:47] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: Manually settled Adyen transaction not coming up in Civi - https://phabricator.wikimedia.org/T344472 (10Cstone) Thanks for the update @krobinson, I'm going to close this one as we've done a bunch of fixes to address some causes of th... [20:23:49] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising Sprint Uptown cURL, 10Fundraising-Backlog: Confirm all Ingenico Tokens made it across to Adyen - https://phabricator.wikimedia.org/T348770 (10XenoRyet) 05Open→03Resolved [20:23:54] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Smashpig, 10Recurring-Donations: Cancel auto-rescue at Adyen when donor cancels recurring donation in Civi - https://phabricator.wikimedia.org/T351338 (10XenoRyet) [20:24:21] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog: Correcting Gift Source Coding on Benevity import - https://phabricator.wikimedia.org/T354911 (10XenoRyet) 05Open→03Resolved [20:24:41] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Unplanned-Sprint-Work: Review our logging output via monolog - https://phabricator.wikimedia.org/T350649 (10XenoRyet) 05Open→03Resolved [20:24:45] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Smashpig, and 2 others: save retry.rescueReference for future cancel action - https://phabricator.wikimedia.org/T353293 (10XenoRyet) 05Open→03Resolved [20:25:25] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog: Civi: cancel recurrings for chargebacks - https://phabricator.wikimedia.org/T353549 (10XenoRyet) 05Open→03Resolved [20:26:35] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Smashpig, 10Recurring-Donations: Cancel auto-rescue at Adyen when donor cancels recurring donation in Civi - https://phabricator.wikimedia.org/T351338 (10XenoRyet) 05Open→03Resolved [20:26:38] 10Fundraising-Backlog, 10Recurring-Donations, 10Epic: Implement Adyen Auto-Rescue feature to improve donor recurring conversion - https://phabricator.wikimedia.org/T331920 (10XenoRyet) [20:26:46] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Suppress failmail on contribution tracking constraint violations - https://phabricator.wikimedia.org/T352321 (10XenoRyet) 05Open→03Resolved [20:26:51] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising Sprint Uptown cURL, 10Fundraising-Backlog, 10MW-1.42-notes (1.42.0-wmf.15; 2024-01-23): Send browser data to Adyen on CC transactions so we can optionally toggle on/off 3DS on demand - https://phabricator.wikimedia.org/T341299 (10XenoRyet) 05... [20:27:01] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10FR-Japan, 10MW-1.42-notes (1.42.0-wmf.12; 2024-01-02): Make the Japan "V1" payment wiki variant the new control - https://phabricator.wikimedia.org/T329807 (10XenoRyet) 05Open→03Resolved [20:27:07] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2324Q3 maintenance window - https://phabricator.wikimedia.org/T337581 (10Dwisehaupt) 05Open→03Resolved a:03Dwisehaupt [20:28:18] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Tech-Analytics, 10FR-tech-data-integrity: FRU Donors Missing Country Info - https://phabricator.wikimedia.org/T355959 (10XenoRyet) 05Open→03Resolved [20:28:40] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Strengthen protections against double charges in recurring job - https://phabricator.wikimedia.org/T354085 (10XenoRyet) 05Open→03Resolved [20:29:09] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: DLocal recurring cancel not sticking - https://phabricator.wikimedia.org/T354357 (10XenoRyet) 05Open→03Resolved [20:30:39] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices, 10MW-1.42-notes (1.42.0-wmf.9; 2023-12-12): "Typed card number does not match card brand" errors - https://phabricator.wikimedia.org/T349600 (10XenoRyet) 05Open→03Resolved [20:31:09] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices, 10MW-1.42-notes (1.42.0-wmf.9; 2023-12-12): Log client side error for adyen to look into "Typed card number does not match card brand" errors - https://phabricator.wikimedia.org/T349600 (10AnnWF) [20:32:42] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-donorservices: Manually settled Adyen transaction not coming up in Civi - https://phabricator.wikimedia.org/T344472 (10XenoRyet) 05Open→03Resolved [20:32:44] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Audit: create missing contribution_tracking entries instead of skipping importing them - https://phabricator.wikimedia.org/T339182 (10XenoRyet) [20:32:49] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: paypal audit line error with no subscr_id - https://phabricator.wikimedia.org/T350824 (10XenoRyet) 05Open→03Resolved [20:33:09] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Records in civicrm.civicrm_contribution_tracking with no time data. Bug or feature? - https://phabricator.wikimedia.org/T353804 (10XenoRyet) 05Open→03Resolved [20:33:34] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: email syntax error due to if condition for param directly - https://phabricator.wikimedia.org/T354801 (10XenoRyet) 05Open→03Resolved [20:33:51] 10Fundraising Sprint Quill Pencil, 10Fundraising Sprint RadioActivewear, 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Deadlock should result in requeueing the message - https://phabricator.wikimedia.org/T118487 (10XenoRyet) 05Open→03Resolved [20:34:27] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Venmo gateway_session_id missing - https://phabricator.wikimedia.org/T352691 (10XenoRyet) 05Open→03Resolved [20:34:41] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10MW-1.42-notes (1.42.0-wmf.14; 2024-01-16): Adyen payment submethod [xxx] was not found - https://phabricator.wikimedia.org/T353032 (10XenoRyet) 05Open→03Resolved [20:35:54] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-Adyen, 10FR-Smashpig: Adyen SecondChargeback IPN causes refund queue failure - https://phabricator.wikimedia.org/T352035 (10XenoRyet) 05Open→03Resolved [20:38:11] 10Fundraising-Backlog: Provide access to Brooklyn Data to relevant systems - https://phabricator.wikimedia.org/T356110 (10greg) [20:47:01] 10Fundraising-Backlog: Gift not importing, but error reason is not showing - https://phabricator.wikimedia.org/T355827 (10MDemosWMF) Thanks @Eileenmcnaughton I am happy to monitor this and we can see if this still pops up after those udpates take place. So far this hasn't come up too often, but at least now we k... [20:47:34] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog: Empty table when looking at import results - https://phabricator.wikimedia.org/T354457 (10MDemosWMF) Sounds good, will do. [21:22:08] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Turn our wmf donation $msg into a class - https://phabricator.wikimedia.org/T356115 (10Eileenmcnaughton) [21:22:30] 10Fundraising-Backlog, 10Documentation: Ensure all disaster recover documentation is in one central location - https://phabricator.wikimedia.org/T95841 (10AKanji-WMF) 05Open→03Resolved a:03AKanji-WMF FR-Techs have documentation appropriate for relevant stakeholders on mediums most accessible for them; re... [21:24:10] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Paypal: Revisit old PayPal bugs, delete code if no longer needed - https://phabricator.wikimedia.org/T355448 (10AKanji-WMF) Review logs in a couple weeks. [21:27:27] 10Fundraising-Backlog: Gift date in Civi thank you for stock gift imported from Overflow is wrong - https://phabricator.wikimedia.org/T355452 (10AKanji-WMF) p:05Triage→03High [21:34:43] 10Fundraising-Backlog: Changing User Permissions in Civi - https://phabricator.wikimedia.org/T347058 (10Eileenmcnaughton) moved to triage as this is back on the front-burner [21:35:29] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10fundraising-tech-ops, 10Unplanned-Sprint-Work: Upgrade CiviCRM to 5.70-rc - https://phabricator.wikimedia.org/T354706 (10Eileenmcnaughton) [21:36:16] dwisehaupt: anilk - I've been adding 'unplanned sprint work' when I bring things in (eg ^^) just to indicate that we didn't put in at the start - is that right? [21:37:12] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10Patch-For-Review, 10Unplanned-Sprint-Work: FY2324 Q3: Need to map new Civi fields over to Acoustic - https://phabricator.wikimedia.org/T353386 (10Eileenmcnaughton) [21:37:38] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10fundraising-tech-ops: Split coworker log on logging server - https://phabricator.wikimedia.org/T355714 (10Dwisehaupt) [21:37:58] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10fundraising-tech-ops: Split coworker log on logging server - https://phabricator.wikimedia.org/T355714 (10Dwisehaupt) 05Open→03Resolved [21:38:13] also just thinking - maybe if we are getting pinged on out of sprint tickets we should straight away more them back to triage ? That would kinda surface any re-prioritisation that needs doing? [21:43:58] ejegg: I think in about 20 mins I should have this acoustic update ready for review - will need to do stuff when I deploy to get file for Katie [21:44:55] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog: Correcting Gift Source Coding on Benevity import - https://phabricator.wikimedia.org/T354911 (10NNichols) @Eileenmcnaughton I can test this in a few days. Benevity's website is down and I can't pull any reports until the 31st. [21:45:57] ok eileen I'll be around [21:48:06] eileen: yes, I think if we're getting pinged about out-of-sprint tasks that aren't in current/chaos/+1 then we should probably bring them back to triage. I'm unsure about how to handle bringing in unplanned things - the tag is useful information I suppose, but I think it would also be useful to understand how many points per sprint are unplanned work. If we use it, we should all use it consistently....dwisehaupt prob [21:48:06] has thoughts [21:49:09] also @eileen - there's a couple of segmentation-related tasks based off the QA, I think I'm going to put them in Sprint +1 (unless you're already working on them) [21:49:41] anilk: yeah - I think maybe some of them I have done some stuff on - but sprint +1 starts tomorrow? [21:50:37] yes! [22:00:35] 10fundraising-tech-ops: Fundraising access request for Ramon Lopez - https://phabricator.wikimedia.org/T356116 (10RLopez-WMF) [22:04:17] (03PS8) 10Eileen: Update Silverpop export to include new fields [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/935182 (https://phabricator.wikimedia.org/T353386) [22:08:03] well I made all the changes - now I just need to refigure out how to run locally [22:13:11] 10Fundraising-Backlog, 10fundraising-tech-ops: Provide access to Brooklyn Data to relevant systems - https://phabricator.wikimedia.org/T356110 (10greg) [22:16:20] (03PS9) 10Eileen: Update Silverpop export to include new fields [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/935182 (https://phabricator.wikimedia.org/T353386) [22:17:22] (03CR) 10CI reject: [V: 04-1] Update Silverpop export to include new fields [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/935182 (https://phabricator.wikimedia.org/T353386) (owner: 10Eileen) [22:28:50] "Column 'donor_status_id' in field list is ambiguous" [22:37:16] ejegg: checking [22:44:11] (03PS10) 10Eileen: Update Silverpop export to include new fields [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/935182 (https://phabricator.wikimedia.org/T353386) [22:46:45] (03PS11) 10Eileen: Update Silverpop export to include new fields [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/935182 (https://phabricator.wikimedia.org/T353386) [22:47:09] hmm - I think it might need to go from the staging table [22:47:56] (03CR) 10CI reject: [V: 04-1] Update Silverpop export to include new fields [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/935182 (https://phabricator.wikimedia.org/T353386) (owner: 10Eileen) [22:50:38] (03PS12) 10Eileen: Update Silverpop export to include new fields [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/935182 (https://phabricator.wikimedia.org/T353386) [22:56:41] (03PS13) 10Eileen: Update Silverpop export to include new fields [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/935182 (https://phabricator.wikimedia.org/T353386) [22:56:54] woohoo, V+2 [22:56:57] reviewing [22:57:05] ejegg: I just pushed an update to the commit message - no other changes [23:06:58] ejegg: just relocating but will check in about 30 mins [23:21:49] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for spuri - https://phabricator.wikimedia.org/T355579 (10Dwisehaupt) Renewed certificate and sent via email. Password sent via SMS. [23:26:18] 10fundraising-tech-ops: Fundraising access request for Ramon Lopez - https://phabricator.wikimedia.org/T356116 (10Dwisehaupt) [23:28:06] eileen: it's looking good, and I see the IDs in the export, but I'm seeing blanks in the donor_segment and donor_status that should be populated by those case statements [23:28:41] not sure why, the IDs match the cases (donor_segment_id = 600 and donor_status_id = 10) [23:29:47] 10fundraising-tech-ops: Fundraising access request for Ramon Lopez - https://phabricator.wikimedia.org/T356116 (10Dwisehaupt) @DBu-WMF Could you verify this access request? Once it is verified, we can proceed. We will need the confirmation of granting access from Lisa and Ramon's information added to the [[https... [23:33:07] huh, and trying just a SELECT (paste CASE statement) from civicrm.wmf_donor [23:33:19] gets me donor_status=New [23:33:25] so what's up here? [23:35:05] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for abeckford - https://phabricator.wikimedia.org/T356123 (10Dwisehaupt) [23:35:45] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for nnichols - https://phabricator.wikimedia.org/T356124 (10Dwisehaupt) [23:36:13] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for sinaba - https://phabricator.wikimedia.org/T356125 (10Dwisehaupt) [23:37:51] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for jmando - https://phabricator.wikimedia.org/T356126 (10Dwisehaupt) [23:38:02] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for shust - https://phabricator.wikimedia.org/T356127 (10Dwisehaupt) [23:38:34] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for areyes - https://phabricator.wikimedia.org/T356128 (10Dwisehaupt) [23:38:44] 10Fundraising Spring - anybodyKnowWhatThisDoes(), 10Fundraising-Backlog, 10Patch-For-Review, 10Unplanned-Sprint-Work: FY2324 Q3: Need to map new Civi fields over to Acoustic - https://phabricator.wikimedia.org/T353386 (10KHaggard) Alright I'm all set now and ready to map whenever you are @Eileenmcnaughton... [23:38:52] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for jjameshill - https://phabricator.wikimedia.org/T356130 (10Dwisehaupt) [23:44:29] ejegg: maybe we should push out that with that blank just so we can get the job running with the other changes for time [23:44:48] & then I'll keep looking at those [23:45:07] actually I think I maybe know [23:45:27] it's probably not 10 but either 10 or 10.0 [23:46:48] (I just discovered my phone is going flat & I'm using it for wifi) [23:52:37] '10' [23:52:38] rather [23:52:59] but even if the fields are blank for now - it will be OK for the mapping work [23:53:10] I'm just running some queries directly on staging [23:54:14] ok, sounds good [23:55:26] (03CR) 10Ejegg: [C: 03+2] "Looks good to me! Getting blanks in the file for donor_segment and donor_status but we can fix those later as discussed on IRC." [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/935182 (https://phabricator.wikimedia.org/T353386) (owner: 10Eileen) [23:56:33] (03Merged) 10jenkins-bot: Update Silverpop export to include new fields [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/935182 (https://phabricator.wikimedia.org/T353386) (owner: 10Eileen) [23:58:05] (03PS1) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/993818 [23:58:20] (03CR) 10Eileen: [C: 03+2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/993818 (owner: 10Eileen) [23:58:48] (03Merged) 10jenkins-bot: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/993818 (owner: 10Eileen)