This is a follow-up to bug 5456 - create a link to opac-ics.pl. The functionality established by that bug fix creates a file that can be imported to a calendar program. In Outlook, with a due time of 11:59, a 1-hour appointment is created, resulting in a 2-day "date due" appointment in the calendar. The appointment created should be limited to the first (actual due) date.
[tag] [reply] [−] Comment 13 John Andrews 2017-05-02 16:16:58 UTC
There's a problem with the lack of end time -- when importing this into my outlook calendar, because there's no end time, outlook automatically creates an hour long event. Which means that the due date reminder shows up both on the due date, and on the day AFTER the due date. In our case, the time due is 11:59 pm, so the appointment gets created in outlook as from 11:59 pm on the due date until 12:59 am on the next day. Is there a way to force the appointment to start and end at the same time?
[tag] [reply] [−] Comment 14 Magnus Enger 2017-05-03 08:05:18 UTC
(In reply to John Andrews from comment #13)
Please report this as a new bug/issue.
Created attachment 64556 [details] [review]
Bug 18563: MariaDB doesn't have a debian.cnf file
The koha-common.cnf file is a link to debian.cnf, which MariaDB
does not install. This just forces a 'localhost' return value.
No related patch here, try to reset to "New"
The "DTSTART" property for a "VEVENT" specifies the inclusive
start of the event. For recurring events, it also specifies the
very first instance in the recurrence set. The "DTEND" property
for a "VEVENT" calendar component specifies the non-inclusive end
of the event. For cases where a "VEVENT" calendar component
specifies a "DTSTART" property with a DATE value type but no
"DTEND" nor "DURATION" property, the event's duration is taken to
be one day. For cases where a "VEVENT" calendar component
specifies a "DTSTART" property with a DATE-TIME value type but no
"DTEND" property, the event ends on the same calendar date and
time of day specified by the "DTSTART" property.
This is an ics output from Koha / current master:
DESCRIPTION:Your copy of Testtitle (barcode 12345) is due back at
the library today
SUMMARY:Testtitle is due
I'm in Switzerland, so DTSTART defined in UTC time is 23.59 local time (+2, daylight saving time)
Import in Thunderbird calendar displays OK, it shows 04.07.2017 23:59 for Begin and for End. The event does not span to the next day.
Test on https://icalendar.org/validator.html passes OK.
Could it be that Outlook does not behave as expected? (see spec above: "...the event ends on the same calendar date and time of day specified by the "DTSTART" property.")