maemo.org - Talk - Calendar Home Widget replacement

maemo.org - Talk (https://talk.maemo.org/index.php)

- Applications (https://talk.maemo.org/forumdisplay.php?f=41)

- - Calendar Home Widget replacement (https://talk.maemo.org/showthread.php?t=55018)

Re: Calendar Home Widget replacement

Quote:

Originally Posted by x-lette (Post 988033)

Using version 1.3 I currently cannot see any errors in display of birthdays or recurring events. I set up an event of one hour duration repeating weekly and it's displayed correctly. Same for upcoming birthdays of which one is today and one tomorrow. Date and age are correct. :)

My settings are: UTC+2 (=UTC+1+DST) and display of upcoming three weeks with all recurrences and events only (no tasks).

same here..

Re: Calendar Home Widget replacement

@Nicolai:

Could help you with the sql queries if you like. Or is it just about the timeset on the telephone? DST stuff ?

Re: Calendar Home Widget replacement

Are the displayed events still wrong?
I thought the latest version solved all time shift related bugs.

Nicolai

Re: Calendar Home Widget replacement

Nope . . . still displaying two hours earlier . . .

Re: Calendar Home Widget replacement

Quote:

Originally Posted by nicolai (Post 987532)

what kind of entries? Events or Todos?

And what timezone settings do you have?

Nicolai

It seems that if I create an event on my N900 the time is correct. But if I synchronize an event from Exchange server (using MfE), the time is shown wrong. It shows 1 hour in the future, for example if my meeting is 9:00 it will show up as 10:00 instead.

My time zone is set to America/Chicago. The times show correctly in the nokia calendar widget, and the calendar itself, and my reminder alarms still ring at the correct time. So it seems like it's only displaying
wrong in this one place.

Let me know if there's any other info I can provide to help solve it! Thanks. :)

Re: Calendar Home Widget replacement

Hi stlpaul,

can you use sqlite3 to export some of these calendar entries.
I don't use MFE, so for me it is difficult to reproduce it.

Thank you.

Nicolai

Re: Calendar Home Widget replacement

Quote:

Originally Posted by nicolai (Post 991662)

can you use sqlite3 to export some of these calendar entries.
I don't use MFE, so for me it is difficult to reproduce it.

Hi, absolutely, thanks for your fine work. :)

Here is my time zone:

Code:

sqlite> select * from timezone where location='America/Chicago';

America/Chicago|/freeassociation.sourceforge.net/Tzfile/America/Chicago|26269200|6231600|-21600|-18000|FREQ=YEARLY;BYDAY=1SU;BYMONTH=11|FREQ=YEARLY;BYDAY=2SU;BYMONTH=3|CST|1

Here I created 2 events with the same start and end time; one on my N900 (shows up properly) and one from Exchange (created in Outlook), which shows time wrong by 1 hour in the widget:

Code:

sqlite> select * from components where id>793;

794|1|1|4|1303336800|1303338600|Test from N900|||-1||-1|0|1303332422|1303332738|:America/Chicago|-18000

795|1|1|4|1303336800|1303338600|Test from Exchange||



|0|040000008200E00074C5B7101A82E008000000008031F03C72FFCB01000000000000000010000000C7BDDF7F6675664DB1E7E27A75331E8E|-1|0|1303332470|1303332779|:America/Nassau|-14400

So we can see the UTC start and end timestamp are identical. The last columns are the interesting ones :) Time Zone ID and Time Zone Offset to UTC.

Why does my Exchange event have America/Nassau and -14400? This difference of course is 3600 seconds, 1 hour, exactly the wrong difference in time on the widget.

But the strange part is that Nokia's widget, and in fact the rest of the calendar and alarm system, can properly interpret the date. Does this mean they only use UTC and compute TZ offset independently, ignoring the TZ and offset in this table? And that the calendar database contains the wrong values, apparently.

My company's Exchange server is located in US Eastern Time Zone, which happens to 1 hour ahead of mine. Maybe that's where the bad data comes from (if it's bad?).

Please let me know if you need any other data, thanks.

Re: Calendar Home Widget replacement

Quote:

Originally Posted by stlpaul (Post 992819)

But the strange part is that Nokia's widget, and in fact the rest of the calendar and alarm system, can properly interpret the date. Does this mean they only use UTC and compute TZ offset independently, ignoring the TZ and offset in this table? And that the calendar database contains the wrong values, apparently.

That is really strange. I had so many bugs with wrong time offset, which
I got fixed only by using the TZ and TZ-offset.

I am afraid I can not simply remove this time offset from the timezone,
as in other cases the time offset may be wrong again.

Nicolai

Re: Calendar Home Widget replacement

I am traveling quite often and I tend to set the timezone to every place I go. I have noticed that every time I edit any of my contacts while being abroad the birth date is set to the current timezone (I saw that using the sqlite3 command).

Due to that "behavior" the birth dates appeared with an offset for those contacts when I get back home.

In order to fix this, I have to edit the affected contacts again, when I am returning to my default time zone.

I though that this might help someone.

Re: Calendar Home Widget replacement

Is it possible to adjust the opacity of the background tiles in this widget? Where does it pull the graphics from?