SMS & SQLite
Thursday, January 15th, 2009You might have recognised that lately I turned a bit quiet here?. Yeah, this happens from time to time when something does trap my interest totally.
Now in this specific case it was the wish to transfer all my stored SMS from the old mobile phone to my newly bought iPhone. Not Possible??
Hah! Sure there is no straight way to do and what a pity the original client software by Motorola does not even allow you to dump the info. But why shouldn’t it be possible though?
With a strong will there is a solution for every thing! Believe me!!
Now searching for info, I found snychonizing services on the net … How cool! Passing on the SMS to them and loose Origin and Timestamp at the end? NEVER!
But querying Google brought up the info that there are P2KTools to dump the Motorola and even they have issues, I was able to dump the messages into ascii files.
This was a beginning for sure.
But now back to the iPhone. How to syncronize it? Looking into things brough up the info about http://youarchive.it and a loadable tool called iTextuploader. A quick test of both ended up with the sureness it works reliable and fine. Checking options even told me there is a bidirectional exchange possible, but the web frontend didn’t allow me to add the older messages.
Ok! So there seemd to be no quick solutions at hand first. Next investigation brought up the info that on the iPhone the SMS info is stored within a SQLite database …a database???
Great! That was the answer of everything. Downloading the db from the iPhone was easily done. In fact – lazy as I was – I just did send it as an email with attachment to myself.
Then it needed 10 to 15 minutes analyzing the internal structure of the database and another hour adding the messages and adjusting and correcting the database integrity again.
Uploading it directly to the device?! Nah, the risk damaging my new SMS info by overwriting the db directly seemed to high.
So I went back to the webservice and used their "old way" uploading messages through the webinterface by uploading the db … in that case the prepared one.
And?! Nothing! No complains, no warning, no errors …. purely loaded and now visible within the web application.
With the offered export funtion of the pages I marked all message for to restore them on the phone and back at the iPhone I told iTextuploader (uploader ROFL) to download them.
Wasn’t that easy? Now I have SMS info on the iPhone out of a time the device was not even invented.
