Calendar - Revision history

Liou: /* Adapting the KELL (waste disposal) calendar */

2025-12-30T23:33:49Z

Adapting the KELL (waste disposal) calendar

← Older revision		Revision as of 01:33, 31 December 2025
Line 38:		Line 38:
	** Formula: <code>=<original>-1</code>		** Formula: <code>=<original>-1</code>
	** Saved file, closed file, reopened again (to convert formula to data)		** Saved file, closed file, reopened again (to convert formula to data)
			*** 2025: worked better without saving inbetween: copy the column and special paste it so it does only contain values
	* Deleted original <code>DTSTART</code> and <code>DTEND</code> columns		* Deleted original <code>DTSTART</code> and <code>DTEND</code> columns
	* Made sure the <code>DESCRIPTION</code> and <code>SUMMARY</code> were 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.		* Made sure the <code>DESCRIPTION</code> and <code>SUMMARY</code> were 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.
	* Converted <code>.tsv</code> to <code>.ics</code>		** Note from end 2025: Calc had some struggle properly saving unicode symbols. In the end it was done using a text editor.
			* Converted <code>.tsv</code> to <code>.ics</code>, using the argument -r
	* Copied <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)		* Copied <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, downloaded just the Schadstoffmobil calendar and uploaded as is		* Additionally, downloaded just the Schadstoffmobil calendar and uploaded as is
			** Note from 2025: Experience showed that we ignore the Schadstoffmobil, so it was decided not to add it to the main trash calendar. If having the dates is important to someone, please create an extra (shared) calendar

	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.)		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.)
	[[Category:Digital]]		[[Category:Digital]]
	[[Category:Social]]		[[Category:Social]]

Doug: /* Working with .ics 👹 */ Rename section to make it concrete, copyedit.

2025-12-15T14:54:52Z

Working with .ics 👹: Rename section to make it concrete, copyedit.

← Older revision		Revision as of 16:54, 15 December 2025
Line 27:		Line 27:
	* Use the same details as for Android/AOSP		* Use the same details as for Android/AOSP

	== ~~Working with <code>.ics</code> 👹~~ ==		== Adapting the KELL (waste disposal) calendar ==
	~~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:		The waste disposal calendar from KELL shows the days when the bins are picked up. Sometimes those pick-ups are quite early, and the safer option is to put the bins out the day before. To move all the dates is not trivial. Here's how we did it towards the end of 2024:

	* ~~Download~~ the correct <code>.ics</code> from https://www.kell-gmbh.de/ ~~(without Schadstoffmobil!)~~		* Downloaded the correct <code>.ics</code> from https://www.kell-gmbh.de/
	* ~~Convert~~ <code>.ics</code> to <code>.tsv</code> using https://github.com/loteoo/icsp		* Converted <code>.ics</code> to <code>.tsv</code> using https://github.com/loteoo/icsp
	* ~~Open~~ new <code>.csv</code> with LibreOffice		* Opened new <code>.csv</code> with LibreOffice
	* ~~Ensure~~ <code>DTSTART</code> and <code>DTEND</code> ~~formats are~~ set to ~~date (~~YYYY-MM-DD) format		* Deleted Schadstoffmobil entries (Since you need to go at the exact time for this)
	* ~~Make~~ new <code>DTSTART</code> and <code>DTEND</code>columns for the adapted values		* Ensured <code>DTSTART</code> and <code>DTEND</code> columns were set to <code>YYYY-MM-DD</code> format
			* Made new <code>DTSTART</code> and <code>DTEND</code> columns for the adapted values
	** Formula: <code>=<original>-1</code>		** Formula: <code>=<original>-1</code>
	** ~~Save~~ file, ~~close~~ file, ~~reopen~~ again (to convert formula to data)\		** Saved file, closed file, reopened again (to convert formula to data)
	* ~~Delete~~ original <code>DTSTART</code> and <code>DTEND</code> columns		* Deleted 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.		* Made sure the <code>DESCRIPTION</code> and <code>SUMMARY</code> were 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>		* Converted <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)		* Copied <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		* Additionally, downloaded just the Schadstoffmobil calendar and uploaded 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.)		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.)
	[[Category:Digital]]		[[Category:Digital]]
	[[Category:Social]]		[[Category:Social]]

Janina at 10:52, 29 January 2025

2025-01-29T10:52:06Z

← Older revision		Revision as of 12:52, 29 January 2025
Line 44:		Line 44:

	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.)		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.)
			[[Category:Digital]]
			[[Category:Social]]

Doug: finish uploading .ics wisdom

2024-11-20T11:32:13Z

finish uploading .ics wisdom

← Older revision		Revision as of 13:32, 20 November 2024
Line 30:		Line 30:
	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:		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/		* 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		* Convert <code>.ics</code> to <code>.tsv</code> using https://github.com/loteoo/icsp
	* Open new <code>.csv</code> with LibreOffice		* Open new <code>.csv</code> with LibreOffice
Line 38:		Line 38:
	** Save file, close file, reopen again (to convert formula to data)\		** Save file, close file, reopen again (to convert formula to data)\
	* Delete original <code>DTSTART</code> and <code>DTEND</code> columns		* Delete original <code>DTSTART</code> and <code>DTEND</code> columns
	* Convert <code>.tsv</code> to <code>.ics</code> ~~using https://github.com/loteoo/icsp~~		* 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)		* 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.)		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.)

	~~Improvement: it is possible to add emojis to title, so next time ''"🟩 Put out Biotonne"'' could be cool!~~

Doug: Add improvement suggestion

2024-11-20T11:12:41Z

Add improvement suggestion

← Older revision		Revision as of 13:12, 20 November 2024
Line 42:		Line 42:

	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.)		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.)

			Improvement: it is possible to add emojis to title, so next time ''"🟩 Put out Biotonne"'' could be cool!

Doug: Initial section on .ics wrangling

2024-11-20T11:02:40Z

Initial section on .ics wrangling

← Older revision		Revision as of 13:02, 20 November 2024
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/
			* 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
			* Convert <code>.tsv</code> to <code>.ics</code> using https://github.com/loteoo/icsp
			* 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)

			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.)

Worldsdweller: Emoji preservation efforts.

2024-10-18T10:25:07Z

Emoji preservation efforts.

← Older revision		Revision as of 12:25, 18 October 2024
Line 1:		Line 1:
	We host our own (CalDAV) calendar on our Nextcloud instance: https://cloud.kanthaus.online/apps/calendar		We host our own (CalDAV) calendar on our Nextcloud instance: https://cloud.kanthaus.online/apps/calendar

	== Calendars overview ~~:calendar:~~ ==		== Calendars overview 📅 ==

	* '''main''' - Kanthaus events of relevance to most residents		* '''main''' - Kanthaus events of relevance to most residents

Worldsdweller: Post-migration cleanup

2024-10-16T08:22:42Z

Post-migration cleanup

← Older revision		Revision as of 10:22, 16 October 2024
Line 1:		Line 1:
	~~= :calendar: Calendar =~~

	We host our own (CalDAV) calendar on our Nextcloud instance: https://cloud.kanthaus.online/apps/calendar		We host our own (CalDAV) calendar on our Nextcloud instance: https://cloud.kanthaus.online/apps/calendar

	== Calendars overview ==		== Calendars overview :calendar: ==

	* '''main''' - Kanthaus events of relevance to most residents		* '''main''' - Kanthaus events of relevance to most residents

HandbookMigration2024: "migration of handbook pages from https://git.kanthaus.online/kanthaus/handbook"

2024-10-15T10:54:51Z

"migration of handbook pages from https://git.kanthaus.online/kanthaus/handbook"

New page

= :calendar: Calendar =

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 [https://kell-gmbh.de/service/pdf-kalender/ 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 [https://www.planlos-leipzig.org/ planlos-leipzig.org] for interesting events in Leipzig.

== Android/AOSP phone access ==

* Download [https://www.davx5.com/ Davx5]
** Recommended to download via [https://f-droid.org/packages/at.bitfire.davdroid/ F-droid]
* Open Davx5, add new account, select “Login with URL and user name”,
** Base URL: <code>https://cloud.kanthaus.online</code>
** User name: <yourNextcloudUserName>
** Password: <yourNextcloudPassword>
* 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