Bug 18563

Summary: Force koha.ics to only show up on first day of created calendar appointment
Product: Koha Reporter: John Andrews <jandrews>
Component: OPACAssignee: Owen Leonard <oleonard>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: jonathan.druart, mtompset, veron
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on: 5456    
Bug Blocks:    
Attachments: Bug 18563: MariaDB doesn't have a debian.cnf file

Description John Andrews 2017-05-09 19:05:20 UTC
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.
Comment 1 Mark Tompsett 2017-06-22 22:46:59 UTC Comment hidden (obsolete)
Comment 2 Marc Véron 2017-06-23 14:07:29 UTC Comment hidden (obsolete)
Comment 3 Marc Véron 2017-06-23 14:53:25 UTC
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.")
Comment 4 Katrin Fischer 2023-09-15 20:38:26 UTC

*** This bug has been marked as a duplicate of bug 30927 ***