Please help with extracting data from Lotus Notes database
Posted on 2004-08-09
I have been asked to rewrite a web application initially developed in Lotus Notes/Domino. The application is a web based jobs database. I know nothing about Lotus Notes or Domino so I have been pulling my hair out trying to export the data out of Lotus Notes and into a text file or some other form I can work with. I have been able to extract most of the data out by downloading the ODBC driver and importing it into SQL Server. However, each document in the Lotus Notes database has a file attached to it that I also need to retrieve (resume files). I originally thought these files might be stored in a directory on the server but it looks like thay are actually stored in the database. I have figured out how to open the database in Lotus Notes and "detach" the attachment from the document but there are 1300 documents. I need a way to retrieve every attachment and save it to a folder with a different file name. Please help.