maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   Maemo 5 / Fremantle (https://talk.maemo.org/forumdisplay.php?f=40)
-   -   Help Exporting SMS from N900. (https://talk.maemo.org/showthread.php?t=51239)

DaSilva 2010-12-06 14:48

Re: Help Exporting SMS from N900.
 
Would be nice to use this command together with timestamps...

ankursinghal 2010-12-28 13:50

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...!!!!!!

nicolai 2010-12-28 14:15

Re: Help Exporting SMS from N900.
 
Quote:

Originally Posted by ankursinghal (Post 906005)
Hi i ran the command in the terminal of my N900 but its giving me some error
"SQL error: no such table: Events"


help...!!!!!!

which command?

Nicolai

ankursinghal 2010-12-29 09:22

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"

nicolai 2010-12-30 11:03

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


All times are GMT. The time now is 04:57.

vBulletin® Version 3.8.8