Batch modification tool - information pack
This document includes instructions for some of different batch modification tools on Koha.
How to use the batch modification tools with the reports module
There are a variety of ways to collect 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 to be modified or deleted using the Reports module are to identify bibliographic records or item records.
Identifying bibliographic records to be modified requires a report which retrieves biblionumbers.
Identifying item records to be modified requires a report which retrieves item numbers.
It is possible to create a report with both biblionumbers and item numbers which will provide the option to use either the item modification tool or the bibliographic record modification tool.
Option 1 - Using a report to modify bibliographic records
The example below uses a report for records added between two dates. This is just a random scenario to demonstrate how completing a batch record modification from an SQL report can be completed. Please be aware this is a very general report and this should be tested to ensure it won’t slow your site by being too large. If you have any concerns, or would like support in creating your own SQL report, please contact Interleaf Technology directly.
Go to Reports > Guided reports > Use saved.
This will bring you to a table of reports on your site.
In this example, the report is found by searching for the title in the search box at the top of the table. This narrows the table to a single report
which can then be run by clicking the Run button in the Actions column.
The report results are generated and as they include a bibliographic number there is a button at the top of the table called Batch operations with 20 visible records.
This is the feature that allows staff to send records in the report to be batch modified or deleted. Only records that actually appear on the first page of the report will be sent to be altered, records on the other pages of the report will not be sent. This limitation is to prevent too many items being sent through to the modification or deletion tool and slowing the system.
To increase the number of items appearing on the first page of the report click the box to the right of the line Rows per page and select the appropriate number from the dropdown menu.
After altering the amount of results appearing on the first page of the report the button has changed to Batch operations with 50 visible records.
When the Batch operations with 50 visible records is clicked the options for changing bibliographic records appear, Batch record modification, Batch record deletion and Add to list.
Clicking Batch record modification will send the visible records to the Batch record modification page.
Option 2 - Use a report to batch modify item records
Go to Reports > Guided reports > Use saved.
This will bring you to a table of reports on your site.
In this example, the report is found by searching for the title in the search box at the top of the table. This narrows the table to a single report
which can then be run by clicking the Run button in the Actions column.
The report results are generated and as they include an item number there is a button at the top of the table called Batch operations with 20 visible records.
This is the feature that allows staff to send records in the report to be batch modified or deleted. Only records that actually appear on the first page of the report will be sent to be altered, records on the other pages of the report will not be sent. This limitation is to prevent too many items being sent through to the modification or deletion tool and slowing the system.
To increase the number of items appearing on the first page of the report click the box to the right of the line Rows per page and select the appropriate number from the dropdown menu.
After altering the amount of results appearing on the first page of the report the button has changed to Batch operations with 50 visible records.
When the Batch operations with 50 visible records is clicked the options changing item records appear, Batch item modification and Batch item deletion.
Clicking Batch item modification will send the visible records to the Batch item modification page.
Option 3 - Use a report with the option of either item or bibliographic modification tools
Go to Reports > Guided reports > Use saved.
This will bring you to a table of reports on your site.
In this example, the report is found by searching for the title in the search box at the top of the table. This narrows the table to a single report
which can then be run by clicking the Run button in the Actions column.
The report results below include both item number and biblionumber. There is a button at the top of the table called Batch operations with 20 visible records.
When the Batch operations with 20 visible records button is clicked the options for both modifying the item records and the bibliographic records appear.
This is the feature that allows staff to send records in the report to be batch modified or deleted. Only records that actually appear on the first page of the report will be sent to be altered, records on the other pages of the report will not be sent. This limitation is to prevent too many items being sent through to the modification or deletion tool and slowing the system.
To increase the number of items appearing on the first page of the report click the box to the right of the line Rows per page and select the appropriate number from the dropdown menu.
After altering the amount of results appearing on the first page of the report the button has changed to Batch operations with 50 visible records.
When the Batch operations with 50 visible records is clicked the options changing item records appear, Batch item modification and Batch item deletion.
| Version | Date | Detail | Author |
| 1.0 | 05/03/20 | Document created | Holly Cooper |
| 2.0 | 02/04/20 | Adding information | Holly Cooper |
| 2.1 | 03/04/20 | Adding information to screenshots | Holly Cooper |
| 2.2 | 06/04/20 | Published | Holly Cooper |
| 2.3 | 22/06/20 | Transferred to Zoho | Daphne Hoolahan |
| 2.4 | 21/07/26 | Updated for newer release of Koha | Holly Cooper |
Using a report to modify bibliographic records
The example below uses a report for records added between two dates. This is just a random scenario to demonstrate how completing a batch record modification from an SQL report can be completed. Please be aware this is a very general report and this should be tested to ensure it won’t slow your site by being too large. If you have any concerns, or would like support in creating your own SQL report, please contact Interleaf Technology directly.
Go to Reports > Guided reports > Use saved.
This will bring you to a table of reports on your site.
In this example, the report is found by searching for the title in the search box at the top of the table. This narrows the table to a single report
which can then be run by clicking the Run button in the Actions column.
The report results are generated and as they include a bibliographic number there is a button at the top of the table called Batch operations with 20 visible records.
This is the feature that allows staff to send records in the report to be batch modified or deleted. Only records that actually appear on the first page of the report will be sent to be altered, records on the other pages of the report will not be sent. This limitation is to prevent too many items being sent through to the modification or deletion tool and slowing the system.
To increase the number of items appearing on the first page of the report click the box to the right of the line Rows per page and select the appropriate number from the dropdown menu.
After altering the amount of results appearing on the first page of the report the button has changed to Batch operations with 50 visible records.
When the Batch operations with 50 visible records is clicked the options for changing bibliographic records appear, Batch record modification, Batch record deletion and Add to list.
Clicking Batch record modification will send the visible records to the Batch record modification page.
Use a report to batch modify item records
Go to Reports > Guided reports > Use saved.
This will bring you to a table of reports on your site.
In this example, the report is found by searching for the title in the search box at the top of the table. This narrows the table to a single report
which can then be run by clicking the Run button in the Actions column.
The report results are generated and as they include an item number there is a button at the top of the table called Batch operations with 20 visible records.
This is the feature that allows staff to send records in the report to be batch modified or deleted. Only records that actually appear on the first page of the report will be sent to be altered, records on the other pages of the report will not be sent. This limitation is to prevent too many items being sent through to the modification or deletion tool and slowing the system.
To increase the number of items appearing on the first page of the report click the box to the right of the line Rows per page and select the appropriate number from the dropdown menu.
After altering the amount of results appearing on the first page of the report the button has changed to Batch operations with 50 visible records.
When the Batch operations with 50 visible records is clicked the options changing item records appear, Batch item modification and Batch item deletion.
Clicking Batch item modification will send the visible records to the Batch item modification page.
| Version | Date | Detail | Author |
| 1.0 | 21/07/26 | Document created | Holly Cooper |
Related Articles
How to use the batch modification tools with the reports module
There are a variety of ways to collect 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 to be ...How to perform a batch modification of items
Identifying the items to be modified In order to batch modify items from your system it is necessary to have an identifying number for the items to be modified. This identifying number can be barcodes or itemnumbers. These can be accumulated in a ...How to batch edit patron details
It is possible to modify multiple patron records at once using the Batch patron modification tool. This document contains directions to the tool and instructions for how to use it. Navigating to the Tool Go to Tools > Patrons and circulation > Batch ...How to use the built in Batch Change Due Date tool
This built in feature to allows staff to bulk edit due dates on checked out items. This document will outline how to navigate to and use the tool and includes a specific example to demonstrate how the process works. Step 1 - Navigate to the batch ...How to batch delete GONE borrowers using the reports module
This document will outline how to delete GONE borrowers from Scooter. Run the Borrowers requiring manual deletion report. Go to Reports > Guided reports click Use saved and you will be brought to a new page with a table of all the reports currently ...