View Single Post
Posts: 49 | Thanked: 7 times | Joined on Sep 2010
#233
Originally Posted by motom View Post
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
Code:
sms;submit;"";"12345";"";"2010.04.07 00:00";"";"Tu t'en sors?"
sms;deliver;"12345";"";"";"2010.04.07 00:01";"";"oui enfin"
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.
Code:
cp /home/user/MyDocs/smsimporter /home/user/
cp /home/user/MyDocs/sms.csv /home/user/
chmod +x /home/user/smsimporter
cd /home/user/
run-standalone.sh ./smsimporter sms.csv
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.
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