Using open source power calDav cardDav etc

wojosc · October 12, 2016, 7:56pm

Already having a server for e-mail, calendars, tasks etc. I really would like to have to maintain two of the kind at the same time. It would be great if it were possible to sync calenders and tasks (the ones found in project for example) to be syncronised with an existing calDav/cardDav server to be able to have tasks and dates be shown in Thunderbird or on my android phone without having to use a special app like the ERPNext app. The app is great, but as it is not really integrated with the rest of my work and organizational habbits I can’t really make use of it.

I’m sure I’m not the only one keen for this feature. Please tell me what I can do to help, thank you!

Krischan · October 14, 2016, 4:02am

This would be indeed great (also to sync with other supporting systems like Nextcloud). I think it has been requested several times and some people even proposed to put out a bounty for it.

Maybe one of the main developers with some interest in working on this could quote a sum and we can crowd-source funding for it?

wojosc · October 14, 2016, 9:24am

Yes, nextcloud sync, also for backup purpose (different subject) is very interesting. We also would be happy to through some € toward this idea!

hwinkel · November 8, 2016, 9:03pm

would strongly agree to have CalDAV and CardDAV in here. In my experience the Protocol is not the issue in general. But having the mapping of the Contact data in relation with the companies could be interesting. Further handling of multiple entries for phone numbers emails etc.

fmorato · January 24, 2017, 12:10am

Would be great to have caldav integration! Any efforts toward that?

wojosc · June 20, 2017, 9:41am

Getting to know ERPNext a little better I can see why it is a brave endevour to take on calander-sync to an external device with calDav. As a lot of “things” inside ERPNext are calender or event related. For example tasks in projects and the project itself and all timesheets connected to it could all be calDav items. These then again are connected to users and other items like projects tasks and customers. I can see this beeing very tricky when sharing and setting permissions. Also I think no one would like to have 100+ calendars to chose from on his phone or inside thunderbird.
A baby step I would like to suggest though is to implement *.ics attachments for maybe just a few items. The idea is, that when I for example create a ToDo for someone there is a *.ics attached which he can then again load into his program or device of choice. Any ideas on that?
Unfortunatelly I can only provide on hand experience but no coding effort.

revant_one · June 20, 2017, 9:59am

ICS generation for Doctypes with Calendar support can be mapped.
Possibly using _calendar.js to map .ics and event data.

http://icalendar.readthedocs.io/en/latest/usage.html#example

Add github Issue

Krischan · October 20, 2018, 6:24pm

Has there ever been any progress on this?

wojosc · October 23, 2018, 12:13pm

not yet no. I have had a look at the data migration tool. It should probably be possible to do this but we have not got the necessary recources to go ahead right now. I’ll let you all know if make any progress.

idao · August 20, 2019, 8:23am

I’m also very interested in this, nextcloud integration would be awesome!
I may provide some funding for that

wojosc · January 12, 2020, 11:36am

Hey @idao I’d like to advance in the project “nextcloud integration” I guess this could be fairly easy as nextcloud is jsut like ERPNext a very modern product. I found this: https://docs.nextcloud.com/server/stable/developer_manual/app/requests/api.html?highlight=rest

Maybe a developer can comment on this.

@rmeyer @itsdave @joelios @lasalesi

Does any have any experience on pushing a project like this with bountys etc. to get this into core. @Basawaraj_Savalagi maybe you can give a a hint?

Best
Wolfram

lasalesi · January 13, 2020, 7:22am

We have done calDav feeds based on data from ERPNext. For example, this is a simple public calendar feed:

github.com

libracore/firetesting/blob/master/firetesting/fire_testing/utils/calendar.py

# -*- coding: utf-8 -*-
# Copyright (c) 2018, libracore and contributors
# For license information, please see license.txt
#
# call the API from
#   /api/method/firetesting.fire_testing.utils.calendar.download_calendar?secret=[secret]
#

from icalendar import Calendar, Event
from datetime import datetime
import frappe

def get_calendar(secret):
    # check access
    enabled = frappe.db.get_value("Calendar Sync Settings", "Calendar Sync Settings", "enabled")
    if float(enabled) == 0:
        return
    erp_secret = frappe.db.get_value("Calendar Sync Settings", "Calendar Sync Settings", "secret")
    if not secret == erp_secret:
        return

This file has been truncated. show original

As you describe, the mapping is the part which is customized/individual…

wojosc · January 13, 2020, 7:36am

Hi Lars,

thank you for sharing. Is this something I am able to install and test? Do you provide some kind of documentation anywhere?

Best
Wolfram

lasalesi · January 13, 2020, 9:49am

Sure, you can install the app (I propose in a test environment) using the standard commands

$ bench get-app https://githu.com/libracore/firetesting.git
$ bench install-app firetesting

Documentation is limited Set a calendar secret in the settings, then use the endpoint to access the calendar. You can also copy the relevant code to your own app and use it from there…

wojosc · January 15, 2020, 9:35am

Hi @lasalesi do you have this somewhere installed where you can show me via a quick demo?

Best

itsdave · January 15, 2020, 9:40pm

@wojosc i just stumbled over this:

Not sure if it has something you are looking for, though.

clarkej · January 15, 2020, 9:44pm

To add context to your reference Document and Archiving System - #12 by woakes070048

wojosc · January 15, 2020, 11:16pm

Thank you Dave! This might be exsactly what we are looking for. I have just sent an e-mail to the developer. I’ll get back to you with any news on the subject.

lasalesi · January 16, 2020, 7:35pm

do you have this somewhere installed where you can show me via a quick demo?

sure, remind me next week

pipiapp

Maybe not the optimal name for an app , but the description sounds very interesting, will also have a look into this… Seems to be straightforwar integrating the WebDav…

wojosc · December 17, 2020, 10:52am

Thank you. I am just talking to @joelios and will be installing this on our test server.

For everyone else:

firetesting is not the function itself but an app including the required functionality. What libracore has built is a python file will calls a function on a iCal library which needs to be installed on your server first. This function collects information from a given docType (in this case Event) an puts all the information from events marked “public” into an iCal-feed.

Further there is a docType which should be created to be able to set some settings on a UI. For the moment this needs to be done by hand.

Having all this done you will be able to subscribe to an iCal-feed in any compatible calendar-app like, thunderbird, outlook, apples calendar etc.

The calendar is a one-way sync from your erpnext instance to you calendar.