March 2009

Back up iPhone SMS messages into an excel database without jailbreaking [solved]

So here’s a somewhat complicated but entirely graphical way of backing up your SMS messages from your iPhone into an excel spreadsheet. I couldn’t get Syphone to work so here is my solution.

The first thing you’ll need is iPhone Backup Extractor. It’s a mac program, but there are other cross platform backup decoders out there such as mobilesync-inspect. You’re looking for the SQLite SMS database (iPhone Backup Extractor calls it SMS.db). iPhone Backup Extractor is not compatible with iPhone OS 3.0 yet but it does work with 2.2.1. Hopefully 3.0 will work soon.

Run iPhone Backup Extractor and select your most recent backup. Scroll down to the bottom of the applications and choose iPhone OS. Choose a folder to save it in.

iPhone Extractor

Then, use an SQLite browser such as SQLite Manager (don’t know why this is a firefox addon, but it rocks) to view the database.

export

All of the SMSes are stored in the messages table – you can right click on it and export it as a CSV. Alternatively you could export the whole database as an SQL or XML file. But open up the CSV in excel and you’re done! Sweet!

SMSes in excel

Sync notes with iPhone 3.0 beta

I’m trying the new iPhone 3.0 OS because I’m a registered developer. So far it’s sweet! My only issues so far are that wifi had trouble connecting at first, and my notes apparently didn’t sync.
Turns out my notes were in mail. They didn’t show up in my left hand navigation bar at first, but I tried doing “new note” and just writing “test”, and then the rest of them all showed up from my iPhone. (no clue where windows would put them.)
Hurray!