paradroid Posted September 30, 2008 Report Share Posted September 30, 2008 You can edit the phonebook the phonebook resides in \USER\UserData\PHONEDATA this can be used to edit the phonebook http://www.sqliteexpert.com/download.html I have an iphone and every contact showed up 3 times (mobile #, home # and work # ) but the display only shows the name so I couldn't see which is which (or what is what ) Quote Link to post Share on other sites
jrdiesel Posted September 30, 2008 Report Share Posted September 30, 2008 Thanks for the link, this looks way better than the DOS version I downloaded yesterday... Quote Link to post Share on other sites
Ellraz Posted October 1, 2008 Report Share Posted October 1, 2008 What do you change to add multiple phone entries to one contact? Quote Link to post Share on other sites
paradroid Posted October 1, 2008 Author Report Share Posted October 1, 2008 nothing, I change the names e.g. Peter Jones (M) Peter Jones (H) , ..... The unit gave me 2 the same names so I had to guess which was which Quote Link to post Share on other sites
tycoonbob Posted October 14, 2008 Report Share Posted October 14, 2008 I have an HTC Touch (Sprint) and I am having a problem syncing my contacts, so I was wondering if someone could upload a file of what it would look like if contacts synced correctly into this folder so I can just manually add all my contacts in. Just post here, PM me, MSN me [tycoonbob@Live], whichever. But it would be greatly appreciated. --I just got my F90BT installed last night [minus the VSS and Reverse wires as I am not sure YET where they go] and I am playing around a lot so I soon hope to contribute a lot to these forums in due time. =] Quote Link to post Share on other sites
Xxsrt4xX Posted October 17, 2008 Report Share Posted October 17, 2008 I have an HTC Touch (Sprint) and I am having a problem syncing my contacts, so I was wondering if someone could upload a file of what it would look like if contacts synced correctly into this folder so I can just manually add all my contacts in. Just post here, PM me, MSN me [tycoonbob@Live], whichever. But it would be greatly appreciated. --I just got my F90BT installed last night [minus the VSS and Reverse wires as I am not sure YET where they go] and I am playing around a lot so I soon hope to contribute a lot to these forums in due time. =] I have the Treo 700Wx (Sprint). What I had to do was in the contacts edit page, under "Categories" make sure the "CarKit" box is checked. Quote Link to post Share on other sites
pbernard Posted October 23, 2008 Report Share Posted October 23, 2008 Following up on the post about the Touch and the F90BT- I just installed my F90BT and tried to import my phonebook into it. The phone is paired but when I go to select a contact and beam it from my HTC Touch it says "To beam, select a device" but the Pioneer doesn't show up, hence no import. Any ideas on what is happening here? Thx! BTW - how do i get to USERDATA to do these entries? Quote Link to post Share on other sites
patbis Posted October 30, 2008 Report Share Posted October 30, 2008 I got a F900BT and a HTC S710 phone. I was able to transfer my phone book without any problems. Like paradroid I also had 2 - 3 times the same name. To get to the \USER\UserData\PHONEDATA you need to follow the steps on: http://www.avic411.com/forum/viewtopic.php?t=17542 Then I modified the file "PhoneBook1783b838a1.db" with sqliteexpert and added (H), (M) and (O). You even can delete contacts that you don't want in your F900BT. Keep in mind that when you change contacts in your phone and do a transfer again with your phone; all modification are lost in the db file and F900BT. So many thanks to paradroid Quote Link to post Share on other sites
skicrave Posted October 30, 2008 Report Share Posted October 30, 2008 Do you have the 2.0 update installed? It adds the type of number to the end of the listing, so manually editing your phonebook for that reason should no longer be required. Quote Link to post Share on other sites
patbis Posted October 31, 2008 Report Share Posted October 31, 2008 Yes, I did install the 2.0 update and it didn't added the type of number to the end of the listing. So the manually editing is still needed. Quote Link to post Share on other sites
skicrave Posted October 31, 2008 Report Share Posted October 31, 2008 Hmm, did you try re-uploading your phonebook afterwards, and what phone are you using? Quote Link to post Share on other sites
patbis Posted November 3, 2008 Report Share Posted November 3, 2008 Yes, I did reload my phonebook and everything was overwritten. I have a HTC S710 with WM 6 Quote Link to post Share on other sites
Gas Is Expensive Posted November 5, 2008 Report Share Posted November 5, 2008 Sorry, .db editing noob here... How do I save/export my .db file in SQLite so that I can upload the modified file to my unit? Also a huge THANK YOU for figuring this out. Quote Link to post Share on other sites
skicrave Posted November 5, 2008 Report Share Posted November 5, 2008 Click the save button (it looks like a disk). Quote Link to post Share on other sites
snolfi Posted November 8, 2008 Report Share Posted November 8, 2008 For anyone else who may end up needing to do this, I couldn't find an sql script to automate this so I downloaded the Expert Trial and saved the db out as a .csv. Then you can take this into a text editor (I used dreamweaver) and 'Find and Replace' the various ()- marks to be left with digits only. Reimport this back into your file with the 'Delete Existing Info' checked and you're done. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.