Shoretel

Windows XP

Make sure the PC is set to UK time format (for current and system users). If this was not the case you will need to reboot to make this change take effect.

Windows 2008 Server

Make sure the PC is set to UK time format (for current and system users). If this was not the case you will need to reboot to make this change take effect.

Replace the following files with the matching ones from the 'Shoretel MySQL.zip' file.

C:\Program Files\Oak Telecom\Comms Suite\Core\Oak Collectors\ADOPort.bpl
C:\Program Files\Oak Telecom\Comms Suite\Core\ADOConfig.ini
C:\Program Files\Oak Telecom\ai office\VCE Library\ShoreTel SQL V8\ShoreTelMySQL_V8.xml
C:\Program Files\Oak Telecom\ai office\VCE Library\Shoretel SQL V8\Setup.Ini
C:\Program Files\Oak Telecom\ai office\VCE Library\ShoreTel SQL V9\ShoreTelMySQL_V9.xml
C:\Program Files\Oak Telecom\ai office\VCE Library\Shoretel SQL V9\Setup.Ini

Install the 'MySQL Connector' (supplied in the file 'Shoretel MySQL.zip')

'mysql-connector-odbc-5.1.5-win32.msi'

Configure in the Windows 'ODBC Datasource Administrator' a new 'System DSN'.

If you are on a 32bit Edition of Windows you can simply run the 'ODBC Data Source Administrator' from 'Control Panel | Administrator Tools'.

On a 64bit Edition of Windows run'C:\Windows\SysWOW64\ODBCAD32.EXE' instead.

Select the 'System DSN' tab and click 'Add'...

You will need to fill in the Server name/IP and a valid username and password

The database is always called 'shorewarecdr' and the port is '3306' by default but may have been changed on site. Use the 'Test' button to check you have a valid connection.

Configure the UDL file. In a 32-bit edition of Windows right click and select 'Properties';

or

In a 64-bit edition of Windows run: 

C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\Program Files (x86)\Oak Telecom\Comms Suite\Core\shoretel.udl

Note: We advise you to copy and paste the command line instruction into the 'Run' field to ensure the syntax is correct! 

Because the app and drivers are 32-bit you cannot use the 64-bit native 'Properties' facility. The 'Run' command listed above will invoke the 32-bit 'Properties' facility.

You will need to select a 'Provider' (Use the 'Microsoft OLE DB provider for ODBC Drivers').

Select the 'System DSL' name you created earlier and re-enter the 'Username' and 'Password'. as before. You will need to select 'Allow saving password'.

Select the initial catalog as the database 'shorewarecdr'.

Test the connection to check all is well and exit to save.

Configure this collector. Select the 'UDL' file created above ('Shoretel.udl').

Set the 'Database or PBX' type to 'Shoretel MySQL'.

Set the 'Operation Mode' to 'Incremental Gets'.

Select the 'Customization' tab and set this to the correct local time zone.

Note: Some Shoretel's are set to local time and not to UTC so this step may not be required.

Make sure the 'Field Delimiter' is set to ','.

Exit and save the changes and restart the 'CommServer'  and 'CallProcessor'.

The final step is to check to see if you are actually collecting call data from the 'ShoreTel PBX'. Click here to see if you are collecting from the 'Switch'.