- Koha - lists.katipo.co.nz

Upload Barcode data to koha
by aaruswartz＠tuta.io 25 Nov '19

25 Nov '19

Dear Team Koha, I have Koha 19 installed and imported (bulk uploaded ) all the records which I had in CSV format after converting to Marc21. But I am unable to upload barcode details of Items which I have in separate CSV file. Please let me know if there are any ways to bulk upload the barcode details I have. Thanks and regardsAaru Swartz

3 2

Need help in login to Koha
by aaruswartz＠tuta.io 25 Nov '19

25 Nov '19

Dear Team Koha, Thanks for accepting my request to join the mail-list. Our office library uses Koha for a long time now. Librarian has forgotten the user name and password. I am the System Admin and have reset the Koha admin user password in the /etc/koha/sites/library/koha-conf.xml and in MySQL. I am able to login to the database via both PHPMyAdmin and MySQL CLI. But unable to login to the Koha site at http://IPaddress:8000 <http://IPaddress:8000>. The login page displays this below message. "Error: Invalid username or password" message is being displayed. " OS : Debian GNU/Linux 8.11 (jessie) Koha : koha 18.11.03 MySQL: mysql 5.5.62 PHPmyadmin : phpmyadmin 4:4.2.12 Please let me know what is causing the problem and if any fix. Thank you. Aaru_Swartz

3 7

Plack using 100% CPU
by Alvaro Cornejo 23 Nov '19

23 Nov '19

Hi After enabling plack, CPU start running at 100% and I get a lot of "compliation errors" as below: Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": Can 't locate object method "cache_dir" via package "Swagger2::SchemaValidator" at /usr/share/perl5/Swagger2.pm lin e 42. Compilation failed in require at (eval 1259) line 1. Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": Can 't locate object method "cache_dir" via package "Swagger2::SchemaValidator" at /usr/share/perl5/Swagger2.pm lin e 42. Compilation failed in require at (eval 1259) line 1. Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": Can 't locate object method "cache_dir" via package "Swagger2::SchemaValidator" at /usr/share/perl5/Swagger2.pm lin e 42. Compilation failed in require at (eval 1259) line 1. Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": Can 't locate object method "cache_dir" via package "Swagger2::SchemaValidator" at /usr/share/perl5/Swagger2.pm lin e 42. Compilation failed in require at (eval 1259) line 1. This is my koha about: Koha version: 17.05.14.000 OS version ('uname -a'): Linux CelacpVps 5.1.2-x86_64-linode124 #1 SMP PREEMPT Wed May 15 15:12:46 UTC 2019 x86_64 Perl interpreter: /usr/bin/perl Perl version: 5.022001 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.22.1 /usr/local/share/perl/5.22.1 /usr/lib/x86_64-linux-gnu/perl5/5.22 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.22 /usr/share/perl/5.22 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base . MySQL version: mysql Ver 14.14 Distrib 5.7.27, for Linux (x86_64) using EditLine wrapper Apache version: Server version: Apache/2.4.18 (Ubuntu) Memcached: Servers: 127.0.0.1:11211 | Namespace: koha_library | Status: running. | Config read from: koha-conf.xml To enable plack I do: sudo koha-plack --enable biblioteca sudo koha-plack --start biblioteca sudo apache2ctl restart Regards, Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com

1 0

[koha] Edited barcodes not saving
by muirunyeri 23 Nov '19

23 Nov '19

Hi Druart, Thank you for your assistance on this issue. I have tried everything I know to remove the duplicate field from the html form without success.How do I do it please? Thank you Sent from my Samsung Galaxy smartphone. Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Michael Hafen <michael.hafen(a)washk12.org> Date: 22/11/2019 20:52 (GMT+03:00) To: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> Cc: Alvaro Cornejo <cornejo.alvaro(a)gmail.com>, muirunyeri <muirunyeri(a)gmail.com>, koha <koha(a)lists.katipo.co.nz>, Koha Devel <koha-devel(a)lists.koha-community.org> Subject: Re: [Koha-devel] [Koha] [koha] Edited barcodes not saving It seems like Koha is trying to set homebranch to 'THK | THK' because the homebranch field is duplicated in the html form. That will fail the foreign key check. The fix for that is probably to verify the value for homebranch in the database for that itemnumber, and if that doesn't looks right then try removing the duplicate field from the html form. On Fri, Nov 22, 2019 at 1:51 AM Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> wrote: Or, better: `koha-zebra --status $INSTANCE` Le mer. 20 nov. 2019 à 20:33, Alvaro Cornejo <cornejo.alvaro(a)gmail.com> a écrit : > > Hi > > Have you checked if zebra is running? > > use: > > ps -ef | grep zebra > > It should give you 4 results. > > Regards, > > Alvaro > > > > |-----------------------------------------------------------------------------------------------------------------| > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > celular y Nextel > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS > y GPRS online > Visitenos en www.perusms.com > > > Le mer. 20 nov. 2019 à 04:09, muirunyeri <muirunyeri(a)gmail.com> a écrit : > > > Hello Chris and all, > > I have been away for awhile the reason I have not responded to a thread I > > raised. The issue remains unresolved. > > I cleared the DBMS autoincrement error and from the system information > > page there's no warning. Barcodes and item edits are still not saving. This > > is really stressing us. The item editor has 2 subfields for permanent > > location as compared to 1 for add new item something that has not been > > there. > > Any assistance will be highly appreciated. > > Thank you > > > > > > Sent from my Samsung Galaxy smartphone.-------- Original message > > --------From: muirunyeri <muirunyeri(a)gmail.com> Date: 07/11/2019 10:20 > > (GMT+03:00) To: Chris Cormack <chrisc(a)catalyst.net.nz> Cc: koha < > > koha(a)lists.katipo.co.nz>, koha-devel(a)lists.koha-community.org Subject: > > [koha] Edited barcodes not saving > > Hi team, > > System information page reports one error which has been there since the > > beginning. The error - Data Problems - Some of your tables have problems > > with their auto_increment values which may lead to data loss. InnoDB does > > not keep auto_increment across SQL server restarts ....... > > No other error besides that. > > I hvae one library set to code THK and still there in my libraries group. > > I do note something unusual in the edit items form for an item am trying > > to edit. There are two subfields for permanent location (subfield a) both > > populating the full name of my library and subfield b -current location > > also with the name of my library. > > Should this two similar subfields be there? Surprisingly theres only one > > subfield for permanent location under add new item. A new item is actually > > saving successfully > > Very grateful for any assistance > > James > > > > Sent from my Samsung Galaxy smartphone.-------- Original message > > --------From: Chris Cormack <chrisc(a)catalyst.net.nz> Date: 06/11/2019 > > 21:18 (GMT+03:00) To: koha(a)lists.katipo.co.nz, muirunyeri < > > muirunyeri(a)gmail.com> Subject: Re: [Koha] [koha] Edited barcodes not > > saving > > That might also be a problem, but the foreign key error before that > > definitely is. It means in that item record the value in homebranch doenst > > match a row in the branches table. > > That's why you can't update that item. Try changing the homebranch and > > save again (maybe try changing all the branch info on that item) > > > > It may be that somehow someone deleted a branch, check in administration, > > to see if all the libraries/branches are there that you expect to be > > > > Chris > > > > On 7 November 2019 2:56:32 AM NZDT, Alvaro Cornejo < > > cornejo.alvaro(a)gmail.com> wrote: > > Hi Muirunyeri > > > > The query used to update the barcode said it is finding several results > > "...Query returned more than one row..." > > > > This means that, when updating a record, msql is founding several records > > to update.... this might seems you have duplicated records in your > > database. > > > > Check on the about page whether you have something about that on system > > status. > > > > Regards, > > > > Alvaro > > > > > > > > |-----------------------------------------------------------------------------------------------------------------| > > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > > celular y Nextel > > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS > > y GPRS online > > Visitenos en www.perusms.com > > > > > > Le mer. 6 nov. 2019 à 03:37, muirunyeri <muirunyeri(a)gmail.com> a écrit : > > > > > > > Hi Vikram and team, > > Below is the error log I tried copying. > > AH01215: [Tue Nov 5 14:38:12 2019] additem.pl: ERROR in > > _koha_modify_item UPDATE items SET > > > > stack=?,price=?,itemnotes_nonpublic=?,replacementprice=?,notforloan=?,enumchron=?,stocknumber=?,itemnotes=?,withdrawn_on=?,datelastseen=?,dateaccessioned=?,restricted=?,copynumber=?,homebranch=?,barcode=?,ccode=?,replacementpricedate=?,holdingbranch=?,coded_location_qualifier=?,location=?,itemlost=?,materials=?,uri=?,booksellerid=?,itemcallnumber=?,itype=?,more_subfields_xml=?,permanent_location=?,items.cn_source=?,damaged=?,itemlost_on=?,withdrawn=?,items.cn_sort=? > > WHERE itemnumber=?: Cannot add or update a child row: a foreign key > > constraint fails (`koha_library`.`items`, CONSTRAINT `items_ibfk_2` > > FOREIGN > > KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) > > at /usr/share/koha/lib/C4/Items.pm line 2029.: > > /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: > > > > http://192.168.67.5:8080/cgi-bin/koha/cataloguing/additem.pl?op=edititem&bi… > > [Tue Nov 05 14:38:12.848114 2019] [cgi:error] [pid 2832] [client > > 192.168.67.5:56592] AH01215: [Tue Nov 5 14:38:12 2019] additem.pl: > > DBIx::Class::Storage::DBI::select_single(): Query returned more than one > > row. SQL that returns multiple rows is DEPRECATED for ->find and ->single > > at /usr/share/koha/lib/Koha/Objects.pm line 92: > > /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: > > > > http://192.168.67.5:8080/cgi-bin/koha/cataloguing/additem.pl?op=edititem&bi… > > Any assistance will be highly appreciated. > > > > Sent from my Samsung Galaxy smartphone.-------- Original message > > --------From: vikram zadgaonkar <vikramczadgaonkar(a)gmail.com> Date: > > 04/11/2019 07:34 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com> Cc: > > Owen Leonard <oleonard(a)myacpl.org>, koha <koha(a)lists.katipo.co.nz> > > Subject: Re: [Koha] [koha] Edited barcodes not saving > > Will you be able to share screen shot of the error. > > Vikram Zadgaonkar > > > > On Mon, Nov 4, 2019 at 10:00 AM muirunyeri <muirunyeri(a)gmail.com> wrote: > > Hello Owen, > > > > Thanks for getting back to me on my query and sorry for not replying > > sooner. > > > > We are using version 17.05. > > > > There are no upgrades to koha, Mysql or the server. There are no changes > > whatsoever and no one has accessed the server. > > > > Kindly guide me on how to access the error logs and I will do so. > > > > Am very grateful for any assistance > > > > Thank you > > > > > > > > Sent from my Samsung Galaxy smartphone.-------- Original message > > --------From: Owen Leonard <oleonard(a)myacpl.org> Date: 31/10/2019 14:43 > > (GMT+03:00) To: muiru james <muirunyeri(a)gmail.com> Cc: koha < > > koha(a)lists.katipo.co.nz> Subject: Re: [Koha] [koha] Edited barcodes not > > saving > > > > Over the last few days, the new barcode is not saving i.e. after > > saving the old number is still showing instead of the new one. > > > > > > What version of Koha are you using? Has anything changed which might > > > > be linked to this problem? A server upgrade, Koha upgrade, MySQL > > > > upgrade? > > > > > > > > Do you have access to Koha's error logs? > > > > > > > > -- Owen > > > > > > > > -- > > > > Web Developer > > > > Athens County Public Libraries > > > > (740) 737-6006 > > > > https://www.myacpl.org Koha mailing list http://koha-community.org > > > > Koha(a)lists.katipo.co.nz > > > > https://lists.katipo.co.nz/mailman/listinfo/koha Koha mailing list > > http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > -- > > Sent from my Android device with K-9 Mail. Please excuse my brevity. > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ -- Michael Hafen Washington County School District Technology Department Systems Analyst

1 0

Add a date picker to edit-item screen for replacementpricedate?
by Raymund Delahunty 22 Nov '19

22 Nov '19

OK, I may have to raise this in Bugzilla, but before I do, I will ask here. When staff price up items with a cost of replacement they need to edit both the $v field and the $w field because Koha does not know to change $w automatically when a change is made to $v. But Koha is silently demanding that data keyed in $w be in the YYYY-MM-DD format. If you key 2019-11-22 Koha will be happy with that and the data will save. But if you key 22-11-2019 (or any other date format) Koha will refuse to accept this data but will not warn. The SAVE operation will see this field cleared out and emptied (if there was something there previously), or left empty (if you are trying to key data into that field for the first time). We might alter the text in Basic constraints in the frameworks to warn the user what to do, but ideally the replacementpricedate would use a date picker, to ensure the item record field populates correctly. Anyone got any tips on how I can do this? Ray Delahunty University of the Arts London . This email and any attachments are intended solely for the addressee and may contain confidential information. If you are not the intended recipient of this email and/or its attachments you must not take any action based upon them and you must not copy or show them to anyone. Please send the email back to us and immediately and permanently delete it and its attachments. Where this email is unrelated to the business of University of the Arts London or of any of its group companies the opinions expressed in it are the opinions of the sender and do not necessarily constitute those of University of the Arts London (or the relevant group company). Where the sender's signature indicates that the email is sent on behalf of UAL Short Courses Limited the following also applies: UAL Short Courses Limited is a company registered in England and Wales under company number 02361261. Registered Office: University of the Arts London, 272 High Holborn, London WC1V 7EY

3 2

Re: [Koha] Searching Authority Records by Authority Record Number
by Stefano Bargioni 22 Nov '19

22 Nov '19

Hi, you may consider using intranetuserjs to add a little form in /cgi-bin/koha/authorities/authorities-home.pl with an input field for the auth id NNN and a button to open /cgi-bin/koha/authorities/detail.pl?authid=NNN (or /cgi-bin/koha/authorities/authorities.pl?authid=NNN to edit the record). HTH. Stefano > Is it possible to search authority records by an authority record number?

1 0

Re: [Koha] Multilingual Searching and ICU Chains
by Charles Kelley 22 Nov '19

22 Nov '19

Hi, all, and especially Ere Maijala In our latest exchange, on 21 Nov 2019, at 15:49, Ere Maijala wrote: I'd use Elasticsearch, at least with all the improvements in the upcoming > Koha 19.11 version. It supports e.g. ICU folding out of the box, and the > analysis chain can be relatively easily modified too. See the (quite > condensed) information at > https://wiki.koha-community.org/wiki/Elasticsearch. This is indeed good news! Thanks for the suggestion. -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 1-5-2 Tsukimino #210 Yamato-shi, Kanagawa-ken, 〒242-0002 JAPAN 1-301-741-7122 [US cell] 011-81-80-4714-5490 [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.

1 0

How to upgrade Koha from 17.05 to Latest stable release on Ubuntu 14.04
by yasiriqbal1 21 Nov '19

21 Nov '19

Dear All, I am new to Koha. Please help me to upgrade Koha from 17.05 to Latest stable release on Ubuntu 14.04. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

4 4

Re: [Koha] Searching Authority Records by Authority Record Number
by Charles Kelley 21 Nov '19

21 Nov '19

Hi, all! In a recent exchange, on 20 Nov 2019, at 11:05, Bob Birchall wrote: Search for authorities on any term. For any authority in the results list, > choose action 'edit'. On the editor page, in the URL, change the authority > number (authid) to that of the record you wish to edit. In a later exchange, on 20 Nov 2019, at 14:06, Heather Hernandez wrote: We're on 18.11, but if I just put an aut record number into the search box > with "Default," "contains" selected, my Koha returns just the aut record > with that aut record number. (It does the same thing if I use the LCCN from > the 010 field.) Interestingly enough, it works also in the Authority > Search in the OPAC. I'm afraid that neither technique worked. We use 3.20 from Josh Hertel's test (and training) package. We are building a proof-of-concept machine and this is what we could get up and running, at least well enough to make MARC records. We're now building a more recent version of Koha, either 18.11 or 19.05, on a Debian or Ubuntu server. Nonetheless, we are encountering the limitations of such an old version and I'm trying to clean up records before copying to the new machine. In any event, it looks like this is one of the limitations, and we'll have to clean up the authority records after the migration. I had hoped there was something analogous to searching sn:5946 for bibliographic records by biblionumber. If anyone knows a way of specifying the record number in authority record searches, we would greatly appreciated it. Thanks for everyone's help. -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 1-5-2 Tsukimino #210 Yamato-shi, Kanagawa-ken, 〒242-0002 JAPAN 1-301-741-7122 [US cell] 011-81-80-4714-5490 [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

Searching Authority Records by Authority Record Number
by Charles Kelley 20 Nov '19

20 Nov '19

Hello, all! Is it possible to search authority records by an authority record number? I have to edit a few authority records. The main entry (100) is in kanji, but each has a Romanized transcription. Koha has graciously created the authority record but only for the kanji version. I have to add the Romanized version. I have the record number and I haven't successfully figured out from the documentation or an internet search how to do so. Thanks to everyone's help. P. S. I haven't yet set up the Linux box to search by kanji. That, I know I have to do, but at least Koha accepts kanji input. -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 1-5-2 Tsukimino #210 Yamato-shi, Kanagawa-ken, 〒242-0002 JAPAN 1-301-741-7122 [US cell] 011-81-80-4714-5490 [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.

3 2