Calendar/MS Outlook integration

[neilnewman]

Has anyone managed to create a calendar based Ebase application, or better still a way to allow an Ebase form to talk with MS Outlook.

[Segi]

I created my own native calendar based solution in Ebase using a Grid with a SQL Server database backend. It supports adding up to 5 calendar events per day with permission to selectively allow people with the right permissions to add/edit calendar events.

It can be done. I don't know if or how Ebase could integrate with Outlook unless you use some kind of service to do a 2 way synchronization and I'm not aware of a service like this.

[asperion]

If you talk about MS Outlook integration, you really mean integration with the MS Exchange mail server.

There are Exchange Web Services (EWS) which have been available since Exchange 2007, using Soap Requests. I believe Office 365 has Rest web services available but this is for the cloud hosted service.

I've never tried to integrate Ebase with MS Exchange but have looked into the feasibility in the past.

You could try to utilise the EWS Soap web services via the standard Ebase calls but they are complex and require multiple web service calls to do the most basic of functions.

One option might be to utilise an Open Source java client to EWS called ews-java-api , which reduces the complexity of calling EWS. Details can be found here :- https://github.com/OfficeDev/ews-java-api/wiki

Microsoft site details further information on how EWS works and how it could be utilised here :- https://msdn.microsoft.com/en-us/librar ... 50%29.aspx

Another alternative is to purchase a commercial client api for EWS to hopefully make life easier. One example I've looked at is JWebServices for Exchange, which includes example code for numerous EWS calls.
Details can be found here and a 30 day evaluation copy is available for download. :- http://www.independentsoft.com/jwebservices/index.html

Before you even think about using any the this code, I would strongly suggest you talk to your Exchange administrator to find out what's installed and what security restrictions are in place.

I've never had time to fully investigate this subject but would be interested if anyone has managed to achieve MS Exchange integration with Ebase.

Mark

[dvanhussel]

We don't actually use the Exchange callendar but we do have an Ebase application that reads and moves mail in an Exchange folder.

We use the EWS Java Api that Mark mentions above.

Implementing this was quite straight forward. We use some Java classes written for this that we call in the Ebase forms.

Regards,

David