[Koha] Request to get listed on Koha support providers list

2019-08-30 Thread Lari Taskula
Dear Koha community, Hypernova Oy would like to sign up to get listed on Koha support providers list. We are offering Koha hosting, development and consultation services. Our team currently consists of Finnish Koha professionals whom worked for public libraries in Finland and later founded a

Re: [Koha] Can't include itype in report (was Bulk search/delete by ISBNs?)

2019-08-30 Thread Coehoorn, Joel
I haven't seen the SQL, but you might be able to change an INNER JOIN somewhere into a LEFT JOIN and get the results you need. Joel Coehoorn Director of Information Technology 402.363.5603 *jcoeho...@york.edu * *Please contact helpd...@york.edu for technical assistance.* The mission of York

[Koha] Can't include itype in report (was Bulk search/delete by ISBNs?)

2019-08-30 Thread King, Fred
Thanks to Chris and a script from George Williams, it worked like a charm. Almost. With a few of them. After a lot of trial and error, I think I might have found the problem: my SQL queries can’t find the item type EBOOK, or any data associated with bib records of that type. Since there aren’t

Re: [Koha] Wordpress "Search this site/Search our catalog" code

2019-08-30 Thread Caroline Cyr-La-Rose
This is what we have. It's a simple bit of html that is used on the page where you want the search box to be. You have to change opacbaseurl for your own. Let me know if it works :) action="https://opacbaseurl/cgi-bin/koha/opac-search.pl; id="searchform">             Keyword   

Re: [Koha] Wordpress "Search this site/Search our catalog" code

2019-08-30 Thread Owen Leonard
> Does anyone have any code for creating a single search box on a Word > Press site that can switch between "Search our website" and "Search our > catalog?" This is what we have in our modified Wordpress template (https://www.myacpl.org/): https://gitlab.com/snippets/1890638 The

[Koha] Top 10 Circulating Books

2019-08-30 Thread Ma. Victoria H. Silva-Manuel
HI. I got the SQL report below to generate the top 10 circulating books from koha-community. SELECT count(s.datetime) AS circs, b.title, b.author, i.ccode FROM statistics sJOIN items i ON (i.itemnumber=s.itemnumber) LEFT JOIN biblio b ON (b.biblionumber=i.biblionumber) WHERE