maemo.org - Talk - [HowTo] Setting birthday reminder time

maemo.org - Talk (https://talk.maemo.org/index.php)

- MeeGo / Harmattan (https://talk.maemo.org/forumdisplay.php?f=45)

- - [HowTo] Setting birthday reminder time (https://talk.maemo.org/showthread.php?t=88995)

[HowTo] Setting birthday reminder time

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

Re: [HowTo] Setting birthday reminder time

Ok finally I test the configuration with 43200.

It seems that everything working fine and reminds you at 12.00 at the same day.

Re: [HowTo] Setting birthday reminder time

Thanks, really appreciated.

How would you go with the value if you wish to have no reminders at all for the birthdays? I would like to have that calendar enabled, but without reminders.

Re: [HowTo] Setting birthday reminder time

I think this is a good tutorial:

http://talk.maemo.org/showpost.php?p...95&postcount=4

And for birthdays which were added in future type:

Code:

CREATE TRIGGER update_reminder AFTER INSERT ON Alarm    

BEGIN        

UPDATE Alarm SET isEnabled = 0 WHERE Offset == -129600;    

END;