I cannot remove incorrectly formatted terms from a controlled vocabulary list
Symptom
- Terms appear in a controlled vocabulary list with what looks like spaces or tab characters preceding the value
Applies to
- CONTENTdm Administration
- Controlled Vocabulary
Resolution
Locating the records that contain incorrectly formatted controlled vocabulary terms can be accomplished by following the workflow below:
- In CONTENTdm Admin select collections
- Select export
- XML > Custom XML > Include all page-level metadata
- click next
- Enter XML tag names for only the metadata fields containing the controlled vocabulary and CONTENTdm number
- keep Repeat fields selected
- click export
This will generate an XML file containing only the desired metadata values of your records and the associated item IDs. Then import the XML into another program that can isolate all lines containing the term that appears with extra characters preceding it. By doing this, you should be able to locate the record that has the incorrectly formatted value.
With the CONTENTdm number, you can then locate the record in CONTENTdm Admin by using this URL format and replacing the sections in bold with the correct values: https://server#####.contentdm.oclc.org/cgi-bin/admin/edittxt.exe?CISOROOT=/collectionAlias&CISOPTR=CONTENTdmNumber
Save the records and re-index the collection.
For individual collections, you will then delete the current controlled vocabulary for the field and create a new CV:
- In CONTENTdm Admin select collections
- Select fields
- Select the correct collection from the dropdown menu
- Click edit next to the desired field
- Next to Controlled Vocabulary select "No" and click save changes
- Click edit next to the desired field
- Next to Controlled Vocabulary select "Yes" then
- Create a new controlled vocabulary for this field > Use the existing contents of the field
- Click save changes
If you are still unable to remove a term from your controlled vocabulary, please contact OCLC Support.