Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

These instructions help you configure your ShoreTel phone system to work with TIM Plus. Contact your system maintainer if you are not familiar with the configuration of your PBX.

Pbxsummary
Supportfiles1ShoreTel.TDT
Supportfiles2ShoreTel.TDS
Supportfiles3ShoreTel.DBS
ConnectionDSN connection
RequiredTask1Configure the SMDR output
RequiredTask2Set up a DSN connection
RequiredTask3Configure TIM Plus

HTML
<a id="Configure the SMDR output"></a>

Configuring your SMDR output

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

Referencemacro
LabelShoreWareCDR
.  In order for TIM Plus 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 Plus 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 
    Referencemacro
    LabelShoreWareCDR
     database.

The default credentials for the ShoreWareCDR database are shown below:

Info

Username: st_cdrreport
Password: passwordcdrreport

HTML
<a id="Set up a DSN connection"></a>

Setting up a DSN connection

To enable TIM Plus 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
    Buttonmacro
    LabelAdministrative Tools
     icon
  2. Double-click on the Data Sources (ODBC) icon to open the ODBC Data Source Administrator window

    Info

    For a 64 bit system, access the ODBC Data Source Administrator from the following location C:\Windows\SysWOW64\odbcad32.exe

  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 Plus 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:

Screenshotmacro
Borderfalse
URL/download/attachments/4817113/shoretel_1.png

HTML
<a id="Configure TIM Plus"></a>

Configuring TIM Plus

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

  1. Click on the Directory tab.
  2. Choose the site you want to configure and click Properties.
    Screenshotmacro
    Borderfalse
    URL/download/attachments/4817113/shoretel_2.png
  3. 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 5.
  7. In the DB script field, select ShoreTel from the drop-down list.
  8. Click on the Save button to apply the settings.