Lotus Notes in OI 9.2.1 (OpenInsight 32-Bit) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{tag>category:"OpenInsight 32-Bit" author:"Asraph Ali" author:"Bob Carten"}}

[[https://www.revelation.com/the-works|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: ===
 
 
<QUOTE>
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
</QUOTE>
----

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

<QUOTE>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

[url=http://docs.google.com/Doc?id=dhh9ztnx_8ckmhvk]Lotus Notes email example 1[/url]



Example 2

[url=https://docs.google.com/document/d/1Wrcj7IXCSmDq_E0u9yea2Efe3_EZai7ETWIj0k_YYxY/edit?hl=en_US&authkey=CLbEw-AJ]Notes Email with Attachment[/url]

</QUOTE>

----

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

<QUOTE>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

</QUOTE>

----

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

<QUOTE>

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

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=6F8BA41C96A844218525789F002DC352|View this thread on the Works forum...]]