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. Knowledge Articles
    4. How can item records be exported from Voyager?

    How can item records be exported from Voyager?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Product: Voyager
    • Product Version: All
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

    Question

    How can item records be exported from Voyager?

    Answer

    Although we think of it as such, there isn't a discrete item "record" to be extracted like there is a bib or MFHD record.  The item record consists of data that is distributed among multiple Voyager Oracle tables.

    • MarcExport will work for any MARC format record (Authority, Bibliographic, Holding).
    • Item records are not MARC format; Voyager does not have a utility for exporting item records.
    • You can use Prepackaged Reports (Reports.mdb) to query for item data and export it  to an external file.
    • Item data and item links to BIB and MFHD records are stored in following tables:

    ITEM 
    ITEM_BARCODE 
    ITEM_STATUS 
    ITEM_NOTE 
    ITEM_STATS 
    MFHD_ITEM 
    BIB_ITEM 

    Additional Information

    See also: What is the logic that governs which tables Voyager Item data are stored in?

    For more information about the tables and fields, see the Class Diagrams found here: https://knowledge.exlibrisgroup.com/Voyager/Product_Documentation/Voyager_Data_Dictionaries_and_ER_Diagrams

    You may want to consult the Voyager Customer Listserv for other options.


    • Article last edited: 17-Jul-2017
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How can I tell which cron jobs are set up to run?
      • How can MFHD location be changed in bulk?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      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