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

    How to recover circulation accidentally done on old version, post-upgrade

    • Article Type: General
    • Product: Aleph
    • Product Version: 17.01

    Description:
    We've successfully migrated to version 20. I'd left version 17 accessible to the circulation dept for comparison and unfortunately on Friday, August 21, the circulation staff opened version 17 rather than version 20 on one of the workstations and did all the day's circulation activity for Friday on version 17. How can I obtain a list of loans and renewals with patron ids for that day out of the version 17 database?

    Resolution:
    There were just 25 circ transactions on Friday:

    SQL> select z35_rec_key || '-' || Z35_ITEM_SEQUENCE, z35_id, z35_event_type from z35 where z35_event_date = '20090821';

    Z35_REC_KEY||'-'||Z35_ITEM_SEQUENCE Z35_ID Z3
    -------------------------------------------------- ------------ --
    000434747-10 82
    000296000-20 11114 50
    000296000-50 1027966 61
    000380627-10 988992500 61
    000380208-10 988992500 61
    000434782-10 988992500 61
    000437236-10 988992500 61
    000380625-10 6663 61
    000342074-10 82
    000056220-840 82
    000428215-10 82
    000296000-20 11114 61
    000428611-10 11009 50
    000089593-10 1031384 50
    000038697-10 1031384 50
    000244458-10 82
    000380250-10 11009 61
    000428706-10 16690 50
    000433713-10 10736 50
    000159420-10 1026527 61
    000433713-10 10736 61
    000245995-10 27238 50
    000342476-10 6199 63
    000342476-10 6199 61
    000433713-10


    Event type

    50 is a loan;
    61 is a return;
    82 is return of an item not on loan;
    63 is a renewal


    • Article last edited: 10/8/2013