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