- Koha - lists.katipo.co.nz

Error restoring Koha-Instance
by Beda Szukics 11 Mar '19

11 Mar '19

Hi all I try to restore a koha-instance wiht koha-restore and I get the following messages: error retrieving biblio 1669 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680. DBD::mysql::st execute failed: Unknown column 'me.damaged_on' in 'field list' [for Statement "SELECT `me`.`itemnumber`, `me`.`biblionumber`, `me`.`biblioitemnumber`, `me`.`barcode`, `me`.`dateaccessioned`, `me`.`booksellerid`, `me`.`homebranch`, `me`.`price`, `me`.`replacementprice`, `me`.`replacementpricedate`, `me`.`datelastborrowed`, `me`.`datelastseen`, `me`.`stack`, `me`.`notforloan`, `me`.`damaged`, `me`.`damaged_on`, `me`.`itemlost`, `me`.`itemlost_on`, `me`.`withdrawn`, `me`.`withdrawn_on`, `me`.`itemcallnumber`, `me`.`coded_location_qualifier`, `me`.`issues`, `me`.`renewals`, `me`.`reserves`, `me`.`restricted`, `me`.`itemnotes`, `me`.`itemnotes_nonpublic`, `me`.`holdingbranch`, `me`.`paidfor`, `me`.`timestamp`, `me`.`location`, `me`.`permanent_location`, `me`.`onloan`, `me`.`cn_source`, `me`.`cn_sort`, `me`.`ccode`, `me`.`materials`, `me`.`uri`, `me`.`itype`, `me`.`more_subfields_xml`, `me`.`enumchron`, `me`.`copynumber`, `me`.`stocknumber`, `me`.`new_status` FROM `items` `me` WHERE ( `me`.`itemnumber` = ? )" with ParamValues: 0=2262] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. Maybe my dump is too old? The one I have is from Juni 2018. Koha is 18.11.02.000. It shows: System Maintenance The Koha online catalog is offline for system maintenance. We'll be back soon! If you have any questions, please contact the site administrator What can I do? Beda

3 2

How to import multiple copies?
by Myriam Torres 11 Mar '19

11 Mar '19

Hello, Do you know how can I import multiple copies from a Marc File into Koha? This is an example of my .mrc file, as you can see all the information is the same except the bar code: =LDR 01362nam a2200289Ia 45e0 =005 $020190221144117 =008 $0070215s2008\\\\miua\\\\\b\\\\001\0\eng =008 190311s9999\\\\xx\\\\\\\\\\\\000\0\und\d =020 \\$a9780310274407 =040 \\$aDLC =040 \\$beng =040 \\$cDLC =040 \\$dDLC =082 \\$22nd ed =100 \\$aVyhmeister, Nancy J. =245 \0$aQuality research papers for students of religion and theology =245 \0$cNancy Jean Vyhmeister =260 \\$aGrand Rapids, Mich =260 \\$bZondervan =260 \\$cc2008 =300 \\$axii, 264 p =300 \\$c23 cm =650 \\$aMusic appreciation. =942 \\$2ddc =942 \\$cBK =952 \\$2ddc$aAKL$bAKL$o200.72$p0018019$yBK =LDR 01243nam a2200229Ia 45e0 =005 $020190221144117 =008 $0070215s2008\\\\miua\\\\\b\\\\001\0\eng =008 190311s9999\\\\xx\\\\\\\\\\\\000\0\und\d =020 \\$a9780310274407 =040 \\$aDLC =040 \\$cDLC =040 \\$dDLC =082 \\$22nd ed =100 \\$aVyhmeister, Nancy J. =245 \0$aQuality research papers for students of religion and theology =245 \0$cNancy Jean Vyhmeister =260 \\$aGrand Rapids, Mich =260 \\$bZondervan =260 \\$cc2008 =300 \\$axii, 264 p =300 \\$c23 cm =650 \\$aMusic appreciation. =942 \\$2ddc =942 \\$cBK =952 \\$2ddc$aAKL$bAKL$o200.72$p29621$yBK Thank you --

2 1

How to define that library loan X copies are only for students enrolled in the X Library school.
by Victor Barroso Oliveira 10 Mar '19

10 Mar '19

Good afternoon, Considering Koha in a Bible Network. How to define that library loan X copies are only for students enrolled in the X Library school. When selecting a student enrolled in a Library the system is allowing to borrow from copies registered in other libraries that the student is not linked. How can I solve this? Thank you, Victor <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> Livre de vírus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…>. <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

2 1

Re: [Koha] Adding randomly generated password to member entry form using intranetuserjs
by Katrin Fischer 09 Mar '19

09 Mar '19

Hi Emma, thx! Posting back to the list to share the link: *Bug 22485* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22485> - Add randomly generated password suggestion to add/modify patron form Katrin On 08.03.19 15:17, Emma Perks wrote: > Hi Katrin, > > Sure - I've logged this on Bugzilla! > > Nice to meet you. > > Kind regards, > > Emma Perks > Area Systems Librarian > Tel: +44 (0) 121 424 9824, ext. 49824 > Email: Baselibrary.Consortium(a)nhs.net > Web: http://www.base-library.nhs.uk > BASE Library Consortium > > By accepting receipt of this information, you agree to abide by Trust policies, guidelines and code of conduct in relation to confidential patient information. You also agree to use this information in line with the Data Protection Act 1998 and any other relevant legislation and guidelines. If you have any concerns about confidential patient information, you can contact the Trust’s Information Governance Manager or the Caldicott Guardian. > > -----Original Message----- > From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Katrin Fischer > Sent: 07 March 2019 21:18 > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Adding randomly generated password to member entry form using intranetuserjs > > Hi Emma, > > we haven't, but I think it would be nice, especially for generating a > first time password when using the ACCTDETAILS notice. > > I think it would be good to have a bug/enhancement request reported for > this on bugs.koha-community.org. > > Katrin > > > On 06.03.19 13:09, Perks, Emma (UNIVERSITY HOSPITALS BIRMINGHAM NHS > FOUNDATION TRUST) wrote: >> 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 >> >> _______________________________________________ >> 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

1 0

Re: [Koha] How to receive reports to email
by Alvaro Cornejo 09 Mar '19

09 Mar '19

Hi Satish Always CC koha list so you can have more feedbacks and others can profit from discussion. You can start with the example Paul provided. I don't know perl but seems complete; however you need to define/create your query. If you don't know perl, you can use any language you know. You can place it in any where you want -you must add-its path to the cron line-. Koha have a cgi-script folder you might want to use or create one for your specific scripts. It must also have the permissions required for it to be run by your cron and access your database. As Paul said, once you have your script ready you need to add a line in your daily cron for it to execute. 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 ven. 15 févr. 2019 à 01:16, SATISH <lis4satish(a)gmail.com> a écrit : > Hi Alvaro, > > Thank you for your email, could you please do little elaborate on how to > write a script or could share some > example script. Where this script should be placed (path) and permissions. > > Tks. > Satish > > On Thu, 14 Feb 2019 at 19:03, Alvaro Cornejo <cornejo.alvaro(a)gmail.com> > wrote: > >> Hi >> >> If already have an report for this, you can define it as public and >> create a small script -in the language of your choice- that runs it and >> insert an entry in cron jobs. >> >> You can even create the whole report in your script accessing directly to >> your database. >> >> Regards, >> >> Alvaro >> >>

5 9

Database Upgrade
by Mohamad F. Barham 09 Mar '19

09 Mar '19

Dears, I am a little bit new to KOHA system. I am trying to test KOHA adaptability to my university library (where I work). I want to add new fields to be used with items e.x binding _cost, binding_note, binding_type. I already added new columns in the database in items table to be used for binding _cost, binding_note and binding_type. the columns were added throug atomicupdate, then running the command koha-upgrade-schema INSTANCE. the columns now exist in the database, but how to add entry for KOHA to marc mapping for these new columns? is it automatically? or should is insert something else where? notes KOHA 18.11 on debian [cid:image002.png@01D327F4.25E9A910] Mohamad Barham System administrator | Information Technology Department Birzeit University P.O.Box. 14, Birzeit, Palestine Tel: + 970 22982012 | Mob: +970 597 861929 | Ext: 5616 mbarham(a)birzeit.edu | www.birzeit.edu<http://www.birzeit.edu/> ~~~~~~~~~~~~~~~~~~~~~~~~~~ The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. The University is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. ~~~~~~~~~~~~~~~~~~~~~~~~~~

2 3

Training on Koha & MARC21
by Nur Ahammad 09 Mar '19

09 Mar '19

Dear All, Koha-ILS and MARC21 Training (17th Phase) will be held from 19th April 2019 to 22nd April 2019 at Daffodil International University Library in Bangladesh. If anybody interested, apply <http://library.daffodilvarsity.edu.bd/content/registration-koha-ils-and-mar…> -- Nur Ahammad Senior Assistant Librarian (System) Daffodil International University *Read to Know. Read to Learn. Read to Lead*

1 0

OpenURL Link Resolvers
by Gene Stevenson 08 Mar '19

08 Mar '19

Koha family, We're in the midst of transitioning to Koha, but we're a non-traditional user. Instead of a library, we are an abstracting database working with Koha to make our service easier to use for our subscribers (mainly libraries). Think of us as a virtual library with our patrons being actual physical libraries. Each of our patrons need the capability of linking out from our database to their in-house full-text e-journal collections via OpenURL linking (link resolver). Do you all have ideas on how this might work? Thank you in advance for your time and consideration! Gene L. Stevenson Religious & Theological Abstracts 121 S. College St., Suite 106 Myerstown, PA 17067 USA Phone: (717) 866-6734 E-mail: <mailto:rtaed@rtabstracts.org> rtaed(a)rtabstracts.org URL: <http://www.rtabstracts.org/> www.rtabstracts.org

1 0

Koha performance and 6 million records
by Michael Kuhn 08 Mar '19

08 Mar '19

Hi We are currently running Koha 18.11 on Debian GNU/Linux 9 (virtual machine with 2 processors, 4 GB RAM) and 50'000 bibliographic records in a MariaDB database, using Zebra, and of course Plack and Memcached. There are only about 160 users. We would like to add 6 million bibliographic records (metadata of articles) that before were only indexed in the Solr index of a proprietary discovery system, but not in Koha itself. Since we are lacking experience in such large masses of data we would like to investigate about the consequences: * Will the overall performance and especially the retrieval experience suffer a lot? (note there are only 160 users) We're afraid it will... * If yes, is there a way to improve the retrieval experience? For example changing from a virtual machine to a dedicated or physical host? Adding more resp. faster processors, more RAM? Using SSD disks instead of SAS? Changing from Zebra to Elasticsearch? Or will we need to implement another discovery system, like Vufind (which is using Solr Energy)? Any tips or hints are very much appreciated! Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 2

Re: [Koha] [MariaDB] installing version 10.3
by Father Vlasie 08 Mar '19

08 Mar '19

Thank you for the reply. I found the problem! I neglected to install mariadb-server only installing mariadb-common It is all fine now! FV >> 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. > > You may need to restart memcached and koha-common. The mariadb > upgrade would not do that. > >> Any ideas? >> >> Thank you, >> >> Father Vlasie >> >> IT Director >> St. Photios Orthodox Theological Seminary >> 510 Collier Way, Etna, CA 96027, U.S.A. >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha > > -- > Héctor González > cacho(a)genac.org

1 0