- Product: Voyager
- Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare
When migrating from Voyager to Alma it might be useful to identify and review any "brief" bibliographic records that were perhaps used for testing or were not overlaid. Note that this is optional and that you may want to consult with your migration team before embarking on this data cleanup.
The following pass through query can be used in Voyager Prepackaged Access Reports to identify bibliographic records ("BIB" records) with a record length of X or less (in this example a record length of 500 or less).
bib_id, to_number(substr(record_segment,1,5)) as reclength
seqnum = 1
and substr(record_segment,1,5) < '00500';
The following bonus pass through query identifies brief bibliographic records (record length of 200 or less) that are attached to line items:
seqnum = 1
and substr(record_segment,1,5) < '00200')
and bib_id in
The following bonus pass through query finds the PO and Line Item data for brief bibliographic records linked to POs:
FROM bib_text WHERE bib_id in
WHERE seqnum = 1
and substr(record_segment,1,5) < '00500'));
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