1

I have an nsf database file from a domino web application based on Lotus Domino version 6.5.

Any ideas on how I can extract the data? The data contains word,pdf and html documents.

Toon Krijthe
  • 52,876
  • 38
  • 145
  • 202
Imran Azad
  • 1,384
  • 1
  • 21
  • 36
  • 1
    Do you have Notes client? Is the only data you want in the attachments? Most data in Notes databases tends to be in fields on the forms, not in attachments. – David Navarre Jul 05 '12 at 17:29

2 Answers2

4

The word and pdf documents can be detached:

For a=1 To coll.count
     Set doc=coll.GetNthDocument(a)
     Set rtitem = doc.GetFirstItem("Body")
     Forall o In rtitem.EmbeddedObjects
        oname="c:\" + o.name
        Call o.ExtractFile( oname )
        Call o.Remove
     End Forall
     Call doc.Save(True, False)
  Next

The code above is just an example, the point is to find the embedded object and use o.ExtractFile( oname )

If the html documents are also attached files, you can do the same for those. If not, it is a different story.

Jasper Duizendstra
  • 2,587
  • 1
  • 21
  • 32
  • Thanks, what programming language is that? I have no experience using Domino, I've just got the file and I'm trying to figure out how to get the data out. – Imran Azad Jul 04 '12 at 10:08
  • 1
    It is lotusscript. You will need the designer client and definitely the help file. – Jasper Duizendstra Jul 04 '12 at 10:19
  • 1
    It is important to get the HTML question right, do you need the html, is it formatted in the notes form, or is it an attachment. If it is formatted in the form, it might be easier (in your case) to bring the site online and use a web crawler to fetch the data. – Jasper Duizendstra Jul 04 '12 at 10:30
  • I've managed to do exactly what you suggested (using a web crawler), however there is also a Java applet that contains documents I need that the web crawler can't get to. – Imran Azad Jul 04 '12 at 12:26
2

You can download the Notes designer client from IBM with no restrictions as well as the Notes and administrator clients with a 90-day evaluation period. Then you should be able to access the data natively.

David Navarre
  • 1,022
  • 10
  • 27