[Building Sakai] Bulk update user timezones in 2.5

[Beth Kirschner]

Hi Ashley,

    Time Zone preferences are stored in the SAKAI_PREFERENCES table,  
but default to the java/server time-zone default. You will likely not  
see any rows in this table unless someone has explicitly set their  
time zone preference. I think what you really need to look into is  
setting the default time zone appropriately on your server. Once this  
is set correctly (you probably will need to restart sakai), all users  
should have the correct time zone.

- Beth

On Aug 16, 2010, at 3:58 AM, Ashley Holman wrote:

> Hi all,
>
> Does anyone know where the user's "Time Zone" setting is stored in the
> Sakai 2.5 database?  I need to bulk update all users to be a new  
> timezone.
>
> I couldn't see it on the SAKAI_USER table and the  
> SAKAI_USER_PREFERENCES
> table is empty (0 rows).
>
> What would be a good way to set everyone's timezone to
> "Australia/Melbourne"?
>
> Thanks
> Ashley
>
> -- 
> Ashley Holman
> Manager, Software Development
> NetSpot Pty. Ltd. ~ 183 Melbourne St. North Adelaide SA 5006
> Ph: 08 8361 6800 (reception) | 08 7200 5322 (direct) | Fax: 08 8361  
> 6811
> Email: ashley.holman at netspot.com.au | Web: http://www.netspot.com.au
> NetSpot - Enabling Technology for Education
>
> _______________________________________________
> 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"
>
>