Discuss Blackberry to iPhone SMS at the iOS 3.x (iPhone OS 3.x) - Hackint0sh.org; Hey guys, I was on the iPhone for awhile and have a bunch of texts ...
Blackberry to iPhone SMS
Hey guys, I was on the iPhone for awhile and have a bunch of texts saved (>2000). I switched over to the Blackberry for a few months with >4000 texts. Was wondering how to move over the the texts from the Blackberry to show up under the iPhone sms history. I'm willing to do extensive work to make it happen.
So far I have accomplished,
Transferred all Blackberry sms into a text file on my Macbook
Extracted sms.db from /private/var/mobile/Library/sms
Downloaded SQLite to edit the database
Converted messages from sms.db to CSV format
My question is how to edit the date for .db from the Blackberry
ex. 1235681477 is Feb 26, 2009 3:51:17 PM or 1252032501 is Sep 3, 2009 10:48:21 PM
Also, once done editing the CSV file and import it back into the SQLite will it work by just editing the "messages" file?
Thanks for any help and suggestions.