- Enter the MySQL data source information as shown in the table below
Field | Description |
---|---|
Database Host Name | FQDN or IP Address of MySQL server, host should be reachable by the GD server |
Database Name | Name of designated database in MySQL server containing tables with information to be used to populate directory |
Database User name | MySQL user with at least read access to the database and tables to be used for directory |
Database Password | Password for MySQL User |
Database Table Name | Name of the table in the MySQL database containing information to be used to populate directory |
Database Charset (optional) | Database character set i.e. UTF8 – Last Name Column |
Last Name Column | Name of column containing last names data |
First Name Column | Name of column containing first names data |
Main Number Column | Name of column containing main telephone numbers data |
Mobile Number Column | Name of column containing mobile telephone numbers data |
Other Number Column | Name of column containing any other telephone numbers data |
Location Column | Name of column containing location data |
Title Column | Name of column containing title data |
Username Column | Name of column containing username data Note: If no username is present local contact attributes will be disabled for contact |
Additional Data Column | Name of column containing any other data which you would like to be present in the directory. |
- Click Save to add a data source and proceed syncing data source section 4.3
Post your comment on this topic.