Automatically delete old calendar events

[Dreamsorcerer]

It would be good to have a setting to automatically delete old calendar events (e.g. events older than 3 months).

This both helps clean up the calendar by reducing the amount of (unneeded) data stored, and improves privacy in the circumstance that a server or account is compromised, ensuring that the user's long-term history is cleared.

[nextcloud-bot]

GitMate.io thinks possibly related issues are #4451 ("Delete Calendar" Issue), #3014 (Calendar event invitation automatically creates a new 'personal' calendar), #3830 (No calendar invitation send for event in shared calendars ), #8246 (Updater fails to complete (step Delete old files)), and #2576 (Failed to create tasks- or events-only calendars from DAVdroid).

[skjnldsv]

@georgehrke does it make sense?
Feels like a not-so-useful feature 🙈

[georgehrke]

I would be okish with having an occ command that does this job that you can call like once a month via cron to cleanup, but a very big 👎 for automatic deleting by default.

[georgehrke]

As this sounds like a nice feature, the requests for this are quite low. Currently there are no plans to implement such a feature. Thus I will close this ticket for now. This does not mean we don't want this feature, but it is simply not on our roadmap for the near future. If somebody wants to implement this feature nevertheless we are happy to assist and help out.

If you wish to have this feature implemented by the Nextcloud GmbH there is the option for consulting work on top of your Nextcloud Enterprise subscription to get your features implemented.

[Dreamsorcerer]

@georgehrke Nobody said by default, I suggested an optional feature for the user to enable if they want to have old events automatically cleaned up.

As I mentioned it can improve privacy, and it can reduce the amount of data that needs to be synced between devices.

[Mululu]

Is there any news on this yet?

It would be a good feature because with a large calendar over several years, the data to be synchronized is increasing.

[NeoTheThird]

Could we get this re-opened? This should definitely be a feature. Not everyone wants to keep ten years worth of calendar history.

[frenkert3243]

I would like to request this to be re-opened, I really could use such a feature.

[Pakbon]

I can also definitely use such a feature, especially if it's an occ

[readonly24]

Please reopen, my calendars are growing and the MySQL database size is limited by my hoster.

No automatic mode, just an occ command

[Coernel82]

I would be happy with a reopen too however as a work around:
What about a bash script selecting old entries from the database and deleting them? There are drafts for those command lines on Stackoverflow.
Other option: In Thunderbird or your other handy calendar display program select and delete and then sync again?

[p5n]

Does anybody know is it enough to clear

• oc_schedulingobjects
• oc_calendarobjects_props
• oc_calendarobjects
  tables which are connected by etag and objectid?

Probably I want to implement such feature in shell script.

I see many queries SELECT "uri", "calendardata", "lastmodified", "etag", "size" FROM "oc_schedulingobjects" WHERE "principaluri" = $1
is it expected behaviour?

DB contains 400+ users and 1 600 000+ scheduling objects.

[p5n]

$ time echo "select * from oc_schedulingobjects where principaluri='principals/users/USERNAME';" | psql -U nextcloud nextcloud >/dev/null
real	0m2.795s
user	0m2.586s
sys	0m0.090s

probably something goes wrong

[manuelkamp]

I would also like to have this feature (occ is fine)

[horga83]

No occ is not fine, there should be a way to purge old calendar events via the UI.
Normal users have no access to occ.

[viisauksena]

many use calendar in (semi)work environment - therefore it is not apropiate to save event data over the years. Would be nice to have an option like 'delete all (not still repeating) events older than xy'