Calendar Home Widget replacement - Page 46 - maemo.org

Carlito | # 451 | 2011-04-17, 10:19 | Report

Originally Posted by x-lette View Post

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..

Carlito | # 452 | 2011-04-18, 12:23 | Report

@Nicolai:

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

nicolai | # 453 | 2011-04-18, 12:26 | Report

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

Nicolai

Carlito | # 454 | 2011-04-18, 12:44 | Report

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

stlpaul | # 455 | 2011-04-18, 15:53 | Report

Originally Posted by nicolai View Post

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.

The Following User Says Thank You to stlpaul For This Useful Post:
nicolai

nicolai | # 456 | 2011-04-19, 09:27 | Report

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

The Following User Says Thank You to nicolai For This Useful Post:
stlpaul

stlpaul | # 457 | 2011-04-20, 21:07 | Report

Originally Posted by nicolai View Post

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.

The Following User Says Thank You to stlpaul For This Useful Post:
nicolai

nicolai | # 458 | 2011-04-26, 08:05 | Report

Originally Posted by stlpaul View Post

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

amok | # 459 | 2011-04-26, 09:24 | Report

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.

The Following User Says Thank You to amok For This Useful Post:
nicolai

hawaii | # 460 | 2011-04-27, 13:42 | Report

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