|
2010-09-19
, 13:32
|
Posts: 15 |
Thanked: 3 times |
Joined on Sep 2010
@ Australia
|
#232
|
sms;submit;"";"12345";"";"2010.04.07 00:00";"";"Tu t'en sors?" sms;deliver;"12345";"";"";"2010.04.07 00:01";"";"oui enfin"
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
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.
|
2010-09-20
, 19:47
|
Posts: 49 |
Thanked: 7 times |
Joined on Sep 2010
|
#233
|
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 delimiterCode:sms;submit;"";"12345";"";"2010.04.07 00:00";"";"Tu t'en sors?" sms;deliver;"12345";"";"";"2010.04.07 00:01";"";"oui enfin"
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.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
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.
|
2010-09-20
, 21:06
|
Posts: 49 |
Thanked: 7 times |
Joined on Sep 2010
|
#234
|
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
|
2010-09-21
, 15:52
|
Posts: 15 |
Thanked: 3 times |
Joined on Sep 2010
@ Australia
|
#235
|
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
|
2010-09-29
, 01:09
|
Posts: 13 |
Thanked: 1 time |
Joined on Apr 2010
@ Melbourne, Australia
|
#237
|
|
2010-10-11
, 08:54
|
Posts: 15 |
Thanked: 3 times |
Joined on Sep 2010
@ Australia
|
#238
|
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
|
2010-10-15
, 20:15
|
Posts: 6 |
Thanked: 1 time |
Joined on Dec 2009
@ Germany
|
#239
|
|
2010-10-19
, 17:49
|
Posts: 1 |
Thanked: 0 times |
Joined on Oct 2010
|
#240
|
$ run-standalone.sh ./smsimporter out.cvs
# chmod +x smsimporter
# run-standalone.sh ./smsimporter your_file.csv
smsimporter need ext partition to work.