Ask / Submit
13

Delete all entries from a calendar

asked 2014-10-17 00:03:22 +0300

nomeata gravatar image

The system provides a way to delete all contacts. There should also be a way to delete all calendar entries.

(This is especially important when trying to reset the calendar to get syncevolution going again.

edit retag flag offensive close delete

2 Answers

Sort by » oldest newest most voted
7

answered 2015-06-16 22:18:07 +0300

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

updated 2015-06-16 22:18:07 +0300

luen gravatar image

HOWTO: The manual way

You need root access and will manually edit the SQLite database storing the calendar data, so please be careful and use at your on risk.

Before you start, close the calendar application, then in a shell on the phone, for example by logging in via SSH, switch to root mode:

devel-su

Start SQLite with the database filename as parameter:

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db

In the SQLite shell, list the available calendars:

SELECT * FROM Calendars;

That will give you a list of the calendars, for example

088f1e00-c071-4370-a435-d659ebd6580e|Default||#0000FF|663|0|||-1|1434371508|||1384941700||

The first column is the calendar ID and the second is the human-readable calendar name.

Optional: if you want to list the calendar entries before deleting them, execute the following query. Use the calendar ID you got from the previous query, for example

SELECT Summary FROM Components WHERE Notebook='088f1e00-c071-4370-a435-d659ebd6580e';

Now delete the entries matching that calendar from the table Components, for example

DELETE FROM Components WHERE Notebook='088f1e00-c071-4370-a435-d659ebd6580e';

Finally exit SQLite and the root shell (Ctrl-D is usually fine) and open the calendar application. If everything went as expected, the calendar entries in the calendar you edited should now be gone.

edit flag offensive delete publish link more

Comments

If You want to remove the Calendars too (instead of only the entries from them) use the following approach AFTER deleting from Components as shown above:

List all calendars: SELECT * FROM Calendars;

Delete specific calendars: DELETE FROM Calendars WHERE CalendarId IN ('d9e4b762-a186-4af8-bbdc-58e8ea4a45c0','c62b5014-2eaa-496c-ac8a-9447b1d69611','fadf6de3-2bea-4d92-987f-a8661ba1f405','9d49c547-9c8c-4914-ac8d-1e2942bd1c31');

Or one specific calendar: DELETE FROM Calendars WHERE CalendarId = 'd9e4b762-a186-4af8-bbdc-58e8ea4a45c0';

Verify with: SELECT * FROM Calendars;

DrWilken ( 2016-01-29 23:30:25 +0300 )edit

High Dr.Wilken, in my case, the deleting of one ore all calendars work very fine. After the deleting i installed the accounts and they worked fine. Thanks - Runningtrilo

Runningtrilo ( 2017-02-13 16:44:13 +0300 )edit

Thanks for the guide. I suppose one could come up with an SQL command to what I am really after, delete all entries older than X days. I will have to learn a bit more about SQL ;)

pichlo ( 2018-11-12 12:31:27 +0300 )edit
4

answered 2014-10-17 00:20:08 +0300

nomeata gravatar image

A quick way to do it is to simply delete /home/nemo/.local/share/system/privileged/Calendar/mkcal/db (as root). It works for me; not sure about any side-effects.

edit flag offensive delete publish link more

Comments

And do you still have the birthday calendar???

Fellfrosch ( 2014-10-17 13:30:07 +0300 )edit

Ok, after a reboot it's back. Thank's for your advice.

Fellfrosch ( 2014-10-17 13:31:49 +0300 )edit

By deleting /db which calendars are going away - all default birthday and private and are they going completely or only the content ? I have my private calendar full with near 1000 entries from my busines-calendar and will loose them all.

Runningtrilo ( 2015-07-09 12:00:59 +0300 )edit

@nomeata this is a great way to solve all sorts off calendar issues. key here is to have everything synched with the cloud.

DarkTuring ( 2016-10-31 19:51:03 +0300 )edit

This is the trick Sometimes my calendars start to multiply themselves. The calendars are syncronized with my OwnCloud - there are no problems, only on my Jolla. To rm /home/nemo/.local/share/system/privileged/Calendar/mkcal/db works fine; After a reboot everything looks healthy again.

groxxorg ( 2017-05-20 19:25:37 +0300 )edit
Login/Signup to Answer

Question tools

Follow
12 followers

Stats

Asked: 2014-10-17 00:03:22 +0300

Seen: 772 times

Last updated: Jun 16 '15