- Koha - lists.katipo.co.nz

Limiting OPAC Searches to Library Holdings Only
by Mutsikiwa Admire 07 Mar '19

07 Mar '19

We have recently configured our Koha. We would like to limit our OPAC searches to Library holdings only without searching on the Internet. Kindly assist. Kind Regards, Admire Mutsikiwa ICT Projects Manager Libraries University of Zimbabwe <Tel:+263-4-303276> Tel:+263-4-303276 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp, 1880-1941, former director of the Bank of England

2 1

Serial numbering pattern for MMM dd, YYYY possible?
by Indranil Das Gupta 07 Mar '19

07 Mar '19

Hi serials control gurus, I'm trying to enter the subscription for a magazine - India Today. It is (1/week), published on every Monday. The issues are numbered as "MMM dd, YYYY" I'm trying to generate a numbering pattern for it and is failing miserably.. Is such a numbering even possible within the current serials framework of Koha? thanks in advance Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 WWW : http://www.l2c2.co.in Blog : http://blog.l2c2.co.in IRC : indradg on irc://irc.freenode.net Twitter : indradg

2 3

Re: [Koha] how to run reports for for a subject specialization.
by Hawwau Moruf 07 Mar '19

07 Mar '19

Hi there, I work with an academic library, each time we try running reports for accreditation purpose we don't get holistic reports on for a particular course/ discipline. Seeking for a way out of this mess. Thanks. On Thu, Mar 7, 2019, 12:00 AM <koha-request(a)lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. MARC Bibliographic Test error (Tanzeem M.B) > 2. Re: How to receive reports to email (SATISH) > 3. Re: MARC Bibliographic Test error (Tomas Cohen Arazi) > 4. Adding randomly generated password to member entry form using > intranetuserjs > (Perks, Emma (UNIVERSITY HOSPITALS BIRMINGHAM NHS FOUNDATION TRUST)) > 5. Koha 10.05.10 released. Critical bug fix. (Jesse Maseto) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 6 Mar 2019 13:39:19 +0530 > From: "Tanzeem M.B" <tanzeem.mb(a)gmail.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] MARC Bibliographic Test error > Message-ID: > <CAFdG+--x7k= > AatAfc4AmYPeGk3Tza2rxyPf2OEBSf5KsaHQWGw(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Dear folks, > > Please see the attached document for the detailed specification of > errors to be fixed. Please advice how to proceed and fix the problem. > > With Thanks & Regards > > Mr. Tanzeem M B > +91 9446705956 > > Thiruvananthapuram > > > ------------------------------ > > Message: 2 > Date: Wed, 6 Mar 2019 17:23:12 +0530 > From: SATISH <lis4satish(a)gmail.com> > To: Alvaro Cornejo <cornejo.alvaro(a)gmail.com> > Cc: Koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] How to receive reports to email > Message-ID: > < > CAJkM6UEvgbVYTUdojxxeEFVN7XFgDwXvxfUCPJR33Chizm2v9A(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Thank you Paul, Barton, Alvaro > > Still I am not able to run the said scripts. I am getting same permission > problem. > I tried to keep related files in /root directory and also in > /usr/share/koha/bin directory > same permission problem occurs. So, I did not understand it completely. > I need some more guidance to get desired results. > > However, I also tried with other suggestions given in the mail, > since runreports.pl is already defined in koha, > > I directly edited the file -- koha-common (etc/cron.d) > added following line, > > 45 17 * * * * root koha-foreach --enabled --email > /usr/share/koha/bin/cronjobs/runreport.pl report-id --format=html > --to=email id > I am successful. > > But, for multiple reports, I am not successful. > 45 17 * * * * root koha-foreach --enabled --email > /usr/share/koha/bin/cronjobs/runreport.pl report-id1 report-id2 report-id3 > --format=html --to=email id > > > Checkout report - is taken from SQL library, developed by Sarah Cornel > List of items issued on a date with optional limit by due date > < > https://wiki.koha-community.org/wiki/SQL_Reports_Library#List_of_items_issu… > > > with little modification in the last line, manual entry of 'issue date' > to 'current date' to chose date on which report is run. > > SQL > ------------------------------ > SELECT > issuedate, date_due, items.barcode, items.itemcallnumber, biblio.title, > biblio.author, CONCAT(borrowers.firstname, ' ',borrowers.surname) AS > 'patron', > borrowers.cardnumber, CONCAT(borrowers.borrowernumber) AS borrowernumber > FROM issues > LEFT JOIN items ON issues.itemnumber = items.itemnumber > LEFT JOIN biblio ON items.biblionumber = biblio.biblionumber > LEFT JOIN borrowers ON issues.borrowernumber = borrowers.borrowernumber > WHERE DATE(issuedate) = CURDATE() > ------------------------------- > > Since I missed to CC koha forum, I am copying imp mails from Paul received. > -- > The twiddle character (~) in the koha-shell command is being interpreted > as root's home directory (/root), not as the regular user's home > directory (/home/helm-gechlibrary or whatever). The regular user can't > see inside /root, hence the permission error. > > Try this: > > # koha-shell gechlibrary -c '/home/helm-gechlibrary/bin/run-reports.pl > /home/helm-gechlibrary/reports/checkout-report.txt' > > Or, equivalently: > > # koha-shell gechlibrary -c '~helm-gechlibrary/bin/run-reports.pl > ~helm-gechlibrary/reports/checkout-report.txt' > > This should also work: > > # koha-shell gechlibrary --login -c 'bin/run-reports.pl > reports/checkout-report.txt' > > That's because the command -- i.e., the COMMAND in _koha-shell INSTANCE > --login -c COMMAND_ -- is executed by a process whose current working > directory is /home/helm-gechlibrary. > Good luck! Paul. > --- > > > ------------------------------ > > Message: 3 > Date: Wed, 6 Mar 2019 09:07:49 -0300 > From: Tomas Cohen Arazi <tomascohen(a)gmail.com> > To: "Tanzeem M.B" <tanzeem.mb(a)gmail.com> > Cc: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] MARC Bibliographic Test error > Message-ID: > <CABZfb= > UiOT02mUDbK10L3-nxeweyOAdhV-kmFn1Pr7wzF3Wt2A(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Your email doesn't have an attachment. > > El mié., 6 mar. 2019 a las 5:10, Tanzeem M.B (<tanzeem.mb(a)gmail.com>) > escribió: > > > Dear folks, > > > > Please see the attached document for the detailed specification of > > errors to be fixed. Please advice how to proceed and fix the problem. > > > > With Thanks & Regards > > > > Mr. Tanzeem M B > > +91 9446705956 > > > > Thiruvananthapuram > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > -- > Tomás Cohen Arazi > Theke Solutions (http://theke.io) > ✆ +54 9351 3513384 > GPG: B2F3C15F > > > ------------------------------ > > Message: 4 > Date: Wed, 6 Mar 2019 12:09:23 +0000 > From: "Perks, Emma (UNIVERSITY HOSPITALS BIRMINGHAM NHS FOUNDATION > TRUST)" <emma.perks(a)nhs.net> > To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: [Koha] Adding randomly generated password to member entry > form using intranetuserjs > Message-ID: <1551874150915.44884(a)nhs.net> > Content-Type: text/plain; charset="iso-8859-1" > > Hello, > > > > I work on behalf of the Base Library Consortium, a group of health > libraries in the UK. > > > > We are upgrading to Koha 18.11 soon. > > > > I wondered if anyone has added the random password generator from > member-password.tt to the OPAC/Staff login section of the memberentry > form, using JavaScript in intranetuserjs. > > > > Many thanks, > > > > Kind regards, > > > > Emma Perks > > Area Systems Librarian > > > > ******************************************************************************************************************** > > This message may contain confidential information. If you are not the > intended recipient please inform the > sender that you have received the message in error before deleting it. > Please do not disclose, copy or distribute information in this e-mail or > take any action in relation to its contents. To do so is strictly > prohibited and may be unlawful. Thank you for your co-operation. > > NHSmail is the secure email and directory service available for all NHS > staff in England and Scotland. NHSmail is approved for exchanging patient > data and other sensitive information with NHSmail and other accredited > email services. > > For more information and to find out how you can switch, > https://portal.nhs.net/help/joiningnhsmail > > > > ------------------------------ > > Message: 5 > Date: Wed, 6 Mar 2019 11:28:54 -0500 > From: Jesse Maseto <jesse(a)bywatersolutions.com> > To: Koha <koha(a)lists.katipo.co.nz> > Subject: [Koha] Koha 10.05.10 released. Critical bug fix. > Message-ID: > <CABV14nN6P1ERVFbW1UHqH_zA0=ZbRpVDPmt_ghWV= > xG443wsrw(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > The Koha community is proud to announce the release of 18.05.10. > > This is a maintenance release and contains a critical bugfix. Please review > the release notes here: > > https://koha-community.org/koha-18-05-10-released/ > > As always you can download the release from here: > > http://download.koha-community.org/koha-18.05.10.tar.gz > <http://download.koha-community.org/koha-18.05.09.tar.gz> > Thank you very much to everyone involved in this release. > > Best regards, > -Jesse and Lucas > > -------------------- > Jesse Maseto > Dev/Ops Support > ByWater Solutions > Support & Consulting for OSS > Office - Stratford,CT > T/F 888.900.8944 > http://bywatersolutions.com > Jesse(a)bywatersolutions.com > > > ------------------------------ > > 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 161, Issue 7 > ************************************ >

1 0

Critical bug fix to prevent data loss (Bug 22395)
by Nick Clemens 07 Mar '19

07 Mar '19

Hello all, It has been discovered there is a bug in the stable versions of Koha, 18.05.09 and 17.11.15 which can cause quoted text in records to be deleted upon edit/save https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22395 If you have not yet upgraded to the most recent maintenance release please wait a few days as we are releasing a new version to fix the issue. If you are running these versions please be aware of this bug and we will be sending a notice when the new versions are available. Thanks, Nick

3 3

Koha community site Wordpress issue
by kohanews 07 Mar '19

07 Mar '19

The Wordpress site koha-community.org will not save my edits and I'm unable to publish. Anyone know who manages that? Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

4 3

[MariaDB] installing version 10.3
by Father Vlasie 07 Mar '19

07 Mar '19

Hello everyone, I noticed that Koha is giving me an error: "Some of your tables have problems with their auto_increment values which may lead to data loss." On the wiki page (https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix) it is stated that this issue only affects MariaDB versions prior to 10.2.4. Since MariaDB 10.3 is now stable I tried to upgrade to that version. I installed the MariaDB repo for 10.3. I apt-get removed mariadb-server and common. On upgrading afterwards the correct repo and packages seemed to be listed: —8<—8<—8<--- Get:1 http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.3/debian stretch/main amd64 libmariadbclient18 amd64 1:10.3.13+maria~stretch [3,100 B] Get:2 http://deb.debian.org/debian stretch/main amd64 python3-openssl all 16.2.0-1 [43.8 kB] Get:3 http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.3/debian stretch/main amd64 libmariadb3 amd64 1:10.3.13+maria~stretch [139 kB] Get:4 http://cdn-fastly.deb.debian.org/debian stretch/main amd64 python3-josepy all 1.1.0-2~deb9u1 [27.8 kB] —8<—8<—8<--- But Koha>About still shows: MySQL version: mysql Ver 15.1 Distrib 10.2.22-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 I am running Koha 18.11.03.000 on Debian 9 Stretch. Any ideas? Thank you, Father Vlasie IT Director St. Photios Orthodox Theological Seminary 510 Collier Way, Etna, CA 96027, U.S.A.

2 1

Koha 10.05.10 released. Critical bug fix.
by Jesse Maseto 06 Mar '19

06 Mar '19

The Koha community is proud to announce the release of 18.05.10. This is a maintenance release and contains a critical bugfix. Please review the release notes here: https://koha-community.org/koha-18-05-10-released/ As always you can download the release from here: http://download.koha-community.org/koha-18.05.10.tar.gz <http://download.koha-community.org/koha-18.05.09.tar.gz> Thank you very much to everyone involved in this release. Best regards, -Jesse and Lucas -------------------- Jesse Maseto Dev/Ops Support ByWater Solutions Support & Consulting for OSS Office - Stratford,CT T/F 888.900.8944 http://bywatersolutions.com Jesse(a)bywatersolutions.com

1 0

MARC Bibliographic Test error
by Tanzeem M.B 06 Mar '19

06 Mar '19

Dear folks, Please see the attached document for the detailed specification of errors to be fixed. Please advice how to proceed and fix the problem. With Thanks & Regards Mr. Tanzeem M B +91 9446705956 Thiruvananthapuram

2 1

Third party fee/fine processing systems?
by Ed Veal 05 Mar '19

05 Mar '19

Is anyone out there using a third party system or dives to allow patrons to pay any fines or fees? If so what system are you using and what kind of payments does it accept? Also how is it communicating with Koha? Ed -- *Ed Veal*

4 3

March 2019 koha-US meeting dates
by koha-US Secretary 04 Mar '19

04 Mar '19

*koha-US meetings are open to any and all.* *Board Meeting -* When: Wednesday, March 6th at 10:30 am CST (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+board+mee…> ) Where: https://kslib.zoom.us/j/450230564 Agenda: https://docs.google.com/document/d/1sxTnLFlnXuDdNAxEME_fqK_neizg8PFRThL9-_v… *Board meetings* focus on business-related matters and topics that would otherwise slow down general meetings. *General Meeting* - When: Wednesday, March 13th at 10:30 am CDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+general+m…> ) Where: https://kslib.zoom.us/j/110290143 *General meetings* put an emphasis on Koha -- bugs, issues, development ideas, workflows -- bring your problems and questions so we can discuss! These meetings also include major organizational decisions and reports from various committees. Meetings are held via Zoom video conferencing. A microphone and camera are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops and Android and iOS on mobile devices. For help getting started, visit: *https://support.zoom.us/hc/en-us/categories/200101697 <https://support.zoom.us/hc/en-us/categories/200101697>* If you have topics for discussion at either meeting, please send them to secretary(a)koha-us.org. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0