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

Question

5

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

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

Schturman

5645 ●143 ●216 ●232

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

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:

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

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 ?

Thanks

edit retag flag offensive close delete

Answer 1

4

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

luen

5879 ●73 ●103 ●101

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

edit flag offensive delete publish link

Comments

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

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

Answer 2

2

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

Schturman

5645 ●143 ●216 ●232

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

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

Answer 3

1

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

Schturman

5645 ●143 ●216 ●232

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

Answer 4

1

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

olf
10393 ●104 ●201 ●158

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

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

Answer 5

0

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

chris_bavaria
1088 ●21 ●37 ●35

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

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

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

5 Answers

Comments

Question tools

Stats

Related questions

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

5 Answers

Comments

Question tools

Public thread

Stats

Related questions