[Building Sakai] Timezone for events

[Nico Coetzee]

Hi

I do not think its a database problem, but I think it has something to do with the org.sakaiproject.time.impl.BasicTimeService.java.  It is set up in init to set up dates according to GMT time, and all tool's uses this but the tools also looks at the local users time zone preferences in My Workspace, Preferences and adjust the time accordingly example calendar.  As far as I can see the ClusterEvenetrackingService and the UsageSessionApdaptor, does not do the adjustment, and takes the local time (which is correct) and then converts it to GMT.

Can someone confirm this before I log a jira?

Thanks
On 20 May 2011, at 2:31 PM, David Horwitz wrote:

Sounds like it might be this:

https://jira.sakaiproject.org/browse/KNL-725

Basically a db column type issue

D

On 05/20/2011 01:55 PM, DAVID ROLDAN MARTINEZ wrote:
> Can you JIRA this, please? Remember to include i18n in components.
> 
> Thank you.
> 
> David
> 
> -----Mensaje original-----
> De: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] En nombre de Coetzee, Nico
> Enviado el: viernes, 20 de mayo de 2011 12:38
> Para: sakai-dev at collab.sakaiproject.org Developers
> Asunto: [Building Sakai] Timezone for events
> 
> This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
> 
> Hi
> 
> 
> I'm busy with my upgrade for sakai 2-8-0 and we currently have to change the kernel-impl/src/main/java/org/sakaiproject/event/impl/ ClusterEventracking.java and UsageSessionServiceApdaptor.  The reason for this change is when a new event is posted the sakai installation takes GMT time, and I have to offset the time by 720000 to make the insert display our current time for this event and the same is for the UsageSessionServiceApdaptor for setting the start and end time for the sessions.
> 
> Is there a better way?  I have found that there is a java param you can set at startup that sets the timezone -Duser.timezone=Africa/Johannesburg, but still the insert is taking gmt time
> 
> Thanks
> 
> Nico Coetzee
> Designer Developer
> ICT
> Unisa Main Campus
> Preller Street
> Pretoria
> Tel: +27 (012) 429-4661
> Fax : 0862756913
> 
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev

TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"


Nico Coetzee
Designer Developer
ICT
Unisa Main Campus
Preller Street
Pretoria
Tel: +27 (012) 429-4661
Fax : 0862756913

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Unisa-email-signature_UNGC.gif
Type: image/gif
Size: 8678 bytes
Desc: Unisa-email-signature_UNGC.gif
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110523/30e4efa7/attachment.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.gif
Type: image/gif
Size: 4902 bytes
Desc: image002.gif
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110523/30e4efa7/attachment-0001.gif 
-------------- next part --------------