Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
sa32-00 [2014/07/31 14:52] – created davidbell | sa32-00 [2017/12/01 16:35] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== How to configure IQXCallerNotification application ====== | ====== How to configure IQXCallerNotification application ====== | ||
+ | |||
+ | |||
+ | The follow is a guide to installing and configuring the IQXCallerNotification application to connect to the Synety VOIP system. | ||
+ | |||
+ | 1) Add the following scripts to your IQX database: | ||
+ | |||
+ | <code SQL> | ||
+ | CREATE FUNCTION " | ||
+ | in @IncomingNumber char(100)) | ||
+ | returns char(100) | ||
+ | begin | ||
+ | DECLARE @Who char(2); | ||
+ | DECLARE @WhoID char(20); | ||
+ | DECLARE @PersonName char(30); | ||
+ | DECLARE @CompanyName char(60); | ||
+ | |||
+ | |||
+ | |||
+ | SELECT FIRST " | ||
+ | |||
+ | CASE | ||
+ | WHEN @Who = ' | ||
+ | SELECT " | ||
+ | return @CompanyName; | ||
+ | WHEN @Who = ' | ||
+ | SELECT " | ||
+ | return string(@PersonName,' | ||
+ | WHEN @Who = ' | ||
+ | SELECT " | ||
+ | return @PersonName; | ||
+ | ELSE | ||
+ | return ' | ||
+ | END CASE; | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | end; | ||
+ | |||
+ | |||
+ | </ | ||
+ | |||
+ | <code SQL> | ||
+ | CREATE FUNCTION " | ||
+ | in @StaffName char(25)) | ||
+ | returns char(120) | ||
+ | begin | ||
+ | DECLARE @AccountID char(20); | ||
+ | DECLARE @NotificationToken char(20); | ||
+ | SELECT AccountID, NotificationToken INTO @AccountID, @NotificationToken | ||
+ | FROM StaffSynety | ||
+ | WHERE StaffID = (SELECT StaffID FROM staff WHERE userid = @StaffName); | ||
+ | |||
+ | IF @AccountID = Null THEN | ||
+ | RETURN null; | ||
+ | ELSE | ||
+ | RETURN string(@AccountID, | ||
+ | ENDIF; | ||
+ | end; | ||
+ | </ | ||
+ | |||
+ | |||
+ | 2) Add the following files to either your IQX main program folder or create your own folder and add the files to that. | ||
+ | |||
+ | 1) IQXCallerNotification.exe | ||
+ | 2) IQXCallerNotification.exe.config | ||
+ | 3) Microsoft.AspNet.SignalR.Client.dll | ||
+ | 4) Newtonsoft.Json.dll | ||
+ | 5) DDE_run.exe | ||
+ | 6) iAnywhere.Data.SQLAnywhere.v4.0.dll | ||
+ | |||
+ | 3) Create a shortcut to point to the IQXCallerNotification.exe file and add it to your Startup folder. | ||
+ | |||
+ | 4) Got to the properties of your shortcut and at the end of the Target file add the following details: | ||
+ | |||
+ | 1) Database Engine Name | ||
+ | 2) Username | ||
+ | 3) Password | ||
+ | 4) Database Name (Optional) | ||
+ | |||
+ | Example: | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | |||
+ | === Error Reporting === | ||
+ | |||
+ | Any error that occurs is written to the IQXCallerNotification.err file. This file can be found in the same folder as the files above. | ||
+ | |||
+ |