Solved

Tidying up DB's

Posted on 2003-11-20
7
183 Views
Last Modified: 2013-12-18
A simple one undoubtedly but i cant seem to ask the correct questions in help :)

A number of forms and hence fields have been deleted from various Databases, but they still show up as options to display in a view column.

How do i "tidy up" so that basically when a field is removed from the databse it is no longer an option  for display on a view column.

Example if i create a new view and select a column, attempt to Display a field, i get the option of

"untitled" "untitled2" etc as well as about 50 fields that were on forms that no longer exist.

Cheers

T
0
Comment
Question by:Tweedy
7 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 9786950
Basically: Compact your database, and remove fields from documents with older names
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 9786970
Or the other way round ;-) cleanup older documents and compact the database.
There have been numerous problems with fieldnames that no longer exist, all reported in several fora about Notes. They seem to have solved this issue in R6...
0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 50 total points
ID: 9787021
Try this

1. Create full text index (In database properties)
2. After index is created, delete it (In database properties)
3. Now compact the database
4. The obsolete fields should not be visible now

~Hemanth
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 9787246
Multiple suggestions have also been made into the direction of full-text index creation and removal. My template does not have an FTI, and compacts as it is supposed to. I absolutely fail to see the connection between FTI and fieldnames, hence I have only one word for it: Balderdash!
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9787298
Hi sjef_bosman,
> I absolutely fail to see the connection between FTI and fieldnames, hence I
> have only one word for it: Balderdash!

I have read Sjef's comment, and I have only one word for it: Accurate!

Best regards,
qwaletee
0
 

Author Comment

by:Tweedy
ID: 9787362
Thanks people, thought it would be an easy one :)
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9805098
Sjef,

You deserved poins on this one.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

831 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