Active Topics

 


Reply
Thread Tools
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:
Lirion is offline Lirion
2013-02-17 , 21:03
Posts: 32 | Thanked: 22 times | Joined on Jul 2012 @ Germany
#2
Ok finally I test the configuration with 43200.

It seems that everything working fine and reminds you at 12.00 at the same day.
Attached Images
 
Last edited by Lirion; 2013-02-17 at 21:29.
 

The Following 2 Users Say Thank You to Lirion For This Useful Post:
tajunta is offline tajunta
2013-02-21 , 19:03
Posts: 1 | Thanked: 1 time | Joined on Feb 2013 @ Finland
#3
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.
 

The Following User Says Thank You to tajunta For This Useful Post:
Lirion is offline Lirion
2013-02-22 , 10:37
Posts: 32 | Thanked: 22 times | Joined on Jul 2012 @ Germany
#4
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;
Last edited by Lirion; 2013-02-22 at 10:40.
 

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

« Previous Thread | Next Thread »

 
Forum Jump


All times are GMT. The time now is 08:58.

Contact Us - Home - Archive - Top