Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version. Compare with Current ·  View Page History

These instructions should assist in configuring your ShoreTel to work with TIM Enterprise. If you are not familiar with PBX configuration, please contact your system maintainer.

Connection information Description
Connection type IP
IP method The ShoreTel stores its 'Call Detail Records' in a MySQL database which is located on the ShoreWare Server.

Configuring ShoreTel

By default, the CDRs are written to the MySQL Database.

The database that TIM Enterprise will connect to is called 'ShoreWareCDR'. You will need to create a username and password on the ShoreWare Server for the MySQL database so TIM Enterprise can connect to it. You may need to speak to your system maintainer to create this for you.

You will need to know the following information for TIM Enterprise to connect successfully to the Shoretel ShoreWareCDR database:

  • IP/DNS of the MySQL Database which is located on the ShoreWare Server.
  • Username and Password to connect to the ShoreWareCDR database.

Setting up a DSN connection for TIM Enterprise

You will need to setup a DSN connection for TIM Enterprise to work with the ShoreTel. Below you will find instructions on how to do this within Microsoft Windows:

  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 you will need to 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 Enterprise link to ShoreTel'.
  10. In the Server field enter the IP Address of the ShoreWare Server.
  11. In the Username field enter the username that was created for the ShoreWareCDR database.
  12. In the Password field enter the password that was created for the ShoreWareCDR database.
  13. In the Database drop-down list select 'ShoreWareCDR'.
  14. Now click on the Test button which will confirm if the information you entered is correct and connection is successful.
  15. Click on the OK button and then again to close the window.

Now you will be able to see the ShoreTel in the System DSN list.

An example of ODBC setup is shown below:

ShoreTel

Configuring TIM Enterprise

Below you will find steps on how to configure TIM Enterprise to listen for SMDR data from your ShoreTel:

  1. Browse to TIM Enterprise as normal and login with your credentials.
  2. Click on the Directory tab.
  3. Go the the point in the Directory where you need to add the PBX Object and add a PBX with the name 'ShoreTel'.
  4. Left-click on it and select Properties.
  5. From the General settings tab select ShoreTel from the PBX model list.
  6. ShoreTel
  7. In the Connection tab select Listen for connection from PBX from the Connection method list.
  8. The DSN field should show ShoreTel.
  9. In the Frequency field enter in 5.
  10. The DB script field should show ShoreTel.
  11. Finally, click on the Save button.
  12. ShoreTel
Labels: