agi666 | # 21 | 2010-05-31, 17:21 | Report

Great! It's working now. Thanks a lot!

matrim | # 22 | 2010-06-14, 09:44 | Report

Just a note to anyone using this. Extended Call Log v0.5 will now display the duration of the call if the end-time field is populated in the database

Garfield007 | # 23 | 2010-06-16, 12:57 | Report

Don t work for me for all call, in or out.

hcm | # 24 | 2010-06-16, 13:01 | Report

@Garfield007: if you want me to help, explain exactly what you did:
- which triggers.txt you used (from which post)
- the commands you used and errors which might have occured
- which firmware version you are using
- how you checked that it doesn't work

Garfield007 | # 25 | 2010-06-16, 13:15 | Report

Heya ,

Triggers file from post 20.

Code from post 12 (sqlite3 -batch /home/user/.rtcom-eventlogger/el.db < triggers.txt)

Executed and got normal prompt, no error.


Got 1.2 installed

Erased all call log. Took a call and emitted one and gone to extended call log application, but no trace of duration.

Ty for your time.

matrim | # 26 | 2010-06-16, 13:17 | Report

In PR1.2 the database is /home/user/.rtcom-eventlogger/el-v1.db

so the command should probably be

sqlite3 -batch /home/user/.rtcom-eventlogger/el-v1.db < triggers.txt

hcm | # 27 | 2010-06-16, 13:19 | Report

@matrim: oh correct, I didn't think of that change ^^
will mention it in my post #20

also note that the feature is new in Extended Call Log v0.5, which is in extras-devel. The version in extras and/or extras-testing does not show call duration.

Garfield007 | # 28 | 2010-06-16, 13:26 | Report

Big thanx, it s work now.

By curiosity, there is a easy way to look structure and data in database in N900 or just to export it for look in it on computer ?

hcm | # 29 | 2010-06-16, 13:29 | Report

yep, sqliteman can just open the el-v1.db. It is available for linux (probably in your package manager), and for mac&windows from the homepage www.sqliteman.com

Garfield007 | # 30 | 2010-06-16, 13:40 | Report

And how i get a copy of the database ?
Not found it in explorateur.

If you have a command line to export it to .documents i take it.


hehe i abuse a bit