4

I have extracted my contacts2.db from a nandroid backup. I'd like to convert that to one or many .vcf files so that I can use my contacts in other applications.

I already found an answer that dealt with .db files but it did not work for this. I don't know if I did something wrong.

  • Do you want to export your contacts numbers or convert a .db file to .vcf? Because that is not the only way – Lucio Apr 10 '14 at 14:27
  • What kind of file is your .db file, actually? Post the output of file contacts2.db run from a terminal in the directory where the file resides. – tgies Apr 10 '14 at 14:30
  • @tgies contacts2.db is a sqlite3 database. – Oli Apr 10 '14 at 14:41
  • @Lucio Now I have the nandroid backup, so I extracted the contacts2.db, and I want to convert it to a .vcf file, so i could have my contacts in my new phone (I didn't use the google sync, I forgot) – user267502 Apr 10 '14 at 15:01
  • "ir did not work for this", how? – Braiam Apr 10 '14 at 15:48
6

This seems to have been answered on our Android sister-site by Chauncellor:

Well, this took a long time. For future searchers, here's what you can do:

Find your contacts2.db file hidden somewhere in Android. Most of the time it's located in /data/data/com.android.providers.contacts/databases. I was lucky and found it in a search through Titanium Backups' tarballs. Nab that file. It has everything in it in a sql database.

I then found this excellent script to extract and convert all contacts into a .vcf format for easy importing into the next device. It's located here on Github and requires two dependencies (on an Ubuntu 12.04 machine in which it was written for): sqllite3 and libsqllite3-dev:

sudo apt-get install sqlite3 libsqlite3-dev

After dependencies are satisfied, save the script on Github as dbconverter.sh. Mark it as executable:

chmod +x dbconverter.sh

use the script like this:

./dbconverter.sh contacts2.db > contacts2.vcf

You will then have a lovely .vcf file for easy importing into your phone.

There are also other programmatic approaches on SO:

  • ubuntu@ubuntu:~$ ./dbconverter.sh contacts2.db > contacts2.vcf bash: ./dbconverter.sh: No such file or directory ... I don't know what to do here! – user267502 Apr 10 '14 at 14:57
  • You have to download and make executable the script from github. – Oli Apr 10 '14 at 15:24
  • I downloaded the script, from the button on the right "Download Zip" and i did make the file "dbconverter.sh" executable, Properties,Permission tab, Check “Allow executing file as program.” – user267502 Apr 10 '14 at 15:52

protected by Community Sep 1 '15 at 15:58

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.