- Koha-devel - lists.koha-community.org

Items are not added in records
by Prawesh Shrestha 03 Mar '11

03 Mar '11

The items are not added in record. It is not displayed in any view - MARC, ITEM and others. But when items are searched for barcode printing, they are displayed without the features to add to the label. The check box and 'Add' don't appear. If 'Edit Items' is clicked the items are there. I checked the database, no items are written in 'Item' table. i tried the following command: sudo -u koha perl -I /usr/share/koha/lib /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -v -w it output the following: . . . . 13:40:47-03/03 zebraidx(3905) [log] Records: 57000 i/u/d 10/56990/0 13:40:53-03/03 zebraidx(3905) [log] Records: 58000 i/u/d 19/57981/0 13:40:58-03/03 zebraidx(3905) [log] Records: 59000 i/u/d 28/58972/0 13:41:11-03/03 zebraidx(3905) [log] Merge 14.0% completed; 61 seconds remaining 13:41:21-03/03 zebraidx(3905) [log] Merge 40.3% completed; 29 seconds remaining 13:41:31-03/03 zebraidx(3905) [log] Merge 57.6% completed; 22 seconds remaining 13:41:41-03/03 zebraidx(3905) [log] Merge 59.6% completed; 27 seconds remaining 13:41:51-03/03 zebraidx(3905) [log] Merge 70.0% completed; 21 seconds remaining 13:42:01-03/03 zebraidx(3905) [log] Merge 76.0% completed; 18 seconds remaining 13:42:11-03/03 zebraidx(3905) [log] Merge 81.4% completed; 16 seconds remaining 13:42:21-03/03 zebraidx(3905) [log] Merge 87.3% completed; 11 seconds remaining 13:42:27-03/03 zebraidx(3905) [fatal] Bad block size -8 in pos=511075 zebraidx: isamb.c:549: open_block: Assertion `p->size >= 0' failed. ==================== CLEANING ==================== I checked for any changes in settings found no changes at all. Need your help. With regards, -- Prawesh Shrestha Project Engineer --------------------------------------------- Young Innovations Pvt. Ltd. GPO 8976 EPC 241 Pulchowk, Lalitpur, Nepal Tel: +977-01 5009282 http://yipl.com.np info[at]yipl[dot]com[dot]np ----------------------------------------------------

1 0

koha - length of records - separation of items from biblios
by Linda Culberson 03 Mar '11

03 Mar '11

There is an "abandoned RFC" for "Stop copying item records to bib's MARC and MARCXML RFC" . Could someone tell me why this was abandoned, because I think having the item record data exists both in the items table and as MARC fields in the bib record is an a terrible shortcoming of Koha for academic and research libraries with large numbers of items for certain titles. Thank you. -- Linda Culberson lculber(a)mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824

6 7

Subject tracings
by Jared Camins-Esakov 02 Mar '11

02 Mar '11

Hello. Can anyone think of any reason not to specify that subject tracings should match only complete subfields? For example, at the moment, if you are looking at a book about Religions (with a subject term "Religions") in the catalog of a library that does not use Koha's authority control, when you click on the subject tracing in the OPAC, you will be given a result set that contains every single record that has the word "Religions" anywhere in its subject. Including, for example, books with the subject "Christianity and other religions." If we make the query on the subject tracings su,complete-subfield: the only false positives will be items where the subject heading being searched is used for both a main entry and a subdivision, which still seems like a significant improvement over the current behavior. Thoughts? Regards, Jared -- Jared Camins-Esakov Freelance bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins(a)cpbibliography.com (web) http://www.cpbibliography.com/

8 11

Jenkins (formerly known as hudson, until Oracle lost their minds) hosting
by Chris Cormack 01 Mar '11

01 Mar '11

Hi All As you are probably all aware I have been running a hudson (now jenkins) instance on my linode server. It has been invaluable for catching errors and for helping to drive us towards better testing. The problem I now have is that my linode instance is RAM starved with both bugzilla and jenkins on it. So I am looking for volunteers to offer a machine to host jenkins on. Ideally debian (running squeeze) as the packages for jenkins work really well. I would need a login so I could set up and configure jenkins, and get it running all the tests again, but then id be happy to have sudo access revoked and let someone else maintain it. Jenkins is a pile of java, so it is RAM hungry. Conversely I could leave it running on my linode, but others could chip in to help afford the upgrade to the next level to get more ram available. Or any other suggestions? Chris PS the Jenkins story is an interesting one, and one worth reading about, a lot of how not to interact with a free software community lessons to be learnt there.

2 1

Re: [Koha-devel] Script to remove authorities
by Thomas Dukleth 28 Feb '11

28 Feb '11

Sorry, I had not noticed that Henri-Damien Laurent had sent the the authorities deduplication script as an attachment. I have become unaccustomed to looking for attachments to email messages on mailing lists. Thomas Dukleth Agogme 109 E 9th Street, 3D New York, NY 10003 USA http://www.agogme.com +1 212-674-3783

1 0

Script to remove authorities
by LAURENT Henri-Damien 27 Feb '11

27 Feb '11

Hi you will find here a command line script which allows deduping authorities based on the parameters passed. You can test and tell me what you think of that. I also fixed the merge script in C4::AuthoritiesMarc.pm http://git.biblibre.com/?p=koha;a=blob;f=C4/AuthoritiesMarc.pm;h=af99fa632e… I think it is quite handy at the moment. It requires though that your authorities index are declared with completeness and p and you can declare on which index and which data you want to deduplicate $0 --match index/123sub##index2/123a####index2/001 AUTHTYPECODE1 AUTHTYPECODE2 Hope that helps. -- Henri-Damien LAURENT

3 2

Re: [Koha-devel] [Koha] Koha 3.2.5 is now available
by Chris Nighswonger 25 Feb '11

25 Feb '11

On Fri, Feb 25, 2011 at 3:42 AM, <hansbkk(a)gmail.com> wrote: > On Fri, Feb 25, 2011 at 3:05 PM, Magnus Enger <magnus(a)enger.priv.no> > wrote: > >>> Is it safe to just update from 3.2.3 with an existing database? > >>> > >>> If so, is that generally safe with point releases at that third level > >>> (3.2.6 through 2.2.9 but perhaps not 3.3?) > >>> > >>> Does everything just automagically work while the system is in use, or > >>> does Apache or something need to be restarted, or is there an > >>> upgrade-data script that needs to be run? > > > >> Sorry I didn't specifically state my questions are regarding updating > >> automatically via the Debian package management system, not the > >> traditional, more manual methods, whatever those might be. . . > > > > That would be this, from INSTALL.debian > > ( > http://git.koha-community.org/gitweb/?p=koha.git;a=blob_plain;f=INSTALL.deb… > ): > > Thanks much for replying Magnus. The link above returns "no such > project" for me, perhaps a permissions issue? > Works fine from my neck of the woods. Kind Regards, Chris

1 0

Official Koha Newsletter: Volume 2, Issue 2: February 2011
by Nicole Engard 25 Feb '11

25 Feb '11

Please read the newsletter online for live links: http://koha-community.org/koha-newsletter-volume-2issue-2-february-2011/ Official Koha Newsletter (ISSN 2153-8328) Volume 2, Issue 2: February 2011 Table of Contents * Koha Developments o Koha 3.2.5 Available o RFC Roundup: System Administration * Koha in Libraries o South Taranaki District Libraries move to Koha o Koha Article: OSS in Italy o Koha in Mongolia o Koha in the Maldives * Koha Events o KohaCon 2011 in India Koha Developments Koha 3.2.5 Available by Chris Nighswonger Please note: This release is a security release. It is strongly recommended that users apply this upgrade immediately to production systems. If you are installing a new system, please use this version rather than earlier versions. The package can be retrieved from: http://download.koha-community.org/koha-3.02.05.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.02.05.tar.gz.MD5 http://download.koha-community.org/koha-3.02.05.tar.gz.MD5.asc http://download.koha-community.org/koha-3.02.05.tar.gz.sig Release notes for 3.2.5 can be found here. RFC Roundup: System Administration by MJ Ray This month, I’m looking at some Requests For Comments pages about Systems Administration improvement ideas. If you’ve any comments on any of these, please visit the wiki and just edit the pages to add your ideas or comment on the suggestions that are already there. Alternatively, you could start a discussion on the email list or web forum at http://koha-community.org/support/. * Enhance renewals parameters o This page says the suggestion is aimed at Koha 3.4, so time is running out for it. It’s currently the really short idea that “Renewable … should be part of smart-rules.pl and take more parameters into account: ability to renew X time for patron Category Y, for item type Z in Branch A”. Could you tidy this idea up, link it to a bug and get it ready for development? If so, please visit the wiki and help Koha develop. * Managing permissions on acquisition module o This is a more complete request, suggesting we follow a similar model for the acquisitions module as for the tools module, with much more granular permissions. It suggests splitting acquisition permissions into nine smaller permissions which would allow different users to be authorised to do different parts of the process. If you’d like to see the suggested split and maybe suggest groupings or others, go to visit the wiki. * Improving statistics on acquisitions RFC o Well, the other side of monitoring acquisitions is to collect statistics for reporting afterwards. This RFC was aimed at Koha 3.2, so either it needs marking as completed, or it needs updating for 3.4 or 3.6. * Support for Syndetics enhanced content RFC o I think this might already be in Koha 3.2 – at least my Koha site has a Syndetics section in the Enhanced Content system preferences page. If you use Syndetics with Koha, could you update this page to say that it is completed and working, please? * Translation Process: Installer and Javascript libraries improvements o This RFC needs some work to make it clearer what users want from the developers when it comes to installing other languages, and probably linking to an enhancement bug. * Guided reports serials RFC o A plan to expand the guided reports concept to the serials table, sponsored by St Etienne University and developed by BibLibre, expected for/deadline: 2011-05-01 – I think that will make it just miss Koha 3.4′s release, so there should still be time to comment on the wiki. Please Contribute! Please, if you have any feedback or encouragement for any of the above, follow the link and add comments, or start a discussion. It really does make a difference, helping Koha to develop in the best way possible, in collaboration between users and developers. Koha Libraries South Taranaki District Libraries move to Koha by Susan McMillan The South Taranaki District Council (STDC) Libraries are pleased to announce that they are changing to Koha in March. While initially skeptical that a “free” system could provide for the needs of a modern public library (in South Taranaki’s case made up of seven branches), staff were pleasantly surprised with the features that Koha offers straight out of the box. After Council’s IT Manager, Pete Sayers and Customer Services Librarian, Cath Sheard, attended Koha10 conference last year the IT department decided to trial Koha. Soon Cath and I were getting emails and excited phone calls from IT telling us how they had set up a borrower, added a book (their cataloguing was abysmal!) and issued items to themselves … all with no training or library knowledge what-so-ever. Cath and I soon had some MARC records imported, set up lending rules, Google book covers, carousels and personalised the OPAC. What we found tricky was the change in terminology between our current management system and that used in Koha. We are looking forward to going live with Koha after Taranaki Anniversary weekend on 14 March. Koha Article: OSS in Italy by Zeno Tajoli Abstract: Koha is an open-source Integrated Library System (ILS) developed in New Zealand and deployed for the first time in January of 2000 for Horowhenua Library Trust. Koha is a full-fledged software with basic and advanced features. Koha has also a strong and wide community of librarians and developers. In particular, it is suitable to all institutions who want to automate their libraries using a system that allows a complete control over data and over software itself. CILEA worked to adapt Koha to Italian libraries and now it is a part of the community. * The official link: http://dx.doi.org/10.1108/10650751111106555 * The post-print link: http://eprints.rclis.org/handle/10760/15340 Koha in Mongolia by J. Begzsuren Central Public Library of Ulaanbaatar in Mongolia has been working to implement Koha in our library since August, 2010. As of now we have successfully tested the conversion of our Softlink Alice “ansi” database into a Koha “unicode” database. Our partners are KOICA, volunteer He Shin Young, librarian and Mongolian Libraries Consortium Gantulga, IT specialist. This is the first library in Mongolia to implement Koha to a public library and the first known ansi database conversion. We are still working on conversion but our system will be live soon at http://koha.pl.ub.gov.mn. Koha in the Maldives by Aminath Riyaz Koha is making waves in the Maldives library sector. A few personnel from the Maldives library and information sector have been exposed to Koha briefly during the last few years, at the short term training programs hosted by the SAARC Documentation Center, New Delhi, India. Koha made a loud enough impact in the Maldives with the formation of DLNetSA (Digital Library Network of South Asia) in July 2010. This was followed by a “training of trainers” workshop on Koha held in Male’, Maldives, organized by the Maldives Greenstone support Network and facilitated by resource persons from HealthNet Nepal. A trial database was hosted by HealthNet Nepal at http://115.187.27.13. With online support of HealthNet Nepal, Maldives Library Association (MLA) is introducing Koha to the libraries in the Maldives. As a first step, the MLA will be setting up Koha in four libraries selected strategically from different parts of the island nation. More information about this pilot project is available at http://infomalias.wordpress.com/2011/01/29/computerise-your-library. The interest shown by the library sector is overwhelming. This is not unexpected, as there are only a few libraries in the country with even an online library catalogue. The only library known to be using an integrated library system at present is the Maldives National University Library. The MLA is very enthusiastic about this endeavor and is very thankful for the support from HealthNet Nepal, University of Waikato, and the Maldives Greenstone support Network. This project is a huge step for MLA given the small group of Library and Information Science professionals in the country. Koha Events KohaCon 2011 in India by Nicole C. Engard The KohaCon 2011 Location Survey is closed. We had a total of 877 responses. If you voted for a location as your first choice it got 4 points, your second choice 3 points, and so on. Below is the break down in points. * Thane, India [ End October - Beginning November ] 2640+150+62+33= 2885 * Kathmandu, Nepal [ November / December 2011 ] 432+96+186+24= 738 * Kolkata, India [ November / December 2011 ] 156+339+104+33= 632 * Somerset or Bristol, UK [ September / October 2011 ] 160+141+72+108 = 481 A break down of results can be found here and raw results available upon request. Even if we ignore votes from those who didn’t fill in all the information I’m pretty sure we have a winner. In addition, I recommend that we soon move on to voting for the location for 2012 so that we can get on top of things and conference planners have more time to prepare. Newsletter edited by Nicole C. Engard, Koha Documentation Manager. Please send future story ideas to me.

1 0

Re: [Koha-devel] [Koha] Koha 3.2.5 is now available
by Magnus Enger 25 Feb '11

25 Feb '11

On 25 February 2011 09:00, <hansbkk(a)gmail.com> wrote: >> Is it safe to just update from 3.2.3 with an existing database? >> >> If so, is that generally safe with point releases at that third level >> (3.2.6 through 2.2.9 but perhaps not 3.3?) >> >> Does everything just automagically work while the system is in use, or >> does Apache or something need to be restarted, or is there an >> upgrade-data script that needs to be run? > Sorry I didn't specifically state my questions are regarding updating > automatically via the Debian package management system, not the > traditional, more manual methods, whatever those might be. . . That would be this, from INSTALL.debian (http://git.koha-community.org/gitweb/?p=koha.git;a=blob_plain;f=INSTALL.deb…) UPGRADE ======= If you are upgrading from a previous installation of Koha 3, you can use the following: ./koha_perl_deps.pl -u -m # to identify new Perl dependencies perl Makefile.PL --prev-install-log /path/to/koha-install-log make make test sudo make upgrade After you have done that you should immediately go to your Intranet and if there are required changes to the database you will be prompted to login and and the web installer will do the updates for you. The OPAC will display a "this system is under maintenance" type message until you have done that. I imagine that last bit would work much the same way with the packages, although I haven't had much time to play with them yet... Best regards, Magnus Enger libriotech.no

1 0

Koha 3.2.5 is now available
by Chris Nighswonger 24 Feb '11

24 Feb '11

Please note: This release is a security release. It is strongly recommended that users apply this upgrade immediately to production systems. If you are installing a new system, please use this version rather than earlier versions. It is with pleasure that I announce the release of Koha 3.2.5. The package can be retrieved from: http://download.koha-community.org/koha-3.02.05.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.02.05.tar.gz.MD5 http://download.koha-community.org/koha-3.02.05.tar.gz.MD5.asc http://download.koha-community.org/koha-3.02.05.tar.gz.sig Release notes for 3.2.5 are below. Come and get it! RELEASE NOTES FOR KOHA 3.2.5 - 24 February 2011 ======================================================================== Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.2.5 can be downloaded from: http://download.koha-community.org/koha-3.02.05.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation Highlights of 3.2.5 ====================== NOTE: This release is a security release. It is strongly recommended that users apply this upgrade immediately to production systems. If you are installing a new system, please use this version rather than earlier versions. Bugs fixed in 3.2.5 ====================== 1953 remove possible SQL injection attacks 2742 Wrong language name in the preferences 5745 overdues with fines not showing titles 5759 When printing a borrowers information the secondary email address is not printed 5769 notice tab disappearing on edit patron System requirements ====================== Changes since 3.0: * The minimum version of Perl required is now 5.8.8. * There are a number of new Perl module dependencies. Run ./koha_perl_deps.pl -u -m to get a list of any new modules to install during upgrade. Upgrades ====================== The structure of the acquisitions tables have changed significantly from 3.0.x. In particular, the budget hierarchy is quite different. During an upgrade, a new database table is created called fundmapping that contains a record of how budgets were mapped. It is strongly recommended that users of Koha 3.0.x acquisitions carefully review the results of the upgrade before resuming ordering in Koha 3.2.x. Documentation ====================== As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, several translations of the Koha manual are available: English: http://koha-community.org/documentation/3-2-manual/ Spanish: http://koha-community.org/documentation/3-2-manual-es/ French: http://koha-community.org/documentation/3-2-manual-fr/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations ====================== Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * Chinese * Danish * English (New Zealand) * English (USA) * French (France) * French (Canada) * German * Greek * Hindi * Italian * Norwegian * Portuguese * Spanish * Turkish Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://www.kohadocs.org/usersguide/apb.html for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha-community.org/ Release Team ====================== The release team for Koha 3.2 is Release Manager: Galen Charlton <gmcharlt(a)gmail.com> Documentation Manager: Nicole Engard <nengard(a)gmail.com> Translation Manager: Chris Cormack <chris(a)bigallofwax.co.nz> Release Maintainer (3.0.x): Henri-Damien Laurent <henridamien.laurent(a)biblibre.com> Release Maintainer (3.2.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Credits ====================== We thank the following individuals who contributed patches to Koha 3.2.5: Owen Leonard Chris Nighswonger marcel(a)libdevelop.rijksmuseum.nl Paul Poulain We regret any omissions. If a contributor has been inadvertantly missed, please send patch against these release notes to koha-patches(a)lists.koha-community.org. The 3.2.x Release Maintainer especially thanks the 3.4 Release Team and all who participated in QA for their diligent labors in testing and pushing well over 330 patches since the 3.2.0 relese. Their continued work very much makes possible the release of 3.2.5 on its announced schedule. Revision control notes ====================== The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of git://git.koha-community.org/koha.git The branch for Koha 3.2.x (i.e., this version of Koha and future bugfix releases) is 3.2.x. The next major feature release of Koha will be Koha 3.4.0. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Naku te rourou, nau te rourou, ka ora ai te iwi.

2 1