Versions Compared

Key

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

...

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

HTML
<p>These instructions should assist in configuring your ShoreTel to 
work with TIM Plus. If you are not familiar with PBX 
configuration, please contact your system maintainer.</p>

<table class="confluenceTable">
	<tbody>
		<tr>
			<th class="confluenceTh" width=158>Connection information</th>
			<th class="confluenceTh">Description</th>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Connection type</b></td>
			<td class="confluenceTd"><b>IP
			</td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>IP method</b></td>
			<td class="confluenceTd">The ShoreTel stores its 'Call Detail Records' in a MySQL database which is located on the ShoreWare Server.
			</td>
		</tr>
	</tbody>
</table>

<h2>Configuring ShoreTel</h2>

<p>By default, the CDRs are written to the MySQL Database.</p>


<p>The database that TIM Plus 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 Plus can connect to
 it. You may need to speak to your system maintainer to create this for
 you.</p>

<p>You will need to know the following information for TIM Plus to
 connect successfully to the Shoretel ShoreWareCDR database:</p>

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

<h2>Setting up a DSN connection for TIM Plus</h2>

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

<ol>
	<li>Click on Windows <span class="button no_margin">Start</span>.</li>
	<li>Click on <span class="button no_margin">Control panel</span>.</li>
	<li>Double click on <span class="button no_margin">Administrative tools</span> icon.</li>
	<li>Double click on <span class="button no_margin">Data Sources (ODBC)</span> icon.</li>
	<li>Click on the <span class="button no_margin">System DSN</span> tab.</li>
	<li>Click on the <span class="button no_margin">Add</span> button.</li>
	<li>Select <span class="keyword">MySQL ODBC 3.51 Driver</span> from the list and click <span class="button no_margin">Finish</span>. If you cannot see the <span class="keyword">MySQL ODBC 3.51 Driver</span> you will need 
		to download this from <a href="http://www.mysql.com">http://www.mysql.com</a>.</li>
	<li>In the <span class="reference">Name</span> field enter the following: <span class="keyword">shoretel</span>.</li>
	<li>In the <span class="reference">Description</span> field enter the following: <span class="keyword">TIM Plus link to ShoreTel</span>.</li>
	<li>In the <span class="reference">Server</span> field enter the IP Address of the ShoreWare Server.</li>
	<li>In the <span class="reference">Username</span> field enter the username that was created for the ShoreWareCDR database.</li>
	<li>In the <span class="reference">Password</span> field enter the password that was created for the ShoreWareCDR database.</li>
	<li>In the <span class="reference">Database</span> drop-down list select <span class="keyword">ShoreWareCDR</span>.</li>
	<li>Now click on the <span class="button no_margin">Test</span> button which will confirm if the information you entered is correct and connection is successful.</li>
	<li>Click on the <span class="button no_margin">OK</span> button and then again to close the window.</li>
</ol>

<p>Now you will be able to see the ShoreTel in the <span class="button">System DSN</span> list.</p>

<p>An example of ODBC setup is shown below:</p>

<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_plus/pbx/shoretel_1.png" alt="ShoreTel" />

<h2>Configuring TIM Plus</h2>

<p>Below you will find steps on how to configure TIM Plus to listen for SMDR data from your ShoreTel:</p>

<ol>
	<li>Browse to TIM Plus as normal and login with your credentials.</li>
	<li>Click on the <span class="button no_margin">Directory</span> tab.</li>
	<li>Click on the site configured during the setup wizard and click <span class="button no_margin">Properties</span>or create a new site and click <span class="button no_margin">Properties</span>.</li>
	<img class="screenshot border" src="http://www.tri-line.com/common/img/documentation/tim_plus/pbx/shoretel_2.png" alt="ShoreTel" />
	<li>Within the <span class="reference">Site Properties</span> window, select <span class="keyword">ShoreTel</span> from the <span class="reference">PBX model</span> drop-down list.</li>
	<li>In the <span class="reference">Connection method</span> field select <span class="keyword">Connect to a system DSN</span> from the drop-down list.</li>
	<li>In the <span class="reference">DSN name</span> field select <span class="keyword">ShoreTel</span> from the drop-down list.</li>
	<li>In the <span class="reference">Frequency</span> field enter in <span class="keyword">5</span>.</li>
	<li>In the <span class="reference">DB script</span> field select <span class="keyword">ShoreTel</span> from the drop-down list.</li>
	<li>Finally, click on the <span class="button no_margin">Save</span> button.</li>
</ol><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.