Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.
09-30-2011, 09:23 AM #1Need to convert Iphone 4 addressbook (sqlitedb) to CSV, any advice?
My wife's Iphone 4 was stolen yesterday. I had an old 3G laying around but sadly, you cannot restore an Iphone 4 backup on a 3G. You can a 3GS, but that's no use to me. I managed to extract the address book database from the Iphone 4 backup, which is a sqlitedb file. No luck converting it to CSV or something readable by the Iphone 3.
Our only copy of the address book is on the Iphone 4 backup. Her contacts do not exist on a computer. I was hoping backing up the Iphone4 backup to the 3G would be painless. Turns out to be next to impossible. Any advice would be greatly appreciated.
Many thanks in advance,
09-30-2011, 09:34 AM #2
09-30-2011, 10:13 AM #3
Thanks for the advice. I was able to extract the Iphone 4's backup using Iphone backup extractor no problem. Did that last night. What the issue is, is importing the address book database from the extracted backup. The address book filetype is an sqlitedb, which isn't supported by address book on her computer. I was hoping to convert the sqlitedb to CSV.
09-30-2011, 10:33 AM #4
09-30-2011, 10:57 AM #5
when i extracted the iphone 4, the file in the address book folder was called "AddressBook.sqlitedb". not a vCard file.
09-30-2011, 11:08 AM #6
09-30-2011, 11:14 AM #7
looks like you're on a PC. i'm on a mac.
09-30-2011, 11:15 AM #8
Have you tried juicephone yet then? addPod - JuicePhone
Edit: I guess that wont work either, looks like it does the same thing. Just gives you the sqlite
No access to a windows computer?
09-30-2011, 11:31 AM #9
not at home. possibly at work. thanks so much for all your suggestions.
09-30-2011, 11:34 AM #10
No prob. I see a few sqlite converters when googling but TBH I have never used any of them so unsure if they are any good. May be easier to just take that backup onto a windows computer and use iphone backup extractor.
09-30-2011, 12:00 PM #11
whalien: to get CSV out of sqlite
If you're able to use and navigate the OS X Terminal.app -
this should work:
$ sqlite3 -csv -header AddressBook.sqlitedb "select ROWID,First,Last,Middle,Organization,Department,Note,Kind,Birthday,JobTitle,Nickname,Prefix,Suffix,DisplayName from ABPerson" > AddressBook.csv
$ sqlite3 -csv -header AddressBook.sqlitedb "select * from ABPerson" > AddressBook.csv
this one offers a 30 day free trial -
I've never used it, and cannot guarantee it will work.
Last edited by raduga; 09-30-2011 at 12:30 PM.