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 Item Records where Item Permanent Location is not the same as the MFHD Location (location mismatch)

    Voyager to Alma Migration Query: Identify Item Records where Item Permanent Location is not the same as the MFHD Location (location mismatch)

    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

     

    Before migrating to Alma, you may want to resolve any mismatches between an item's Permanent Location and its MFHD Location.

    In the migration process, if an item record carries a different permanent location from the location in the holding record, Alma will create multiple holding records: one MFHD for the holding and items that match that holding; and one or more for any items that have a different permanent location, with the item permanent location being added to the new MFHD. This may not be desirable. For more information discuss this with your migration team.

    This query, which you can run in Voyager's Prepackaged Access Reports, will help you identify items where the Permanent Location is different from the MFHD Location. Note that this query includes the barcode if it exists ("outer join" or "left join"):

    SELECT DISTINCT LOCATION_1.LOCATION_CODE AS ItemPermLoc, LOCATION.LOCATION_CODE AS MFHDLoc, utf8to16([mfhd_master].[DISPLAY_CALL_NO]) AS Display_Call_No, MFHD_MASTER.MFHD_ID, ITEM.ITEM_ID, ITEM_BARCODE.ITEM_BARCODE
    FROM ((((MFHD_MASTER INNER JOIN MFHD_ITEM ON MFHD_MASTER.MFHD_ID = MFHD_ITEM.MFHD_ID) INNER JOIN ITEM ON MFHD_ITEM.ITEM_ID = ITEM.ITEM_ID) INNER JOIN LOCATION ON MFHD_MASTER.LOCATION_ID = LOCATION.LOCATION_ID) INNER JOIN LOCATION AS LOCATION_1 ON ITEM.PERM_LOCATION = LOCATION_1.LOCATION_ID) LEFT JOIN ITEM_BARCODE ON ITEM.ITEM_ID = ITEM_BARCODE.ITEM_ID
    WHERE (((MFHD_MASTER.LOCATION_ID)<>[ITEM].[PERM_LOCATION]));

     

    BONUS SQL

    The following query is a pass through version of the above query (note that it does not include the barcode):

    SELECT 
    a.location_id, b.perm_location, b.temp_location, c.mfhd_id, c.item_id
    FROM
    mfhd_master a, item b, mfhd_item c
    WHERE
    a.mfhd_id = c.mfhd_id
    and b.item_id = c.item_id
    and a.location_id != b.perm_location
    ORDER BY c.mfhd_id;
     

    This pass through query includes the item barcode but note that it excludes MFHDs without a barcode (it uses an "inner join"):

    SELECT
    a.mfhd_id, a.location_id, b.item_id, b.perm_location, b.temp_location, c.mfhd_id, c.item_id, d.item_barcode
    FROM
    mfhd_master a, item b, mfhd_item c, item_barcode d
    WHERE 
    a.mfhd_id = c.mfhd_id
    and b.item_id = c.item_id
    and c.item_id = d.item_id
    and a.location_id != b.perm_location
    ORDER BY c.mfhd_id;

     

    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. 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 Duplicate Vendor Names
      • Voyager to Alma Migration Query: Identify MFHDs in a specific location that are missing a specific call number suffix
    • 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