Results 1 to 11 of 11

Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.


Thread: Need to convert Iphone 4 addressbook (sqlitedb) to CSV, any advice?

  1. #1
    Default Need to convert Iphone 4 addressbook (sqlitedb) to CSV, any advice?
    Hi there.

    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,

    Whalien

  2. #2
    Superbad Modder-ator Simon's Avatar
    Join Date
    Nov 2007
    Location
    Bermuda
    Posts
    46,719
    Thanks
    6,952
    Thanked 15,502 Times in 7,090 Posts

    If you are on a Mac you can extract the contents including contacts from your backup with juicephone. On windows you can use iPhone backup extractor.

  3. #3
    Hey Simon,

    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.

    Cheers,

    Whalien

  4. #4
    Superbad Modder-ator Simon's Avatar
    Join Date
    Nov 2007
    Location
    Bermuda
    Posts
    46,719
    Thanks
    6,952
    Thanked 15,502 Times in 7,090 Posts

    Doesnt iPhone backup extractor extract the contacts as vCard file though?

  5. #5
    when i extracted the iphone 4, the file in the address book folder was called "AddressBook.sqlitedb". not a vCard file.

  6. #6
    Superbad Modder-ator Simon's Avatar
    Join Date
    Nov 2007
    Location
    Bermuda
    Posts
    46,719
    Thanks
    6,952
    Thanked 15,502 Times in 7,090 Posts

    This is what I see when using it. I click on the contacts link and it extracts to a folder in vCard format.



  7. #7
    looks like you're on a PC. i'm on a mac.

  8. #8
    Superbad Modder-ator Simon's Avatar
    Join Date
    Nov 2007
    Location
    Bermuda
    Posts
    46,719
    Thanks
    6,952
    Thanked 15,502 Times in 7,090 Posts

    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?

  9. #9
    not at home. possibly at work. thanks so much for all your suggestions.

  10. #10
    Superbad Modder-ator Simon's Avatar
    Join Date
    Nov 2007
    Location
    Bermuda
    Posts
    46,719
    Thanks
    6,952
    Thanked 15,502 Times in 7,090 Posts

    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.

  11. #11
    whalien: to get CSV out of sqlite
    If you're able to use and navigate the OS X Terminal.app -
    this should work:

    Code:
    $ sqlite3 -csv -header AddressBook.sqlitedb "select ROWID,First,Last,Middle,Organization,Department,Note,Kind,Birthday,JobTitle,Nickname,Prefix,Suffix,DisplayName from ABPerson"  > AddressBook.csv
    This will grab ALL fields, but may not import cleanly.
    Code:
    $ sqlite3 -csv -header AddressBook.sqlitedb "select * from ABPerson"  > AddressBook.csv
    If you'd rather not muck with typing things on the command-line,
    this one offers a 30 day free trial -
    RazorSQL Download
    I've never used it, and cannot guarantee it will work.
    Last edited by raduga; 09-30-2011 at 12:30 PM.

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •