- Koha - lists.katipo.co.nz

Re: [Koha] Biblio deletion
by Adalid Ortiz 26 Jan '12

26 Jan '12

Home Tools Batch item deletion Felipe Adalid Ortiz Anzaldo Bibliotecario de sistemas Universidad Iberoamericana Tijuana Biblioteca Loyola http://clavius.tij.uia.mx Ave. Centro Universitario 2501 Playas de Tijuana 22200, Tijuana, B.C. 0 664 630-1577 Ext. 623 adalid(a)tij.uia.mx "En una jerarquía, el poder lo tiene quien guarda secretos; en una red el poder lo obtiene quien disemina información. -John Perry Barlow-> >Subject: [Koha] Biblio deletion > From: library <library(a)katikaticollege.school.nz> > Date: Fri, 27 Jan 2012 09:33:03 +1300 > To: koha(a)lists.katipo.co.nz > >Goodmorning > >Can anyone direct me to instructions on how to batch delete biblio records. >I managed to batch delete the items attached to the records and now I need >to delete the records themselves, but I really don't want to do this one at >a time for over 1100 records. Or have I misunderstood the process >entirely. > >Best wishes >Ann Murphy >Librarian >Katikati College > >amurphy(a)katikaticollege.school.nz >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Biblio deletion
by library 26 Jan '12

26 Jan '12

Goodmorning Can anyone direct me to instructions on how to batch delete biblio records. I managed to batch delete the items attached to the records and now I need to delete the records themselves, but I really don't want to do this one at a time for over 1100 records. …Or have I misunderstood the process entirely. Best wishes Ann Murphy Librarian Katikati College amurphy(a)katikaticollege.school.nz

1 0

Koha 3.6.3 is now available
by Chris Nighswonger 26 Jan '12

26 Jan '12

It is with pleasure that I announce the release of Koha 3.6.3. The package can be retrieved from: http://download.koha-community.org/koha-3.06.03.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.06.03.tar.gz.MD5 http://download.koha-community.org/koha-3.06.03.tar.gz.MD5.asc http://download.koha-community.org/koha-3.06.03.tar.gz.sig Release notes for 3.6.3 are below. Come and get it! RELEASE NOTES FOR KOHA 3.6.3 26 Jan 2012 ======================================================================== 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.6.3 can be downloaded from: http://download.koha-community.org/koha-3.06.03.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.6.3 is a bugfix/maintenance release. Highlights of 3.6.3 ====================== 6627 blocker [security] insecure file creation 2830 critical Hold not removed when "trapped" item on hold shelf is checked out to a different patron in the holds queue 3651 critical Require patron login to send shelves and baskets 5533 critical marking item lost diff in two places 6292 critical Overdue notices have a bug when multiple overdues exist 7193 critical can't remove end date from subscriptions 7360 critical Importing a SQL file for frameworks based on Default Framework deletes the default framework 7370 critical Longoverdue cronjob claims Undefined subroutine &main::LostItem 7394 critical Broken detail page for last link from result page 7407 critical HidePatronName not working anymore 2012 major Add bilio crashes under no zebra 6302 major Failing to send email notices - to_address not set 7226 major Can't add tags on list 7282 major invalid language selection Bugs fixed in 3.6.3 ====================== 2307 normal Calendar widget cannot be translated 3431 normal Catalog by itemtype report pulling from holdingbranch 4300 normal Display 866z summary holdings public note in OPAC 5226 normal MARC21 field 545 missing 5369 normal se queries with paranthesis fail 6098 normal zebra conf NSB NSE indexed as space 6142 normal CanBookBeReserved function is redefined in C4/ILSDI/Utility.pm 6374 normal Use "size" as names/hash keys leads to an unexpected results when using Template::Toolkit (name of a virtual method there) 6466 normal hung socket read causes SIP tests to fail 6700 normal Better handling of version numbers in updatedatabase 6717 normal Sub total doubled up on borrower pay fines page 6885 normal Superlibrarian users can't delete items from another library when IndependantBranches 7097 normal HidePatronName not hiding in all places 7266 normal overdue.pl : filter on flags "debarred" "suspended" and "gonenoaddress" not working 7276 normal member entry Performance improvement 7277 normal keyword mapping needs spaces in the OPAC 7311 normal Error when records have UNIMARC 461$0 or 773$0 for something other than bibnumber 7313 normal Untranslatable strings in 'search to hold' feature 7328 normal Expanded options in advanced search 7332 normal Translated title (MARC21 field 242) doesn't display 7338 normal link to serial detail wrong 7349 normal Sorting patron search result by cardnumber doesn't work 7356 normal Fix various typos and mis-spellings 7361 normal 'Default' encoding in staged marc import breaks diacritics 7363 normal Downloading a list in CSV format doesn't work 7381 normal wrong isbn showing on the staff search results 1623 enhancement Retain history of approved comments 3184 enhancement Show creator and budget receiving a document 5327 enhancement Unit tests required for all C4 modules 5565 enhancement Default OAI UNIMARC to Dublin Core XSL adds superfluous blanks 5607 enhancement Make fields from issues table available in overdues 5729 enhancement Add coins information to the intranet 6015 enhancement Enhancing the performance test suite 6193 enhancement Use memcached cache koha-conf.xml configuration variables 6787 enhancement NORMARC needs a Fast Add framework 6990 enhancement TransformKohaToMarc enhancement 7079 enhancement Default values for German system preferences (web installer) 7143 enhancement Bug for tracking changes to the about page 7220 enhancement Add IDs to check-in message dialogs to facilitate CSS customization 7240 enhancement Cleaning up import tables and action_logs 7247 enhancement rebuild_zebra.pl -v should show all Zebra log output 7278 enhancement In the items table, make items.materials of type text, and show its contents at circulation 7324 enhancement Show alternate email as mailto link on patron summary 7326 enhancement longoverdue.pl was hardcoded to 1 year, is now a parameter 7364 enhancement Fast-Add framework doesn't always get the branch for item creation 7373 enhancement new bridge icons 7439 enhancement Mailmap for git shortlog System requirements ====================== Changes since 3.4: * Perl 5.10 is required 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, only the English version of the Koha manual is available: http://manual.koha-community.org/3.6/en/ 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 (Taiwan) * Danish * English (USA) * English (UK) * French (France) * German * Italian * Portuguese (Brazil) * Spanish Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://wiki.koha-community.org/wiki/Translating_Koha 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.6 is Release Manager: Chris Cormack <chrisc(a)catalyst.net.nz> Documentation Manager: Nicole C Engard <nengard(a)gmail.com> Translation Manager: Frédéric Demians <frederic(a)tamil.fr> QA Manager: Ian Walls <ian.walls(a)bywatersolutions.com> Bug Wranglers: MJ Ray, Marcel de Rooy, Paul Poulain, Mason James Release Maintainer (3.4.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.6.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Credits ====================== We thank the following libraries who are known to have sponsored new features in Koha 3.6: * Los Gatos Public Library * NEKLS * East Brunswick Public Library * Athens County Public Libraries * Horowhenua Library Trust * Halton Borough Council * South Taranaki District Council We thank the following individuals who contributed patches to Koha 3.6.3. 1 Tomas Cohen Arazi 1 Alex Arnaud 2 Marc Balmer 2 D Ruth Bavousett 6 Jared Camins-Esakov 1 Frédérick Capovilla 1 Garry Collum 15 Chris Cormack 1 Christophe Croullebois 8 Frédéric Demians 3 Connor Dewar 2 Nicole Engard 2 Magnus Enger 14 Katrin Fischer 4 Chris Hall 1 Srdjan Jankovic 1 Admin User Koha 2 Henri-Damien Laurent 12 Owen Leonard 1 Frère Sébastien Marie 1 Jesse Maseto 1 James Mason 2 Julian Maurice 3 Sophie Meynieux 5 Chris Nighswonger 1 Albert Oller 1 Dobrica Pavlinusic 10 Paul Poulain 2 Liz Rea 7 Marcel de Rooy 1 Fridolyn SOMERS 1 Sam Sanders 5 Adrien Saurat 11 Duncan Tyler 5 Ian Walls We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patches(a)lists.koha-community.org. 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.6.x (i.e., this version of Koha and future bugfix releases) is 3.6.x. The next major feature release of Koha will be Koha 3.8.0. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Ehara taku toa i te toa takitahi, engari he toa takitini ##### Autogenerated release notes updated last on 26 Jan 2012 15:06:56 Z #####

1 0

Deleted authorities
by Stefano Bargioni 26 Jan '12

26 Jan '12

Hi, I'm looking for a way to trace deleted authorities. A table for biblio is deletedbiblioitems, but I found no deletedauth_header or something similar for auth records. I only need the auth_id. Any idea? Thanks. Stefano

1 0

installing koha on hosted server?
by lionalx 26 Jan '12

26 Jan '12

hey, sorry if im out of line asking this here, but didnt find answers in documentation pages. im experienced home linux user, but dont have much knowledge about servers, expect installing wordpress and drupals.. i got an impression that ur installation guidelines assume im running my own server, but will i be able to install it on average paid linux hosting? do i need to look for specific feature(s)? thx, alex -- View this message in context: http://koha.1045719.n5.nabble.com/installing-koha-on-hosted-server-tp543245… Sent from the Koha-general mailing list archive at Nabble.com.

2 1

Official Koha Newsletter: Volume 3, Issue 1: January 2012
by Daniel Grobani 26 Jan '12

26 Jan '12

[Below is the text of the newsletter. For active links and a more readable format, please visit http://koha-community.org/koha-newsletter-volume-3-issue-1-january-2012] Official Koha Newsletter (ISSN 2153-8328) Volume 3, Issue 1: January 2012 Edited by Daniel Grobani, Koha Community Newsletter Editor. Please submit news items to danielg.koha(a)gmail.com. Table of Contents Koha Development Koha 3.6.3 Status Koha 3.4.8 Status Database Schema Bugs PostgreSQL Support Koha Community New Koha Libraries Community Gossip Donum: a Norwegian Koha Co-op Catalyst Open Source Academy 2012 Past Koha Events January General IRC Meeting Global Bug Squashing Day 2012-01-06 Upcoming Koha Events February General IRC Meeting Global Bug Squashing Day 2012-02-08 Marseille Hackfest KohaCon12 Koha Development Koha 3.6.3 Status by Chris Nighswonger The 3.6.x branch is in a string freeze. Koha 3.6.3 is scheduled for release on 25 January 2012. Koha 3.4.8 Status by Chris Nighswonger Koha 3.4.8 is scheduled for release on 28 January 2012. Database Schema Bugs Paul Poulain and Jonathan Druart have created a new wiki page, http://wiki.koha-community.org/wiki/DB_schema_bugs, documenting problems they’ve identified with Koha’s database design. They invite the community to read, add to, or discuss this page. PostgreSQL Support Marc Balmer plans to begin work on PostgreSQL support during the March hackfest in Marseille in order to pave the way for future PostgreSQL support in Koha. For more info, see http://wiki.koha-community.org/wiki/PostgreSQL. Koha Community New Koha Libraries Bethel University (via ByWater Solutions) Mental Health and Education Resource Centre, Christchurch (via Catalyst) New Zealand Institute of Chartered Accountants (via Catalyst) 246 libraries in the Philippines went live with Koha in the last year. For more info, see http://web.nlp.gov.ph/nlp/?q=node/2300. Community Gossip ByWater Solutions has an opening for a Development Specialist. Chris Cormack has posted a summary of Koha accomplishments in the year 2011 at http://blog.bigballofwax.co.nz/2012/01/01/2011-and-koha-by-the-numbers/. Chris has also posted sign-off statistics for December at http://blog.bigballofwax.co.nz/2012/01/23/sign-off-statistics-for-december/. Nicole Engard has been promoted to Vice President of Education at ByWater Solutions. Melia Meggs has been promoted to Chief Operations Officer at ByWater Solutions. Equinox Software has formed a Canadian subsidiary. Ian Walls, Koha 3.8 QA manager, has left ByWater Solutions for a position at the University of Massachusetts Amherst. Bob and Irma Birchall from Calyx and Chris Cormack and Kathryn Tyree from Catalyst will be holding a combined Koha stand at Vala2012 in Melbourne from 6-9 February. For more info, see http://www.vala.org.au/vala2012/conf2012. Donum: a Norwegian Koha Co-op by Magnus Enger Donum — Frie biblioteksystemer SA is a co-op that aims to further its members’ economic interests by cooperating in building, developing, and managing software, translations, knowledge, and networks. The co-op will also mediate relevant contracts and generate spin-offs and user utility by helping to promote and increase knowledge about free library systems and the values they build upon, both in the private and public sector. It also aims to assist with the development and delivery of services related to such systems. The main activities will be to carry out, organize, maintain, and quality check translations, as well as marketing, training and development of Koha and other free software for the library sector in Norway. The co-op will function as a network and maintainer of fora and meeting places through activities such as organizing user meetings, seminars, and conferences. The co-op will benefit its members through prioritized and possibly discounted access to training, conferences etc. It will also aid in organizing cost-sharing for new developments related to relevant software. For more info, see http://donum.no/. Catalyst Open Source Academy 2012 by Chris Hall, Chris Cormack, Grant Patterson, Javier Romero Twenty-three high school students from around New Zealand took the opportunity to learn more about open source software development during their summer holidays by participating in the Catalyst Open Source Academy 2012. In the first week, the students learned to install Ubuntu Linux on their training laptops, familiarised themselves with what the terms Freedom and Community mean for open source projects, and learned basic programming principles and how the web works. During the second week students worked on an open source project of their choosing. Amongst others there was a Koha group and a group who worked on kiritakikoha, an Android app for Koha (system and end) users. Four students from the Koha project group used jQuery to create graphs for many of the popular SQL reports at http://wiki.koha-community.org/wiki/SQL_Reports_Library. A sample of the graphs made by one student can be viewed at http://opac.koha.workbuffer.org/. These can be adapted to graph almost any SQL report and display it on the OPAC and/or the intranet. The other two students working on the Koha project went through the HTML test report page to improve unit testing coverage. The goal for the week was to increase the percentage of unit testing coverage of Koha by at least 2%, which they did! By the end of the week the Koha project group had: Committed 16 unit tests Changed 300 lines of Koha code Tested 598 lines of Koha code not previously tested (+2.1%) Tested 85 subroutines not previously tested (+2.6%) The group working on kiritakikoha made suggestions for future improvements in the client and in its appearance, e.g. customised icons for small devices. They worked collaboratively to implement the following features: Splitting up the existing search interface into simple and advanced search Highlighting search terms in the search results Displaying book covers from OpenLibrary and Google in the search results Providing a date picker for the place hold dates Displaying currently checked out/overdue Improved support for low-resolution devices Importing library settings via a Quick Response code (2D barcodes which upon scanning with a phone camera can configure kiritakikoha with that library’s settings) The Academy was an opportunity for these students to experience the software development cycle within the open source community and to make valuable contributions to open source projects. Past Koha Events January General IRC Meeting The January general IRC meeting was held on 4 January 2012. For more info, including the agenda and links to the minutes, see http://wiki.koha-community.org/wiki/General_IRC_Meeting,_4_January_2012. Global Bug Squashing Day 2012-01-06 by Magnus Enger Global Bug Squashing Day 2012-01-06 by Magnus Enger A Global bug squashing day was held on Friday, 6 January 2012, and there was much rejoicing. For the numbers, see http://wiki.koha-community.org/wiki/2012-01-06_Global_bug_squashing_day. Upcoming Koha Events February General IRC Meeting The February general IRC meeting will be held on 8 February 2012. For more info, see http://wiki.koha-community.org/wiki/General_IRC_Meeting,_8_February_2012. Global Bug Squashing Day 2012-02-08 by Magnus Enger Global Bug Squashing Days are days designated to a concerted effort to get bugs and patches moving along in the right direction. The next GBSD will be 8 February 2012. For more info, see http://wiki.koha-community.org/wiki/2012-02-08_Global_bug_squashing_day. Marseille Hackfest by Paul Poulain A reminder about the hackfest BibLibre is organizing in Marseille in March! It’s time to book your flights/trains/car/horse/boat, and tell us if you’re coming. We already have 6 people coming (plus all BibLibre staff, of course) from 4 different countries (France, Germany, Croatia, and USA). We have a lot of chairs and desktops still available! If you hope to come but still are not sure, don’t hesitate to email kim.nguyen -at- biblibre.com. Full details are at http://drupal.biblibre.com/en/blog/entry/2012-hackfest-in-europe. KohaCon12 KohaCon12 will take place this June in central Edinburgh, Scotland, UK. The main conference will be held Tuesday, 5 June to Thursday, 7 June. A hackfest will be held Saturday, 9 June to Monday, 11 June. For more info, see http://wiki.koha-community.org/wiki/Category:KohaCon12 and http://wiki.koha-community.org/wiki/Wishlist_for_KohaCon12.

1 0

mysqldump issue with koha database
by cjwalke 25 Jan '12

25 Jan '12

I'm running Koha on two different servers for testing reasons. One has 3.6.2 and is my current active server. I just upgraded the other from 3.2.2 to 3.6.2 with no problems. I copied the koha database using mysqldump from the current server and copied it onto the newly upgraded server. I've run the rebuild_zebra.pl script, but none of the data shows. Searching in the OPAC and Staff Client shows nothing in the catalog. So I checked the koha database using the mysql shell and all the books are listed there, but nothing shows when searching. What am I doing wrong? C.J. Walke, Librarian Maine Organic Farmers and Gardeners Association Unity, Maine - USA -- View this message in context: http://koha.1045719.n5.nabble.com/mysqldump-issue-with-koha-database-tp5429… Sent from the Koha-general mailing list archive at Nabble.com.

4 6

Re: [Koha] [OPEN-ILS-GENERAL] integration of electronic content
by R Sunil Kumar 25 Jan '12

25 Jan '12

Dear All, With regard to e-books, if catalogue the e-books as regular print books and use 956 tags and provide the url link of the exact location and file name of the book, users might be able to access the resources. But i will also be interested to understand how to do e-resources integration. E-resources like EBSCO, Lexis Nexis, ebribary, etc. Thanks and Regards R Sunil Kumar -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: 25 January 2012 02:32 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 75, Issue 53 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: [OPEN-ILS-GENERAL] integration of electronic content (Dan Scott) 2. Re: Availability: No items available: (Deepa Gajendra) 3. Re: Problem with new functionnality Hard Due Dates (Chris Nighswonger) 4. Emailing: proccenterdocx.docx (Hillyard, Cecil) ---------------------------------------------------------------------- Message: 1 Date: Mon, 23 Jan 2012 23:53:19 -0500 From: Dan Scott <dan(a)coffeecode.net> To: Evergreen Discussion Group <open-ils-general(a)list.georgialibraries.org> Cc: Koha list <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] [OPEN-ILS-GENERAL] integration of electronic content Message-ID: <20120124045317.GA6237@denials> Content-Type: text/plain; charset=us-ascii On Mon, Jan 23, 2012 at 04:38:28PM -0800, Lori Bowen Ayre wrote: > Could anyone point me to a library catalog that does a great job > integration e-content into their catalog? I am assuming this will mostly > be e-books unless someone knows a library that has done a great job > integrating databases as well (and could direct me to those libraries-this > wouldn't be evident without an account but I'd still like to know if > someone has done a good job of it so I can talk to them). Define what you mean by "integration of e-content" please? ------------------------------ Message: 2 Date: Tue, 24 Jan 2012 04:16:48 -0800 From: Deepa Gajendra <Deepa.Gajendra(a)Indegene.com> To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Availability: No items available: Message-ID: <62C0B73762251D41BFEDF5B9DC07494E2565DD8B(a)emailla.medschool.local> Content-Type: text/plain; charset="us-ascii" Hi, I am also facing the same problem in Koha. Getting the same error for - Availability: No items available. Please let me know what might be the error. Let me know if I am missing any tag? Thanks & Regards. Deepa Gajendra Senior Associate - Library Services Indegene Lifesystems Pvt. Ltd. Office: +91-80-40787777 Fax: +91-80-41267704 www.indegene.com<http://www.indegene.com/> [cid:image001.jpg@01CCDAC0.25C11A90] ________________________________ Disclaimer This email (including any attachments) contains information, which is confidential and may be subject to legal privilege. If you are not the intended recipient, you must not use, distribute, or copy this email. If you have received this email in error, please notify the sender immediately and delete this. Any views expressed in this mail are not necessarily the views of INDEGENE. Thank you. P Please consider the environment before printing this e-mail

1 0

getting too much result in search
by KLib Tech Support 25 Jan '12

25 Jan '12

Hi, I have installed koha 3.06.02.001,I am getting problem in search when I search item other than english. For example if I search records which are entered in HINDI I get so many results which are not relevant . Can any one help?

2 1

Emailing: proccenterdocx.docx
by Hillyard, Cecil 24 Jan '12

24 Jan '12

<<proccenterdocx.docx>> Hi all, How long does the "temporary" shelving location of PROC stay on the item? When items are being checked in at the owning branch the PROC shelving location is not being changed to its proper location of New Materials or whatever is applicable. Items like this are coming up in holds report and confusing staff. Is it in processing/being cataloged or is it on the shelf? The item in the attached was checked in yesterday but still says Processing Center. __________________________ Cecil Hillyard Washoe County Library -Tel: 775-327-8338 or 7750-327-8330 fax: 775-327-8334

1 0