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. Delete all patrons from Aleph test system including claims, loans etc.

    Delete all patrons from Aleph test system including claims, loans etc.

    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 can we delete all patrons except 12, including claims, loans, etc., from our Aleph test system?

     

    Answer    
    Use service 'Delete Patron Records (cir-23)' This service can use an input file with ID numbers.

    Possible solution:
    1. Create an input file with all IDs currently in the system with help of SQL query and spooling it into a text file.
    2. Remove all IDs that should be kept from this text file
    3. Use this file as input for service cir-23, choosing the "Override for all attached transactions" option in the submission.

     

    Tip: run with 'Update Database =N' first.

     

     


    • Article last edited: 26-Jun-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Delete All ADAM Objects
      • Delete BIB Recs Incl. Related ADM/HOL Recs (manage-33): BATCH-DELETE lines
    • Was this article helpful?

    Recommended articles

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