Re: Help Exporting SMS from N900.
 

Would be nice to use this command together with timestamps...

Re: Help Exporting SMS from N900.
 

Hi i ran the command in the terminal of my N900 but its giving me some error
"SQL error: no such table: Events"


help...!!!!!!

Re: Help Exporting SMS from N900.
 

which command?

Nicolai

Re: Help Exporting SMS from N900.
 

i ran this command

sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='xxxxxxxxxxxx' order by start_time DESC;" > output.html

have replaced xxxxxxxxxxxx with a phone number

and got the error
"SQL error: no such table: Events"

Re: Help Exporting SMS from N900.
 

there are two events db-files depending on your Firmware version.
try el-v1.db instead of el.db:
sqlite3 -html /home/user/.rtcom-eventlogger/el-v1.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='xxxxxxxxxxxx' order by start_time DESC;" > output.html