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

    Voyager to Alma Migration Query: Find Patrons with Blank Barcodes

    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Description

    When migrating from Voyager to Alma it may be helpful to identify patron records with blank barcodes. Blank patron barcodes are not commonly present but can exist in the database.

    Note that this is optional and that you may want to consult with your migration team before embarking on any related data cleanup.

    NOTE that this is a pass through query:

    SELECT
    a.patron_id, a.first_name, a.last_name, b.patron_barcode, b.patron_group_id, c.patron_group_name
    FROM
    patron a, patron_barcode b, patron_group c
    WHERE
    a.patron_id = b.patron_id
    and b.patron_group_id = c.patron_group_id
    and b.patron_barcode is null;

     

    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.

     


    • Article last edited: 21-Jun-2021