Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

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

    1. Last updated
    2. Save as PDF
    • 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