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 DatabaseMachine 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.