Solved

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

Posted on 2003-11-10
10
286 Views
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 !
navgup@hotmail.com
0
Comment
Question by:navgup
[X]
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
10 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
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

~Hemanth
0
 

Author Comment

by:navgup
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.

thanks
0
Independent Software Vendors: 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

by:qwaletee
ID: 9728763
The best document field editor out there is the NotesManager freebie on http://www.MartinScott.com

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

Author Comment

by:navgup
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
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9732479
Use picklistcollection to get document handle

Syntax:

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

0
 

Author Comment

by:navgup
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.

0
 

Author Comment

by:navgup
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.
0
 
LVL 24

Accepted Solution

by:
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

0

Featured Post

Industry Leaders: 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!

Question has a verified solution.

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

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…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

688 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