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

    Voyager to Alma Migration Query: Bibliographic Records With Two Or More OCLC Numbers

    Created By: Laura Guy
    Created on: 7/16/2020



    When migrating from Voyager to Alma, you may want to clean up any bibliographic records that have two or more OCLC numbers.  A single bibiographic record should contain only one OCLC control number.

    This query, which can be run using Voyager's Prepackaged Access Reports, will display the BIB_IDs of those records with multiple OCLC numbers:

    SELECT Count(BIB_TEXT.BIB_ID) AS [OCLC#Count], BIB_INDEX.BIB_ID, BIB_TEXT.TITLE_BRIEF, BIB_TEXT.AUTHOR
    FROM BIB_TEXT INNER JOIN BIB_INDEX ON BIB_TEXT.BIB_ID = BIB_INDEX.BIB_ID
    WHERE (((BIB_INDEX.INDEX_CODE)="0350") AND ((BIB_INDEX.NORMAL_HEADING) Like "OCOLC*"))
    GROUP BY BIB_INDEX.BIB_ID, BIB_TEXT.TITLE_BRIEF, BIB_TEXT.AUTHOR
    HAVING (((Count(BIB_TEXT.BIB_ID))>1));

    For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.
     
    If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.