How to export data from a IBM Lotus Notes Database using Java

1
votes

I want to export data from a Lotus Notes database .nsf that lives on my local computer. I want to write a java program that will connect to this .nsf lotus notes database and export data from a view/form.

I am not sure how to do that ? Is there a sample code that i can refer too or a JDBC-ODBC driver ?

3
javalotus-dominolotuslotus-notes

3 Answers

4
votes

You actually have two issues/questions. 1) How to use Java to connect to a Notes database 2) How to export data from documents (let's use the correct terminology, form is a design element, data is stored in documents)

For 1) there is plenty of sample code available, like the link poisonedYouth referenced in his response.

For 2) I would suggest looking at the samples in the Domino Designer help. You need to undertand that Domino Object Model (DOM) first, and know how that data is stored.

But you would probably do something like this:

  • Create a new NotesSession object
  • Get a NotesDatabase object from the session
  • Get a NotesView object from the database

Now you can do it different ways, depending on éxactly what you want to do and things like what items are being displayed in the view.

If all fields you want to export are displayed in the view, I would do this:

  • Get a NotesViewEntryCollection document from the view
  • Use GetFirstEntry and GetNextEntry methods to loop through the collection and get the individual entries
  • Use the ColumnValues property of the NotesViewEntry object to get the values displayed in the view, then export those values the way you want it.

If you don't have all the values displayed in the view, use this (slower) method:

  • Use the GetFirstDocument and GetNextDocument methods to loop through all NotesDocuments in the view
  • For each document, read the field values using GetItemValues (remember that all field values are returned as an array, even if they only contain one value) and export them the way you like.

Exporting data from Notes is a very common process, and you should be able to find plenty of code. I have a tool available(it is not open source, though) here: http://www.texasswede.com/websites/texasswede.nsf/Page/Notes%20XML%20Exporter

I also posted code on my blog that you can look at and modify: http://blog.texasswede.com/export-notes-view-to-excel-with-multi-value-fields/

0
votes

I found an article with topic "Writing standalone Java code that connects to IBM Lotus Domino"

http://www-10.lotus.com/ldd/dominowiki.nsf/dx/06082009125716AMWEB7TU.htm

0
votes

I recommend trying IBM Security Directory Integrator (former Tivoli Directory Integrator, or TDI). It's a integration tool especially built for your purpose.

SDI operates using so-called assembly lines where you have one or more sources and one or more destinations. In between you can manipulate your data to your hearts desire.

Some versions of TDI/SDI are free with the newest versions of IBM Domino. Check out these sites for more info:

Good luck! Ove