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

    Voyager to Alma Migration Query: MFHD 852 Lacks First Indicator

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



    When migrating from Voyager to Alma, you may want to identify and fix any MFHD 852 fields that are missing the first indicator value.  In this situation indexing may be incorrect, and the Call Number not easily searchable.

    This query, which can be run using Voyager's Prepackaged Access Reports, will display the MFHD IDs of holdings records that have a blank first indicator value in the 852:

    SELECT MFHD_MASTER.MFHD_ID, LOCATION.LOCATION_CODE,
    MFHD_MASTER.NORMALIZED_CALL_NO, MFHD_MASTER.DISPLAY_CALL_NO,
    MFHD_MASTER.CALL_NO_TYPE, MFHD_MASTER.CREATE_DATE FROM MFHD_MASTER INNER
    JOIN LOCATION ON MFHD_MASTER.LOCATION_ID = LOCATION.LOCATION_ID WHERE
    (((MFHD_MASTER.NORMALIZED_CALL_NO) Is Null) AND
    ((MFHD_MASTER.DISPLAY_CALL_NO) Is Not Null));

    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.

     




    • Was this article helpful?