Lotus Enterprise Integrator (LEI) - Articles

Moving Domino attachments to your RDBMS with LEI, without writing script
Lotus Enterprise Integrator (LEI) 6.x can move attachments from a Domino database into an RDBMS table, making them readable from within the RDBMS itself. Best of all, you can do this quickly without writing a single line of script code!

Working with file attachments in the LCLSX
This article describes how you can work with file attachments in Lotus Connectors LotusScript Extension (LCLSX). We show how LCLSX handles file attachments and present a sample application to demonstrate file attachment processing.

Integrating IBM Lotus Domino and SAP
Learn how to build an application that reads data out of SAP and places it into a Domino database, using powerful tools such as Lotus Enterprise Integrator, Domino Enterprise Connection Services, and Lotus Connectors LotusScript Extension.

What is new in Lotus Enterprise Integrator (LEI) 7
IBM Lotus Enterprise Integrator for Domino (LEI) allows users to access data across multiple platforms. With LEI, users can work with corporate data, irrespective of where the data actually resides. This lets you leverage your existing store of company knowledge, without having to port this information to a common platform or application.
IBM recently released Lotus Enterprise Integrator 7, the latest version of LEI. This article gives you a short tour of the enhancements made in LEI 7.

IBM Lotus Connections - Articles

Enhancing productivity with social computing
Get an overview of IBM Lotus Connections and its five features: Profiles, Communities, Blogs, Dogear, and Activities. The technical requirements for the product are included along with simple ways to extend the services outside the product.

Deploying IBM Lotus Connections series:

Part1: Planning and architecture considerations
Focuses on planning and architecture considerations to ensure that your deployment is built properly. Learn from an expert on recommended planning and architecture practices.

Part2: Post-installation tuning
Focuses on post-installation tuning tips to ensure that your deployment does not suffer from common performance pitfalls. Learn from an expert on recommended practices to perform after the initial installation of Lotus Connections is complete.

Part3: Maintenance
Focuses on system maintenance, backup and recovery strategies, and tips to protect your environment from unexpected data loss or corruption. This article also covers practices for policing your Lotus Connections content.

Part4: Troubleshooting
Focuses on tips for troubleshooting during installation. It describes how to diagnose an installation problem, how to recognize which components cause the problem, and how to solve the most common problems.

Part5: Branding and customization
Demonstrates how to brand and how to customize the IBM Lotus Connections user interface. Learn how to make changes to ensure that Lotus Connections has the right look and feel for your enterprise.

Part6: Integrating with other systems
Focuses on integrating IBM Lotus Connections with other systems using the Atom API. This article is intended for I/T specialists and developers and is helpful when exploring options to integrate Lotus Connections into your applications.

Part7: Application programming interface
Covers working with the Lotus Connections APIs. This article is intended for I/T specialists and developers and is helpful when building programs that use Lotus Connections data and services.

LOTUSSCRIPT CODE FOR FILE OPEN DIALOG BOX

Lotus script code to show file open dialog box to browse and select files in windows.

Sample Agent code with settings "Manually from the Actions menu" and "Run Once (@Commands may be used)"

Declarations event:
-----------------------
Declare Function NEMGetFile Lib "nnotesws" ( wUnk As Integer, Byval FileName As String, Byval Filter As String, Byval Title As String ) As Integer

Initialize event:
-----------------------

Sub Initialize

Dim strFileName As String*256
Dim strTitle As String
Dim strFilter As String

strFileName = ""
strTitle = "Please select the Excel file to be imported"
strFilter = "MS Excel Files*.xls" 'Filter is set to show only .xls files

' Show file dialog box till a Excel file is selected
Do
ErrorStatus=False
If NEMGetFile( 0, strFileName, strFilter, strTitle) = 0 Then
retval=Msgbox( "You have not selected an Excel file for processing. Do you want to exit ?",4+256,"Abort")
If retval=7 Then
ErrorStatus=True
Else
Exit Sub
End If
End If
Loop Until ErrorStatus=False

Msgbox strFileName

End Sub