Both sides previous revision Previous revision Next revision | Previous revision |
sa37-00 [2015/01/13 11:51] – davidbell | sa37-00 [2022/05/04 08:47] (current) – Shelley Hunter |
---|
-- RETURN null; -- if not using EWS | -- RETURN null; -- if not using EWS |
set rv = 'EWS'+crlf; -- mandatory for EWS | set rv = 'EWS'+crlf; -- mandatory for EWS |
set rv = string(rv,(select (select staff.Email || '; ' from staff where Staff.staffid = UserStaffID ) || list(number,';' order by pt.name asc) from Phone as p key join PhoneType as pt where p.WhoID = UserStaffID and p.Who = 'U' and pt.Capabilities = 'E'),crlf); -- one or more sender addresses separated by ; Use userstaffid to look up valid ones for logged in user. | set rv = rv + string(rv,(select (select staff.Email || '; ' from staff where Staff.staffid = UserStaffID ) || list(number,';' order by pt.name asc) from Phone as p key join PhoneType as pt where p.WhoID = UserStaffID and p.Who = 'U' and pt.Capabilities = 'E'),crlf); -- one or more sender addresses separated by ; Use userstaffid to look up valid ones for logged in user. |
-- set rv=rv+'IQXEWSSendMail.exe'+crlf; -- the program to call (with full path if not either in system path or iqx.exe folder). Notepad.exe handy for testing. | -- set rv=rv+'IQXEWSSendMail.exe'+crlf; -- the program to call (with full path if not either in system path or iqx.exe folder). Notepad.exe handy for testing. |
set rv = rv+'IQEWSSendMail.exe'+crlf; -- the program to call (with full path if not either in system path or iqx.exe folder). Notepad.exe handy for testing. | set rv = rv+'IQEWSSendMail.exe'+crlf; -- the program to call (with full path if not either in system path or iqx.exe folder). Notepad.exe handy for testing. |
set rv = rv+'<ExchangeServerUrl>https://titanic2.iqx.co.uk/EWS/Exchange.asmx</ExchangeServerUrl>'+crlf; -- All remaining lines are inserted into the <ServerDetails> block. | |
set rv = rv+'<ExchangeVersion>2010</ExchangeVersion>'+crlf; | -- All remaining lines are inserted into the <ServerDetails> block. |
set rv = rv+'<ExchangeServicePack></ExchangeServicePack>'+crlf; | set rv = rv+'<ExchangeServerUrl>https://pcname.domain.co.uk/EWS/Exchange.asmx</ExchangeServerUrl>'+crlf; -- Example: https://TITANIC.iqx.co.uk/EWS/Exchange.asmx |
| set rv = rv+'<ExchangeVersion>2010</ExchangeVersion>'+crlf; -- You need to specify the version of Exchange you are using. |
| set rv = rv+'<ExchangeServicePack></ExchangeServicePack>'+crlf; -- Add the Exchange Service pack 1 or 2 or 3 etc. blank if none. |
return rv | return rv |
end | end |
2) Microsoft.Exchange.WebServices.dll | 2) Microsoft.Exchange.WebServices.dll |
3) IQXEWS.pfx | 3) IQXEWS.pfx |
| |
| 3) Add the following records to your IQX database. |
| |
| Firstly create the record below in the "//phonetype//" table. |
| |
| <code SQL> |
| INSERT INTO "pears"."phonetype" ("sortorder","company","contact","applicant","phonetypeid","name","Capabilities","AuditFlag","displaygroup","displayname","SocialMediaType") VALUES(999,0,0,0,'UUSE','Email','E',1,0,'EWS Email',NULL) |
| |
| |
| </code> |
| |
| For each email address you want to add you need one of these insert statements. phoneid is unique and therefore has to change for each record. phonetypeid matches the phonetypeid above. Who is given 'U' so not to mess with any other types. "//number//" becomes the email address to add. |
| <code SQL> |
| INSERT INTO "pears"."phone" ("phoneid","phonetypeid","who","whoid","number","numberdigits") VALUES('XX01251426042013026F','UUSE','U','XX18141218042013016A','EWS@pulse.com',NULL) |
| </code> |
| |
| |
**Error Reporting** | **Error Reporting** |
| |
Any error that occurs is written to the *.err file. This file can be found in the same folder as the files above | Any error that occurs is written to the *.err file. This file can be found in the same folder as the files above. \\ \\ |
| |
| For information on the development of IXQ and the visibility of the Inbox please click [[sa37-01|here]]. |
| |
| |