maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   Applications (https://talk.maemo.org/forumdisplay.php?f=41)
-   -   New Call logger widget (https://talk.maemo.org/showthread.php?t=51492)

manitasdeplata 2010-04-30 15:32
New Call logger widget
 
Hi all,
I've started developing a simple widget that tells the number of minutes of ougoing calls and the number of sent sms.
You can find the code and a .deb package from the garage account:

https://garage.maemo.org/projects/call-log/

here you can find some more information on how to use the package:

http://leonardo.lilik.it/wordpress/2...or-nokia-n900/

and here is the necessary screenshot :-)
http://leonardo.lilik.it/files/Widget.png

I'v been using it in the last days, feel free to test it and report me back impressions and bugs...

Two things you have to know:
- installing the deb this will change your event database as explained here: http://talk.maemo.org/showthread.php?t=42624
- consequently you need to have sqlite3 installed.

Hopefully you wan't need any other dependency.

Ciao,
leonardo.

GameboyRMH 2010-04-30 15:34
Re: New Call logger widget
 
Nice! That would be especially handy while roaming.

crazy_agent 2010-06-11 11:18
Re: New Call logger widget
 
Hello,
I have pr1.2 installed ,when trying ti install it returns (unable to install) and a black box appears on the desktop.
Any ideas how to get it working ?
Thanks.

manitasdeplata 2010-06-11 12:56
Re: New Call logger widget
 
Quote:
Originally Posted by crazy_agent (Post 710263)
Hello,
I have pr1.2 installed ,when trying ti install it returns (unable to install) and a black box appears on the desktop.
Any ideas how to get it working ?
Thanks.
humm! I still didn't upgrade. I will check this in the next weekend, I hope.

hawaii 2010-06-11 13:41
Re: New Call logger widget
 
Possible to add ALL calls to logging? Outgoing and incoming minutes added up?

Thanks.

sacal 2010-06-15 23:35
Re: New Call logger widget
 
First i want to thank the developer for this work. It is a very useful widget..

I also have pr1.2 installed and unfortunately the widget doesn't work.

After installing the call-log widget all my other widgets disappeared. :(

I had to uninstall it to get my desktop widgets back.

sacal 2010-07-04 15:56
Re: New Call logger widget
 
Bump!

Is the development of this very useful widget dead ?? :(

I hope not.

manitasdeplata can you comment please

Thanks

crazy_agent 2010-07-04 17:21
Re: New Call logger widget
 
this widget is much needed hope to see some results regarding pr 1.2 soon.
Thanx.

DaSilva 2010-07-04 17:28
Re: New Call logger widget
 
Do you have plans to submit it to extras(-devel)?

manitasdeplata 2010-09-06 20:11
Re: New Call logger widget
 
dear all...
I've had no time for the widget, I'm trying to bring it back to life, but I don't promise anything.

sacal 2010-09-07 01:36
Re: New Call logger widget
 
Quote:
Originally Posted by manitasdeplata (Post 808903)
dear all...
I've had no time for the widget, I'm trying to bring it back to life, but I don't promise anything.
I'm glad to hear that you are trying to update the widget. ;)

If you need any help on testing i will do it with pleasure.

manitasdeplata 2010-09-12 18:20
Re: New Call logger widget
 
Ok, I've made some steps forward. I'm rewriting everything using QT and QCreator. By now, I've done a console-based version and if you want to help use your ssh-fu and try out the script to test it. In the meantime I'll check for a decent gui.

You can find the code and some more details here:
http://leonardo.lilik.it/wordpress/2...ll-log-widget/

keep in mind that the script will not count the minutes before you apply the triggers.txt as explained, so the best to do is to apply the triggers, do some calls, try the script.

ciao
leonardo.

sacal 2010-09-13 01:03
Re: New Call logger widget
 
Hi Leonardo

Thanks again for restarting your work on this widget.

I tried your call-log-terminal application and it worked ok.
This was the xterm output:

Code:
/home/user/MyDocs # call-log-terminal 2 2010 09 01
DB opened
Debug: "select strftime("%J"      ,storage_time, 'unixepoch','localtime'      ) from Events order by id limit 1;"
Debug: "select strftime("%J"      ,storage_time, 'unixepoch','localtime'      ) from Events order by id desc limit 1;"
Debug: "select count(*), sum(end_time-start_time)            from Events where service_id=1 and outgoing=0 and            strftime("%J",storage_time, 'unixepoch','localtime')            > strftime("%J","2010-09-01") and end_time != 0            and local_uid = "ring/tel/ring"
"
Warning: You have  11  ingoing calls  for a total of  7 minutes
  and  17  outgoing calls  for a total of  7 minutes
 
Debug: "select strftime("%J"      ,storage_time, 'unixepoch','localtime'      ) from Events order by id limit 1;"
Debug: "select strftime("%J"      ,storage_time, 'unixepoch','localtime'      ) from Events order by id desc limit 1;"
Debug: "select count(*)            from Events where service_id=3 and outgoing=0 and            strftime("%J",storage_time, 'unixepoch','localtime')            > strftime("%J","2010-09-01");
"
Warning: SMS query returned  6 sent SMS and  4  received SMS
The real values retrieved from my el-v1.db are:
sent sms = 6
received sms = 4
ingoing calls = 12 (1 call with end_time=0)
ingoing calls duration = 7min 15s
outgoing calls = 28 (11 calls with end_time=0)
outgoing calls duration = 7min 41s

Comparing the real values with the output from call-log-terminal it seams ok.
The program doesn't count the calls with end_time=0 which i think is correct.
The call duration sum is truncated to the minute. This is a difficult issue as it should be evaluated according to the user plan.
For instance my provider invoices 1 min if outgoing call duration is less or equal to 1min and rounds to the next half minute for durations greater than 1min.

Later on i will try and post the above test with a larger database.

Thanks

Test results with a larger database:

Quote:
~ $ call-log-terminal 1 2010 07 01
DB opened
Warning: You have 86 ingoing calls for a total of 71 minutes
and 125 outgoing calls for a total of 108 minutes

Warning: SMS query returned 12 sent SMS and 19 received SMS
~ $ call-log-terminal 1 2010 07 32
DB opened
Fatal Error: The date entered is invalid!
Aborted
~ $ call-log-terminal 1 2010 15 02
DB opened
Fatal Error: The date entered is invalid!
Aborted
~ $ call-log-terminal 1 01 07 2010
DB opened
Fatal Error: The date entered is invalid!
Aborted
The real values retrieved from my el-v1.db are:
sent sms = 12
received sms = 19
ingoing calls = 86 (with end_time>0)
ingoing calls duration = 71min 3s
outgoing calls = 125 (with end_time>0)
outgoing calls duration = 108min 37s

I think this proves that call-log-terminal is working well.
I suggest that if possible the call time should be evaluated in time period units per call.
For instance if the user time period is 30s a call with 1min 35s should be evaluated as:
1m35s= 95s -> int(95/30+0.9)=4 -> 4X30s=120 -> 120s= 2min
and for a user time period of 1s the result would be 1m35s

manitasdeplata 2010-10-10 10:25
Re: New Call logger widget
 
I have to admit that the gui part is quite disappointing. I dowloaded the SDK, tried to use it, there is no documentation on how to make a desktop widget and the only example i found does not run on my n900...
still trying in my spare time.

sacal 2010-10-10 22:58
Re: New Call logger widget
 
If i may suggest an easier / faster way of creating a widget take a look at:
Queen Beacon Widget.
and
Queen_BeeCon_Widget WIKI

If you agree i can also try to create a QBW widget using your script.


All times are GMT. The time now is 15:19.

vBulletin® Version 3.8.8