- Koha - lists.katipo.co.nz

Call for news: November 2014
by Koha News 19 Nov '14

19 Nov '14

Fellow Koha users ~ We're collecting news for the November newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- * News items can be of any length. * Anything and everything Koha. * Submit by the 26th. If you are working on an interesting project or development related to Koha, please let us know and we'll include it in the development section. -- Chad Roseburg Joanne Dillon Editors, Koha Newsletter

1 0

A Road Map for Koha
by Bob Birchall 19 Nov '14

19 Nov '14

Until the release of Koha 3.2, the project maintained a Road Map which listed the features planned for the release. After 3.2 we switched from feature based releases to time based releases and the Road Map became less critical. Nonetheless road maps were produced for (at least) Koha 3.8 <cid:part1.06080905.05050701@calyx.net.au> and 3.12 <cid:part2.08030500.03020204@calyx.net.au>. On the sidelines of the KohaCon14 Hackfest, we had a discussion about the future of Koha and decided to propose to reintroduce the Road Map. This time an important difference will be that it is not time (release) based. The idea is to present a list of features that are planned for future releases, with just a couple of lines of description of each. Each heading can link to another page to provide a full RFC. Present in the discussion were Chris C, Paul P, Arnaud, Jonathan, Katrin, Brendan, Joy, Tomas, Bernardo and BobB. We agreed on the following proposal: 1. To maintain a road map for Koha - that is not time based. 2. The road map is to address both features and architecture. 3. The monthly general meeting following each major release will consider updates to the road map. 4. However maintenance of the road map can be a continuous process. This led to discussion of the state of the wiki and also to ways of promoting the project more broadly. (We noted some recent press releases from the major closed source companies, announcing features that have been in Koha since, in one example, 2000! So we felt its a problem that we don't promote more what Koha already does.) Therefore we propose two new roles in the community release team. These are roles that could be effectively filled by librarians (one for each role, or a team), allowing developers to keep developing. _Wiki Curator_ - a lot of work needs to be done to clean up the wiki; - could also participate (with some developers) in updating the wiki technology; - the role is not seen as a controller of wiki content or as being required to approve content, rather it is a curation task: moving stuff around, keeping it tidy, collaborating with the wiki contributors (So, looking at stuff and asking: Is this correct? Does it need to be updated? Should it be moved? Renamed? etc) _Communication Manager_ - promote the project and its achievements; - gather press releases and stories; - liaise closely with the newsletter editors (Chad and JD); - update the koha-community.org website; - send items to Marshall Breeding or other distribution sites; - write articles or twist the arms of others who might write articles. We'll seek endorsement of these ideas at an upcoming IRC General Meeting. Bob Birchall Calyx

5 6

A small gift from KohaCon14
by Tomas Cohen Arazi 19 Nov '14

19 Nov '14

KohaCon14 is past. We had a great time and were really happy to host it. This is a small gift we prepared for the community during that awesome week we shared. Hope you enjoy it :-D https://www.youtube.com/watch?v=uHav6PL_4Bo The conference was possible because of the hard work of: Andrea Capdevila (comitee), Victoria Paganini (comitee), Gabriela Cuozzo (comitee), Lucas Yrusta (comitee), Roberto Cattaneo (comitee), Veronica Lencinas (comitee), Pablo Albertinazzi (design), Mel Quevedo (logistics), Magui Saal (photos / video), Pilar Vega (photos / video), Gustavo Spertino (logistics), Carlos Facciano (logistics), Ezequiel Gómez (logistics). We are especially grateful to the rector of UNC, Francisco Tamarit, for his unconditional support of KohaCon14 and the Koha project. Thanks everyone! Tomás and Bernardo

10 9

[Bug 11559 - Professional Cataloging Interface]
by Iming Chan 19 Nov '14

19 Nov '14

Just browse through the release note for 3.18.0 Beta and didn't see above improvement made to this upgrade! Very disappointed and frustrated as professional catalogers have to put up with the novice interface for another 6 months! ----- Iming Chan Translib Information Service Melbourne, Australia http://opac.translib.com Phone: +61 3 9801 5097 Fax: +61 3 9801 4024 E-mail: iming(a)translib.com -- View this message in context: http://koha.1045719.n5.nabble.com/Bug-11559-Professional-Cataloging-Interfa… Sent from the Koha-general mailing list archive at Nabble.com.

2 2

Fwd: Koha 3.16.03 Opac No results found!
by Rachel Hamilton-Williams 19 Nov '14

19 Nov '14

-------- Forwarded Message -------- Subject: Koha 3.16.03 Opac No results found! Date: Wed, 19 Nov 2014 09:25:44 +0200 (EET) From: Ozkan OZMEN <ozkanozmen(a)balikesir.edu.tr> To: koha-owner(a)lists.katipo.co.nz Hi all, I moved koha 3.16.01 database on test machine to koha 3.16.03 on another machine. And I run zebra normally. I showed that catalog search in intranet is correct but I got a warning that "No results found!" for same search in opac. I looked system preferences but everything seems correct. Do you have any idea for this problem? Thanks for your help. Regards, Özkan Özmen Balikesir University Balikesir/Turkey YASAL UYARI: Bu elektronik posta ve onunla iletilen butun dosyalar kisiye ozeldir ve sadece gondericisi tarafindan almasi amaclanan yetkili gercek ya da tuzel kisinin kullanimi icindir. Eger soz konusu yetkili alici siz degilseniz bu elektronik postanin icerigini aciklamaniz, kopyalamaniz, yonlendirmeniz ve kullanmaniz kesinlikle yasaktir. Bu mesajin gonderilmek istendigi kisi degilseniz (ya da bu e-posta'yi yanlislikla aldiysaniz), lutfen yollayan kisiyi haberdar ediniz ve mesaji sisteminizden derhal siliniz. Kurumumuz, bu mesajin icerdigi bilgilerin dogrulugu veya eksiksiz oldugu konusunda herhangi bir garanti vermemektedir. Bu nedenle bu epostanin ne sekilde olursa olsun iceriginden, iletilmesinden, alinmasindan ve saklanmasindan kurumumuz sorumlu degildir. Bu mesajdaki gorusler yalnizca gonderen kisiye ait olup, her zaman kurumumuzun goruslerini yansitmayabilir. Bu e-posta, bilinen butun bilgisayar viruslerine karsi anti-virus sistemimiz tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hukuki ve mali hic bir sorumlulugu kabul etmez. DISCLAIMER: This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any dissemination, forwarding, copying or use of any of the information is strictly prohibited. If you are not the intended recipient (or have received this e-mail by mistake), please notify the sender and delete it from your system immediately. Our university makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. The opinions expressed in this message may belong to sender alone and may not necessarily reflect the opinions of our university. This e-mail has been scanned by our anti-virus system for all known computer viruses. In doing so, however, sender cannot guarantee that virus or other forms of data corruption may not be present and do not take any legal or financial responsibility in any occurrance.

2 1

Recover deleted books
by Jorge de Cardenas 18 Nov '14

18 Nov '14

I had a similar problem not long ago and discovered that at least on my system the table structure of the deleted tables did not match the structure of their counter parts. The result was that directly inserting from the deleted tables did not match up and data was lost. In other words even though the tables had the same fields they were not in the same order. I was using something I found online. insert into biblio (select * from deletedbiblio where biblionumber=100); delete from deletedbiblio where biblionumber=100; insert in to items (select * from deleteditems where biblionumber=100); delete from deleteditems where biblionumber=100; insert in to biblioitems (select * from deletedbiblioitems where biblionumber=100); delete from deletedbiblioitems where biblionumber=100; What I did was restored a backup to a test server and created a tables to use to restore from on the live server. Jorge >We accidently deleted about 100 books a few weeks ago and would like to recover them. We have a list of the barcodes and titles. What would be the best way to do this? >Thanks, >Paul Dokken >Software Developer >SIL PNG Communication and Technology Services >Ukarumpa EHP 444 | Papua New Guinea -- Jorge de Cardenas | Head Systems Administrator 3512 Darrow Road, Stow, OH 44224 330 688-3295, ext 106 | FAX 330 688-0448 | www.smfpl.org | <http://www.facebook.com/SMFPL> <http://twitter.com/smfpl> <http://pinterest.com/smfpl/boards> If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the institution.

2 1

Koha-NA General Meeting - Thursday, December 11th, 1pm EST
by Nick Clemens 18 Nov '14

18 Nov '14

Hi All, The next meeting of the Koha-NA group will be Thursday, December 11th at 1pm EST The link to join (via Blackboard) is: https://sas.elluminate.com/m.jnlp?sid=2011591&password=M.CAB86B29B91D359A10… First time participants on this platform will find this information helpful: http://support.blackboardcollaborate.com/ics/support/default.asp?deptID=833… This meeting will be a review voting results for the 2015 NAKUG meeting plus any general business To sign up for the KohaNA mailing list: http://lists.bywatersolutions.com/mailman/listinfo/kohana -- Nick Clemens Quechee & Wilder Libraries Nick(a)quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341

1 0

Report help needed
by Elaine Bradtke 18 Nov '14

18 Nov '14

I have a request for a report that is beyond my paltry abilities and that of the report builder. I have this, and it works (thanks Liz!): SELECT biblio.biblionumber,biblio.title,biblio.notes,biblioitems.publishercode,biblioitems.itemtype FROM biblioitems LEFT JOIN biblio USING (biblionumber) WHERE biblioitems.itemtype='CR' But I need to add in more columns that involve the MARC XML Specifically 780 t (previous title) 780 w (previous control no.) 866 a (holdings) 866 z (note) 867 e (source) When I try to add in: Extract value ExtractValue(marcxml, '//datafield[@tag="780"]/subfield[@code="t"]') I manage to break the above query and it complains of syntax errors. Does it matter where this Extract phrase comes in? How do you handle multiple subfields (780 t and w for instance) For that matter, how do you handle multiple fields? And how can I label the columns The following (and a few variations on the theme) did not work: SELECT biblio.biblionumber,biblio.title,biblio.notes,biblioitems.publishercode,biblioitems.itemtype ExtractValue(marcxml, '//datafield[@tag="780"]/subfield[@code="t"]') ExtractValue(marcxml, '//datafield[@tag="780"]/subfield[@code="w"]') ExtractValue(marcxml, '//datafield[@tag="866"]/subfield[@code="a"]') ExtractValue(marcxml, '//datafield[@tag="866"]/subfield[@code="z"]') FROM biblioitems LEFT JOIN biblio USING (biblionumber) WHERE biblioitems.itemtype='CR' As always I am very, very grateful for whatever help you can give. Thanks -- 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 2

2015 Koha North America User's Group - Proposed Sites
by Jason Robb 18 Nov '14

18 Nov '14

Three contenders have thrown in to host the 2015 Koha North America User's Group Meeting. Each proposal has been posted to the Koha North America Wiki: http://koha-na.org/index.php/2015_Meeting_Site_Proposals Please take a moment to read through all three proposals. A survey will be sent later this week so you can vote for your favorite! Stay tuned to the KohaNA mailing list (sign up at http://lists. bywatersolutions.com/mailman/listinfo/kohana) for more information. Jason Robb SEKnFind Coordinator Southeast Kansas Library System jrobb(a)sekls.org

4 3

Koha Training
by Vinod Kumar Mishra 18 Nov '14

18 Nov '14

Dear All, Its my pleasure to inform you that Nehru Library, College of Agriculture Campus, Indira Gandhi Agricultural University, Raipur Chhattisgarh is going to organize Training Program on Koha Library management software on 22-23 November, 2014 and Myself and Mr. D.P. Tripathi is invited to share our knowledge on the said topic. To participate in the event you may contact to Dr. Madhav Pandey at : http://www.igau.edu.in/lib_librarian.htm Hope to meet many professionals who is eager to learn and implement Koha at their libraries and get our untiring free of cost support in implementations of the same. Thanking You. With regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librarian(a)rediffmail.com : mishravk79(a)gmail.com

1 0