Please Log In or Register - it's FREE!

3 Pages V  < 1 2 3 >  
Reply to this topicStart new topic
 Windows Mobile SMS Migrator [Beta 1]
Rating 5 V
giankap
post Aug 9 2009, 20:25
Post #21


Newbie
Group Icon

Group: Posters
Posts: 6
Joined: 10th August 2007
Member No.: 287,412

Device(s): HTC Magic



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
Go to the top of the page
 
+Quote Post
sibbor
post Aug 14 2009, 09:38
Post #22


Newbie
Group Icon

Group: Posters
Posts: 13
Joined: 19th April 2009
Member No.: 528,501



QUOTE(patzek @ Aug 5 2009, 12:09) *
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.nasenbaeren.net/smsimport/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 smile.gif 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:
  1. Open the replace dialogue (ctrl+H)
  2. Find what: date="([0-9]*)/([0-9]*)/([0-9]*) ([0-9]*)sad.gif[0-9]*)sad.gif[0-9]*)"
  3. Replace with: date="\2/\1/\3 \4:\5:\6"
  4. "Replace All"
  5. Saved the file... done!
Thanks a bunch patzek!! laugh.gif
Go to the top of the page
 
+Quote Post
Magnetic_dud
post Aug 15 2009, 16:10
Post #23


Enthusiast
Group Icon

Group: Posters
Posts: 263
Joined: 29th April 2005
From: Italy
Member No.: 126,630

Device(s): Samsung SGH-i600 (WM6)



QUOTE(giankap @ Aug 9 2009, 22:25) *
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)


--------------------
Weird things and Mitac Mio 8390 downloads on DanDanDin
Go to the top of the page
 
+Quote Post
SKORPiO1975
post Aug 15 2009, 17:09
Post #24


Newbie
Group Icon

Group: Posters
Posts: 14
Joined: 4th August 2009
Member No.: 571,749

Device(s): G1



QUOTE(sibbor @ Aug 14 2009, 03:38) *
  1. Find what: date="([0-9]*)/([0-9]*)/([0-9]*) ([0-9]*) sad.gif [0-9]*) sad.gif [0-9]*)"
  2. Replace with: date="\2/\1/\3 \4:\5:\6"


Sibbor,

Thanks for your input. Im trying to duplicate your search string but notepad++ cant see it (of cource i replaced sadface.gif with sad.gif .... ) and notepad cant see this string. Another question is how notepad weill know the order when only naming in the search string is "*" I'm a little confused with this search string... but the replacement looks logical if the values were somehow assigned in search.

Im not familiar with notepad++ search wild cards and sequencing

i think im just unlucky with this import smile.gif

thanks... Bart
Go to the top of the page
 
+Quote Post
SKORPiO1975
post Aug 16 2009, 05:19
Post #25


Newbie
Group Icon

Group: Posters
Posts: 14
Joined: 4th August 2009
Member No.: 571,749

Device(s): G1



QUOTE(SKORPiO1975 @ Aug 15 2009, 11:09) *
Sibbor,


ehh... never mind.... it works... I should just copy and paste smile.gif

but i have another problem. When I click on "Write" to .db than i ge following error message:

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

can anyone help?

thanks, Bart.
Go to the top of the page
 
+Quote Post
SKORPiO1975
post Aug 16 2009, 05:25
Post #26


Newbie
Group Icon

Group: Posters
Posts: 14
Joined: 4th August 2009
Member No.: 571,749

Device(s): G1



QUOTE(Magnetic_dud @ Aug 15 2009, 10:10) *
the same for me, what to do? (xp sp3 with .net 3.5)


Download notepad++ and open your xml file and see if indeed your folder names are Inbox and Outbox.

String is as follows <folder name="Inbox">

There is another possibility... you did not have your messages in Inbox or Outbox folders when you exported your messages from your windows mobile cell smile.gif

Regards, Bart.
Go to the top of the page
 
+Quote Post
SKORPiO1975
post Aug 16 2009, 05:31
Post #27


Newbie
Group Icon

Group: Posters
Posts: 14
Joined: 4th August 2009
Member No.: 571,749

Device(s): G1



ps: this is my format which reads fine:

<?xml version="1.0" encoding="UTF-8"?>
<SMSExport>
<store name="SMS">
<folder name="Deleted Items"></folder>
<folder name="Drafts"></folder>
<folder name="Inbox"><message date="07/12/2008 12:16:34" sender="+1234567890" recipient="+9876543210">message text goes here</message></folder>
<folder name="Outbox"></folder>
<folder name="Sent Items"></folder>
</store>
</SMSExport>

This program will only read messages from Inbox and Outbox folders... or whichever you will fill out


but I have another problem when merging the databases which i mention above sad.gif

regards, Bart.
Go to the top of the page
 
+Quote Post
Magnetic_dud
post Aug 17 2009, 15:13
Post #28


Enthusiast
Group Icon

Group: Posters
Posts: 263
Joined: 29th April 2005
From: Italy
Member No.: 126,630

Device(s): Samsung SGH-i600 (WM6)



got it, there might be a problem on how XML files are generated on wm standard
the xml is "unix formatted", i converted to DOS, encoded to UTF-8, and added <?xml version="1.0" encoding="UTF-8"?> on the top

and then there is another problem, my cellphone generates this:
<message date="12/30/2007 16:24:24" sender=""FriendName" <+12345678>" recipient="+888888888">Message text</message>

instead of:
<message date="12/30/2007 16:24:24" sender="+12345678" recipient="+888888888">Message text</message>
Go to the top of the page
 
+Quote Post
thklinge
post Aug 17 2009, 17:37
Post #29


Newbie
Group Icon

Group: Posters
Posts: 1
Joined: 17th August 2009
Member No.: 576,736

Device(s): HTC Hero / Xperia X1



Doesn't work. I've got a rooted Hero and have installed and started SMS Migrator on my Hero. I also installed the USB-drivers from modaco.com, and my Hero is identified as "HTC Dream Composite ADB interface". But when I start the program on my PC I get one of two errors:

* Unable to connect to Android device.
* Something about not having root?


The program then quits.
Go to the top of the page
 
+Quote Post
patzek
post Aug 17 2009, 20:58
Post #30


Newbie
Group Icon

Group: Posters
Posts: 43
Favorited Topics: 1
Joined: 3rd October 2008
Member No.: 433,044



QUOTE(Magnetic_dud @ Aug 17 2009, 15:13) *
got it, there might be a problem on how XML files are generated on wm standard
the xml is "unix formatted", i converted to DOS, encoded to UTF-8, and added <?xml version="1.0" encoding="UTF-8"?> on the top

and then there is another problem, my cellphone generates this:
<message date="12/30/2007 16:24:24" sender=""FriendName" <+12345678>" recipient="+888888888">Message text</message>

instead of:
<message date="12/30/2007 16:24:24" sender="+12345678" recipient="+888888888">Message text</message>


The number part gets extracted when there is a "FriendName" and a Number Part.


This post has been edited by patzek: Aug 17 2009, 21:08
Go to the top of the page
 
+Quote Post
patzek
post Aug 17 2009, 21:07
Post #31


Newbie
Group Icon

Group: Posters
Posts: 43
Favorited Topics: 1
Joined: 3rd October 2008
Member No.: 433,044



QUOTE(SKORPiO1975 @ Aug 16 2009, 05:19) *
ehh... never mind.... it works... I should just copy and paste smile.gif

but i have another problem. When I click on "Write" to .db than i ge following error message:

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

can anyone help?

thanks, Bart.


recipient_address is part of the thread table. when to program does not find this column then the file seems to be not the right one from a hero phone...
Go to the top of the page
 
+Quote Post
patzek
post Aug 17 2009, 21:10
Post #32


Newbie
Group Icon

Group: Posters
Posts: 43
Favorited Topics: 1
Joined: 3rd October 2008
Member No.: 433,044



QUOTE(giankap @ Aug 9 2009, 20:25) *
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


take a look at the created xml file and where the messages are stored in this file. then you find the right names for the folders
Go to the top of the page
 
+Quote Post
patzek
post Aug 17 2009, 21:15
Post #33


Newbie
Group Icon

Group: Posters
Posts: 43
Favorited Topics: 1
Joined: 3rd October 2008
Member No.: 433,044



QUOTE(SKORPiO1975 @ Aug 9 2009, 16:22) *
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 biggrin.gif

Thank you for all help, regards, Bart.


maybe it is a convertation problem for the date column. i extract the date as mm/dd/yyyy hh:mm:ss but convert it to a german date format. so i think this is the problem for the from date. maybe i can fix this tomorrow...
Go to the top of the page
 
+Quote Post
AndroidTim
post Aug 19 2009, 10:13
Post #34


Newbie
Group Icon

Group: Posters
Posts: 6
Joined: 19th August 2009
Member No.: 577,345



I tried Patzeks way of merging the messages...

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.
Go to the top of the page
 
+Quote Post
patzek
post Aug 19 2009, 19:58
Post #35


Newbie
Group Icon

Group: Posters
Posts: 43
Favorited Topics: 1
Joined: 3rd October 2008
Member No.: 433,044



I have open a new Topic for my SMS Transfer solution...

http://android.modaco.com/content/software...sms-to-android/
Go to the top of the page
 
+Quote Post
woody100
post Sep 9 2009, 11:48
Post #36


Newbie
Group Icon

Group: Posters
Posts: 4
Joined: 9th September 2009
Member No.: 585,232

Device(s): HTC Hero



I've tried this app a few times with no joy - seems to create 3 files on my desktop from my inital sync with my Hero, then says winmo process is complete - the confirms everything is sucessful and reboots my Hero...

just never seem to end up with my old texts, any ideas?
Go to the top of the page
 
+Quote Post
Killbox
post Sep 17 2009, 21:05
Post #37


Newbie
Group Icon

Group: Posters
Posts: 6
Joined: 17th September 2009
Member No.: 588,388



I just bought SMS migrator, but im getting a error message that I don't have root.  I have installed Instant root from Market. 

What do I do?

Go to the top of the page
 
+Quote Post
mrmamon
post Sep 18 2009, 09:59
Post #38


Newbie
Group Icon

Group: Posters
Posts: 5
Joined: 18th September 2009
Member No.: 588,538



Hi, I'm try to use wmsm to migrate from Eten glofiish x800 to t mobile g2 with MoDaCo'Custom ROM but after every thing seem to be ok

(or not? just only about 10 sec. to copy all of my hundred text message ) nothing found in my message on my android phone,What can I do in this case?

Go to the top of the page
 
+Quote Post
BG69
post Oct 7 2009, 09:08
Post #39


Newbie
Group Icon

Group: Posters
Posts: 3
Joined: 7th October 2009
Member No.: 595,121

Device(s): HTC HERO



QUOTE(woody100 @ Sep 9 2009, 12:48) *
I've tried this app a few times with no joy - seems to create 3 files on my desktop from my inital sync with my Hero, then says winmo process is complete - the confirms everything is sucessful and reboots my Hero...

just never seem to end up with my old texts, any ideas?


+1

Everything goes OK but then once my Hero has rebooted my old texts aren't there ....
Anyone ?

BG69
Go to the top of the page
 
+Quote Post
BG69
post Oct 7 2009, 20:26
Post #40


Newbie
Group Icon

Group: Posters
Posts: 3
Joined: 7th October 2009
Member No.: 595,121

Device(s): HTC HERO



Also, I wish I could give more detail (error messages, logs, ...) but again I get no error at all ...
If you know which logs to look into I could post them here. Thanks !

BG69
Go to the top of the page
 
+Quote Post

3 Pages V  < 1 2 3 >
Reply to this topicStart new topic

Collapse

Similar Topics

  Topic Replies Topic Starter Views Last Action
No New Posts Angry Birds Lite Beta
8 Paul 3,324 7th September 2010 - 16:56
Last post by: englishpunk
No New Posts SMS problem
Is the memory problem ?
9 ntanghe 421 Yesterday, 07:42
Last post by: Rumcájsz
No New Posts Topic has attachmentsSMS Notification LED - BETA 1.0
[UPDATE: 7th Sep]
10 Meltus 479 Yesterday, 22:21
Last post by: CharlieBareham
No new T Mobile and Orange network merger
16 Stevos 666 Yesterday, 17:58
Last post by: flibblesan
No New Posts T-Mobile USA 3G Dell Streak data being blocked
9 Wee Thomas 233 Yesterday, 23:19
Last post by: ben.g
No New Posts Mobile Version of modaco?
8 Morris Lee 334 Yesterday, 13:57
Last post by: Morris Lee

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 


RSS hit counter Lo-Fi Version Time is now: 9th September 2010 - 07:49

Please visit our 'Plus Partners' - these companies support MoDaCo through 'MoDaCo Plus' - Click Here for more details!

ActiveKitten | Binaryfish | Conduits | DeveloperOne | eSoft Interactive | FTouchSL | Inesoft | LastPass

Lingvosoft | monocube | OmegaOne | Omnisoft | Opera Software | Resco | SBSH | Splashdata

Sprite Software | Syncdata | Teksoft | Titanium Backup | VITO | WalkingHotSpot | WebIS | z4soft

Would your company like to become a 'Plus Partner'? Click Here to contact us!