- Koha - lists.katipo.co.nz

Koha: Fine not displayed at checkout page
by Laxmi Lal Menaria 16 May '19

16 May '19

Hello, I have configured fine rules at "Circulation and fines rules" but when I doing checkout of books which was overdue, it doesn't show any overdue amount popup. Please let me know what I have missed in configuration. -- Thanks, Laxmilal Menaria | +91 982 955 3793 | https://cloud-computing.solutions/ <http://laxmilalmenaria.com/>

2 1

adjusting MARC field SQL query for indicator?
by Jason Vasche 15 May '19

15 May '19

Greetings everyone! I have another newbie SQL question. I want to run reports that return all bibs with MARC 100 0_ or 100 3_ fields. I found the "Bibs with a specific MARC field" in the reports library, but don't know how to modify it to include the specific indicator. Can anyone point me in the right direction? Thanks for your time and assistance! Regards, Jason Vasché Catalog Librarian Round Rock Public Library

2 1

Embedding search form with branch limit
by Karen Myers 15 May '19

15 May '19

Hi all Hoping someone may be able to help me with this - I've searched online but cant find a solution. I am embedding a search box in the website of of one of our member libraries using the code below, however I want to limit the search to that 1 member library's materials. What else to i need to add to ensure it just returns results from the 1 member library rather than all our libraries? <form name="searchform" method="get" action="http://159.65.65.143/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> </select> <input value="Search" id="searchsubmit" type="submit"> </p></form> Thanks in advance. Karen

2 1

Re: [Koha] Enabling https only using SSL
by TechOut Solutions 15 May '19

15 May '19

Thanks for your inputs and response! Could you please provide a sample virtualhost file by providing a working copy or by referring to the template available from https://github.com/Koha-Community/Koha/blob/master/debian/templates/apache-… ? On Sun, May 12, 2019 at 7:26 PM Coehoorn, Joel <jcoehoorn(a)york.edu> wrote: > You must change the *:80 at the top to *:443. You will also want to copy > the original virtualhost section, before adding the sslengine settings, and > change it to redirect to the https url. > > On Sun, May 12, 2019, 5:18 AM TechOut Solutions < > techoutsolutions00(a)gmail.com> wrote: > >> Hi Joel, >> >> I couldn't find the four entries of virtual hosts but I did the following >> by searching for similar problems but others are using letsencrypt >> certificates. >> >> # OPAC >> <VirtualHost *:80> >> Include /etc/koha/apache-shared.conf >> # Include /etc/koha/apache-shared-disable.conf >> Include /etc/koha/apache-shared-opac.conf >> >> ServerName ssb >> SetEnv KOHA_CONF "/etc/koha/sites/ssb/koha-conf.xml" >> SetEnv MEMCACHED_SERVERS "" >> SetEnv MEMCACHED_NAMESPACE "" >> AssignUserID ssb-koha ssb-koha >> >> ErrorLog /var/log/koha/ssb/opac-error.log >> # TransferLog /var/log/koha/ssb/opac-access.log >> # RewriteLog /var/log/koha/ssb/opac-rewrite.log >> SSLEngine on >> SSLProtocol +TLSv1.2 +TLSv1.1 +TLSv1 >> SSLCipherSuite >> "ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA" >> SSLHonorCipherOrder on >> SSLCompression off >> >> SSLCertificateFile /etc/apache2/ssl/apache.crt >> SSLCertificateKeyFile /etc/apache2/ssl/apache.key >> </VirtualHost> >> >> I couldn't make the https protocol to load the OPAC using the above >> configuration. Do I need to use the letsencrypt certificate for it to work? >> >> Thanks! >> >> On Sun, May 12, 2019 at 10:43 AM Coehoorn, Joel <jcoehoorn(a)york.edu> >> wrote: >> >>> I'm not at a place where I can check, but if you look at your Apache >>> site .conf file, there will likely be 4 virtual host entries: an http >>> and https option for both the opac and staff client. You can remove most >>> everything from inside the http entries and replace them with Redirect >>> directives which point to the correct https urls. >>> >>> On Sat, May 11, 2019, 11:41 PM TechOut Solutions < >>> techoutsolutions00(a)gmail.com> wrote: >>> >>>> Hi there, >>>> >>>> I am trying to setup Koha OPAC and Staff-Client using https protocol >>>> only >>>> using SSL and want to disable http access to Koha. I'd appreciate if I >>>> could get the sample apache virtualhost site configuration to achieve >>>> the >>>> result. Thank you. >>>> >>>> Regards, >>>> Nirvana >>>> _______________________________________________ >>>> Koha mailing list http://koha-community.org >>>> Koha(a)lists.katipo.co.nz >>>> https://lists.katipo.co.nz/mailman/listinfo/koha >>>> >>>

2 2

LiveDVD of Six Software Packages in 64 bits OS of Lubuntu 16.04.5
by mohan pradhan 15 May '19

15 May '19

Dear all, HealthNet Nepal has configured LIve DVD of six software packages for library use in 64 bits OS of Lubuntu 16.4.5 version. This 64 bits contains the following software ( https://sourceforge.net/projects/livedvdvufindkohadspace/) Koha ILS (18.05.08), DSpace (6.3), SubjectsPlus(4.2.2), Vufind(5.0), WordPress(5.0.4). It has also configuration of Exim mail server. Through API SubjectsPlus data can be used in WordPress. A plugin is also developed in WordPress for use of VuFind search engine in WordPress for searching database of Koha, VuFind and SubjectsPlus databases. The software can be used by library professionals without having in-depth knowledge of computer skill. For installation in the hard disk, either right click in the Install Release and tick mark in the "Execute in terminal Emulator" then click ok. Now click ok in Install Release and the prompt password: type "healthnet" or go to the terminal with the command ctrl_+alt+t and type "sudo sh -c 'ubiquity gtk_ui'we and the prompt password : type "healthnet". Help file is included along with the software. For Downloading the the software go to the url : https://sourceforge.net/projects/livedvdvufindkohadspace Prof. Mohan Raj Pradhan, Ph. D. Chairman HealthNet Nepal web: https://www.mpradhan.com.np email: pradhmohan@gmail.com/mpradhan@healthnet.org.np

1 0

Call for News: May 2019 Newsletter
by kohanews 15 May '19

15 May '19

Hello all! I'm collecting news for the May newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Koha 18.11.05, 18.05.12 and 17.11.18 release
by Renvoize, Martin 14 May '19

14 May '19

The Koha community is proud to announce the release of Koha versions 18.11.05, 18.05.12 and 17.11.18. These are combined security and maintenance releases and we recommend you update your systems at your earliest convenience. Debian packages have been uploaded and are available as of now, and detailed release notes for each respective version can be found below: 18.11.05 - https://koha-community.org/koha-18-11-05-release/ 18.05.12 - https://koha-community.org/koha-18-05-12-release/ 17.11.18 - https://koha-community.org/koha-17-11-18-release/ My apologies for the delay in this release, we felt it pertinent to try and avoid as many of the bank holidays as possible. Many thanks to all who have contributed to these releases, *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize(a)ptfs-europe.com *Fax:* +44 (0) 800 756 6384 www.ptfs-europe.com Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info(a)ptfs-europe.com

4 4

Re: [Koha] SQL Report - Authorities. List duplicate values based on 010$a
by Stefano Bargioni 14 May '19

14 May '19

Maybe a self join can help you. See https://www.w3schools.com/sql/sql_join_self.asp <https://www.w3schools.com/sql/sql_join_self.asp> However, your query could be very slow, since the match will not work on indexed data. If not sure, but try SELECT A.authid AS authid1, B.authid AS authid2, ExtractValue(A.marcxml,'/record/datafield[@tag="010"]/subfield[@code="a"]') AS dup FROM auth_header A, auth_header B WHERE A.authid <> B.authid AND ExtractValue(A.marcxml,'/record/datafield[@tag="010"]/subfield[@code="a"]') <> '' AND ExtractValue(A.marcxml,'/record/datafield[@tag="010"]/subfield[@code="a"]') = ExtractValue(B.marcxml,'/record/datafield[@tag="010"]/subfield[@code="a"]') ORDER BY A.authid; HTH. Stefano > Subject: [Koha] SQL Report - Authorities. List duplicate values based > on 010$a > Message-ID: > <CAP4tGF9Em5-4xiMHerf9B6sS+9ogzmh8_iMgKz-zJdtDJeBh6A(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hi all, > > Koha 18.11 on Ubunti 16.04 > > May I request help for an SQL report that does the following, please: > > Identify and list by authid and main heading all authority records that > have a tag 010$a with duplicate values? > > I am attempting to located all authority records that can be merged (or > de-duped via merge). > > Many thanks! > > Craig Butosi, MA, MLIS, B Mus (Hons) > Library: library.craigbutosi.ca > > > ------------------------------ > > Message: 2 > Date: Sun, 12 May 2019 01:49:55 +0530 > From: vijay kumar <vijcrjbhu(a)gmail.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] upgrade from koha-17.05.06 to koha-latest > Message-ID: > <CACNt1H6pKRZsRJiQQSeoevwDbuMYRwDmxCOiMBksweSfPUbGCg(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Dear all, > We have koha-17.05.06, installed using tarball method. > > I have followed the following methods for upgrading from koha-17.05.06 to > koha-latest > 1. Updated koha-list source accordingly koha-stable > 2. Update all perl dependencies and cpan module > > vijay@debian:/usr/share/koha-18.11.04$ perl Makefile.PL > /usr/share/koha-17.05.06/misc/koha-install-log > /usr/share/koha/misc/koha-install-log > > and also > > vijay@debian:/usr/share/koha-18.11.04$ sudo perl Makefile.PL > /usr/share/koha-17.05.06/misc/koha-install-log > /usr/share/koha-18.11.04/misc/koha-install-log > > vijay@debian:/usr/share/koha-18.11.04$ sudo make > > vijay@debian:/usr/share/koha-18.11.04$ sudo make upgrade > ------------------------------------------------------------------------------------ > > Getting the following error during upgrade > Kindly suggest the proper method for up-gradation of koha-latest > > With regards, > Vijay Kumar > > > ::::error:::: > > vijay@debian:/usr/share/koha-18.11.04$ sudo make upgrade > Can't locate C4/Installer/UpgradeBackup.pm in @INC (you may need to install > the C4::Installer::UpgradeBackup module) (@INC contains: /etc/perl > /usr/local/lib/x86_64-linux-gnu/perl/5.24.1 /usr/local/share/perl/5.24.1 > /usr/lib/x86_64-linux-gnu/perl5/5.24 /usr/share/perl5 > /usr/lib/x86_64-linux-gnu/perl/5.24 /usr/share/perl/5.24 > /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base). > BEGIN failed--compilation aborted. > Makefile:22908: recipe for target 'make_upgrade_backup' failed > make: *** [make_upgrade_backup] Error 2 > > > ------------------------------ > > Message: 3 > Date: Sun, 12 May 2019 08:27:33 +1200 > From: David Nind <david.nind(a)gmail.com> > To: Craig Butosi <cbutosi(a)gmail.com> > Cc: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] SQL Report - Authorities. List duplicate values > based on 010$a > Message-ID: > <CAK5OMPcJCLGVyOHFBubZ2-Et9-Tf-cTWyk+Ui21eYPXhxE-z6g(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hi Craig. > > I'm not that great at reports, but you might be able to find something in > the SQL reports library that could help: > https://wiki.koha-community.org/wiki/SQL_Reports_Library > > > David Nind | david.nind(a)gmail.com > PO Box 12367, Thorndon, Wellington, New Zealand 6144 > m. +64 21 0537 847 > > > On Sun, 12 May 2019 at 05:46, Craig Butosi <cbutosi(a)gmail.com> wrote: > >> Hi all, >> >> Koha 18.11 on Ubunti 16.04 >> >> May I request help for an SQL report that does the following, please: >> >> Identify and list by authid and main heading all authority records that >> have a tag 010$a with duplicate values? >> >> I am attempting to located all authority records that can be merged (or >> de-duped via merge). >> >> Many thanks! >> >> Craig Butosi, MA, MLIS, B Mus (Hons) >> Library: library.craigbutosi.ca >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > End of Koha Digest, Vol 163, Issue 12 > *************************************

2 1

koha for instrument
by martin007 14 May '19

14 May '19

Hi, I need help on Koha. I want to use it to carry out an inventory of laboratory equipment such as oscilloscopes, tools, voltage sources. I would appreciate any kind of information -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 1

Modifications in OPAC script not shown
by Camilo Freire 14 May '19

14 May '19

Salud: i'im triying to do some little modifications in the script that shows the MARC format of the record in Koha's OPAC (opac-MARCdetail.pl). I've found that any modification in the code is not shown inmmedialely on the screen, for example if I make print "Content-Type: text/html\n\n"; print "<html><body>something</body></html>"; exit; the message is not shown at all. Only if I change the name of the script and run it works, but again the new script seems to remain "frozen" in this initial step and doesn't show any further modification. I suppose that the problem is based in the existence of some cache anywhere, I would like to know how to avoid this behaviour in order to see in real time the effect of the modifications I'm doing. Thank you very much Camilo Freire Uruguay

2 1