Has anyone found a way of saving sms messages to their pc? for both viewing or creating? I have 100s in my inbox and would like to keep them, but not sure how to do it.
Any info would be gratefully appreciated
Mitch
There are some programs that apparently do this, such as SMSExport, though I've never got these to work.
The only way I've found to do it - though as the II has more memory I've not done anything with them in months now - is to use a db program such as dbExplorer to export them to a csv file. There are other posts that detail how you find the particular table the messages are in, there isn't one folder that applies across all devices.
Cheers
Anthony
Try Jeyo Mobile Companion. Through your pc, you can view all your past sms, all incoming sms, and reply to them. You could back up all or some of your sms, and restore them later (if you want). You could choose to make the backups in text format.
And not only that ...
You can view your call history and make backup of those.
You can make screen caps of your ppc screen.
Hope this helps.
Try this one
:lol:
Jeyo's Mobile Companion is fantastic, exactly what I've been looking for since the first XDA came out.
Finally resetting your device (which I think is a good idea once every 6 months or so) doesn't mean you have to lose all your text messages.
Cheers
Anthony
Yes, I agree it is fantastic .... But it doesn't yet allow you to save SMS subfolders
The notification said I had new sms's.
The inbox status line says: Text Messages 0 items, 3 Unread.
Anybody some smart ideas?
mambaum said:
The notification said I had new sms's.
The inbox status line says: Text Messages 0 items, 3 Unread.
Anybody some smart ideas?
Click to expand...
Click to collapse
Had the same problem, Like it or not, it was caused by Spritebackup (and other backup programs do the same thing). Are you using some backup software on your device? If so that might be the cause. These programs have trouble with the databases (when restoring / patching the backup data into the database during a restore) and sometimes (or even pretty often) screw up the databases. There is a "CleanMail.exe" tool available from Sprite backup. I'll attach it to this post but you should go to their website to read about it if you are inclined to use it. It will wipe all the mail databases completely. Do a backup before using it, just in case the backup programs were not the cause of the problem.
If the problem persists there is no way around a hard reset. Had at one time lost my SMS folder altogether and couldn't get the registry fixed, so hardreset it was for me. Luckily I keep my daily backup files for 21 days, so I found a older backup with the reg intact.
Hope it helps.
CleanMail removed MMS
Hello
I tried the CleanMail util.
After running CleanMail util, I can send an MMS to myself,
but if try to receive it, it only contains an SMS...the picture is gone.
After syncing with outlook, only have 2 message boxes:
-mail
-sms
These two seam to work, now....I can receive sms'es again.
The mms box has disappeared.
Another solution
Another solution is posted here
http://forum.xda-developers.com/viewtopic.php?p=278434#278434
Hi,
I recently did a hard reset and I wanted to save my SMS messages so I backupped them with PIMbackup. I succesfully recovered the messages, but the sorting is al wrong in threaded mode! I read somewhere that going to normal and then back to threaded would solve the problem, but it didn't
For example:
Other person:
Yeah, i'll be there at 17.00
Other person:
Sure
Me:
will you go to [somewhere] and if yes, when will you be there?
Me:
can i ride along?
that is .. wel.. ridicoulous, can i solve it in some way?
thanks,
Hitisj
Well. PIMBackup was created before Threaded SMS came to WinMo. It restores Received text messages first, then the sent ones so yours come last. I was trying to find a way to restore in chronological order too :|
Kraize said:
Well. PIMBackup was created before Threaded SMS came to WinMo. It restores Received text messages first, then the sent ones so yours come last. I was trying to find a way to restore in chronological order too :|
Click to expand...
Click to collapse
Thanks for your reply. I think this is strange behaviour: Outlook on Vista sorts incoming messages by date too, not by the sequence they come in Oh well, MS...
It's the right way to restore SMS messages while in normal mode, and then turn to threaded mode to complete rebuild the all conversation threads. The messages would keep in order as they stay in the backup, resorting seen to be none sense.
Hi there.
I had problem with sms-messages after modaco-2.2 flashing.
When I got sms-message phone made sound and vibration but nothing to read in message program.
After reading couple hundred pages I found solution:
(Before you do this remember that this distroys your old mms and sms archive )
1. I found and downloaded adb.zip file and extracted it. You can get it from attacement. ( nope ... I can't upload it here )
2. Then I turned phones debugging on ( home-> menu-> settings-> Applications-> Developement -> USB debugging on
3. Wired phone to my mac
4. Opened terminal and then went to that directory where I extracted adb.zip
5. First checked device with command
./adb device
6. When everything was ok then shell command
./adb shell
7. Now prompt was #
8. Changed directory with command
# cd /data/data/com.android.providers.telephony/databases
9. Look that there was mmssms.db
# ls mmssms.db
10. Erased that file
# rm mmssms.db
11. Went out from shell
# exit
12. Went out from terminal
exit
13. Rebooted my phone and then everythin worked perfect.
I think that old mmssms.db file was different format than new one and thats why message-program could't use it.
I hope that this helps somebody.
...Lasse...
worked perfectly for me, thanks a lot of the tip!
The database from 2.73.405.5 build got a lot of changes to the old one (1.76.405.6). So it does not work to copy back the old Database after an update. I imported my old Mails manual to the new databasefile by accessing the database directly.
patzek said:
The database from 2.73.405.5 build got a lot of changes to the old one (1.76.405.6). So it does not work to copy back the old Database after an update. I imported my old Mails manual to the new databasefile by accessing the database directly.
Click to expand...
Click to collapse
Could you please describe how you restored your old data? I know it's a SQLite database and manually changed data in it before updating, but my knowledge with SQLite ain't that great, so I don't know "the perfect" SQL manager and so on...
Any advice is highly appreciated!
For me it was really easy as i only have SMS messages in my Database. So i wrote a very simple windows-app that imports the old messages out of the old database-file into the new database.
i have read about this fix in a german forum. it doesn't seem to fix the issue completely. i would suggest to keep smstomailbox installed for a while so we can be sure this really is a permanent fix.
This fix (german forum) does not work because the database got also changes in other parts of the database than the sms table. only in import into the new format will work.
patzek said:
For me it was really easy as i only have SMS messages in my Database. So i wrote a very simple windows-app that imports the old messages out of the old database-file into the new database.
Click to expand...
Click to collapse
Yes, I used your method when migrating from Windows to Android. It worked great and it was me who wrote directions for Notepad++ on how to change dates to proper format with regexp for other countries
Although, with the new Hero ROM database ROM seems to have changed in such a way that old message collides with new database/table structure. I will transfer new database to my computer and do some research soon.
sibbor said:
Yes, I used your method when migrating from Windows to Android. It worked great and it was me who wrote directions for Notepad++ on how to change dates to proper format with regexp for other countries
Although, with the new Hero ROM database ROM seems to have changed in such a way that old message collides with new database/table structure. I will transfer new database to my computer and do some research soon.
Click to expand...
Click to collapse
The SMSImport Application was done to import my SMS Messages from Windows Mobile. The application is based on the 1.76 Rom SMS Database.
After my Update to 2.73 is was in the same situation, how to get the messages into the new Databaseformat and so i wrote a second little application that just make a transfer from the old databsefile to the new databasefile Quick and Dirty
sibbor said:
Yes, I used your method when migrating from Windows to Android. It worked great and it was me who wrote directions for Notepad++ on how to change dates to proper format with regexp for other countries
Although, with the new Hero ROM database ROM seems to have changed in such a way that old message collides with new database/table structure. I will transfer new database to my computer and do some research soon.
Click to expand...
Click to collapse
patzek said:
The SMSImport Application was done to import my SMS Messages from Windows Mobile. The application is based on the 1.76 Rom SMS Database.
After my Update to 2.73 is was in the same situation, how to get the messages into the new Databaseformat and so i wrote a second little application that just make a transfer from the old databsefile to the new databasefile Quick and Dirty
Click to expand...
Click to collapse
Come on guys, lets share these about...
I have to migrate my brothers contacts from his Diamond to his Hero, he's on the 1.76 rom at the minute but will be upgrading to 2.73 later on.
I then have to import my messages from my old 1.76 database to my 2.73 database.
patzek said:
The SMSImport Application was done to import my SMS Messages from Windows Mobile. The application is based on the 1.76 Rom SMS Database.
After my Update to 2.73 is was in the same situation, how to get the messages into the new Databaseformat and so i wrote a second little application that just make a transfer from the old databsefile to the new databasefile Quick and Dirty
Click to expand...
Click to collapse
Ah, sorry I missunderstood. Please share your dirty solution with us ;-)! Btw, can one merge the old structure with the new one (two databases) and keep data intact from both? Or is it just a conversation from old to new structure, where you keep old messages? Either way, sounds great! I can manually add messages that I recieved in my new database "manually" afterwards
i will try to make an sql update script that will update the structure from the old database to the new one.
so i make a quick compare of the database files from a wiped hero 1.76 rom and an wiped 2.73 hero rom. the only difference is the column "index_on_sim" in the table "sms" as an integer field. an simple "alter table sms add index_on_sim integer null" would fix this. i think this field will store the id of an contact which is on the sim card stored, otherwise its value is "null" on messages that was sended and "-1" on messages that was received.
there are hugher differences between a normal android sms database and the hero one and and "easy" upgrade is not possible. its necessary to add columns to different tables and it is also necessary to have them in the right possition so that when a application try to access the column by the index and not with the column name it uses the right one. maybe there is a application in the www available that makes an automatic database update. for other databases like ms sql server there are solutions available...
patzek said:
so i make a quick compare of the database files from a wiped hero 1.76 rom and an wiped 2.73 hero rom. the only difference is the column "index_on_sim" in the table "sms" as an integer field. an simple "alter table sms add index_on_sim integer null" would fix this. i think this field will store the id of an contact which is on the sim card stored, otherwise its value is "null" on messages that was sended and "-1" on messages that was received.
there are hugher differences between a normal android sms database and the hero one and and "easy" upgrade is not possible. its necessary to add columns to different tables and it is also necessary to have them in the right possition so that when a application try to access the column by the index and not with the column name it uses the right one. maybe there is a application in the www available that makes an automatic database update. for other databases like ms sql server there are solutions available...
Click to expand...
Click to collapse
Yes, I've made this conclusion too. I've now merged my entire MMS/SMS database:
1) I exported both the 1.76 db and the 2.73 db as SQL dumps
2) Merged them together and got rid of lots of messed up data. Also I had to fix formatting for strings for the application to be able to import it properly again. Changed some ID's too.
3) Then I truncated the tables "sms" & "threads" + made minior fixes around the database (clean-up). and made changes to other ID's for it to look cleaner.
Since I've done SMS migration like this: Nokia > Windows Mobile > Android (Hero, v1.76) > Android (Hero, 2.73) there was some differences within the database. I fixed number formatting + updated data in proper places. Ex. sms.toa + sms.sc_toa (145 for one person and 0 for me), sms.person to correct ID for the contact (since there was diffs between the two Android databases and no person ID at all for earlier merged databases; Nokia + WM).
Side note: it seems sms.index_on_sim should be NULL for outgoing SMS'es and -1 for incoming (that's not stored on SIM card).
Also I added correct ID to the sms.person column for all my old SMS'es. First
Tx uttila for the sms problem solution
@uttila: it worked fine for me and my htc hero. I erased the database table mmssms.db and now it saves the messages
I have the Sprint version of the HTC Hero, Just got it a few days ago. I started noticing in about my second day having the phone that I wasnt receiving texts either. Same problem as everyone else, could send, make calls, receive calls, etc. Just couldnt recieve texts. After a while, i will eventually be able to recieve again, usually because I restart the phone, or that could just be a coincidence. But nevertheless I dont recieve any of the "lost" texts.
I just got off the phone with customer service with Sprint, They had me turn the phone off, take the battery out, and were doing some "updates" on their end. And then tried to send a text to me after turning it back on. They werent able to resolve the problem. They are telling me to take it to a Sprint store, so that they can run some tests on the phone, and send it off for a replacement.
I mentioned to the customer service rep that I've read about this problem online, that alot of people seem to be having the same problem. His response was "Yeah, I have been receiving some calls, but not to the point where we would consider it a known issue"
So I guess thats where we stand right now. Is there someway that I can fix it on my end, or is there an update out from HTC that resolve's this. Because it doesn't seem to just be a Sprint issue, since people overseas in Europe with different providers are having the same issue. So I'm guessing its a software\hardware issue, and not a network problem.
Any solutions?
Same Issue here.... about to send it back!
From Sprint's actual Hero forum users are reporting the same issue...
http://community.sprint.com/baw/thread/22913?start=30&tstart=0&reqsorting=dec
Hope posting this link is ok
Additionally it seems like some files are not being removed when performing a factory reset as I had installed a sound board and after two factory resets I noticed some sound files were still on my phone. TO me this indicates not all files are being removed correctly. I doubt the sound board messed anything up but this may indicate another app inadvertently did and the factory reset isn't cutting it as far as fixing the issue. Called Sprint and they offered to replace for free and also refreshed my syst settings which had zero impact.
Hello guys!
I've have one question. Now, I want to use my Leo as my main phone again over my Desire.
I've got a backup of my messages in Desire, but can't restore it on my Leo. When I click import, it says "Messages sucessfully saved" or something like this - but when I go to messages it is still empty. I've have about 600+ sms which is important.
Any good idea for importing software?
BUMP!
Anyone?