Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Community Knowledge
    4. Voyager to Alma Migration Query: Identify Duplicate Call Numbers (Pass-through query)

    Voyager to Alma Migration Query: Identify Duplicate Call Numbers (Pass-through query)

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    Created By: Laura Guy (contact)
    Created on: 11/27/2020



    When migrating from Voyager to Alma it may be helpful to identify and review duplicate call numbers.

    This Pass-Through SQL Query (it will not run as is as a normal Access Query) finds pairs of records with the same call number, but different BIB IDs.  It compares the normalized call number, the way Voyager indexes them.  The query also checks that one MFHD_ID is greater than the other, so that each pair only shows up once in the results.  Bound-withs (different BIB, same holdings) are excluded.

    Note that this query checks call number type.  It is set to look at LC, but can be altered to look at Dewey.

    select
      bt1.bib_id as bib1
    , bt2.bib_id as bib2
    , mm1.display_call_no
    , bt1.title_brief as title_1
    , bt2.title_brief as title_2
    from mfhd_master mm1
    inner join bib_mfhd bm1 on mm1.mfhd_id = bm1.mfhd_id
    inner join bib_text bt1 on bm1.bib_id = bt1.bib_id
    inner join mfhd_master mm2 on mm1.normalized_call_no = mm2.normalized_call_no
    inner join bib_mfhd bm2 on mm2.mfhd_id = bm2.mfhd_id
    inner join bib_text bt2 on bm2.bib_id = bt2.bib_id
    where bm1.bib_id != bm2.bib_id
    and bm1.mfhd_id > bm2.mfhd_id
    and mm1.call_no_type = '0' --change this to 1 if you use Dewey
    order by mm1.normalized_call_no;

    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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Voyager to Alma Migration Query: Identify Department Codes that are Duplicates
      • Voyager to Alma Migration Query: Identify Duplicate Call Numbers in the MFHD Record
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved