Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Bulk move of items from Reserves back to regular location

    Bulk move of items from Reserves back to regular location

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Question    
    How to move items from Reserves sublibrary back into the main library? The change could be done via SQL, but are there alternatives?

     

    Answer    
    The problem with SQL updating item records is discussed in Article 000042656 ("SQL update of item sublibrary, collection, and call number fields don't update indexes"). (See Smartlink below.) 

    As described in section 6.1.3 of the "Staff User’s Guide – Course Reading and Reserves", this is typically done using the “Change Item Information” option under "Items" on the Circulation client menu bar (the second line from the top of the Circ client screen). 

    When the items were placed on Reserves the z30_sub_library, z30_collection, and/or z30_item_process_status were changed, and (if the first two) the z30_temp_location flag was set. 

    Assuming so, the “Restore Item Information” option can be used to take the item off Reserves. When "Change Item Information" is performed, the original values are stored in the Z30 field of the ADM record. And when "Restore Item Information" is performed, those values are retrieved from the Z30 field of the ADM record and the z30_temp_location flag is unchecked. 

    The "Restore Item Information" function requires only the item barcode. The barcode of each item being taken off of Reserves is scanned into the Item Barcode box. 

    If staff feel that having to scan the barcode is too much trouble, a batch change of z30_temp_location flag to "N" could be performed by the manage-62 Item Update Service. The advantage of this method over SQL is that it triggers proper reindexing of the location (in the bib indexes).

     

    Additional Info
    See also Article "SQL update of item sublibrary, collection, and call number fields don't update indexes"

     

     


    • Article last edited: 28-Feb-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Bulk item process status updates based on barcode
      • C0101 2 error message after password change
    • Was this article helpful?

    Recommended articles

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