| colorlinks | links-as-notes |
|---|---|
true |
true |
forked from talmage/fixdavicalics
-
Notifications
You must be signed in to change notification settings - Fork 0
Fix the ICS files that PostgreSQL creates when you export calendars from DAViCal
License
phgrau/fixdavicalics
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
The fixdavicalics project contains instructions, a shell script, and an AWK script for exporting ics files from DAViCal and correcting them so that NextCloud can import them.
DAViCal's export facility creates incorrect ics files. They must be corrected using an editor, then processed with the AWK script to create an ics file that NextCloud can import.
As the user postgres in the directory /tmp, do these things.
These instructions are from the per user ics/vcard export instructions on the DAViCal wiki
psql davical -Atc "SELECT array_to_string(array(SELECT caldav_data FROM caldav_data WHERE dav_name LIKE '/talmage/addresses/%'),'');" > talmage_addressbook.vcf
psql davical -Atc "SELECT array_to_string(array(SELECT caldav_data FROM caldav_data WHERE dav_name LIKE '/talmage/calendar/%'),'');" > talmage_calendar.ics
psql davical -Atc "SELECT array_to_string(array(SELECT caldav_data FROM caldav_data WHERE dav_name LIKE '/talmage/workCalendar/%'),'');" > workCalendar.ics
psql davical -Atc "SELECT array_to_string(array(SELECT caldav_data FROM caldav_data WHERE dav_name LIKE '/talmage/churchCalendar/%'),'');" > churchCalendar.ics
psql davical -Atc "SELECT array_to_string(array(SELECT caldav_data FROM caldav_data WHERE dav_name LIKE '/talmage/datesOfNote/%'),'');" > datesOfNote.ics
awk -f icsfiltercalendars.awk < talmage_calendar.ics > talmage_calendar_filtered.ics
awk -f icsfiltercalendars.awk < workCalendar.ics > workCalendar_filtered.ics
awk -f icsfiltercalendars.awk < churchCalendar.ics > churchCalendar_filtered.ics
awk -f icsfiltercalendars.awk < daysOfNote.ics > daysOfNote_filtered.ics
About
Fix the ICS files that PostgreSQL creates when you export calendars from DAViCal
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published
Languages
- Awk 78.1%
- Shell 21.9%