Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. How to delete a set of authority records

    How to delete a set of authority records

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    4. Additional Information
    5. Attachment
    • Article Type: Q&A
    • Product: Voyager
    • Product Version: 8.0.0
    • Relevant for Installation Type: Total Care; Dedicated-Direct; Direct; Local

    Question

    How to delete a set of authority records using Global Data Change (GDC)

    Answer

    1. Identify authority records by record ID, or use Scan Job if records all contain a characteristic that can be scanned for.
    2. Create Data Change Rule Set with following parameters:
      1. Condition: <set condition specific to your data; condition should be true for all records in set>
      2. Consequence: Record Disposition / Delete (see Chapter 3, Table 2 of the GDC User's Guide)
    3. Add Data Change Rule Set to a Data Change Rule Set Group.
    4. Preview data change. Success should be indicated by "Rule execution causes record to be deleted" at top of preview window
    5. Schedule the Data Change Job.

    Additional Information

    Example scenario: Vendor has completed authority work & all existing authority records are to be deleted before new authorities from vendor are imported.

    The ability to create a Record Set from a Range of Record IDs was first available in Voyager 10.0

    1. Add full range of records
      1. Find highest auth_id  (See this Article for the MS Access Prepackaged Reports SQL code to find highest record ID)
        1. select max(auth_id) from auth_master;
        2. Note output - this will be top of record range in next step.
      2. GDC > Record Sets > Specific Records > Range of Records
        1. In first box, start with 1
        2. In second box, add auth_id output from step 1.1.2 above.
    2. Use Data Change Job to execute deletion:
      1. Create Data Change Rule Set with following parameters:
        1. Condition: MARC Control Field Exists / LDR
        2. Consequence: Record Disposition = Delete
      2. Add Data Change Rule Set to Data Change Rule Set Group.
      3. Preview data change in Preview slider. Success should be indicated by "Rule execution causes record to be deleted" at top of preview window
      4. Job Management > Submit Data Change Job > Use Record Set & Data Change Rule Set Group and submit job.

    Result: all authority records in database are deleted.

    Alternate method for creating record set: Use Scan Job to put all authority records into record set:

    1. GDC > Rule Sets > Scan Rule Set
      1. Condition: MARC Control Field Exists / LDR
      2. Consequence: Include
    2. Add Scan Rule Set to Scan Rule Set Group
    3. Job Management > Submit Scan Job > Use Scan Rule Set Group to scan Entire Database and put records in New Record Set

    Sample Scan Rule Set for this scenario attached. This can be imported into GDC in Scan Rule Sets > Import.

     

    Additional Information

    See Chapter 3 of the Global Data Change User's Guide.

    Attachment

    ScanRule_IncludeAllAuthRecords.dslr

     


    • Article last edited:22-Nov-2019
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to create interleaved file with Prebulk, with all mfhds mapped to one location
      • How to delete a WebVoyage Tomcat skin in Voyager
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    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