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. How to make Aleph records updated by SQL be harvested by ARC

    How to make Aleph records updated by SQL be harvested by ARC

    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 make Aleph records updated by SQL (instead of the GUI or with a service) be harvested by ARC. 

    See example update in Additional Information below.

     

    Answer    
    In addition to whatever other updates are made to the z601, update the Z601_UPD_TIME_STAMP: 

    SQL> update z601 set Z601_UPD_TIME_STAMP = ‘YYYYMMDDHHMMSSS’; 

    where ‘YYYYMMDDHHMMSSS’ is the UTC (Coordinated Universal Time) (basically, the Greenwich Mean Time) 

    This will trigger the inclusion of the record by ARC.

     

    Additional Info
    If Z68 and Z601 records (invoices or orders) created in error and deleted are not removed from ARC, then see Article "ARC incremental mode, order deletions not propagated" in regard to triggers.  

     

    Even if we renew the budgets with acq-06-b in May, later in the summer our Acq Dpt revises each Serials order to planned the encumbrance of each title. Instead of asking our library technicians to upgrade manually all the orders, the Serials Librarian send me a list of the amount she wants to use and I am updating with SQL the z601 records (created when we run acq-06-b at the end of the fiscal year). We've been doing that for the last 3 years without any problem. 

    After the SQL update, ARC does not show the new amount; it is still using the previous one. 

     

     


    • Article last edited: 28-Feb-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to make a shortcut key for changing catalog editing direction
      • How to make ALEPH WEB OPAC display the Results List always in Table Format?
    • 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