Importing sms from N900 to PC ?
 

Hello.

I've recently found a way to send my texts from my N900 to my PC, thanks to some very smart people. The solution would be:

" Start xterm and type the following code
~ $ sqlite3 .rtcom-eventlogger/el-v1.db "select * from events where event_type_id in (7,8) order by id;"
> /home/user/MyDocs/sms.txt "

Fine and dandy, but I have a question. What has to be modified in order to have all of the texts organized first by contact, and secondly by date? I would really like to see all the texts from all my contacts one after the other. I've done a little sql language, and I would like to know what the columns of the table are here. I'd like to select only the actual text message, contact number, and eventually the date and time, but without the "ring/tel/ring self handle"

An example of an entry:
31|3|7|1294511062|1294511062|0|1|0|0|0|ring/tel/ring|<SelfHandle>|+407354*****||*actual text message*|54*****|1|0

What are the other numbers and what do they mean ?

Thank you in advance!

Re: Importing sms from N900 to PC ?
 

try ".schema events" :)

Re: Importing sms from N900 to PC ?
 

And try some sed & awk on the output.

Re: Importing sms from N900 to PC ?
 

Thank you for the reply, guys! But I have to say, I do not really understand what I should do. Please explain like you would for a totally new guy to this stuff (which I am).

Write in x term this: "......". The entire thing, please :))

Re: Importing sms from N900 to PC ?
 

Teaching you SQL (let alone SQLite's dialect of it) is somewhat beyond the time I have available. :)

Re: Importing sms from N900 to PC ?
 

Are you using a Windows PC? Ovi suite can do this for you. Also, there are rumours there's an OSS tool on the horizon that will be capable of synching all coversations (including MMSs) with a second (?master) device. Not from me but you know who you are :-).

Re: Importing sms from N900 to PC ?
 

have you tried glogarchive ?

it can export to csv spreeadsheet where you can sort as you wish...