• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 612
  • Last Modified:

Need to export entire Lotus database file.

I am trying to export an entire Lotus Notes file (.nsf) to anything that i can then import into Access. My problems are:

- i know almost nothing about LN
- when i open my file i see a list of Views; but none of the views contains all the fields that i know exist
- i figured out how to add more fields to the views but they don't seem to display the information for that field.
- as far as i can tell i can only export the fields that i see in a view

How do i get everything out of this LN database and into anything else?

1 Solution
maybe there is another way, but why don't you try and use notes automation classes.
then you can make a small script that runs from VB6 VBA or VB.NET to conect to this notes db and to any other ODBC db.

It is very easy to conect to a notes DB usin NAC and there you can access ALL the fields for ALL the forms.

Notes automation classes are installed on your machine if you've got Lotus Notes installed.

of course, you might do this also in LotusScript from within notes, but I don't really like it that much, and if you're not familiar with Notes you'll like it even less :)

There is pelnty of material on Lotus notes automation classes on Internet, just search for "LotusScript for Visual Basic Programmers" and PDF on google and you'll find some code from Lotus and IBM I allways use.

Hope it helps
1.Install MSAccess on a machine that has a Lotus Notes client.  (I have a Domino database.)  

2.Download the Lotus NotesSQL ODBC driver.  This can be found on www.lotus.com website.  Go to Products & Services, Products A-Z, find Lotus Domino, under Extending Domino click on NotesSQL.  Download and install all features.

3.Configure a Lotus Notes ODBC data source.  You can go to www.activedocs.com/support/kb/000070.asp for information on how to do this.

4.Before you close the ODBC Data Source Administrator, select a particular .nsf database by going to the File DSN tab.  
     a.     Click on Add.  
     b.     Select the Lotus NotesSQL driver.
     c.     Type Domino.dsn.  
     d.     On the Notes Connection screen , find the database.
     e.     Enter in a Lotus Notes/Domino password (I was     already logged on to a Lotus Notes user’s computer as the user and so it prompted me for that particular user’s password).
     f.You can now see all the .nsf (like .mdb) files.     Select one and click OK.  
     g.Everytime you want to select a different .nsf file, you must redo step #4.  

5.To import the tables and/or views into MS Access see the MS Access help topic Import or link SQL database tables or data from other ODBC sources.  

Importing data from lotus notes to acess is very simple all you have to do is map all the fields in a view (all the fields except "computed for display" fields show data in the view )if the data is not visible in the view make the fields that are "computed for display" as computed ones in the form and map them in the view.Now you can export the data from the view to the access as "tabular text", open it in access and you are through with the import in access .
Hope this helps

ptalindstromAuthor Commented:
Sorry, but i am new to the EE and didn't know how to CLOSE a question. Thank-you all for your comments but i have fixed the problem myself. I also had the all the Lotus data dumped in an index card format (i.e. not in columns). Not being able to figure out anything to get this data out in columns; I wrote a small PERL script to transpose data into CSV format - then imported to Excel - then to Access.
PAQed, with points refunded (50)

E-E Admin

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now