SMS Analyzer

merthsoft · File Archiver Joined: 09 May 2010 Posts: 2735

So I was talking to my friend about out texts, and he wanted to know how many were sent by him versus, and some various other bits of data. Well, I used a program on my phone called SMS Backup & Restore which lets me get an XML dump of my texts. Using some quick XPath I was able to figure out the sent and received, but we wanted more data, so I made this little program. Here's what it looks like right now:

So, my question to you all is, what kind of data would you want to see? I'll be adding average texts in a row (per person), average response time by the other person (that one might be a little tricky... I'll have to figure out what actually counts as a "response". It'll probably just end up being "average time between messages"), and average words per text (per person). What else would be good? If you want to play with it now, get SMS Backup & Restore on your Android phone, back up, get the XML file off the SD card, and download my program here:
http://merthsoft.com/SMSAnalyzer.zip

If you don't have an Android phone, I don't know what to tell you. If there's a way to get an XML dump of texts, and you send me a file, I can make it work for other phones, too.
_________________
Shaun

KermMartian · Posted: 18 Apr 2012 10:59:04 pm Post subject:

Graphs. I want graph everywhere. I want histograms of what time of day I send texts, what days of the week, what time of the month. I want graphs correlating (somehow) my texts sent to different people with each other. On a slightly more serious note (not that I'm not serious), does that application work on all Android phones?
_________________

merthsoft · File Archiver Joined: 09 May 2010 Posts: 2735

Ooh, those graphs would be neat. I'm not sure about the one correlating people, but the others would be cool.

It should work on all Android phones. It worked on my G1 with Android way-old, and my G2 with CyanogenMod.
_________________
Shaun

TheStorm · NOU! Joined: 26 Mar 2007 Posts: 2375

It should work on all android phones, and I think a cool feature may be to add support for reading the data from Gmails SMS backup+'s storage as well, since that is what I and a bunch of people I know use. But either way, hoteness Merth.
_________________

"Always code as if the person who will maintain your code is a maniac serial killer that knows where you live" -Unknown

"If you've done something right no one will know that you've done anything at all" -Futurama

"Have a nice day, or not, the choice is yours." Tom Steiner

<Michael_V> or create a Borg collective and call it The 83+
<Michael_V> Lower your slide cases and prepare to be silent linked. Memory clears are futile.

elfprince13 · Posted: 18 Apr 2012 11:28:43 pm Post subject:

Who's the lucky lady in second place for most texts?
_________________
StickFigure Graphic Productions || VSHI: Vermont Sustainable Heating Initiative

merthsoft · File Archiver Joined: 09 May 2010 Posts: 2735

That's Michelle. Though she's collected only 235 texts in the same amount of time as Josh collected 1557. Not very significant.
_________________
Shaun

elfprince13 · Posted: 19 Apr 2012 11:10:27 am Post subject:

merthsoft · File Archiver Joined: 09 May 2010 Posts: 2735

Haha, well, OK. She's not even in second place, though. The actual second place has 335 messages, but is off the list.
_________________
Shaun

merthsoft · File Archiver Joined: 09 May 2010 Posts: 2735

*Bump* Added some more data:

Download is the same:
http://merthsoft.com/SMSAnalyzer.zip
_________________
Shaun

allynfolksjr · Minor Calculator Deity Joined: 20 Apr 2005 Posts: 1273

You text Chris more than you text me? Sad

_________________
http://tcpa.calcg.org/

merthsoft · File Archiver Joined: 09 May 2010 Posts: 2735

Do I even have you number? Text me, my number's on my Facebook.
_________________
Shaun

allynfolksjr · Minor Calculator Deity Joined: 20 Apr 2005 Posts: 1273

comicIDIOT · Posted: 09 May 2012 02:44:11 am Post subject:

I'm extremely interested to try this with my phone, given that I've kept text logs going back a year and a half now.
_________________

-Alex

KermMartian · Posted: 09 May 2012 11:37:43 am Post subject:

Just as a tiny nitpick, may I recommend that you round off those numbers at some reasonable decimal-place value? I doubt you actually need 13 digits of decimal precision there. Smile

_________________

merthsoft · File Archiver Joined: 09 May 2010 Posts: 2735

Definitely a good point. I was just calculating and dumping, it's not at "production" quality or anything like that, just a demo.
_________________
Shaun

techboy6601 · Member Joined: 31 Jan 2012 Posts: 124

Since I don't own an Android phone, I'd appreciate if you sent me the raw .XML file. I'd like to make a web parser for it!
_________________
My graphics card is a crayon box.

comicIDIOT · Posted: 27 Oct 2012 08:18:30 pm Post subject:

techboy6601 · Member Joined: 31 Jan 2012 Posts: 124

Woops. Guess that was a misinterpretation - by "raw .XML file" I meant an example XML file based off the barebones structure.

As for the SQLite database:

1) Isn't it encrypted?
2) How do I get the database in the first place?
_________________
My graphics card is a crayon box.

comicIDIOT · Posted: 27 Oct 2012 08:38:14 pm Post subject:

Hm. I remember doing this before that whole encryption thing went around. Let me backup my phone and load the database again under iOS6.

But the file you want(ed) to find is: 3d0d7e5fb2ce288813306e4d4636395e047a3d28.mddata
_________________

-Alex

techboy6601 · Member Joined: 31 Jan 2012 Posts: 124

Yup, I've found it. Unfortunately I had it in an encrypted backup. I'm currently syncing right now. I wonder if it shows deleted SMSs as well.
_________________
My graphics card is a crayon box.