Differences

This shows you the differences between two versions of the page.

--- 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 ======
+The follow is a guide to installing and configuring the IQXCallerNotification application to connect to the Synety VOIP system.
+) Add the following scripts to your IQX database:
+<code SQL>
+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;
+</code>
+<code SQL>
+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;
+</code>
+) Add the following files to either your IQX main program folder or create your own folder and add the files to that.
+) IQXCallerNotification.exe
+) IQXCallerNotification.exe.config
+) Microsoft.AspNet.SignalR.Client.dll
+) Newtonsoft.Json.dll
+) DDE_run.exe
+) iAnywhere.Data.SQLAnywhere.v4.0.dll
+) Create a shortcut to point to the IQXCallerNotification.exe file and add it to your Startup folder.
+) Got to the properties of your shortcut and at the end of the Target file add the following details:
+) Database Engine Name
+) Username
+) Password
+) 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.