Need to export entire Lotus database file.

Posted on 2003-02-26
Medium Priority
Last Modified: 2012-05-04
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?

Question by:ptalindstrom
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 8166884
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

Expert Comment

ID: 8314179
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.  

Expert Comment

ID: 8340341

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


Author Comment

ID: 8341818
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.

Accepted Solution

Computer101 earned 0 total points
ID: 12036177
PAQed, with points refunded (50)

E-E Admin

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question