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"
Specs: https://tools.ietf.org/html/rfc5545#section-3.6.1 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: BEGIN:VCALENDAR VERSION:2.0 PRODID:Data::ICal 0.21 BEGIN:VEVENT DESCRIPTION:Your copy of Testtitle (barcode 12345) is due back at the library today DTSTAMP:20170623T143352Z DTSTART:20170704T215900Z SUMMARY:Testtitle is due UID:issue-2@192.168.1.27 END:VEVENT END:VCALENDAR 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.")
*** This bug has been marked as a duplicate of bug 30927 ***