How to convert "AddressBook.sqlitedb" to CSV or similar?

hey guys,

updated sisters iphone newest ios.
backed , everything... contacts did not sync. (fakkking apple) apparently common problem.

downloaded iphone backup extractor , have "addressbook.sqlitedb" file. but, don't know how convert csv or put on iphone. sisters phone not jailbroken can't use jail broken options.

, "iphone backup extractor" has limited functions unless buy full license...

can me convert addressbook.sqlitedb csv?

 

fix!

1. open addressbook database

open firefox , install sqlite manager add-on firefox, restarted firefox. goto web developer->sqlite manager. on sqlite manager window click open icon , selected addressbook.sqlitedb.

2. open execute sql tab , execute following query

select abperson.prefix, abperson.first,abperson.last, abmultivalue.value abperson,abmultivalue abmultivalue.record_id=abperson.rowid

if want more details;, e.g, notes, birthday, etc., use following query

select abperson.prefix,abperson.suffix, abperson.first,abperson.middle,abperson.last, abmultivalue.value, abperson.note, abperson.nickname, abperson.organization, abperson.department, abperson.jobtitle, abperson.birthday abperson,abmultivalue abmultivalue.record_id=abperson.rowid

, wollah, there contacts.

3. hit actions button , choose save result(csv) file

there have contacts in csv.

http://yogeshd.blog.com/2011/04/10/viewexport-contacts-from-iphone-addressbook-sqlitedb-file/

 

Forums iPhone, iPad, and iPod Touch iPhone iPhone

• iPhone
• Mac OS & System Software
• iPad
• Apple Watch
• Notebooks
• iTunes
• Apple ID
• iCloud
• Desktop Computers
• Apple Music
• Professional Applications
• iPod
• iWork
• Apple TV
• iLife
• Wireless