lelinuxien52 | # 231 | 2010-09-18, 17:26 | Report

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

smsimporter need ext partition to work.

motom | # 232 | 2010-09-19, 13:32 | Report

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.

wshamroukh | # 233 | 2010-09-20, 19:47 | Report

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

wshamroukh | # 234 | 2010-09-20, 21:06 | Report

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

motom | # 235 | 2010-09-21, 15:52 | Report

glad it helps

wshamroukh | # 236 | 2010-09-23, 11:38 | Report

thanks motom so much

sed8me | # 237 | 2010-09-29, 01:09 | Report

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

motom | # 238 | 2010-10-11, 08:54 | Report

see here

NJD | # 239 | 2010-10-15, 20:15 | Report

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 =(

batal | # 240 | 2010-10-19, 17:49 | Report

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

---

Last edited by batal; 2010-10-19 at 18:57.