56 replies to this topic

[RemoteSojourner]

Hi,

Based on your solution and couple of other softwares I finally managed to import over 900 sms from my Nokia N95 and I think this will work with all other Nokia phone. I will post the full details of how I did it soon. Thanks for your amazing program

[giankap]

patzek, on Sep 3 2009, 09:11, said:

New Release. Try it with this one.

Now it's working!!
i successed to write mmssms.db.
i'm uploding the db to the phone and see the result.
many thanks, and excuse me for the private message, i did not see your last post...

[RemoteSojourner]

Here is the tutorial http://vinodmishra.c...ndroid-devices/

[giankap]

giankap, on Sep 3 2009, 13:50, said:

Now it's working!!
i successed to write mmssms.db.
i'm uploding the db to the phone and see the result.
many thanks, and excuse me for the private message, i did not see your last post...

excuse me,
is there any body who have some suggestion for deleting duplicate items in the sms xml file exported from windows? Opening the xml with excel, an working with access, I manged to obtain an excel file in which I do not have duplicates, but i can't export this file back in an xml format.
can anybody help me?
thank you

[patzek]

giankap, on Sep 4 2009, 20:48, said:

excuse me,
is there any body who have some suggestion for deleting duplicate items in the sms xml file exported from windows? Opening the xml with excel, an working with access, I manged to obtain an excel file in which I do not have duplicates, but i can't export this file back in an xml format.
can anybody help me?
thank you

you can edit, delete or insert sms messages with my smsimporter. when you read in the xml file you can full edit all sms messages. Sorting is also possible by clicking on the columnheaders...

[giankap]

patzek, on Sep 5 2009, 05:24, said:

you can edit, delete or insert sms messages with my smsimporter. when you read in the xml file you can full edit all sms messages. Sorting is also possible by clicking on the columnheaders...

I've seen this feature, but my situation is that i've about 1000 sms, about 400 of these are duplicated. Using excel and access i've obtained a file excel without duplicates. My need is to copy the rows of this file in smsimporter, and this seem not to be possible because, as far as I can see, i can't make multiple selection and copy past in sms importer. Thus, the solution could be exporting the corret xls file in xml from excel, befor opening it qhit smsimporter,  but I can't success in this task.

thank you

[SKORPiO1975]

patzek, on Sep 3 2009, 02:15, said:

Normaly my SMSImporter also link SMS Messages together like Android does this. I check this by comparing the Phonenumber from Sender/Receiver with the existing ones and when i find the right one then the message get attached to the existinig thread. The only reason that i can think what happens on your side that all of your Messages get an own thread is that the Numbers in your Messages are looking other then the Numbers in the Messages of the other Person (Country Code maybe??? )

Messagetype = 1 = Received Message
Messagetype = 2 = Sended Message

It all worked out when I manually changed Message type on my messages to "2" in your program. Now all messages are in one thread

Thank you for all your work. regards, Bart.

[mrmamon]

I got some problem.
every thing seem to be ok in All messages but if click into detail it will display "Loading..." for long long time and nothing happen.
How can I fix this problem?

[patzek]

Some more informations would be helpfully (what you have done, Rom Version..., which telefone ...) but i saw this kind of problem on my hero when i use a old database file (1.76.xxx) on a new rom (2.73.xxx)

[RemoteSojourner]

adb shell
   sqlite3 /data/data/com.android.providers.telephony/databases/mmssms.db
   ALTER TABLE sms ADD COLUMN index_on_sim INTEGER DEFAULT -1;
   (Press Control-D)
   exit

This should fix your db

[mrmamon]

Yep,Now I can transfered already after factory reset and get new db Thanks!

[hinz]

patzek, on Aug 20 2009, 15:31, said:

use this commands:

adb shell
su
cd /data/data/com.android.providers.telephony/databases
cat mmssms.db > /sdcard/mmssms.db
exit
exit

now you have the database on your sdcard and can be transfered with normal usb transfer

to write it back from the sdcard do:

adb shell
su
cd /data/data/com.android.providers.telephony/databases
mv mmssms.db mmssms.db.old
cat /sdcard/mmssms.db > ./mmssms.db
chown radio.radio mmssms.db
chmod 660 mmssms.db
exit
exit


hope this helps

Hi trying to do this on my hero but whenever I type the command 'su' it says

Quote

/ # su
su
/sbin/sh: su: not found
/ #

This is on a hero with Modaco custom rom 2.2 and cyanogen v1.4 +JF

please help

[hinz]

Ok I did all the steps and it had no errors but after restarting the phone i got an error message which says

Sorry -  The process com.android.phone has stopped unexpectely. Please try again - Force close - (this happens every 10 secounds or so and stop the phone from receiving signal)
Also
Sorry - The application Messages (process com.android.mms) has stopped unexpectely. Please try again - Force close
and
Sorry - The process com.htc.provider has stopped unexpectely. Please try again - Force close

no sms have been imported either :-(

any ideas?

Thanks

edit one error

Quote

# cd /data/data/com.android.providers.telephony/databases
cd /data/data/com.android.providers.telephony/databases
# mv mmssms.db mmssms.db.old
mv mmssms.db mmssms.db.old
# cat /sdcard/mmssms.db > ./mmssms.db
cat /sdcard/mmssms.db > ./mmssms.db
# chown radio.radio mmssms.db
chown radio.radio mmssms.db
chown: unknown user/group radio:radio
# chmod 660 mmssms.db
chmod 660 mmssms.db
#

Edited by hinz, 21 September 2009 - 11:38 AM.

[patzek]

hinz, on Sep 21 2009, 10:52, said:

Ok I did all the steps and it had no errors but after restarting the phone i got an error message which says

Sorry -  The process com.android.phone has stopped unexpectely. Please try again - Force close - (this happens every 10 secounds or so and stop the phone from receiving signal)
Also
Sorry - The application Messages (process com.android.mms) has stopped unexpectely. Please try again - Force close
and
Sorry - The process com.htc.provider has stopped unexpectely. Please try again - Force close

no sms have been imported either :-(

any ideas?

Thanks

edit one error

the error message says something radio:radio but on android it should be radio.radio
have you entered radio:radio or radio.radio?
alternative you can use 1001.1001 which is the user id and group id for radio

[hinz]

patzek, on Sep 21 2009, 12:42, said:

the error message says something radio:radio but on android it should be radio.radio
have you entered radio:radio or radio.radio?
alternative you can use 1001.1001 which is the user id and group id for radio

I noticed that too, I entered radio.radio.
Tried 1001.1001

and...

sucess

The sms's have been imported

However the text messages only show the what the other person has said and not the original message that I sent (i.e. a one sided conversation)
Is this normal? how can I import the messages that I sent so they show in the threaded view?
Ignore above - think I should have named Outbox as Sent Items

thanks again patzek awesome tool :-)

Edited by hinz, 21 September 2009 - 01:16 PM.

[Enake]

Hi patzek...

First, thank you very much for your application...

Works well but I have a little problem...

The date and hour in XML file are correct, but when I write the mmssms.db and copy to the phone all messages shows the same hour: 02:00

¿How can I correct this?

Thanks in advance.

[Enake]

Ok, if I put the hour with your application... it writes well to the android database...

The problem is that SMSImporter.exe don't read the hour, only the date...

Can you correct this in another version please?

Regards.

[Enake]

I downloaded the 0.1Alpha version and it reads the hour perfectly...

But that version have the problem of the "recipient_address"...

Hope you can solve this in a 0.5Alpha version...

Thanks.

Regards.

[Rough1977]

patzek, on Aug 20 2009, 16:31, said:

use this commands:

adb shell
su
cd /data/data/com.android.providers.telephony/databases
cat mmssms.db > /sdcard/mmssms.db
exit
exit

now you have the database on your sdcard and can be transfered with normal usb transfer

to write it back from the sdcard do:

adb shell
su
cd /data/data/com.android.providers.telephony/databases
mv mmssms.db mmssms.db.old
cat /sdcard/mmssms.db > ./mmssms.db
chown radio.radio mmssms.db
chmod 660 mmssms.db
exit
exit


hope this helps

After typing SU, I get:  SU: Permission Denied.
Any Idea?

Regards

[RemoteSojourner]

@Rough1977 I don't think your phone is rooted. You need to do that as well.