tycoonbob Posted October 15, 2008 Report Share Posted October 15, 2008 So I have a HTC Touch with WM6 and it sync's up nicely with my f90bt. But, I cannot transfer my contacts over. Total bummer...and what I want to do is find someone willing to copy their file from their Avic and send it to me so I can edit it, place my contacts in it using SQLite and then put it on my unit so I can have my contacts on there. I can't remember the exact location the file comes from on the Avic, but I do know that it is a .db file. Anyone help me out? If your worried about me getting your numbers or anything, just edit the file and xxxxxxxxxx your numbers. I just need to know how the format looks so i can do it with my contacts. Thanks Link to post Share on other sites
skicrave Posted October 15, 2008 Report Share Posted October 15, 2008 You'll also need the MAC address of your phone also, as the file is unique to each handset. Link to post Share on other sites
tycoonbob Posted October 15, 2008 Author Report Share Posted October 15, 2008 Alright, I can get that...is that what the file is named? I remember seeing my file in test mode, but of course it had nothing in it. But I can get my MAC address from my phone, if anyone knows exactly what I am to do with it. Link to post Share on other sites
BorisM Posted October 15, 2008 Report Share Posted October 15, 2008 Well, the file is named PhoneBook.db and is located in USER\UserData\PHONEDATA directory on the AVIC. Seems that it strips leading zeros from the MAC address. I would imagine that if you have paired the phone and at least attempted to transfer contacts, a blank file might be there. Link to post Share on other sites
HiFiSi Posted October 15, 2008 Report Share Posted October 15, 2008 Just grab the one you have on your unit and enter your contacts in it. If you have already paired your phone to the unit, the contacts database WILL be there, just empty. This is what the sql editor interface looks like And here is the info you need to enter for each contact: ID = order in which they are displayed on the contacts list (basically 1,2,3,4,5,etc. in order, has no effect on the actual display of the contacts on the unit) chShowName = name of contact (you can use the same name for more than 1 entry as long as each has a different "dwType" entry) chPhoneCode = phone number dwType = type of contact (1=home, 2=work, 3=mobile) Link to post Share on other sites
tycoonbob Posted October 15, 2008 Author Report Share Posted October 15, 2008 Just grab the one you have on your unit and enter your contacts in it. If you have already paired your phone to the unit, the contacts database WILL be there, just empty. This is what the sql editor interface looks like And here is the info you need to enter for each contact: ID = order in which they are displayed on the contacts list (basically 1,2,3,4,5,etc. in order, has no effect on the actual display of the contacts on the unit) chShowName = name of contact (you can use the same name for more than 1 entry as long as each has a different "dwType" entry) chPhoneCode = phone number dwType = type of contact (1=home, 2=work, 3=mobile) *Jump's up, run out to car to get empty file.* BRB, will give that a try. Link to post Share on other sites
tycoonbob Posted October 15, 2008 Author Report Share Posted October 15, 2008 So just went out to the car, popped in SD to boot up in test mode like normal, well music started playing right before the copy screen came up. Play from CD cause I was tuning my subs from music on cd last time i had avic regularly booted up. Just thought it was odd that CD played in test mode, volume knob worked, even the skip song by pushing left or right, worked. Link to post Share on other sites
Bman69 Posted October 15, 2008 Report Share Posted October 15, 2008 yea i was watching transformers with mine but without the video in testmode just could listen Link to post Share on other sites
tycoonbob Posted October 15, 2008 Author Report Share Posted October 15, 2008 Got em all done, once bluetooth connected, clicked contacts and they came up. "contact name (M)" or "contact name (H)" was a really good idea too, so now I know what phone number I'm calling. So I got my contacts working, basis of modding the unit, VSS hooked up, now all that leaves is that reverse wire. I'm not sure which wire on the tail light it goes to, so I didn't run it back there. It's hooked up to the back of the radio, but the other end is just rolled up under the carpet on the passenger side. So what does having that hooked up do anyway? I would assume make the back up camera come up when in reverse, maybe help Nav a liittle...anything else? Or would I even notice a difference with it hooked up vs. unhooked [without back up camera that is]? Link to post Share on other sites
skicrave Posted October 16, 2008 Report Share Posted October 16, 2008 I'm going to lock this topic, as the issue has been resolved. Search for your answer about the backup lead, it's been answered multiple times. If you still can't find the answer, post a new thread. Link to post Share on other sites
Recommended Posts