My time, not server time


(timendum) #1

Piwik collects and archives data based on “server time”, but my server is in USA and my averange visitor is in Italy, there are like 6 hours difference!

How can i make Piwik work with my time zone

PS i’m on a shared server, so no change to server/php config

Thanks,
Timendum


(vipsoft) #2

It’s a TODO item on the roadmap.

http://dev.piwik.org/trac/ticket/56


(fresco) #3

[quote=vipsoft @ Mar 6 2009, 09:27 PM]It’s a TODO item on the roadmap.

http://dev.piwik.org/trac/ticket/56[/quote]

hi, is there any news about this?
It’s a bit annoying when all your visitor’s times get shifted of 6 hours…
apart from this, great work!!


(vipsoft) #4

There are a number of approaches to the problem of varying difficulty/complexity, pros/cons.

The easiest is a fixed offset, a one-time configured item during the initial installation. Let’s say the server time is EST. An offset of +3 would shift all times to PST. This would apply to all web sites. Everyone would see the data relative to that timezone. (Or we could convert all times to UTC and just specify a timezone offset relative to that.)

Another scenario is a fixed offset per web site. This might be a middle-ground solution.

The most difficult would be user-configurable timezone settings per user. This is complicated by the storage of timestamps in server time (vs UTC) and how archiving currently works. We could leave archiving alone (i.e., by server time). Or we could archive by user timezone – unfortunately, this has the negative consequence of increasing the database size significantly.

We would also need to consider how to handle DST and re-archiving when someone changes the timezone settings.


(Matthieu Aubry) #5

vipsoft, I have specced the changes required for adding timezone support; please look at the ticket at: http://dev.piwik.org/trac/ticket/56 and let’s continue the discussion there