Calendar: Difference between revisions
Emoji preservation efforts. |
finish uploading .ics wisdom |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 26: | Line 26: | ||
* Find ‘add calendar’ or equivalent | * Find ‘add calendar’ or equivalent | ||
* Use the same details as for Android/AOSP | * Use the same details as for Android/AOSP | ||
== Working with <code>.ics</code> 👹 == | |||
Concrete example: the waste disposal calendar from KELL shows the days when the bins are picked up. Sometimes those pick-ups are early, and the far safer option is put the bins out the day before. To move all the dates (except for the Schadstoffmobil!) is not trivial. Here's how we did it in towards the end of 2024: | |||
* Download the correct <code>.ics</code> from https://www.kell-gmbh.de/ (without Schadstoffmobil!) | |||
* Convert <code>.ics</code> to <code>.tsv</code> using https://github.com/loteoo/icsp | |||
* Open new <code>.csv</code> with LibreOffice | |||
* Ensure <code>DTSTART</code> and <code>DTEND</code> formats are set to date (YYYY-MM-DD) format | |||
* Make new <code>DTSTART</code> and <code>DTEND</code>columns for the adapted values | |||
** Formula: <code>=<original>-1</code> | |||
** Save file, close file, reopen again (to convert formula to data)\ | |||
* Delete original <code>DTSTART</code> and <code>DTEND</code> columns | |||
* Make sure the <code>DESCRIPTION</code> and <code>SUMMARY</code> are informative, an emoji at the beginning of the <code>SUMMARY</code> is especially nice! (e.g. ''"🟩 Put out Biotonne"''). Also, make sure that line lengths are under 75 characters long, or Nextcloud (Hub 9.0) will complain. | |||
* Convert <code>.tsv</code> to <code>.ics</code> | |||
* Copy <code>PRODID</code> and <code>VERSION</code> lines (2 & 3) from original <code>.ics</code> to between <code>BEGIN:VCALENDAR</code> and <code>BEGIN:VEVENT</code> (1 & 2) | |||
* Additionally, download just the Schadstoffmobil calendar and upload as is | |||
Watch out that you don't have any <code>UUID</code> clashes! (i.e. you will need to delete existing events if same events previously uploaded.) | |||
Latest revision as of 12:32, 20 November 2024
We host our own (CalDAV) calendar on our Nextcloud instance: https://cloud.kanthaus.online/apps/calendar
Calendars overview 📅
- main - Kanthaus events of relevance to most residents
- people - for recording visitor visiting times
- müll - waste collection dates from KELL
- festivals-events-etc - for external events that may be of interest to others
- Contact birthdays - automagically generated from birthdates in the ‘khontacts’ contact book
See planlos-leipzig.org for interesting events in Leipzig.
Android/AOSP phone access
- Download Davx5
- Recommended to download via F-droid
- Open Davx5, add new account, select “Login with URL and user name”,
- Base URL:
https://cloud.kanthaus.online - User name: <yourNextcloudUserName>
- Password: <yourNextcloudPassword>
- Base URL:
- Got to ‘Caldav’, select all calendars you want to sync
Laptop/computers
- Your calendar app should already have Caldav capabilities
- Find ‘add calendar’ or equivalent
- Use the same details as for Android/AOSP
Working with .ics 👹
Concrete example: the waste disposal calendar from KELL shows the days when the bins are picked up. Sometimes those pick-ups are early, and the far safer option is put the bins out the day before. To move all the dates (except for the Schadstoffmobil!) is not trivial. Here's how we did it in towards the end of 2024:
- Download the correct
.icsfrom https://www.kell-gmbh.de/ (without Schadstoffmobil!) - Convert
.icsto.tsvusing https://github.com/loteoo/icsp - Open new
.csvwith LibreOffice - Ensure
DTSTARTandDTENDformats are set to date (YYYY-MM-DD) format - Make new
DTSTARTandDTENDcolumns for the adapted values- Formula:
=<original>-1 - Save file, close file, reopen again (to convert formula to data)\
- Formula:
- Delete original
DTSTARTandDTENDcolumns - Make sure the
DESCRIPTIONandSUMMARYare informative, an emoji at the beginning of theSUMMARYis especially nice! (e.g. "🟩 Put out Biotonne"). Also, make sure that line lengths are under 75 characters long, or Nextcloud (Hub 9.0) will complain. - Convert
.tsvto.ics - Copy
PRODIDandVERSIONlines (2 & 3) from original.icsto betweenBEGIN:VCALENDARandBEGIN:VEVENT(1 & 2) - Additionally, download just the Schadstoffmobil calendar and upload as is
Watch out that you don't have any UUID clashes! (i.e. you will need to delete existing events if same events previously uploaded.)