[00:09:21] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: TS update import back into Civi - https://phabricator.wikimedia.org/T255805 (Eileenmcnaughton) @CCogdill_WMF I'm just uploading the file now to try with the script to check that & then it will just be a... [00:17:07] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (Eileenmcnaughton) @CCogdi... [00:17:09] PROBLEM - check_log_messages on frav1002 is CRITICAL: CRITICAL: Adyen_endpoint_critical 1 [=1] [00:22:09] RECOVERY - check_log_messages on frav1002 is OK: OK [01:26:25] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: TS update import back into Civi - https://phabricator.wikimedia.org/T255805 (LeanneS) @Eileenmcnaughton @CCogdill_WMF I just did a spot check of a few in this group and they looked good. Happy to do a m... [01:46:07] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: TS update import back into Civi - https://phabricator.wikimedia.org/T255805 (Eileenmcnaughton) OK - I have run the first 2000 rows in via our command line method - the command works and simply requires... [01:48:25] So I've done all the steps for target smart apart from final checks & turning it on. I estimate it will take about 80 hours to run & it might be that more checks aren't really needed [10:24:46] Fundraising-Backlog, MediaWiki-extensions-DonationInterface, phan-taint-check-plugin, MW-1.35-notes (1.35.0-wmf.8; 2019-11-26): Add phan-taint-check-plugin to DonationInterface extension - https://phabricator.wikimedia.org/T202384 (Daimona) [10:25:04] Fundraising-Backlog, MediaWiki-extensions-DonationInterface, phan-taint-check-plugin, MW-1.35-notes (1.35.0-wmf.8; 2019-11-26): Add phan-taint-check-plugin to DonationInterface extension - https://phabricator.wikimedia.org/T202384 (Daimona) Closing as duplicate because taint-check is now included... [12:40:14] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (KHaggard) Both import job... [13:15:31] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog: Japanese MC 2nd Upsell Email - https://phabricator.wikimedia.org/T255227 (krobinson) Agreed - this is more a confirmation that the monthly will happen next month, so no tax info. So long any actual donations include it, I think it's not... [14:54:07] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (KHaggard) To answer @Eile... [15:25:40] hmm, new silverpop logic seems to take longer than expected [15:26:13] failmail says it timed out after 8 hrs [15:29:29] woah ejegg [15:32:03] hmm I thought we'd patched the code that results in the failmail related to: DATA_INCONSISTENT Trying to update contribution tracking row 80642885 that already has contribution_id 4664461 [15:32:31] jgleeson we fixed one of the things that gets us into that situation [15:32:47] but there can be a lot of other ways that two contributions get the same ct_id [15:33:10] oh? how so [15:33:35] and btw if it's a holiday where you are and you're only dropping in on the silverpop thing feel free to leave the explanation until monday! [15:33:41] for example, we saw an iDEAL bank transfer duplicated with only a single log line for us redirecting the donor to iDEAL [15:33:57] which means they probably reloaded a page on their bank's site or something [15:35:12] I was going to check on the fail mails real quick to see if they were ones we had run into before [15:35:56] thanks cstone ! [15:36:10] old to news look good [15:36:16] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog: Japanese MC 2nd Upsell Email - https://phabricator.wikimedia.org/T255227 (TSkaff) @Cstone Looks like it's approved now; so the footer is just: ============================ Many employers will generously match employee contributions: plea... [15:37:20] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog: Japanese MC 2nd Upsell Email - https://phabricator.wikimedia.org/T255227 (TSkaff) @Cstone Looks like it's approved now; so the footer is just: Many employers will generously match employee contributions: please check with your employer t... [15:43:24] that's great to hear cstone [15:48:53] (PS3) Ejegg: Add comment about escaping for employer autocomplete [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/608757 (https://phabricator.wikimedia.org/T256837) (owner: AndyRussG) [15:49:00] (CR) Ejegg: [C: +2] Add comment about escaping for employer autocomplete [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/608757 (https://phabricator.wikimedia.org/T256837) (owner: AndyRussG) [15:53:06] (PS3) Ejegg: Remove unused bannerController RL modules [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/606370 (https://phabricator.wikimedia.org/T224034) (owner: AndyRussG) [15:54:20] (CR) Ejegg: [C: +2] "Thanks for the de-crufting! Looks like bannerController is 4 years dead? TODO: update link in centralnotice-devicetype-unknown message th" [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/606370 (https://phabricator.wikimedia.org/T224034) (owner: AndyRussG) [16:00:34] (Merged) jenkins-bot: Add comment about escaping for employer autocomplete [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/608757 (https://phabricator.wikimedia.org/T256837) (owner: AndyRussG) [16:00:36] (Merged) jenkins-bot: Remove unused bannerController RL modules [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/606370 (https://phabricator.wikimedia.org/T224034) (owner: AndyRussG) [16:06:15] (CR) Krinkle: Don't show Admin UI tabs on subscribing wikis [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/606371 (owner: AndyRussG) [16:06:17] (CR) Krinkle: [C: +2] Don't show Admin UI tabs on subscribing wikis [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/606371 (owner: AndyRussG) [16:07:23] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog: Check on old Ingenico to new Ingenico test recurrings - https://phabricator.wikimedia.org/T256181 (Cstone) @Emartin The 11 tests recurred today, everything looks good. | Civi Contact ID | July Ingenico Order ID | | 12789573 | 400588614... [16:19:21] i havent 100% checked them all but I'm guessing the adyen failmails are first recurs from the US adyen vs ingenico test on june 3, lots of amex and looking like discover has the same issue [16:20:22] hi fr-tech! [16:20:35] hey AndyRussG :) [16:21:09] I see a lot of folks online! Is there even standup? or is that cancelled? [16:21:09] hi AndyRussG jgleeson [16:21:14] :) [16:21:19] :) [16:21:35] im technically not supposed to be here just was checking old to news then got distracted haha [16:22:08] I'm technically meant to be here but I'm also distracted https://www.youtube.com/watch?v=LGs_vGt0MY8 [16:22:12] heh yeah anything can be a break from anything else! [16:22:35] I think I'm gonna try and learn how to play the piano [16:22:41] nice jgleeson [16:23:05] jgleeson sounds fantastic! yeah go for it! [16:23:41] jgleeson I see a new patch set late yesterday from https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/608089 [16:24:12] do you think you'd like to walk through it together, and if so, what time-ish? [16:24:50] I just have to do a bank run, and the usual cooking, sometime before it's too late, but I can work that around whatever time would work for you :) [16:25:13] (Merged) jenkins-bot: Don't show Admin UI tabs on subscribing wikis [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/606371 (owner: AndyRussG) [16:26:26] oh yeah sorry AndyRussG it's still WIP. I spent a little on it yesterday around meetings but didn't wrap it up. I'm gonna go cook dinner shortly but once I'm back from that I'll see what's left and then let you know when it's good to be reviewed. thanks! [16:27:04] I wanted to take a peak into why the unsubscribes list was smaller than usual as reported by katers yesterday [16:27:23] so gonna do that now before I break for food [16:27:59] and replay merry christmas mr lawrence one more time... [16:28:35] peek* [16:28:53] jgleeson: ah okok cool yeah no rush! [16:29:14] so I'll try to do my non-work stuff now then :) [16:29:34] ejegg gonna make yuca pan de queso! I bought that mix package [16:29:35] Fundraising-Backlog: Recurring Adyen amex and discover IPNs not ignored - https://phabricator.wikimedia.org/T255303 (Cstone) [16:29:45] nice AndyRussG ! [16:30:24] Fundraising-Backlog: Recurring Adyen amex and discover IPNs not ignored - https://phabricator.wikimedia.org/T255303 (Cstone) More spam on 7/3 from 6/3 test. Discover: 80643704.2 80643527.2 80643407.2 [16:30:34] ejegg yeah! I'll tell you how it turns out! A lot of reviews said "this is yummy but I have no idea how authentic it is" and others said "this is totally not authentic" [16:30:50] however it is mostly yuca flour, so I could probably just add more cheese or other stuff [16:32:41] nice AndyRussG [16:37:23] ejegg this silverpop thing doesn't make sense [16:37:50] so the latest files generated by the export builder are here: civi1001:/var/lib/silverpop_export [16:40:38] cstone heh we'll see if it tastes ok... 8p they did also have like a giant back of straight yuca flour for like a million pesos [16:42:56] *bag [16:55:06] Fundraising-Backlog: Adyen recurring double recurring records in civi - https://phabricator.wikimedia.org/T257067 (Cstone) [16:57:32] alright fail mails investigated! gona head out on the lake now! have a good weekend everyone [17:16:32] cstone: have fun! [17:44:03] doing my bank run, back in about 1.5 hours [17:50:39] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog: Japanese TY Email - https://phabricator.wikimedia.org/T254052 (CDenes_WMF) Thank you Christine! I had our translator review the email via testmeister and found a few things that needed editing. I have edited the HTML file with these upda... [17:57:01] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog: Japanese MC 2nd Upsell Email - https://phabricator.wikimedia.org/T255227 (CDenes_WMF) Thank you all! @Cstone I had our Japanese translator review the email via the production testmeister and found two mistakes that need correcting. Pleas... [22:33:04] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Patch-For-Review: Create job to update/generate employer dataset for usage within paymentswiki - https://phabricator.wikimedia.org/T251201 (jgleeson) To Test: # Pull down https://gerrit.wikimedia.org/r/608089 # Connect to Wikim... [22:34:36] (PS6) Jgleeson: Command to check matching gifts employer data file [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/608089 (https://phabricator.wikimedia.org/T251201) [22:55:14] (PS3) Eileen: Silverpop - build main table incrementally [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609238 (https://phabricator.wikimedia.org/T253152) [22:55:57] (CR) jerkins-bot: [V: -1] Silverpop - build main table incrementally [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609238 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [23:14:13] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (Eileenmcnaughton) OK so I... [23:21:34] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (Eileenmcnaughton) OK the...