I still use this excellent utility, my old tilt and now tilt 2 aways syncs my contacts with last name first. The util works great but a couple of minor changes would make it so much faster to use. Any chance to get it updated? Once I correct all the names to be first name last name, reordering everything is quite tedious I have about 300 numbers in my phone book to correct and organize.

1. an auto-sort re-number feature to re-sort and renumber the contacts rather than moving them up/down.

2. In aditon or alternately drag and drop a contact row(s) rather than clicking to move it up or down in order.

All that mouse clicling is driving me nuts!

Thanks to the author for providing this for our use!

ZBB

I'm a .NET developer and wouldn't mind extending some the features of this program. Any chance of either open sourcing the program, or if not, could I at least get a copy of the source?

Failing that, would you be divulge some info, such as, is this just a SQL Lite DB?

Thanks!

The programm on page 1 is offline?

Where can me send the programm avicedit, please?

I'm a .NET developer and wouldn't mind extending some the features of this program. Any chance of either open sourcing the program, or if not, could I at least get a copy of the source?

 

Failing that, would you be divulge some info, such as, is this just a SQL Lite DB?

 

Thanks!

It is a standard SQLite file, so pretty easy to figure out...

I'm a .NET developer and wouldn't mind extending some the features of this program. Any chance of either open sourcing the program, or if not, could I at least get a copy of the source?

 

Failing that, would you be divulge some info, such as, is this just a SQL Lite DB?

 

Thanks!

It is a standard SQLite file, so pretty easy to figure out...

and yu could have a look at http://avic411.com/forum/viewtopic.php?f=34&t=25308&hilit=phonebook

weo

Does anyone have a copy of this avicedit? the link on the first page is no longer valid.

Thanks!

Also looking for a copy of the software, I've got 300 contacts on my phone but only need 10 in my car. The format that works on my phone transfers horribly to the phone.

Without the avicedit software it is still possible to roll your own with a minimum of hassle. You could use the Outlook based method, or you can use FireFox with the SQLite Manager addon.

Here is a way to start from scratch:

1. [*:414e90zo]open the addon, and create a new database
   [*:414e90zo]go to the "execute SQL" panel, and enter following SQL
   

CREATE TABLE phonebook
 (ID           INTEGER PRIMARY KEY,
  chShowName   TEXT,
  chPhoneCode  TEXT,
  dwType       INTEGER
);

[*:414e90zo]next you enter the relevant information in the newly created table via the "browse & search" tab.
Leave the ID blank, Name and PhoneCode speak for themselves
for dwType: 0=generic, 1=Home, 2=Business, 3=Mobile
[*:414e90zo]save and close
[*:414e90zo]rename the database to the appropriate name (with the Bluetooth identifier) and copy to your AVIC.

The same scenario applies for editing the AVIC phonebook. In that case, do not create a new DB, but rather go and fetch the copy from your AVIC.

Bear in mind the AVIC does not do any sorting. It simply displays the entries in exactly the same order as they appear in the DB. Also it is not a problem to have "holes" in the ID numbering, so simply deleting rows in the DB works out just fine.

That said, I prefer the Outlook based approach

have fun

Weo

Where can I get this? Can someone upload it? The file is not longer available.

I just use SQLite Expert Personal edition. It is free and works great.

I resorted to using this and it works but how to I put the contacts in alphabetical order? I tried rearranging the ID numbers manually but it wouldn't let me.

Where can I get this? Can someone upload it? The file is not longer available.

Which file do you mean? I can still access the Outlook macro I was talking about?

Weo

Which file do you mean? I can still access the Outlook macro I was talking about?

 

Weo

The one at the beginning of this thread.

Yep, the AVICEdit program. I used it myself a year ago and now I need to reorganize my phonebook but cant find the program. Cannot forgive myself for not saving it somewhere secure locally. Can someone please upload it?

anyone?

I resorted to using this and it works but how to I put the contacts in alphabetical order? I tried rearranging the ID numbers manually but it wouldn't let me.

Sorry, don't have the AVICEdit software.

But if you just want to sort your contacts, try the following:

• Generate a sorted CSV file with SQLite:
  enter following SQL (under the tab "execute SQL"), click on "Actions" and save as CSV
  

  SELECT * FROM phonebook order by chShowName

  
  

• Delete all records from the phonebook (Table->Empty Table)
  
• import the CSV you created using the Import Wizard
  

I know, it is a bit of a pain, but like I said: the AVIC does not do any sorting, it just takes all records sequentially

hth,

Weo