er...that's it really. I'm curious as to which database holds the SMS's that come in. Is it one DB per folder (i.e., inbox, deleted items, etc) or does one database take care of all SMS's?
Thanks.
It's quite hard to find out, and it involves using a program like Pocket dbExplorer.
They are held in a system database, though in my experience it is never the same name from one installation to the next. A good way to look is to look at the number of messages in your sms inbox, then look for a folder (usually one of the larger ones) that has the same record count. The messages are stored in the expected way: fields for date, time, sender, message content etc. Depending on the program you use you can export or back up the table, but AFAIK they are all cross referenced and won't work 100% as before should you try to restore them after, say, a hard reset. You would also need to rename the table when restoring as it won't be the same any longer.
As far as SMSs YOU'VE sent, the process is much the same. However, this table appears even further cross referenced as even when you restore it and rename / overwrite it, the messages themselves are missing with only the headers showing in your Sent Items. If someone has a way to more effectively back up the texts (without using SMS Save or whatever it's called) then I'd be interested to know.
Cheers
Anthony
Thanks!
Export SMS/MMS/Email messages onto Storage Card
Hi,
Have you tried this one:
http://xpocketpc.fw.hu
Related
I have just installed one of the new ROM's (slueths) and I love how text messages now list as a conversation. I've restored my old text's using PPCPimBackup, but when I go to a conversation they are out of order. One particular one shows all of my replies, then as it gets older and older it shows the other persons messages. The dates shown seem to be correct though...
Is there a way to re-order the messages? Thanks.
Clear your inbox in the SMS program and then try restoring the backup again. It works for me, and a fair few other people have had success in the other threads this is covered in.
http://forum.xda-developers.com/showpost.php?p=1903404&postcount=749
That seems to have done the trick. Nice one, thanks.
Is it possible to remove/delete single messages from within the conversation?
Erm, is that a no?
'lo.
Apologies, I'm a bit of a noob around here. I asked about this in IRC and I got a few half-answers. Essentially, I'm one of those guys who keeps logs of most things. That said, I want to remove the text messages from my phone, but have them backed up and readable on my computer.
The reason for wanting to remove them has to do with the fact that someone suggested that the 1500+ text messages are (for some silly reason... text... of all things) slowing down my Fuze. This would make sense, since I noticed that using Mystic Series, my phone has slowed down over time... and since text messages (non-graphical in nature) are all that I've gained, this theory would make sense.
I've used PIM Backup... but how do I backup text messages to my computer where I'm able to read them?
Many thanks!
if you have a mac you could use missing sync which has that option while on the pc side i believe theres another software for it. But you could also use vito sms chat to make a complete backup of each conversation thats readable by a computer...
hey im looking for this too, but for windows
ive already researched jeyo mobile extender and pocketexport
which one of those is better and is there anything else?
tried out pocketexport, wasn't able to get it to function. Was going to do Vito SMS Chat, but didn't get around to it.
I ended up using Microsoft MyPhone. I happened to stumble upon the SMS "Archive to Internet" feature. Unfortunately, you can't just select "Archive All". You have to go by pages of messages (I had to "Archive All" 122 pages). However, everything is backed up in a readable format online, and it removes it automatically from your phone, giving you the option to restore later.
BeAuMaN said:
tried out pocketexport, wasn't able to get it to function. Was going to do Vito SMS Chat, but didn't get around to it.
I ended up using Microsoft MyPhone. I happened to stumble upon the SMS "Archive to Internet" feature. Unfortunately, you can't just select "Archive All". You have to go by pages of messages (I had to "Archive All" 122 pages). However, everything is backed up in a readable format online, and it removes it automatically from your phone, giving you the option to restore later.
Click to expand...
Click to collapse
One question. Does it put them back in there original threaded format?
Have you looked into Dashwire? It allows you to sync almost all of your phone content (or whatever you select) to a free online service. Text messages, contacts, pictures and videos, etc. I have been using it for a bit now and am pretty happy with it. If I can find a better option that will allow me to do this with a local machine I will take it as I would prefer to have everything on my own systems (I,too, am one who likes to keep copies of everything) and I have not yet tried to find a way to move the archives from the Dashwire service to my home systems.
The service definitely is not an ideal solution but it works for now.
myphone.microsoft.com. its awesome. use it.
I would be willing to start a bounty for a auto text delete app... like delete texts for each person after 100 texts... is this possible?
Its not auto, but try SMS Quick delete
No Offense. But Its not that hard to Delete Text Messages.
I agree with this post. I think getting sms quick delete to do a nightly scheduled delete would be amazing.
ebartolon said:
No Offense. But Its not that hard to Delete Text Messages.
Click to expand...
Click to collapse
I think youre missing the point.
I agree, btw something like this would be great. Either running to deleted messages by scheduled task and or delete message based on a specified count.
ebartolon said:
No Offense. But Its not that hard to Delete Text Messages.
Click to expand...
Click to collapse
It's not that hard to mail a letter via postal service, but I'd still rather email.
I think it's a great idea, you could adjust it to purge anything over x number of messages or older than x number of days.
I'd love to see this happen.
OP I think you may have a better chance by emailing SMS Quick Delete because they already have the app started...
I haven't looked into what APIs the SDK offers for dealing with text messages, but just thinking this through real quick, this shouldn't be a hard app to write.
When I get a text, it appears in both the stock app and in Handcent. This indicates that the messages are stored in a central location. The existence of Handcent and Chomp also make it clear that third party apps can access and manipulate this storage.
Performing tasks on a schedule is easy to code.
What sort of features would people like to see in this? Delete by age? Delete by count? Exempt certain contacts from having their messages deleted? etc...
I've been looking for an idea for a simple app to write to get more familiar with coding for the Android environment. If there's interest in something like this, it seems like as good a project as any to practice with.
subliminalurge said:
I haven't looked into what APIs the SDK offers for dealing with text messages, but just thinking this through real quick, this shouldn't be a hard app to write.
When I get a text, it appears in both the stock app and in Handcent. This indicates that the messages are stored in a central location. The existence of Handcent and Chomp also make it clear that third party apps can access and manipulate this storage.
Performing tasks on a schedule is easy to code.
What sort of features would people like to see in this? Delete by age? Delete by count? Exempt certain contacts from having their messages deleted? etc...
I've been looking for an idea for a simple app to write to get more familiar with coding for the Android environment. If there's interest in something like this, it seems like as good a project as any to practice with.
Click to expand...
Click to collapse
Issue is
1. You want to delete it when no one is sending you messages as to delete one you missed which would make you think that scheduled at night is best but...
2. Either count or time (i.e. middle of the night schedule) can screw you up if you get a message and the app then deletes it before you are able to check your messages...
I think it could be anything if you could prevent the deletion of new texts then I guess it wouldn't matter as much.
pipskicks said:
Issue is
1. You want to delete it when no one is sending you messages as to delete one you missed which would make you think that scheduled at night is best but...
2. Either count or time (i.e. middle of the night schedule) can screw you up if you get a message and the app then deletes it before you are able to check your messages...
I think it could be anything if you could prevent the deletion of new texts then I guess it wouldn't matter as much.
Click to expand...
Click to collapse
I see what you're saying, but if it's properly designed, neither one should really be an issue. If, for example, it's set to auto-delete anything over 30 days old, well, frankly if it's been sitting on your phone for 30 days and you haven't read it yet, then either it wasn't important, or you've been sitting in jail and likely have more important things to worry about.
Same with going by number of messages, you'd want the threshold set at a level where there's not really much chance of you not getting to it before it gets deleted.
Ideally, these thresholds would be user configurable. For me, deleting anything over 100 texts would easily retain a month's worth, but for my daughter, it would be blasting stuff that was only a few hours old. (I've honest to god seen this girl sleep with her phone in her hands, thumbs never leaving typing position....)
That said, it would definitely be a good idea to never, ever delete unread messages. Or, at least have separate criteria for unread messages.
isn't this a feature that's included in non-Sense messages app??? I much prefer that version, but I don't know how to replace the sense version with that one (if possible)
I think having delete by both age and number would be best... for example, if it could delete any message that is more than say 5 days old, up to the point where there is <10 messages left in the thread then stop deleting from that thread
and if you could adjust the two variables...
and:
adjust which persons messages get deleted...maybe even make it so that you could adjust the two variables individually depending on the person?
dmc971989 said:
maybe even make it so that you could adjust the two variables individually depending on the person?
Click to expand...
Click to collapse
Ultimately, that's the idea. Let each user specify their own criteria.
To be honest, if I decide to take a crack at this, my initial "proof of concept" version would probably just have a couple criteria hardcoded in, and then I would add configurability in increments.
The actual "guts" of this program should be crazy simple to code, but being new to Android, I'm still getting used to designing UIs on the platform, so that would be the portion that slows me down (and also the part that I'm looking to get some practice with...).
the file for storing texts is /data/data/com.android.providers.telephony/databases/mmssms.db
and no that's not a typo, there is a data folder within the data folder
also, by the way, I tried messing with it once to restore some old texts from a previous rom, and kept force closing my handcent and the stock app until I just deleted the file and let it recreate itself
Yeah honestly i am shocked that no one has done this. My friend and i have had so many texts our phone slows way down. And then when we try to delete txts of the contact(s) with the largest amount of texts the phone will lock up for along time or untill we pull the battery. After the phone lock up the texts are still there. i would be happy if all my contacts where limited to 100 texts. this issue normally happens around the 1000 mark (for a single contact) from what i have noticed.
Also this has happend on sevral roms that i have used so its def not a rom issue
danaff37 said:
the file for storing texts is /data/data/com.android.providers.telephony/databases/mmssms.db
and no that's not a typo, there is a data folder within the data folder
also, by the way, I tried messing with it once to restore some old texts from a previous rom, and kept force closing my handcent and the stock app until I just deleted the file and let it recreate itself
Click to expand...
Click to collapse
Yeah, that's a database file. Probably not a great idea to edit it directly, you would want to make changes through the sqlite interface....
any solutions?
Hi all, I'm using an unrooted HTC Wildfire and yesterday all of my texts just disappeared - about 8000 in total. I think it was after I recieved a text from someone. I reasoned that the messages have to still be on the phone somewhere due to the fact that data is just marked as overwritable, or am I wrong about that? Either way, I hunted through the SD card with some file recovery software (PC Inspector File Recovery, to be precise) and found a few files that may be useful - "com.gb.gosms-1.asec" in "android_secure" that's 4.09MB (about the right size for the data my messaging app was reading in the "Settings>Applications", and "40123", found in "LOST.DIR" that is 14.0MB, probably too large but the closest I could find as the other two in that directory were only a few hundred kilobytes.
I can't open any of them - I tried "40123" as .db and .xml files and the .ASEC file seems to be an encrypted Android file.
I'm looking for a few things, I guess - Where should I look to use the file recovery software to find the old SMS files? How do I open a .ASEC file, and might it be the right one? And does anyone know of any way to recover my texts? I just would quite like to recover my texts as there are some important ones on there!
Many thanks in advance, and sorry if I am repeating anything, I ran a search but couldn't find anything.
P.S., I am using GoSMS, but my stock messaging app is just as empty!
Why do you have 8,000 texts on your phone? Typically any SMS app you download will automagicly delete any texts once you collect a certain amount.
I like to keep all my messages so I can know what has been said and because there are some important texts in there, and I just double checked and couldn't find any settings like that in there, but I know it's disabled on my stock app and I had conversations ranging from about 5000 to 2 or 3 texts, but thanks for the suggestion!
I did, however, find a thing saying that I had sent 1900 messages in total, or thereabouts, which is a lot more than I sent since the messages went missing, a lot less than I have sent since I got the phone. Perhaps it is from when I started using Go SMS, but is it indicative of the messages still being on the phone somewhere?
Yes it is since you got Go sms because the stock messanging app doesn't count how many was sent. And no that doesn't mean that they are on your phone. It is simply a built in counter allowing you to keep track of your messages in case you don't have an unlimited messaging plan. Try downloading a file explorer and searching for your texts, that should all be backlogged onto your phone somewhere. Chances are though that the messages where deleted. Linux will overwrite information in order to better utilize your memory space. I recommend to back up any messages, or lock the ones you want kept to avoid this in the future.
Thanks very much, I'll do that
As per my original message, does anyone know how to open a .ASEC file?
I'd like to see my SMS conversations separated by contact (not just by number) on desktop. I'd rather not import all those old SMS into my new phone, but I'd like to archive them. I would not want to have everyone I used to text with as contact on the new phone. Therefore in the messagning app there would not even be names for them.
Every solution I found just creates one single big file (database, excel, xml, html, whatever), but it's often way too big, ugly, people merged, contact names not resolved, conversation means something entirely different. Is there a way to create many small files for everyone I have a conversation with? If not, this is a business gap.