- Koha - lists.katipo.co.nz

Unwanted e-mail about UseTransportCostMatrix
by Michael Kuhn 26 Jun '19

26 Jun '19

Hi Since two days I am receiving the following unwanted e-mail from my demo installation (running Koha 19.05.00) every hour: ################################## Subject: Cron <root@vmi47659> cd / && run-parts --report /etc/cron.hourly /etc/cron.hourly/koha-common: UseTransportCostMatrix set to yes, but matrix not populated at /usr/share/koha/lib/C4/HoldsQueue.pm line 193. ################################## But in fact system preference "UseTransportCostMatrix" is NOT set to yes: mysql> select value from systempreferences where variable="UseTransportCostMatrix"; +-------+ | value | +-------+ | 0 | +-------+ 1 row in set (0.00 sec) What does it mean and how can I prevent getting this unwanted e-mail? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 2

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

1 0

Need advice regarding removal of deleted biblio records
by Andy Boze 26 Jun '19

26 Jun '19

Dear all, I'm hoping someone can give me a bit of direction. We have a large number of deleted biblio records (due to a failed MARC records import). We'd like to remove the deleted records from the database as there are somewhat more deleted records (401,000) than active records. Is there a script than can clean up deleted records? I've seen this "Clean up database" script < https://koha-community.org/manual/18.11/en/html/cron_jobs.html#clean-up-dat… >, but it's not what we're looking for. If there's no script, can we safely use the MySQL TRUNCATE command on the deletedbiblio, deletedbiblio_metadata, deletedbiblioitems and deleteditems tables? This is a non-circulating library, so I don't think the biblionumber would be tied to any other tables. I'll appreciate any guidance. We're using Koha 18.11 and MariaDB 5.5.60. -- Andy Boze, Associate Librarian University of Notre Dame 271H Hesburgh Library (574) 631-8708

4 5

Education meeting
by Caroline Cyr-La-Rose 25 Jun '19

25 Jun '19

Hello everyone! Just a quick reminder that the community education meeting is taking place THIS Thursday, June 27, at 14 UTC. ByWater Solutions offered their Zoom room so that we can all meet. Click on this link to access it: https://zoom.us/j/545232903 You can try it in advance to make sure it works for you. Here is the agenda again. And again, I invite you to email me or the list if you want to add points to it. :) 1. Presentation 2. Collaboration for training, propositions * Wiki? * Mailing list? * other means? * Are there things that we can share? Or things we should develop as a community? 3. Best practices * If anyone wants to share one thing that they do that works wonderfully, go ahead :) See you then! Caroline -- Caroline Cyr La Rose, M.L.I.S. Librarian | Product Manager Phone: 1-833-465-4276, ext. 221 Caroline.Cyr-La-Rose(a)inLibro.com <mailto:caroline.cyr-la-rose@inLibro.com> INLiBRO | Document Technologies Specialists | www.inLibro.com <http://www.inLibro.com>

1 0

Re: [Koha] Koha Ldap Auth
by Daniele Piccoli 24 Jun '19

24 Jun '19

Il 24/06/19 11:45, Katrin Fischer ha scritto: > Hi Daniele, Hi Katrin, > I think this line might be the problem: > > <mapping>record field names --> > > You are missing the closing tag. I am not sure if a mapping is required > or if this could be removed, but it's invalid XML. Mapping tags were closed, like these: <mapping>  <userid is="uid"></userid> <password is="userpassword"></password> <email is="mail"></email> </mapping> By the way, I've just tried to remove them, but the result is the same. > Hope this helps, > > Katrin > Thanks Daniele

1 0

BATCH ITEM MODIFICATION BARCODES NOT FOUND
by muirunyeri 23 Jun '19

23 Jun '19

I updated the barcodes field directly from the koha_library items table in mysql successfully. From the browser searching the barcodes from the catalogue is successful but the batch item modification gives the barcodes not found result. Barcodes edited thruogh the browser are however found using the batch modification. How do I resolve this? Someone please help

1 0

How to add more text fields in the patron card creator tool
by Larisa Snabi 22 Jun '19

22 Jun '19

Hello everyone, I would like to know if we can add more text fields in the patron card creator tool under the layout options. Thank you Snabi

2 1

BATCH ITEM MODIFICATION TOOL BARCODES NOT FOUND
by muiru james 22 Jun '19

22 Jun '19

Hi, I am using Koha Version 17.11.05.000 and Zebra Zebra 2.0.59. I edited the Koha backend Maria DB table items and updated the Barcodes field for about 3000 barcodes. The update was successful and searching the barcodes using the browser the books are updated. Reports are also running well nad populating the barcodes column with the new. However, when using the Batch Item Modification the barcodes not found result is returned. Searching them one by one shows they are there. How do I resolve the Batch Item Modification barcodes not found result? Please assist Regards

1 0

Out Of Office until 07/03/19
by sheralynb 22 Jun '19

22 Jun '19

I appreciate your message. I am out of the office until 7 July 2019. If this is an emergency please contact sheilag(a)latahlibrary.org Thank you! Sheralyn Bassett Technical Services Assistant Latah County Library District

1 0

Koha backup vs -SQL backup
by Yatheesh lis 20 Jun '19

20 Jun '19

Hi 1) what is deferencece B/w Koha backup vs -SQL backup. 2) I have taken backup through koha and imported other system but it shows only biblio records with out any item details why? 3) to import -SQL backup should I know database name?

3 2