- Koha - lists.katipo.co.nz

multiply zebra daemons problem on ubuntu 16.04
by Irakli Garibashvili 09 Mar '20

09 Mar '20

Dear All, We have encountered this problem when upgrading Ubuntu from version 14.04 to - 16.04 : We run multiply instances of koha on the ubuntu server. (Single Koha with several MySQL databases – koha, koha1, koha2, koha3) For each of the instances, we have to run separate koha-zebra-daemon. The daemon for the instance of koha1 is the following: --------------------------------------------------------------------------------------- USER=koha GROUP=koha DBNAME=koha1 NAME=koha-zebra-ctl.$DBNAME LOGDIR=/var/log/koha1 ERRLOG=$LOGDIR/koha-zebradaemon.err STDOUT=$LOGDIR/koha-zebradaemon.log OUTPUT=$LOGDIR/koha-zebradaemon-output.log KOHA_CONF=/etc/koha1/koha-conf.xml RUNDIR=/var/run/koha1/zebradb LOCKDIR=/var/lock/koha1/zebradb # you may need to change this depending on where zebrasrv is installed ZEBRASRV=/usr/bin/zebrasrv ZEBRAOPTIONS="-v none,fatal,warn" .................................................................................................... .............the same as for instance of koha, koha2, koha3........... --------------------------------------------------------------------------------------- When I activate the daemon, on Ubuntu 14.04 it passes without any problem, but on Ubuntu 16.04 I get the following error: --------------------------------------------------------------------------------------- $ sudo update-rc.d koha1-zebra-daemon defaults insserv: script koha1-zebra-daemon: service koha-zebra-daemon already provided! insserv: exiting now! update-rc.d: error: insserv rejected the script header --------------------------------------------------------------------------------------- Can anyone help me to solve the problem? Best regards Irakli Garibashvili Tbilisi, GEORGIA

2 1

-SQL report on total cost of books
by Yatheesh lis 09 Mar '20

09 Mar '20

Hi I would like to know total cost of books in my library Can anyone suggest -SQL query on following details 1) total number books & total cost. 2) total number of books with out cost Thank you

2 1

How to add authorized value to a report output
by Joelle Hannert 06 Mar '20

06 Mar '20

I'm trying to get a report to include an output of a custom borrower attribute, but having trouble coming up with the correct way to ask for this in the SQL code. I feel like the answer is somewhere on this schema page: http://schema.koha-community.org/18_11/tables/borrower_attributes.html but nothing I'm trying is working. The authorized value for our local attribute is "BANNERHOLD." I tried the following: - borrower_attributes.bannerhold - borrower_attribute_types.bannerhold - code.bannerhold I don't really understand how the relationships work, so it's just trial and error for me. Any advice would be much appreciated! Joelle -- Joelle Hannert Library Technical Services Coordinator Northwestern Michigan College (231) 995-1684 Work days: M, W, Th, F

3 4

Rancor/advanced bib editor at next Cataloging SIG meeting
by Hernandez, Heather H 05 Mar '20

05 Mar '20

Hi! The next meeting of the Koha-US Cataloging SIG is Thursday, March 5, 2020, 8am – 9am PT (9 MT/10 CT/11 ET), https://zoom.us/j/861480992 (Open to all!) Topic: Advanced Bibliographic Editor/Rancor Round Table! Join us for a live Rancor walk-through in a real, live Koha catalog!!! Experimenting!! Q&A!! Sharing!! Send me ideas for what you'd like to see in Rancor--we'll try it!! Spoiler: There will be multiple browsers in use at once!! (What?!?) Tune in to see if I'm wearing (and clutching??) my pearls!! Join us and join in--unmute and chime in! Share your tips and tricks! Ask questions! The meeting will be recorded and available on the Koha-US YouTube channel for those who want to re-watch or can't make it to the live round table with the chat saved and appended to the description. (Koha and chill!) See you then! --h2 ~~~~~~~~~~~~~~ Ms. Heather Hernandez (she, her, hers) Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032, heather_hernandez(a)nps.gov<mailto:heather_hernandez@nps.gov> Library catalog: http://keys.bywatersolutions.com/

1 1

Issue list of statuses
by Mohamad F Barham 04 Mar '20

04 Mar '20

Dears, In serials module, the list of issue statuses is hardcoded, is there a way to add new statuses or to use it as authorized value. I need statuses like withdrawn as its not existing in the list, Koha version: 19.11.03.000 Linux libkoha 4.9.0-9-amd64 #1 SMP Debian 4.9.168-1+deb9u3 (2019-06-16) x86_64 attached current statuses. Regards [cid:image002.png@01D327F4.25E9A910] Mohamad Barham System Engineer | 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 1

Restrictions on 9XX Fields
by Charles Kelley 03 Mar '20

03 Mar '20

Hi, all! I'd like to thank everyone for the help I have received in the past. My library would like to begin tracking changes we make to the catalog records. I already know Koha does keep track of changes, for when I click on "Modification Logs", I see a rich history. What I had in mind was something that we did in another library job of mine: rededicated a 9XX field to log a brief synopsis of the changes we made. Mostly just the cataloger's name or initials, timestamp, and a few words, e.g., 949 \\ $a Kelley, Charles. $b 2020-02-28 $c Added subject field. $c Romanized Cyrillic title. 949 \\ $a Sloshkin, Victoria. $b 2020-02-29 $c Added editor [700]. $c Added series title. 949 \\ $a Watanabe, Junko. $b 2020-02-30 $c Fixed title indicators. 949 \\ $a Watanabe, Junko. $b 2020-02-31 $c OK. Nothing more involved or detailed than the illustrations. If we really need the detail, we'll look at the modification logs. I know the 9XX fields are locally defined, but as far as I can determine, Koha uses the 942, 952, and 999 fields and they are to be avoided. Are there other 9XX fields that we ought to avoid? I have added to the avoidance list the CANMARC fields and the other fields in the Koha default framework. I understand I'll have to add the brief change log field (949 in my examples)and its subfields to the frameworks. Many thanks for your help. -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 5-2 Tsukimino 1-Chome #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +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

Re: [Koha] Restrictions on 9XX Fields
by Charles Kelley 03 Mar '20

03 Mar '20

Hi, Caroline This is good to hear. Thanks for the confirmation, and the suggestion of the additional MARC tag fields. They may be a better solution. In our latest exchange, on 2 Mch. 2020, at 11:21, Caroline Cyr-La-Rose wrote: > As far as I know, Koha only uses those three MARC fields (942, 952 and 999). > > Also, have you looked at the following system preferences MarcFieldForCreatorId, MarcFieldForCreatorName, MarcFieldForModifierId and MarcFieldForModifierName? You can enter your local 9XX fields in there. Quoting my question of 2 Mch. 2020, 12:29, to wit: > My library would like to begin tracking changes we make to the catalog records. I already know Koha does keep track of changes, for when I click on "Modification Logs", I see a rich history. > > What I had in mind was something that we did in another library job of mine: rededicated a 9XX field to log a brief synopsis of the changes we made. Mostly just the cataloger's name or initials, timestamp, and a few words, e.g., > 949 \\ $a Kelley, Charles. $b 2020-02-28 $c Added subject field. $c Romanized Cyrillic title. > 949 \\ $a Sloshkin, Victoria. $b 2020-02-29 $c Added editor [700]. $c Added series title. > 949 \\ $a Watanabe, Junko. $b 2020-02-30 $c Fixed title indicators. > 949 \\ $a Watanabe, Junko. $b 2020-02-31 $c OK. -- Caroline Cyr La Rose, M.S.I. Bibliothécaire | Responsable de produit Tél. : 1-833-465-4276, poste 221 Caroline.Cyr-La-Rose(a)inLibro.com <mailto:caroline.cyr-la-rose@inLibro.com> INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com < http://www.inLibro.com> -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 5-2 Tsukimino 1-Chome #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +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

koha-US March 2020 Meetings & Events
by Jason Robb 02 Mar '20

02 Mar '20

koha-US online meetings and events are free and open to all. See our calendar for a full list: http://koha-us.org/calendar/ *Meetings* Board Meeting - Wednesday, March 4th @ 8:30-9:30 PT (9:30 MT / 10:30 CT / 11:30 ET) - Meeting Link - https://zoom.us/j/293750042 - Agenda - https://docs.google.com/document/d/12TKC2nKuasTRC-xFvbYuqgY2arBu90xXOnVMD3V… General Meeting - Wednesday, March 11th @ 8:30-9:30 PT (9:30 MT / 10:30 CT / 11:30 ET) *Learning Opportunities* Basic SQL for Koha Users - Tuesday, March 24th @ 8:30-9:30 PT (9:30 MT / 10:30 CT / 11:30 ET) *Special Interest Groups* Cataloging - Thursday, March 5th @ 8-9 PT (9 MT / 10 CT / 11 ET) System Administration - Tuesday, March 10th @ 9-10 PT (10 MT / 11 CT / Noon ET) Acquisitions - Tuesday, March 17th @ 9-10 PT (10 MT / 11 CT / Noon ET) See what other SIGs are in the works and join groups on topics important to you: http://koha-us.org/special-interest-groups/ For example, do you wish certain Koha functionality was more streamlined? Do you have strong opinions about how Koha looks and feels? Consider joining the *Web Development SIG <https://groups.google.com/a/koha-us.org/forum/#!forum/webdev>* to chat about Koha user experience and interface design, customization, and more. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Saying farewell to QueryParser
by Renvoize, Martin 02 Mar '20

02 Mar '20

Hi All, As discussed at the development meeting on the 19th February <https://meetings.koha-community.org/2020/development_irc_meeting_19_februar…> we have decided to remove the QueryParser option and code from Koha. This decision was not taken lightly, but with the move towards Elasticsearch and the lack of follow-through support for continued bug fixing and improvements in the QueryParser code we decided to reduce out maintenance debt and remove it. We used HEA to try to ascertain if anyone had been using the option and it appears to have little to zero adoption (and at the time of writing, had a number of bad bugs which meant using it was advised against for some time). Jonathan D has worked hard to produce a patch quickly to do this work and I intend to push this later today to reduce the risk of repetitive rebase requirements. So, join me in saying farewell to QueryParser, a nice idea never fully realised. Many thanks as ever to the koha development team, *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager Community Release Manager (19.11, 20.05) *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

1 0

Problems with Virtual Hosts?
by dimabin 29 Feb '20

29 Feb '20

I tried to install Koha following this manual: https://wiki.koha-community.org/wiki/Koha_on_Debian My system: Debian (at digitalocean) In what follows, XXX is my domain at ".org". libersu is my instance. Contents of /etc/koha/koha-sites.conf: DOMAIN=".XXX.org" INTRAPORT="80" INTRAPREFIX="" INTRASUFFIX="-intra" OPACPORT="80" OPACPREFIX="" OPACSUFFIX="" Folder /etc/koha/sites/ contains an empty folder libersu. Directory /etc/apache2/sites-available contains only 2 files: 000-default.conf default-ssl.conf URLs: http://libersu.XXX.org/ http://libersu-intra.XXX.org/ When I open these URLs in browser, it opens just Apache2 Debian Default Page, not Koha. Please help me with this. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

3 2