[00:20:36] (PS2) Cstone: WIP: Update thank you emails for 2021. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/673588 [00:36:57] (PS1) Eileen: Update triggers for contribution table to exclude one more giver [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/674460 [00:38:43] (PS2) Eileen: Update triggers for contribution table to exclude one more giver [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/674460 [00:43:50] ejegg: cstone ^^ is trivial but if I get it merged I can organise for Dallas to run [00:44:35] (CR) Cstone: [C: +2] Update triggers for contribution table to exclude one more giver [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/674460 (owner: Eileen) [00:44:41] sure eileen [01:01:05] (Merged) jenkins-bot: Update triggers for contribution table to exclude one more giver [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/674460 (owner: Eileen) [01:14:18] (PS3) Cstone: WIP: Update thank you emails for 2021. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/673588 [01:24:39] thanks cstone [01:30:34] (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/674464 [01:30:46] (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/674464 (owner: Eileen) [01:36:06] !log civicrm revision changed from f36a0b08f0 to ad430721f6, config revision is 26b02db7ba [01:36:15] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [01:38:06] Fundraising Sprint Downed power line jump rope, Fundraising Sprint Esperantoland, Fundraising Sprint File Systems Stage Show, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Benevity Import Error - https://phabricator.wikimedia.org/T271416 (Eileenmcnaughton) @Dwisehaupt can you please loa... [01:41:18] Fundraising Sprint Downed power line jump rope, Fundraising Sprint Esperantoland, Fundraising Sprint File Systems Stage Show, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Benevity Import Error - https://phabricator.wikimedia.org/T271416 (Eileenmcnaughton) @RLewis I've made one change &... [01:42:17] Fundraising Sprint File Systems Stage Show, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Issue with New Field in Individual Engage Import File - https://phabricator.wikimedia.org/T275442 (Eileenmcnaughton) @MDemosWMF perhaps your csv editor just keeps re-adding it? In any case I've deployed a... [02:31:23] (PS1) Ejegg: Fall back to invoice ID to find refund parent [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/674470 (https://phabricator.wikimedia.org/T277244) [02:32:45] (PS2) Ejegg: Fall back to invoice ID to find refund parent [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/674470 (https://phabricator.wikimedia.org/T277244) [03:16:01] Fundraising Sprint File Systems Stage Show, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Creating New Fidelity File Civi Import - https://phabricator.wikimedia.org/T275445 (Eileenmcnaughton) @MDemosWMF when I look at that file there is quite a bit of variation in what is in the Addressee Name... [03:28:59] (PS4) Cstone: Update thank you emails for 2021. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/673588 [03:29:34] cstone: are those ready for review? [03:29:43] to put on staging yeah [03:33:19] cstone: ah - you will get Camille to review? [03:33:27] yeah I'm gona have her look at it [03:35:37] Fundraising Sprint File Systems Stage Show, Fundraising-Backlog, Patch-For-Review: Coding HTML emails - https://phabricator.wikimedia.org/T277779 (Cstone) @CDenes_WMF These are on staging. I did notice the footer in Chinese still has the SF address. [10:37:41] Fundraising Sprint File Systems Stage Show, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Key Relationships not showing for a record that has a relationship - https://phabricator.wikimedia.org/T276592 (RLewis) @Eileenmcnaughton got it, thanks [16:08:09] Fundraising Sprint File Systems Stage Show, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Issue with New Field in Individual Engage Import File - https://phabricator.wikimedia.org/T275442 (MDemosWMF) Thanks @Eileenmcnaughton - I just tried it again and still no Partner field info importing to... [16:12:54] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-CiviCRM-Searchkit: Search kit tool notes - contribution search - https://phabricator.wikimedia.org/T275707 (MDemosWMF) Noting that this seems to be solved with the two queries @Eileenmcnaughton created for Engage reconciliation and Batch contribu... [16:32:14] Fundraising-Backlog, FR-US, fr-donorservices: Correct US state alphabetization on donation form - https://phabricator.wikimedia.org/T266614 (DStrine) [16:45:22] Fundraising-Backlog, FR-UK, Thank-You-Page: Thankyou page link invalid for UK donors - https://phabricator.wikimedia.org/T276928 (DStrine) [16:46:24] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-UK: Improve security of UKFC data transfers - https://phabricator.wikimedia.org/T124315 (DStrine) [16:46:49] Fundraising-Backlog, FR-UK: UKFC Payment investigation - https://phabricator.wikimedia.org/T125887 (DStrine) [16:47:14] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-UK: UKFC as Payment Instrument option for foreign check import - https://phabricator.wikimedia.org/T167355 (DStrine) [16:49:01] Fundraising Sprint X-rays, Fundraising-Backlog, FR-France: Updated Subject Lines: French, Dutch, Norwegian - https://phabricator.wikimedia.org/T239215 (DStrine) [16:49:22] Fundraising Sprint They Live, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising-Backlog, FR-France, MediaWiki-extensions-CentralNotice: Delay in French mobile banners showing up in Banner Allocation - https://phabricator.wikimedia.org/T206562 (DStrine) [16:51:18] Fundraising-Backlog, FR-Japan, fr-donorservices: Japanese donation form reverts to English language - https://phabricator.wikimedia.org/T273938 (DStrine) [16:51:25] Fundraising-Backlog, FR-Japan: Japanese last name, first name ordering issues - https://phabricator.wikimedia.org/T261144 (DStrine) [16:51:50] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Japan: clean up name order for Japanese donors in the civi database - https://phabricator.wikimedia.org/T264338 (DStrine) [16:52:52] Fundraising-Backlog, Wikimedia-Fundraising-Banners, FR-Japan, donate.wikimedia.org, fr-donorservices: Investigate Japanese unintended recurring donations - https://phabricator.wikimedia.org/T262361 (DStrine) [16:58:14] Fundraising-Backlog, FR-Italy: CPS report of high donation volume in IT - https://phabricator.wikimedia.org/T189697 (DStrine) [17:00:33] Fundraising Sprint File Systems Stage Show, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Creating New Fidelity File Civi Import - https://phabricator.wikimedia.org/T275445 (MDemosWMF) @Eileenmcnaughton I see what you mean. Unfortunately we get the file directly from Fidelity, so I'm not sure t... [17:07:48] Fundraising-Backlog, FR-Ingenico, FR-Netherlands: Fix alphabetization of list of iDEAL banks on NL form - https://phabricator.wikimedia.org/T162613 (DStrine) [17:08:35] Fundraising-Backlog, FR-Ingenico, FR-Netherlands: Add explanatory text to NL form when Ideal is down - https://phabricator.wikimedia.org/T132372 (DStrine) Open→Declined [17:09:15] Fundraising-Backlog, FR-Netherlands: High Unique Clicks for nlNL RML program - https://phabricator.wikimedia.org/T259189 (DStrine) [17:10:07] Fundraising Sprint Judgement Suspenders, Fundraising Sprint Kickstopper, Fundraising Sprint Loose Lego Carpeting, Fundraising-Backlog, and 2 others: Spike: Investigate cause of large banner impression surge in NL and ES fr campaigns - https://phabricator.wikimedia.org/T164996 (DStrine) [17:11:24] Fundraising Sprint Downed power line jump rope, Fundraising Sprint Esperantoland, Fundraising Sprint File Systems Stage Show, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Benevity Import Error - https://phabricator.wikimedia.org/T271416 (Dwisehaupt) @Eileenmcnaughton I have applied the... [17:12:28] Fundraising-Backlog, FR-Sweden, fr-donorservices, Patch-For-Review: Fix email address autosuggest for valid SE email addresses & improve wording - https://phabricator.wikimedia.org/T221387 (DStrine) [17:20:05] Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint Window dressing is mostly olive oil, Fundraising-Backlog, FR-LATAM, and 3 others: Switch PE and UY to dlocal for processing - https://phabricator.wikimedia.org/T208963 (DStrine) [17:21:19] Fundraising-Backlog, FR-LATAM: DLOCAL forms for Uruguay and Peru - https://phabricator.wikimedia.org/T274578 (DStrine) [17:27:56] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-BigBundle, FR-Civi-Dedupe: Domain task - script fix to bulk update emails from Belgium - https://phabricator.wikimedia.org/T250320 (DStrine) [17:28:26] Fundraising Sprint X-rays, Fundraising-Backlog, FR-BigBundle, FR-France: Updated Subject Lines: French, Dutch, Norwegian - https://phabricator.wikimedia.org/T239215 (DStrine) [17:28:51] Fundraising-Backlog, FR-BigBundle: Enabling Offline BT for Poland (and Other countries) - https://phabricator.wikimedia.org/T127715 (DStrine) [17:29:28] Fundraising-Backlog, FR-BigBundle, FR-LATAM: Brazil TY page in English and not Portuguese - https://phabricator.wikimedia.org/T275576 (DStrine) [17:33:59] (PS6) Ejegg: Add settings and logos for two UY-specific cards [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/472503 (https://phabricator.wikimedia.org/T208963) [17:36:20] Fundraising-Backlog, FR-EN6C, FR-UK, Thank-You-Page: Thankyou page link invalid for UK donors - https://phabricator.wikimedia.org/T276928 (DStrine) [17:36:29] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-EN6C, FR-UK: Improve security of UKFC data transfers - https://phabricator.wikimedia.org/T124315 (DStrine) [17:36:32] Fundraising-Backlog, FR-EN6C, FR-UK: UKFC Payment investigation - https://phabricator.wikimedia.org/T125887 (DStrine) [17:36:34] Fundraising-Backlog, FR-EN6C, FR-US, fr-donorservices: Correct US state alphabetization on donation form - https://phabricator.wikimedia.org/T266614 (DStrine) [17:36:36] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-EN6C, FR-UK: UKFC as Payment Instrument option for foreign check import - https://phabricator.wikimedia.org/T167355 (DStrine) [18:00:13] (PS1) Cdenes: new TY emails in 17 languages plus their corresponding subject line files [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/674649 [18:02:28] Fundraising Sprint File Systems Stage Show, Fundraising-Backlog, Patch-For-Review: Coding HTML emails - https://phabricator.wikimedia.org/T277779 (CDenes_WMF) Thanks Christine. Any edits to the footer text I would defer to @spatton or @TSkaff on. [18:04:28] Fundraising-Backlog: Production of New Annual Fund Thank You Email (due to ED transition) - https://phabricator.wikimedia.org/T278363 (CDenes_WMF) [18:05:21] Fundraising-Backlog: Production of New Annual Fund Thank You Email (due to ED transition) - https://phabricator.wikimedia.org/T278363 (CDenes_WMF) [18:08:37] Fundraising Sprint File Systems Stage Show, Fundraising-Backlog: Production of New Annual Fund Thank You Email (due to ED transition) - https://phabricator.wikimedia.org/T278363 (DStrine) [18:12:27] Fundraising Sprint File Systems Stage Show, Fundraising-Backlog: Production of New Annual Fund Thank You Email (due to ED transition) - https://phabricator.wikimedia.org/T278363 (DStrine) a:Cstone [18:15:44] Fundraising Sprint File Systems Stage Show, Fundraising-Backlog, FR-AutoTY-Email, Patch-For-Review: Coding HTML emails - https://phabricator.wikimedia.org/T277779 (TSkaff) [18:34:37] fundraising-tech-ops: Adjust postfix to do graceful restarts when possible - https://phabricator.wikimedia.org/T267698 (Dwisehaupt) Open→Resolved a:Dwisehaupt Pushed change out to support reload: ` [frack::puppet] 8c3f4b64 Add reload function to postfix service ` [19:06:41] Fundraising Sprint Downed power line jump rope, Fundraising Sprint Esperantoland, Fundraising Sprint File Systems Stage Show, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Benevity Import Error - https://phabricator.wikimedia.org/T271416 (Eileenmcnaughton) @Dwisehaupt yeah that seems OK [20:05:10] Fundraising-Backlog, FR-LATAM: DLOCAL forms for Uruguay and Peru - https://phabricator.wikimedia.org/T274578 (Ejegg) For the DLocal forms, should we allow ALL the payment methods that are supported in each country, filtered as usual by card/bank transfer/cash? Or just a subset? Peru: VI Visa Credit C... [20:07:09] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: cannot exclude members for groups on classic civi reports - https://phabricator.wikimedia.org/T278384 (DStrine) [21:21:06] Fundraising-Backlog: Paypal Payflow IP changes - https://phabricator.wikimedia.org/T278388 (EMartin) [22:17:56] Fundraising-Backlog, FR-LATAM: DLOCAL forms for Uruguay and Peru - https://phabricator.wikimedia.org/T274578 (EMartin) Here are the payment types Dlocal can support: Peru: VI Visa Credit Card MC Mastercard Credit Card AE American Express Credit Card VD Visa Debit Debit Card EF Pago Efectivo Cash Payment... [23:19:46] Fundraising-Backlog, fundraising-tech-ops: Fix duplicate entries in pgehres tables so we can convert them to utf8mb4 - https://phabricator.wikimedia.org/T277484 (Dwisehaupt) I have pulled the dumps of these tables into a sheet for easy viewing and thought processing: https://docs.google.com/spreadsheets...