Any way to manually insert SMS Messages into Android SMS Database ? - Android Software/Hacking General [Developers Only]

Hi guys ... I have a really silly question .. I have an old Blackberry Curve 8700 which has some very important SMSs in it .. I would like to copy over all the SMS from this Blackberry Curve 8700 into my new HTC Desire Z ... Problem is I dont see any tool for the Blackberry which allows me to export SMS messages .. So my only option is to maybe somehow open up the SMS Database for my Android phone is some editor, and manually plant the SMSs from my blackberry by manually typing them in, and also setting the correct times as to when I received them, or when I sent them out .. There are only like 10-15 messages so I don't mind manually typing them in if I have to, but because they are so important, I have to somehow copy them over ..
Any suggestions ? Is there any tool available for the Androids which allows you to dissect and operate on the SMS database in an Android phone at low level ?
Any other suggestions are welcome too ...

What exactly is a "very important SMS" and why couldn't you simply just record the information in a text file or write it down somewhere? Email it to yourself? Why does it need to be loaded into the SMS database of another device? Why must it remain an SMS?
I hope that's not prying, but I just can't seem to understand why it would need to be kept in "sms format"

deathsled said:
What exactly is a "very important SMS" and why couldn't you simply just record the information in a text file or write it down somewhere? Email it to yourself? Why does it need to be loaded into the SMS database of another device? Why must it remain an SMS?
I hope that's not prying, but I just can't seem to understand why it would need to be kept in "sms format"
Click to expand...
Click to collapse
Its actually a business related thing .. I have talks with clients and its very important you have a complete chronological record of all discussions in your phone .. So I would really prefer to copy them over if I can as this would make my life a lot easier later when referring to these conversations ..

By SQlite you can edit a sqlite file and put it back into

take pictures with your new phone of all the SMSes.

Use SMS Faker. It let's you put fake text messages on your phone at any time. To and from.
Sent from my GT-I9000 using XDA App

Related

Intercepting Text Messages

I get alot of text messages from some people and my partner would like to be able to intercept those messages so he can have a copy of them on his Wizard. How would he go about doing that?
You want all you SMS messages forwarded to another phone?
think he want to set rules for which ones are forwarded
Your "partner" can't intercept them.. But you can do one of two things..
Either create a program intercepting all incoming SMS'es, always forwarding them to him. You could append the sender phonenumber in the body of the sms or something so he'll know who it is from..
The other thing you could do .. is write a client/server app, so when you get an sms, it's intercepted and posted to a homepage/server you have.. Your partner could have a clientversion which regurarly synchronizes the data from the server and adds them to the cemail.vol file.. making it seem that he ha got the sms aswell..
Another thing again .. you could just make another app which sends the incoming sms as an email to your partner.. Many ways to do this.. but he can not intercept them.. you have to forward them either as an SMS, Email or pure data via a server solution you code/develop...
"Either create a program intercepting all incoming SMS'es, always forwarding them to him. You could append the sender phonenumber in the body of the sms or something so he'll know who it is from.."
he can also make a program which only intercept sms's from a list of phone numbers or where surden texts or char's are present
but the program would need to run all the time and periodicly check for new sms's
i would like a program to reject sms messages or mms messages by phone number like i was able to do with my old phone.
sashje said:
Your "partner" can't intercept them.. But you can do one of two things..
Either create a program intercepting all incoming SMS'es, always forwarding them to him. You could append the sender phonenumber in the body of the sms or something so he'll know who it is from..
The other thing you could do .. is write a client/server app, so when you get an sms, it's intercepted and posted to a homepage/server you have.. Your partner could have a clientversion which regurarly synchronizes the data from the server and adds them to the cemail.vol file.. making it seem that he ha got the sms aswell..
Another thing again .. you could just make another app which sends the incoming sms as an email to your partner.. Many ways to do this.. but he can not intercept them.. you have to forward them either as an SMS, Email or pure data via a server solution you code/develop...
Click to expand...
Click to collapse
I think I'll just go with the first suggestion. Thanks!
MOD EDIT:
this is obviously illegal.
lets move this discussion to the Q&A section
beastlybit81 said:
Hey all. Nearly 2 years have gone by since the last post in this thread and I know technology changes over time. I've done some reading about intercepting SMS/text messages but I was wondering if there are now any other ways to do this.
I want to be able to intercept text messages sent and received from one particular CDMA mobile phone number, or to have them forwarded to me without the person's knowledge. I don't have physical access to this person's phone, but if it helps I do have their ESN/MEID for their device.
I'm not so worried about intercepting phone calls or anything. I can get close enough to the user's phone though to be on the same cell tower as them if needed in order to intercept or have the SMS messages forwarded to me.
Are their any options for making this possible without direct access to this particular device? I understand the idea behind copying the identity of the target phone using a SIM card, but again, I don't have physical access to the phone in order to do that. Thanks!
Click to expand...
Click to collapse
Guys,
Isn't this illegal? You're literally asking to be the NSA or the government, snooping information without the person's information or consent?
Spying on a significant other?
Cheers.
good point. didn't read the last post.

Sending SMS from PC using Windows Mobile

Hi,
I want to send SMS from my PC using the Windows Mobile connected via Active Sync. Though there are numerous software available to do so, the specific feature I am looking is sending the SMS from excel file in which one column contains the Phone No and another the personlized SMS for each number.
I had searched a lot on the internet and could't find one.
Can you please help ?
Thanks in advance !!!
saurabh159 said:
Hi,
I want to send SMS from my PC using the Windows Mobile connected via Active Sync. Though there are numerous software available to do so, the specific feature I am looking is sending the SMS from excel file in which one column contains the Phone No and another the personlized SMS for each number.
I had searched a lot on the internet and could't find one.
Can you please help ?
Thanks in advance !!!
Click to expand...
Click to collapse
Well I don´t know about your "specific feature" but Pocket Controller can send SMS and lot more from your PC
Hope it helps,
orb3000 said:
Well I don´t know about your "specific feature" but Pocket Controller can send SMS and lot more from your PC
Hope it helps,
Click to expand...
Click to collapse
Hmmm, sounds to me like he wants to spam people rather than sending standard messages - can't think of another reason why you would want to have Excel List prepeared messages. If it wouldn't be meant to send out large amount of SMS, a SMS template would do!
I hate people doing that - here in the US you have to pay even for incoming messages, regardless if it was wanted or not!
Could be he wants to do a blanket "Happy New Year" message to all his friends.
Actually scrub that, you could just do one SMS to already existing contacts very easily so why the need to prepare an Excel sheet.
For remote control etc i use Jeyo Mobile Companion.
Junner2003 said:
Hmmm, sounds to me like he wants to spam people rather than sending standard messages - can't think of another reason why you would want to have Excel List prepeared messages. If it wouldn't be meant to send out large amount of SMS, a SMS template would do!
I hate people doing that - here in the US you have to pay even for incoming messages, regardless if it was wanted or not!
Click to expand...
Click to collapse
Hey !
I am not spamming anything, I want to send personalized SMS to my friends, relatives. etc.
I have to send around 250 SMS on this New Year and has made an excel containing the phone number and the personalized SMS.
Generally in India, people send standard SMS to everybody on such days but I just want to add my personal touch to it !!!
Spamming means to send standard SMS/emails to many recipients, but after reading your reply, it seems that your definition of spamming is very much different !!!
I do have Jeyo mobile, but copy and pasting each number and SMS will be bit difficult.
Hmmm,
I just wonder why you copied / wrote all the messages into an Excel sheet in first place?
As far as I remember, Outlook 2007 somehow supports sending out short messages - it has to be configured once but then it should work just fine.
http://messaging.office.microsoft.com/Overview.aspx
Junner2003 said:
Hmmm,
I just wonder why you copied / wrote all the messages into an Excel sheet in first place?
As far as I remember, Outlook 2007 somehow supports sending out short messages - it has to be configured once but then it should work just fine.
http://messaging.office.microsoft.com/Overview.aspx
Click to expand...
Click to collapse
I had not written all the SMS, just changed the standard SMS according to the person, like his/her name, saluation, etc. Basic text of all the SMS is same.
Excel provides tools like concanate, etc to create SMS with variable fields and that why I used it.
However I can convert that excel file onto .txt file also but the basic requirement remains the same, I want to send particular SMS to particular number only.
Jeyo Mobile Companion
i believe you can send sms messages through the computer using dashwire (www.dashwire.com), but im not sure if you can send multiple at once
sprinttouch666 said:
i believe you can send sms messages through the computer using dashwire (www.dashwire.com), but im not sure if you can send multiple at once
Click to expand...
Click to collapse
Thanks all for your help.
Anyways I did the using Jeyo Mobile and manually copying and pasting each SMS there.
I opened this new thread as I know one software which can be used with CDMA handset to send SMS from excel and that software is free.
I used it and it works like a charm.
I thought there would be some software for GSM also.
But anyways all your help was appreciated !
saurabh159 said:
Thanks all for your help.
Anyways I did the using Jeyo Mobile and manually copying and pasting each SMS there.
I opened this new thread as I know one software which can be used with CDMA handset to send SMS from excel and that software is free.
I used it and it works like a charm.
I thought there would be some software for GSM also.
But anyways all your help was appreciated !
Click to expand...
Click to collapse
What is the software program?
need help for same problem
hi this is bunny facing same problem i want to send sms from pc through mobile ,
data is in excel format , in excel i have 3 columns name, mobile, information
i wish to send different information to different members could you help me please please

Possible for auto text delete app kinda like mem killer

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?

[Q] Anyway to save entire SMS Chat from WM6.1 to PC?

Hey everyone,
I've wondering this for a long time and couldn't find a solution to my problem. I have samsung i780 and have upgraded it to windows mobile 6.1. It comes with the SMS displayed as a chat conversation, which is neat. I want to backup all these conversations, as they are.
When I try most SMS backup software,(like iMobile SMS backup or Godswmobile SMS transfer) they backup all the messages, but they don't save it in a conversation way. They split them into sent or received smses, and its really hard to make sense of things and its tiresome.
Is there any software that can save the entire conversation as they are displayed in wm6.1? (i.e sent-received-sent-received etc)
Or at least someone can think of in this way:
In the conversation window, I can select all, and then copy the messages to Microsoft word or Note. The problem is, it shows very few messages at a time(as the screen is small, so only like 7 or 8 are displayed at a time), and I have to keep clicking on 'Older' to go to the very first sms, which is like a 1000 click before. And its tiresome to copy/paste it in the word, and if one small error, you are pushed back to the very recent sms chat.
Cant I just access the main html/xml file on the mobile where all of this is stored? Anyone knows how to retrieve the file where all your SMS chat/conversation is saved?
Thanks
Okay, I found the software.
Jeyo Software is the one. God, I wish I had known such a software existed before. Its just beautiful.
One more thing, any idea how to restore contacts that were saved as .xml?
Thankx

Tool to export WhatsApp voice messages to computer in chronological and audible form

Hello dear XDAers,
try my luck here:
Since a family member died, I'm trying to preserve the memories of it and extract WhatsApp voice messages in a way that makes listening to them as easy as possible - ideally as it is presented in WhatsApp itself.
I have already moved WhatsApp to another rooted device.
What I don't want is a chat history with "11:19: voicemessage....opus" where I then have to manually go to each file in File Explorer.
In fact, it's pretty much exclusively voice messages with a little bit of pictures.
I have now installed WhatsApp in a VM, which works so far.
However, I have made the experience that WhatsApp at some point asks for an update or stops the service if, for example, the date of the VM is not correct.
Then I have to set up the whole thing again - even worse, if then the phone number should no longer be available.
The best thing would be a program that extracts the WA data (however, e.g. by pushing an old version) and then creates an HTML file or displays the chat history in the program itself in a WhatsApp style.
In any case, the voice messages would have to be embedded.
It may also cost something.
With the usual suspects such as from Mobiletrans, however, I have found no documentation on how the messages are displayed or only documentation in which the voice messages were then stored in a separate folder.
Thank you very much

Categories

Resources