Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

How do I use the export tool that's also in the files?

I want to export the messages in my phone to a .csv file.

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

How rude of me, I forgot to say please ;-)

Can some one please explain how to export messages from the N900 to a .csv file? :D

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

navigate to the place you've placed the extracted tool and type:

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

Hmm I use this now:

cd /home/user/
chmod +x smsexporter

But it gives me the error: no such file or directory. I have put the file in the map data on my phone. That should be /home/user/ right?

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

It's /home/user/MyDocs

If I understand correctly, then do only once:
thereafter everytime you want to send all sms to csv do:
hope it helps

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

I'm still getting the same error.

Why is the map tree on the device totally different than I see it on the computer? And why do I have to cd to a map I can't see on the device?

If I use the filebrowser I can't find home/user/ really weird.

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

ok, the info you give is not enough for me to understand where you are and what you do.

change of direction,
try this http://maemo.org/downloads/product/Maemo5/glogarchive/
it will though export all calls and sms in one file.

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

Great, I'll try it :-) Thanks for all the help :-)

Hopefully I can import them again in Meego later on. I want to try it out.

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

smsexporter is giving me this error:

can anyone give me some help? Thanks

EDIT: sorry, got it. latest versions are not in the first post.
Great job on this thing. I just wished it would add them in the proper order.

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

i'm having trouble with smsexporter.... it creates a blank file
any idea what that is? it doesn't work with pr 1.2?

thanks!

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

error while loading shared libraries: librtcom-eventlogger.so.0: cannot open shared object file: no such file or directory

I have the same problem. Please help, who can.

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

is it possible to use this exporter and than transfer my messages to a android device?! Thanks

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

I've got my own Python app for browsing sms messages from other Nokia devices.
To use it one needs to export all smses from the old device using Nokia PC Suite into a file, and copy this file into n900.

Then this app (sms-nostalgia) will import all your smses into it (the app, not Conversation app) and one is be able to have them when one needs.
One could search by text/phone number and see avatars of sms author.
It also supports rotation.

It's in Python. I've spend like 2 weeks polishing it, so it's stable and easy to use. Though after some time I'm not using it so often. Anyhow, I got all my E61 sms here on n900.

One thing though, I don't know how to package Python software yet, so I can't redistribute it easily. Sources are available though.
http://github.com/nthx/sms-nostalgia

I could be happy to distribute it/improve, just someone would need to give me a hand how to do it.

Cheers!
Tomasz (send email/private if you're interested)

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

Hey guys, I have followed the steps and made sure to use the lates version of the smsimporter http://talk.maemo.org/showpost.php?p...&postcount=178
the command line runs successfully but i can't see my messages? i event restarted my mobile but it did not help.

Am i missing something here? plz help

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

can anybody help me in this!! i tried to run the smsimporter and it ran successfully, but when checking the conversation application it does not show the imported messages..
any help is much appreciated!!

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

Try rebooting, might help.

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

i did already but yet the same no messages are there!!

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

try this: close conversations, run smsimporter, reboot then check.

try also with a file that has only one message to import first.

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

I have exported only one message
i rebooted the device
saved the .csv file to the device
ran the command
reboot again

no luck :confused:

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

for those who successfully import sms:
will the imported sms connect like thread style?

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

Yes they will, though the imported sms messages will always be on bottom of your message thread, even if the date says they are older.
New messages ofcourse from there on out will be on the bottom.




Other than that:
Has anyone succesfully exported messages with PR1.2
I keep getting an error!? In the future i'd like to be able to transfer my messages to another (android?) device. Which seems easy if the n900 would sync with OVI suite, but it doesn't.... but i don't quite feel like reverting to PR1.1 just to export my messages.

So if anyone has an updated version of SMSexporter or another solution, PLEASE let me now, thanks!

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

I noticed one thing difference in my databade that the name is different from what you have in this thread. My sms messages database name is el-v1.db. Could be this the issue that i can't get the sms messages imported to my N900? I have noticed that the tables' fields are somehow different from el.db!!
does everyone who tried this tool and successfully imported their messages have el.db or el-v1.db?

ur help is much appreciated

thanks in advance

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

dose the sms file suppose to be like this before import ?
http://img.whirltools.com/viewer.php...7508705480.jpg

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

i need this app.. how do i get it up and running?

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

i have tried to manipulate the el-v1.db manually and tried to use the update query as bellow:

INSERT INTO Events
VALUES(63,3,11,1275483743,1275483734,1275483741,1, 0,0,0,0,'ring/tel/ring','<SelfHandle>','Nokia',NULL,'test message','Nokia');


i have added the above values according to this:

TABLE Events (id INTEGER PRIMARY KEY,service_id INTEGER NOT NULL,event_type_id INTEGER NOT NULL,storage_time INTEGER NOT NULL,start_time INTEGER NOT NULL,end_time INTEGER,is_read INTEGER DEFAULT 0,outgoing BOOL DEFAULT 0,flags INTEGER DEFAULT 0,bytes_sent INTEGER DEFAULT 0,bytes_received INTEGER DEFAULT 0,local_uid TEXT,local_name TEXT,remote_uid TEXT,channel TEXT,free_text TEXT,group_uid TEXT)

but when i go to conversations, the name of the sender is "NULL" and when trying to access it, it says "unable to access the conversation null" or whatsoever.

im trying disperately to get my old messages imported into my new N900 but no luck :(
I wish if somebody can pin point what im missing here in this query??

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

i dont'see my oldest sms imported with this instructions...why?

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

Hi my SMS files was exported from nokia pc suite, looks like the image above. Mobile, date, MSG..etc. All are in different cells. Is it correct?
Also the content of the inbox and sent box file are different. The inbox SMS file have one more empty column.
How should I merge them?
Appreciate any help.

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

Hi

dose the sms file suppose to be like this before import ?
http://img.whirltools.com/viewer.php...7508705480.jpg

my SMS files was exported from nokia pc suite, looks like the image above. Mobile, date, MSG..etc. All are in different cells. Is it correct?
Also the content of the inbox and sent box file are different. The inbox SMS file have one more empty column.
How should I merge them?
Appreciate any help.

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

Hi,

Smsimporter works fine for me : more than 1600 SMS from my old Nokia 5800XM saved in *.csv file with Nokia PC Suite.

Thanks a lot !

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

guys, i cant get the sms imported to my conversation application.

here what i have tried:

Nokia-N900:/home/user# ./smsimporter
Usage: smsimporter <input csv file>
ex. smsimporter backup.csv
Nokia-N900:/home/user# ./smsimporter 1.csv
Nokia-N900:/home/user#


is this the expected output? The command just finishes in less than a second. Is this the expected behaviour?

any help is much appreciated :)

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

Try :
# chmod +x smsimporter
# run-standalone.sh ./smsimporter your_file.csv

smsimporter need ext partition to work.

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

Nobody helped me :( , But I figured it out myself from the old posts, so I’ve finally done the importing.

Here’s what I did,

1. export sms from PC suite or anywhere else into csv. CSVed is a handy free CSV file editor you might need.
2. make sure the format is like this
3. I use a semicolon ( ; ) as the delimiter
4. download the smsimporter from here.
5. copy the sms.csv and smsimporter to your N900.
6. Open X terminal from menu and type the code from here.
7. wait for a while and the importing will begin. You will see the sms no. increasing.

you can use FileBox to delete the sms.csv and smsimportor from /home/user/ if you wish to.

I've successfully import 1700+ sms.

Good luck and hope this helps.

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

Thanks for the detailed information here.
Unfortunately even after i have followed your instructions literally , but i can get the sms imported. I have even rebooted the mobile but no luck
I have even tried to run this query against el-v1.db:
SELECT * FROM Events where event_type_id=11 and remote_uid='+123456789'

but this returned nothing!!

actually the command runs very quick!! is this the expected behavior?

any helps is much appreciated

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

it seems because i was trying to run the command from putty, it was not executing the command. However, when i used the X-terminal that is available on the mobile itself, i got the command running and got the sms imported to my conversation application....

thanks a million :)

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

glad it helps

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

thanks motom so much :)

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

Hello Everybody,

I wonder if this is at all possible in reverse ?
I would like to extract every event (sms) in my Conversations application and convert them into individual sms files.
ie: *.vmg format.

It seems everything can create a csv file.
but until there is <ahem> support, lol
I yearn to have all my sms backed up in Nokia LIFEBLOG
nokia photo's and ovi suite dont seem to import csv . . .

Thanx in advance to the best community ever ;)

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

see here

:)

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

I don't get it =(

How can I get the export thing 2 work?

Is it the same export like googlarchive?

I want to export it to import it on my milestone.

Please help =(

Re: HOWTO: Importing SMS messages from Nokia phones to N900
 

[SOLVED] Well... obviously you have to execute the importer as user "user" and not as root. Should have thought of this, silly me. But perhaps someone can use this post for good ;)

I can confirm, that somehow the import application does "nothing".

My N900 has the latest update and my import file stores around 4k messages. At first i tried to run the importer (latest build from #178 or something) as root via ssh with | as a delimiter in the .cvs file.
The application didn't return any error messages and my el-v1.db and el.db files haven't changed (i.e. not in size and not the last modified date).

After that i tried a few things like changing the delimiter back to ";", chmod to full rw (666) and since i don't know anything about the importers internals i tried switching the directory of the executable to 1) the user's home root dir and 2) the el-v1.db's location. I also tried running the command directly from the N900s X-term.

Didn't get any results. Some ideas anyone? (I guess there haven't been any updates on the OS since the latest successful import with the smsimporter)

Btw... I have already messages stored in my database. But i guess this shouldn't be a problem. Sadly i couldn't get access to the systems log files.