Database maintenance

Find 9xx fields used in Sierra using a SQL query.

Prior to Alma migration, quotation marks must be cleaned up in Sierra for successful data validation using a SQL query.

Prior to Alma migration, quotation marks in non-MARC records must be cleaned up in Sierra for successful data validation.

The document is an overview of how the matching process for the Alma migration works.

In order to keep local metadata consistent, Sierra Statistics can identify the system codes actually used in records which can then be cleaned up as needed then documented for future reference.

Given their pre-migration experiences, the Vanguard libraries have suggestions for metadata clean-up projects and advice for all OhioLINK member libraries. This Info Hub article will continue to be expanded and revised as needed.

Find bibliographic records using various updates suggested by Kent State University based on their regular checks.

Find bibliographic records that have title field indicator errors using Regular Expressions (RegEx).