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. Circulation Log - can the self-check machine's location be included?

    Circulation Log - can the self-check machine's location be included?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    Question on the Circulation Log regarding Self Check machines...

    Currently the log will show the USER information, which the library likes, but they are wondering, when a book is loaned by one of their self check machines, is there any way to identify which one. (Currently, the USER name just shows "Selfcheck".)

    In WXY50's case, they have two machines (in two different sublibraries) and would like to see where the item was checked out.

    Resolution:
    The z309 Circulation logger record contains a Z309_CATALOGER_IP field which does not display in the GUI.

    The following SQL could be used to get statistics on how many items are checked out at each:

    SQL-WXY50> select Z309_CATALOGER_IP, count(*) from z309 where Z309_CATALOGER_NAME = 'SELFCHECK' group by Z309_CATALOGER_IP;

    And this could be used to see where particular items were checked out:

    SQL-WXY50> select z309_rec_key_3, Z309_CATALOGER_IP from z309 where Z309_CATALOGER_NAME = 'SELFCHECK' and substr (z309_date_x,1,8) = '20081029';

    Note: This presumes that these two self-check machines have different, distinct ip-addresses. If not, this will not give you any useful information.

    If you want the Z309_CATALOGER_IP to display in the GUI, that would be an enhancement request.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Circulation History Summary Not Populated for xxx50 Items
      • Circulation log continues to show Self-Check when tab_circ_log.eng has "N"
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    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