maemo.org - Talk
Page 24 of 28 « First 142223 24 2526 Last »
Show 40 post(s) from this thread on one page

maemo.org - Talk (https://talk.maemo.org/index.php)
-   Applications (https://talk.maemo.org/forumdisplay.php?f=41)
-   -   HOWTO: Importing SMS messages from Nokia phones to N900 (https://talk.maemo.org/showthread.php?t=37354)

lelinuxien52 2010-09-18 17:26
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.

motom 2010-09-19 13:32
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
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.

Quote:
Originally Posted by motom (Post 812175)
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.

wshamroukh 2010-09-20 19:47
Re: HOWTO: Importing SMS messages from Nokia phones to N900
 
Quote:
Originally Posted by motom (Post 820610)
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

wshamroukh 2010-09-20 21:06
Re: HOWTO: Importing SMS messages from Nokia phones to N900
 
Quote:
Originally Posted by wshamroukh (Post 821758)
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


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 2010-09-21 15:52
Re: HOWTO: Importing SMS messages from Nokia phones to N900
 
Quote:
Originally Posted by wshamroukh (Post 821834)
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 :)
glad it helps

wshamroukh 2010-09-23 11:38
Re: HOWTO: Importing SMS messages from Nokia phones to N900
 
thanks motom so much :)

sed8me 2010-09-29 01:09
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 ;)

motom 2010-10-11 08:54
Re: HOWTO: Importing SMS messages from Nokia phones to N900
 
see here

:)

Quote:
Originally Posted by sed8me (Post 828839)
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 ;)

NJD 2010-10-15 20:15
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 =(

batal 2010-10-19 17:49
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.
Code:
$ run-standalone.sh ./smsimporter out.cvs
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.


All times are GMT. The time now is 17:35.
Page 24 of 28 « First 142223 24 2526 Last »
Show 40 post(s) from this thread on one page

vBulletin® Version 3.8.8