import shopping / calendar entries from sepia into nextcloud

[royrogermcfreely]

Hello all,

thats my first "tutorial". most of the stuff was copy&paste and try/error.
and its working for me. can be that you have to adapt it for your needs.
my sepia server runs on a proxmox debian vm

you will need a nextcloud app-id passwort if you use 2FA

prepare sepia vm:

you will need the following stuff:

sudo apt install python3-venv python3-pip
sudo pip3 install caldav

i created a folder for my scripts "python_scripts"

create a new file and name it for example "importsepiatask.py" with the following code:

from urllib.request import urlopen
import json
import sys
import requests
from datetime import datetime, date
sys.path.insert(0, '..')
sys.path.insert(0, '.')
import caldav

caldav_url = 'https://YOUR-URL/remote.php/dav'
username = 'USER'
password = 'AppPasswort'
ssl_verify_cert = False

client = caldav.DAVClient(url=caldav_url, username=username, password=password, ssl_verify_cert = False)
# i need to ssl_verify_cert = false cause i have troubles with cert.

my_principal = client.principal()

## Let's try to find or create a calendar ...
try:
    ## must be the name of the tasklist
    my_new_calendar = my_principal.calendar(name="shoppinglist")
    assert(my_new_calendar)
    ## calendar did exist, probably it was made on an earlier run
    ## of this script
except caldav.error.NotFoundError:
    print("no list found") 
    # could create tasklist with:
    #my_new_calendar = my_principal.make_calendar(name="my_new_tasklist")

headers = {
    'Content-Type': 'application/json',
}

data = '{"GUUID": "uid1007", "PWD": "PASSWORD", "client": "b1", "device_id": "b1", "get": {"lists":[{"section": "productivity", "indexType": "shopping"}]}}'
url = 'http://SEPIA-URL:20721/userdata'
response = requests.post(url, headers=headers, data=data)

json_data = response.json()
list = json.loads(response.text)

array = list['get_result']['lists'][0][0]['data']

#get the values for the VTODO
taskname = [ sub['name'] for sub in array]
taskuid = [ sub['itemId'] for sub in array]
taskdate = [ sub['dateAdded'] for sub in array]

#put the values together
d = {'data': [{'taskname': a, 'taskuid': b, 'taskdate': c} for a, b, c in zip(taskname, taskuid, taskdate)]}

for x in d['data']:
  my_event = my_new_calendar.save_todo("""BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Example Corp.//CalDAV Client//EN
BEGIN:VTODO
UID:""" + x['taskuid'] + """@URL
SUMMARY:""" + x['taskname'] + """
STATUS: NEEDS-ACTION
END:VTODO
END:VCALENDAR
""")

#############################################
##### DELETE shopping items in sepia ###########
########################
id = json_data['get_result']['lists'][0][0]['_id'] 
datadelete = '{"GUUID": "uid1007", "PWD": "PASSWORD", "client": "b1", "device_id": "b1", "delete": {"lists":[{"section": "productivity", "indexType": "shopping", "group":"todo", "title": "Einkaufen", "_id" : "%s", "type": "userDataList", "user": "uid1007"}]}}'%id
delete = requests.post(url, headers=headers, data=datadelete)

for the calendar entries i made a new file "importsepiacalendar.py" with this code:

from urllib.request import urlopen
import json
import sys
import requests
from datetime import datetime, date
sys.path.insert(0, '..')
sys.path.insert(0, '.')
import caldav

caldav_url = 'https://NEXTCLOUD-URL/remote.php/dav'
username = 'nextclouduser'
password = 'APP Password'
ssl_verify_cert = False

client = caldav.DAVClient(url=caldav_url, username=username, password=password, ssl_verify_cert = False)
my_principal = client.principal()
try:
    ## This will raise a NotFoundError if calendar does not exist
    my_new_calendar = my_principal.calendar(name="personal")
    assert(my_new_calendar)
    ## calendar did exist, probably it was made on an earlier run
    ## of this script
except caldav.error.NotFoundError:
     print("no calendar found")
     ##  create a calendar
    #my_new_calendar = my_principal.make_calendar(name="Test calendar")

headers = {
    'Content-Type': 'application/json',
}

data = '{"GUUID": "uid1007", "PWD": "SepiaPasswort", "client": "b1", "device_id": "b1", "get": {"lists":[{"section": "timeEvents", "indexType": "alarms"}]}}'
url = 'http://SEPIA-URL:20721/userdata'
response = requests.post(url, headers=headers, data=data)

json_data = response.json()
print("====================")
for x in json_data['get_result']['lists'][0][0]['data']:
 print(x['name'])
 start = x['targetTimeUnix'] / 1000
 start = start - 3600
 end = start + 3600
 start = datetime.fromtimestamp(start).strftime('%Y%m%dT%H%M%S')
 end = datetime.fromtimestamp(end).strftime('%Y%m%dT%H%M%S')
 start = start + "Z"
 end = end + "Z" 
 my_event = my_new_calendar.save_event("""BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Example Corp.//CalDAV Client//EN
BEGIN:VEVENT
UID:""" + x['eventId'] +"""@URL
DTSTAMP:"""+ start+"""
DTSTART:"""+start + """
DTEND:""" + end +"""
SUMMARY:""" + x['name'] + """
END:VEVENT
END:VCALENDAR
""")

#########################
##########Delete from sepia ##########
########
id = json_data['get_result']['lists'][0][0]['_id'] 

datadelete = '{"GUUID": "uid1007", "PWD": "Password", "client": "b1", "device_id": "b1", "delete": {"lists":[{"section": "timeEvents", "indexType": "alarm", "group":"todo", "title": "Wecker", "_id" : "%s", "type": "userDataList", "user": "uid1007"}]}}'%id
delete = requests.post(url, headers=headers, data=datadelete)

i created a cronjob for each script to start the script every 10 minutes with:

crontab -e
*/10 * * * * /usr/bin/python3 /home/sepia/python_scripts/importsepiatermine.py
*/10 * * * * /usr/bin/python3 /home/sepia/python_scripts/importsepiatask.py

so every 10 minutes the script looks if there are new alarms / shopping entries. get a array from them, import it to nextcloud and delete it in sepia.
i delete it in sepia because for the next time i dont have to search which entry is allready synct and which not.

to ask sepia for the next events / shopping entries, i will make another thread cause i need HomeAssistant for that but im pretty sure you can use OpenHab or FHEM too.

[fquirin]

Awesome! Thanks for this great contribution 🥇 😀 .
I don't have a Nextcloud instance right now for testing but I'll try to change that soon ;-)

[royrogermcfreely]

you connect via caldav - so i think you can use it with everything else like google too :)