, ,

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

Lotus Notes in OI 9.2.1 (OpenInsight 32-Bit)

At 29 MAY 2011 04:19:51AM Asraph Ali wrote:

Hi,

We have developed several applications in Lotus Notes, Recently we started using Open Insight.

I can access Notes server using IBM Lotus Notes client. But In OI Notes Registration, I am not able to see my remote Notes server.

Please let me know if some configuration had to be done initially. I just want to take my U2 database to Notes (without ODBC).

Thanks

Asraph Ali

At 30 MAY 2011 01:29PM Bob Carten wrote:

Hi Asraph,

The direct connection options in OpenInsight don't work with current versions of Lotus notes. However, you can use OLE automation instead.

I've had success with sending e-mails. You can probably find vbscript examples for other functions, translate them to Basic+

Example 1

Lotus Notes email example 1

Example 2

Notes Email with Attachment

At 30 MAY 2011 11:53PM Asraph Ali wrote:

I had seen your email example earlier. But what I need is using the U2 database that I have in Open Insight for our Lotus Notes applications. ODBC connections are very slow. Is there a way to provide these U2 tables in Notes or VB?

Thanks again

Asraph

At 31 MAY 2011 11:16AM Bob Carten wrote:

Hi Asraph,

Sorry, I read your question to mean "can I read notes data in OpenInsight". You really asked "Can Notes read U2 tables using OpenInsight", correct?

I do not know Lotus Notes programming. Here are some generic answers that will work for VB and possibly Notes

Option 1:

Run the Oengineserver and an internal webserver, create a sort of web service where you use XMLHTTP from vb/notes to send requests to OpenInsight. This would be a web based RPC (remote procedure call) interface. The benefit of this is that the OpenInsight would run on the server, so OpenInsight would not need to run on each desktop wehre notes is running.

Option 2: Use NetOI, the .Net connector to OpenInsight, to create an interface whereby you send requests to OI, receive responses. This would be a .Net based RPC interface. NetOI is built on top of the Oengineserver, so this would behave similarly to Option 1, except you would not need a web server. Also, netOI already has functions to support read, write and selecting rows, so you would not need to write that code yourself.

Option 3:

Use RevCap32 Api Library declarations to create an RPC style interface. Revcap32 connects directly to the Oengine, so OpenInsight must be running on the same desktop as the notes or VB client. VB can implement this, I am not sure that Notes can.

Option 4: (Broken in 9.21, will be fixed in 9.3)

Use XREV.dll, the COM connector to Openinsight to create an RPC style interface. Xrev is just a COM interface to revCap32, so this would behave similarly to Option4, except you can use Xrev in a programming language such as VBA which does not support API calls. Unfortunately Xrev.dll is broken in current release of OpenInsight. It will be fixed for the next release.

Option 5:

Specifically for U2, look at UniObjects (deprecated) and UniObjects.Net. These are libraries which allow a COM or .Net client to communicate with U2.

- Bob

View this thread on the Works forum...