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 help you configure your ShoreTel phone system to work with TIM Enterprise. Contact your system maintainer if you are not familiar with the configuration of your PBX.

Connection Type
  TIM Enterprise establishes a DSN connection with this PBX.

Support Files
  ShoreTel.TDT
  ShoreTel.TDS
Required Tasks
  Configure the SMDR output
  Set up a DSN connection
  Configure TIM Enterprise

Configuring your SMDR output

By default, the ShoreTel phone system writes its CDR data to a MySQL database called ShoreWareCDR.  In order for TIM Enterprise to connect to the database and collect the call logging data, you need to create a username and password in the MySQL database on the ShoreWare Server. Contact your system maintainer if you are not familiar with this procedure.

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

  • IP address or hostname of the ShoreWare Server where the MySQL database resides.
  • Username and Password of the ShoreWareCDR database.

Setting up a DSN connection

To enable TIM Enterprise to work with your ShoreTel phone system, you first need to set up a DSN connection by following the steps below:

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

An example of an ODBC entry is shown below:


Configuring TIM Enterprise

Once the DSN connection has been set up, log in to TIM Enterprise and perform the following steps:

  1. Click on the Directory tab.
  2. Choose the PBX object you want to configure and click Properties.
  3. A new window will open. In the General tab, select ShoreTel from the Data format list and tick the Keep a local backup of data box, as shown below:


  4. In the Connection tab, select System DSN connection from the Connection method list.
  5. In the DSN field, select ShoreTel from the drop-down list.
  6. In the Frequency field, enter to check for data every five seconds.
  7. In the DB script field, select ShoreTel from the drop-down list.
  8. Click on the Save button to apply the settings.


 

 

 

 

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: