Tweedy
asked on
Tidying up DB's
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
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
Basically: Compact your database, and remove fields from documents with older names
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...
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...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!
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
> 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
ASKER
Thanks people, thought it would be an easy one :)
Sjef,
You deserved poins on this one.
You deserved poins on this one.