Archiving Borrowers

File Name: Archiving borrowers.docx
Category: Knowledge Base
File Size: 98.23999999999999 KB
File Type: application/msword
Created Date: 01-09-2023
Last Updated Date: 10-03-2026

Related documents

Maintenance - Automatic Renewal Notice Wording - Spydus 10.5 - 2020-08

Wording for Automatic Renewal Notices

Spydus 10.5

August 2020

Gympie Libraries / Richmond Tweed Libraries

dvdreservations
A List of DVD titles with reservations
Monthly Discards Report (v.1) - select own dates
Monthly Discards Report: gives a summary of the numbers of items 'discarded' in each collection and its total value, for each branch/library, for a particular period - to be entered when the refresh button is clicked (uses a parameter macro). The 2nd version uses the date range 'LASTMONTH' in case the date selection feature in the first version doesn't work.(Spydus 8.2) Madelon van Zijll de Jong - Hastings Central Library NZ
How to become a SPUN member (for the Primary Member)

With the set-up of the new website which incorporates invoicing, we need to assign each Library site with a Primary member who will then add add/remove staff to the website.

  • There can only be one Primary member per site to avoid multiple invoices being generated.
  • The Primary member has been determined based on the previous year’s membership form.
reservations_excluding_dvd
Titles which are heavily reserved, excluding DVDs
heavy_reserved_report - includes orders

This report lists heavily reserved biliographic records. It includes order information (if present) as well as a count of copies.

To get this report to work you need to create a new table in your SQL database by closely following the instructions in the attached zip file AT YOUR OWN RISK. I personally had no problems following these instructions but if you get stuck I'm afraid you're on your own. Likewise if you break your database in some bizarre way. I think that's very unlikely but I have to limit my liability here...

We commissioned Civica (in the form of Trevor) to write this report for us. They are happy for me to share the report we paid for but if you can't get it to work and want some help with it I'm sure your account manager can work something out.

The first column is a basic calculation of reservations per item and order.
2nd column is the title and collection.
Then it's total copies, total resies, total on order copies and order date.

I hope it's useful.

Ken

Search