Bug 18563 - Force koha.ics to only show up on first day of created calendar appointment
Summary: Force koha.ics to only show up on first day of created calendar appointment
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: OPAC (show other bugs)
Version: master
Hardware: All All
: P5 - low normal (vote)
Assignee: Owen Leonard
QA Contact: Testopia
URL:
Keywords:
Depends on: 5456
Blocks:
  Show dependency treegraph
 
Reported: 2017-05-09 19:05 UTC by John Andrews
Modified: 2017-06-23 14:53 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Who signed the patch off:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 18563: MariaDB doesn't have a debian.cnf file (836 bytes, patch)
2017-06-22 22:46 UTC, M. Tompsett
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
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 M. 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.")