Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| sa32-00 [2014/07/31 15:31] – davidbell | sa32-00 [2017/12/01 16:35] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 4: | Line 4: | ||
| The follow is a guide to installing and configuring the IQXCallerNotification application to connect to the Synety VOIP system. | The follow is a guide to installing and configuring the IQXCallerNotification application to connect to the Synety VOIP system. | ||
| - | 1) Add the following | + | 1) Add the following |
| <code SQL> | <code SQL> | ||
| Line 42: | Line 42: | ||
| </ | </ | ||
| - | 2) Add the following files to either your IQX main program folder or create your own folder and add them. | + | <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 | 1) IQXCallerNotification.exe | ||
| Line 67: | Line 87: | ||
| === Error Reporting === | === Error Reporting === | ||
| - | An errors | + | Any error that occurs is written to the IQXCallerNotification.err file. This file can be found in the same folder as the files above. |