[00:00:05] (PS1) Eileen: Exclude Refund contributions from calculations. [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/528295 (https://phabricator.wikimedia.org/T229273) [00:00:32] (CR) Eileen: [C: +2] "cherry-picked as some stuff not ready to go" [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/528295 (https://phabricator.wikimedia.org/T229273) (owner: Eileen) [00:01:10] (Merged) jenkins-bot: Exclude Refund contributions from calculations. [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/528295 (https://phabricator.wikimedia.org/T229273) (owner: Eileen) [00:54:55] (PS6) Eileen: Update backfill command [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/526798 (https://phabricator.wikimedia.org/T229273) [01:09:34] (PS7) Eileen: Update backfill command [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/526798 (https://phabricator.wikimedia.org/T229273) [01:12:17] (PS8) Eileen: Update backfill command [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/526798 (https://phabricator.wikimedia.org/T229273) [02:08:34] !log civicrm revision changed from 857dcc9461 to 2e03f9bb1e, config revision is 84b785d41c [02:08:40] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [02:14:42] (PS1) Eileen: Updated triggers [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/528303 (https://phabricator.wikimedia.org/T229273) [03:04:29] (PS1) Eileen: wip - try switching sql to use group by [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/528307 (https://phabricator.wikimedia.org/T229273) [05:01:16] (PS2) Eileen: Reformat sql to use group by & eliminate the order by [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/528307 (https://phabricator.wikimedia.org/T229273) [05:01:18] (PS1) Eileen: re-add date of largest contribution [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/528310 (https://phabricator.wikimedia.org/T229273) [05:20:49] (CR) Eileen: "testing on staging is coming out a bit lower - ie most runs under 500 per min using" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/528310 (https://phabricator.wikimedia.org/T229273) (owner: Eileen) [06:26:28] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: List all data types in the import from IBM to civi - https://phabricator.wikimedia.org/T227500 (Eileenmcnaughton) OK - written up here https://www.mediawiki.org/wiki/Fundra... [11:07:28] Wikimedia-Fundraising-CiviCRM: Created new Gift Source - Qualified Charitable Distribution - https://phabricator.wikimedia.org/T229901 (Aklapper) @RLewis: Assuming this task is about #Wikimedia-Fundraising-CiviCRM, hence adding project tag so others can find this task when searching for tasks under that proj... [13:25:29] Fundraising-Backlog: Portuguese TY email: matching gift link error - https://phabricator.wikimedia.org/T209506 (Pcoombe) Open→Resolved a:Pcoombe The formatting in the template is correct, and test emails in pt and pt-br both look good with a link to https://donate.wikimedia.org/wiki/Matching_Gifts. [13:27:50] srdsrd [13:28:24] @_@ [13:31:28] Fundraising-Backlog, FR-Civi-Prospect: Possible addition to the deduper tool? - https://phabricator.wikimedia.org/T229927 (NNichols) [14:29:20] Fundraising-Backlog: Bug: payment form still displays warning that we do not accept over 10K donations - https://phabricator.wikimedia.org/T229932 (DStrine) [15:28:35] Fundraising-Backlog: Bug: payment form still displays warning that we do not accept over 10K donations - https://phabricator.wikimedia.org/T229932 (Pcoombe) [17:25:47] Fundraising-Backlog: Portuguese TY email: matching gift link error - https://phabricator.wikimedia.org/T209506 (MBeat33) Thank you @Pcoombe [18:37:12] Fundraising-Backlog, FR-Civi-Prospect: Possible addition to the deduper tool? - https://phabricator.wikimedia.org/T229927 (MBeat33) This would be a really helpful feature! [19:01:45] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: New Custom Field - Endowment Site Listed as - https://phabricator.wikimedia.org/T229681 (DStrine) [19:09:56] Fundraising-Backlog: count impressions and campaigns in 2018 - https://phabricator.wikimedia.org/T229960 (DStrine) [19:10:32] Fundraising-Backlog, MediaWiki-extensions-CentralNotice: CentralNotice: count impressions and campaigns in 2018 - https://phabricator.wikimedia.org/T229960 (DStrine) [19:14:29] Wikimedia-Fundraising-Banners, donate.wikimedia.org: Update max donation amount in banners/donatewiki to 12000 USD - https://phabricator.wikimedia.org/T229961 (Pcoombe) [19:30:47] Wikimedia-Fundraising-Banners: Fix banner amount error messages - https://phabricator.wikimedia.org/T229962 (Pcoombe) [19:34:34] Wikimedia-Fundraising-Banners: Change %MINIMUM% variable name to something less confusing - https://phabricator.wikimedia.org/T229964 (Pcoombe) [19:36:39] Fundraising-Backlog, Epic: Investigation: Create Preference Center for donors to manage email subscription preferences - https://phabricator.wikimedia.org/T125272 (DStrine) [19:36:49] Fundraising-Backlog, Epic: Investigation: Create Preference Center for donors to manage email subscription preferences - https://phabricator.wikimedia.org/T125272 (DStrine) p:Low→Normal [19:37:30] Fundraising-Backlog, Epic: Investigation: Create Preference Center for donors to manage email subscription preferences - https://phabricator.wikimedia.org/T125272 (DStrine) [19:40:31] Fundraising-Backlog: document steps for fr-online to submit TY email to git - https://phabricator.wikimedia.org/T229965 (DStrine) [19:40:44] Fundraising-Backlog: document steps for fr-online to submit TY email to git - https://phabricator.wikimedia.org/T229965 (DStrine) a:Ejegg [19:55:07] Fundraising-Backlog, Epic: Investigation: Create Preference Center for donors to manage email subscription preferences - https://phabricator.wikimedia.org/T125272 (DStrine) [20:07:04] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: List all data types in the import from IBM to civi - https://phabricator.wikimedia.org/T227500 (DStrine) Open→Resolved [20:07:23] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Add new calendar year fields to silverpop export - https://phabricator.wikimedia.org/T228241 (DStrine) Open→Resolved [20:07:32] Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint Land before Timeouts, Fundraising Sprint Men In Slack, Fundraising Sprint Never Ending Query, and 3 others: Add calendar year totals fields to CiviCRM & export ? some? of them to silverpop - https://phabricator.wikimedia.org/T170972 (DSt... [20:07:46] Fundraising Sprint Land before Timeouts, Fundraising Sprint Men In Slack, Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising-Backlog: Rename Field in IBM export - https://phabricator.wikimedia.org/T225544 (DStrine) Open→Resolved [20:07:57] Fundraising Sprint Office  , Fundraising-Backlog: Republish Japanese Thank You email - https://phabricator.wikimedia.org/T228680 (DStrine) Open→Resolved [20:08:19] Fundraising Sprint A series of unfortunate event handlers, Fundraising Sprint Bert and Ernie's Excellent Adventure, Fundraising Sprint Casino Royale With Cheese, Fundraising Sprint Da Vinci Coder, and 15 others: Reduce recurring TY emails - https://phabricator.wikimedia.org/T213209 (DStrine) O... [20:08:33] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Investigate: TargetSmart Civi import - https://phabricator.wikimedia.org/T227513 (DStrine) Open→Resolved [20:09:20] Fundraising Sprint Men In Slack, Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising-Backlog: Elliott: estimate old tasks - https://phabricator.wikimedia.org/T226548 (DStrine) Open→Resolved [20:10:19] Fundraising Sprint Men In Slack, Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising-Backlog: Replace MySQL-python with pymysql in fundraising python scripts - https://phabricator.wikimedia.org/T213757 (Eileenmcnaughton) this is rolled back atm [20:13:32] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Investigate: Add more silverpop data to Civi (query names, query criteria, segment data) - https://phabricator.wikimedia.org/T227363 (Eileenmcnaughton) from Brian We login... [20:28:08] Fundraising-Backlog: Edits to the employer field test - https://phabricator.wikimedia.org/T229343 (DStrine) [20:30:01] Fundraising-Backlog: rando spanish page in India flow - https://phabricator.wikimedia.org/T229006 (DStrine) DOD: is this on dlocal side? If so, what would we say back to dlocal to help them identify the issue? [20:30:11] Fundraising-Backlog: Dlocal cancel buttons don't go back to the payments wiki form - https://phabricator.wikimedia.org/T229336 (DStrine) DOD: is this on dlocal side? If so, what would we say back to dlocal to help them identify the issue? [20:30:39] Fundraising-Backlog: Bug: payment form still displays warning that we do not accept over 10K donations - https://phabricator.wikimedia.org/T229932 (DStrine) a:Ejegg [20:31:07] Fundraising-Backlog: Look into CSP changes in core - https://phabricator.wikimedia.org/T229607 (DStrine) a:Ejegg [21:07:25] Fundraising Sprint Princess Mongodb, Fundraising-Backlog: document steps for fr-online to submit TY email to git - https://phabricator.wikimedia.org/T229965 (DStrine) [21:07:27] Fundraising Sprint Princess Mongodb, Fundraising-Backlog, MediaWiki-extensions-CentralNotice: CentralNotice: count impressions and campaigns in 2018 - https://phabricator.wikimedia.org/T229960 (DStrine) [21:07:29] Fundraising Sprint Princess Mongodb, Fundraising-Backlog: Bug: payment form still displays warning that we do not accept over 10K donations - https://phabricator.wikimedia.org/T229932 (DStrine) [21:07:31] Fundraising Sprint Princess Mongodb, Fundraising-Backlog: Look into CSP changes in core - https://phabricator.wikimedia.org/T229607 (DStrine) [21:07:33] Fundraising Sprint Princess Mongodb, Fundraising-Backlog: Edits to the employer field test - https://phabricator.wikimedia.org/T229343 (DStrine) [21:07:35] Fundraising Sprint Princess Mongodb, Fundraising-Backlog: Dlocal cancel buttons don't go back to the payments wiki form - https://phabricator.wikimedia.org/T229336 (DStrine) [21:07:37] Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: Bug: Trigger caused db locks - https://phabricator.wikimedia.org/T229273 (DStrine) [21:07:39] Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Fr-CentralNotice-Caching: PHPUnit tests failing with "Cannot write with role DB_REPLICA" - https://phabricator.wikimedia.org/T229194 (DStrine) [21:07:46] Fundraising Sprint Princess Mongodb, Fundraising-Backlog: rando spanish page in India flow - https://phabricator.wikimedia.org/T229006 (DStrine) [21:07:46] Fundraising Sprint Princess Mongodb, Fundraising-Backlog, FR-Ingenico: Follow up re: Performance of Ingenico MyCheckout hosted pages - https://phabricator.wikimedia.org/T228953 (DStrine) [21:07:48] Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Prepare next civi upgrade - https://phabricator.wikimedia.org/T228826 (DStrine) [21:07:51] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Create batch job wrapping target smart import allowing us to schedule it - https://phabricator.wikimedia.org/T228714 (DStrine) [21:07:53] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, and 2 others: Add missing Prospect fields to our dev environments - https://phabricator.wikimedia.org/T228713 (DStrine) [21:07:56] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Finalise & test field mapping for targetsmart import - https://phabricator.wikimedia.org/T228712 (DStrine) [21:08:00] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, and 3 others: Update our csv import library in drupal - https://phabricator.wikimedia.org/T228711 (DStrine) [21:08:08] Fundraising Sprint Princess Mongodb, Fundraising-Backlog: India bank transfer icons and/or test redesign - https://phabricator.wikimedia.org/T228698 (DStrine) [21:08:13] Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Patch-For-Review: Bug: Qunit tests should not be ignored - https://phabricator.wikimedia.org/T227879 (DStrine) [21:08:18] Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: As a drush user, I want to be able to schedule and limit queue jobs independently - https://phabricator.wikimedia.org/T227805 (DStrine) [21:08:20] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: I want to be able to read a list communication fields in civi - https://phabricator.wikimedia.org/T227498 (DStrine) [21:08:24] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, and 2 others: Update SmashPig recurring processor to handle first payments - https://phabricator.wikimedia.org/T227051 (DStrine) [21:08:26] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Recurring-Donations: Update recurring QC for tokenized subscriptions - https://phabricator.wikimedia.org/T227048 (DStrine) [21:08:29] Fundraising Sprint Men In Slack, Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, and 2 others: CentralNotice: Review incoming patches 2019-06 and 2019-07 - https://phabricator.wikimedia.org/T226655 (DStrine) [21:08:31] Fundraising Sprint Men In Slack, Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog: Andy: estimate old tasks - https://phabricator.wikimedia.org/T226552 (DStrine) [21:08:38] Fundraising Sprint Men In Slack, Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, and 3 others: Review Campaign Fallback - https://phabricator.wikimedia.org/T226344 (DStrine) [21:08:45] Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint Land before Timeouts, Fundraising Sprint Men In Slack, Fundraising Sprint Never Ending Query, and 5 others: CentralNotice banner preview: follow-up improvements - https://phabricator.wikimedia.org/T225101 (DStrine) [21:08:58] Fundraising Sprint A series of unfortunate event handlers, Fundraising Sprint Bert and Ernie's Excellent Adventure, Fundraising Sprint Karma chameleons hide amongst us, Fundraising Sprint King Kong vs. Mozilla, and 20 others: New scripts to ingress data fro... - https://phabricator.wikimedia.org/T195594 [21:09:01] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Investigate: Add more silverpop data to Civi (query names, query criteria, segment data) - https://phabricator.wikimedia.org/T227363 (... [21:09:06] Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Patch-For-Review: Make sure silverpop export does not include endowment donations (except in explicit endowment fields) - https://phabricator.wikimedia.org/T228349 (DStrine) [21:09:09] Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint Land before Timeouts, Fundraising Sprint Men In Slack, Fundraising Sprint Never Ending Query, and 6 others: Implement Ingenico recurring up sell - https://phabricator.wikimedia.org/T216560 (DStrine) [21:09:11] Fundraising Sprint Men In Slack, Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog: Replace MySQL-python with pymysql in fundraising python scripts - https://phabricator.wikimedia.org/T213757 (DStrine) [21:09:16] Fundraising Sprint Men In Slack, Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, and 2 others: All fundraising python scripts should run on python 3 by 2020 - https://phabricator.wikimedia.org/T197805 (DStrine) [21:09:20] Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Land before Timeouts, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Men In Slack, and 13 others: DB schemas (production changes and test DB) and SQL commands to ... - https://phabricator.wikimedia.org/T196564 [21:09:23] Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Land before Timeouts, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Men In Slack, and 13 others: Write a specification for mapping banner/landing page impression... - https://phabricator.wikimedia.org/T196563 [21:09:28] Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Epic: Investigation: Create Preference Center for donors to manage email subscription preferences - https://phabricator.wikimedia.org/T125272 (DStrine) [21:25:56] XenoRyet, cstone I'd usually be jumping off around now but I know we chatted some about deploying upsell before our meeting. [21:26:52] Oh, right. We were trying to deploy earlier, but it looked like that patch that Eileen deployed last night was still set to go out. [21:27:18] are you guys ok to leave pushing that out until tomorrow? I think the code is easy enough but this new last part of pushing up a patch with a one-off sql query to bring forward the recurring next payment date on our first test [21:27:38] makes it a little tricker [21:27:40] If you want to wait, that's fine with me. [21:28:04] With ejegg back tomorow, we'll have more hands around to help as well. [21:28:17] makes sense to me [21:28:22] have a good one fr-tech! [21:28:25] You too [21:43:56] Fundraising Sprint Princess Mongodb, Fundraising-Backlog: Supporting FR-Creative to do more payments wiki work - https://phabricator.wikimedia.org/T228448 (DStrine) a:Ejegg [21:44:56] XenoRyet: can I get you to + 2 this https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/crm/+/528303/ - it's the follow on from yesterday's merge- once deployed I'll get Jeff to reload the triggers [21:45:16] Sure, let me take a look [21:45:34] this is also ready - https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/crm/+/526798/ but might be a bit more head-hurty [21:47:42] Yea, I'll take a look at that second one too, but no promises. [21:50:08] :-) [21:51:01] (PS1) Esanders: build: Update linters [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/528584 [21:51:10] (CR) XenoRyet: [C: +2] Updated triggers [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/528303 (https://phabricator.wikimedia.org/T229273) (owner: Eileen) [22:31:43] (PS2) Eileen: Updated triggers [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/528303 (https://phabricator.wikimedia.org/T229273) [23:08:38] (PS1) Eileen: Updated triggers [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/528594 (https://phabricator.wikimedia.org/T229273) [23:09:59] (CR) Eileen: [C: +2] Updated triggers [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/528594 (https://phabricator.wikimedia.org/T229273) (owner: Eileen) [23:10:38] (Merged) jenkins-bot: Updated triggers [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/528594 (https://phabricator.wikimedia.org/T229273) (owner: Eileen) [23:12:34] !log civicrm revision changed from 2e03f9bb1e to 727a2c193b, config revision is 84b785d41c [23:12:40] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [23:15:37] Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: Bug: Trigger caused db locks - https://phabricator.wikimedia.org/T229273 (Eileenmcnaughton) @Jgreen we have made a minor update to the triggers but I need you t...