Voyager to Alma Migration Query: Identify Records where the 035 Field has a Malformed OCoLC Prefix

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Created By: Laura Guy (contact)

Created on: 3/01/2021

When migrating from Voyager to Alma it may be helpful to identify, review and perhaps "fix" bibliographic records with malformed ("bad") OCoLC prefixes such as (OCLC), (OC<zero>LC), OCoLC(ocm, and (OCoCL).

This query, which can be run using Voyager's Prepackaged Access Reports, looks for 035 fields that being with variations of the OCoLC prefix.

SELECT BIB_INDEX.BIB_ID, BIB_TEXT.TITLE_BRIEF, BIB_INDEX.DISPLAY_HEADING,
BIB_INDEX.NORMAL_HEADING, BIB_MASTER.SUPPRESS_IN_OPAC, BIB_MASTER.CREATE_DATE
FROM (BIB_INDEX INNER JOIN BIB_MASTER ON BIB_INDEX.BIB_ID = BIB_MASTER.BIB_ID)
INNER JOIN BIB_TEXT ON BIB_INDEX.BIB_ID = BIB_TEXT.BIB_ID
WHERE (((BIB_INDEX.DISPLAY_HEADING) Like "(OCLC)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "oclc*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "OCLC*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OC0LC)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(ocOlc)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(ocolc)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OcoLC)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OCOLC)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OCOLCO*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OCOLC0*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OCoLCoc*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "OCoLC(oc*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "OCoLC)oc*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "OCoLCoc*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "((OCoLC*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OCoLC))*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OCoCL)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OCLoC)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(0CoLC)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(COoLC)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OCcLC)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OCo:C)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OCoLO)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OLoLC)*"
Or (BIB_INDEX.DISPLAY_HEADING) Like "(OCLoLC)*")
AND ((BIB_INDEX.INDEX_CODE)="0350"))
ORDER BY BIB_INDEX.DISPLAY_HEADING;

For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.

Posted as is. If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.

Report