Jump to content


Windows Mobile SMS Migrator [Beta 1]

* * * * * 1 votes

51 replies to this topic

#1
PaulOBrien

PaulOBrien

    It's My Party

  • Founder
  • PipPipPipPipPipPip
  • 32,926 posts
  • Gender:Male
  • Location:Norwich, UK
  • Devices:Galaxy Nexus / TF Prime
  • Twitter:@paulobrien
What is it?

Windows Mobile SMS Migrator is a suite of tools that allows you to migrate your SMS Inbox and Sent Items from Windows Mobile to Android. The solution was produced super-quick for a customer requirement, and will be improved going forward (e.g. removing the need for root access, removing the need for a PC).

What are the requirements?
  • An application unlocked Windows Mobile device
  • An Android device with root access
  • A Windows PC
How does it work?

The application is launched from a Windows PC, and works in 4 phases:
  • Copy existing SMS database from Android device (with option to backup)
  • Copy SMS database from Windows Mobile device
  • Perform merge operation on Windows PC
  • Copy updated SMS database back to Android device
How do I use it?

To use the application, do the following...

Preperation
  • Download and install 'Windows Mobile SMS Migrator' from the Market on your Android device (99 pence)
  • Download and install the PC / Windows Mobile component of WMSM from here - Attached File  Windows_Mobile_SMS_Migrator.exe   2.36MB   3434 downloads
  • Ensure you have PC USB drivers installed for your Android device - you can get them from here if required - http://android.modaco.com/usbdrivers
  • Ensure you have ActiveSync or Windows Mobile Device Center installed on your PC for your Windows Mobile device
Use
  • Connect your Android device to your PC
  • Run WMSM on your PC
  • Follow the in program instructions as prompted, connecting the appropriate device as required. When the process is complete, your Android phone will reboot, and you'll be set!
NOTE: If you have a large SMS database on either device, there may be periods where the application looks as if it is 'not doing anything'. Patience... :D

Screenshots of the process

To follow...

Known Issues
  • There are currently no dialogues on screen when the application is busy (which can lead user to think it has closed)
  • Application is not detecting if there is a problem with the WM connection
  • There is no dupechecking atm - if you import more than once, you will get duplicates.
Changelog

Beta 1 (version 1.0):

Initial Release

Feedback

If you have any questions / suggestions / feedback about the migrator, feel free to post here!

P

You can follow me on Twitter - http://twitter.com/paulobrien / Follow MoDaCo on Twitter - http://twitter.com/modaco / Follow MoDaCo Android on Twitter - http://twitter.com/modacoandroid

Want to donate? MoDaCo is raising money for the Multiple Sclerosis society.

Posted Image


#2
PaulOBrien

PaulOBrien

    It's My Party

  • Founder
  • PipPipPipPipPipPip
  • 32,926 posts
  • Gender:Male
  • Location:Norwich, UK
  • Devices:Galaxy Nexus / TF Prime
  • Twitter:@paulobrien
If you would like to help me Beta test this app, please contact me!

P

You can follow me on Twitter - http://twitter.com/paulobrien / Follow MoDaCo on Twitter - http://twitter.com/modaco / Follow MoDaCo Android on Twitter - http://twitter.com/modacoandroid

Want to donate? MoDaCo is raising money for the Multiple Sclerosis society.

Posted Image


#3
Egmel

Egmel

    Newbie

  • Members
  • Pip
  • 15 posts
  • Devices:SPV E650

View PostPaul, on Jun 8 2009, 13:15, said:

If you would like to help me Beta test this app, please contact me!

P
I'd love to give this a go but don't currently have root access and the more I look into getting root access the more hassle it seems.  I'm on the latest version of android so would have to wipe my phone. :D

If you can get this to work without root access then I'm game for giving it a go.

Cheers
Helen

Edited by Egmel, 15 June 2009 - 02:27 PM.


#4
PaulOBrien

PaulOBrien

    It's My Party

  • Founder
  • PipPipPipPipPipPip
  • 32,926 posts
  • Gender:Male
  • Location:Norwich, UK
  • Devices:Galaxy Nexus / TF Prime
  • Twitter:@paulobrien
I'm hoping to have a non root requiring version with extra features available in the next week or two...

P

You can follow me on Twitter - http://twitter.com/paulobrien / Follow MoDaCo on Twitter - http://twitter.com/modaco / Follow MoDaCo Android on Twitter - http://twitter.com/modacoandroid

Want to donate? MoDaCo is raising money for the Multiple Sclerosis society.

Posted Image


#5
Egmel

Egmel

    Newbie

  • Members
  • Pip
  • 15 posts
  • Devices:SPV E650

View PostPaul, 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 :D

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


#6
Egmel

Egmel

    Newbie

  • Members
  • Pip
  • 15 posts
  • Devices:SPV E650

View PostPaul, 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?  ;)


#7
shericourt

shericourt

    Newbie

  • Members
  • Pip
  • 1 posts
Hi,

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

Thanks...


#8
Chrisp77

Chrisp77

    Newbie

  • Members
  • Pip
  • 2 posts
  • Devices:k750i
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.


#9
PaulOBrien

PaulOBrien

    It's My Party

  • Founder
  • PipPipPipPipPipPip
  • 32,926 posts
  • Gender:Male
  • Location:Norwich, UK
  • Devices:Galaxy Nexus / TF Prime
  • Twitter:@paulobrien
I can add this option.

In the market, search for 'modaco'! :)

P

You can follow me on Twitter - http://twitter.com/paulobrien / Follow MoDaCo on Twitter - http://twitter.com/modaco / Follow MoDaCo Android on Twitter - http://twitter.com/modacoandroid

Want to donate? MoDaCo is raising money for the Multiple Sclerosis society.

Posted Image


#10
patzek

patzek

    Newbie

  • Members
  • Pip
  • 43 posts
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


#11
SKORPiO1975

SKORPiO1975

    Newbie

  • Members
  • Pip
  • 14 posts
  • Devices:G1
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.


#12
patzek

patzek

    Newbie

  • Members
  • Pip
  • 43 posts
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.


#13
SKORPiO1975

SKORPiO1975

    Newbie

  • Members
  • Pip
  • 14 posts
  • Devices:G1
Would you be so kind and share :) ?

regards, Bart.

View Postpatzek, 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.


#14
patzek

patzek

    Newbie

  • Members
  • Pip
  • 43 posts
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 Files



#15
Egmel

Egmel

    Newbie

  • Members
  • Pip
  • 15 posts
  • Devices:SPV E650
Any word on if there's a version of this for non-rooted phones?  Or if it's even possible!   :)


#16
SKORPiO1975

SKORPiO1975

    Newbie

  • Members
  • Pip
  • 14 posts
  • Devices:G1

View Postpatzek, 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.


#17
SKORPiO1975

SKORPiO1975

    Newbie

  • Members
  • Pip
  • 14 posts
  • Devices:G1

View Postpatzek, 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.


#18
patzek

patzek

    Newbie

  • Members
  • Pip
  • 43 posts
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.


#19
SKORPiO1975

SKORPiO1975

    Newbie

  • Members
  • Pip
  • 14 posts
  • Devices:G1

View Postpatzek, 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.


#20
SKORPiO1975

SKORPiO1975

    Newbie

  • Members
  • Pip
  • 14 posts
  • Devices:G1

View PostSKORPiO1975, 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.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users