Notes, hacks, ...


OwnCloud Internet Calendar for M$ Outlook

The OwnCloud calendar can export .ics (“internet calendar”) files that M$ Outlook (and other software) can display. The following cronjob calls the calendar export function and stores an .ics file.

0 * * * * /usr/bin/wget -O- -q --no-cache --http-user=USERNAME --http-password=PASSWORD "https://HOSTNAME/index.php/apps/calendar/export.php?calid=ID" > /path/to/the/owncloud/webroot/SOMESECRETFILENAME.ics

Replace USERNAME and PASSWORD with the OwnCloud login credentials, replace HOSTNAME with the host name where OwnCloud runs, and replace and ID with the calendar’s id (get the full URL from the “export” link in the calendar app as these URLs change sometimes with newer Owncloud versions). /path/to/the/owncload/webroot/SOMESECRETFILENAME.ics is where the resulting .ics file goes in the OwnCloud top level directory.

In Outlook add the internet calendar using http://HOSTNAME/SOMESECRETFILENAME.ics.

Pro tip: click the left arrow in the Outlook calendar tab and it will “merge” it with your main calendar.

And similarly you can export the contacts as a .vcf file: wget -O- -q --no-cache --no-check-certificate --auth-no-challenge --no-clobber --http-user=USERNAME --http-password=PASSWORD "https://HOSTNAME/remote.php/carddav/addressbooks/USERNAME/contacts?export" > /path/to/the/owncloud/webroot/SOMESECRETFILENAME.vcf

Note that on multi-user systems you may want to use the ~/.netrc file instead of the --http-user and --http-password option (see wget man page). Depending on how the system is setup other users may see the process and it’s command line arguments while it’s running. Also, make sure umask is set such that the SOMESECRETFILENAME files have adequate permissions.

Export Google Maps Starred Locations (a.k.a. Bookmarks) to KML, GPX

See Also