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. Consolidating/Removing additional patron addresses from records

    Consolidating/Removing additional patron addresses from records

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

    Description:
    We recently performed a survey of the usage on certain fields in the patron database. One of the conclusions we came to was that we should only keep one mailing address per patron. We will modify our patron load for future patrons.

    However, we need to find a good way to trim down the records on existing patrons. What is the best way to go about this?

    Thanks,
    Natalie

    ps - I like the planned activity fields! I'll use them for this ticket for the extra contact info. [ <Jerry Specht > ]
    [ <Jerry Specht > ]

    Resolution:
    I can think of two ways to do this:

    1. p_file_20. Resend the patron records with the following for the address you want to delete:

    ADDR-REC with ADDR-REC-ACTION "D" (Delete) / ADDR-REC-TYPE

    2. SQL.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Consequences of a Large Number of Patron ID Types (Z308)
      • Consortial borrowing in Aleph
    • Was this article helpful?

    Recommended articles

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