Synchronize Lotus Notes to ownCloud

[FordPrefect]

Inspired by this project I have started to work on a sync tool implemented in Java.

The goal is to write the calendar data of a Lotus Notes user file to my ownCloud instance. A straight forward very simple basic version is ready. It just dumb writes the Notes entries to ownCloud without taking care if the event is already existing or not. Just wanted to kind of proof that building a communication channel all the way from Lotus Notes to ownCloud is possible.

Now I'm trying to expand this to really compare the two calendars and only update the information that has changed. Further down the road, two-way sync could be made possible. In laying out the architecture I also set the grounds for syncing contact and todo entries.

Just wanted to share this little piece information. I am curious to see whether this would be of general interest or if it's just me trying to "pair" Lotus Notes with ownCloud.

Cheers!

[diesseits]

Absolutely, yes! There are a lot of people stuck with using Lotus Notes with all its problems. I use GooCalSync to sync to a google calendar, but an OwnCloud sync would be just as useful.

[FordPrefect]

Absolutely, yes! There are a lot of people stuck with using Lotus Notes with all its problems. I use GooCalSync to sync to a google calendar, but an OwnCloud sync would be just as useful.

Obviously this is also where I'm coming from. Now that ownCloud is around, I wanted to have a "google free" setup. Sharing the contacts and calendars between PC, notebook, tablet and Android phone is working properly. The only missing piece is (soon to be 'was'!) the link between Lotus Notes to ownCloud to get my work related data into this system.

Still working on this in my free time. Right now I am able to read the ownCloud entries into the application. The remaining task is to compare these events with the ones coming from Lotus Notes. The 'dumb' writing is done as mentioned in my first post. But still missing a piece of code that allows me to update existing events, as opposed to delete and re-create them. As soon as there is some useable version, I will keep posting

[eMarcus]

Hi,

That would be exactly what I am looking for!

I would be also happy to support, although I am neither a Notes nor a big software developer geek. I did a sync engine for the Lotus Notes Contacts with Ubuntu's CouchDB - if you want to reuse some code, just let me know!

bye
Marcus.
P.S. And PLEASE keep me posted, I am starving for that missing tool!

[FordPrefect]

Quick update:
Was struggling for a while with non-standard timezone IDs coming from Lotus Notes. Guess this is finally resolved now with the help of a mapping table that can be configured as a file. Reading ownCloud entries falling into a (configurable) sync interval is done.

Next steps:
Identify entries that are existing in both, Lotus Notes and ownCloud.

[vegetto]

Hi,

I would also be interested! At the moment I use http://lngooglecalsync.sourceforge.net/ to sync to a Google calendar but I do not want to share important information to a server I do not own.

I intended to modify the code of lngooglecalsync (java open source tool) to sync to a caldav calendar instead. The owner of the project is interested in doing this but none of us found the time yet. You might want to take a look at his tool and either submit a patch or get some ideas.

[FordPrefect]

Hi,

I would also be interested! At the moment I use http://lngooglecalsync.sourceforge.net/ to sync to a Google calendar but I do not want to share important information to a server I do not own.

I intended to modify the code of lngooglecalsync (java open source tool) to sync to a caldav calendar instead. The owner of the project is interested in doing this but none of us found the time yet. You might want to take a look at his tool and either submit a patch or get some ideas.

Hi vegetto,
thanks for the hint. I am in touch with him already. In fact I'm using the Lotus Notes part of the LN GoogleCalSync with some minor tweaks and attached the CalDAV as an additional connector. We have initially discussed of possibly merging everything together at a later point in time.

As for the matters, vacation time slowed me down a little. I will re-start working on this soon. The basic (one way) sync seems to work, but still fighting issues with more complex items like repeats, all-day events and time zone issues.

Cheers!

[vegetto]

Cool!

I personally would just be interested in the one-way Notes -> owncloud sync: I would be scared of making automatic changes to my work calendar. If you need a tester for this, please let me know. If not I hope that I can at least invite you a bier

[james007]

Hi, I've decided to modify lngooglesync app to connect to owncloud first, and any other caldav standard after.
I've already modified the GUI of the tool,
But that's the first time I use owncloud with httpclient java library.
I try to connect to owncloud caldav, but i have always the same error

<?xml version="1.0" encoding="utf-8"?>
<d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns">
<s:exception>Sabre_DAV_Exception_NotAuthenticated</s:exception>
<s:message>No basic authentication headers were found</s:message>
<s:sabredav-version>1.6.6</s:sabredav-version>
</d:error>

Does anyone have an idea ?

@FordPrefect, can you send me what you've already done on this subject ?


Think you all for your help
James

[Rancor]

Check this FAQ entry about your "No basic authentication headers were found" error (can be found via the forums search):

viewtopic.php?f=17&t=7536