[00:10:46] (PS23) Ejegg: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [00:11:27] (CR) Ejegg: "PS23: fix column names for notice_regions table, add table and log columns to CentralNotice.sql" [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [00:28:15] AndyRussG: ohh, that js should go in the campaignmanager, not the base admin UI [00:38:07] (PS24) Ejegg: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [00:42:53] (PS25) Ejegg: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [00:45:08] (CR) Ejegg: "PS25: move multiselector init logic to campaignmanager, don't load jstree on other admin pages" [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [00:47:06] (PS26) Ejegg: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [00:47:32] ejegg sounds right! [01:57:45] (PS27) Ejegg: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [02:00:04] (CR) Ejegg: "PS27: de-bloat choice data using handy get_top_selected() function which returns just the top-level selections, including regions where th" [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [02:16:04] Fundraising-Backlog: Investigate: Add support for Paypal micro transaction pricing for donations under $6 - https://phabricator.wikimedia.org/T238576 (Ejegg) OK, looks like the payments-wiki side would be pretty easy. Our base adaptor class has logic for switching accounts depending on transaction data (we... [06:09:00] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, FR-Tech-Analytics: Email Data Audit / Data Capture - https://phabricator.wikimedia.org/T236855 (Eileenmcnaughton) Just an update that I have found a problem as you identified & have been work... [11:59:55] (PS1) Cdenes: French, Dutch, and Norwegian new TY emails [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/552057 [12:05:52] Fundraising-Backlog: First Batch of TY Emails Pushed to Gerritt - https://phabricator.wikimedia.org/T238736 (CDenes_WMF) [13:35:53] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Sysadmin Kane, Fundraising Sprint Trojan Horse Wisperer, Fundraising Sprint Usual Subscripts, and 5 others: Update CiviCRM Contacts Actions to include a new 'Send Annual Thank You Receipt' Action - https://phabricator.wikimedia.org/T238692... [15:21:45] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Sysadmin Kane, Fundraising Sprint Trojan Horse Wisperer, Fundraising Sprint Usual Subscripts, and 4 others: Update EOY Receipt Module to accept contact id argument - https://phabricator.wikimedia.org/T238691 (jgleeson) [15:30:13] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [15:35:13] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [15:39:05] (PS8) Jgleeson: WIP: Added annual thank you emailer extension [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/550371 (https://phabricator.wikimedia.org/T238692) [15:45:13] RECOVERY - check_mysql on frdev1001 is OK: Uptime: 1157450 Threads: 4 Questions: 243547688 Slow queries: 383171 Opens: 23929 Flush tables: 1 Open tables: 200 Queries per second avg: 210.417 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [15:58:40] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog: FRUEC: Detailed comparison of events in old and new log files for banner impression pipeline - https://phabricator.wikimedia.org/T236834 (AndyRussG) [16:04:43] Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog: Civi to IBM export: Ensure CIDs ordered in reverse chronological order - https://phabricator.wikimedia.org/T238689 (CCogdill_WMF) Okay thanks for digging into this and explaining the current prcess! @MBeat33 please have your team chime in if... [16:10:26] fr-tech any news to share in Scrum of Scrums? [16:11:44] ejegg: thanks! what about maybe asking if anyone has thoughts on why we might get client-side LP events without corresponding server-log pageviews? [16:12:12] sure thing AndyRussG [16:12:14] ...only if it seems appropriate to mention given other time and topic constraints, o course [16:12:17] thanks in advance!! [16:12:32] what's the ticket associated with that again? [16:13:51] ejegg: https://phabricator.wikimedia.org/T236835#5670862 ...see the section "Explaining orphaned events in new logs" [16:15:35] thanks! [16:15:57] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Sysadmin Kane, Fundraising Sprint Trojan Horse Wisperer, Fundraising Sprint Usual Subscripts, and 4 others: Civi: create annual $ summary TY email button - https://phabricator.wikimedia.org/T221271 (mepps) @MBeat33 @DStrine How do we w... [16:21:07] Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog: Ingenico iframe says Donate/Cancel Donation in US, Pay/Cancel elsewhere - https://phabricator.wikimedia.org/T238366 (Ejegg) a:Ejegg [16:31:32] Fundraising-Backlog, fundraising-tech-ops: Issue new SSL Client Certificate for ccogdill - https://phabricator.wikimedia.org/T238757 (Dwisehaupt) [16:33:17] Fundraising-Backlog, fundraising-tech-ops: Issue new SSL Client Certificate for jgleeson - https://phabricator.wikimedia.org/T238758 (Dwisehaupt) [16:54:59] Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog: Ingenico iframe says Donate/Cancel Donation in US, Pay/Cancel elsewhere - https://phabricator.wikimedia.org/T238366 (Ejegg) All of the language pack XLS files I downloaded already had the value as 'Donate'. In the individual theme configurat... [16:57:07] (PS1) Jgleeson: WIP: add contact_id filter to wmf_eoy_receipt module [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/552089 (https://phabricator.wikimedia.org/T238691) [17:08:21] fundraising-tech-ops, Operations, ops-eqiad: rack/setup/install frban1001.eqiad.wmnet - https://phabricator.wikimedia.org/T234068 (RobH) Please note that this has two entries in netbox: https://netbox.wikimedia.org/dcim/devices/2267/ https://netbox.wikimedia.org/dcim/devices/2318/ (this entry has b... [17:09:03] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Sysadmin Kane, Fundraising Sprint Trojan Horse Wisperer, Fundraising Sprint Usual Subscripts, and 5 others: Update EOY Receipt Module to accept contact id argument - https://phabricator.wikimedia.org/T238691 (Ejegg) @MBeat33 for the on... [17:09:45] Fundraising-Backlog, fundraising-tech-ops: Issue new SSL Client Certificate for tskaff - https://phabricator.wikimedia.org/T238761 (Dwisehaupt) [17:10:51] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Sysadmin Kane, Fundraising Sprint Trojan Horse Wisperer, Fundraising Sprint Usual Subscripts, and 5 others: Update EOY Receipt Module to accept contact id argument - https://phabricator.wikimedia.org/T238691 (Ejegg) Oops, never mind @M... [17:11:16] Fundraising-Backlog, fundraising-tech-ops: Issue new SSL Client Certificate for jseddon - https://phabricator.wikimedia.org/T238762 (Dwisehaupt) [17:11:57] Fundraising-Backlog, fundraising-tech-ops: Issue new SSL Client Certificate for jsamra - https://phabricator.wikimedia.org/T238763 (Dwisehaupt) [17:15:11] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Sysadmin Kane, Fundraising Sprint Trojan Horse Wisperer, Fundraising Sprint Usual Subscripts, and 5 others: Update EOY Receipt Module to accept contact id argument - https://phabricator.wikimedia.org/T238691 (MBeat33) Thanks! I will as... [17:20:55] (CR) Ejegg: "Thanks CDenes, I've just pulled these up on to staging if you want to test them." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/552057 (owner: Cdenes) [18:03:34] (PS9) Mepps: WIP: Added annual thank you emailer extension [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/550371 (https://phabricator.wikimedia.org/T238692) (owner: Jgleeson) [18:07:52] (CR) Ejegg: Finer geo targeting (2 comments) [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [18:08:03] (PS28) Ejegg: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [18:08:17] fr-tech i think i figured out the confirm thing--i was just thinking about it wrong [18:08:52] what's the best way to do it mepps? [18:09:08] i think i just need to add CRM.confirm to the form template [18:09:34] ah cool, so doing it via the template is cool for your use case? [18:10:50] (CR) jerkins-bot: [V: -1] Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [18:11:38] (CR) Ejegg: "PS28: fix comments and whitespace, move datepicker init back to general admin js, restore deleted param in test fn" [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [18:12:23] (PS29) Ejegg: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [18:13:37] i think so ejegg! working on it now [18:56:34] (PS1) Eileen: Fix Mailing.load to use UTC [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/552113 (https://phabricator.wikimedia.org/T238621) [19:00:30] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, FR-Civi-Dedupe, FR-Civi-Prospect: Possible addition to the deduper tool? - https://phabricator.wikimedia.org/T229927 (Eileenmcnaughton) @NNichols have you tested this? Good to close? [19:05:11] (PS1) Ejegg: Quit trying to build datepicker bundle [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/552116 [19:12:47] (PS1) Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/552118 [19:13:49] (CR) Cstone: [C: +2] Quit trying to build datepicker bundle [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/552116 (owner: Ejegg) [19:14:24] (Merged) jenkins-bot: Quit trying to build datepicker bundle [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/552116 (owner: Ejegg) [19:17:08] (CR) Ejegg: [C: +2] Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/552118 (owner: Ejegg) [19:17:46] (Merged) jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/552118 (owner: Ejegg) [19:19:51] (PS1) Eileen: Address timeout fail mail on repair job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/552119 (https://phabricator.wikimedia.org/T236855) [19:20:26] there's a WMDE tech talk on wikidata streaming now: https://www.youtube.com/watch?v=uWqKyC7gt0s [19:21:38] (PS2) Eileen: Address timeout fail mail on repair job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/552119 (https://phabricator.wikimedia.org/T236855) [19:23:01] (PS3) Eileen: Address timeout fail mail on repair job [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/552119 (https://phabricator.wikimedia.org/T236855) [19:25:14] I've put up this https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/crm/+/552119/ to reduce the repair failmail. I want to amp it up a bit as it's not keeping pace with the faster re-import [19:25:52] (actually I could do that without ^^ as the failmail was not happening when it wasn't keeping up but when it was overtaking) [19:26:57] (PS1) Ejegg: Schema change for region-level geotargeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/552121 (https://phabricator.wikimedia.org/T226438) [19:28:15] (PS30) Ejegg: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [19:29:39] (CR) Ejegg: "PS30: break out schema change into a preliminary patch" [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [19:31:02] Wikimedia-Fundraising-CiviCRM: Citibank Import for International donations is not working - https://phabricator.wikimedia.org/T238783 (RLewis) [19:31:36] !log updated fundraising internal dashboard from 69fdbec60d to 8fc2726736 [19:31:39] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [19:38:18] Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog, FR-Adyen: Adyen audit question: Nov refunds reaching Civi - https://phabricator.wikimedia.org/T238428 (Ejegg) p:Triage→Normal a:Ejegg [19:39:15] Fundraising-Backlog: Monthly convert: some display issues - https://phabricator.wikimedia.org/T238785 (spatton) [19:40:53] eileen: can we move some of your tickets from doing to deployed? like T230954 and T238606 [19:40:54] T230954: Middle name and initial appearing in first or last name fields causing lots of manual dedupe - https://phabricator.wikimedia.org/T230954 [19:40:54] T238606: First name field conflicts on nick name not being handled automatically - https://phabricator.wikimedia.org/T238606 [19:41:30] yeah - good thinking - the thing is both have potential follow ons [19:41:47] ahh, got it [19:41:52] ie. the Middle & in initial still has some variants I'm not catching & the other I need to expose in a form [19:42:11] but I could create follow ons rathr than keep them hanging around I guess [19:42:11] cool, thanks [19:42:20] nah, I'll leave 'em where they are [19:43:07] I'm going to be out a chunk this morning - winding up with mid-week meetings for the art centre project - but I'll work some or all of tomorrow [20:13:36] fundraising-tech-ops, DC-Ops, Operations, decommission: decommission alnilam.frack.codfw.wmnet - https://phabricator.wikimedia.org/T238233 (Papaul) [20:34:24] Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog, FR-Ingenico, MediaWiki-extensions-DonationInterface: Sending over-long first name field to Ingenico Connect - https://phabricator.wikimedia.org/T228094 (Ejegg) Resolved→Open [20:34:43] (PS1) Ejegg: Use mb_substring to truncate [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/552129 (https://phabricator.wikimedia.org/T228094) [20:34:59] fr-tech ^^ should fix recurring charges for cyrillic names [20:35:30] oh hmm, maybe that strlen should change too [20:35:55] (PS2) Ejegg: Use mb_substring to truncate [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/552129 (https://phabricator.wikimedia.org/T228094) [20:45:26] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Sysadmin Kane, Fundraising Sprint Trojan Horse Wisperer, Fundraising Sprint Usual Subscripts, and 4 others: Civi: create annual $ summary TY email button - https://phabricator.wikimedia.org/T221271 (MBeat33) @mepps If donors have made... [20:47:18] ejegg i was just messing around with the two strlens to see and yeah it totally returns as 3 instead of 1 [20:48:11] pretty annoying that php by default treats strings as a byte array [20:49:55] (CR) Cstone: [C: +2] "Looks good" [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/552129 (https://phabricator.wikimedia.org/T228094) (owner: Ejegg) [20:50:14] (Merged) jenkins-bot: Use mb_substring to truncate [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/552129 (https://phabricator.wikimedia.org/T228094) (owner: Ejegg) [20:59:16] thanks cstone [21:07:07] weird, composer still doesn't see the new version even after I clear-cache [21:10:08] huh, now it works when I get rid of the --no-dev [21:11:44] (PS1) Ejegg: Update SmashPig [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/552131 [21:11:50] (CR) Ejegg: [C: +2] Update SmashPig [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/552131 (owner: Ejegg) [21:13:55] (PS1) Ejegg: Update SmashPig [wikimedia/fundraising/crm/vendor] - https://gerrit.wikimedia.org/r/552132 [21:13:58] (CR) Ejegg: [C: +2] Update SmashPig [wikimedia/fundraising/crm/vendor] - https://gerrit.wikimedia.org/r/552132 (owner: Ejegg) [21:14:18] (PS1) Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/552133 [21:14:21] (CR) Ejegg: [C: +2] Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/552133 (owner: Ejegg) [21:17:09] (Merged) jenkins-bot: Update SmashPig [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/552131 (owner: Ejegg) [21:19:16] (Merged) jenkins-bot: Update SmashPig [wikimedia/fundraising/crm/vendor] - https://gerrit.wikimedia.org/r/552132 (owner: Ejegg) [21:25:24] I'm pushing out the first of those db_switcher removal calls [21:26:16] fr-tech if something goes wonky with that, it would look like the large donation bot looking for its threshold levels in the wrong database [21:27:05] !log Fundraising CiviCRM updated from 2802bdd649 to 852c4a36bd [21:27:08] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [21:44:33] (PS2) Ejegg: Update thank you email text. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/551924 (owner: Cstone) [21:44:59] (CR) Ejegg: [C: +2] "Less effusive, just as requested." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/551924 (owner: Cstone) [21:50:37] (Merged) jenkins-bot: Update thank you email text. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/551924 (owner: Cstone) [22:36:59] Fundraising-Backlog: Investigate: Add support for Paypal micro transaction pricing for donations under $6 - https://phabricator.wikimedia.org/T238576 (EMartin) @Ejegg It is feasible for the main account to be used for central clearing/settlement/fundng as the integration and bank are attached. Once the ac... [23:34:13] Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog: Civi to IBM export: Ensure CIDs ordered in reverse chronological order - https://phabricator.wikimedia.org/T238689 (MBeat33) Thank you @CCogdill_WMF > OK, looks like the merged records for 24041039 had different versions of the email addre... [23:58:19] Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog: Civi to IBM export: Ensure CIDs ordered in reverse chronological order - https://phabricator.wikimedia.org/T238689 (MBeat33) p:Unbreak!→Normal