[AndroidTim]

Sorry for the doublepost

In what way can you get to the android sms-database? Using Astro or Linda doesn't work.

I succeeded exporting the Windows Mobile xml-file, but I just can't find a way to get to /data/data/com.android.providers.telephony/databases
What programm do I need to get to the sms database file on my Android phone? Yes, my phone is rooted.

[Sponsored Links]

[patzek]

i used the adb command from the sdk to copy the file to the sdcard and then the normal usb-transfer to get it on my pc.

[AndroidTim]

I used some adb commands like:

adb pull mmssms.db /data/data/com.android.providers.telephony/databases /sdcard

can't get the job done... I'm no developer, I tried to extract this detail from the guide. I got as for as the above line... I feel stupid.
It would be very very usefull if you could write a little howto on pulling and pushing the database file. In the style they did for rooting.
You bet, you'd help a lot of people if you did this.

[patzek]

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

[AndroidTim]

So! That's something completely different as I did...
Thank you for your reply.

The routine hangs during copy...

After:
cat mmssms.db > /sdcard/mmssms.db
The system comes back with "cannot create /sdcard/mmssms.db: read only file system"

Do you have a solution? I seems I have to chmod something first?

[patzek]

why should the sdcard mounted as read-only

can you post the output of mount?

adb shell
su
mount

[AndroidTim]

Here are the result of mount:

mount
rootfs / rootfs ro 0 0
tmpfs /dev tmpfs rw,mode=755 0 0
devpts /dev/pts devpts rw,mode=600 0 0
proc /proc proc rw 0 0
sysfs /sys sysfs rw 0 0
tmpfs /sqlite_stmt_journals tmpfs rw,size=4096k 0 0
/dev/block/mtdblock3 /system yaffs2 ro 0 0
/dev/block/mtdblock5 /data yaffs2 rw,nosuid,nodev 0 0
/dev/block/mtdblock4 /cahce yaffs2 rw,nosuid,nodev 0 0


All hocus pocus to me...

[patzek]

there is no sdcard mounted, so there are two reasons possible...

1. no sdcard inserted

2. hero is attached to pc with usb transfer enabled because then the sdcard is unmounted, so first disable the usb mode, then you can copy the file to the sdcard and after this you can reenable the usb transfer mode

[AndroidTim]

You're right; my device was still usb connected.
It all worked right now. All my sms messages are now transported from my windows mobile device to my HTC Hero!

Thankyou Patzek

[SKORPiO1975]

patzek, on Aug 19 2009, 22:37, said:

The Column "recipient_address" is Part from the Messagedatabase not from the XML File. So there is an error with your mmssms.db File. Have you selected the right one? Do you have a Hero? What kind of modification have you made to your telephone? Firmware Version?

You can also check your mmssms.db File with an SQLLite Explorer (there exists an Plugin for Firefox). The Column is Part of the Threadtable. Maybe you can take a look at this.

Thanks for this info. I have a Tmobile G1
Firmware 1.5
Baseband ver 62.33.20.08H_1.22.14.11
Kernel Version 2.6.27.00393-g6607056 san@sandroid #1
Build CRC1

Flashed w tmobile patched bin with root access. No other nods except previous downgrade to get root and now.. the rc1

When I look at the .db file I see Tables(13) / threads (not thread) and recipient_ids... I will attach a screen grab...

thanks again for all help.

[patzek]

The Messagedatabase from the Standard 1.5 Android Build looks a little bit different than the Hero one.
I try to add support for this kind of Database on afternoon.

[giankap]

patzek, on Aug 24 2009, 08:45, said:

The Messagedatabase from the Standard 1.5 Android Build looks a little bit different than the Hero one.
I try to add support for this kind of Database on afternoon.

Hallo patzek,
with the new version of your software I can now see messages from my Magic in data grid
When i try to write to the db, i get this message:

Cannot perform '=' operation on System.String and System.Int32

any idea?
thank you

[patzek]

giankap, on Aug 24 2009, 09:28, said:

Hallo patzek,
with the new version of your software I can now see messages from my Magic in data grid
When i try to write to the db, i get this message:

Cannot perform '=' operation on System.String and System.Int32

any idea?
thank you

I've added some more Debug Informations to the new build. Maybe you can post the errormessage here.

[giankap]

patzek, on Aug 24 2009, 20:30, said:

I've added some more Debug Informations to the new build. Maybe you can post the errormessage here.

I try tu put the image here. In any case there is an attachment with the errormessage.


thank you

Attached File(s)

•  New_Text_Document__3_.doc (44.5K)
  Number of downloads: 155

[SKORPiO1975]

patzek, on Aug 24 2009, 01:45, said:

The Messagedatabase from the Standard 1.5 Android Build looks a little bit different than the Hero one.
I try to add support for this kind of Database on afternoon.

WOW patzek, I must admit you kick some serious a** everything transferred fine and no errors. so your program works with G1 now

Although I have another lame question. Is it possible to merge transferred database into one thread?

What I have is my SMSes going back and forth with one person on my xml file. Android creates those threads between You and another person. When I transferred the .db it created "My" thread based on my phone number where only my SMSes are, and added other person's SMSes to existing thread that i had in my android phone. Now I have 2 threads, one "Me" with only my SMSes and "Other Person" thread which was merged. I was looking for a way to move "My" SMSes to another thread, but I don't think it is possible. Are there any managing tools for SMS database in android?

Thanks again for your time. You really have quick solutions for everything here

Regards, Bart.

ps: what does "Messagetype" column do in your program?

This post has been edited by SKORPiO1975: 26 August 2009 - 03:23 AM

[patzek]

giankap, on Aug 25 2009, 07:56, said:

I try tu put the image here. In any case there is an attachment with the errormessage.


thank you

New Release. Try it with this one.

[patzek]

SKORPiO1975, on Aug 26 2009, 03:21, said:

WOW patzek, I must admit you kick some serious a** everything transferred fine and no errors. so your program works with G1 now

Although I have another lame question. Is it possible to merge transferred database into one thread?

What I have is my SMSes going back and forth with one person on my xml file. Android creates those threads between You and another person. When I transferred the .db it created "My" thread based on my phone number where only my SMSes are, and added other person's SMSes to existing thread that i had in my android phone. Now I have 2 threads, one "Me" with only my SMSes and "Other Person" thread which was merged. I was looking for a way to move "My" SMSes to another thread, but I don't think it is possible. Are there any managing tools for SMS database in android?

Thanks again for your time. You really have quick solutions for everything here

Regards, Bart.

ps: what does "Messagetype" column do in your program?

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

This post has been edited by patzek: 03 September 2009 - 10:10 AM

[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.com/2009/09/how-to-impo...ndroid-devices/

[Sponsored Links]