Batch Record Deletion
Batch Record Deletion
There may be times when you will want to delete a batch of bibliographic records. You will need to delete all the attached items first, but then you can follow this process to delete the bibliographic records with no attached items.
First create a new report to list the records - All bibs where last item deleted
SELECT b.biblionumber, b.title, b.author
FROM biblio b
LEFT JOIN items i USING (biblionumber)
WHERE i.itemnumber IS NULL
AND b.biblionumber IN (SELECT biblionumber FROM deleteditems)
GROUP BY b.biblionumber
ORDER BY b.title
If you are happy to proceed, create a second new report to list just the biblionumbers - All biblionumbers where last item deleted
SELECT b.biblionumber
FROM biblio b
LEFT JOIN items i USING (biblionumber)
WHERE i.itemnumber IS NULL
AND b.biblionumber IN (SELECT biblionumber FROM deleteditems)
GROUP BY b.biblionumber
3. Run the report and when the results are listed, click the button to Download, and then Comma separated text (csv)
Make a note of the name of the downloaded file.
4. Go to Tools, then Batch Record Deletion
5. Select the downloaded file of biblionumbers and click Continue
7. Click the button to Delete selected records.
Related Articles
How to use the batch modification tools with the reports module
There are a variety of ways to collect catalogue records for batch modification or deletion. These instructions will outline how to use the Reports module to locate and send records to the different modification tools. The options for sending records ...How to use the batch edit tools through catalogue
There are a variety of ways to collect catalogue records for batch modification or deletion. These instructions will outline how to use the catalogue search function to locate and send records to the different modification tools. Step 1 - Search the ...How to perform a batch deletion of items
Step 1 - Finding items to delete In order to delete items from your system it is necessary to have the barcodes or item numbers of the items to be deleted. These can be accumulated in a number of ways; however, it is common to use the reports module ...How to store record creator and editor information in MARC fields
It is possible to note information about the record creator and the last user to make an edit in the MARC record. Step 1 - Designate MARC fields to store the information The fields to store information related to the creator and editor of the record ...How to perform a batch modification of items
This document will outline how to complete a batch edit of unrelated items using the Batch item modification tool. Step 1 - Finding items to modify In order to modify items from your system it is necessary to have the barcodes or itemnumbers of the ...