- Koha-devel - lists.koha-community.org

Acquisition Reports - Orders Not Recieved
by RAGHAV ARORA 30 Jun '19

30 Jun '19

Hello everyone, The following link states that orders for books that have not been received is accessed by the aqorders for which datereceived is Null: Acquisition Reports - SQL Library <https://wiki.koha-community.org/wiki/SQL_Reports_Library#Acquisition_Reports> But this SQL query also makes use of the column biblio. Will record of an item exist in the biblio and biblioitems table before that item is received by the library? I understood that biblio and biblioitems are created after catalogging a book. Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

2 1

Koha Community Newsletter: June 2019
by kohanews 29 Jun '19

29 Jun '19

The Koha Community Newsletter for June 2019 is here: https://koha-community.org/koha-community-newsletter-june-2019/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Decision Support System for library.
by RAGHAV ARORA 28 Jun '19

28 Jun '19

Hello everyone, Does anyone know of good Decision-support software that can be used for decision making for library acquisitions based on Koha database? Or any framework/model I can refer to in the direction would be really helpful. Thanks in advance. Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761, 8474975691 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

1 0

Re: [Koha-devel] SQL Query to get the Waiting Holds From reserves table.
by Michael Hafen 28 Jun '19

28 Jun '19

It's a left outer join, which means we will get all the applicable rows from reserves but not necessarily from issues. If there isn't a matching row in issues then we get null values instead. The date_due column should never be null otherwise. So that query should show reserves with no issue. On Wed, Jun 26, 2019, 10:50 PM RAGHAV ARORA < f20171016(a)pilani.bits-pilani.ac.in> wrote: > Thank you for your reply Sir. > > Why are we querying for issues that have Null date_due? Should we not > query for the reserves corresponding to which no issues exist. > > When will the date_due be null? > > Regards, > *Raghav Arora* > Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering > Contact : (+91) 9897597761 > Personal Email <raghavarora999(a)yahoo.in> | University Email > <f20171016(a)pilani.bits-pilani.ac.in> > LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub > <https://github.com/RAraghavarora/> > > ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ > *Birla Institute of Technology and Science, Pilani* > Pilani campus, > Rajasthan-333031 > > > On Wed, Jun 26, 2019 at 10:44 PM Michael Hafen <michael.hafen(a)washk12.org> > wrote: > >> Here's me trying the query with more joins instead of sub-selects, though >> I can't guarantee it's exactly what you want. >> >> SELECT borrowers.surname, borrowers.email, borrowers.cardnumber, >> it1.barcode, biblio.title, reserves.reservedate >> FROM reserves >> LEFT JOIN borrowers USING (borrowernumber) >> LEFT JOIN biblio USING (biblionumber) >> LEFT JOIN items AS it1 USING (itemnumber) >> LEFT JOIN issues AS iss1 USING (itemnumber) >> LEFT JOIN items AS it2 ON (reserves.biblionumber = it2.biblionumber) >> LEFT JOIN issues AS iss2 ON(it2.itemnumber = iss2.itemnumber) >> WHERE iss1.date_due IS NULL AND iss2.date_due IS NULL >> >> >> On Wed, Jun 26, 2019 at 12:45 AM RAGHAV ARORA < >> f20171016(a)pilani.bits-pilani.ac.in> wrote: >> >>> Hello all, >>> >>> Could someone please help me in creating the SQL query to get all the >>> holds in the library for which the book is available,in the library (i.e, >>> no issue exists for that book) >>> >>> The reserves table contains some rows for which itemnumber is Null, and >>> the waitingdate is Null for every row even if no issue exists for the item. >>> >>> I came up with the following sql query, but I am not sure if I am right, >>> can someone please verify my query, or rectify it with the correct query: >>> >>> ```SELECT >>> borrowers.surname, borrowers.email, borrowers.cardnumber, >>> items.barcode, biblio.title, reserves.reservedate >>> FROM reserves >>> LEFT JOIN borrowers USING (borrowernumber) >>> LEFT JOIN items USING (itemnumber) >>> LEFT JOIN biblio ON (reserves.biblionumber = biblio.biblionumber) >>> WHERE >>> (reserves.itemnumber IS NOT NULL >>> AND NOT EXISTS(SELECT issue_id FROM issues WHERE >>> items.itemnumber = issues.itemnumber) >>> ) >>> OR >>> (reserves.itemnumber IS NULL >>> AND EXISTS( >>> SELECT itemnumber FROM items i2 WHERE >>> items.biblionumber=reserves.biblionumber >>> AND NOT EXISTS( >>> SELECT issue_id FROM issues WHERE >>> issues.itemnumber=i2.itemnumber >>> ) >>> ) >>> ) >>> ``` >>> >>> Thanks in advance >>> Regards >>> *Raghav Arora* >>> Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics >>> Engineering >>> Contact : (+91) 9897597761 >>> Personal Email <raghavarora999(a)yahoo.in> | University Email >>> <f20171016(a)pilani.bits-pilani.ac.in> >>> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub >>> <https://github.com/RAraghavarora/> >>> >>> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ >>> *Birla Institute of Technology and Science, Pilani* >>> Pilani campus, >>> Rajasthan-333031 >>> _______________________________________________ >>> Koha-devel mailing list >>> Koha-devel(a)lists.koha-community.org >>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >>> website : http://www.koha-community.org/ >>> git : http://git.koha-community.org/ >>> bugs : http://bugs.koha-community.org/ >> >> >> >> -- >> Michael Hafen >> Washington County School District Technology Department >> Systems Analyst >> >>

2 1

SQL Query to get the Waiting Holds From reserves table.
by RAGHAV ARORA 26 Jun '19

26 Jun '19

Hello all, Could someone please help me in creating the SQL query to get all the holds in the library for which the book is available,in the library (i.e, no issue exists for that book) The reserves table contains some rows for which itemnumber is Null, and the waitingdate is Null for every row even if no issue exists for the item. I came up with the following sql query, but I am not sure if I am right, can someone please verify my query, or rectify it with the correct query: ```SELECT borrowers.surname, borrowers.email, borrowers.cardnumber, items.barcode, biblio.title, reserves.reservedate FROM reserves LEFT JOIN borrowers USING (borrowernumber) LEFT JOIN items USING (itemnumber) LEFT JOIN biblio ON (reserves.biblionumber = biblio.biblionumber) WHERE (reserves.itemnumber IS NOT NULL AND NOT EXISTS(SELECT issue_id FROM issues WHERE items.itemnumber = issues.itemnumber) ) OR (reserves.itemnumber IS NULL AND EXISTS( SELECT itemnumber FROM items i2 WHERE items.biblionumber=reserves.biblionumber AND NOT EXISTS( SELECT issue_id FROM issues WHERE issues.itemnumber=i2.itemnumber ) ) ) ``` Thanks in advance Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

2 1

Development meeting reminder
by Renvoize, Martin 25 Jun '19

25 Jun '19

Hi all, Just a quick friendly reminder from your latest RM that we have a developer meeting scheduled for tomorrow: 26 June 2019, 19:00 UTC <https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+I…> . The agenda <https://wiki.koha-community.org/wiki/Development_IRC_meeting_26_June_2019#A…> is looking full and I hope it will prompt lots of constructive discussion and move a few important things forward. Looking forward to seeing many of you there.

1 0

Doubt in Koha Database Schema
by RAGHAV ARORA 24 Jun '19

24 Jun '19

Hello everyone, I am currently working on a project on Reports Management and Decision Support System for my institute library that uses Koha as it's ILS. I have a doubt in understanding what is the difference between the fields 'accountlines.amount' and 'accountlines.amountoutstanding'? Could someone help me out with this? Thanks in advance. Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

2 6

Integration Koha/Alma/Primo/Summon
by Leonor Fernandez Alfaro 20 Jun '19

20 Jun '19

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 integration Koha/Alma/Primo/Summon? At the same way, do you know any similar experience for a consortium loan with these systems (Koha/Alma/Primo/Summon)? We are very interesting in knowing a similar case. Thank you very much. Kind regards, UCA Leonor Fernández Alfaro Técnico de Gestión de Recursos de Información Sección de Normalización y Proceso Técnico Servicio Central de Biblioteca Universidad de Cádiz C/Dr. Marañón, 3 Cádiz.11002 Tel 956015273 - Ext. 1307 leonor.fernandez(a)uca.es [ mailto:leonor.fernandez@uca.es ] Aviso de Confidencialidad "Este mensaje, y cualquier fichero anexo al mismo, contienen información de carácter confidencial dirigida exclusivamente a su(s) destinatario(s) y, en su caso, sometida a secreto profesional. Queda prohibida su difusión, copia o distribución a terceros sin la previa autorización escrita. Si Vd. ha recibido este mensaje por error, se ruega lo comunique inmediatamente por esta misma vía y proceda a su eliminación". Confidentiality Warning "The information in this e-mail, and in any attachments, is confidential and, if any, protected by a professional privilege, and intended solely for the attention and use of the named addressee(s). You are hereby notified that any dissemination, copy or distribution of this information is prohibited without the prior written consent. If you have received this communication in error, please notify the sender by reply e-mail and delete it".

1 0

Updatedatabase and use module
by Fridolin SOMERS 20 Jun '19

20 Jun '19

Hi, Since bug 21073 in master, I get an error when upgrading from 18.11 : ... Upgrade to 18.12.00.066 done (Bug 8995 - Add new preferences for OpenURLResolvers) Upgrade to 18.12.00.067 done (Bug 8000 - Add new preferences for SendAllEmailsTo) Upgrade to 18.12.00.068 done (Bug 7088: Cannot renew items on hold even with override) DBD::mysql::st execute failed: Table 'koha.plugin_methods' doesn't exist [for Statement "SELECT `me`.`plugin_class` FROM `plugin_methods` `me` GROUP BY `me`.`plugin_class`"] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834. DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha.plugin_methods' doesn't exist at /home/koha/src/Koha/Plugins.pm line 89 Whasn't it forbiden to use DBIx in updatedatabase ? Best regards, -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - software and system maintainer

2 2

New Koha staff theme plugin
by Fridolin SOMERS 19 Jun '19

19 Jun '19

Hi I'm proud to give you a new Koha staff theme plugin : https://github.com/biblibre/koha-plugin-theme-intranet-lsd You should read the README ;) Have fun XD -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - software and system maintainer

2 1