Using open source power calDav cardDav etc

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.

lasalesi · December 22, 2020, 6:38am

Sounds good. Yes, firetesting is one module that that an inbuilt calDav support (as a calendar feed of the public “Event” records). As there are meny things from ERPNext that can be fed into calendars (refer to the calendar view) and even tasks are nicely deployed using calDav, there is quite a variety of similar feeds around (which is why they are typically built into an app along with other customisations)…

Maybe there is an generic application worthwile to be integrated in the core.

wojosc · December 25, 2020, 11:04am

Merry Christmas to you all!

So we have bundled the function in an app at GitHub - joelios/iCalFeed

I have taken the time to test with Thunderbird and Apples Calendar. Works as expected.

Here are some screenshots:

Go to Settingspage:

and setup basic configuration

The highlighted fields will be parsed to your feed. (+Date & Time)

Apple Calendar:

Thunderbird (on macOS):

So you can see, that it will do what it should but needs a little optimization here and there.

@Basawaraj_Savalagi fyi

You all have a nice holiday!

carsten · December 27, 2020, 11:55am

Awesome.

Has there been any work done for contacts? This is actually much more important for us than events - knowing who’s calling you on your phone. CardDav? Microsoft 365 integration?

f_deryckel · December 27, 2020, 12:31pm

thanks @wojosc for sharing this.
Just wondering how are password stored in the db? in clear?
Could any IT administrator for the frappe/erpnext site have access to these password if put in the database?

Thanks.

wojosc · December 29, 2020, 5:35am

yes, at seen in this screen:

Passwords stay visible here and form the end of the URL you subscribe to.

wojosc · December 29, 2020, 5:36am

It’s on our list, yes.

charleslcso · March 12, 2023, 11:45am

@wojosc any update on carddav?

wojosc · March 13, 2023, 6:57am

no real news, no. We are now looking to do a *.ics attachment to be able to create calendar entries as a first step. Expecting to have this done in the next few weeks maybe. Stay tuned.

charleslcso · March 13, 2023, 8:32am

I wonder if it is difficult to code the U part of CRUD in Contacts. Doing iCal should be more straight toward. May be.

As ERPNext nor Frappe has built-in carddav or Candace server, I guess it is inevitable to pass this work via 3rd party such as Radicale.

wojosc · March 13, 2023, 11:48am

In general I guess the first decision that needs to be made is:

#1 ERPNext is your cal/card DAV Server
#2 ERPNext is just a client syncing with a third-party server (this is kind of implemented with google contacts and calendar)