[PaulOBrien]

I'm hoping to have a non root requiring version with extra features available in the next week or two...

P

[Sponsored Links]

[Egmel]

Paul, on Jun 15 2009, 22:08, said:

I'm hoping to have a non root requiring version with extra features available in the next week or two...

P

You are officially a star

What with this and sms-backup I can store all my messages safely

[Egmel]

Paul, on Jun 15 2009, 22:08, said:

I'm hoping to have a non root requiring version with extra features available in the next week or two...

How's this coming along?

[shericourt]

Hi,

I'm really interesting in your soft, but I can't find it on android market, do you know what happen?

Thanks...

[Chrisp77]

Is there any chance of an option where we can add xml files ourselves - ie an xml export from say a Symbian phone? I wish I could copy my Nokia SMS's to Android.

[PaulOBrien]

I can add this option.

In the market, search for 'modaco'!

P

[patzek]

Maybe i have done somethink wrong, but i tried to use this fine piece of software (over the Market) to get my WiMo SMS to my brand new Hero. I have root access to my hero but i think not in the way you need this for your software.
I dont know how your are doing this Message transfer, but when you access directly the SMS Database from the Android System is it possible to get an Version for the Windowspart on which i can select the databasefile by myself located on my Windows system? Because i was able to get the Databasefile.

When it is not possible then i have to try to do it by myself...

Thanks for your reply

[SKORPiO1975]

hmm After running windows side of the program it states that it is Unable to connect to Android device even though it is clearly visible in my device manager as Andrrid Phone in Portable Devices tree... what gives? I'm using Vista btw...

regards, Bart.

[patzek]

Finally i manage to import my SMS Messages by exporting the SMS from WM6 to an xml file and then native fill the android sms database with my own application. Worked fine for me.

[SKORPiO1975]

Would you be so kind and share ?

regards, Bart.

patzek, on Aug 4 2009, 06:14, said:

Finally i manage to import my SMS Messages by exporting the SMS from WM6 to an xml file and then native fill the android sms database with my own application. Worked fine for me.

[patzek]

This was just a quick and very dirty solution and its nothing for people who dont know what they are doing... but here is my way:

First of all you still need root access to your Android device to get the SMS Database file located in
/data/data/com.android.providers.telephony/databases
The file is called mmssms.db and it is a sqlite database. Make a copy of this file to your computer.

Then export your Windows Mobile SMS with this Tool: http://wince.nasenba...t/SmsImport.exe
This will create a single XML file of all your SMS Folders. Take this file also to your Computer.

Then, use my little programm attached here and open the xml file. But first change the Foldernames for the SMS folders. For me (German Windows Mobile Device) this was Posteingang for the Inbox and Gesendete Objekte for the Outbox. Take a look at the XML file there you find the foldernames. Now open up your xml file and let the programm read them. When you do it right then the Datagrid will show up your imported SMS Messages. Check, them. Edit them. Do what ever you want And at least select your Android SMS Databasefile and write your SMS Messages to the Database. Existing Messages in the Database will not be killed. And the last step copy back your mmssms.db file to your android device (check permissions and owner radio.radio 660) and restart your device.

This has worked for me (Importet 600 SMS without errors) but dont know if this will work with other users databasefiles and sms messages. I'm not responsable for damages or dataloss. Use it at your own risk.

Attached File(s)

•  Android.SMSImporter.rar (391.76K)
  Number of downloads: 651

[Egmel]

Any word on if there's a version of this for non-rooted phones? Or if it's even possible!

[SKORPiO1975]

patzek, on Aug 5 2009, 05:09, said:

And the last step copy back your mmssms.db file to your android device (check permissions and owner radio.radio 660) and restart your device.

Thank You for sharing you knowledge and application. I have two issues and I would greatly appreciate your help. The first thing is when I load the xml file, program does not read all messages. All of them are in one folder and there is about 480 of them. Second is the ability to set file permissions. What is the command I can use to change it. I cant use "touch" to see what the file has now. I know a little about linux and none of the commands I know seem to work here, and I'm not really following with your description "owner radio.radio 660"

Thank You for Your help, Regards, Bart.

[SKORPiO1975]

patzek, on Aug 5 2009, 05:09, said:

And the last step copy back your mmssms.db file to your android device (check permissions and owner radio.radio 660) and restart your device.

Thank You for sharing you knowledge and application. I have two issues and I would greatly appreciate your help. The first thing is when I load the xml file, program does not read all messages. All of them are in one folder and there is about 480 of them. Second is the ability to set file permissions. What is the command I can use to change it. I cant use "touch" to see what the file has now. I know a little about linux and none of the commands I know seem to work here, and I'm not really following with your description "owner radio.radio 660"

Thank You for Your help, Regards, Bart.

[patzek]

set the owner by: chown radio.radio mmssms.db
and the permissions by: chmod 660 mmssms.db

you can check the permissions by: ls -l

for your other problem, please investigate the missing messages entries in the xml file if they are looking different. maybe some special characters or something else.

[SKORPiO1975]

patzek, on Aug 7 2009, 23:06, said:

set the owner by: chown radio.radio mmssms.db
and the permissions by: chmod 660 mmssms.db

you can check the permissions by: ls -l

for your other problem, please investigate the missing messages entries in the xml file if they are looking different. maybe some special characters or something else.

I think I know what the problem is. I don't see any messages beyond 12th day of the month. My cell orders dates US style " MM/DD/YYYY" and I believe your program reads "DD/MM/YYYY" and disregards all messages after 12th day of the month. This is the reason why Im missing so many SMSes.

I think that converting the date format by hand would take me forever in simple editor.

too bad... so close yet so far away

Thank you for all help, regards, Bart.

[SKORPiO1975]

SKORPiO1975, on Aug 9 2009, 10:22, said:

too bad... so close yet so far away

Thank you for all help, regards, Bart.

oh... one more thing I forgot to mention. When I will try to write to db I get the following error message:

Column 'recipient_address' does not belong to table Table. [OK]

I really don't know what this one means. I went through xml file and changed all sender and recipient numbers to the same value because all I want to keep is conversations with only one person. Both mine and other persons numbers start with "+" and follow by the actual number. Every message has the following xml format:

<message date="MM/DD/YYYY HH:MM:SS" sender="+1234567890" recipient="+9876543210">message is here</message>

I hope I'm not bothering you with this too much

Thanks, regards, Bart.

[giankap]

excuse me patzek,
I've exported from WM to xml, the file seems to be ok. I changed the folder name in your program to Inbox e Sent Items but when, after selected the xml file, I click on the read button nothing happens. It show an empty table , but no message at all. Is there something I'm doing wrong?

thank you

[sibbor]

patzek, on Aug 5 2009, 12:09, said:

This was just a quick and very dirty solution and its nothing for people who dont know what they are doing... but here is my way:

First of all you still need root access to your Android device to get the SMS Database file located in
/data/data/com.android.providers.telephony/databases
The file is called mmssms.db and it is a sqlite database. Make a copy of this file to your computer.

Then export your Windows Mobile SMS with this Tool: http://wince.nasenba...t/SmsImport.exe
This will create a single XML file of all your SMS Folders. Take this file also to your Computer.

Then, use my little programm attached here and open the xml file. But first change the Foldernames for the SMS folders. For me (German Windows Mobile Device) this was Posteingang for the Inbox and Gesendete Objekte for the Outbox. Take a look at the XML file there you find the foldernames. Now open up your xml file and let the programm read them. When you do it right then the Datagrid will show up your imported SMS Messages. Check, them. Edit them. Do what ever you want And at least select your Android SMS Databasefile and write your SMS Messages to the Database. Existing Messages in the Database will not be killed. And the last step copy back your mmssms.db file to your android device (check permissions and owner radio.radio 660) and restart your device.

This has worked for me (Importet 600 SMS without errors) but dont know if this will work with other users databasefiles and sms messages. I'm not responsable for damages or dataloss. Use it at your own risk.

I gave your solution and a shot, did some investigation on how to transfer the database from Android back and fourth (pull/push)... and guess what!? IT WORKED!! successfully managed to import ~4200 SMS! Thanks to the XML approach (exported WM6 database) I was able to manually fix some names etc. before importing the new database to my HTC Hero.

Before merging the XML file and the SQLite database from Android I replaced some faulty names in my fav edior, Notepad++. Also I had to change the faulty date format (Y-d-m) to a proper one (Y-m-d). I used Notepad++ just like before and did the following:

• Open the replace dialogue (ctrl+H)
  
• Find what: date="([0-9]*)/([0-9]*)/([0-9]*) ([0-9]*)[0-9]*)[0-9]*)"
  
• Replace with: date="\2/\1/\3 \4:\5:\6"
  
• "Replace All"
  
• Saved the file... done!

Thanks a bunch patzek!!

[Magnetic_dud]

giankap, on Aug 9 2009, 22:25, said:

excuse me patzek,
I've exported from WM to xml, the file seems to be ok. I changed the folder name in your program to Inbox e Sent Items but when, after selected the xml file, I click on the read button nothing happens. It show an empty table , but no message at all. Is there something I'm doing wrong?

thank you

the same for me, what to do? (xp sp3 with .net 3.5)

[Sponsored Links]