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

    Voyager to Alma Migration Query: Item records that have data in the Spine Label Field

    Created By: Laura Guy (contact)
    Created on: 9/15/2020



    When migrating from Voyager to Alma, it may be desirable to identify those item records that have data in the Spine Label Field.  Alma does not have a corresponding field and these data will be lost during migration.

    This query, which can be run using Voyager Prepackaged Access Reports, will identify data that should be moved to another field, such as the item note field.

    SELECT ITEM.ITEM_ID, ITEM.SPINE_LABEL, MFHD_MASTER.MFHD_ID,
    LOCATION.LOCATION_NAME, MFHD_MASTER.NORMALIZED_CALL_NO,
    MFHD_MASTER.DISPLAY_CALL_NO, MFHD_ITEM.ITEM_ENUM, MFHD_ITEM.CHRON,
    MFHD_ITEM.YEAR, MFHD_ITEM.CAPTION, MFHD_ITEM.FREETEXT, ITEM.COPY_NUMBER,
    ITEM_BARCODE.ITEM_BARCODE, ITEM.PIECES, ITEM_NOTE.ITEM_NOTE
    FROM ((LOCATION INNER JOIN MFHD_MASTER ON LOCATION.LOCATION_ID = MFHD_MASTER.LOCATION_ID)
    INNER JOIN ((ITEM INNER JOIN MFHD_ITEM ON ITEM.ITEM_ID = MFHD_ITEM.ITEM_ID)
    LEFT JOIN ITEM_BARCODE ON ITEM.ITEM_ID = ITEM_BARCODE.ITEM_ID)
    ON MFHD_MASTER.MFHD_ID = MFHD_ITEM.MFHD_ID)
    LEFT JOIN ITEM_NOTE ON ITEM.ITEM_ID = ITEM_NOTE.ITEM_ID
    WHERE (((ITEM.SPINE_LABEL) Is Not Null))
    ORDER BY LOCATION.LOCATION_NAME, MFHD_MASTER.NORMALIZED_CALL_NO;

    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.