- Koha - lists.katipo.co.nz

renewal rules and days not corresponding
by Daniel Owens 02 Dec '17

02 Dec '17

We are using Koha 3.22.04.000. We have renewal rules for all libraries and our branch set up to renew for 14 days. But upon renewal Koha adds 10 days. So I tried changing the renewal rule to 30 days, and upon renewal Koha added 34 days. Has anyone seen this kind of behavior before? Daniel

2 2

Export Patrons report has passwords encrypted
by Christopher Davis 01 Dec '17

01 Dec '17

Dear Colleagues, My library needs to regularly send to a vendor a list of our patrons' library card numbers and passwords/PINs so that they can authenticate patrons. The only way which I have found to do this is to use the "Export Patrons" report found at < https://wiki.koha-community.org/wiki/SQL_Reports_Library#Export_patrons>. Unfortunately, the passwords in the report are encrypted and are not given in cleartext. I am glad to see that Koha does not just give out passwords in cleartext, but is there a way to make this work? Thank you, Christopher Davis Systems & E-Services Librarian Uintah County Library cgdavis(a)uintah.utah.gov (435) 789-0091 <14357890091> ext.261 uintahlibrary.org basinlibraries.org facebook.com/uintahcountylibrary instagram.com/uintahcountylibrary

2 2

koha not sending email notices for Check in, Check out, Overdue etc.
by Javed Sahil 01 Dec '17

01 Dec '17

Hi everyone! I have set postfix with gmail to send Email Notices for Check In, Check Out, and every transaction made in Circulation Module, But in user accounts Notices tab Email status is pending. I want koha to send email notices immediately. But it is not sending emails. I have installed "mailutils" using command below: * # sudo apt-get install mailutils* Everything is ok, I can send emails using the command below: *# mail -s "This is the subject" javedshoukat900(a)gmail.com <javedshoukat900(a)gmail.com> <<< 'This is the message'* But notifications emails by koha are not sent, I have tried *# PERL5LIB="/usr/share/koha/lib"# KOHA_CONF="/etc/koha/sites/library/koha-conf.xml"# cd /usr/share/koha/bin/cronjobs* above commands go fine but when i try the following command, *# ./*process_message_queue.pl it returns unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. Can't call method "config" on unblessed reference at /usr/share/koha/lib/Koha/Database.pm line 56. *i tried rebuilding zebra* *# koha-rebuild-zebra -v -f library* Can't locate Authen/CAS/Client/Response/Failure.pm: ./Authen/CAS/Client/Response/Failure.pm: Permission denied at /usr/share/perl/5.22/base.pm line 97. ...propagated at /usr/share/perl/5.22/base.pm line 106. BEGIN failed--compilation aborted at /usr/share/perl5/Authen/CAS/Client/Response.pm line 68. Compilation failed in require at /usr/share/perl5/Authen/CAS/Client.pm line 8. BEGIN failed--compilation aborted at /usr/share/perl5/Authen/CAS/Client.pm line 8. Compilation failed in require at /usr/share/koha/lib/C4/Auth_with_cas.pm line 26. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth_with_cas.pm line 26. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 65. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 92. Compilation failed in require at /usr/share/koha/lib/Koha/Virtualshelf.pm line 22. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Virtualshelf.pm line 22. Compilation failed in require at /usr/share/koha/lib/Koha/Virtualshelves.pm line 24. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Virtualshelves.pm line 24. Compilation failed in require at /usr/share/koha/lib/Koha/Patron.pm line 37. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Patron.pm line 37. Compilation failed in require at /usr/share/koha/lib/Koha/Patrons.pm line 28. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Patrons.pm line 28. Compilation failed in require at /usr/share/koha/lib/Koha/Item.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Item.pm line 29. Compilation failed in require at /usr/share/koha/lib/Koha/Items.pm line 26. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Items.pm line 26. Compilation failed in require at /usr/share/koha/lib/C4/Items.pm line 43. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Items.pm line 43. Compilation failed in require at /usr/share/koha/lib/C4/Reserves.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Reserves.pm line 29. Compilation failed in require at /usr/share/koha/lib/C4/Circulation.pm line 28. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Circulation.pm line 28. Compilation failed in require at /usr/share/koha/lib/C4/Overdues.pm line 31. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Overdues.pm line 31. Compilation failed in require at /usr/share/koha/lib/C4/Members.pm line 30. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Members.pm line 30. Compilation failed in require at /usr/share/koha/lib/C4/Search.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Search.pm line 29. Compilation failed in require at /usr/share/koha/lib/C4/AuthoritiesMarc.pm line 24. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/AuthoritiesMarc.pm line 24. Compilation failed in require at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 26. BEGIN failed--compilation aborted at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 26. Something went wrong rebuilding biblio indexes for library Can't locate Authen/CAS/Client/Response/Failure.pm: ./Authen/CAS/Client/Response/Failure.pm: Permission denied at /usr/share/perl/5.22/base.pm line 97. ...propagated at /usr/share/perl/5.22/base.pm line 106. BEGIN failed--compilation aborted at /usr/share/perl5/Authen/CAS/Client/Response.pm line 68. Compilation failed in require at /usr/share/perl5/Authen/CAS/Client.pm line 8. BEGIN failed--compilation aborted at /usr/share/perl5/Authen/CAS/Client.pm line 8. Compilation failed in require at /usr/share/koha/lib/C4/Auth_with_cas.pm line 26. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth_with_cas.pm line 26. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 65. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 92. Compilation failed in require at /usr/share/koha/lib/Koha/Virtualshelf.pm line 22. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Virtualshelf.pm line 22. Compilation failed in require at /usr/share/koha/lib/Koha/Virtualshelves.pm line 24. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Virtualshelves.pm line 24. Compilation failed in require at /usr/share/koha/lib/Koha/Patron.pm line 37. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Patron.pm line 37. Compilation failed in require at /usr/share/koha/lib/Koha/Patrons.pm line 28. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Patrons.pm line 28. Compilation failed in require at /usr/share/koha/lib/Koha/Item.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Item.pm line 29. Compilation failed in require at /usr/share/koha/lib/Koha/Items.pm line 26. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Items.pm line 26. Compilation failed in require at /usr/share/koha/lib/C4/Items.pm line 43. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Items.pm line 43. Compilation failed in require at /usr/share/koha/lib/C4/Reserves.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Reserves.pm line 29. Compilation failed in require at /usr/share/koha/lib/C4/Circulation.pm line 28. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Circulation.pm line 28. Compilation failed in require at /usr/share/koha/lib/C4/Overdues.pm line 31. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Overdues.pm line 31. Compilation failed in require at /usr/share/koha/lib/C4/Members.pm line 30. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Members.pm line 30. Compilation failed in require at /usr/share/koha/lib/C4/Search.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Search.pm line 29. Compilation failed in require at /usr/share/koha/lib/C4/AuthoritiesMarc.pm line 24. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/AuthoritiesMarc.pm line 24. Compilation failed in require at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 26. BEGIN failed--compilation aborted at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 26. Something went wrong rebuilding authority indexes for library Help Plz I want koha to send emails immediately. -- Regards, Javed Shoukat Management Trainee Officer (MTO) Lahore University of Management Sciences (LUMS), Lahore. Contact #: +92 300 6548748 <+92%20300%206548748> Email: javedshoukat900(a)gmail.com

2 1

Koha Community Newsletter: November 2017
by kohanews 30 Nov '17

30 Nov '17

Fellow Koha users: The Koha Community Newsletter for November 2017 is here: https://koha-community.org/koha-community-newsletter-november-2017/ 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. Thanks! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Email message sending error in koha
by Javed Sahil 30 Nov '17

30 Nov '17

Hi everyone! I have set postfix with gmail to send Email Notices for Check In, Check Out, and every transaction made in Circulation Module, But in user accounts Notices tab Email status is pending. I want koha to send email notices immediately. But it is not sending emails. I have installed "mailutils" using command below: * # sudo apt-get install mailutils* Everything is ok, I can send emails using the command below: *# mail -s "This is the subject" javedshoukat900(a)gmail.com <javedshoukat900(a)gmail.com> <<< 'This is the message'* But notifications emails by koha are not sent, I have tried *# PERL5LIB="/usr/share/koha/lib"# KOHA_CONF="/etc/koha/sites/library/koha-conf.xml"# cd /usr/share/koha/bin/cronjobs# ./process_message_queue.pl <http://process_message_queue.pl>* it returns root@iolhost:/usr/share/koha/bin/cronjobs# ./process_message_queue.pl unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Templates.pm line 153. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Auth_with_cas.pm line 42. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 242. Can't call method "config" on unblessed reference at /usr/share/koha/lib/Koha/Database.pm line 56. *i tried rebuilding zebra* *# koha-rebuild-zebra -v -f library* Can't locate Authen/CAS/Client/Response/Failure.pm: ./Authen/CAS/Client/Response/Failure.pm: Permission denied at /usr/share/perl/5.22/base.pm line 97. ...propagated at /usr/share/perl/5.22/base.pm line 106. BEGIN failed--compilation aborted at /usr/share/perl5/Authen/CAS/Client/Response.pm line 68. Compilation failed in require at /usr/share/perl5/Authen/CAS/Client.pm line 8. BEGIN failed--compilation aborted at /usr/share/perl5/Authen/CAS/Client.pm line 8. Compilation failed in require at /usr/share/koha/lib/C4/Auth_with_cas.pm line 26. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth_with_cas.pm line 26. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 65. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 92. Compilation failed in require at /usr/share/koha/lib/Koha/Virtualshelf.pm line 22. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Virtualshelf.pm line 22. Compilation failed in require at /usr/share/koha/lib/Koha/Virtualshelves.pm line 24. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Virtualshelves.pm line 24. Compilation failed in require at /usr/share/koha/lib/Koha/Patron.pm line 37. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Patron.pm line 37. Compilation failed in require at /usr/share/koha/lib/Koha/Patrons.pm line 28. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Patrons.pm line 28. Compilation failed in require at /usr/share/koha/lib/Koha/Item.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Item.pm line 29. Compilation failed in require at /usr/share/koha/lib/Koha/Items.pm line 26. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Items.pm line 26. Compilation failed in require at /usr/share/koha/lib/C4/Items.pm line 43. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Items.pm line 43. Compilation failed in require at /usr/share/koha/lib/C4/Reserves.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Reserves.pm line 29. Compilation failed in require at /usr/share/koha/lib/C4/Circulation.pm line 28. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Circulation.pm line 28. Compilation failed in require at /usr/share/koha/lib/C4/Overdues.pm line 31. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Overdues.pm line 31. Compilation failed in require at /usr/share/koha/lib/C4/Members.pm line 30. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Members.pm line 30. Compilation failed in require at /usr/share/koha/lib/C4/Search.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Search.pm line 29. Compilation failed in require at /usr/share/koha/lib/C4/AuthoritiesMarc.pm line 24. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/AuthoritiesMarc.pm line 24. Compilation failed in require at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 26. BEGIN failed--compilation aborted at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 26. Something went wrong rebuilding biblio indexes for library Can't locate Authen/CAS/Client/Response/Failure.pm: ./Authen/CAS/Client/Response/Failure.pm: Permission denied at /usr/share/perl/5.22/base.pm line 97. ...propagated at /usr/share/perl/5.22/base.pm line 106. BEGIN failed--compilation aborted at /usr/share/perl5/Authen/CAS/Client/Response.pm line 68. Compilation failed in require at /usr/share/perl5/Authen/CAS/Client.pm line 8. BEGIN failed--compilation aborted at /usr/share/perl5/Authen/CAS/Client.pm line 8. Compilation failed in require at /usr/share/koha/lib/C4/Auth_with_cas.pm line 26. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth_with_cas.pm line 26. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 65. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 92. Compilation failed in require at /usr/share/koha/lib/Koha/Virtualshelf.pm line 22. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Virtualshelf.pm line 22. Compilation failed in require at /usr/share/koha/lib/Koha/Virtualshelves.pm line 24. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Virtualshelves.pm line 24. Compilation failed in require at /usr/share/koha/lib/Koha/Patron.pm line 37. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Patron.pm line 37. Compilation failed in require at /usr/share/koha/lib/Koha/Patrons.pm line 28. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Patrons.pm line 28. Compilation failed in require at /usr/share/koha/lib/Koha/Item.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Item.pm line 29. Compilation failed in require at /usr/share/koha/lib/Koha/Items.pm line 26. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Items.pm line 26. Compilation failed in require at /usr/share/koha/lib/C4/Items.pm line 43. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Items.pm line 43. Compilation failed in require at /usr/share/koha/lib/C4/Reserves.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Reserves.pm line 29. Compilation failed in require at /usr/share/koha/lib/C4/Circulation.pm line 28. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Circulation.pm line 28. Compilation failed in require at /usr/share/koha/lib/C4/Overdues.pm line 31. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Overdues.pm line 31. Compilation failed in require at /usr/share/koha/lib/C4/Members.pm line 30. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Members.pm line 30. Compilation failed in require at /usr/share/koha/lib/C4/Search.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Search.pm line 29. Compilation failed in require at /usr/share/koha/lib/C4/AuthoritiesMarc.pm line 24. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/AuthoritiesMarc.pm line 24. Compilation failed in require at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 26. BEGIN failed--compilation aborted at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 26. Something went wrong rebuilding authority indexes for library Help Plz I want koha to send emails immediately. -- Regards, Javed Shoukat Management Trainee Officer (MTO) Lahore University of Management Sciences (LUMS), Lahore. Contact #: +92 300 6548748 <+92%20300%206548748> Email: javedshoukat900(a)gmail.com

4 3

Sending Email to User
by Luis Moises Rojas 30 Nov '17

30 Nov '17

Hello everybody, the first time when we create a new user (patron) , we send an email using koha, but how do we send an email to inform the patron that has to return a borrowed book? Of course,when the date is over. Thanks -- *Luis Moisés Rojas P.* <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

2 2

Batch record modification
by Hugo Agud 30 Nov '17

30 Nov '17

Good morning, we have identified a strange behaviour in Batch record modification, the goal is to create a second 655 tag, but there is no way if there is already one 655 tag. the only option is add/update and if we use that, it always replace the entire field or it adds a 655$a to the already exist 654 _atest-654 655 _aTest-655 _942126 _atest-654 Perhaps we do not know how to add a new field if already exists one any idea? -- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* <http://www.orex.es/> [image: www.orex.es/koha] <http://www.orex.es/koha> [image: www.orex.es/vufind] <http://www.orex.es/vufind> Directo Calle Sant Joaquin,117, 2º-3ª · 08922 Santa Coloma de Gramanet - Tel: 933 856 138 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

2 2

koha-US Users Group: December Meeting Reminder and Call for Agenda Items
by koha-US Secretary 29 Nov '17

29 Nov '17

koha-US holds monthly online meetings every second Wednesday of the month via Zoom. Our next meeting will be Wednesday, December 13th, 2017 at 10:30 am CST (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+December+…> ). These meetings are open to any and all who wish to attend and are meant to be a platform for us to share and discuss Koha-related issues, ideas, and solutions. Meetings are also the place to have your voice heard with regards to the growth and development of koha-US as an organization. If you have topics for the agenda, please send them my way. Watch for links to the agenda and meeting space next week. For more information, don't hesitate to contact us <http://koha-us.net/index.php/Participants>! Jason Robb koha-US Secretary secretary(a)koha-us.org

1 0

Koha 17.11.00 released
by Jonathan Druart 29 Nov '17

29 Nov '17

Hello everybody, It is with great pleasure that the Koha community announces the release of Koha 17.11, a major release of the Koha open source integrated library system. Read the full release notes here: https://koha-community.org/koha-17-11-released/ The Debian packages for this new version will be available soon. Stay tuned! Cheers, Jonathan

6 5

Find unused (not linked) authority records
by Eric Phetteplace 28 Nov '17

28 Nov '17

Hi all, I'm wondering if anyone has a way to find authority records that aren't being used by any bib records currently. I can find *the opposite* in the reports library; ways to check if authors or subjects in biblios aren't connect to authorities. But I can't find a way to list authority records used in 0 biblios even though that's very clearly displayed in the authority search on the staff side. There's a search method which basically does exactly what I want: count_auth_use <https://github.com/Koha-Community/Koha/blob/master/Koha/SearchEngine/Elasti…> will, given an authority ID, return the number of bib records it's used in. So I just want records where count_auth_use = 0. Yet I can't find that exposed in a way I can use or think of an easy way to write a report that pulls them. As an aside: the purpose behind this is pruning authority records that don't have linked bibs so that they don't keep showing up in our "did you mean" search suggestions, because right now we have a lot of "did you mean" suggestions that just link to searches with zero results. Best, ERIC PHETTEPLACE Systems Librarian libraries.cca.edu | vault.cca.edu | 510.594.3660 5212 Broadway, Oakland, CA 94618 1111 8th St., San Francisco, CA 94107 Preferred Pronoun(s): he/him :(){ :|: & };:

3 3