From the skunk works here at Squidworks.net comes the ConnectWise Callers widget for the Digium SwitchVox PBX switchboard. The ConnectWise Callers Widget queries your Connectwise database for information about inbound callers calling in to your SwitchVox PBX. When a phone number is picked up from the caller ID it is then used to query the contact and company tables inside Connectwise. If it finds a match then it queries for key information about the caller including what company they are associated with and any personal information kept in the contact database.
The widget collects:
- Callers full name
- Callers Title
- Company Name
- Nick Name
- Married Flag
- Spouse’s Name
- Children Flag
- Children Info
- Anniversary Date
Of course this all relies on your database being complete and accurate, ConnectWise provides the table and the ability to add and edit this information within your company contacts area. Using this widget to query this information as fast as you can pick up the phone allows you to be heads up on your caller, making calls more personal and closing sales. The best part is it’s free!
Download ConnectWiseCallers here –> Connectwise-Callers-switchboard
The download zip file contains a single php file and 2 images. Extract all files to the same directory inside a web server that is accessible from your SwitchVox PBX . Your web server can be Windows or Linux but must be able to use (mssql_connect) to access Microsoft SQL servers (ConnectWise Database). If you are using Linux and need some help getting MSSQL working with Apache and PHP then see my how-to post http://www.squidworks.net/2011/07/how-to-setup-ubuntu-and-php-to-use-mssql-microsoft-sql-server/ and you should be up and running within minutes. You will need to edit the ConnectwiseCallers.php file between line 48 and 52. Edit the following lines to reflect your ConnectWise Database and user access to database.
//Connectwise Database access
$cwuser = “ConnectwiseUser”; <— Your Connectwise SQL User
$cwpass = “ConnectWisePass”; <— Your SQL Password
$cwdb = “cwwebapp_companyDB”; <— Your Connectwise Database name
$cwserver = “cw.yourdomain.com”; <— Your SQL server address
You will need to log into the SwitchVox Admin area and add the Custom panel. Goto the Tools menu and select Switchboard Panels, You should see the following:
Select the Custom Switchboard Panels tab from the admin and then select Create Custom Panel button.
- Panel Name = ConnectWise Callers
- Panel Description = Queries inbound callers for Connectwise information
- Panel URL = http://yourWebServerAddress/switchboard/ConnectwiseCallers.php?NAME=%CALLER_ID_NAME%&NUMBER=%CALLER_ID_NUMBER%&EXT=%EXTENSION%&LOAD=%FIRST_LOAD%
- Select the extensions you want to allow access to widget
Save Custom panel and launch your Switchboard, once the switchboard loads select your new panel from the add panel menu. You should get a ConnectWise Callers Image in you panel if it is accessible and your URL is correctly addressed. The panel should start out looking like this:
This is version 1 of the widget, we will be looking at expanding the widget in the next versions to allow you to edit the information so you can update you customers contacts on the fly. If you have ideas on data or features you would like to see in the next versions of the widget feel free to post your comments here and we will see if we can add them into the widget.