Calendar/MS Outlook integration

Post any questions you have about using the Verj.io Studio, including client and server-side programming with Javascript or FPL, and integration with databases, web services etc.

Moderators: Jon, Steve, Ian, Dave

neilnewman
Ebase User
Posts: 201
Joined: Fri Dec 20, 2013 1:29 pm
Location: Dartford Borough Council
Contact:

Calendar/MS Outlook integration

#1

Postby neilnewman » Tue May 31, 2016 12:56 pm

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.
0 x

Segi
Ebase User
Posts: 649
Joined: Mon Dec 09, 2013 6:37 pm

#2

Postby Segi » Tue May 31, 2016 5:57 pm

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.
0 x

asperion
Ebase User
Posts: 8
Joined: Sat Feb 02, 2013 8:24 pm

#3

Postby asperion » Tue May 31, 2016 8:40 pm

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
0 x

User avatar
dvanhussel
Ebase User
Posts: 161
Joined: Fri Oct 19, 2007 12:45 pm
Location: Haarlem, the Netherlands

#4

Postby dvanhussel » Wed Jun 01, 2016 9:36 am

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
0 x


Who is online

Users browsing this forum: No registered users and 11 guests