Lookup rich text fields in any database

Posted on 2004-08-13
Last Modified: 2013-12-18
For reporting reasons I need to have an agent that scanns all databases on a server and reports in which databases a rich text field is used.

I've got the code to scan the databases and walk through all forms in a database, but I can't seem to extract the rich text fields from the form note.

Using the API function NSFNoteInfo for a rich text field the data type is always returned as TYPE_INVALID_OR_UNKOWN (=0), where it should be TYPE_COMPOSITE.

Does anybody know of a way how I can walk through all forms in a database and check if there is a rich text field on it? Using LotusScript or C API or any other method?
Question by:Jean Marie Geeraerts
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
LVL 24

Expert Comment

ID: 11792677
API functions are sensitive on data type that you pass.. for instance check this one..

Also make sure the length of the item is correct.


Author Comment

by:Jean Marie Geeraerts
ID: 11792759
Yes, I know. Wrong declaration and you could get a "red box of death" :-)
Will look into it and keep you posted.

Author Comment

by:Jean Marie Geeraerts
ID: 11792870
Apparently this bit of info doesn't get us any further.
The problem is we have a reference to the form design element and when we use above function to retrieve info from an item, we don't get the correct value for the item type from the API function.

Do you have any idea as to why this wouldn't be working as it should?
On a regular data document, when you get the properties this way it returns the correct type.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 31

Expert Comment

ID: 11793036
Thing is, since a form's definition can change without changing the underlying data (documents already created with the form), you are goingto have to be careful with scope: do you want to check for current design using RTF, or for current data, or both.

To check for current data, you would haveto scan every doc in the database.  Checking forms is trickier, as you found, for a very simple reason: the way Notes stores a form's design.  A form is itself a note (document).  It has the following fields:

1) $Body - a rich text field that contains the form's content, including text, style, hootspots, images, etc. -- and a PLACEHOLDER for each field without any defintion for that field

2) $* -- a bunch of other fields whose names start with $ that control how the form is used (e.g., flag for store form in document), along with a few others (e.g., $UpdatedBy, which has no real function except to record the last person to edit the form)

3) A field for every field definition on the form.  These fields have the same name as the form's fields, contain the description of the fields (data type, formula, etc.), and have a special flag PLACEHOLDER.  The data type for these fields is not really relevant -- I think numbers and dates placeholders are actually stored as numbers and dates, everything else is a special type (though it should not be unknown... see what actual numeric value is returned, and match that against teh constants.  I don't think it matches teh standard unknown, though the specific number may not be defined)


A better way to do this might be to use the R6 client, with DXL, to get the form defintion, use teh DXL transform interpreters to go down to just teh field defintion level, and pull the data type flags.

Author Comment

by:Jean Marie Geeraerts
ID: 11793225
Well, we don't have R6 available yet, so we'll have to do with R5 for the time being.

We did get as far as to the design note of the form and found the fields describing the fields on the note, but now want to read from these fields or in another way if any rich text fields are specified in the current design. (in current data is not important for our report)
LVL 24

Expert Comment

ID: 11793375
Why don't you use a view (described in previous question using $FormulaClass) to list all the design elements.. And treat them as document and read it !

Author Comment

by:Jean Marie Geeraerts
ID: 11793477
I don't expect it to make a difference, since we now open the document by it's unid through api call NSFNoteOpen and then get the item info through NSFItemInfo.
LVL 63

Expert Comment

ID: 13004241
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
    PAQ with points refunded

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

EE Cleanup Volunteer

Accepted Solution

modulo earned 0 total points
ID: 13042855
PAQed with points refunded (500)

Community Support Moderator

Author Comment

by:Jean Marie Geeraerts
ID: 13061488
Hm, didn't get a chance to react, because I was at home sick all week, but don't mind the question being closed since we are no longer looking into it anyway.
Would have been nice to have had an answer, though :(

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

This is an old article, please see an updated version of this article, located here:
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
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…

635 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