Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

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

    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.