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: Item Count by Location and Item Type

    Voyager to Alma Migration Query: Item Count by Location and Item Type

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



    When migrating from Voyager to Alma, it may be desirable to check for mismatches between location and item type and resolve any obvious mismatches.

    This query, which you can run using Voyager's Prepackaged Access Reports, displays what item types are found in each location, and provides a count.

    Questionable combinations can then be investigated and fixed if necessary (see link to that query at bottom of this page).

    SELECT LOCATION.LOCATION_NAME, ITEM_TYPE.ITEM_TYPE_NAME, Count(ITEM.ITEM_ID) AS CountOfITEM_ID
    FROM (ITEM INNER JOIN ITEM_TYPE ON ITEM.ITEM_TYPE_ID = ITEM_TYPE.ITEM_TYPE_ID) INNER JOIN LOCATION ON ITEM.PERM_LOCATION = LOCATION.LOCATION_ID
    GROUP BY LOCATION.LOCATION_NAME, ITEM_TYPE.ITEM_TYPE_NAME;
     

    For other queries that may be useful, see my "Surviving Almanado" 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.

     

    See also: Identify Specific Records Where Item Type is not Consistent with the Item Location

     




    Report
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Voyager to Alma Migration Query: Item Barcodes With The Wrong Length
      • Voyager to Alma Migration Query: Item records that have data in the Spine Label Field
    • 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