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!