Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Community Knowledge
    4. Voyager to Alma Migration Query: Bibliographic Records with Multiple 245 Fields

    Voyager to Alma Migration Query: Bibliographic Records with Multiple 245 Fields

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    Created By: Laura Guy
    Created on: 7/13/2020



    When migrating from Voyager to Alma, you may want to identify, review and clean up any bibliographic records that have multiple 245 fields.  While multiple 245 fields is not a problem per se, it is against MARC standards and there is some wisdom in cleaning these records up.

    These three queries, which can be run using Voyager's Prepackaged Access Reports, will display bibliographic records with more than one 245 field.  Note that this is a series of queries, the first two are Make Table queries and the three must be run in sequence (Query 1, Query 2, and finally Query 3). The third query will produce your results as a list of BIB_IDs.

    Note that Query 2 is a BLOB query and may take a very long time to run.

    Bibliographic records with multiple 245 fields Query 1: looks for bib records with more than one entry in the 2450 index. It creates the table named Bib multiple 245 table 1, containing a list of the bib IDs:

    SELECT BIB_INDEX.BIB_ID INTO [Bib multiple 245 table 1]
    FROM BIB_INDEX
    GROUP BY BIB_INDEX.BIB_ID, BIB_INDEX.INDEX_CODE
    HAVING (((BIB_INDEX.INDEX_CODE)='2450') AND ((Count(BIB_INDEX.BIB_ID))>1));

    Bibliographic records with multiple 245 fields Query 2: For the bibs listed by query 1, blob query 2 looks up the full content of each of the 245 fields found by query 1. This query may find cases where the 245 field is legitimately linked with an 880 field. It creates the table named Bib multiple 245 table 2, containing the bib IDs and the first and second 245 fields:

    SELECT [Bib multiple 245 table 1].BIB_ID, getfield(getbibblob([bib_id]),"245",1) 
    AS First245, getfield(getbibblob([bib_id]),"245",2) 
    AS Second245 INTO [Bib multiple 245 table 2]
    FROM [Bib multiple 245 table 1];

    Bibliographic records with multiple 245 fields Query 3: For the bibs listed by query 2, query 3 omits the records with a valid 245 880 linkage. The records identified by query 3 are the ones that need to be corrected.

    SELECT [Bib multiple 245 table 2].BIB_ID, [Bib multiple 245 table 2].Second245
    FROM [Bib multiple 245 table 2]
    WHERE ((([Bib multiple 245 table 2].Second245)<>""));

     

    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.

     




    Report
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Voyager to Alma Migration Query: Bibliographic Records With Empty Index Entries
      • Voyager to Alma Migration Query: Bibliographic Records with Multiple MFHDs
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved