Copy text messages sms from n900 to pc computer

[manacho]

I have a N900 and I can't figure out of how use a pc based sms program with it. I have downloaded Nokia PC Suite and all the messaging options are grayed out. Specifically I want to copy the texts so I can e-mail them.
thanks,
Lucas

 

[chewster]

Not sure if this will still help you as your post is kind of old, but I just signed up today, so it's not my fault. 😉

And I can't resist answering a question that no one else could as my first post even if you're long gone.

I'm not sure if that is something that PC Suite is capable of at the moment (I don't run anything M$).

Now, this can still be done, but it depends on how comfortable you are with Linux.

To just dump them to a text file, do the following:

Open xterm (you don't need root) and enter the following command (note: case matters. a <> A in linux)

     ~ $ sqlite3 .rtcom-eventlogger/el.db "select * from events where event_type_id in (7,8) order by id;" > /home/user/MyDocs/sms_dump.txt

This will create sms_dump.txt which will contain all of your inbound (type 7) and outbound (type 8) SMS records in chronological order. You can also export the other types contained in the table, just add them to the sqlite3 command above in the brackets separated by comas.

Here is the list of the types:

1 = inbound call
2 = outbound call
3 = missed call
4 = voicemail message
5 = inbound IM (integrated conversations only)
6 = outbound IM (integrated conversations only)
7 = inbound SMS
8 = outbound SMS

When you've run what you need to run, plug the N900 into your PC in mass storage mode and you should see the file there.

You can import it with Open Office Spreadsheet or Excel if you are using M$ (boo you in that case).

Also, best place for help with the N900 is talk.maemo.org

Enjoy.

 

[audiovoodoo]

One hell of a first post. Welcome to the club

 

[aikipy]

Hi!

Thanks for the info. Still, I encountered a problem... it says that the "events" table does not exist... any idea why?

Thank you!

Not sure if this will still help you as your post is kind of old, but I just signed up today, so it's not my fault. 😉

And I can't resist answering a question that no one else could as my first post even if you're long gone.

I'm not sure if that is something that PC Suite is capable of at the moment (I don't run anything M$).

Now, this can still be done, but it depends on how comfortable you are with Linux.

To just dump them to a text file, do the following:

Open xterm (you don't need root) and enter the following command (note: case matters. a <> A in linux)

     ~ $ sqlite3 .rtcom-eventlogger/el.db "select * from events where event_type_id in (7,8) order by id;" > /home/user/MyDocs/sms_dump.txt

This will create sms_dump.txt which will contain all of your inbound (type 7) and outbound (type 8) SMS records in chronological order. You can also export the other types contained in the table, just add them to the sqlite3 command above in the brackets separated by comas.

Here is the list of the types:

1 = inbound call
2 = outbound call
3 = missed call
4 = voicemail message
5 = inbound IM (integrated conversations only)
6 = outbound IM (integrated conversations only)
7 = inbound SMS
8 = outbound SMS

When you've run what you need to run, plug the N900 into your PC in mass storage mode and you should see the file there.

You can import it with Open Office Spreadsheet or Excel if you are using M$ (boo you in that case).

Also, best place for help with the N900 is talk.maemo.org

Enjoy.

 

[aikipy]

ok, I solved the problem, by replacing 'el.db' with 'el-v1.db' thanks a lot!

 

[maartenlandman]

Hello people,

I have got a problem with doing this. If I put ~ $ sqlite3 .rtcom-eventlogger/el.db "select * from events where event_type_id in (7,8) order by id;" > /home/user/MyDocs/sms_dump.txt in to X Terminal on my Nokia N900 it says Permission denied.

What can I do to fix this?

 

[roxannakh]

i've entered the code but it says: cannot create /home/user/MyDocs/sms_dump.txt: nonexistent directory!
what should i do???🙁

 

[bmouring]

Wow, I had no idea there were this many people who also had N900s, I thought I was fairly alone.

By default, that directory should exist, if it doesn't than something is severely weird/wrong with the setup of your N900. What does

ls -l /home

from the built-in terminal/ssh session return?

If you see a user directory, what does listing the contents of that directory return?

 

[roxannakh]

what do u mean?
i entered the code: ls -l /home
and for the user directory it says:
drwxr-xr-x 51 user users 4096 oct 19 18:44 user

 

[bmouring]

Ok, and now for the $10,000 question: what is the contents of the /home/user directory? If there is a MyDocs folder (which there should be by default on the N900), then there is something else wrong with the command you used since the containing directory (/home/user/MyDocs does exist

 

[keef256]

Hi. Just tried this but get an empty file.

Then tried adding in options 1 2 3 4 5 6 I then get what looks like all the phone and Im logs but no SMS messages any ideas?