- Koha - lists.katipo.co.nz

Re: [Koha] Changing IP on Koha Server
by Doug Dearden 11 Nov '15

11 Nov '15

Hi Greg, Always reply to the list when you post something. You get more eyes reading the message and more brains working on the problem. ☺ As far as I know Ubuntu should have the IP addresses in the same place as Debian. Did you check in /etc/network/interfaces ? Doug From: gpa(a)glenstal.com [mailto:gpa@glenstal.com] On Behalf Of G P Ashe Sent: Monday, November 9, 2015 3:53 AM To: Doug Dearden <dearden(a)sarsf.org> Subject: Re: [Koha] Changing IP on Koha Server Hi Doug Ubuntu 12.04 Koha 3.20.05 Greg On 30 October 2015 at 20:27, Doug Dearden <dearden(a)sarsf.org<mailto:dearden@sarsf.org>> wrote: Hi Greg, You don't say which distro you are using. On my Debian install, I have the IP addresses I use statically defined in /etc/network/interfaces . I would check there first. Best, Doug -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz<mailto:koha-bounces@lists.katipo.co.nz>] On Behalf Of G P Ashe Sent: Friday, October 30, 2015 9:07 AM To: koha-user <koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>> Subject: [Koha] Changing IP on Koha Server I need to change the fixed IP on Koha server. What files need to be updated manually in order that everything will work as before but with new IP (different subnet). Thanks Greg -- *Disclaimer Important*: Information in this email (including attachments) is confidential. It is intended for receipt and consideration only by the intended recipient. If you are not an addressee or intended recipient, any use, dissemination, distribution, disclosure, publication or copying of information contained in this email is strictly prohibited. Opinions expressed in this email may be personal to the author and are not necessarily the opinions of *Glenstal Abbey School Ltd*. If this email has been received by you in error we would be grateful if you could immediately notify the sender, and thereafter delete this e-mail from your system. You are requested to carry out your own virus check before opening any attachment. The author and *Glenstal Abbey School Ltd* accept no liability for any loss or damage which may be caused by viruses, malware or malicious software. Please consider the environment before printing this email. _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha [http://www.glenstal.com/wp-content/uploads/2015/09/Glenstal-Abbey-School-si…] Disclaimer Important: Information in this email (including attachments) is confidential. It is intended for receipt and consideration only by the intended recipient. If you are not an addressee or intended recipient, any use, dissemination, distribution, disclosure, publication or copying of information contained in this email is strictly prohibited. Opinions expressed in this email may be personal to the author and are not necessarily the opinions of Glenstal Abbey School Ltd. If this email has been received by you in error we would be grateful if you could immediately notify the sender, and thereafter delete this e-mail from your system. You are requested to carry out your own virus check before opening any attachment. The author and Glenstal Abbey School Ltd accept no liability for any loss or damage which may be caused by viruses, malware or malicious software. Please consider the environment before printing this email.

1 0

Classification code on bibliographic record
by Krister Andréason 11 Nov '15

11 Nov '15

Hi Is it possible to show the classification code (084 a) on the bibliographic record? It is displayed on the marc tab on the bib records I've tested but not on the bib. At first I thought it might have something to do with the xslt, but when I leave the XSLTDetailsDisplay field in admin empty it does not show either. Thank's for your help _______________________ Krister Andréason IT-bibliotekarie Mölndals stadsbibliotek Göteborgsvägen 19, 431 30 Mölndal Tel: 031-315 16 65 Mobil: 0705-76 45 42 Webbplats: bibliotek.molndal.se

3 4

Total number of Entries in Catalog
by Balaji Ravichandran 11 Nov '15

11 Nov '15

Hi all, I am using koha and have successfully imported the database in .sql file format.Now I need to know how many entries have been imported.How to find out how many records are imported?Can anyone please help?Thanks in advance :-) -- Regards, Balaji Ravichandran ( பாலாஜி ) , Volunteer at Free Software Foundation - Tamilnadu, Mobile : 9790528505 My Blog - balogic.wordpress.com

2 2

"patron does not exist" error when adding new patron
by wildness 11 Nov '15

11 Nov '15

Hey All, I inherited a system today for a library that's having a using adding new members. I'm assuming this is a database issue or configuration issue, but i'm not sure how to trouble shoot this. The issue: Via the web interface: When I go to patrons->add a new patron fill out the required fields and send the form I get back a "patron does not exist" error which makes no sense to me. Can anyone help me out? -- View this message in context: http://koha.1045719.n5.nabble.com/patron-does-not-exist-error-when-adding-n… Sent from the Koha-general mailing list archive at Nabble.com.

3 3

Check out more DVDs for "good behavior"
by Christopher Davis 10 Nov '15

10 Nov '15

Dear Colleagues, Is there a way in which Koha can *automatically* increase the number of DVDs a patron is allowed to check out on their account based on their "good behavior" (e.g., their account carries no late fees, no lost item fees, no overdue items, etc.)? I know that Koha currently has a cron which moves patron accounts from a minor patron category into an adult patron category once the said patron has turned 18 years of age. I am wondering if a similar cron could be programmed to move patron accounts from a "four-DVDs" patron category to an "eight-DVDs," or "twenty-DVDs" patron category by evaluating the "good behavior" criteria which I specified in the paragraph above. Is this a ludicrous idea? Your thoughts? Thank you, Christopher Davis, MLS Systems & E-Services Librarian Uintah County Library cgdavis(a)uintah.utah.gov (435) 789-6261 uintahlibrary.org basinlibraries.org facebook.com/uintahcountylibrary

1 0

Searching in Arabic
by Jesse Lambertson 10 Nov '15

10 Nov '15

Good morning everyone (if it is morning when you are...) A while back, we figured out how to search and retrieve results in Arabic (much of our collection is in this language). I thank everyone who helped us get this done. But we have been searching "keyword" in Arabic for so long, we just realized that we are NOT getting any Arabic results for *title*, *author* or *series* in Arabic. ICU is turned-on of course. The default MARC21 fields in Zebra's indexing list are found here: http://manual.koha-community.org/3.2/en/kohasearchindexes.html Are there any other steps we need to follow besides those listed here http://wiki.koha-community.org/wiki/How_to_add_new_zebra_index to add 880 to the indexing list? Or maybe there is a step listed somewhere in the wiki that we missed? Does that mean modifying the framework or is the cataloguing framework itself unaffected during this index-list addition? Thank you in advance for your assistance. Regards, Jesse -- Jesse A Lambertson Librarian Sultan Qaboos Cultural Center <http://www.sqcc.org/> عالم الانجازات ينحاز دوماً مع المتفائلين

1 0

Report help: count of certain subfield values
by Kallinen Pasi 10 Nov '15

10 Nov '15

Hi all, I've been pondering how to do this report, but haven't found a good solution: I'd like to have a list of all subfield values for certain subfield from biblioitems, and have counts of the field contents. For example: SELECT count(*), ExtractValue(marcxml, '//datafield[@tag=<<Field>>]/subfield[@code="<<Subfield>>"]') AS kentta FROM biblioitems GROUP BY kentta ORDER BY count(*), kentta This works, except when the field or subfield is repeatable, because the values from a single record are concatenated by MySQL, with the values separated by spaces. This means it's impossible to know if the space is a separator between the field values, or part of a field value. (If only Koha stored the marcxml data in a database-query friendly format too...) -- Ystävällisin terveisin Pasi Kallinen ICT-asiantuntija p. 050-408 6958 pasi.kallinen(a)pttk.fi Pohjois-Karjalan Tietotekniikkakeskus Oy - www.pttk.fi

1 0

Koha funds
by Hugo Agud 10 Nov '15

10 Nov '15

Dear Koha members We're interested in funding the Koha community, but we have just one question, is it possible to receive an invoice from thr funds? I mean we can't send the money without a invoice , the people from taxes will shoot at me If I can't justify it with an invoice thanks you in advacnce Hugo -- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* Director Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

3 2

Software error
by geromoselle 09 Nov '15

09 Nov '15

Hello, My server is displaying this error message and I don't know how to go about fixing it. Really some urgent help, please. Software error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line 790. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 63. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. For help, please send mail to the webmaster ( [no address given] ), giving this error message and the time and date of the error. George Systems Librarian University of Ilorin Sent from Samsung Mobile.

2 1

Re: [Koha] Class reports
by Paul A 09 Nov '15

09 Nov '15

Could you please try a comma after c.branchcode ? And let us know the results? P. At 12:03 PM 11/9/2015 +1300, library wrote: >Hi everyone > >I wonder if anyone can help me with my report. I am trying to adapt the >"Patrons with most checkouts in date range report" to enable me to print >borrowing statistics by classes which I have as an additional attribute. I >keep getting an error message > >"You have an error in your SQL syntax; check the manual that corresponds to >your MySQL server version for the right syntax to use near >'count(s.borrowernumber) AS checkouts FROM statistics s LEFT JOIN borrowers >b ' at line 2" > >which is the part I didn't change. > >This is as far as I have got in my report. > > >SELECT concat(b.surname,', ',b.firstname) AS name, a.code, a.attribute, >c.branchcode > count(s.borrowernumber) AS checkouts >FROM statistics s >LEFT JOIN borrowers b USING (borrowernumber) >LEFT JOIN borrower_attributes a USING (borrowernumber) >WHERE c.branchcode = 'KKC' AND s.datetime BETWEEN <<Top checkouts BETWEEN >(yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> >WHERE a.code = Class AND a.attribute=<<Class>> > > >Thanks >Ann Murphy >Katikati College >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >https://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

1 0