Skip to main content
OCLC Support

Mass borrower deletion

Learn how to mass delete borrowers and delete single borrower records in Amlib.

Mass delete borrowers

It is best to delete students who have left BEFORE adding new students – for example: in a Primary School this will be the Year 7 students; in a Secondary School the Year 12 students can be found and deleted.

The following instructions are for a Primary School:

  1. Launch the Amlib client
  2. Go to Main > Borrowers > BorrowerWhere – the Borrower Where screen will display
  3. Create a Where clause – for example: Last Active < 31/12/2007 (this will search for all who were last active before a particular date)
    • Highlight the field to search on: Group
    • Choose Operator: <
    • Enter the Where condition, or the exact data you want to find – for example: 31/12/2007
    • Click the Paste button to insert the clause into the table
  4. An alternate Where clause might be – for example: Group = CHI (this will search for all Borrowers who are in that particular group)
    • Highlight the field to search on: Group
    • Choose Operator: =
    • Enter the Where condition, or the exact data you want to find – for example: CHI
    • Click the Paste button to insert the clause into the table
  5. Click on the F7 QtoFile button – the Borrower Saved Query Results screen will now display:
  6. Click on the F1 New button to create a new Saved File
  7. Type in a name for the file in the Details column – for example: Groups to Delete
  8. Click on F3 Save button
  9. Highlight the new Saved File and click on the F9 Select button to save results to this file
  10. A prompt will display noting the number of borrowers contained in the file
  11. Click the OK button
  12. Go to Main > Borrowers > Borrower – the Borrower screen will display
  13. Select File > DisplayFile – the Borrower Saved Query Results file screen will display
  14. Highlight the required Saved File and click on the F9 Select button to display the file
  15. The results will display in a Borrower List:
  16. Select the Borrowers to be deleted by highlighting the rows – to select and highlight all the Borrowers:
  17. Press the Ctrl key and click with the left mouse button first borrower in range and then run the mouse down the left column, or
  18. Select first name in list and then Press shift and select the last Borrower in the range (useful for highlighting all of a big list!)
  19. From the menu, select Table > MassBorrowerDelete – a prompt with the following message will display: You are about to delete the selected Borrowers. Do you want confirmation of delete message?

Hint: You have already highlighted the borrowers for deletion. Confirming each and every borrower to be deleted will slow down the process.

  • No: All borrowers highlighted in the table will be deleted unless the borrower has loans, reservations or memos. No messages display.
  • Yes: Each borrower’s ID will display. Messages will also display if the borrower cannot be deleted (for example: the borrower has loans, reservations or memos, etc).

Delete single patron records

  1. Search by Surname in the Borrower Details screen
  2. Delete by clicking the F4 Delete button – a prompt with the following message will display:

    Borrower XXXXX Are you sure you wish to delete this Borrower?
  3. Click the Yes button to delete the borrower record – a prompt with the following message will display: The Borrower has been Deleted
  4. Click the OK button

Please Note: Students with Loans, Reservations or Memos will not be deleted. If a student has left with items showing on loan, if the books are unlikely to be returned, it is suggested that these items be returned from the patron and either made lost or deleted so that the student (or teacher!) can be deleted from your database.

 

  • Was this article helpful?