Voyager to Alma Migration Query: Identify "Brief" Bib Records
- Product: Voyager
- Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare
Description
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.
NOTE that these queries are Pass Through SQL queries.
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).
SELECT
bib_id, to_number(substr(record_segment,1,5)) as reclength
FROM bib_data
WHERE
seqnum = 1
and substr(record_segment,1,5) < '00500';
BONUS SQL:
The following bonus pass through query identifies brief bibliographic records (record length of 200 or less) that are attached to line items:
SELECT
bib_id, title
FROM bib_text
WHERE
bib_id in
(SELECT bib_id
FROM bib_data
WHERE
seqnum = 1
and substr(record_segment,1,5) < '00200')
and bib_id in
(SELECT bib_id
FROM line_item);
The following bonus pass through query finds the PO and Line Item data for brief bibliographic records linked to POs:
SELECT
line_item_number, po_id
FROM line_item
WHERE
bib_id in
(SELECT bib_id
FROM bib_text WHERE bib_id in
(SELECT bib_id
FROM bib_data
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