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: Identify specific records where item type is not consistent with the item location

    Voyager to Alma Migration Query: Identify specific records where item type is not consistent with the item location

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    Created By: Laura Guy (contact)
    Created on: 10/05/2020



    When migrating from Voyager to Alma it may be important to identify and review those records where the item type is not consistent with the item's location.  This query is designed to run using the output you receive of the on-board Prepackaged Access Report that is called "Item Count by Location and Type".  That on-board query allows you to see the number of occurrences of each combination of permanent location and item type.  In other words, it simply provides counts of each pairing.

    The following query, which can be run using Voyager Prepackaged Access Reports, will show you the specific items with questionable conbinations as per the on-board prepackaged report described above. When you run this query, it will ask for the LOCATION_NAME and the ITEM_TYPE_NAME.  Both are case senstive and both must be entered exacty as you see them in the "Item Count by Location and Type" query.

    SELECT LOCATION.LOCATION_NAME, ITEM_TYPE.ITEM_TYPE_NAME, 
    utf8to16([mfhd_master].[DISPLAY_CALL_NO]) AS DISPLAY_CALL_NO, 
    MFHD_ITEM.ITEM_ENUM, MFHD_ITEM.CHRON, 
    ITEM.ITEM_ID, ITEM_BARCODE.ITEM_BARCODE
    FROM ((ITEM_TYPE INNER JOIN ((MFHD_ITEM INNER JOIN MFHD_MASTER 
    ON MFHD_ITEM.MFHD_ID = MFHD_MASTER.MFHD_ID) INNER JOIN ITEM 
    ON MFHD_ITEM.ITEM_ID = ITEM.ITEM_ID) 
    ON ITEM_TYPE.ITEM_TYPE_ID = ITEM.ITEM_TYPE_ID) 
    INNER JOIN LOCATION ON ITEM.PERM_LOCATION = LOCATION.LOCATION_ID) 
    LEFT JOIN ITEM_BARCODE ON ITEM.ITEM_ID = ITEM_BARCODE.ITEM_ID
    WHERE (((LOCATION.LOCATION_NAME)=[Location Name (not CODE):]) 
    AND ((ITEM_TYPE.ITEM_TYPE_NAME)=[Item type Name (not CODE):]));

    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: Identify Recent Issues Data for Potential Cleanup
      • Voyager to Alma Migration Query: Identify Records where the 035 Field has a Malformed OCoLC Prefix
    • 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