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

    Voyager to Alma Migration Query: Identify Patrons by Barcode Status

    • 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 look at your patron records by barcode status.  

    The following pass through query can be used in Voyager Prepackaged Access Reports to list patron records by barcode status.

    Consult with your migration team before embarking on any related data cleanup.

    NOTE that this is a Pass Through SQL query.

    The following query produces a list of patron records, one row per barcode.

    SELECT
    a.patron_id, a.last_name, a.first_name, b.patron_barcode, b.barcode_status, c.barcode_status_desc, d.patron_group_id, d.patron_group_name
    FROM
    patron a, patron_barcode b, patron_barcode_status c, patron_group d
    WHERE
    a.patron_id = b.patron_id
    and b.barcode_status = c.barcode_status_type
    and b.patron_group_id = d.patron_group_id
    and b.barcode_status not in (1)
    ORDER BY a.patron_id;

     

    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: 06-Apr-2021