Info Hub
Regular Expressions and the Control Number Field
- Last updated:
- Feb 12, 2024
- Topic(s):
- Database maintenance, Metadata cleanup using RegEx
- Summary:
Find bibliographic records that have a non-standard or missing control number in the 001 field using Regular Expressions (RegEx).
Using Global Updates
- Last updated:
- Apr 28, 2023
- Topic(s):
- Database maintenance, Global Update
- Summary:
Basic Global Update commands
Saving Global Updates
- Last updated:
- Apr 28, 2023
- Topic(s):
- Database maintenance, Global Update
- Summary:
Create and save Global Update commands for reuse
Converting 856 links to 956 links
- Last updated:
- Mar 6, 2023
- Topic(s):
- Database maintenance
- Summary:
Convert supplemental material 856 links to 956 links in member-contributed records in the Central Catalog.
Searching for bib records without item, checkin, or order records
- Last updated:
- Feb 12, 2024
- Topic(s):
- Database maintenance
- Summary:
Find non-electronic resource bibliographic records that do not have an attached item, checkin, or order record.
Searching for active item holds using a Sierra SQL query
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance, Metadata cleanup using SQL
- Summary:
Find items with holds still active using a Sierra SQL query.
Removing Historical Rave Links using a Sierra SQL query
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance, Metadata cleanup using SQL, Legacy
- Summary:
-
Search for historical rave links no longer in use using a Sierra SQL query and delete them from any records.
-
Removing OCLC prefixes in 001 field using a Sierra SQL query
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance, Metadata cleanup using SQL
- Summary:
Ensure that OCLC prefixes are not in the 001 field using a SQL query.
Identifying item records without bib records using a Sierra SQL query
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance, Metadata cleanup using SQL
- Summary:
Find item records that are not linked to a bibliographic record using a SQL query.
Verifying minimal bibliographic record standards
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance
- Summary:
Check that bibliographic records contributed to the Central Catalog meet the minimal bibliographic record standards for contribution. If not, upgrade any to include the mandatory fields.