Re: [Koha-devel] Doubt in Koha Database Schema

Ok sir, thanks for the clarification. One last thing, if I need to see the total fine of a patron, I will take sum of all the amountoutstanding for that borrowernumber, right? At some place I found someone to be taking sum of only the positive amountoutstanding, and ignoring the negative amountout

Re: [Koha-devel] Doubt in Koha Database Schema

So that you know what the original amount of the fine is/was. This is especially useful in an ongoing overdue fine, for example. The patron may have some, but still has the book. So the script can look at what the fine is supposed to be, and what it was last time the script ran (the amount colum

[Koha-devel] Integration Koha/Alma/Primo/Summon

Dear colleagues, we are writting from University of Cadiz Library. Our library belongs to the Andalusia Consortium and the ILS used by all its libraries is Alma/Primo VE (ExLibris). We are trying to integrate our Koha catalog in the union catalogue. Do you know any similar experience of an i

Re: [Koha-devel] Updatedatabase and use module

I've created a bug for this: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23168 *Martin Renvoize* Development Team Manager *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvo...@ptfs-europe.com *Fax:* +44 (0) 800 75

Re: [Koha-devel] Updatedatabase and use module

Yikes, This is a fun 'chicken before the egg' problem. I'll take a look this afternoon. *Martin Renvoize* Development Team Manager *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvo...@ptfs-europe.com *Fax:* +44 (0) 800 756 6

Re: [Koha-devel] Doubt in Koha Database Schema

Thank you sir, Can you please help me understand these tables? What is the purpose of the 2 tables 'accountlines' and 'account_offsets'? account_offsets is a child of accountlines, which allows 1 accountlines row to have multiple account_offsets, and the 'account_offsets.amount' is the total amou