[00:10:25] (PS1) Eileen: Submodule update CiviCRM [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549229 [00:10:36] (CR) Eileen: [C: +2] Submodule update CiviCRM [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549229 (owner: Eileen) [00:11:30] (CR) jerkins-bot: [V: -1] Submodule update CiviCRM [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549229 (owner: Eileen) [00:11:59] (CR) Eileen: [C: +2] "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549229 (owner: Eileen) [00:14:47] Fundraising Sprint Usual Subscripts, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Automatic DAF thank you email - https://phabricator.wikimedia.org/T233374 (Cstone) @LeanneS This is live on production. It applies to both the batch entry page and th... [00:27:08] (PS1) Eileen: Change return to mixed - it would 'almost always' be a string but it could be an int too I think - not sure if it could ever be an array. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549230 [00:27:10] (PS1) Eileen: Another EA-triggered change - change order for performance. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549231 [00:27:12] (PS1) Eileen: Use lower-case 'contact' in my test [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549232 [00:27:14] (PS1) Eileen: Comment fix as pointed out by Jack [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549233 [00:27:16] (PS1) Eileen: Introduce the concept or preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 [00:32:59] (CR) jerkins-bot: [V: -1] Introduce the concept or preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 (owner: Eileen) [00:33:21] (CR) jerkins-bot: [V: -1] Use lower-case 'contact' in my test [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549232 (owner: Eileen) [00:33:26] (CR) jerkins-bot: [V: -1] Comment fix as pointed out by Jack [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549233 (owner: Eileen) [00:38:49] (PS2) Eileen: Introduce the concept or preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 [00:38:54] (Abandoned) Eileen: Comment fix as identified by Jack [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549171 (owner: Eileen) [00:40:08] (PS2) Eileen: Use lower-case 'contact' in my test [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549232 [00:40:57] (PS3) Eileen: Introduce the concept or preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 [00:43:10] (PS2) Eileen: Comment fix as pointed out by Jack [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549233 [00:44:25] (CR) Cstone: "I missed the original_gross in the test too, it should be looking for 3.00 instead of 6.00" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549209 (https://phabricator.wikimedia.org/T235105) (owner: Ejegg) [00:46:49] (CR) jerkins-bot: [V: -1] Introduce the concept or preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 (owner: Eileen) [01:07:50] (PS4) Eileen: Introduce the concept or preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 (https://phabricator.wikimedia.org/T232037) [01:09:22] (PS6) Eileen: Fix payment method update fn to add account relationship [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/548823 (https://phabricator.wikimedia.org/T235212) (owner: Ejegg) [01:11:11] (CR) jerkins-bot: [V: -1] Fix payment method update fn to add account relationship [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/548823 (https://phabricator.wikimedia.org/T235212) (owner: Ejegg) [01:13:44] (CR) jerkins-bot: [V: -1] Introduce the concept or preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 (https://phabricator.wikimedia.org/T232037) (owner: Eileen) [01:24:00] (PS5) Eileen: Introduce the concept or preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 (https://phabricator.wikimedia.org/T232037) [01:30:09] (CR) jerkins-bot: [V: -1] Introduce the concept or preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 (https://phabricator.wikimedia.org/T232037) (owner: Eileen) [01:40:13] PROBLEM - check_mysql on frdev1001 is CRITICAL: Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2 No such file or directory) [01:44:57] ACKNOWLEDGEMENT - check_mysql on frdev1001 is CRITICAL: Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2 No such file or directory) Dwisehaupt mysql down for reclone to frdb1001 [02:21:19] (PS6) Eileen: Introduce the concept or preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 (https://phabricator.wikimedia.org/T232037) [02:29:39] (PS1) Eileen: Add debug to try to understand test fail on ejegg's patch [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549239 [02:31:19] (PS7) Eileen: Introduce the concept of preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 (https://phabricator.wikimedia.org/T232037) [02:31:32] (CR) jerkins-bot: [V: -1] Add debug to try to understand test fail on ejegg's patch [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549239 (owner: Eileen) [02:38:05] (PS1) Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/549240 [02:42:58] (PS2) Eileen: Fix issue when ejegg's patch runs on a new install. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549239 [02:44:16] (CR) Eileen: [C: +2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/549240 (owner: Eileen) [02:46:26] (CR) Eileen: "I think this will fix the failing error - https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/crm/+/549239/" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/548823 (https://phabricator.wikimedia.org/T235212) (owner: Ejegg) [06:20:13] RECOVERY - check_mysql on frdev1001 is OK: Uptime: 350 Threads: 2 Questions: 155590 Slow queries: 11 Opens: 130 Flush tables: 1 Open tables: 122 Queries per second avg: 444.542 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [14:11:48] (CR) Jgleeson: [C: +2] Change return to mixed - it would 'almost always' be a string but it could be an int too I think - not sure if it could ever be an array. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549230 (owner: Eileen) [14:17:12] (Merged) jenkins-bot: Change return to mixed - it would 'almost always' be a string but it could be an int too I think - not sure if it could ever be an array. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549230 (owner: Eileen) [14:48:02] Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog: Need to reset password for user silverpop-upload@wikimedia.org in IBM - https://phabricator.wikimedia.org/T237100 (KHaggard) Thanks, Ejegg ! I checked again and the password expiration countdown banner has gone away for this user 😄 So I think... [15:54:07] Fundraising-Backlog, fundraising-tech-ops, DC-Ops: frdb1001 has suffered a raid event resulting in /dev/sda going read only - https://phabricator.wikimedia.org/T236739 (Jgreen) [15:59:11] fundraising-tech-ops: investigate remote logging or polling of iDRAC and ILO for hardware issues - https://phabricator.wikimedia.org/T237648 (Jgreen) p:Triage→Normal [16:04:16] Fundraising-Backlog, fundraising-tech-ops, DC-Ops: frdb1001 has suffered a raid event resulting in /dev/sda going read only - https://phabricator.wikimedia.org/T236739 (Jgreen) a:Jclark-ctr→Dwisehaupt Reassigning to @dwisehaupt since he's done the heavy lifting on the reimage/recommissions. [16:07:19] fundraising-tech-ops: investigate remote logging or polling of iDRAC and ILO for hardware issues - https://phabricator.wikimedia.org/T237648 (Jgreen) Note an enterprise license is required for iDRAC, afaict this was included in recent server orders. [16:33:53] Fundraising-Backlog, fundraising-tech-ops, DC-Ops: frdb1001 has suffered a raid event resulting in /dev/sda going read only - https://phabricator.wikimedia.org/T236739 (Dwisehaupt) Database was recloned with the bulk of the data coming from the dev host and the few remaining tables coming from frdb20... [17:49:32] Fundraising-Backlog, Recurring-Donations: recurring: Retry by country and by time of day - https://phabricator.wikimedia.org/T237653 (DStrine) [17:51:07] Fundraising-Backlog, Recurring-Donations: Recurring: Apply retry logic by decline reason. - https://phabricator.wikimedia.org/T237654 (DStrine) [17:52:18] (CR) Jgleeson: [C: +2] Another EA-triggered change - change order for performance. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549231 (owner: Eileen) [17:52:23] Fundraising-Backlog, Recurring-Donations: Recurring: Optimize retry logic. - https://phabricator.wikimedia.org/T237655 (DStrine) [17:52:51] (CR) Jgleeson: [C: +2] Use lower-case 'contact' in my test [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549232 (owner: Eileen) [17:53:04] (CR) Jgleeson: [C: +2] Comment fix as pointed out by Jack [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549233 (owner: Eileen) [17:53:47] Fundraising-Backlog, Recurring-Donations: Recurring: Extend retry window. - https://phabricator.wikimedia.org/T237656 (DStrine) [17:56:20] Fundraising-Backlog, Recurring-Donations: EPIC: MVP for reporting on recurring donations - https://phabricator.wikimedia.org/T237657 (DStrine) [17:56:50] Fundraising-Backlog, Recurring-Donations: EPIC: MVP for reporting on recurring donations - https://phabricator.wikimedia.org/T237657 (DStrine) [17:58:09] (Merged) jenkins-bot: Another EA-triggered change - change order for performance. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549231 (owner: Eileen) [17:58:11] (Merged) jenkins-bot: Use lower-case 'contact' in my test [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549232 (owner: Eileen) [17:58:50] (Merged) jenkins-bot: Comment fix as pointed out by Jack [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549233 (owner: Eileen) [17:58:53] Fundraising Sprint Usual Subscripts, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, FR-Civi-Dedupe: Middle name and initial appearing in first or last name fields causing lots of manual dedupe - https://phabricator.wikimedia.org/T230954 (jgleeson) Looks like all the patches linked... [17:59:00] Fundraising-Backlog, Recurring-Donations: recurring:MVP reporting, Investigate declines by reason code. - https://phabricator.wikimedia.org/T237658 (DStrine) [18:00:24] fr-tech are we planning to push standup out 30mins in response to the extended monthly meeting? [18:01:13] Fundraising-Backlog, Recurring-Donations: Recurring: MVP reporting, Monitor true auth rate - https://phabricator.wikimedia.org/T237659 (DStrine) [18:02:58] Fundraising-Backlog, Recurring-Donations: recurring: MVP for reporting, Success by auth attempt. - https://phabricator.wikimedia.org/T237660 (DStrine) [18:04:27] Fundraising-Backlog, Recurring-Donations: Recurring: MVP for reporting, Declines by attempt. - https://phabricator.wikimedia.org/T237662 (DStrine) [18:07:15] Fundraising-Backlog, Recurring-Donations: Epic: recurring ideal feature (post mvp) - https://phabricator.wikimedia.org/T237663 (DStrine) [18:09:54] Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog: Add elements to monthly convert thank you email - https://phabricator.wikimedia.org/T237578 (DStrine) [18:10:03] jgleeson: Yea, that was the idea [18:10:53] If that gets too late for you, feel free to do an email standup or something along those lines. I know it's getting pretty late in your day. [18:31:21] hmm looks like it ended on time? [18:31:31] Yea, that was a pretty quick video cut [18:31:47] "We're at time"/ends [18:55:36] fr-tech so it looks like the existing 'Sent year-end summary receipt' just records the activity entry in civicrm and doesn't send the actual email [18:55:48] looks like it's a manual logging event post the email send happening else where [18:55:56] MBeat: does the above sound correct? [18:59:36] not sure jgleeson I will look into T237578 after next meeting [18:59:37] T237578: Add elements to monthly convert thank you email - https://phabricator.wikimedia.org/T237578 [18:59:57] thanks MBeat [19:10:45] (PS1) Eileen: Add checkPermission to the cache key [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/549598 [19:29:23] Fundraising Sprint Usual Subscripts, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, FR-Civi-Dedupe: Middle name and initial appearing in first or last name fields causing lots of manual dedupe - https://phabricator.wikimedia.org/T230954 (Eileenmcnaughton) I think there are still a... [19:40:29] (PS1) Eileen: Fix merge script to resolve opt in custom field on most recent donor. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549614 (https://phabricator.wikimedia.org/T232037) [19:41:03] ok I have the patch for handling 'opt in' on merges working pending feedback from jenkins [19:41:41] (Abandoned) Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/549240 (owner: Eileen) [19:44:31] hey eileen :) can you tell me where i can find the button 'Send Receipt? Automatically email a receipt for this payment to (donor)' mentioned in the desc of this ticket [19:44:35] https://phabricator.wikimedia.org/T221271 [19:45:09] I think they mean on the contribution edit screen? [19:45:42] but the easiest might be like the fishing net one - let me find it [19:46:25] (CR) jerkins-bot: [V: -1] Fix merge script to resolve opt in custom field on most recent donor. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549614 (https://phabricator.wikimedia.org/T232037) (owner: Eileen) [19:47:57] jgleeson: if you search for dedupetools_civicrm_summaryActions you will find the code that adds to this drop down https://usercontent.irccloud-cdn.com/file/ECBibuQd/Screen%20Shot%202019-11-08%20at%208.47.34%20AM.png [19:48:44] since it's a 'contact wide' action I think that makes sense. You can also add to search actions but I'm not sure they do it on sets [19:48:55] (PS1) Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/549617 [19:49:11] ooo thanks eileen I'll add that to my etherpad notes on the task [19:49:39] ejegg|away: mentioned also checking out your email extender patch for an idea of how to proceed with adding a new button/action [19:49:44] (CR) Eileen: [C: +2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/549617 (owner: Eileen) [19:50:17] jgleeson: can you +2 this - it's super simple but probably causing my other test to fail https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/crm/civicrm/+/549598/ [19:50:28] also upstream https://github.com/civicrm/civicrm-core/pull/15761 [19:50:42] sure I'll take a look [19:52:46] (CR) Jgleeson: [C: +2] Add checkPermission to the cache key [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/549598 (owner: Eileen) [19:53:13] I like the patch submissions structure of the upstream pull request [19:53:36] yeah - github has templates which is nice & the webUI for PRs is really usable [19:53:42] one of my OKR points is to work on standardising code review so I might borrow that! :) [19:54:07] I wish we could put screenshots in gerrit [19:54:29] actually it's gonna be a team effort where we all collaborate on that and come up with a structure. +1 to screenshots on gerrit! [19:54:38] although we could link to phab from it maybe [19:54:59] yeah - gotta work with the tools we have... [19:55:37] jgleeson: I’m a bit out of my depth on T237578 re: “manual logging event post the email send happening else where” is there something I can look into about how that email will work? [19:55:37] T237578: Add elements to monthly convert thank you email - https://phabricator.wikimedia.org/T237578 [19:55:41] we could possibly build more of a template via git commit hooks - if you commit direct from phpstorm it has teemplates [19:56:57] dwisehaupt: have we turned deduping back on now we have a shiny new db server? [19:57:33] MBeat: sorry! let explain my question more clearly with some context [19:58:09] (Merged) jenkins-bot: Add checkPermission to the cache key [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/549598 (owner: Eileen) [19:58:52] so.. I'm working on this ticket https://phabricator.wikimedia.org/T221271 which relates to sending the annual summary email based on an event triggered (button click) from within civicrm [19:59:20] (PS1) Eileen: Submodule commit [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549621 [19:59:58] and while browsing around CiviCRM I came across the ' Sent year-end summary receipt' link under Actions within a contact [20:00:12] so I was curious whether that did some of what we want already [20:00:40] but after playing around with that, I realised it looks more time log stamp action (recording something has happened) and not actually doing the thing [20:00:48] MBeat: heads up that I'm deploying a script to stop two people or processes trying to dedupe the contact at the same time. We haven' done much on the error handling so it might error in ugly ways - probably on the deduper it will look like a hang (but it's better than the data issues that were happening on a dedupe clash before) [20:01:08] ty jgleeson & eileen [20:01:18] (CR) Eileen: [C: +2] Submodule commit [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549621 (owner: Eileen) [20:02:22] (CR) Eileen: [C: +2] "recheck" [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/549617 (owner: Eileen) [20:02:36] (CR) Eileen: [C: +2] "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549621 (owner: Eileen) [20:02:42] so my guess is at the moment DS manually sends the annual summary emails and then you log a record of that manual process via the 'Sent year-end summary receipt' action [20:02:48] zuul is a slacker [20:02:53] does that sound about right MBeat ? [20:03:00] lol eileen [20:04:20] yes, jgleeson that Action:Send option is outside the DS workflow. The annual summaries that we do send manually from Gmail we don’t even track in Civi, we just send ‘em [20:04:53] i think MG are the ones who use that Action option if anyine [20:04:55] *anyone [20:05:01] ahhh got it [20:05:35] jgleeson: any activities show up in the 'actions' - so it might just be an activity the script creates after sending [20:06:04] would that location, under the contact Actions, be a good place to put the new 'Send annual summary ty email' button? [20:06:06] (we can change which ones show with the is_filter value on civicrm_option_value - which we maybe should if it is script driven -) [20:06:47] (CR) Eileen: "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549614 (https://phabricator.wikimedia.org/T232037) (owner: Eileen) [20:06:55] eileen: that makes sense [20:07:03] we automate the stamp if you like, after the send [20:07:44] I'll gonna take a run at it tomorrow and I'll put up where I to for you to look over when you next week begins :0 [20:07:49] :) * [20:08:12] s/where I to/where I get to/ [20:08:26] !log civicrm revision changed from f1ce5c86f7 to bfa53ee611, config revision is 72d2692743 [20:08:30] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [20:08:50] MBeat: I'm just gonna test a few dedupes with that deploy I just did but it should mean quite a lot more resolve in safe mode [20:09:01] great, thank you [20:09:27] that's me. have good rest of your day all! o/ [20:10:01] also - the modified_dates works now - so you can do this [20:10:13] https://usercontent.irccloud-cdn.com/file/olrEcgDo/Screen%20Shot%202019-11-08%20at%209.09.55%20AM.png [20:25:47] (PS8) Eileen: Introduce the concept of preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 (https://phabricator.wikimedia.org/T232037) [20:25:49] (PS2) Eileen: Fix merge script to resolve opt in custom field on most recent donor. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549614 (https://phabricator.wikimedia.org/T232037) [20:33:25] (PS3) XenoRyet: Clear payment submethod radios on validation fail [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/545955 (https://phabricator.wikimedia.org/T235126) [20:33:51] cstone: ^ Wanna give that one a try for me? [20:38:13] XenoRyet: I just ran out to get lunch and did not bring the mac, but I will when i get back [20:38:39] Cool, no worries [20:38:45] Didn't mean to interrupt lunch [20:38:51] haha you didn't [20:39:13] I should have thought to bring the mac with me [20:53:47] (PS9) Eileen: Introduce the concept of preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 (https://phabricator.wikimedia.org/T232037) [20:53:49] (PS3) Eileen: Fix merge script to resolve opt in custom field on most recent donor. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549614 (https://phabricator.wikimedia.org/T232037) [20:53:51] (PS1) Eileen: Resolve initials where there is punctuation in the middle_name but middle_name is not conflicted [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549630 [20:59:31] (CR) jerkins-bot: [V: -1] Fix merge script to resolve opt in custom field on most recent donor. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549614 (https://phabricator.wikimedia.org/T232037) (owner: Eileen) [20:59:36] (CR) jerkins-bot: [V: -1] Introduce the concept of preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 (https://phabricator.wikimedia.org/T232037) (owner: Eileen) [20:59:46] (CR) jerkins-bot: [V: -1] Resolve initials where there is punctuation in the middle_name but middle_name is not conflicted [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549630 (owner: Eileen) [21:05:13] MBeat: I spotted a few cases where donors have given their names as 'first' & 'last' (or in one case 'blah') but the contact has donated on other occassions with their real name. I have a feeling we should treat 'first', 'last' or 'blah' (perhaps there are others) as 'empty' - ie. they would be overwritten rather than be a conflict [21:06:49] yes, that makes sense eileen I always imagine them getting a fundraising email a year later saying ‘Dear first’ and going d’oh! [21:06:56] :-) [21:07:14] are there any other obvious ones? (We can also add to the list later) [21:35:39] (PS10) Eileen: Introduce the concept of preferred contact, add ability to specify fields to be resolved that way. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549234 (https://phabricator.wikimedia.org/T232037) [21:35:41] (PS4) Eileen: Fix merge script to resolve opt in custom field on most recent donor. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549614 (https://phabricator.wikimedia.org/T232037) [21:35:43] (PS1) Eileen: Resolve initials where there is punctuation in the middle_name but middle_name is not conflicted [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549639 [21:35:45] (PS1) Eileen: Add silly name resolver. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549640 [21:37:21] cid=36037795 may be a different use case (lmk if it merits its own Phab?) but they got 15 digits of card # in the first name field (still visible in change log), eileen [21:38:11] could treat all #s as empty? [21:39:20] (Abandoned) Eileen: Resolve initials where there is punctuation in the middle_name but middle_name is not conflicted [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549630 (owner: Eileen) [21:42:46] (CR) jerkins-bot: [V: -1] Add silly name resolver. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549640 (owner: Eileen) [21:52:27] MBeat: for automatic deduping we do treat numbers as 'not names' - the deduper script is still off - I need to find out if it can go back on - maybe mepps knows? [21:52:50] great, ty for update [21:53:26] Pretty sure it can go back on right dwisehaupt Jeff_Green [21:53:29] ? [21:53:41] MBeat: I'm also seeing conflicts on Opt In - I have a patch up for review on that now [21:53:54] thank you [21:56:04] (PS1) Eileen: Fix oddness of middle name (this is why it shows as a link unlike the others) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549644 [21:56:20] (PS3) Eileen: Brain dump of where I see things going in future [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/547712 [21:57:33] mepps: we haven't repooled frdb1001 yet pending reclone sanity checks, let me check in with dwisehaupt about it [22:02:06] (CR) jerkins-bot: [V: -1] Fix oddness of middle name (this is why it shows as a link unlike the others) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549644 (owner: Eileen) [22:02:29] (PS2) Eileen: Fix oddness of middle name (this is why it shows as a link unlike the others) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549644 [22:03:18] (PS2) Eileen: Add silly name resolver. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549640 [22:03:35] (PS4) XenoRyet: Clear payment submethod radios on validation fail [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/545955 (https://phabricator.wikimedia.org/T235126) [22:14:13] (CR) Cstone: [C: +2] "Looks good, Clearing on both Safari and Chrome." [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/545955 (https://phabricator.wikimedia.org/T235126) (owner: XenoRyet) [22:27:58] (Merged) jenkins-bot: Clear payment submethod radios on validation fail [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/545955 (https://phabricator.wikimedia.org/T235126) (owner: XenoRyet) [22:31:10] (PS1) XenoRyet: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/549657 [22:37:38] (CR) XenoRyet: [C: +2] Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/549657 (owner: XenoRyet) [22:38:12] (Merged) jenkins-bot: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/549657 (owner: XenoRyet) [22:41:52] (PS1) XenoRyet: Update DonationInterface submodule [core] (fundraising/REL1_31) - https://gerrit.wikimedia.org/r/549658 [22:42:20] (CR) jerkins-bot: [V: -1] Update DonationInterface submodule [core] (fundraising/REL1_31) - https://gerrit.wikimedia.org/r/549658 (owner: XenoRyet) [22:42:43] (Abandoned) XenoRyet: Update DonationInterface submodule [core] (fundraising/REL1_31) - https://gerrit.wikimedia.org/r/549658 (owner: XenoRyet) [22:44:59] (PS1) XenoRyet: Update DonationInterface submodule [core] (fundraising/REL1_31) - https://gerrit.wikimedia.org/r/549659 [22:51:33] (CR) XenoRyet: [C: +2] Update DonationInterface submodule [core] (fundraising/REL1_31) - https://gerrit.wikimedia.org/r/549659 (owner: XenoRyet) [22:56:01] mepps / eileen: the frdb1001 clone hit a snag and we're not confident in the data, we need to reclone it [22:56:07] (Merged) jenkins-bot: Update DonationInterface submodule [core] (fundraising/REL1_31) - https://gerrit.wikimedia.org/r/549659 (owner: XenoRyet) [22:56:38] we're looking at a different approach, using percona xtrabackup and frdb2001 instead of frdev, so we don't have to take frdev offline to do it [22:57:23] Jeff_Green: what does this mean for campaigns or current contributions? [22:57:43] Anything we should know about the snag? [22:58:08] status quo, we still have frdev and frdb2001 in the mix [22:58:17] K thanks! [22:59:53] the snag, we tried to clone frdev1001 and add databases that it is missing, and for some reason innodb/mariadb isn't properly recognizing the those additional databases we restored [23:00:51] !log updated payments-wiki from aac3d93f70 to bd907656fb [23:00:54] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [23:01:01] we're looking at doing a full dump/restore from frdb2001 instead [23:04:48] whenever gmail decides to stop sorting my mail and let me access it, I'll reply on the frdb1001 thread [23:20:39] email update sent for Jeff_Green since he had to run. [23:22:24] Wikimedia-Fundraising-Banners: RML popup remains from large fr-banner after scrolling down and switching to nag - https://phabricator.wikimedia.org/T237699 (jbolorinos-ctr)