As you said, SOGo doesn't implement the full iCalendar standard, so I think this should be fixed in main SOGo and not in the connector. I've already filed bug 586 about this.

Lightning 1.0 doesn support alarms with fixed times, as you can see in the other bug I used Lightning to create one.

@havard:
I know your bug report but I think it's something different.

It's right that SOGo should implement the full iCalendar standard. That would be the optimal solution.
But I think it's much more work than to implement the converts which you could directly take from the 2 mentioned files and must only adopt a little bit for SOGo.

Another problem would be that without the converter events in Lightning wouldn't be shown correctly. Therefore Lightning must implement the full iCalendar standard also.

And last but not least:
Without the converter events on mobile devices wouldn't show correctly as most (all?) mobiles seem to support only absolut alarms.

The fast and only working solution for all this is:
VALARM-Converters in Funambol-SOGo-Connector

The full iCalendar standard in SOGo would be also very nice. But that should be another feature request (and the solution for your bug report 586).

As nobody seems to be able to do it or have time for it, I'll try it myself.
Don't expect too much.

If I get the conversion running I'll make a patch and provide it here.

Please fix this bug, it is the only reason why I continue to use Horde instead of migrating to SOGo.
Unfortunately I cannot implement a solution myself, but I am willing to help otherwise.

Yes, I'd also be very glad if this problem would be fixed and we could use Funambol-Sync.

I tried myself but aren't good enough in programming :(

As soon as there's a testing version I'd be glad to test it. I'd also test and try a new subversion trunk release.

I think we really need to convert relative alarms to absolute ones when downgrading vcal 2 to vcal 1. I can't find any reference of relative alarms support in vcal 1.

Futhermore, with the v8.7 of the Funambol BlackBerry client, it now uses vcal 1 instead of SIF-E for events.

When an event is returned that contains a relative AALARM, it'll be skipped by the client because of incorrectly input data.

I've pushed a fix for this - see:

https://sogo-connector.forge.funambol.org/source/browse/sogo-connector/trunk/src/java/ca/inverse/sogo/engine/source/SOGoUtilities.java?view=diff&pathrev=48&r1=47&r2=48

You can grab the Funambol SOGo Connector from SVN if you want to test it.

Basically, it'll convert relative alarms to absolute ones.

Can any of you guys test my fix from yesterday?

Thank you for making a fix available! Unfortunately, I have no idea how to build the funambol sogo connector package from the svn sources. Could you perhaps give a short description of the download and build process, or even better make the .s4j-file available? Thank you!

I've uploaded a s4j for testing.

Many thx. I'm waiting for my new android and will test it as soon as possible and report any issues.

I tested on Nokia S60 mobile. Synchronization of events from Sogo to mobile seems to work, reminders stay intact. For whole-day events, the mobile displays an absolute alarm time, for normal events, the mobile re-translates the absolute alarm into a relative setting in its display. This is fine.

However, synchronization of events created on the mobile to sogo does not work: Alarms are lost, and for one event, I can see the event in sogos web interface, but when double-clicking on it, "An error occurred during object publishing
the requested object could not be found!" appears (this was a repeating event, and not synced to the default calendar, but to a different one).

The sync tag used to be displayed in the event name on the syncml client. This changed, and the sync tags of events created in sogo are no longer displayed on the mobile.

Synchronization of events created on phones (that are absolute) will cause issue, this is issue 0000586.

As for the sync tag issue, I'm not sure I understand - please elaborate.

The sync tag issue:

If a user has two calendars, the standard personal calendar and another one called e.g. "test" (sync tag "t"), creates an event "meeting" in test and syncs it to the mobile, it used to show up there as "[t] meeting", indicating which calendar the item belongs to.
With the current version of the funambol connector, the event shows up as "meeting" on the mobile, the sync tag is no longer added to the event name.

Creating an event with name "[t] meeting" on the mobile and syncing it back to sogo creates the event in calendar "test" instead of the personal calendar. With the current connector, this still works, but at least sometimes, the event can not be opened or modified from the web interface. It appears in the overview (standard calendar view) in calendar "test", but cannot be opened. Instead, the error message "An error occured during object publishing. the requested object could not be found!" appears.

I cannot reproduce the tag issue nor the "An error occured during object publishing. the requested object could not be found!" error.

I don't have this problem with tags. Multiple calenders are synced great. What doesn't work are read-only calenders from groups but that's another problem.

These are the results of my test with svn_50 version of funambol-connector:

One good news and a bad one.

Good one:
Alarms work great on sogo-web and mobile if you create a new event with alarm and sync this event.

Bad one:
Editing the alarm of an existing event doesn't work neither on sogo-web nor mobile.
If you edit the alarm on mobile and sync it you still see the alarm clock in sogo-web but if you enter the event it says: "No reminder" :(
If you edit the alarm in web-interface and sync it to mobile you still see the previous alarm time.

As for "If you edit the alarm on mobile and sync it you still see the alarm clock in sogo-web but if you enter the event it says: "No reminder" :(", that's 0000586

As for "If you edit the alarm in web-interface and sync it to mobile you still see the previous alarm time.", that might be a bug in your mobile device. Look at the ds-server.log to see if the alarm is being updated. If so, like my testing showed, then it's a bug in your mobile device.

ok. I'll try it with outlook and funambol-plugin and report if it works better than with my mobile.

Hi, I've tested this (funambol-sogo-1.0.8.s4j (74,517 bytes) 2010-11-12 12:02) plugin.
And now I'm able to sync the reminder from the sogo web client and thunderbird to the outlook and my windows mobile 6.5 phone.

• sogo->funambol->outlook/mda = work
  But when I created the event with alarm (15 min. before) in the outlook or windows mobile 6.5 phone, I can see a event with reminder in the thunderbird, not like "15 min. before", but like "other" with correct time. But in the SOGo web client I still see "no reminder".
• outlook/mda->funambol->sogo(web) = noreminder
• outlook/mda->funambol->sogo(thunderbid) = work (but how "other" not like "15min. before)

configuration:

• sogo server 1.3.4 (64bit)
• funambol server 8.7 (64bit)
• thunderbird 3.1.6 (sogo extensions xy.104)
• outlook 2007 (funambol outlook sync client 9.0.20101026 - because of resolved bug with repeated events)
• htc hd2 (windows mobile 6.5) (funambol sync client v.8.7.2)

@dusanl: What about editing existing events?

Try to edit an event created on webinterface/thunderbird/mobile and outlook.
Edit it on all your platforms and sync it then report if it works.

Editing was a major problem for me! Creating new works relative good.

@wcronen: hi, so, I have tested editing existing events... And my resuls are attached here in "sogo-sync-edit.xls" file.

or here: :)
CREATED;sync_status;EDITREMINDER;sync(edit)_status
WEB;tb(ok),outlook(ok),mda(ok);TB;web(ok),outlook(ok),mda(ok)
WEB;tb(ok),outlook(ok),mda(ok);OUTLOOK;web(without_reminder),tb(old_reminder-no_changes),mda(ok)
WEB;tb(ok),outlook(ok),mda(ok);MDA;web(without_reminder),tb(old_reminder-no_changes),outlook(old_reminder-no_changes)

TB;web(ok),outlook(ok),mda(ok);WEB;tb(ok),outlook(ok),mda(ok)
TB;web(ok),outlook(ok),mda(ok);OUTLOOK;tb(old_reminder-no_changes),web(without_reminder),mda(old_reminder-no_changes)
TB;web(ok),outlook(ok),mda(ok);MDA;tb(old_reminder-no_changes),web(without_reminder),outlook(old_reminder-no_changes)

OUTLOOK;web(without_reminder),tb(other_reminder-not_like_5min.before),mda(ok);TB;outlook(ok),web(ok),mda(ok)
OUTLOOK;web(without_reminder),tb(other_reminder-not_like_5min.before),mda(ok);WEB;outlook(ok),tb(ok),mda(ok)
OUTLOOK;web(without_reminder),tb(other_reminder-not_like_5min.before),mda(ok);MDA;outlook(ok),tb(old_reminder-no_changes),web(without_reminder)

MDA;web(without_reminder),tb(other_reminder-not_like_5min.before),outlook(ok);web;mda(ok),tb(ok),outlook(ok)
MDA;web(without_reminder),tb(other reminder-not_like_5min.before),outlook(ok);TB;mda(ok),web(ok),outlook(ok)
MDA;web(without_reminder),tb(other_reminder-not_like_5min.before),outlook(ok);OUTLOOK;mda(ok),web(without_reminder),tb(without_reminder)

I hope it's help. I love this project.

Has some progress been achieved on this bug? I still would love to use SOGo, but need a reliably working event synchronization with my mobile...

I tested today again with the connector version attached to this bug. Reminders are transferred correctly from the server to the phone.
Things get broken when transferring events from the phone back to the server, this is likely bug 586. However, KDEs kontact (via caldav access) states that the event from the mobile has a reminder "at the end of the event" set.

I encountered another problem, though: Non recurring events created or edited on the mobile cannot be edited via KDE kontact (caldav access) after syncing them to the server. Instead, kontact states "unknown error" and some error message saying that only resources could edit this event.
The event can be edited through the web interface without problems.

Funambol is no longer supported.