Hi to all, a library has asked us a develop about circolation in Koha. They want: -- Automatic check-in after an hold if the book is avaible and a mial to user with the message 'Go to pickup the book'. -- A mail to user is the book is on loan after an hold. -- Automatic renews (if there aren't holds), max 3. -- Check-out with a self-check out station -- When a book with an hold returns, automticaly the system does check-in and sends a mail to the user with the message 'Go to pickup the book'. In fact they want an automatic CIRC library, leand the books without a librarian. I see the RFCs about circulation, the Biblibre enhancements. I want to know the situation at SQL level To implement this develop I need a more robust table about holds, I probably need to add fields to table tmp_holdsqueue. Can you send to the list your plans (at SQL level) for CIRC and holds in particular ? There is any developer that is working on similar features ? Cheers Zeno Tajoli -- Dott. Zeno Tajoli tajoliAT_SPAM_no_prendiATcilea.it fax +39 02 2135520 CILEA - Consorzio Interuniversitario http://www.cilea.it/disclaimer
Le 07/07/2011 11:33, Zeno Tajoli a écrit :
Hi to all, Hi Zeno,
late answer, but better late than never ;-)
a library has asked us a develop about circolation in Koha. They want: -- Automatic check-in after an hold if the book is avaible and a mial to user with the message 'Go to pickup the book'. Doesn't it exist already in Koha ? -- A mail to user is the book is on loan after an hold. ??? I don't understand -- Automatic renews (if there aren't holds), max 3. This does not exist (and should just require a script, no DB change I think) -- Check-out with a self-check out station This already exists in Koha -- When a book with an hold returns, automticaly the system does check-in and sends a mail to the user with the message 'Go to pickup the book'. Same as #1 or there's something i've missed ? To implement this develop I need a more robust table about holds, I probably need to add fields to table tmp_holdsqueue.
Can you send to the list your plans (at SQL level) for CIRC and holds in particular ? There is any developer that is working on similar features ? at SQL level, we've (BibLibre) have added a reserves.reservenumber field (see bugzilla 5872). It's a Primary key for reserves, and it's a must-have (we should have have it for years !) other changes are related to issuingrules, with more columns for more granular hold rules.
ByWater has hourly loans underway, they may give some informations about DB changes I never worked with tmp_holdsqueue, so can't help you here. Do you have answers to your question ? -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08
Hi to all, Il 26/07/2011 17:57, Paul Poulain ha scritto:
late answer, but better late than never ;-)
a library has asked us a develop about circolation in Koha. They want: -- Automatic check-in after an hold if the book is avaible and a mial to user with the message 'Go to pickup the book'. Doesn't it exist already in Koha ?
in fact to explain the request I wrote ALL the request of the user, not only the develps to do.
-- A mail to user is the book is on loan after an hold. ??? I don't understand This the case to cover: An user puts an hold on a copy on loan. The hold is written a table and the user receives an e-mail with the text 'The book is on loan, Your hold is registered. You need to wait"
-- Automatic renews (if there aren't holds), max 3. This does not exist (and should just require a script, no DB change I think) Also I.
-- When a book with an hold returns, automticaly the system does check-in and sends a mail to the user with the message 'Go to pickup the book'. Same as #1 or there's something i've missed ? I didn't know that is option is avaible. I start to study how to setup it.
at SQL level, we've (BibLibre) have added a reserves.reservenumber field (see bugzilla 5872). It's a Primary key for reserves, and it's a must-have (we should have have it for years !)
This is the an important poit for me. It is the SQL develop that I need, for now. I try to sign-off bug 5872 as soo as I can.
Do you have answers to your question ? Yes, a complete answer
Bye Zeno Tajoli -- Dott. Zeno Tajoli tajoliAT_SPAM_no_prendiATcilea.it fax +39 02 2135520 CILEA - Consorzio Interuniversitario http://www.cilea.it/disclaimer
participants (2)
-
Paul Poulain -
Zeno Tajoli