maemo.org - Talk - View Single Post - Extract contacts from backup files

	manvik60	2010-07-29 , 15:17
	Posts: 128 \| Thanked: 46 times \| Joined on Mar 2010 @ Switzerland	#8

As nicolai already told, its in Berkeley-DB format. So you need some utility like db4.5_dump to dump the addressbook.db into more readable format.

I have cygwin installed on my XP and that includes db4.5_dump.exe in it. If you dont have cygwin, install it from here. At the page, right hand it says install. When you install make sure you install the db4.5 package also. Or you can install it in any other os you want,like ubuntu etc.

After install steps.
-- copy the addressbook.db to your PC.
-- open the cygwin prompt
-- cd to directory where the addressbook.db is and run below command,

PHP Code:


			
db4.5_dump.exe -p addressbook.db | sed -e '9,$ !d' \

-e '/^ pas-id/d' \

-e 's/\\0d\\0a/\n/g' \

-e 's/\\\\, / /g' \

-e 's/^ //' -e 's/\\00//' \

-e 's/\\c3\\89/É/g' \

-e 's/\\c3\\8a/È/g' \

-e 's/\\c3\\a9/é/g' \

-e 's/\\c3\\a8/è/g' \

-e 's/\\c3\\aa/ê/g' \

-e 's/\\c3\\a0/à/g' \

-e 's/\\c3\\a1/á/g' \

-e 's/\\c3\\a2/â/g' \

-e 's/\\c3\\a7/ç/g' \

-e 's/\\c3\\b4/ô/g' \

-e 's/\\c3\\af/ï/g' \

-e 's/\\c3\\ab/ë/g' \

> mycontact.vcf

Now this will convert your addressbook.db into a nice readable vcf format. Now you can use some tool to convert into excel or someother format (whatever you want)

This is not my code, but I have used it sometime back, so maybe some syntax error could be there. But you got the idea how to do it.

Quote & Reply |

The Following 5 Users Say Thank You to manvik60 For This Useful Post:
flair, nicolai, Tiboric, titou1234