Go Back   maemo.org - Talk > Software > Applications
 
Register FAQ Community Calendar Today's Posts Search

Notices

Reply
 
Thread Tools
  #11  
Old 2010-02-06, 21:51
Swimm12984's Avatar
Swimm12984 Swimm12984 is offline
 
Join Date: Feb 2010
Location: Long Island, New York
Posts: 80
Thanks!: 84
Thanked 37 Times in 22 Posts
Send a message via AIM to Swimm12984 Send a message via Yahoo to Swimm12984 Send a message via Skype™ to Swimm12984
Default Re: Eventlogger doesn't log call-end-time

Beautiful.

This may sound like a newbie question but thats because Im relatively new to the linux scene....im a symbian guy...but anyway, how do i go about "activating" the triggers in the script?

Simply running the following code isn't sufficient?
Code:
sqlite3 -batch /home/user/.rtcom-eventlogger/el.db < triggers.txt
Reply With Quote
  #12  
Old 2010-02-06, 21:56
hcm hcm is offline
 
Join Date: Jan 2010
Location: Germany
Posts: 75
Thanks!: 26
Thanked 78 Times in 32 Posts
Default Re: Eventlogger doesn't log call-end-time

yes thats sufficient.
copy the triggers.txt over to your device, open a terminal and navigate to the folder where the triggers.txt is, for example
Code:
cd MyDocs
then run
Code:
sqlite3 -batch /home/user/.rtcom-eventlogger/el.db < triggers.txt
this line adds the triggers to the database (if the triggers already exist because of a previous version, the previous version is deleted first).
the triggers are stored persistently in the database and survive a reboot, of course…
you can also delete the triggers.txt after that, if you want.
Reply With Quote
The Following 3 Users Say Thank You to hcm For This Useful Post:
  #13  
Old 2010-02-06, 21:59
Swimm12984's Avatar
Swimm12984 Swimm12984 is offline
 
Join Date: Feb 2010
Location: Long Island, New York
Posts: 80
Thanks!: 84
Thanked 37 Times in 22 Posts
Send a message via AIM to Swimm12984 Send a message via Yahoo to Swimm12984 Send a message via Skype™ to Swimm12984
Default Re: Eventlogger doesn't log call-end-time

good deal... thank u very much
Reply With Quote
  #14  
Old 2010-05-14, 08:59
newbe newbe is offline
 
Join Date: Dec 2009
Posts: 64
Thanks!: 85
Thanked 5 Times in 3 Posts
Default Re: Eventlogger doesn't log call-end-time

hi there and thanks
but here's a noob question (the id says it all) where do I save the trigger to have access to it in x-terminal? it's in Documents now but can't get to it
THANKS
__________________
Teaching old dogs new tricks

Last edited by newbe; 2010-05-14 at 09:00. Reason: typo
Reply With Quote
  #15  
Old 2010-05-14, 09:04
hcm hcm is offline
 
Join Date: Jan 2010
Location: Germany
Posts: 75
Thanks!: 26
Thanked 78 Times in 32 Posts
Default Re: Eventlogger doesn't log call-end-time

The folder "Documents" in the Filemanager is actually /home/user/MyDocs/.documents in the filesystem.
You can get there by typing
Code:
cd /home/user/MyDocs/.documents
in xterm. A simple "ls" will show you the files in your current directory, so you can verify its actually there.
Reply With Quote
The Following 3 Users Say Thank You to hcm For This Useful Post:
  #16  
Old 2010-05-29, 16:53
agi666 agi666 is offline
 
Join Date: Jan 2010
Posts: 4
Thanks!: 4
Thanked 2 Times in 1 Post
Default Re: Eventlogger doesn't log call-end-time

Hi, is this working after PR1.2?
I now have el-v1.db instead of el.db, and applied the triggers there. But I'm still getting no end_time.

Thanks.
Reply With Quote
  #17  
Old 2010-05-30, 10:41
hcm hcm is offline
 
Join Date: Jan 2010
Location: Germany
Posts: 75
Thanks!: 26
Thanked 78 Times in 32 Posts
Default Re: Eventlogger doesn't log call-end-time

Quote:
Originally Posted by agi666 View Post
Hi, is this working after PR1.2?
I now have el-v1.db instead of el.db, and applied the triggers there. But I'm still getting no end_time.

Thanks.
this is not needed anymore with PR1.2. I don't know if it might even be harmful now.
What do you mean by "I'm still getting no end_time"? Did you check the database? AFAIK there are no GUI-Application which actually use the field end_time.
Reply With Quote
  #18  
Old 2010-05-30, 12:01
agi666 agi666 is offline
 
Join Date: Jan 2010
Posts: 4
Thanks!: 4
Thanked 2 Times in 1 Post
Default Re: Eventlogger doesn't log call-end-time

Quote:
Originally Posted by hcm View Post
this is not needed anymore with PR1.2. I don't know if it might even be harmful now.
What do you mean by "I'm still getting no end_time"? Did you check the database? AFAIK there are no GUI-Application which actually use the field end_time.

Hi, my end_time is still showing 1970-01-01 on outgoing calls, but I found that it is being correctly updated on incoming calls! So, with PR1.2 should I remove these triggers?
Thanks for your help,

Alberto
Reply With Quote
  #19  
Old 2010-05-30, 12:09
hcm hcm is offline
 
Join Date: Jan 2010
Location: Germany
Posts: 75
Thanks!: 26
Thanked 78 Times in 32 Posts
Default Re: Eventlogger doesn't log call-end-time

sorry, you're right, it's only correctly set for incoming calls.
I'll try to examine that further, I'll let you know when I find out more…
Reply With Quote
The Following User Says Thank You to hcm For This Useful Post:
  #20  
Old 2010-05-30, 17:55
hcm hcm is offline
 
Join Date: Jan 2010
Location: Germany
Posts: 75
Thanks!: 26
Thanked 78 Times in 32 Posts
Default Re: Eventlogger doesn't log call-end-time

ok my last post was incorrect, PR1.2 did not change anything with respect to end_time (i.e. end_time is still not saved).
But PR1.2 changed the structure of the database, and that's why only the triggers for incoming calls were working correctly.
Apparently, the triggers are even saved in a backup, and thus survived my reflashing and backup-restoring.

Anyway, here are the new triggers which should work for PR1.2.

EDIT: the name of the database has changed, so the command to import the triggers is now
Code:
sqlite3 -batch /home/user/.rtcom-eventlogger/el-v1.db < triggers.txt
Attached Files
File Type: txt triggers.txt (1.9 KB, 1401 views)

Last edited by hcm; 2010-06-16 at 13:20.
Reply With Quote
The Following 9 Users Say Thank You to hcm For This Useful Post:
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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