Thread: calendar shortcomings
View Single Post
kortsi is offline kortsi
2010-01-27 , 07:23
Posts: 31 | Thanked: 32 times | Joined on Jan 2008 @ Helsinki
#4
It seems the calendar is able to display "complex" recurring schedules, but there are no editing tools for that. I would like to see them.

I was able to create a bi-weekly recurrence by using the sqlite console:

Code:
sqlite3 /home/user/.calendar/calendardb
Warning: Remember you can screw up your calendar database using the sqlite console, so you probably want to take a backup before editing it. And close the calendar app before editing to avoid you both accessing the db at the same time.

The table called "Components" contains the calendar events. Notice the first column which contains the id of the event you want to have a complex recurrence.

There's also a table called "RECURSIVE" which contains the recurrence rules for the events. They seem to be standard iCalendar syntax in column "rrule".

Get your event's recurrence rule:

Code:
select * from RECURSIVE where id=123;
I just changed my event to have a bi-weekly interval:

Code:
update RECURSIVE set rrule='FREQ=WEEKLY;INTERVAL=2;UNTIL=20101231T160000!' where id=123;
And that's it. Calendar shows my event now recurring every other week.
 

The Following 4 Users Say Thank You to kortsi For This Useful Post: