Page MenuHomePhabricator

Eileenmcnaughton (eileen)
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Monday

  • Clear sailing ahead.

User Details

User Since
Sep 15 2015, 12:37 AM (266 w, 4 d)
Availability
Available
LDAP User
Eileen
MediaWiki User
Eileenmcnaughton [ Global Accounts ]

Recent Activity

Thu, Oct 22

Eileenmcnaughton added a comment to T265369: New engage endowment import.

@RLewis OK - the import will pick up the value in the Contribution Type column once the fix deployed - so if that can handle a mix in one file

Thu, Oct 22, 8:01 PM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

@bsisolak yes - those 2 - our db is still tracking them - obviously they were 'processing' until very recently

Thu, Oct 22, 5:22 AM · Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

Why would they be 'Failed' - we don't actually remove them from our tracking until we get a SUCCESS response - 2 of the 5 failed we are still checking on every cron run - ie the ones from July

Thu, Oct 22, 4:58 AM · Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton updated subscribers of T260703: Add translations for failed recurring email for 7 additional languages.

@MBeat33 @krobinson we have deployed this from a technical point of view - but we added another non-technical step where you can do a final QA & approval before they are live. If you got to my record (11863262 ) and try to send me a failure message you will see the screen looks a bit different - this is specifically because I'm set to Spanish - which is a language with an unapproved version available (& no approved version). The languages in this state are

Thu, Oct 22, 3:57 AM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, fr-donorservices, Fundraising-Backlog
Eileenmcnaughton moved T260703: Add translations for failed recurring email for 7 additional languages from Review to Done on the Fundraising Sprint Upbeat Upholstery board.
Thu, Oct 22, 3:52 AM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, fr-donorservices, Fundraising-Backlog
Eileenmcnaughton updated subscribers of T222287: Civi: make sure Forget Me requests reach IBM.

These contacts seem to have been fully deleted. In Silverpop there is a list of jobs in https://engage4.silverpop.com/ux/#/gdprjoblisting but it includes the 5 hung jobs (now showing as failed rather than 'processing' like last time) and a fistful of jobs for the last few days

Thu, Oct 22, 12:04 AM · Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Wed, Oct 21

Eileenmcnaughton added a comment to T265700: all_Wikimedia database shows both_funds_donation_count as a decimal.

The second one

Wed, Oct 21, 11:18 PM · Fundraising Sprint Upbeat Upholstery, Fundraising-Backlog
Eileenmcnaughton updated subscribers of T265700: all_Wikimedia database shows both_funds_donation_count as a decimal.

So looking at the first one - he has 2 references in silverpop

Wed, Oct 21, 11:06 PM · Fundraising Sprint Upbeat Upholstery, Fundraising-Backlog
Eileenmcnaughton moved T265369: New engage endowment import from Doing to Review on the Fundraising Sprint Upbeat Upholstery board.
Wed, Oct 21, 10:22 PM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T265369: New engage endowment import.

@RLewis so it seems like the Endowment donations are in the main csv that gets imported? And they ARE being imported but the type is being ignored. From what you sent me it looks like the Contribution Type column has the data but it's being ignored - I' have a fix that will pay more attention to that column in the csv

Wed, Oct 21, 10:18 PM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T265369: New engage endowment import.

It was added by mdemos-ctr (& then you fixed it to be Endowment)

Wed, Oct 21, 8:59 PM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T265369: New engage endowment import from Backlog to Doing on the Fundraising Sprint Upbeat Upholstery board.
Wed, Oct 21, 8:01 PM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T260703: Add translations for failed recurring email for 7 additional languages from Done to Review on the Fundraising Sprint Upbeat Upholstery board.
Wed, Oct 21, 8:01 PM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, fr-donorservices, Fundraising-Backlog
Eileenmcnaughton moved T264663: fr-tech to look into supporting mail fail over for civi from Doing to Review on the Fundraising Sprint Upbeat Upholstery board.
Wed, Oct 21, 3:51 AM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264663: fr-tech to look into supporting mail fail over for civi.

I've loaded the series of patches ending in https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/635410 on staging. I then set the SMTP host to more than one server using

Wed, Oct 21, 3:28 AM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264663: fr-tech to look into supporting mail fail over for civi.

Thanks @Jgreen - very helpful. As a bonus I can see whether it went via SMTP or not as I applied your XMailer suggestion to the SMTP but it's not set on phpmail

Wed, Oct 21, 3:20 AM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Tue, Oct 20

Eileenmcnaughton closed T261795: Changes to Citibank International import as Resolved.

Cool - thanks for confirming

Tue, Oct 20, 8:05 PM · Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264663: fr-tech to look into supporting mail fail over for civi.

@Dwisehaupt - are these the values we would need for config?

Tue, Oct 20, 7:08 AM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton updated subscribers of T264663: fr-tech to look into supporting mail fail over for civi.

@Jgreen @Dwisehaupt - I have in my head that we want to use smtp - but I realised I need to confirm that

Tue, Oct 20, 1:21 AM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Mon, Oct 19

Eileenmcnaughton added a comment to T260703: Add translations for failed recurring email for 7 additional languages.

@Cstone this is now in 'done' - but did they get enabled on live? I did some patches to give us more control enabling - (ending in https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/634139 ) but those aren't merged - unless you did an install that I'm missing

Mon, Oct 19, 10:03 PM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, fr-donorservices, Fundraising-Backlog
Eileenmcnaughton claimed T264663: fr-tech to look into supporting mail fail over for civi.
Mon, Oct 19, 9:06 PM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T264663: fr-tech to look into supporting mail fail over for civi from Backlog to Doing on the Fundraising Sprint Upbeat Upholstery board.
Mon, Oct 19, 9:05 PM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T254270: Dedupe donors before creating new contact.

I just enabled this with `drush vset match_on_import 1```

Mon, Oct 19, 9:02 PM · Fundraising Sprint Upbeat Upholstery, FR-Q2-FY2020-21-cleanup-list, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T254270: Dedupe donors before creating new contact from Pending Deployment to Done on the Fundraising Sprint Upbeat Upholstery board.
Mon, Oct 19, 8:51 PM · Fundraising Sprint Upbeat Upholstery, FR-Q2-FY2020-21-cleanup-list, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T254270: Dedupe donors before creating new contact from Review to Pending Deployment on the Fundraising Sprint Upbeat Upholstery board.
Mon, Oct 19, 7:48 PM · Fundraising Sprint Upbeat Upholstery, FR-Q2-FY2020-21-cleanup-list, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T265530: Clean up recurring 'installments' column on paypal recur records.

We can remove a civi-hack once completed is all good

Mon, Oct 19, 7:46 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T261795: Changes to Citibank International import.

@LeanneS this is live

Mon, Oct 19, 7:37 PM · Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T264124: one last civi point release? from Pending Deployment to Done on the Fundraising Sprint Upbeat Upholstery board.
Mon, Oct 19, 7:36 PM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T261795: Changes to Citibank International import from Pending Deployment to Done on the Fundraising Sprint Upbeat Upholstery board.
Mon, Oct 19, 7:36 PM · Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Fri, Oct 16

Eileenmcnaughton added a comment to T265700: all_Wikimedia database shows both_funds_donation_count as a decimal.

@KHaggard there should hopefully be a new full output uploading.... It would be an additional file

Fri, Oct 16, 9:36 PM · Fundraising Sprint Upbeat Upholstery, Fundraising-Backlog
Eileenmcnaughton added a comment to T265700: all_Wikimedia database shows both_funds_donation_count as a decimal.

I just replaced the view

Fri, Oct 16, 8:25 PM · Fundraising Sprint Upbeat Upholstery, Fundraising-Backlog
Eileenmcnaughton added a comment to T265700: all_Wikimedia database shows both_funds_donation_count as a decimal.

OK - those queries ran - so check tonights update & see how it compares

Fri, Oct 16, 3:05 AM · Fundraising Sprint Upbeat Upholstery, Fundraising-Backlog
Eileenmcnaughton updated subscribers of T265700: all_Wikimedia database shows both_funds_donation_count as a decimal.

& this would be the other query to implement @Ejegg's patch

Fri, Oct 16, 2:46 AM · Fundraising Sprint Upbeat Upholstery, Fundraising-Backlog
Eileenmcnaughton added a comment to T265700: all_Wikimedia database shows both_funds_donation_count as a decimal.

I just ran this on on staging to reflect the change

Fri, Oct 16, 2:42 AM · Fundraising Sprint Upbeat Upholstery, Fundraising-Backlog

Thu, Oct 15

Eileenmcnaughton moved T261795: Changes to Citibank International import from Review to Pending Deployment on the Fundraising Sprint Upbeat Upholstery board.
Thu, Oct 15, 7:55 PM · Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T264124: one last civi point release? from Review to Pending Deployment on the Fundraising Sprint Upbeat Upholstery board.
Thu, Oct 15, 7:55 PM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton assigned T261705: As a email manager, I'd like to see which contacts are suppressed to mepps.
Thu, Oct 15, 7:36 PM · Fundraising Sprint Upbeat Upholstery, fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Fundraising Sprint Raw data never hurt anyone, Fundraising-Backlog
Eileenmcnaughton added a comment to T261705: As a email manager, I'd like to see which contacts are suppressed.

Sounds good -

Thu, Oct 15, 7:35 PM · Fundraising Sprint Upbeat Upholstery, fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Fundraising Sprint Raw data never hurt anyone, Fundraising-Backlog
Eileenmcnaughton updated subscribers of T260703: Add translations for failed recurring email for 7 additional languages.

I'm not comfortable reviewing this patch due to the copy being in different languages so I have set it up (with a few patches) so I can generate tests on staging. Bonus - it permits us to deploy the updates & someone else (or us) can qa & enable individually if we want - I will forward emails on to @Cstone & @CDenes_WMF unless someone else wants to qa them

Thu, Oct 15, 3:00 AM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, fr-donorservices, Fundraising-Backlog
Eileenmcnaughton added a comment to T261705: As a email manager, I'd like to see which contacts are suppressed.

@KHaggard @bsisolak the opt out file should upload in the next hours & then daily. Filename is something like Optout-20201015131007.csv

Thu, Oct 15, 12:38 AM · Fundraising Sprint Upbeat Upholstery, fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Fundraising Sprint Raw data never hurt anyone, Fundraising-Backlog
Eileenmcnaughton moved T261705: As a email manager, I'd like to see which contacts are suppressed from Pending Deployment to Done on the Fundraising Sprint Upbeat Upholstery board.
Thu, Oct 15, 12:37 AM · Fundraising Sprint Upbeat Upholstery, fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Fundraising Sprint Raw data never hurt anyone, Fundraising-Backlog
Eileenmcnaughton added a comment to T261705: As a email manager, I'd like to see which contacts are suppressed.

Patch is merged through to deploy branch. Not deployed as yet - is any co-ordination needed?

Thu, Oct 15, 12:16 AM · Fundraising Sprint Upbeat Upholstery, fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Fundraising Sprint Raw data never hurt anyone, Fundraising-Backlog
Eileenmcnaughton moved T261705: As a email manager, I'd like to see which contacts are suppressed from Review to Pending Deployment on the Fundraising Sprint Upbeat Upholstery board.
Thu, Oct 15, 12:12 AM · Fundraising Sprint Upbeat Upholstery, fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Fundraising Sprint Raw data never hurt anyone, Fundraising-Backlog

Wed, Oct 14

Eileenmcnaughton added a comment to T261795: Changes to Citibank International import.

@LeanneS did you test on like or staging - it seems OK for me on staging...

Wed, Oct 14, 8:24 PM · Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T265369: New engage endowment import.

I just put up a concept patch - it might be enough depending on whether the file is just the same - it adds a checkbox

Wed, Oct 14, 3:12 AM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

Also noting where the 'more data' is

Wed, Oct 14, 12:59 AM · Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

@MBeat33 @KHaggard where is more info on these 5? There are perhaps co-incidentally 5 jobs that have been sent to silverpop that are still 'processing'

Wed, Oct 14, 12:51 AM · Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T254270: Dedupe donors before creating new contact from Backlog to Review on the Fundraising Sprint Upbeat Upholstery board.
Wed, Oct 14, 12:45 AM · Fundraising Sprint Upbeat Upholstery, FR-Q2-FY2020-21-cleanup-list, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T261795: Changes to Citibank International import from Doing to Review on the Fundraising Sprint Upbeat Upholstery board.
Wed, Oct 14, 12:45 AM · Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T261795: Changes to Citibank International import.

@LeanneS OK - I've put what I think is wanted onto staging as an update to 'Citibank Individuals' import

Wed, Oct 14, 12:27 AM · Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T261795: Changes to Citibank International import.

Also - this is the 'Citibank Individuals' import?

Wed, Oct 14, 12:05 AM · Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Tue, Oct 13

Eileenmcnaughton added a comment to T261795: Changes to Citibank International import.

@LeanneS I just realised there is a question here - we have a citibank import & my initial assumption was this updates that - but it occurs to me that the

Tue, Oct 13, 11:58 PM · Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T261795: Changes to Citibank International import from Backlog to Doing on the Fundraising Sprint Upbeat Upholstery board.
Tue, Oct 13, 10:53 PM · Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton claimed T261795: Changes to Citibank International import.
Tue, Oct 13, 10:53 PM · Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T264124: one last civi point release? from Backlog to Review on the Fundraising Sprint Upbeat Upholstery board.
Tue, Oct 13, 9:17 PM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264819: Investigate impact of buster upgrade on queue processing.

https://frmon.frdev.wikimedia.org/d/Pq1YNMviz/fundraising-overview?viewPanel=22&orgId=1&from=now-120d&to=now&refresh=1m

Tue, Oct 13, 8:08 PM · fundraising-tech-ops, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
Eileenmcnaughton moved T254270: Dedupe donors before creating new contact from Sprint W November 10th to November 24th to Sprint V October 27th to November 10th on the Fundraising-Backlog board.
Tue, Oct 13, 7:58 PM · Fundraising Sprint Upbeat Upholstery, FR-Q2-FY2020-21-cleanup-list, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton closed T264061: Queue speed - the new frontier as Resolved.
Tue, Oct 13, 7:20 PM · fundraising sprint Theme songs for programming languages, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
Eileenmcnaughton moved T264061: Queue speed - the new frontier from Pending Deployment to Done on the fundraising sprint Theme songs for programming languages board.
Tue, Oct 13, 7:20 PM · fundraising sprint Theme songs for programming languages, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
Eileenmcnaughton moved T262883: Address extraneous location related queries in queue processing from Pending Deployment to Done on the fundraising sprint Theme songs for programming languages board.
Tue, Oct 13, 7:17 PM · fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264124: one last civi point release?.

@jgleeson yeah - in fact that issue hit us last time too I think - but didn't realise & then it was really slow on live. This time I figured it out so it should be OK - the main thing is I test the update on staging & then deal with anything I spot

Tue, Oct 13, 7:05 PM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264061: Queue speed - the new frontier.

I also tried symfony 4 vs symfony 3 but locally could not measure a consistent difference

Tue, Oct 13, 3:58 AM · fundraising sprint Theme songs for programming languages, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
Eileenmcnaughton added a comment to T264061: Queue speed - the new frontier.

I did find a few memory leaks which I fixed in core - including one in our main code path & one in the dedupe code. But locally the speed difference was not significant. These are bundled with the 5.31 release along with other improvements - so we will see if it adds up to anything on prod

Tue, Oct 13, 3:57 AM · fundraising sprint Theme songs for programming languages, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
Eileenmcnaughton moved T264061: Queue speed - the new frontier from Doing to Pending Deployment on the fundraising sprint Theme songs for programming languages board.
Tue, Oct 13, 3:55 AM · fundraising sprint Theme songs for programming languages, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
Eileenmcnaughton moved T264124: one last civi point release? from Doing to Review on the fundraising sprint Theme songs for programming languages board.
Tue, Oct 13, 3:55 AM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton closed T264222: Contributions in Civi currently not saving as Resolved.
Tue, Oct 13, 3:26 AM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264124: one last civi point release?.

OK - I found a fix for this - https://lab.civicrm.org/dev/core/-/issues/2120

Tue, Oct 13, 2:23 AM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264124: one last civi point release?.

ALTER TABLE dev_civicrm.log_civicrm_address MODIFY log_id bigint(20) unsigned AUTO_INCREMENT

Tue, Oct 13, 1:04 AM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264124: one last civi point release?.
ALTER TABLE `dev_civicrm`.log_civicrm_activity_contact MODIFY   `log_id` bigint(20) unsigned  AUTO_INCREMENT
Tue, Oct 13, 12:57 AM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264124: one last civi point release?.

except it won't run on live...

Tue, Oct 13, 12:43 AM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264124: one last civi point release?.

Now I'm seeing

Tue, Oct 13, 12:42 AM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264124: one last civi point release?.

It's doing activity too

Tue, Oct 13, 12:07 AM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264124: one last civi point release?.

I've just deployed this on staging

Tue, Oct 13, 12:03 AM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Mon, Oct 12

Eileenmcnaughton moved T264124: one last civi point release? from Backlog to Doing on the fundraising sprint Theme songs for programming languages board.
Mon, Oct 12, 9:57 PM · Fundraising Sprint Upbeat Upholstery, Patch-For-Review, fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T262883: Address extraneous location related queries in queue processing from Doing to Pending Deployment on the fundraising sprint Theme songs for programming languages board.
Mon, Oct 12, 6:39 AM · fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Wed, Oct 7

Eileenmcnaughton added a comment to T263744: Error message when importing a Benevity file.

To clarify - the fees not the donation amount would be off (in non-converted currency) - for the AUD & CAD if should be pretty close but more out for the 115 EUR , 41 GBP, 2 SGD & 1 PLN ones

Wed, Oct 7, 7:26 PM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T262232: Donations queue consumer failed - Invalid character input in postal code from Review to Pending Deployment on the fundraising sprint Theme songs for programming languages board.
Wed, Oct 7, 2:38 AM · Fundraising Sprint Upbeat Upholstery, fundraising sprint Theme songs for programming languages, Fundraising-Backlog
Eileenmcnaughton added a comment to T263744: Error message when importing a Benevity file.

@RLewis - you should be able to import now - per above we are thinking to skip the retrospective fix up on concern it is not worth the time

Wed, Oct 7, 2:38 AM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T263744: Error message when importing a Benevity file from Review to Done on the fundraising sprint Theme songs for programming languages board.
Wed, Oct 7, 2:37 AM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T262884: Review activity related queries in contribution processing .
  • the remaining ones will be in the civi update
Wed, Oct 7, 2:23 AM · fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T262884: Review activity related queries in contribution processing from Backlog to Done on the fundraising sprint Theme songs for programming languages board.
Wed, Oct 7, 2:23 AM · fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T262883: Address extraneous location related queries in queue processing from Backlog to Doing on the fundraising sprint Theme songs for programming languages board.
Wed, Oct 7, 2:23 AM · fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Tue, Oct 6

Eileenmcnaughton created T264819: Investigate impact of buster upgrade on queue processing.
Tue, Oct 6, 11:28 PM · fundraising-tech-ops, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
Eileenmcnaughton added a comment to T262884: Review activity related queries in contribution processing .

I deployed one fix but I got more merged upstream which will be in the civi deploy

Tue, Oct 6, 9:01 PM · fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T260935: Matching Gifts database data cleanup from Review to Pending Deployment on the fundraising sprint Theme songs for programming languages board.
Tue, Oct 6, 9:00 PM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
Eileenmcnaughton moved T248420: Paypal recurring payments missing predecessor from Review to Pending Deployment on the fundraising sprint Theme songs for programming languages board.
Tue, Oct 6, 8:53 PM · Fundraising Sprint Upbeat Upholstery, fundraising sprint Theme songs for programming languages, FR-Q2-FY2020-21-cleanup-list, Fundraising-Backlog
Eileenmcnaughton moved T263877: new endowment TY email from Review to Pending Deployment on the fundraising sprint Theme songs for programming languages board.
Tue, Oct 6, 8:43 PM · fundraising sprint Theme songs for programming languages, Fundraising-Backlog
Eileenmcnaughton added a comment to T263744: Error message when importing a Benevity file.

@RLewis we chatted about this on our fr-tech meeting - there are up to 600 donations with incorrect fee amounts - most less than $0.50 & it's not clear if some are OK in the mix - so we were thinking we would leave them rather than try to fix

Tue, Oct 6, 8:04 PM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T263744: Error message when importing a Benevity file.

@RLewis there are around 600 already-imported benevity contributions which *might* have inaccurate fee_amount values. The weird thing is there is just one of these with PLN currency, 4 with SGN and another 41 GBP - which are low numbers. The Benevity code somewhat assumes one currency per file - hence you can specify the currency for the import - how would these odd ones have come in?

Tue, Oct 6, 7:53 AM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T263744: Error message when importing a Benevity file.

Hmm - I think I'd like to pick up the fix question in tech talk - there's about 600 possibly affected donations

Tue, Oct 6, 5:12 AM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T263744: Error message when importing a Benevity file.

MariaDB [civicrm]> select sum(total_amount), count(c.id), sum(fee_amount), (sum(fee_amount) /sum(total_amount)) as total_fee_ratio, c.id, c.total_amount, c.fee_amount, fee_amount/total_amount as fee_ration, c.net_amount,

->        c.currency, original_amount, source, original_currency
-> FROM wmf_contribution_extra x
->   LEFT JOIN civicrm_contribution c on c.id = entity_id
-> WHere gateway = 'benevity' AND original_currency != 'USD'
-> 
-> AND fee_amount > 0 GROUP BY original_currency LIMIT 10;

+-------------------+-------------+-----------------+-----------------+----------+--------------+------------+------------+------------+----------+-----------------+-----------+-------------------+

sum(total_amount)count(c.id)sum(fee_amount)total_fee_ratioidtotal_amountfee_amountfee_rationnet_amountcurrencyoriginal_amountsourceoriginal_currency

+-------------------+-------------+-----------------+-----------------+----------+--------------+------------+------------+------------+----------+-----------------+-----------+-------------------+

707.364844.820.063362356127925.000.750.1500004.24USD10.00AUD 10AUD
3361.93469179.630.0534313561281727.710.570.02057027.15USD50.00CAD 50CAD
2825.47115133.950.047408356128842.750.070.0254552.68USD2.00EUR 2EUR
1448.094154.820.0378573561293932.550.800.02457831.75USD21.00GBP 21GBP
1.3810.510.369565504663411.380.510.3695650.87USD20.00PLN 20PLN
35.9421.460.0406234509983414.120.570.04036813.55USD27.35SGD 27.35SGD

+-------------------+-------------+-----------------+-----------------+----------+--------------+------------+------------+------------+----------+-----------------+-----------+-------------------+
6 rows in set (0.393 sec)

Tue, Oct 6, 2:40 AM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Mon, Oct 5

Eileenmcnaughton created T264664: Investigate unnnecessary disk checks for unfound files from civi.
Mon, Oct 5, 8:11 PM · Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
Eileenmcnaughton created T264663: fr-tech to look into supporting mail fail over for civi.
Mon, Oct 5, 8:10 PM · Patch-For-Review, Fundraising Sprint Upbeat Upholstery, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Thu, Oct 1

Eileenmcnaughton claimed T264222: Contributions in Civi currently not saving .
Thu, Oct 1, 7:20 PM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264222: Contributions in Civi currently not saving .

@mepps no there was an issue see https://phabricator.wikimedia.org/T264222#6507012

Thu, Oct 1, 7:19 PM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Wed, Sep 30

Eileenmcnaughton moved T263744: Error message when importing a Benevity file from Doing to Review on the fundraising sprint Theme songs for programming languages board.
Wed, Sep 30, 11:23 PM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T263744: Error message when importing a Benevity file.

@RLewis I tracked it down - but it's a bit problematic. Basically we were converting the donation amount but not the fee amount - so for EUR it might look like

Wed, Sep 30, 11:22 PM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T263744: Error message when importing a Benevity file from Backlog to Doing on the fundraising sprint Theme songs for programming languages board.
Wed, Sep 30, 10:04 PM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton added a comment to T264222: Contributions in Civi currently not saving .

OK - I just deployed a fix

Wed, Sep 30, 9:45 PM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
Eileenmcnaughton moved T264222: Contributions in Civi currently not saving from Pending Deployment to Done on the fundraising sprint Theme songs for programming languages board.
Wed, Sep 30, 9:45 PM · fundraising sprint Theme songs for programming languages, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog