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

    How to delete a set of authority records

    • 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

    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
    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.

    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 recoords 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.

     

    Attachment

    ScanRule_IncludeAllAuthRecords.dslr

     


    • Article last edited: 09-Jan-2019