- Koha - lists.katipo.co.nz

Storage of Perl Scripts [Was: Orphaned Authority Records: Finding Them and Deleting Them]
by Charles Kelley 06 Aug '20

06 Aug '20

Hello, all! In a recent exchange, on 5 Aug. 2020, at 12:54 AM, I received the following response to my earlier inquiry about orphaned authority records: Did you try the script misc/migration_tools/remove_unused_authorities.pl? > I have looked for this on our Linux box, but I cannot find it. In fact, I cannot find any Perl script. Where are they kept? The Koha-Community.org website has not been helpful to me in this regard. Thank you for your help in this matter. P. S. We are running Koha 20.05 on Debian 10.4 ("Stretch"). -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

2 4

koha-US August 2020 Meetings & Events
by Jason Robb 04 Aug '20

04 Aug '20

koha-US online meetings and events are free and open to all. Please note that *all Zoom links have been updated* to include an embedded passcode. Should you be asked for a passcode to join a koha-US Zoom meeting, it will always be 111581. See our calendar for a full list of events with links: http://koha-us.org/calendar/ *Meetings* Board Meeting - Thursday, August 6th @ 10:00a PT / 1:00p ET / 5:00p UTC - Meeting Link - https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 - Agenda - https://docs.google.com/document/d/1QUxr8s4ZYJEQUyWAO8ggMtKVbS3SDiNSVHV-Bw2… General Meeting - Wednesday, August 12th @ 8:30a PT / 11:30a ET / 3:30p UTC *Special Interest Groups* Cataloging - Thursday, August 6th @ 8:00a PT / 11:00a ET / 3:00p UTC System Administration - Tuesday, August 11th @ 9:00a PT / 12:00p ET / 4:00p UTC Web Development - Thursday, August 13th @ 8:00a PT / 11:00a ET / 3:00p UTC User Services - Monday, August 17th @ 12:00p PT / 3:00p ET / 7:00p UTC Acquisitions - Tuesday, August 18th @ 9:00a PT / 12:00p ET / 4:00p UTC Consortia - Monday, August 24th @ 9:00a PT / 12:00p ET / 4:00p UTC Special interest groups are open to all, and strive to encourage discussion on specific modules and areas of Koha. Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topics that interest you! Jason Robb koha-US Secretary secretary(a)koha-us.org

1 0

Fetching images from Google image
by Vincent Van Gogh 04 Aug '20

04 Aug '20

Fetching images from Google image

1 0

Orphaned Authority Records: Finding Them and Deleting Them
by Charles Kelley 04 Aug '20

04 Aug '20

Hello, all! I have been trying to detect, isolate, and delete orphaned authority headings, i.e., authority records to which no record is attached. I tried adapting the duplicate authority record report from the SQL Reports Library. I thought changing this one line would do the trick, but alas, it did not. HAVING count(authid) > 1 > I changed it to HAVING count(authid) < 1 > HAVING count(authid) = 1 > HAVING authid IS NULL OR authid = '' Alas, an empty report. Is there something I can do to find and then delete the orphaned authority records? Many of these orphaned authority records are duplicates that I am painstakingly merging two at a time. If I could get some help in speeding up the merge and deletion because going through the records two at a time is terribly inefficient. Many thanks for your help. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

2 2

dual cover images suport
by Alvaro Cornejo 03 Aug '20

03 Aug '20

Hi We have seen that the cover images we have been loading into koha, in png format, are quite big (some over 1Mb) so we are checking a way to optimise their size. One option is to replace those png files with one with a lower resolution/size keeping the same png format and/or move to jpeg. Another option would be to convert them to a better image format like webp. The issue here is that that webp is not supported by some browsers. Therefore, we need to have two cover image versions. In this last case, we will either need to add a second image column in mysql for the optimized version or store them somewhere in the network. In addition to that, we will need to modify opac-image.pl or create another get-webp-cover.pl script in order to have something like: <picture> <source type="image/webp" srcset="/get-webp-cover.pl?biblionumber=243233"> <img style="-webkit-user-select: none;margin: auto;cursor: zoom-in;" src=" https://biblioteca.celacp.org/cgi-bin/koha/opac-image.pl?biblionumber=243233" width="445" height="695"> </picture> Instead of just <img style="-webkit-user-select: none;margin: auto;cursor: zoom-in;" src=" https://biblioteca.celacp.org/cgi-bin/koha/opac-image.pl?biblionumber=243233" width="445" height="695"> And /get-webp-cover.pl will return <img style="-webkit-user-select: none;margin: auto;cursor: zoom-in;" src="/image/ 243233.webp" width="445" height="695"> Will adding an additional column to mysql break future koha upgrades? opac-image.pl modifications for sure will be overwritten in future uogrades, so we will need to keep track of changes and reapply them after each upgrade. Any thoughts on the best way to go? Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire

2 2

Pick up Time and Date to Staff/patron
by JITHIN N 03 Aug '20

03 Aug '20

Dear Koha community Is there any options are there to give pick up date and time by patron to staff or vice versa at the time/after hold the book. Jithin N Librarian CRC Kozhikode Kerala

1 0

Linking fields 770 and 772
by cruciani＠uns.edu.ar 03 Aug '20

03 Aug '20

Hi. I am working with serials, trying to link a parent record to a supplement record using 770 and 772 fields and it seems not to be working. In spite of using 772 0# in the supplement record and 770 0# in the parent one (using $w for linking records) no linking note appears to be displaying and no relation seems to be establishing. I´m using Koha version 19.11. I ´d greatly appreciate your feedback on this. Regards, Paola V. Cruciani

3 4

Problem in koha regional (Kannada) language search
by Shiva Kumara 03 Aug '20

03 Aug '20

Dear koha community members, I have installed koha (version - 19.11.08.000) on ubuntu (version -18.04). its working fine except regional (Kannada) language search. 1. There is no GoogleIndicTransliteration drop down menu in opac search bar, eventhough parameter has been turned on in staff client "Global system preferences > OPAC > GoogleIndicTransliteration > Show" 2. When we performed search in opac for regional (Kannada) language, then results will display entire (all) records entered in koha. There is no definite order ranking in results display. Kindly guide me to solve this issues as soon as possible. Thanking you -- ***With Regards*** Shivakumara RM Digital Library Analyst Institute for Social and Economic Change Dr. VKRV Rao Road, Nagarabhavi, Bangalore - 560 072 <https://sites.google.com/site/shivakumararm/>

3 2

UPDATE: SQL edit for Non-circulating items report
by David Sale 01 Aug '20

01 Aug '20

ATTN: Please remove earlier message from listserv. Further inquiry has shown that the system permissions for our local installation of Koha do not allow this user to SELECT from the biblioitems table. David Sale Coastline Library System Coos/Curry County, Oregon From: David Sale Sent: Friday, July 31, 2020 12:12 PM To: koha(a)lists.katipo.co.nz Subject: SQL edit for Non-circulating items report Hello, Our library is engaged in a weeding project that requires a SQL report for Koha to be customized. The report we are attempting to customize was written by ByWater Solutions, and it generates a list of items "not seen" in X years, by branch and shelf location. The existing report is written in SQL as follows: SELECT i.itemcallnumber, b.biblionumber, b.title, b.author, b.copyrightdate, i.barcode, i.datelastseen, i.issues AS totalcheckouts, i.dateaccessioned FROM items i LEFT JOIN issues USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE homebranch = <<Home Library|branches>> AND location = <<Shelving location|LOC>> AND i.withdrawn=0 AND i.itemlost=0 AND i.damaged=0 AND i.itemnumber NOT IN (SELECT issues.itemnumber FROM issues) AND YEAR(NOW())-YEAR(i.datelastseen) > <<Years NOT seen>> ORDER BY i.itemcallnumber ASC We would like to modify this report so that in addition to returning the author, title and copyright date, it also returns the ISBN. However, adding "b.isbn" to the SELECT list (as with "b.title", "b.author", etc.) breaks the report and renders it non-functional. Can anyone suggest how the SQL given above should be modified to create a functional report that will generate a list of items "not seen" in X years, by branch and shelf location, and that will return the ISBN *in addition to* the title, author, copyright date and barcode for each item listed in the report? Thanks, David Sale Coastline Library Network Coos/Curry Counties, Oregon

1 0

Koha Community Newsletter: July 2020
by Koha Newsletter 31 Jul '20

31 Jul '20

The Koha Community Newsletter for July 2020 is here: https://koha-community.org/koha-community-newsletter-july-2020/ 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