====== 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:
CREATE FUNCTION "pears"."IncomingCallerIDLookup"(
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 "phone"."who", "phone"."whoid" into @Who, @WhoID FROM "pears"."phone" WHERE "pears"."phone"."numberdigits" = @IncomingNumber ORDER BY "pears"."phone"."whoid";
CASE
WHEN @Who = 'C' THEN
SELECT "company"."name" into @CompanyName FROM "pears"."company" WHERE "pears"."company"."companyid" = @WhoID;
return @CompanyName;
WHEN @Who = 'CP' THEN
SELECT "person"."name", company.name into @PersonName, @CompanyName FROM "pears"."employment" key join ("pears"."person" , pears.company) WHERE "pears"."employment"."employmentid" = @WhoID;
return string(@PersonName,' (',@CompanyName,')');
WHEN @Who = 'P' THEN
SELECT "person"."name" into @PersonName FROM "pears"."person" WHERE "pears"."person"."personid" = @WhoID;
return @PersonName;
ELSE
return 'Unkown Caller';
END CASE;
end;
CREATE FUNCTION "pears"."GetNotificationToken" (
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, '|', @NotificationToken);
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:
{{ :iqxcallernotification1.png?300 |}}
=== 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.