We have moved to a new Sailfish OS Forum. Please start new discussions there.

Import/Removing calendar entries inserted from .ics file. Some questions?

asked 2016-09-14 23:59:50 +0300

Schturman gravatar image

updated 2016-09-15 01:14:11 +0300

Hi to all.
I have 3 questions:

1. As we know we can import calendar entries from .ics file by clicking on file and pressing IMPORT button. But now can we somehow remove this entries from calendar app ? I mean not manually removing each entry or not hiding Personal calendar from Callendar-> Manage calendar-> unchecking Personal calendar (it not have option to remove this calendar, it allow only unchecking). I know we can remove ALL entries(calendars) by removing this file:


But this is not a solution if you want remove only this one that you just imported (Personal calendar). Any way to do this via terminal maybe ?

2. Is it possible import .ics file via terminal command instead by clicking on file and import button ?

3. Any way to create manually new Calendar ? I didn't find it in setting and also here... Maybe again via terminal ?


edit retag flag offensive close delete

5 Answers

Sort by » oldest newest most voted

answered 2016-09-15 00:13:51 +0300

luen gravatar image

For 1), see Delete all entries from a calendar.

edit flag offensive delete publish link more


Cool, thanks! The first question is answered. What about the two other ?

Schturman ( 2016-09-15 00:24:21 +0300 )edit

answered 2016-09-15 04:14:36 +0300

Schturman gravatar image

updated 2016-09-15 10:23:25 +0300

Ok, I find a answer by myself for question #3 :D.
Run this one-line command to create your custom calendar. The important thing is a first long number:

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "insert into Calendars values('11112222-1111-1111-1111-111122221111','Custom calendar','','#FFFFFF',664,0,'hebcal','',-1,1473912123,'','',1473912123,'','');"

And to remove this calendar (one-line command too):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "DELETE FROM Calendars WHERE CalendarId='11112222-1111-1111-1111-111122221111';"
edit flag offensive delete publish link more

answered 2016-09-15 12:31:33 +0300

Schturman gravatar image

Probably we also can import .ics file into calendar (question #2). It should be something like:

.import /home/nemo/Downloads/test.ics Calendars

But here is a problem we need import it to specific CalendarId and not just to table named "Calendars"... Here i'm stuck and don't know the right command. Any help ?

edit flag offensive delete publish link more

answered 2017-10-03 05:21:46 +0300

olf gravatar image

updated 2017-10-03 05:27:38 +0300

Just for the records (i.e. other readers of this than Schturman, the author of this question), and to avoid misunderstandings:

"3. Any way to create manually new Calendar" can be achieved at the GUI by the help of Schturman's Patch "Add more calendars"; obviously he meant to address "manually" via CLI, not GUI.

edit flag offensive delete publish link more

answered 2017-10-03 02:12:53 +0300

chris_bavaria gravatar image

updated 2017-10-03 12:07:56 +0300

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db
 sqlite> .import /home/nemo/Downloads/test.ics Calendars

does not import the *.ics file. Now I tried:

[root@Sailfish mkcal]# sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db < /home/nemo/Downloads/termine.ics
Error: incomplete SQL: BEGIN:VCALENDAR

Somebody knows the terminal command? Thanks

Edit: Need it for a script.

edit flag offensive delete publish link more
Login/Signup to Answer

Question tools



Asked: 2016-09-14 23:59:50 +0300

Seen: 722 times

Last updated: Oct 03 '17