- Koha - lists.katipo.co.nz

Call for news for the July newsletter
by Daniel Grobani 12 Jul '13

12 Jul '13

Dear Koha kommunitarians, I'm harvesting news for this month's newsletter. Please send me by the 20th anything you think your fellow community members might like to know about. "News" can be as short as a sentence or as long as a paper. I especially encourage you to send me a line or two for the gossip/society column about what you're currently working on. And if you know of a go-live not announced on the list, please be sure to let me know about it. Thanks, Daniel Grobani

1 0

Cronjob errors
by Doug Dearden 12 Jul '13

12 Jul '13

Hello all, I don't think this is critical, but every night that the cron jobs run I get this email: >From root(a)sar75linux.campus.sarsf.org Thu Jul 11 06:32:28 2013 Envelope-to: root(a)sar75linux.campus.sarsf.org Delivery-date: Thu, 11 Jul 2013 06:32:28 -0600 Date: Thu, 11 Jul 2013 06:32:28 -0600 From: root(a)sar75linux.campus.sarsf.org (Cron Daemon) To: root(a)sar75linux.campus.sarsf.org Subject: Cron <root@SAR75Linux> test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily ) Content-Type: text/plain; charset=UTF-8 X-Cron-Env: <SHELL=/bin/sh> X-Cron-Env: <PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin> X-Cron-Env: <HOME=/root> X-Cron-Env: <LOGNAME=root> /etc/cron.daily/koha-common: [: 97: missing ] [: 97: missing ] [: 97: missing ] Here's the server info: Koha version: 3.10.00.000 OS version ('uname -a'): Linux SAR75Linux 2.6.32-5-686 #1 SMP Sun Sep 23 09:49:36 UTC 2012 i686 GNU/Linux Perl interpreter: /usr/bin/perl Perl version: 5.010001 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.1.63, for debian-linux-gnu (i486) using readline 6.1 Apache version: Server version: Apache/2.2.16 (Debian) Zebra version: Zebra 2.0.47 (C) 1994-2010, Index Data ApS Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: e4e44d1916c6e80e01aad163b487ee41c22272ba Using ICU Koha installed from packages on Debian Squeeze . The cron file is the default included in the package. It looks like this: #!/bin/sh # /etc/cron.daily/koha-common -- Daily housekeeping tasks for all Kohas. # Copyright 2010 Catalyst IT, Ltd # # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation, either version 3 of the License, or # (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program. If not, see <http://www.gnu.org/licenses/>. koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/overdue_notices.pl -t koha-foreach --enabled /usr/share/koha/bin/cronjobs/fines.pl koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/advance_notices.pl -c koha-foreach --enabled /usr/share/koha/bin/cronjobs/holds/cancel_expired_holds.pl >/dev/null 2>&1 koha-foreach --enabled /usr/share/koha/bin/cronjobs/services_throttle.pl > /dev/null 2>&1 koha-foreach --enabled /usr/share/koha/bin/cronjobs/cleanup_database.pl --sessions --zebraqueue 10 koha-foreach --enabled --noemail /usr/share/koha/bin/cronjobs/cleanup_database.pl --mail koha-run-backups --days 2 --output /var/spool/koha I couldn't find anything in bugzilla. I am running three instances of Koha which I assume is why I get the error message three times. Thanks for any help. Doug Dearden Director, IT School for Advanced Research (505)954-7220 sarweb.org

2 3

Search engine configuration error
by Araik Manukyan 12 Jul '13

12 Jul '13

Hi list. We have 3 servers of Koha (3.10,3.12, 3.12.01) on Ubuntu 12.04 We have some problem (on the 3 servers) when clicking Search engine configuration in System preferences.It brings such error : ****************************** Software error: `Koha::SearchEngine::::Config' is not a module name ***************************************************** Any suggestions? Araik.

1 0

Fwd: Change of format of CSV basket export
by Rachel Hamilton-Williams 11 Jul '13

11 Jul '13

-------- Original Message -------- Subject: Change of format of CSV basket export Date: Thu, 11 Jul 2013 13:01:54 +0200 From: Mike D. <black23(a)gmail.com> To: koha-owner(a)lists.katipo.co.nz Hello, in Koha is possible define some CSV profiles for export from OPAC (Tools/CSV Profiles). Is possible make similar profile for basket export? It should be very useful for quick book shopping. Some of our vendors can import orders in CSV format into their e-shops (IBAN/EAN, quantity). Is possible to change default export format from basket? Thanks Mike

1 0

Fwd: Change of format of CSV basket export
by Chris Cormack 11 Jul '13

11 Jul '13

---------- Forwarded message ---------- From: Mike D. <black23(a)gmail.com> Date: 11 July 2013 23:01 Subject: Change of format of CSV basket export To: koha-owner(a)lists.katipo.co.nz Hello, in Koha is possible define some CSV profiles for export from OPAC (Tools/CSV Profiles). Is possible make similar profile for basket export? It should be very useful for quick book shopping. Some of our vendors can import orders in CSV format into their e-shops (IBAN/EAN, quantity). Is possible to change default export format from basket? Thanks Mike

1 0

Re: [Koha] Help Re: Journal Articles
by King, Fred 11 Jul '13

11 Jul '13

Hello Alice, and everyone, Funny you should bring this up. I was planning to bring it up myself a while later after we got our system running smoothly, but this seems like a good time since we're not the only ones interested in this kind of a project. A few years ago, we started Authors' Day, a celebration of Hospital Center associates who have written articles, book chapters, etc. Last year, we started tracking the articles in Reference Manager so we could analyze the data a bit more, and include subject headings, etc., in the citations. The next step is to put the data into Koha to make it widely and easily accessible to anyone on the hospital network. Who knows? Someday we might be able to make it available outside our firewall as well. My idea is to install a second instance of Koha on our server (I did it already on a test system, so that's not a major problem) and use it exclusively for local authors. Just about everything our associates publish is in Medline, so one of the things we're pondering is how to convert MeSH to MARC. Like Alice, we've looked at analytics and we don't think that's the solution. Some of the other things we're considering include: * We're only interested in indexing local authors, but we ought to include the non-local co-authors in the record. * We want to differentiate between journal article, book, chapter, etc. Maybe Item Types? * There's also the consideration of what kind of journal article--case report, letter, randomized controlled trial, etc. Maybe Collection Code? * Right now we're indexing articles from three MedStar divisions, but eventually we'd consider adding other hospitals. Different branches? * We also want to include departmental affiliation. So I guess my question is, has anyone else done something like this? Can anyone offer any pointers? BTW, the actual conversion of one set of tags to another is not all that difficult. I found a program called Replace Text that you can set up to look for every instance of xxx and convert it to yyy, for multiple values of xxx and yyy. I'm sure there are others. Cheers, Fred King Medical Librarian, MedStar Washington Hospital Center fred.king(a)medstar.net 202-877-6221 ---------------------------- Original Message ---------------------------- Subject: [Koha] Help Re: Journal Articles From: "Alice Esguerra" <kaces08(a)gmail.com> Date: Mon, July 8, 2013 12:33 am To: koha(a)lists.katipo.co.nz -------------------------------------------------------------------------- Hello everyone, We are new with Koha, we started 2 years ago with Koha 2.9 and recently migrated to Koha 3.12 (May of this year). My concern is about our periodical indexes. We have manually encoded about 1000 records of indexes to journal and magazine articles. I'd like to create a MARC framework for this. Can somebody please help us as to what MARC tags to use for the framework? I have seen the discussion about "Analytics" but I don't think this is applicable to us because we only prepared records for the "component articles" while the "parent or host item" (for journals) were not recorded in our OPAC. Our objective is to make a simple framework that is searchable and wouldn't have any conflict with the MARC rules. We really hope to hear from you. Thank you in advance! alice -- Alicia C. Esguerra Associate Professor I/ Librarian Bulacan State University City of Malolos, Bulacan 3000 Philippines +63 044 7961417 www.bulsu.edu.ph _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha CONFIDENTIAL: The information contained in this communication, including its attachments, may contain confidential information and is intended only for the individual(s) or entity(ies) to whom it is addressed. The information contained in this communication may also be protected by legal privilege, federal law or other applicable law. If you are not the intended recipient of this communication, you are hereby notified that any distribution, dissemination or duplication of this communication is strictly prohibited. If you have received this communication in error, please immediately delete and destroy all copies of this message and please immediately notify us of the error by separate communication. Thank you.

3 4

Check a potential bug in Koha serials module
by Hugo Agud 11 Jul '13

11 Jul '13

Hi everybody Before opening a bug in bugzilla... we wish to check with you a strange behaviour of serials pattern If one subscription ends before expirying, for example it goes to bankrupcy :( (we know a lot of this now in Spain)... if we try to delete or cancel any expected issue they system automatically generate new one... there is no way of cancel expected issues it is an unlimited loop, even if the subscription is expired Of course we can delete via mysql.... Kindest Regards Hugo -- *Hugo Agud - Orex Digital * *www.orex.es* * * Director Mossen Jaume Rafanell, 21 · 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.

1 0

Software error in koha
by sumit raina 10 Jul '13

10 Jul '13

Respected Sir I tried to install Koha on my system running ubuntu 12.04 LTS but i got the below error when i tried to run the software. Also i have installed solr, perl, apache tomcat6 and have followed the proper instructions provided with koha . Still i get the below error when i try to run it at http://127.0.1.1/ . Please help . Error is displayed in the same style and font as below . Kindly help me so that i could use Koha . Software error: Access denied for user 'kohaadmin'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 803. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 63. Compilation failed in require at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. BEGIN failed--compilation aborted at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. -- Thank You Sumit Raina

4 5

New SQL Report - All titles with 008 for Continuing Resource
by Cab Vinton 10 Jul '13

10 Jul '13

All titles with 008 for Continuing Resource Developer: Nicole C. Engard, ByWater Solutions Module: Statistical (Catalog) Purpose: This report lists all titles that are coded as continuing resources in the 008 SELECT b.title, m.issn FROM biblioitems m LEFT JOIN biblio b USING (biblionumber) WHERE SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag="008"]'),22,1) IN ('d','l','m','n','p','w') Cheers, Cab Vinton Sanbornton Public Library Sanbornton, NH

1 0

Boolean operator AND shows up as highlighted term
by Elaine Bradtke 10 Jul '13

10 Jul '13

We're using 3.10.05 When using the advanced search option (in both OPAC and staff interface) if you enter more than one search term in the Search for box (author, title, etc.) Koha highlights 'and' in the search results, and even truncated versions such as England. Being the catalogue for the English Folk Dance and Song Society, we have an awful lot of biblios with England in them. Here's an example: http://catalogue.efdss.org/cgi-bin/koha/opac-search.pl?idx=ti&q=morris+danc… At first glance, I was worried it was actually searching on 'and' but have tested it with a few biblios that don't have and in any form in them (not easy to find!). It only looks as if it's searching on 'and'. Obviously we've got the highlighting switched on, because it's useful, most of the time. Other settings: QueryAutoTruncate is set to "only if * is added" QueryFuzzy is set to "Don't try" to match words of the same base in a search. Are there other settings I should look at? Should I file a bug? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

2 1