Thread: [HowTo] Setting birthday reminder time
View Single Post
Lirion is offline Lirion
2013-02-04 , 17:34
Posts: 32 | Thanked: 22 times | Joined on Jul 2012 @ Germany
#1
Hey TMO Users!

This thread (http://talk.maemo.org/showthread.php?t=85319) reminds me to set up the default birthday calender.

I've search a while on this board for an info how to change the reminder time of the build in calender (a while ago i read a howto but today i didn't find it anymore ). So i decided to write a little howto on my own - for anyone who have also the ability to forget the birthday also if your n9 remind you 1,5 days (!!!) before.

Inception and developer mode are required

Install sqlite3
Download from here (sqlite3_3.7.7-2+maemo2+0m6_armel.deb):
http://harmattan-dev.nokia.com/pool/...ree/s/sqlite3/
Code:
dpkg -i /path/to/sqlite3/download
Starting a terminal
Code:
devel-su
ariadne sh
aegisctl -s
sqlite3 /home/user/.calendar/db
then a sqlite terminal apperas( sqlite> ):

  • First - change existing birthdays:
Code:
 UPDATE Alarm SET Offset = -7200 WHERE Offset == -129600;
  • Change birthdays which are added in future
Code:
CREATE TRIGGER update_Offset AFTER INSERT ON Alarm
   BEGIN 
      UPDATE Alarm SET Offset = -7200 WHERE Offset ==-129600;
   END;
hit return! After that type .quit to exit sqlite. Now you can close the terminal.

The numerics are seconds. So -7200 seconds are 2 hours (10.00 pm on the day before).

Maybe it is possible that reminder fire up at 12.00 am at the same day? Later on I try the Alarm with 43200 (without -). If it works i edit this post with the result.

hth
Last edited by Lirion; 2013-02-17 at 21:26.
 

The Following 9 Users Say Thank You to Lirion For This Useful Post: