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

    Voyager to Alma Migration Query: Identifying Duplicate Patrons by Patron Barcode

    Created By: Laura (Customer) Guy
    Created on: 11/01/2021



    When migrating from Voyager to Alma it may be helpful to identify and review duplicate patron records identified by having duplicate patron barcodes.

    The following query, which can be run using Voyager Prepackaged Access Reports, provides a count of duplicate patron barcodes, regadless whether or not the barcode is active.

    SELECT PATRON_BARCODE.PATRON_BARCODE, Count(PATRON_BARCODE.PATRON_BARCODE_ID) AS CountOfPATRON_BARCODE_ID
    FROM PATRON_BARCODE INNER JOIN PATRON ON PATRON_BARCODE.PATRON_ID = PATRON.PATRON_ID
    WHERE (((PATRON.DB_ID)="0" Or (PATRON.DB_ID) Is Null))
    GROUP BY PATRON_BARCODE.PATRON_BARCODE
    HAVING (((Count(PATRON_BARCODE.PATRON_BARCODE_ID))>1))
    ORDER BY PATRON_BARCODE.PATRON_BARCODE;

    This next query filters on active barcodes (BARCODE_STATUS is 1)

    SELECT PATRON_BARCODE.PATRON_BARCODE, Count(PATRON_BARCODE.PATRON_BARCODE_ID) AS CountOfPATRON_BARCODE_ID
    FROM PATRON_BARCODE INNER JOIN PATRON ON PATRON_BARCODE.PATRON_ID = PATRON.PATRON_ID
    WHERE (((PATRON_BARCODE.BARCODE_STATUS)="1")
    AND ((PATRON.DB_ID)="0" Or
    (PATRON.DB_ID) Is Null))
    GROUP BY PATRON_BARCODE.PATRON_BARCODE
    HAVING (((Count(PATRON_BARCODE.PATRON_BARCODE_ID))>1))
    ORDER BY PATRON_BARCODE.PATRON_BARCODE;


    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.