Solved

Lookup rich text fields in any database

Posted on 2004-08-13
10
422 Views
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?
0
Comment
Question by:Jean Marie Geeraerts
10 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
Comment Utility
API functions are sensitive on data type that you pass.. for instance check this one..

http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/5de580478807fc0f85256ea200356faa?OpenDocument

Also make sure the length of the item is correct.

~Hemanth
0
 
LVL 8

Author Comment

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

Author Comment

by:Jean Marie Geeraerts
Comment Utility
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.
0
 
LVL 31

Expert Comment

by:qwaletee
Comment Utility
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.
0
 
LVL 8

Author Comment

by:Jean Marie Geeraerts
Comment Utility
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)
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 24

Expert Comment

by:HemanthaKumar
Comment Utility
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 !
0
 
LVL 8

Author Comment

by:Jean Marie Geeraerts
Comment Utility
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.
0
 
LVL 63

Expert Comment

by:Zvonko
Comment Utility
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.

Zvonko
EE Cleanup Volunteer
0
 

Accepted Solution

by:
modulo earned 0 total points
Comment Utility
PAQed with points refunded (500)

modulo
Community Support Moderator
0
 
LVL 8

Author Comment

by:Jean Marie Geeraerts
Comment Utility
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 :(
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now