[Koha] Advice for how to update huge numbers of bib records, for former Millennium user

[Bales (US), Tasha R]

What would be the Koha equivalent to Millennium Create Lists* (or Alma Normalization Rules and Record Sets)?

So far, I see that lists and carts can be used to update records in Koha, but this seems to demand working with a pre-determined list of record numbers, or else by manually adding items to a cart.  What if I need to update a huge number of "unknown" records meeting specific criteria?

Can anyone suggest what the approach would be to accomplish an objective like this:

A non-administrator with limited technical skills needs to gather and update 40,000 bib records in Koha that can't be identified by any single unifying attributes.  My Millennium query might have looked like this:

*         Bib record not attached to order AND

*         (Location is Y or Location is X or Location is Z) and

*         Author is not TODD and

*         Note doesn't have FREE

*Millennium Create Lists allows you to create a Boolean Search, with up to about 20 statements, to query the entire database (various methods to search subsets or existing result sets also exist) and saves it to a file that can then be exported, or operated on (to apply global updates to fixed or variable fields, for instance).  No knowledge of SQL is needed.

Thanks in advance for any tips.  As an administrator, I could conceivably do this with SQL, but that's not feasible for cataloging staff.  We update large quantities of records all the time.


Tasha R. Bales