View Source

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.

<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 ShoreWareCDR. 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 ShoreWareCDR database.

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

Open Windows Control Panel and select the Administrative Tools icon.
Double-click on the Data Sources (ODBC) icon.
Click on the System DSN tab.
Click on the Add button.
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/.
In the Name field, enter shoretel.
In the Description field, enter TIM Plus link to ShoreTel.
In the Server field, enter the IP address or hostname of your ShoreWare Server.
In the Username field, enter the username for your ShoreWareCDR database.
In the Password field, enter the password for your ShoreWareCDR database.
In the Database drop-down list, select ShoreWareCDR.
Click on the Test button to confirm the information you entered is correct and that the connection is successful.
Click on the OK button to close the window.

An example of an ODBC entry is shown below:

<a id="Configure TIM Enterprise"></a>

Configuring TIM Enterprise

Follow the steps below to configure TIM Enterprise to collect the SMDR data from your Panasonic phone system:

Click on the Directory tab.
Choose the PBX object you want to configure and click Properties.
A new window will open. In the General tab, select Panasonic KX-TD Series from the Data format list and tick the Keep a local backup of data box, as shown below:
In the Connection tab, select Establish TCP connection to PBX from the Connection method list.
In the Host field, enter the IP address of your phone system.
In the Port field, enter 2300.
Leave the Username field blank.
In the Password field, enter the password required to connect to your phone system, by default PCCSMDR.
In the IP script field, select Panasonic from the drop-down list.
Click on the Save button to apply the settings.

<p>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.</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 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.</p>

<p>You will need to know the following information for TIM Enterprise 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 Enterprise</h2>

<p>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:</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 Enterprise 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_enterprise/pbx/shoretel_1.png" alt="ShoreTel" />

<h2>Configuring TIM Enterprise</h2>

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

<ol>
	<li>Browse to TIM Enterprise as normal and login with your credentials.</li>
	<li>Click on the <span class="button no_margin">Directory</span> tab.</li>
	<li>Go the the point in the Directory where you need to add the PBX Object and add a PBX with the name 'ShoreTel'.</li>
	<li>Left-click on it and select <span class="button no_margin">Properties</span>.</li>
	<li>From the <span class="button no_margin">General</span> settings tab select <span class="keyword">ShoreTel</span> from the PBX model list.</li>
	<img class="screenshot border" src="http://www.tri-line.com/common/img/documentation/tim_enterprise/pbx/shoretel_2.png" alt="ShoreTel" />
	<li>In the <span class="button no_margin">Connection</span> tab select <span class="keyword">Listen for connection from PBX</span> from the <span class="reference">Connection method</span> list.</li>
	<li>The <span class="reference">DSN</span> field should show <span class="keyword">ShoreTel</span>.</li>
	<li>In the <span class="reference">Frequency</span> field enter in <span class="keyword">5</span>.</li>
	<li>The <span class="reference">DB script</span> field should show <span class="keyword">ShoreTel</span>.</li>
	<li>Finally, click on the <span class="button no_margin">Save</span> button.</li>
	<img class="screenshot border" src="http://www.tri-line.com/common/img/documentation/tim_enterprise/pbx/shoretel_3.png" alt="ShoreTel" />
</ol>