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

2021-01-21 Thread Ian Bays
Hi Tasha (and Eric) I see Eric has responded and I just wanted to encourage you to persevere as I think the facilities are there in Koha and with the selection using SQL your selection can be very precise. I wanted to draft up some (fixed) SQL that pretty much does what you ask (which was wh

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

2021-01-21 Thread Eric Phetteplace
There's an additional step which ferries the data from a report into the batch modification tool (Tools > Batch item/record modification). For bibs or authorities, you need to create a MARC modification template des

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

2021-01-21 Thread Bales (US), Tasha R
I really appreciate your reply Eric, thank you. I will check out your link. Alas, this is also a bit of a disaster. I see my workload increasing. ☺ If staff will be using SQL, I have reservations about unintentional changes or deletions. Once a Report is created, are you just using SQL to c

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

2021-01-21 Thread Eric Phetteplace
Hi Tasha, We were also a former Millennium library that migrated to Koha, though it's been a while (migrated in 2016). Reports are essentially Millennium's "Lists" but they require more skill to create. So your example would need to be a SQL Report filtering according to the properties you've laid

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

2021-01-21 Thread 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

[Koha] Logical schema about holds

2021-01-21 Thread BOUIS Sonia
Hello, Is there somewhere, someone (a really wonderful person) who had the idea to do a logical schema of how the holds work in Koha, with all the options possible and especially with a multi branches Koha where not all the branches chose to allow reserves. Yes, sometimes, I still believe in San