[horde] Recurrent Appointments not reading timezone info correctly?

Michael J Rubinsky mrubinsk at horde.org
Tue May 27 01:30:39 UTC 2014 

Quoting Michael J Rubinsky <mrubinsk at horde.org>:

> Quoting Simon Wilson <simon at simonandkate.net>:
>
>> ----- Message from simon at simonandkate.net ---------
>>    Date: Tue, 20 May 2014 15:25:04 +1000
>>    From: simon at simonandkate.net
>> Subject: Re: [horde] Recurrent Appointments not reading timezone info
>> correctly?
>>      To: mrubinsk at horde.org
>>      Cc: horde at lists.horde.org
>>
>>>> On 20 May 2014, at 1:47 pm, Michael J Rubinsky <mrubinsk at horde.org>
>>>> wrote:
>>>>
>>>> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>>>>
>>>>> Quoting Simon Wilson <simon at simonandkate.net>:
>>>>>
>>>>>> Horde 5.1.6, Kronolith 4.1.5
>>>>>>
>>>>>> We setup TWO appointments in my wife's calendar, both inviting me as
>>>>>> an attendee.
>>>>>>
>>>>>> First one was a SINGLE non-recurrent event that came through with
>>>>>> times fine, displaying both in Katie's calendar all fine, and showing
>>>>>> in my Imp ics viewer fine, and accepted and showing in Kronolith fine.
>>>>>>
>>>>>> <SNIP>
>>>>>>  
>>>>>
>>>>> Does the ics file look the same if it exported directly from Katie's
>>>>> calendar?
>>>>
>>>> This may or may not be fixed by
>>>>
>> https://github.com/horde/horde/commit/7f6f41619c7ce923a56ba6f5d678aba30818daa8#diff-3115bd8529b81bde2eeba73f7cdde96d
>> (this fixed a number of timezone related issues I uncovered while trying to
>> track this
>>>> down).
>>>>
>>>> --
>>>> mike
>>>
>>> I'll check tonight, also what the ics looks like when exported from
>>> Katie's calendar.
>>>
>>> Thanks Mike :)
>>>
>>> Simon.
>>
>> Hi Mike,
>>
>> Not fixed unfortunately. :(
>>
>> Changes applied to kronolith/lib/Application.php as per the push. Stopped
>> httpd, horde-clear-cache, cleared xcache. Restarted everything. (Any
>> way to confirm that it's taken effect?)
>>
>> I generated a test recurrent appointment for 8th July, every two weeks,
>> 11am to 12 noon, in Katie's calendar, with me as an attendee. 
>>
>> Appears in Katie's calendar fine, but the invite to me appears in Imp
>> and imports as 10am to
>> 11am. 
>>
>> Three ics files following.
>>
>> Simon
>>
>>
>>
>> First is the ics as sent to me
>> Second is the ics exported from Katie's calendar
>> Third is the ics exported from MY calendar after accepting it.
>>
>> Both first two have the same information, with the event showing from
>> 11am to 12 noon
>>
>> DTSTART;TZID=Australia/Brisbane:20140708T110000
>> DTEND;TZID=Australia/Brisbane:20140708T120001
>>
>> My Imp displays it 10 to 11am, and it imports the same. The export
>> from my calendar then shows:
>>
>> DTSTART;TZID=Australia/Brisbane:20140708T100000
>> DTEND;TZID=Australia/Brisbane:20140708T110001
>>
>> ics as sent to me:
>>
>> BEGIN:VCALENDAR
>> VERSION:2.0
>> METHOD:REQUEST
>> X-WR-CALNAME:Calendar of Katie Wilson
>> PRODID:-//The Horde Project//Horde iCalendar Library//EN
>> BEGIN:VEVENT
>> DTSTART;TZID=Australia/Brisbane:20140708T110000
>> DTEND;TZID=Australia/Brisbane:20140708T120001
>> DTSTAMP:20140520T091239Z
>> UID:20140520191239.rPFpybvjG1ykk_SLJ3vD6A6 at mail.simonandkate.net
>> CREATED:20140520T091239Z
>> LAST-MODIFIED:20140520T091239Z
>> SUMMARY:Test
>> ORGANIZER;CN=Katie Wilson:mailto:katie at simonandkate.net
>> CLASS:PUBLIC
>> STATUS:CONFIRMED
>> TRANSP:OPAQUE
>> ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE:mailto:simon@
>> simonandkate.net
>> ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE:mailto:katie@
>> simonandkate.net
>> RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=TU;COUNT=5
>> BEGIN:VALARM
>> ACTION:DISPLAY
>> DESCRIPTION:Test
>> TRIGGER;VALUE=DURATION:-PT15M
>> END:VALARM
>> END:VEVENT
>> BEGIN:VTIMEZONE
>> TZID:Australia/Brisbane
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19170101T000100
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19170325T020000
>> TZNAME:EST
>> END:STANDARD
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19420101T020000
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19420329T020000
>> TZNAME:EST
>> END:STANDARD
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19420927T020000
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19430328T020000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3;UNTIL=19440325T16000Z
>> TZNAME:EST
>> END:STANDARD
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19431003T020000
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19711031T020000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=19711030T16000Z
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19720227T020000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=2;UNTIL=19720226T16000Z
>> TZNAME:EST
>> END:STANDARD
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19891029T020000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=19911026T16000Z
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19900304T020000
>> RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=1SU;UNTIL=19920229T16000Z
>> TZNAME:EST
>> END:STANDARD
>> END:VTIMEZONE
>> END:VCALENDAR
>>
>> And as exported from the event in Katie's calendar:
>>
>> BEGIN:VCALENDAR
>> VERSION:2.0
>> X-WR-CALNAME:Calendar of Katie Wilson
>> PRODID:-//The Horde Project//Horde iCalendar Library//EN
>> BEGIN:VEVENT
>> DTSTART;TZID=Australia/Brisbane:20140708T110000
>> DTEND;TZID=Australia/Brisbane:20140708T120001
>> DTSTAMP:20140520T091305Z
>> UID:20140520191239.rPFpybvjG1ykk_SLJ3vD6A6 at mail.simonandkate.net
>> CREATED:20140520T091239Z
>> LAST-MODIFIED:20140520T091239Z
>> SUMMARY:Test
>> ORGANIZER;CN=Katie Wilson:mailto:katie at simonandkate.net
>> CLASS:PUBLIC
>> STATUS:CONFIRMED
>> TRANSP:OPAQUE
>> ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE:mailto:simon@
>> simonandkate.net
>> ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE:mailto:katie@
>> simonandkate.net
>> RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=TU;COUNT=5
>> BEGIN:VALARM
>> ACTION:DISPLAY
>> DESCRIPTION:Test
>> TRIGGER;VALUE=DURATION:-PT15M
>> END:VALARM
>> END:VEVENT
>> BEGIN:VTIMEZONE
>> TZID:Australia/Brisbane
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19170101T000100
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19170325T020000
>> TZNAME:EST
>> END:STANDARD
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19420101T020000
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19420329T020000
>> TZNAME:EST
>> END:STANDARD
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19420927T020000
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19430328T020000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3;UNTIL=19440325T16000Z
>> TZNAME:EST
>> END:STANDARD
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19431003T020000
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19711031T020000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=19711030T16000Z
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19720227T020000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=2;UNTIL=19720226T16000Z
>> TZNAME:EST
>> END:STANDARD
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19891029T020000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=19911026T16000Z
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19900304T020000
>> RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=1SU;UNTIL=19920229T16000Z
>> TZNAME:EST
>> END:STANDARD
>> END:VTIMEZONE
>> END:VCALENDAR
>>
>> ics exported from my calendar:
>>
>> BEGIN:VCALENDAR
>> VERSION:2.0
>> X-WR-CALNAME:Calendar of Simon Wilson
>> PRODID:-//The Horde Project//Horde iCalendar Library//EN
>> BEGIN:VEVENT
>> DTSTART;TZID=Australia/Brisbane:20140708T100000
>> DTEND;TZID=Australia/Brisbane:20140708T110001
>> DTSTAMP:20140520T093228Z
>> UID:20140520191239.rPFpybvjG1ykk_SLJ3vD6A6 at mail.simonandkate.net
>> CREATED:20140520T093211Z
>> LAST-MODIFIED:20140520T093211Z
>> SUMMARY:Test
>> CLASS:PUBLIC
>> STATUS:CONFIRMED
>> TRANSP:OPAQUE
>> RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=TU;COUNT=5
>> BEGIN:VALARM
>> ACTION:DISPLAY
>> DESCRIPTION:Test
>> TRIGGER;VALUE=DURATION:-PT15M
>> END:VALARM
>> END:VEVENT
>> BEGIN:VTIMEZONE
>> TZID:Australia/Brisbane
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19170101T000100
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19170325T020000
>> TZNAME:EST
>> END:STANDARD
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19420101T020000
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19420329T020000
>> TZNAME:EST
>> END:STANDARD
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19420927T020000
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19430328T020000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3;UNTIL=19440325T16000Z
>> TZNAME:EST
>> END:STANDARD
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19431003T020000
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19711031T020000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=19711030T16000Z
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19720227T020000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=2;UNTIL=19720226T16000Z
>> TZNAME:EST
>> END:STANDARD
>> BEGIN:DAYLIGHT
>> TZOFFSETFROM:+1000
>> TZOFFSETTO:+1100
>> DTSTART:19891029T020000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=19911026T16000Z
>> TZNAME:EST
>> END:DAYLIGHT
>> BEGIN:STANDARD
>> TZOFFSETFROM:+1100
>> TZOFFSETTO:+1000
>> DTSTART:19900304T020000
>> RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=1SU;UNTIL=19920229T16000Z
>> TZNAME:EST
>> END:STANDARD
>> END:VTIMEZONE
>> END:VCALENDAR
>
>
> Looked at this some again tonight. I've narrowed it down to the fact  
> that Horde seems to generate the wrong UTC offset when importing the  
> ics in Horde_Icalendar::_parseDateTime(). I have yet to figure out  
> WHY this happens, or if the tz data in the ics has the wrong info...

Ok. I found the issue, but I'm not familiar enough with the ics code  
to figure out how to fix this quickly. I'm going to create a ticket  
and break down the issue so hopefully Jan can take a look at it.





-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5869 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20140526/df0673fb/attachment.bin>

More information about the horde mailing list