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 using Global Data Change (GDC)
Answer
- Identify authority records by record ID, or use Scan Job if records all contain a characteristic that can be scanned for.
- Create Data Change Rule Set with following parameters:
- Condition: <set condition specific to your data; condition should be true for all records in set>
- Consequence: Record Disposition / Delete (see Chapter 3, Table 2 of the GDC User's Guide)
- Add Data Change Rule Set to a Data Change Rule Set Group.
- Preview data change. Success should be indicated by "Rule execution causes record to be deleted" at top of preview window
- 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
- Add full range of records
- Find highest auth_id (See this Article for the MS Access Prepackaged Reports SQL code to find highest record ID)
-
select max(auth_id) from auth_master;
- Note output - this will be top of record range in next step.
-
- GDC > Record Sets > Specific Records > Range of Records
- In first box, start with 1
- In second box, add auth_id output from step 1.1.2 above.
- Find highest auth_id (See this Article for the MS Access Prepackaged Reports SQL code to find highest record ID)
- Use Data Change Job to execute deletion:
- Create Data Change Rule Set with following parameters:
- Condition: MARC Control Field Exists / LDR
- Consequence: Record Disposition = Delete
- Add Data Change Rule Set to Data Change Rule Set Group.
- Preview data change in Preview slider. Success should be indicated by "Rule execution causes record to be deleted" at top of preview window
- Job Management > Submit Data Change Job > Use Record Set & Data Change Rule Set Group and submit job.
- Create Data Change Rule Set with following parameters:
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:
- GDC > Rule Sets > Scan Rule Set
- Condition: MARC Control Field Exists / LDR
- Consequence: Include
- Add Scan Rule Set to Scan Rule Set Group
- 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.