Your event violates the standard.
The start and end dates are equal.

DTSTART;VALUE=DATE:20120420
DTEND;VALUE=DATE:20120420

End must always be later than start.

See bug 0001055 for a fix.
Can you please try it?

Thank you for your reply. I think Outlook violates the standard then, and there is not much I can do about that :)

About the propposed fix: is there a compiled RPM for CentOS6 with the fix somewhere that I can try to install? I have no experience on compiling SOGo myself: if I need to do that, I would appreciate instructions how to proceed.

This should be in the nightlies.
http://www.sogo.nu/downloads/backend_nightly.html

Thank you for your feedback.

I yum updated my dev system to the latest nightly packages:

rpm -qa |grep sogo

sogo-2.0_20120419-1.centos6.i686
sogo-ealarms-notify-2.0_20120419-1.centos6.i686
sogo-tool-2.0_20120419-1.centos6.i686

rpm -qa |grep sope

sope49-appserver-4.9-20120414_1664.el6.1.i686
sope49-xml-4.9-20120414_1664.el6.1.i686
sope49-gdl1-mysql-4.9-20120414_1664.el6.1.i686
sope49-gdl1-postgresql-4.9-20120414_1664.el6.1.i686
sope49-sbjson-2.3.1-20120414_1664.el6.1.i686
sope49-gdl1-contentstore-2.0_20120419-1.centos6.i686
sope49-gdl1-4.9-20120414_1664.el6.1.i686
sope49-ldap-4.9-20120414_1664.el6.1.i686
sope49-cards-2.0_20120419-1.centos6.i686
sope49-core-4.9-20120414_1664.el6.1.i686
sope49-mime-4.9-20120414_1664.el6.1.i686

I restarted memcached+sogod, removed the calendar with sogo-tool and imported the attached webcalendar-fullday.ics again.

This did not resolve the problem. The event is still marked on the 19th when it should be marked on the 20th. Sogo also complains about the end date being before the start date if I double click the event.

If one creates a full day event in Outlook 2010, one cannot change the time for the event: it always begins and ends at the same time (12 AM). Although against the standard, IMHO it would be user friendly to support such events? And at least for me it would make sense that if an event is a full day event, then the calendar should be only considered about the day the event is occurring (and pay no attention to the time).

The fix is in the 20120420 builds.

The fix will only work for events that are imported from SOGo's Web GUI, not if you do a DAV PUT.

I can confirm that yum updating to 20120420 build fixed the problem when importing the full day event from ics.

But like ludovic commented, it does not fix the problem when syncing from Outlook with Funambol:

• Event marked as a full day event for 21st of April and synced from Outlook is listed starting on the 20th and ending on the 21st

• The event does not show at all in the actual calendar area (only in the event list)

• If double clicked from the event list, the event information is shown as follows:

x All day event
Start: 2012-04-21 00:00
End: 2012-04-21 00:00

• If I now click "Save and Close" the event appears in the the calendar area and is now shown correctly on the 21st and in the event list it is reported starting on the 21st and ending on the 21st

Can you fix this behaviour as well? Thanks!

I just upgraded to 1.3.15a and there was no change: full day events synced from Outlook with Funambol are shown in the SOGo web UI on the wrong day.

Are there any plans fixing this or should I start looking for Funambol replacement for Outlook users?

To fix the issue for all day events synced form Outlook with Funambol requires the value for c_startdate and c_enddate inserted into the *quick table.

e.g.
// tfu 0001775 / sogo allday events on wrong day
s.setLong(3, event.isAllDay() ? s_date + 3600 : s_date); // c_startdate
s.setLong(4, event.isAllDay() ? e_date + 86399 : e_date ); // c_endate

I attached following files to the bug containg some hacks which should fix following problemes related to events and their reminders:

ca/inverse/sogo/engine/source/CalendarData.class
-> Convert DATE/DATE-TIME trigger to DURATION trigger (the fix is actually just a cut'n'past of parts of MozillaSyncClientout.bsh)
-> reminder are not shown in sogo-web when synced via funambol (c_nextalarm)

ca/inverse/sogo/engine/source/SOGoEventUtilities.class
-> fix for some issue with all day events
-> fix issue were allday events are shown on wrong day
-> Convert DATE/DATE-TIME trigger to DURATION trigger

ca/inverse/sogo/engine/source/SOGoUtilities.class
-> fix for some issue with all day events

I call them hacks because I've not enough programming experience to write clean java code but maybe someone can make use of my findings and can create proper fixes for the mentioned problems.

Funambol is no longer supported.