Edit Your PhoneBook

[freakshow999]

Has anyone been able to successfully do this on an F500BT?

 

I went through all the steps and when it's completed and I reboot I get a no contacts found screen. Now I did delete entrys and changed the names around because it keeps importing them backwards from my blackberry. I did export to excel to re-edit the entry numbers then re-imported to the database editor.

 

TIA for any help

[ProfessorPlum]

personally I hate having shareware on my computer, with the nags for buying the product. The SQLite Expert, Professional edition is the one that has the useful feature however of being able to import and export and is not free, unlike the Personal edition, which is freeware.

 

However, you can import without the SQLite Expert Professional edition GUI interface, albeit using DOS commands. Here's a step by step on importing a comma delimted file with all your phone contacts. There should be 4 columns to every row - a unique ID, contact name, phone number, and a number which I believe is used for indexing in the contact screen interface (ABCDE, FGHIJ, etc):

 

1) install SQLite3 and put the file somewhere. For example, C:\Program Files\SQLite:

http://www.sqlite.org/sqlite-3_6_4.zip

 

2) open up a DOS window (Start, Run, cmd)

 

3) navigate to the directory where you installed the program, i.e C:\Program Files\SQLite.

 

4) Run this: SQLite3 path:PhoneBookXXXXX.db

 

where path: is the path where your db file is, and XXXXX is the 10 digit hex string of the .db file that you extracted out. Example: SQLite C:\My Documents\PhoneBook1a1b1c1d1e.db

 

5) at the sqlite> prompt, type in:

.separator ,

 

(I think the default separator is already a comma, but just in case)

 

6) at the next sqlite> prompt, type in:

import FILE Phonebook

 

where FILE is where your comma-separated file is located. For example:

import C:\My Documents\ContactList.csv Phonebook

 

7) Verify the file went in correctly:

select * from Phonebook;

[norcalmike]

I finally got around to editing my phonebook data for my iPhone 3G and now the voice dialing works and names show on the screen.

 

For those that use Firefox they have an SQLite add on that makes it really easy to edit the phonebook.db

[humblehyper]

Small problem with contacts, whenever I received a call it doesn't display the name instead just their phone number even if the phone number is already stored in the stereo. Is it supposed to be like this? I have a Nokia E51. Thanks.

[BitViper]

You all know that Excel can read and save CSV files....thres no need to dl a database tool..

 

Just an FYI

[BitViper]

You all know that Excel can read and save CSV files....thres no need to dl a database tool..

 

Just an FYI

[norcalmike]

I didn't have Excel and the Firefox add on is super easy to use and free

[Maverickster]

For those who are interested, the dwType column controls multiple numbers for each contact. Specifically:

 

0 = General (only use this if you only have one number for that particular contact)

 

1 = Home

 

2 = Work

 

3 = Mobile

[Petekazel]

OK I have a 9800bt. I edited my contacts using sqlite expert. My caller ID works but no voice recognition. I cannot figure this out for the life of me. Any help would be greatly appreciated.

 

Pete

[Kricket]

ive got a question - i have one phone that connects to the 700bt without issue - all of the contacts appear to be properly named and edited

 

i have another phone that does NOT connect correctly

 

is there a way i can copy the contacts database from the first phone into the database of the second phone (so that the contacts show up the same for both phones)? does that question make any sense?

 

i dont know very much about this database editing - so pardon my "noobishness"

[abefroman]

In SQLite:

 

Does it matter if the Recno and ID columns match? I had to delete some duplicate records and they don't match anymore.

[Kricket]

In SQLite:

 

Does it matter if the Recno and ID columns match? I had to delete some duplicate records and they don't match anymore.

 

im not sure if this was the cause or not - but i deleted a few entries and then renamed the id numbers to match up - this caused my system to crash - got some sort of fatal exception error

 

i had to get back into test-mode and completely delete the database to get going again - so my suggestion: try it without changing the id's

[dle619]

see my latest solution without involving copying xx.db file to SD card, it is a much better solution.

 

 

http://avic411.com/forum/viewtopic.php?p=152487#152487

[avic_weo]

of course you could also use Outlook as your Phonebook DB editor

 

http://avic411.com/forum/viewtopic.php?p=171817#p171817

 

(hint hint)