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

    Voyager to Alma Migration Query: Identify Duplicate Item Barcodes

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



    When migrating from Voyager to Alma, duplicate (in other words, non-unique) item barcodes will be changed to "-".  This may not be desirable and you may want to fix any duplicate item barcodes before migration. The following two queries can assist you in doing that.

    This first query, which you can run in Voyager's Prepackaged Access Reports, should help you to identify duplicate barcodes in your database and fix them.

    SELECT ITEM_BARCODE.ITEM_BARCODE, Count(ITEM_BARCODE.ITEM_ID) AS CountOfITEM_ID
    FROM ITEM_BARCODE
    WHERE (((ITEM_BARCODE.BARCODE_STATUS)="1"))
    GROUP BY ITEM_BARCODE.ITEM_BARCODE
    HAVING (((Count(ITEM_BARCODE.ITEM_ID))>1));

    This second query, when run, will ask you for a barcode number and return the barcode number, location, call number, enumeration, chronology, copy, and item ID for each item to which the barcode is attached.

    SELECT ITEM_BARCODE.ITEM_BARCODE, LOCATION.LOCATION_CODE,
    utf8to16([mfhd_master].[DISPLAY_CALL_NO])
    AS Display_Call_No, MFHD_ITEM.ITEM_ENUM,
    MFHD_ITEM.CHRON, ITEM.COPY_NUMBER, ITEM_BARCODE.ITEM_ID
    FROM LOCATION INNER JOIN (((ITEM_BARCODE INNER JOIN ITEM
    ON ITEM_BARCODE.ITEM_ID = ITEM.ITEM_ID) INNER JOIN MFHD_ITEM
    ON ITEM.ITEM_ID = MFHD_ITEM.ITEM_ID) INNER JOIN MFHD_MASTER
    ON MFHD_ITEM.MFHD_ID = MFHD_MASTER.MFHD_ID)
    ON LOCATION.LOCATION_ID = ITEM.PERM_LOCATION
    WHERE (((ITEM_BARCODE.ITEM_BARCODE)=[Bar code:]));

    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.