HowTO integrate Twiggi and WHFC

E-smith:

1) First create a user named hylafax with minimum access rights to twiggi.

[root@e-smith /root]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1023 to server version: 3.23.32

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> grant select on twiggi.* to hylafax identified by 'hyla!fax';
Query OK, 0 rows affected (0.01 sec)

2) Next using phpMyAdmin, change the twig_contacts field 'item' to be viewed by WHFC. Start phpMyAdmin, select twiggi > twig_contacts, find the field item and select change. Set the type from TEXT to VARCHAR and set Length/Set 100 as shown below:

Database twig - table twig_contacts

Field	Type	Length/Set	Attributes	Null	Default	Extra
item	VARCHAR	100		null

Windows Workstation:

Install the myODBC drivers from http://myEZserver.com/downloads/windows/. Then go set up the twiggi ODBC connection via:

Control Panel > Administrative Tools > Data Sources (ODBC) > and under the UserDSN tab, select Add:

Then choose mySQL > Finish

Fill in the information below substituting your e-smith server internal IP address.
Password = hyla!fax

OK to save and exit the Control Panel

WHFC:

Start the WHFC and open the Phonebook > add the phonebook named twiggi by typing twiggi in the top left box. Next select ODBC (FaxNo. from the same table). Select Database > Machine Data Source > twiggi > OK

Then Table for Userinformation = twig_contacts and select the fields shown below:

OK to save and now the WHFC will use the twiggi contact list as it's fax address book :-)

Note the field 'item' above is the Nickname field in twiggi contacts so make sure this field is filled in, under twiggi as you want it to appear in the fax address book. For instance the Nickname field should be a filled in with the users full name or a company name.