Re: UK BST Time Settings

Helge Hess wrote:
> On 05.04.2009, at 23:39, Ken Smith wrote:
>> Ok - Just to be clear. I looking at appointments through Oulook with 
>> the Zidelook / Zidestore connector.
>
> OK. So ZideLook + Skyrix ZideStore.
>
>> If I go to the configuration page at 
>> http://192.168.1.2:8050/zidestore/so/{username}/settings I can see 
>> choices for MET, GMT, PST. EST and CST. Changing those settings seems 
>> to have no effect. The display of appointments in Outlook is showing 
>> in GMT.
>
> Outlook stores times in UTC internally and then uses its own timezone 
> to display the items.
> I'm pretty sure that ZideLook and ZideStore only exchange times in 
> UTC. The timezone setting is only for iCalendar exchange.
>
>> It seems as if the Zidelook / Zidestore arrangement is ignoring the 
>> files in 
>> /opt/skyrix/skyrix5/Libraries/Resources/libFoundation/TimeZoneInfo or 
>> is configured to look elsewhere for the timezone data.
>
> I think the list of timezones which show up in the WebUI is configured 
> using the LSTimeZones default, see:
>
>   http://mail.opengroupware.org/pipermail/users/2003-October.txt
>
> But: this does not affect how _Outlook_ calculates timezones.
>
>
>> I would appreciate some guidance on how to correct this anomaly as 
>> the end user is getting rather frustrated with a wrong calendar.
>
> I think you should check that the local timezone on your Windows 
> machine switched to DST and that Outlook uses it.
>
> ZideLook and ZideStore should only exchange UTC times, timezone 
> settings of ZideStore should not affect you (AFAIK).
>
> Helge


Thank you for your swift reply.

I have checked that the PC + Outlook that I'm using is set to UK London 
time and DST. Indeed it is. If I change the timezone or DST setting in 
Outlook then the time setting on the PC also changes. I can make the 
appointments appear at the correct times by unticking the DST setting, 
but that makes the PC clock wrong.

 From Outlook I created a test appointment at 10AM. Using ODBC/Access to 
look into the OGo database, the entry in date_x is also at 10:00. Using 
psql I see this:-

OGo=# select date_id,start_date,title FROM date_x where title='Test';
 date_id |       start_date       | title
---------+------------------------+-------
  119440 | 2009-04-02 10:00:00+01 | Test
(1 row)

OGo=#

I don't fully understand the significance of the '+01' at the end of the 
date data.

In the OGo web display the same appointment appears at 09:00. So this 
test entry I created with Outlook/Zidelook does not appear to be 
adjusted into UTC before entry in the database.

Using wireshark I attempted to capture the traffic between the PC & the 
server, to see what the time data was 'on the wire'. Unfortunately I'm 
using a VPN to the remote server and the capture is of the encrypted VPN 
traffic. :-(

Superficially, it would appear that DST is not getting applied somewhere 
between the database and the Outlook display. Is it possible that a 
correction is being applied on the server and then removed by Outlook? 
If so there is a possibility of a simple fix.

I tried to export the appointment from Outlook to a csv file, to see 
what data Outlook thought it had, but unfortunately I get a MAPI error 
and the export fails.

I'd appreciate any suggestions and if you have any tests I can try I'd 
be more than willing to get a fix to this.

Many thanks

Ken




-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users