- Koha - lists.katipo.co.nz

Help with a report query
by Carlos Lopez 24 Sep '19

24 Sep '19

Hi folks I have the following report query: ---- SELECT monthname(datetime) month, type, count(datetime) as count from statistics where YEAR(datetime) = YEAR(NOW()) and type in ('issue', 'renew') GROUP BY month, type ORDER BY month(datetime) ---- This works well but I've been asked to provide a mechanism to select the year to run this for (I would guess similar to the construct " DATE (b.dateexpiry) BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>", except selecting only years) Is it possible to do this? And if so, how? With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | library(a)dml.vic.edu.au | library.dmlibrary.org.au

3 2

Renewing on-site chekouts
by Hakulinen, Inkeri J 24 Sep '19

24 Sep '19

Hi, is it possible to have the option for patrons to renew the on-site chekouts they have? (And the staff to renew the patron's checkouts, of course.) Also, is it possible to define that the due date for on-site checkouts comes from the system automatically? Now we have to click it every time we have a patron / material that's for on-site checkout? When you click to have an on-site checkout, the system automatically suggests the end of the current day to be the due date. We wish it would be according to our circulation rules and calendar, usually 28 days period would be good. Is there a system preference(s) to help us with these problems? Best regards Inkeri Hakulinen Information Specialist The National Library of Finland P.O.Box 15 00014 University of Helsinki Tel. +358 2941 44627, +358 50 578 0461 inkeri.hakulinen(a)helsinki.fi<mailto:inkeri.hakulinen@helsinki.fi> www.kansalliskirjasto.fi<http://www.kansalliskirjasto.fi/> www.facebook.com/Kansalliskirjasto<http://www.facebook.com/Kansalliskirjasto> www.twitter.com/NatLibFi<http://www.twitter.com/NatLibFi> www.instagram.com/kansalliskirjasto<http://www.instagram.com/kansalliskirjasto> www.flickr.com/photos/natlibfi<https://www.flickr.com/photos/natlibfi/>

2 1

Auto increment/ Checkout & Checkin
by Arshad Iqbal 23 Sep '19

23 Sep '19

Hi to all I am facing problem in circulation, an item checking out first time and checking in , If I repeat this activity again, in repeating case auto increment DBMS error clicking, login koha database via PHPMYADMIN, clean 0 number from issue and old issue table. I have configured Auto increment from koha wiki, but error is still coming. How to cope with this error? -- Best Regards *Muhammad Arshad Iqbal* *Assistant Librarian* *NUST Central Library * *National University of Science and Technology (NUST)* *Sector H-12, Islamabad, Pakistan* *Tel. Office:051-90851087* *Cell no.+923444900809* * +923004900159*

3 2

Binding journals
by Carlos Lopez 22 Sep '19

22 Sep '19

Hi folks This might seem like a silly question, but how does Koha manage serials to be bound together? It creates an item record per serial issue on issue receipt, but once we send several issues to be bound into a volume do we have to delete those items manually? Or is there some Koha process that takes care of that? (and how does this work?) With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | library(a)dml.vic.edu.au | library.dmlibrary.org.au

2 1

Help restoring OPAC search box
by Sayward Schoonmaker 22 Sep '19

22 Sep '19

Hi All— thank you in advance for any help— I am new to Koha and using the software for a research project at Syracuse University. I’ve made an error that is way beyond my knowledge! I copied and pasted some code from ByWaterSolutions into the OpacCustomSearch field (which was empty) and in doing so I unintentionally erased the library branch pulldown menu from the main search page. Is there a way to return to the default search box which included a pull down menu for search by keyword, author, etc. and another pulldown for library branch? Or, is there code that I can add to the existing code to restore the library dropdown menu to the search box? Here is the code I used from ByWaterSolutions: <form name="searchform" method="get" action="http://syracuse.klassmates.us//cgi-bin/koha/opac-search.pl" id="searchform"> <input id="transl1" name="q" type="text"><p> <select name="idx" id="masthead_search"> <option value="kw">Keyword</option> <option value="ti">Title</option> <option value="au">Author</option> <option value="su">Subject</option> <option value="nb">ISBN</option> <option value="se">Series</option> <option value="callnum">Call Number</option> <input value="Search" id="searchsubmit" type="submit"> </p></form> Thank you so much. Sincerely, Sayward Schoonmaker, Research Assistant, Syracuse University -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 1

Use of indicators in field 245
by Giacomo Visini 22 Sep '19

22 Sep '19

Hi fellow Koha users, Just a quick question. Can someone shed a light on the use of the indicators in field 245? Since our conversion to Koha we stopped using them, but data from previous systems has these indicators filled in. Upon inspection, in most cases the given value is even wrong somehow (0's are 1's etc.). But it doesn't seem to affect indexation. So my question is, is there no need to fill in the indicators of field 245? Do you guys use them? For what purpose? For the sake of exhaustivity: we are currently using version 18.11.06.000 Thanks in advance for any replies. Kind regards, Giacomo Visini I Bibliotheekmedewerker DIVA, Antwerp Home of Diamonds Gildekamersstraat 9, B-2000 Antwerpen T + 32 3 360 52 42 giacomo.visini(a)divaantwerp.be<mailto:giacomo.visini@divaantwerp.be>

5 6

Restricting access to Koha by IP via Apache
by King, Fred 21 Sep '19

21 Sep '19

Greetings from the last day of the koha-US conference in Pueblo, Colorado! For reasons too boring to relate here, I'm trying to put our Koha system on a cloud server but restrict it to certain IP addresses. I've tried two ways: <DirectoryMatch "^/(.+)/"> Require ip 123.123.123.123 </DirectoryMatch> makes most of the information unavailable, but some of it is still coming through. The test site is 157.245.82.80, if anyone's interested. The other way I've tried is <Directory /foo/bar/> Require ip 123.123.123.123 </Directory> The second one works when I'm restricting access to /var/www/html, but I haven't figured out how to use that with Koha. So: Can anyone tell me how to do a DirectoryMatch statement that will restrict everything, including subdirectories? or Can anyone tell me which directory (or directories) Koha needs to start and lack of access will prevent it from running? I've broken multiple (test, fortunately) instances of Koha by accident, but now that I want it not to work, I'm stumped. (We're winding up, and I probably won't read my e-mail until Monday at the earliest.) Thanks, Fred King, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king(a)medstar.net<mailto:fred.king@medstar.net> 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org A library in the middle of a community is a cross between an emergency exit, a life-raft and a festival. They are cathedrals of the mind; hospitals of the soul; theme parks of the imagination. On a cold rainy island, they are the only sheltered public spaces where you are not a consumer, but a citizen instead. --Caitlin Moran ---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. Help conserve valuable resources - only print this email if necessary.

1 0

Deleting items without barcodes
by Tami Wilkerson 20 Sep '19

20 Sep '19

Hello, I have a list of items that I would like to batch delete but the items do not have barcodes. There is an option to batch delete using an item number file but I do not know how to extract the item numbers from Koha to make the file. Can anyone help? Thanks, Tami Tami Wilkerson, MLIS Library Program Lead/Librarian Columbia River Inter-Tribal Fish Commission Columbia Basin Fish & Wildlife Library<https://www.streamnetlibrary.org/> (formerly StreamNet Library) 700 NE Multnomah St. Suite 515 Portland, OR 97232 twilkerson(a)critfc.org<mailto:twilkerson@critfc.org> / 503.736.3581

2 2

ISBN matching for ebooks
by Joelle Hannert 20 Sep '19

20 Sep '19

Hello, I'm trying to refine my matching rules for importing staged records, and I'm having trouble setting up the right combination of match points to get matching in the way that I want. This is for loading ebook records, so if there is a matching print record I want to keep it *and* add the ebook record, but if there is a matching ebook record, I want to be able to either replace it or ignore the record so I don't have many duplicate ebook records from different vendors. Have any others found a solution for this? I want these types of scenarios to match: - Incoming 020a matches existing 020a - One of several incoming 020a match with existing 020a - Incoming 020a matches with one of several existing 020a - Incoming 020z match with existing 020z - Incoming 020z match with one of several existing 020z - One of several incoming 020z match with existing 020z - Incoming 020z match with existing 020z + text - Incoming 020z + text match with existing 020z And these types of scenarios to NOT match: - Incoming 020a match with existing 020z - Incoming 020z match with existing 020a Basically, if the ISBN and subfield of any 020 are the same, I want the system to find a match, regardless of how many other 020 fields are in the incoming/existing records. If the contents of 020 are the same but the SUBFIELDS ARE NOT (a vs. z), I don't want the system to find a match. I've tried all the combinations of record matching rules and match points I can think of, and I'm not able to get a rule combo that will even get close to what I'm hoping for (I would understand if the system can't handle matching on the numbers of the ISBN only, and ignoring extra text like "paperback.") Has anyone found a solution for loading ebook records from multiple vendors? I'd love to hear your workarounds, solutions, etc! I'm really feeling stuck here, and not wanting to add many duplicate ebook records to our catalog. -- Joelle Hannert Library Technical Services Coordinator Northwestern Michigan College (231) 995-1684 Work days: M, W, Th, F

3 3

Checkin error
by Arshad Iqbal 19 Sep '19

19 Sep '19

Hi to all. I am using koha 19.05 on Debian 9. When i try to checkin an item i am facing this error , Software error: DBIx::Class::Storage::DBI::_dbh_execute(): The user specified as a definer ('root'@'%') does not exist at /usr/share/koha/lib/Koha/Object.pm line 155 How to solve this problem? -- Best Regards *Muhammad Arshad Iqbal* *Assistant Librarian* *NUST Central Library * *National University of Science and Technology (NUST)* *Sector H-12, Islamabad, Pakistan* *Tel. Office:051-90851087* *Cell no.+923444900809* * +923004900159*

1 0