I’m looking for a simple example to get me started on reading a database and collecting document property information for all documents within a database. I will need to create & print a document that contains the property information of all documents within the specified database.Any examples will be appreciated!
Diane
Subject: document properties
Generally you would not be able to construct one document to contain all the document properties of a database set of documents simply because the size of the content would be way past the limits of a document/field.
However, you can use the NotesDatabase.AllDocuments property to pull every document from the database and then you can cycles through all the fields, and such rather easily.
The key thing to remember is that you will probably hit the limit around the 200th document, depending on how complicated your database design is…
Don’t have a specific example, but if you have more details about what your basic goal is, I might be able to whip up a few quick examples.
Subject: RE: document properties
Scott, It’s a very simple database, and I really just need document title, size, date created. I don’t think the 200 document limit will even be an issue. I started playing with the @dblookup, but I don’t think this is what I need.
The agent will be within the database that I need the information from, basically, just a simple read the first document, grab the info, then place the info on a new document, read the second document, grab info, etc… It should be a very simple process, although, not doing alot of Lotus Script, I would like to see an example before I put way too much thought into something that seems very easy to do.
Thanks for your interest in my post!
Diane
Subject: RE: document properties
Scott’s idea is quite adequate
set doc = col.getnthdoc
do while not (doc is nothing)
…
extract data
write to a doc2 field
…
loop
the only limitation as Scott says would be the field load
but you on say 200 docs you could create a doc2 field 2, etc…