ShoreTel PBX

...

By default, the ShoreTel phone system writes its CDR data to a MySQL Database,  called

Referencemacro
Label ShoreWareCDR

.  For In order for TIM Plus to connect to the database and collect the call logging data, you need to create a username and passwor for the MySQL databased on the ShoreWare Server. To achieve this, contact Contact your system maintainer if you You will need to know the following information are not familiar with this procedure.

The following information is required for TIM Plus to connect successfully to the Shoretel ShoreWareCDR database:

...

To enable TIM Plus to work with your ShoreTel phone system, you will first need to set up a DSN connection. Below you will find For instructions on how to do this within Microsoft Windows, follow the instructions below:

1. Click on Windows Start.
2. Click on Control panel.
3. Double click on Administrative tools icon.
4. Double click on Data Sources (ODBC) icon.
5. Click on the System DSN tab.
6. Click on the Add button.
7. Select MySQL ODBC 3.51 Driver from the list and click Finish. If you cannot see the MySQL ODBC 3.51 Driver in the drop-down list, you can download this from http://www.mysql.com.
8. In the Name field, enter the following: shoretel.
9. In the Description field, enter the following: TIM Plus link to ShoreTel.
10. In the Server field, enter the IP address of the ShoreWare Server.
11. In the Username field, enter the username for your ShoreWareCDR database.
12. In the Password field, enter the password for your ShoreWareCDR database.
13. In the Database drop-down list, select ShoreWareCDR.
14. Next, click Click on the Test button to confirm the information you entered is correct and whether that the connection is successful.
15. Click on the OK button to close the window.

...

Once the DSN connection has been setup, log on in to TIM Plus as usual and apply perform the following settingssteps below:

1. Click on the Directory tab.
2. Select Choose the site configured during the setup wizard you want to configure and click on Properties.
   

   Screenshotmacro
   Border false URL http://docs.tri-line.com:8090/download/attachments/4817113/shoretel_2.png

3. Within In the Site Properties window, select ShoreTel from the PBX model drop-down list.
4. In the Connection method field, select Connect to a system DSN from the drop-down list.
5. In the DSN name field, select ShoreTel from the drop-down list.
6. In the Frequency field, enter in 5.
7. In the DB script field, select ShoreTel from the drop-down list.
8. Click on the Save button to apply the settings.
   
   

...