Dynamic tool to change field values & preventing FT index getting corrupt

Posted on 2003-11-10
Last Modified: 2013-12-18
Do you know of any tool that helps in selecting a document and then showing a list of fields in it and have one at a time modify the field value or delete a field completely ?
Pl provide me with the name or link of the tool or the code.

If you also know how to prevent a FT index from getting it corrupt. please let me know, that would be helpful. Let us also say, if it is corrupt somehow how to find out about it  automatically and fix it automatically as well ?
I will raise the point to double if the answer will help things to work.

Thanks !
Question by:navgup
LVL 14

Expert Comment

ID: 9718633
LVL 24

Expert Comment

ID: 9719108
To automatically fix the full text corruption run these commands on your server scheduled mostly mid-night

Run Updall to fix corrupted views and full-text indexes and then run Fixup to fix corrupted views and documents and finally
Compact task on server


Author Comment

ID: 9727037
Well.. one of Fixup or Updall, deletes the corrupt documents automatically. How to prevent that from happening ?

About the edit document fields 3.0. It is great ! i found it but i need earlier version which is used with R5. This version 3.0 has some r6 functions.

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

LVL 31

Expert Comment

ID: 9728763
The best document field editor out there is the NotesManager freebie on

If you get it, say hi to Jamie for me.

Author Comment

ID: 9732336
I m stuck with one problem regarding this, Is there a way using lotus script or formula to get a handle on document thru a selected document from @picklist ?

I am doing this, but don't know where to go from here..

Set uidoc = ws.CurrentDocument
Set doc = uidoc.document
Dim TempDoc As NotesDocument
If ws.dialogbox("DocSelect",True, True,False,False,False,False,"Specify a field",doc, True ) Then

'<I don't know what to use here>, DocSelect is a form with a field using @Picklist for document selection from a view. I want when i close this dialog box, i have the handle to the document that was selected from the picklist. '      
End If
LVL 24

Expert Comment

ID: 9732479
Use picklistcollection to get document handle


Set notesDocumentCollection = notesUIWorkspace.PickListCollection( type% [,multipleSelection ] [, server$ ] [, databaseFileName$ ] [, viewName$ ] [, title$ ] [, prompt$ ] [, Singlecategory$ ] )

LVL 24

Expert Comment

ID: 9732493

Author Comment

ID: 9739226
Thanks Hemantha !
Even though i am now getting the document handle. I have lotus script code stored in those documents. I want to execute different code depending upon the document the admin is going to select.
Each of these document code is meeting a different purpose to be executed from an agent.


Author Comment

ID: 9740707
Just want to clarify more...I don't want to change any design code every time i decide to make a code change. That requires a release of application everytime to implement every time. That is why i want to make the code dynamically stored in a document and use it / call it from an agent/ button.
LVL 24

Accepted Solution

HemanthaKumar earned 50 total points
ID: 9740802
There is a way you can evaluate a text as script and I am not sure how helpful that would be ?

Check for Execute function in lotus script.

What it does is it accepts a script text and evaluates it.. the scope is limited, that is the variables defined in this cannot be referenced externally. For further info/examples look into help


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

808 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