Results 1 to 7 of 7
Discuss Opening iPhone Contacts - SQLiteDB at the Free Toolchain Software (Cydia App's) - Hackint0sh.org; I have screwed all my Contacts. Thanks to MobileMe and great OTA Sync technology. I ...
  1. #1
    Amazingly Knowledgeable Array jashsayani's Avatar

    Join Date
    Dec 2007
    Location
    Salt Lake City, UT
    Posts
    958
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    55

    Question Opening iPhone Contacts - SQLiteDB

    I have screwed all my Contacts. Thanks to MobileMe and great OTA Sync technology. I had done a backup with Funambol but it doesnot Backup the fields with custom labels. So, I need to read some old Contacts from my AddressBook.sqlitedb on my PC/Mac. Any software to Read them ?

    I cant over-write the file on the iPhone as these are old ones but has some nos. that are not on my iPhone.
    My iPhone
    iPhone 4 (32 GB) Black, Firmware 4.1

    My Mac mini
    2.0 GHz Dual core, 2GB RAM, 160 GB HDD, Leopard 10.5.8

    My MacBook
    2.0 GHz Dual core, 4 GB RAM, 160 GB HDD, SnowLeopard 10.6.4

    My Blogs:
    Jash's Blog: http://www.jashsayani.com
    The iFone Blog: http://theifoneblog.blogspot.com



  2. #2
    Senior Professional Array spektro's Avatar

    Join Date
    Mar 2008
    Posts
    178
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    15

    Default

    google for sqliteadmin !!!

  3. #3
    iPhone Moderator Array

    Join Date
    Aug 2007
    Posts
    3,620
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    220

    Default

    Quote Originally Posted by jashsayani View Post
    I have screwed all my Contacts. Thanks to MobileMe and great OTA Sync technology. I had done a backup with Funambol but it doesnot Backup the fields with custom labels. So, I need to read some old Contacts from my AddressBook.sqlitedb on my PC/Mac. Any software to Read them ?

    I cant over-write the file on the iPhone as these are old ones but has some nos. that are not on my iPhone.
    For Mac check here
    http://www.versiontracker.com/php/qs...cosx&submit=Go

    hope that helps (btw, I use MesaSQLite 1.6.8)

    v.
    Read the stickies and search the forum before posting!
    If you want to become a Hackint0sh supporter click here
    ----------
    iPhone 4 factory unlocked, iOS 4.3.1, jailbroken
    iPad Wi-Fi + 3G (1G), iOS 4.3.1, jailbroken
    iPad 2

  4. #4
    Amazingly Knowledgeable Array jashsayani's Avatar

    Join Date
    Dec 2007
    Location
    Salt Lake City, UT
    Posts
    958
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    55

    Default

    Quote Originally Posted by volkspost View Post
    For Mac check here
    http://www.versiontracker.com/php/qs...cosx&submit=Go

    hope that helps (btw, I use MesaSQLite 1.6.8)

    v.
    Thanks again.

    Thumbs up for you.
    My iPhone
    iPhone 4 (32 GB) Black, Firmware 4.1

    My Mac mini
    2.0 GHz Dual core, 2GB RAM, 160 GB HDD, Leopard 10.5.8

    My MacBook
    2.0 GHz Dual core, 4 GB RAM, 160 GB HDD, SnowLeopard 10.6.4

    My Blogs:
    Jash's Blog: http://www.jashsayani.com
    The iFone Blog: http://theifoneblog.blogspot.com

  5. #5
    Newbie Array

    Join Date
    Aug 2009
    Posts
    1
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default reading .sqlitedb files on a PC

    I'm in the same boat, using a PC with Windows XP. I have downloaded and installed SQLite Administrator, however have not figured out how to read the Addressbook file that i have. I simply want to read and copy information into Google contacts, which i now have set up to sync with my Iphone. Help?


  6. #6
    Newbie Array

    Join Date
    Aug 2009
    Posts
    2
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default sqlite to gdata.contacts

    Quote Originally Posted by violboy
    however have not figured out how to read the Addressbook file that i have.
    Sorry for stupid question, but does iPhone really store its local copy of addressbook in sqlite? If yes, which version? v2, v3? Do you know a DB schema for the addressbook data?
    On Linux I just run 'sqlite foo.db', then do '.tables' and/or '.schema' to see it
    I simply want to read and copy information into Google contacts, which i now have set up to sync with my Iphone. Help?
    For accessing Google Contacts API there are bindings to several PLs. I prefer python and I'm writing a gcontacts.py script to manipulate gdata.contacts from cmdline. Currently, it can add email and phone_number items to existing contacts and supports adding "primary" email/phone. I'm not sure it will be helpful to you in its current form, but if you are not in great hurry, maybe it will be of use someday. I'm planning to use gcontacts.py with another script to convert VCARD files from MOTO phone and upload MOTO addressbook to Google Contacts.
    With iPhone you need to write script pulling data from sqlite DB and pushing it to Google Contacts with gcontacts.py. But probably it's better to:
    1. store old DB, e.g.: mv contacts.db contacts0.db
    2. sync iPhone with Google Contacts - it will pull data from Google and create new contacts.db
    3. write script to merge contacts0.db into contacts.db
    4. sync iPhone with Google - this should upload new data to Google contacts
    Please note that I didn't try the last method myself and cannot guarantee it works

  7. #7
    Newbie Array

    Join Date
    Aug 2009
    Posts
    2
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default

    Quote Originally Posted by violboy
    I simply want to read and copy information into Google contacts
    Oops, /you don't need no/ automated tool, probably, just some sqlite2/3 client for Microsoft(R) Windows(TM) plus N times copy-paste.

 

 

Similar Threads

  1. Replies: 1
    Last Post: 01-27-2010, 07:36 AM
  2. SQLiteDB parsing
    By TeckniX in forum iOS 3.x (iPhone OS 3.x)
    Replies: 2
    Last Post: 08-10-2009, 06:14 AM
  3. Replies: 1
    Last Post: 11-11-2008, 03:20 PM
  4. Replies: 2
    Last Post: 11-09-2008, 02:17 PM
  5. Replies: 2
    Last Post: 12-29-2007, 12:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Powered by vBulletin®
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by vBSEO
(c) 2006-2012 Hackint0sh.org
All times are GMT +2. The time now is 06:10 PM.
twitter, follow us!