Page MenuHomePhabricator

Civi emails and donations have different timestamps in the activities tab
Closed, ResolvedPublic2 Estimated Story Points

Description

https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/815964

@KHancock99 @Ejegg What is the correct timezone these should be in? Looks like donations are going in UTC and mailing events at Pacific time

Event Timeline

Change 815964 had a related patch set uploaded (by Cstone; author: Eileen):

[wikimedia/fundraising/crm@master] A better now

https://gerrit.wikimedia.org/r/815964

I am not sure.

UTC would be best to work in across the board, but @KHaggard and @nisrael may be able to speak to why the mailing events are in Pacific as it may be a particular preference of theirs perhaps.

cc: @krobinson, @SHust

This is a little confusing. We strictly work in UTC through our Email Service Platform and schedule all of our sends and view our results in the context of UTC. Not sure where the disconnect may be. I can ping Brian Sisolak, our Acoustic expert who may be able to help with this question.

The user you export data with is set to GMT. I checked data in some of our accounts and it's being exported as GMT. Can you provide some examples where you are seeing PT in the exported file? Is this something recentlly that changed or it's been like this for years?

I know for the end of year donations push, we move something back to PT or Hawaiian time so donors donating on 31st Dec from anywhere in the US get their tax receipt with the correct year. @Eileenmcnaughton can likely provide context here.

I'm not sure how that affects other things in Civi, but I would prefer things to be in UTC if possible.

Adding some other subscribers who may want to weigh in on any changes here: @LeanneS @TSkaff @SHust @RLewis @NNichols

Yes the date on the letters is in 'beach time' - to ensure that US people get things in the correct year. I think we use the same on the thank yous to keep it consistent.

However, the activity date is purely a UI thing. Ie not user facing at all. It came up because @Cstone was finding it confusing that the activity dates for the contribution & for the thank you letters are not in the same timezone so building a timeline is confusing

Dwisehaupt set the point value for this task to 2.Aug 22 2022, 8:16 PM

Change 815964 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] A better now

https://gerrit.wikimedia.org/r/815964