View Single Post
Posts: 12 | Thanked: 18 times | Joined on Sep 2010
#10
Without invalidating the Perl script above which reads the message, wouldn't it be simpler just to type in the command for reading the message? Just open the X Terminal window and type

sqlite3 -csv $( ls $HOME/.rtcom-eventlogger/el*db -1t | head -n1 ) "SELECT free_text FROM Events WHERE service_id='3' ORDER BY start_time DESC;" | head -n1 | espeak

You do have to make sure espeak is installed. You can do it from the usual App Manager or, if you know how to gain root, run as root: "apt-get install espeak". (You don't need espeakmsg or espeaktime or whatever.)

Of course, typing that 166-character line above is not that convenient, so you can stick it in a two-line shell script file that says:

#!/bin/sh
sqlite3 -csv $( ls $HOME/.rtcom-eventlogger/el*db -1t | head -n1 ) "SELECT free_text FROM Events WHERE service_id='3' ORDER BY start_time DESC;" | head -n1 | espeak


If you name the file "ss", for example, then you just type "ss"[Enter] which is 3 characters.

You can also stick it in a widget on your N900 "desk"top, so you can just tap the icon to read the most recent sms message.
 

The Following 6 Users Say Thank You to C.Whiteham For This Useful Post: