Re: [Koha] values for syspref QueryRemoveStopwords
I'd like to see it and the nozebra one both go. Chris On Sep 5, 2012 4:49 AM, Nicole Engard neng...@gmail.com wrote: On Tue, Sep 4, 2012 at 11:52 AM, Tomas Cohen Arazi tomasco...@gmail.com wrote: It doesn't have any effect whether you choose one or the other. NoZebra is hard deprecated in Koha 3.8, and that syspref only applies on NoZebra installs. So, should we remove the preference? Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] values for syspref QueryRemoveStopwords
On 5 September 2012 08:15, Mathieu Saby mathieu.s...@univ-rennes2.fr wrote: Thank you for these explanations. From a mere librarian point of view, if nozebra is completely out of date, it should be a good idea to delete all trace of it. That's the plan. There is already s many sysprefs to check when you install Koha... Yep, that's the beauty of Koha, you can make it work your way, not the way I think you should have to work :) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Volunteers for the 3.12 release
It's that time again, we are sorting out volunteers to work on the 3.12 release http://wiki.koha-community.org/wiki/Roles_for_3.12 If there is a role you think you would be good at, please sign up Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Availability: No items available
Just to confirm you ran the remove items from biblioitems script right? Not just rebuild zebra, but both of them? Chris On Aug 24, 2012 10:11 PM, umer habib umerhabi...@yahoo.com wrote: Hi Sorry there was some problem with my mailbox so i didnt recieve your email last day. I have tried running this utility using --run it updates all the records and then i ran rebuild_zebra.pl -b -r as was suggested in remove_items_from_biblioitems.pl script but my issue is not resolved. It is still giving availability: no items available regards From: Robin Sheat ro...@catalyst.net.nz To: umer habib umerhabi...@yahoo.com Cc: koha@lists.katipo.co.nz koha@lists.katipo.co.nz Sent: Friday, 24 August 2012 2:00 PM Subject: Re: [Koha] Availability: No items available What happened when you tried what I said when you asked this yesterday? Specifically here: http://lists.katipo.co.nz/pipermail/koha/2012-August/033934.html Op 24-08-12 10:50, umer habib schreef: Hi, I have a very strange problem. I have two installations of koha one is 3.2 and other is 3.8, I imported mrc files for records in both the installations seperately and (mrc files have items information as well). For zebra indexing i use the fllowing command on both the installations perl /path/to/rebuild_zebra.pl -b -r -v Now, in koha 3.2 it works great. all the records and items are added into the serch and every thing is perfect. But in 3.8, items are not added into the search and when i search for a book, then items against the record says availability: no items available, however there are items present in that record. what could be the issue? In between 3.2 and 3.4, the way items worked changed. After loading your data in to the database, run the misc/maintenance/remove_items_from_biblioitems.pl script to fix them up. This will hopefully help. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha in prisons
On 24 August 2012 09:42, Rachel Hollis rachel.hol...@stevenshenager.edu wrote: Greetings colleagues, I am a part-time librarian at a prison, providing degreed support to everyday library operations. Currently this prison uses an Access database for its library. There is some concern that the Access licenses may be pulled from the library for use in other departments, and they are looking at Koha as an alternative. Are there people at prison libraries using Koha on this list? Hi Rachel I'm not sure they are on the list, but yes Koha is being used in prisons. The one I remember best was from a presentation at Kohacon10 called, it's not the code that is locked down. http://blip.tv/the-curious-and-wondering-eye/kohacon10-video-13-sue-lavery-and-irma-birchall-4430445 Here are the slides https://gitorious.org/kohacon/kohacon/blobs/raw/909f04aae31a1b6d21794fe23d4a93cd0d9cc6cd/static_site/www.kohacon10.org.nz/static/discoverer/slides/lavery_birchall.pdf Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 3.8.4 released
radio buttons on inventory 8544trivial Make RSS icon styleable 7153enhancement Show Open Library as Search Target in More Searches in OPAC detail page 8204enhancement Authority viewer in OPAC ugly, unfriendly, and mostly useless New sysprefs in 3.8.4 == * OPACSearchForTitleIn System requirements == Important notes: * Perl 5.10 is required * Zebra 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.8/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: * Arabic (100%) * Armenian (100%) * Chinese (Taiwan) (100%) * Danish (75%) * English (New Zealand) (96%) * English (USA) * French (100%) * French (Canada) (69%) * German (100%) * German (Switzerland) (100%) * Greek (69%) * Italian (100%) * Norwegian Bokmål (68%) * Portuguese (Brazil) (91%) * Spanish (91%) 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.8 is Release Manager: Paul Poulain paul.poul...@biblibre.com Documentation Manager: Nicole C Engard neng...@gmail.com Translation Manager: Frédéric Demians frede...@tamil.fr QA Manager:Ian Walls koha.sek...@gmail.com QA team: Marcel de Rooy m.de.r...@rijksmuseum.nl, Jonathan Druart jonathan.dru...@biblibre.com Mason James ma...@kohaaloha.com Bug Wranglers: Katrin Fischer, Magnus Enger Release Maintainer (3.4.x): Chris Nighswonger cnighswon...@foundations.edu Release Maintainer (3.6.x): Jared Camins-Esakov jcam...@cpbibliography.com Release Maintainer (3.8.x): Chris Cormack chr...@catalyst.net.nz Credits == We thank the following individuals who contributed patches to Koha 3.8.4. 1 Tomas Cohen Arazi 1 D Ruth Bavousett 10 Jared Camins-Esakov 2 Colin Campbell 5 David Cook 4 Chris Cormack 1 Elliott Davis 1 Frédéric Demians 2 Jonathan Druart 2 Nicole Engard 1 Magnus Enger 1 Chris Hall 4 Kyle M Hall 1 Mason James 2 Owen Leonard 1 Julian Maurice 1 Dobrica Pavlinusic 1 Meenakshi R 2 Marcel de Rooy 8 Fridolyn SOMERS 5 Robin Sheat 3 Mark Tompsett 4 Marc Veron 1 Savitra sirohi We also especially thank the following individuals who tested patches for Koha 3.8.4. 1 Joseph Alway 1 Tomas Cohen Arazi 7 Jared Camins-Esakov 1 David Cook 68 Chris Cormack 1 Elliott Davis 2 Frédéric Demians 7 Jonathan Druart 2 Nicole C. Engard 5 Katrin Fischer 5 Kyle M Hall 9 Owen Leonard 1 Julian Maurice 1 Dobrica Pavlinusic 28 Paul Poulain 1 Marcel de Rooy 1 Zeno Tajoli 3 Mirko Tietgen 3 Marc Veron We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patc...@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 this version of Koha and future bugfixes in this release line is 3.8.x. The last Koha release was 3.8.3, which was released on July 22, 2012. 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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] String freeze for 3.8.4
Hi All Tomorrow is the 15th of August (in NZ at least) and as such, is a week out from the release of 3.8.4. So I am calling a string freeze, this means I won't be pushing any patches that change strings from then on. Frédéric, when you get a chance could you generate the .po files please and let the translators know. Thanks everybody Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Question on Z39.50 cross-format queries
* Manos Petridis (egpetri...@yahoo.com) wrote: From: Robin Sheat ro...@catalyst.net.nz To: koha@lists.katipo.co.nz Sent: Tuesday, August 14, 2012 1:07 PM Subject: Re: [Koha] Question on Z39.50 cross-format queries Op 13-08-12 21:36, Manos Petridis schreef: a) It it were simply a case of either/or, then why can I select the MARC flavour of the various Z39.50 origins set up at my installation? What is the reason to let koha know of the MARC flavour/dialect, if it not able to use the data that each server sends? There must be some functionality behind the dropbox selections, even if it only defines the query statement dialect. Koha needs to know what you are using, so that it knows what field to pull from for the title, and how to index the title in zebra to make it correctly searchable, for example. There are a number of other cases where the differences are a bit deeper than just different field IDs. That's exactly my point! Koha knows a) what MARC flavor my installation is using b) what MARC form each Z39.50 origin accepts requests and supplies its results in It should therefore be able to know what field to pull from for the title etc. I would expect that zebra indexes the various koha tables, not the imported MARC records, i.e. works on data past the mapping phase. Then you would be expecting wrong, it indexes the MARC, which is stored as marcxml in the biblioitems table. If yuo want more in depth on the internals of Koha, it's better on the koha-devel list. Only a small fraction of the over 900 marc fields (most of which are repeatable) and their myriad of subfields (also repeatable) are mapped to columns in the database and stored. The cataloguers on this list will be able to tell you much better than I, but a crosswalk between UNIMARC and MARC21 (or NORMARC, or DANMARC or whatever else) is very hard to pull off, when you have to deal with control fields, indicators etc Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Request for IRC Meeting to Begin Planning KohaCon13
MJ Ray m...@phonecoop.coop wrote: Nicole wrote: Nope, it's a user conference. Vendors can sponsor the conference to keep it free, but we don't have any kind of vendor hall or vendor sales tables. Nicole is far too modest to link to http://www.flickr.com/search/?q=kohacon12 where you can see what it looked like this year, based mostly on the great photos taken by Nicole! We had a sponsors and kohacon info table outside the room, sponsor credits displayed on the screen when people came back from breaks and sponsor details in the printed programmes, but no direct sales event as such. If you do a Flickr search for kohacon10 you will see it was much the same, credits on the website and on screen between breaks. But again no direct sales events or booths, it's not really that kind of conference. Which imho is a pleasant change. I'd like to throw in my vote for 3+1+3 too. Really looking forward to it Edinburgh on June already seems ages ago Chris Hope that informs, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] First post from a koha newbie
Hi Manos On Aug 13, 2012 6:33 PM, Manos Petridis egpetri...@yahoo.com wrote: Greetings from a koha newbie. Before posting any further, I would like to know/ask if this is the proper list for a) posting questions on koha operation Yes b) posting ideas and suggestions for future development Sometimes, for general discussion of new features and how they should work, yes. For how to code them then over on the developer list is the best place. Chris thank you for your time and patience Manos Petridis ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Why are our borrowers being restricted?
* Jared Camins-Esakov (jcam...@cpbibliography.com) wrote: Tim, Restrictions are put in place about 5 minutes before emailed overdue notices are received, so guessing it's the same process. Overdue notice/status triggers Restrict column is unchecked. Preference OversBlockCirc is set to Don't block All fines are set to 0.00, MaxFine is set to 0.00. Maxoutstanding and Noissuescharge is set to 100.00. Anyone see any obvious preferences we may have missed that could be causing this? It's not exactly obvious, but could you check the Overdue notice/status triggers again, and make sure that you either don't have overdue triggers for any libraries other than the default library, or that *none* of them have the Restrict box checked? Also, when you say restricted, what is the exact message you are getting when you go to check out books to this patron? (or, if you are noticing the restriction in another context, where exactly do you notice the restrictions) Ah ha! Thank you Jared! Tim, if you go to Overdue notice/status triggers and switch the library drop down from All, to Ministry of Education. I bet you have restrict switched on there. Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Digest, Vol 82, Issue 20
* Joel Buleka (jbul...@mra.gov.pg) wrote: Hi Chris an you advice which logs to clear? Not really no, not without know what is on your machine. It's dangerous to delete things without knowing what they are. Chris Joel -Original Message- From: Chris Cormack [mailto:chr...@catalyst.net.nz] Sent: Tuesday, August 14, 2012 8:50 AM To: Joel Buleka Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha Digest, Vol 82, Issue 20 * Joel Buleka (jbul...@mra.gov.pg) wrote: Hi We have Koha 2.2.9 running on Fedora 5, recently the MySQL database is not starting up and the server is giving us no disk space error. Hi Joel What that means, is you have run out of disk space on your server. Do you have anyone nearby who knows about linux? You will need to either find some files to delete or will need to get some more diskspace. It might be time to perhaps think about getting a new server and putting a recent version of Koha on it. 2.2.9 is very very old. But the quick fix is you need more disk space on your server, Hope this helps Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Archive for the list
* Diedre Conkling (diedr...@gmail.com) wrote: I clicked on http://lists.katipo.co.nz/mailman/listinfo/koha thinking it would take me to the archive for this list but I am getting an error message. Is there somewhere else to go for the archive? Hi Diedre Yes that is normally where you go, however spammers were using that web interface to try and spam. So it is currently disabled while Katipo work on making sure they can't do that again. In the meantime there are a lot of other places to read the archives http://koha-community.org/support/koha-mailing-lists/ Down the bottom here, the gmane, markmail etc links Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Importing individual records
* Seth Mayo (sm...@stpeters.nsw.edu.au) wrote: I've followed these directions and there was no difference in result or what I had already attempted. It doesn't matter how I add a biblio, it looks like it never moves from reservoir to catalogue. It is very strange all around. Once you 'add' a biblio, you can enter in the item details and then you'll find that the biblio was added into the reservoir and the item details you typed have disappeared into cyberspace. Any other ideas? Sounds to me like your zebra reindex job is not running. Things aren't moved from the reservoir, they are copied, so it will still be in the reservoir if it is the catalogue or not. When you add one, check the url, and see what the biblionumber is. Then in the database (or in reports) SELECT * FROM biblioitems where biblionumber = that_number If it's in the db, its in the catalogue, and its just your cron job to reindex is not running (or failing) Chris Seth Mayo IT Technical Manager Email: sm...@stpeters.nsw.edu.au --- St Peter's Anglican Primary School Howe Street Campbelltown NSW 2560 PH: 02 4627 2990 DID: 02 8203 1368 Website: http://www.stpeters.nsw.edu.au On 8 August 2012 19:03, Robin Sheat ro...@catalyst.net.nz wrote: Op 08-08-12 04:48, Seth Mayo schreef: The librarian has asked me to investigate an issue where when she using Z39.50 to search for a biblio and then proceeds through the process of adding it and an item, she is left with a record that is forever in the reservoir. I think the help for the cataloguing homepage could do with some updating to better explain what the options do, however the way I'd consider doing one-off entries is: 1. Go to cataloguing 2. Select New record and pick the framework This gives you the MARC entry fields 3. From there, use Z39.50 Search. This will populate the fields on the screen with the results of the search. Then when you save, this should go straight into the catalogue. To work with the reservoir, go to Tools - Staged MARC record management. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Overdue items that aren't yet overdue
On 7 August 2012 09:48, Seth Mayo sm...@stpeters.nsw.edu.au wrote: This last week we upgraded to the latest release, 3.8.3, and we now have a strange problem where when you create a print slip in a patron's file, they will have the overdue section with a book that is due today even through the time for it to become overdue is in another 8 hours time. Being at a school, we have the kids return books as a class on the exact day it is due so it isn't overdue until we get past the due date. In past versions all the books were listed as on loan but never overdue unless the date and time were past - but now the unique case of when the date = today, it is always listed as overdue. Is there an easy way to fix this? Perhaps some setting somewhere? We've had a look around over the past couple of days and all we found was the template which is definitely set out right still. FYI - exact description of the librarian This morning we noticed that books due back today appear as overdues on the print slip (student borrower card/print button). This wasn't the case yesterday. The difference between 'this morning' and 'yesterday' in the librarian's comment is that we upgraded Koha overnight. Thanks for your help in advance. Hi Seth You have just run into something similar to http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8182 I think. Can you check the database, and see what the due date of the items are? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Arab Koha Mailing list (and website)
On 4 August 2012 16:45, Karam Qubsi karamqu...@gmail.com wrote: Dear all We hope if you can create a new list for the Koha Arab Community we need this because the community now depending on poorly groups in (facebook) and it doesn't have the features of archiving and safety issues that you all know and we want it to be a mailing list (and forum ) in the same time as it is here . And we are planing to have an Arabic koha community website (interface) that Mr Massoud start something like this on his own server but we need to make this more formal so please advice us about this : - Arabic Mailing list like the German one : http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-i18n-german But please note that we need it to use utf-8 ( in digest) for the Arabic characters - Arabic web site ( for news and encouraging the Arab community to contribute to the international community of koha ) http://ar.koha-community.org and thank you ALL for your efforts Hi Karam Biblibre look after the lists.koha-community.org server, so they will need to do that for you. But if you let me know the ip number you plan to put your ar.koha-community.org site on then I can set up dns to point to that. I assume you will want to bring it up to date and link back to the main site for downloads/git etc eh? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-devel] Koha Release Manager newsletter published
On 4 August 2012 04:30, Paul Poulain paul.poul...@biblibre.com wrote: Hello, I just published my monthly newsletter on koha-community.org website : http://koha-community.org/koha-release-manager-newsletter-9-2012-07/ And now, I leave for 3 weeks of vacation. See you on Aug, 26th ! -- While 3.10.0 is being delayed for a month, due to the vacation. I still plan to release 3.8.4 on time (August 22). To this end, patches that pass QA and are bug fixes I will be applying on 3.8.x. So I would (as always) appreciate any work the QA team does, and any work the rest of community does signing off. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Quick question
Hi Clint, Been there ranted already. http://findingheroes.co.nz/2012/03/30/open-source-ils-much-bigger-than-you-think/ Hope this helps. Chris clint.deckard clint.deck...@frontiers.co.nz wrote: Kia ora, I am advocating for Koha and wish to point out that 'free' doesn't mean 'low quality' or 'cut down', could someone please point out of couple of examples of Koha powering 'large' libraries please. I have a bit of a rant going :-) Thank you very much, Clint. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Stable vs maintenance releases?
Cab, They are both stable branches and releases on both are maintenance releases each month. I prefer to think of them as stable and oldstable. With master bein development. 3.4.1 is pretty old I'd say the site needs an update. When we release a new feature release a x.x.0 release we don't kill the previous release tree. So currently we are doing monthly maintenance releases for the 2 stable branches. 3.8.x and 3.6.x, this means people can stick with the latest release of 3.6.x until they have decided they want to move. So we have feature releases, every 6 months and maintenance every 1. The only exception is a security release, if something requires an urgent release we will do that. Chris Cab Vinton bibli...@gmail.com wrote: Can someone explain the difference between these two? http://download.koha-community.org/ lists these as 3.8.3 (stable) and 3.6.7 (maintenance) ... I would have thought that a maintenance release is done on top of a stable release, comprising minor bug fixes and the like. And how is it determined what the latest stable release is? I notice that Equinox's support page is still listing 3.4.1 as the current stable version. Is this something that varies from support company to support company, depending on their confidence in a particular release, their philosophy of development, etc? With thanks, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast! _ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Circulation Errors after Upgrade
On 31 July 2012 17:13, Josh Mikow joshmi...@gmail.com wrote: Thanks Chris! Glad to know I'm doing this the best/recommended way. i'm refreshing my linux skills and also having to learn about library systems and it takes me a bit. Hmm that looks alright you could try a koha-rebuild-zebra -f to just see if that helps Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Circulation Errors after Upgrade
Hi Josh On 31 July 2012 12:36, Josh Mikow joshmi...@gmail.com wrote: I ran all of the upgrade scripts to get from 3.01. to 3.6. Based on the file, it looks like it should have run as a part of that process. Hmm which upgrade scripts are those? When I try to run it to view the help it gives me a compilation error. Whats the error? I bet its missing the path to the C4 modules Would it have logged somewhere if this failed as a part of the upgrade? No. It isnt run as part of the upgrade, because it only needs to be run in special circumstances, when coming from a pre 3.4.x version to a 3.6.x, and take a long time potentially. From the INSTALL file in the UPGRADE section Koha 3.4.x or later no longer stores items in biblio records. If you are upgrading from an older version ou will need to do the following two steps, they can take a long time (several hours) to complete for large databases misc/maintenance/remove_items_from_biblioitems.pl --run misc/migration_tools/rebuild_zebra.pl -b -r You need to run these as the user that runs rebuild_zebra normally (check your cron if you are unsure) and need to set the paths. For instance on my machine if I was using a package installed from the tarball sudo -u koha PERL5LIB=/usr/share/koha/lib KOHA_CONF=/etc/koha-conf.xml perl misc/maintenance/remove_items_from_biblioitems.pl --run If I installed from the packages (the best way) (but I think you used the tarball?) sudo koha-upgrade-to-3.4 instancename Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Circulation Errors after Upgrade
On 31 July 2012 16:59, Josh Mikow joshmi...@gmail.com wrote: Hi Chris, When I imported our database into the 3.6.4 system at the time I ran the following: koha-upgrade-schema instancename then koha-uprade-to-3.4 instancename When I ran the 2nd command, the koha-upgrade-to-3.4 command kept returning a bunch of Use of uninitialized value in pattern match (m//) at /usr/share/koha/lib/C4/Biblio.pm line 2953 . I asked and was told I could safely ignore those errors from the upgrade command. I actually install KOHA using the apt-get packages on Debian. I've used that to keep it up to date and apply patches as they come out. Cool, it is by far the easiest way to run Koha. Do I need to try to re-run the upgrade to 3.4 or check any specific logs? What you can do is in your report writer, write a report that does SELECT marcxml FROM biblioitems limit 5 That will get you 5 records, you can look at your marcxml and if it has 952 fields in it, the fields were not removed. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha space usage
On 26 July 2012 06:02, rfblanchard rfblanch...@hotmail.com wrote: Hi, I'm doing some investigation into the space usage on my server and noticed the following take the most space: 7.0 G *** ./var/lib/mysql 8.6 G ./var/lib/koha/kohapei/biblios/register 9.3 G ./var/lib/koha/kohapei/biblios/shadow The first folder is the database. Questions: 1) are the 'register' and 'shadow' directories and the files within generated during the zebra indexing? Yes, when the index is created, its created in the shadow, then copied to the register. This means searching doesn't stop while things are being indexed. 2) is it normal for these directories to each be bigger than the size of the entire koha database? Yes, it has to create indexes, on tons and tons of fields. 3) do these directories continue to grow with each reindex? No, only as the bibliographic data grows 4) should I do anything to reduce the size of these directories? Not if you want a functioning search ;) Thanks for any input Hope it helps Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Kohacon13
Hi All (and especially the folks from Reno) Now that the vote is all in, and we have our winner (it was a very high voter turnout too, so should be a super big Kohacon) I wonder if some tentative dates have been thought of? Will it be October or September? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Solr
On 25 July 2012 08:15, Stacy Pober stacy.po...@manhattan.edu wrote: Does anyone know if switching from Zebra to Solr will let Koha libraries use a stopwords list? Also, will Solr have any effect on fuzzy searching defaults? Lastly, is there anyone sponsoring or working on a did you mean... opac response to zero retrieval searches? At our library, we'd probably choose a did you mean... spelling suggestion choice over the automatic fuzzy spelling assumptions that are currently in the system. I realize this would probably be listed in bugzilla, but I'm not sure exactly how to search for this. Stacy Koha is not switching to Solr, but now (in master) you can choose between using Solr or Zebra. (YMMV with other software based originally on Koha). This is already working in the master branch. Also, in Koha itself using zebra (I don't know what the forks are doing) you can now use DOM indexing which is much more powerful than the old indexing methods. But we want to do much more than that, if you look at the thread starting here http://lists.katipo.co.nz/pipermail/koha/2012-July/033634.html You will see what the future plans are. (This does include did you mean). Hope this helps Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Kohacon13
On 25 July 2012 03:59, Keener, Nancy nkee...@washoecounty.us wrote: Thanks for asking Chris. We are discussing that very subject today. Looks like the first week in October would be a good time for coming to Reno. Excellent, thank you That will help trying to figure out funding :) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Neat participation / bug fixing dashboard from WikiHow
On 25 July 2012 11:00, BWS Johnson abesottedphoe...@yahoo.com wrote: Salvete! Last meeting, I tried in vain to describe how cool the wikiHow Community Dashboard is. Hopefully this link is viewable without logging in. Let me know if you all can't see it, and I'll screenshot it and upload it to the wiki. http://www.wikihow.com/Special:CommunityDashboard That does look fantastic. There is a git repository for the Koha dashboard http://dashboard.koha-community.org/ That lives at https://gitorious.org/koha-dashboard (In the next bit I will be using you a lot, this refers to the collective you, or y'all :) not Brooke) If people wanted to extend it, they are more than welcome to work on it. I'm unlikely to get more free time to work on it in the near future. These project always run into the problem of not enough hours in the day. Which leads me to my next point, we need more people to get involved. Something like the dashboard is great, you won't/can't break Koha, no one will lose circulation statistics if you make a mistake. It needs things you might have skills in, design, css, html, javascript, wordsmithery (i just made that one up). It's a great intro into getting more involved, then you can move to signing off. http://blog.bigballofwax.co.nz/2012/07/09/do-some-signoffs-you-know-you-want-to/ Then let us know how you choose what to sign off. http://blog.bigballofwax.co.nz/2012/07/10/choosing-something-to-sign-off/ So it can help us encourage others to do some. You have a distinct advantage with Koha, you can have direct influence, and a small change you make, say highlighting the needs signoff section in a way that makes it stand out and thus get more people looking at it, may get 20 new features into Koha. Reading back, I sound like a bit of a idealistic/pompous fool, so I feel like I should end with Hold your ground, hold your ground! Sons of Gondor, of Rohan, my brothers! I see in your eyes the same fear that would take the heart of me. A day may come when the courage of men fails, when we forsake our friends and break all bonds of fellowship, but it is not this day. An hour of woes and shattered shields, when the age of men comes crashing down! But it is not this day! This day we fight! By all that you hold dear on this good Earth, I bid you *stand, Men of the West!* Thus I have Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra problem with Ubuntu 12.04
* Vimal Kumar V. (vimal0...@gmail.com) wrote: Dear Friends, I just upgraded from 3.8.2 to 3.8.3 Everything working fine, but problem with zebra. After adding catalogue records, newly added records does not display in OPAC when searching. Every time I have to rebuild zebra manually. I installed Koha on Ubuntu 12.04. Anybody experienced same problem. How to solve it? Sounds to me like either your cron job is not running. Or the permissions are mucked up. Check your cron job to run rebuild_zebra.pl is set up right and is running at a regular interval Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha version feature summary?
On 23 July 2012 22:25, Hailuodon Kunnankirjasto m.kirjasto.hailu...@gmail.com wrote: Hi, grts from Finland Europe! Ive been wondering has anybdy listed on one doc functional features of major Koha versions? I run live a experimental Koha 3.6.2. on periodicals of my 20 000 item'ish rural public library in Northern Finland. Now, I miss for my upcoming (due 1.1.2013) project reports general part a description of Koha's feature delevopment to ground my by-far-final version choice. :)) 3.2 3.3 3.4 3.5. 3.6 3.7 3.8 Any help? 3.8. and some earlier versions new features can be obtained but as far as I see it, the earlier feature specs have not been informed in any especially explicit manner. Especially from usability viewm not technical. For a start, there never has been a 3.3.x, 3.5.x, or 3.7.x release. Releases always have the second number an even number. Also versions are always 3 numbers, 3.2.0, 3.2.1. 3.4.0 etc. Also, the release notes are in the git repository. eg http://git.koha-community.org/gitweb/?p=koha.git;a=tree;f=misc/release_notes;h=b6eebe16e771cead367f368b7c2383e03e231814;hb=108e901043f0766f8c103f3826b5af1cdb6daaa4 Plus on the website eg http://koha-community.org/koha-3-8-3-released/ Hope this helps Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha 3.8.0 Released
On 23 July 2012 22:40, Hugo Agud ha...@orex.es wrote: Hi Chris I have seen again where I saw it.. the chance of sharing patterns... it was not a official community new it was a presentation in Kohacon11 http://bywatersolutions.com/2011/11/01/biblibres-work-on-acquisitions-and-serials/ Ahh, Well you would have to ask Biblibre about that, I didn't see it in the release notes, or on bugzilla, or on the wiki. So it looks like not submitted yet, you could ask Paul (he is release manager for 3.10.0 and was release manager for 3.8.0) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] SQL queries to delete records from the database?
22000 done 23000 done 24000 done 25000 done 26000 done 27000 done 28000 done 29000 done 3 done 31000 done 32000 done 56 bibliorecords not indexed ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] SQL queries to delete records from the database?
On 23 July 2012 15:57, Sonia P. sossola...@hotmail.com wrote: So something like that? mysqldump -u kohauser -p kohalibrary savedatabase230712.sql mysql -u username -p[password]use kohalibrary;DELETE FROM biblio WHERE biblionumber='2315'; (never done mysql things in commandline before...) Cheers, Sonia. Yes If you are incredibly sure you want do this, and you are sure you know how to restore from a backup, and no one is using or has used Koha since you made that backup. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Need to improve Koha users list world wide
On 19 July 2012 19:05, Vimal Kumar vimal0...@gmail.com wrote: Dear Friends, Its high time to implement a user friendly Koha users list world wide, http://wiki.koha-community.org/wiki/Koha_Users_Worldwide In the present situation very difficult for entering libraries in the list. Its good to create a database with form to enter the details with search facility. Login option to edit the information by Koha users. I look forward to using the solution you implement Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-translate] String freeze for 3.6.7
Ata marie, 3.8.x is also in string freeze for 3.8.3. I have started putting important dates on dashboard.koha-community.org in the hopes it will be useful for people. Chris On Jul 16, 2012 1:04 AM, Jared Camins-Esakov jcam...@cpbibliography.com wrote: Good morning. Apologies for the late notice, but as of right now 3.6.x is in string freeze in preparation for the release of 3.6.7 in one week. Thank you to the translation teams for their hard work. Regards, Jared Camins-Esakov -- Jared Camins-Esakov Bibliographer, C P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha-translate mailing list koha-transl...@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate website: www.koha-community.org git: git.koha-community.org bugs: bugs.koha-community.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Patch for shibboleth login
On 14 July 2012 21:41, Tom Francart franc...@gmail.com wrote: Dear all, I wrote rudimentary Shibboleth login support for Koha. It's quite specific to our university and Koha setup, but should be easy to modify. I hope someone finds it useful. The attached patch can be applied to lib/C4/Auth.pm of Koha 3.8.2 Tom Your patch didn't come through, a better place for it would be to create a bug at bugs.koha-community.org and attach it to that. That would be excellent. Looking forward to seeing it Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Software error: when trying to open Koha web installer
* jackymasibo (jmas...@gmail.com) wrote: hi guys i have installed koha but now when i try to connect to its web installer so that i can finish up the configurations i get the following errorSoftware error: Access denied for user 'admin'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 758. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 31. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 31. 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 (webmaster@LIBRARY), giving this error message and the time and date of the error. It looks to me like the user in your koha-conf.xml doesn't have permission to connect to the database. How did you install? You probably need to fix the mysql permissions Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra troubles after upgrading from 2.2
On 12 July 2012 19:16, Tom Francart franc...@gmail.com wrote: Dear all, We've just upgraded from Koha 2.2 to Koha 3.8 and are having troubles searching with zebra. We proceeded as follows: - Upgrade from 2.2 to 3.0 using the instructions on http://wiki.koha-community.org/wiki/Upgrading_2.2 - Upgrade from 3.0 to 3.8 (perl Makefile.PL, make, make upgrade) My install log is below this message. Note that I answered yes to whether I wanted to use DOM for Marc records. Running misc/migration_tools/rebuild_zebra.pl -a -b -k –reset yields: koha@gilbert:/home/tom/temp/koha/koha-3.8.2$ misc/migration_tools/rebuild_zebra.pl -b -r error retrieving biblio 663 at misc/migration_tools/rebuild_zebra.pl line 485. error retrieving biblio 664 at misc/migration_tools/rebuild_zebra.pl line 485. error retrieving biblio 665 at misc/migration_tools/rebuild_zebra.pl line 485. error retrieving biblio 666 at misc/migration_tools/rebuild_zebra.pl line 485. error retrieving biblio 667 at misc/migration_tools/rebuild_zebra.pl line 485. 09:02:51-12/07 zebraidx(16409) [warn] Record didn't contain match fields in (bib1,Local-number) Hi Tom Does it manage to export any records at all, or do you just get these errors? And does zebraidx finish successfully? If you just get these errors, no records are being exported to be indexed, hence nothing in your search results. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra troubles after upgrading from 2.2
On 12 July 2012 19:46, Tom Francart franc...@gmail.com wrote: On Thu, Jul 12, 2012 at 9:27 AM, Chris Cormack ch...@bigballofwax.co.nz wrote: On 12 July 2012 19:16, Tom Francart franc...@gmail.com wrote: Dear all, We've just upgraded from Koha 2.2 to Koha 3.8 and are having troubles searching with zebra. We proceeded as follows: - Upgrade from 2.2 to 3.0 using the instructions on http://wiki.koha-community.org/wiki/Upgrading_2.2 - Upgrade from 3.0 to 3.8 (perl Makefile.PL, make, make upgrade) My install log is below this message. Note that I answered yes to whether I wanted to use DOM for Marc records. Running misc/migration_tools/rebuild_zebra.pl -a -b -k –reset yields: koha@gilbert:/home/tom/temp/koha/koha-3.8.2$ misc/migration_tools/rebuild_zebra.pl -b -r error retrieving biblio 663 at misc/migration_tools/rebuild_zebra.pl line 485. error retrieving biblio 664 at misc/migration_tools/rebuild_zebra.pl line 485. error retrieving biblio 665 at misc/migration_tools/rebuild_zebra.pl line 485. error retrieving biblio 666 at misc/migration_tools/rebuild_zebra.pl line 485. error retrieving biblio 667 at misc/migration_tools/rebuild_zebra.pl line 485. 09:02:51-12/07 zebraidx(16409) [warn] Record didn't contain match fields in (bib1,Local-number) Hi Tom Does it manage to export any records at all, or do you just get these errors? And does zebraidx finish successfully? If you just get these errors, no records are being exported to be indexed, hence nothing in your search results. Chris Hi Chris, Thanks for your quick response. I'm not sure if it does. I don't get any further (error) messages. How do I check? Try running it with -vv You should get a whole of of messages from zebraidx, Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra troubles after upgrading from 2.2
On 12 July 2012 20:18, Tom Francart franc...@gmail.com wrote: On Thu, Jul 12, 2012 at 10:12 AM, Chris Cormack ch...@bigballofwax.co.nz wrote: On 12 July 2012 19:46, Tom Francart franc...@gmail.com wrote: On Thu, Jul 12, 2012 at 9:27 AM, Chris Cormack ch...@bigballofwax.co.nz wrote: On 12 July 2012 19:16, Tom Francart franc...@gmail.com wrote: Dear all, We've just upgraded from Koha 2.2 to Koha 3.8 and are having troubles searching with zebra. Hi Chris, Here's the output with the vv switch. Here's the salient bit log] Records: 0 i/u/d 0/0/0 No items inserted, updated or deleted. So zebra is being given nothing it can index, it looks to me like your upgrade didn't work well, and the records are not complete. Do you have mysql access, can you do select marc,marcxml from biblioitems where biblionumber = 669 And take a look at it, i suspect it is missing the 999 field, if not a lot more. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra troubles after upgrading from 2.2
Hi Chris, First of all, thank you very much for taking the time to help us. That query returns no records. In table biblioitems, biblionumber goes only up to 667. Most records have the marcxml field set, but I haven't found any that contain the 999 field. Additionally, records 663-667 have an empty marcxml field. What would be the best way to fix it? I still have the original Koha 2 database. Removing biblioitems 663-667 and re-addng them to the library wouldn't be a problem either. Hmm it doesn't appear to be indexing anything, not just missing those 4. You could try the rebuild zebra with -k to keep the files, then you could take a look at them. I'd try -k -v -r -b -x Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-devel] BibLibre efforts on reversing developments and you
On 7 July 2012 03:58, Chris Cormack chr...@catalyst.net.nz wrote: Claire, I was just trying to encourage more people to sign off by showing them that they would end up in the stats reports. Hence the do some sign offs, become famous. I thought that is what you were wanting. In order to perhaps help get more people signing off, I wrote a little script that writes out json of the last sign offs. I then wrote some jquery to pull that in after a set interval. http://stats.workbuffer.org/scroller.html Please ignore how hideous it looks, or better yet, please help me with some css to make it less hideous if people think it is worth continuing. It was a late night Saturday night idea, so might be dumb :) If not I was thinking signoffs.koha-community.org Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] opaccloud syspref
Interesting when I turn it off I don't see it. Chris mourik jan heupink heup...@merit.unu.edu wrote: Hi list, Chris, OpacBrowser is for the subject cloud If you want the Tag cloud not to show you have to turn tags off. With TagsEnabled Setting TagsEnabled to false gets rid of the Tag Cloud link. Thanks Chris. I have set OpacBrowser to don't allow patrons to browse subject authorities on OPAC, but the subject cloud link is still present... Clicking it only shows Note: This feature only available to French catalogs where ISBD subjects have been populated, and an index built by separate script. Would be nice to not show that link, since we're not a French catalog... MJ _ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] BibLibre efforts on reversing developments and you
Claire, I was just trying to encourage more people to sign off by showing them that they would end up in the stats reports. Hence the do some sign offs, become famous. I thought that is what you were wanting. Chris Claire Hernandez claire.hernan...@biblibre.com wrote: On 05/07/2012 20:46, Chris Cormack wrote: To that end, I have been creating the statistics of signoffs http://blog.bigballofwax.co.nz/2012/04/01/bug-statistics-for-march-2012/ http://blog.bigballofwax.co.nz/2012/05/04/statistics-for-koha-april-2012/ http://blog.bigballofwax.co.nz/2012/06/01/bugenh-statistics-for-may-2012/ http://blog.bigballofwax.co.nz/2012/07/01/bugzilla-statistics-for-june-2012/ So people can recognise the hard work of the people doing sign offs Do some sign offs, become famous!! Save some kittens! Hello Chris, I am not sure to understand why you answer me that. I wasn't saying that nothing is done. What I am saying is a measure of our (BibLibre) investment (people, time and energy) versus the result (and metrics I have put to follow it). We are able to challenge our (BibLibre) practices if you (community) have feedback to give us. Secondly, signoffs statistics does not say everything : as Marcel show this morning, a patch can be signed-off multiple times before being integrated (and my main metric is done as patch pushed). Furthermore, the main patches attached are not bugfixes but enhancements which needs acceptance tests and non regression validation. If you sort bugs that need signoff by change date, that's clear that almost of patches waiting are enhancements. The most important thing for me is the value added we deliver to users at the end... Thanks, Claire. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] problems when Running the Koha installer
On 5 July 2012 20:00, jackymasibo jmas...@gmail.com wrote: hi guys , thanks alot for your support but now i have a nother issue, i am trying to run the koha installer and when i type the following command: $ perl Makefile.PL i get the following: Can't open perl script Makefile.PL: No such file or directory any idea on what i am supposed to do will be appreciated. Sounds to me like you aren't the right directory. You need to be in the directory that that file is in. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Statistics in 3.6
On 4 July 2012 11:49, Paul Nielsen pa...@hauraki-dc.govt.nz wrote: I am glad I am not alone Jo, thanks. Chris, I only use the Circulation Statistics Wizard so not sure if that is what you mean about the table? Ah ha, that will be the problem that wizard doesn't work right since 3.4.x You will want to use a saved report in the reports, I'll email you a good one to use when I'm back at work. (I checked the db, this year is actually up about 30 thousand on last year (june to july)) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] opaccloud syspref
On 5 July 2012 22:46, mourik jan heupink heup...@merit.unu.edu wrote: Hi, I can't find the OpacCloud syspref. Has this been removed? (koha 3.8.2, from debian apt repository) I currently have two links in my opac that don't work: 'Tag Cloud' and 'Subject Cloud'. I'm not sure what exactly they do, so I wanted to disable them for now... OpacBrowser is for the subject cloud If you want the Tag cloud not to show you have to turn tags off. With TagsEnabled Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] BibLibre efforts on reversing developments and you
* Claire Hernandez (claire.hernan...@biblibre.com) wrote: Hello, We continue to invest a lot of time and energy to this task (and signoff and qa) but it seems that today, the goal fixed at the beginning of the year can't be reached, because in 3 months no progress is really noticable... Have a look https://docs.google.com/a/biblibre.com/spreadsheet/ccc?key=0AuZF5Y_c4pIxdHE3S0RXMjJqSzZ3d1BVUmxpRnRVUUE#gid=11 To that end, I have been creating the statistics of signoffs http://blog.bigballofwax.co.nz/2012/04/01/bug-statistics-for-march-2012/ http://blog.bigballofwax.co.nz/2012/05/04/statistics-for-koha-april-2012/ http://blog.bigballofwax.co.nz/2012/06/01/bugenh-statistics-for-may-2012/ http://blog.bigballofwax.co.nz/2012/07/01/bugzilla-statistics-for-june-2012/ So people can recognise the hard work of the people doing sign offs Do some sign offs, become famous!! Save some kittens! Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Search Results without items
* ggardei (ggar...@gbs.edu) wrote: Greetings Koha Guru's We are currently in the progress of migrating from Follett Destiny to Koha. One of the issues that we are having is that a bunch of biblio items are being imported that do not have an item (and some that are). I have run the SQL query to remove biblio without items; however the biblio records are still showing up when I search in OPAC. When you click on one of these items, a page with error 404 appears Here is the script I ran to remove the biblio items INSERT into deletedbiblio (SELECT * FROM biblio where biblionumber NOT IN (SELECT biblionumber from items)); INSERT into deletedbiblioitems (SELECT * FROM biblioitems where biblionumber NOT IN (SELECT biblionumber from items)); DELETE FROM biblio where biblionumber NOT IN (SELECT biblionumber from items); Hiya So what you have done is fine, but the step you are missing is to do a full zebra reindex, because you have deleted stuff, but not told zebra of that fact. So if you do a full zebra reindex they will drop out of your search results Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-devel] KohaCon 13 Survey Problem
* Marc Balmer (m...@msys.ch) wrote: So lets repeat the vote, please. You are volunteering to email all those people, including the ones Mirko made a good point about not having reliable internet? To make sure they know to vote again? Chris -- Marc Balmer micro systems, http://www.msys.ch/ Tel. +41 61 383 05 10, Fax +41 61 383 05 12 Am 05.07.2012 um 22:00 schrieb Lori Bowen Ayre lori.a...@galecia.com: I was under that impression too and would not have voted the way I did had I known otehrwise. Lori On Thu, Jul 5, 2012 at 11:07 AM, Marc Balmer m...@msys.ch wrote: As I understand, I could have given points only to one location, not giving points to any of the other locations, right? I was under the impression that I must pick five locations, which seems not to be the case. -- Marc Balmer micro systems, http://www.msys.ch/ Tel. +41 61 383 05 10, Fax +41 61 383 05 12 Am 05.07.2012 um 19:38 schrieb Jared Camins-Esakov jcam...@cpbibliography.com: Marc, Yes, please restart the vote. I was not aware that I could only give points to one location. Every location you vote for gets points. It's just that it gets a different number of points depending on whether you rank it 1..5. Regards, Jared -- Jared Camins-Esakov Bibliographer, C P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha-devel mailing list koha-de...@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Statistics in 3.6
Yep, that's what I think anyway. I'm in at work today (been on leave for school holidays) So I'll do some new reports for you. Chris On Jul 6, 2012 8:33 AM, Paul Nielsen pa...@hauraki-dc.govt.nz wrote: Great thanks Chris, Good to know the old gut instinct is still intact. So, is the wizard unreliable for other reports too, especially membership? Paul -Original Message- From: Chris Cormack [mailto:ch...@bigballofwax.co.nz] Sent: Thursday, 5 July 2012 9:42 p.m. To: Paul Nielsen Cc: Joann Ransom; koha@lists.katipo.co.nz Subject: Re: [Koha] Statistics in 3.6 On 4 July 2012 11:49, Paul Nielsen pa...@hauraki-dc.govt.nz wrote: I am glad I am not alone Jo, thanks. Chris, I only use the Circulation Statistics Wizard so not sure if that is what you mean about the table? Ah ha, that will be the problem that wizard doesn't work right since 3.4.x You will want to use a saved report in the reports, I'll email you a good one to use when I'm back at work. (I checked the db, this year is actually up about 30 thousand on last year (june to july)) Chris # DISCLAIMER: This e-mail message and accompanying data may contain information that is confidential and subject to privilege. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you have received this e-mail in error please notify the sender or Hauraki District Council at mailmars...@hauraki-dc.govt.nz immediately and delete all material pertaining to this e-mail. # ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Overdue notices only list the first book/item that's late
On 6 July 2012 07:50, Steven Nickerson snick...@maine.rr.com wrote: Hello everyone, We've noticed that the email overdue notices that go out only seem to list the 1st item that is overdue, and not all overdue items. For example, if I checked out 2 books on the same date/time, I only get an overdue notice for one of the two items.Anyone have any ideas? I would think that both items should be in the same email or at least two different emails should be generated. Hey Steve What version of Koha ? I'm pretty sure I saw a bug report for this and a fix for it in the recentish past. Ill go hunting Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-devel] [discussion] Privacy issue (bug 3280)
Make it a syspref, so it can work for all jurisdictions. Problem solved. Chris Paul Poulain paul.poul...@biblibre.com wrote: Hello Koha users developers, The bug 3280 fixes a problem in cart sending in opac : the behaviour has changed, and for security reason, it will be possible only for logged-in users. A question has also been raised : we could also add the IP address of the sender in the mail that Koha sent. Do you think : 1- we could 2- we should 3- we shouldn't (and why) I start arguing = I think we should, and in France, I think it's a legal issue, you must be able to answer any legal request from a court (9-11, thank you :\ ) It's right we have the username, but the IP address is a good complement -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08 _ Koha-devel mailing list koha-de...@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] UNIMARC 100 FIELD Language of cataloguing can not change
On 3 July 2012 00:33, Fabio T. fabio.t...@gmail.com wrote: Good time of day everyone! Same here for italian language, since version 3.6 (but I can't say before) with Koha UNIMARC flavor (.deb packaged release in my case). Anytime I change fre to ita and save it, this edit isn't kept. Thanks for helping. Fabio Tiana Hi All I would encourage one of you to go to http://bugs.koha-community.org and report this as a bug. Hopefully some of the UNIMARC developers will see it then. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Solr and enhanced searching (WAS: Re: Koha Digest, Vol 80, Issue 40)
On 26 June 2012 19:12, Stacy Pober stacy.po...@manhattan.edu wrote: Jared, Thank you for the explanation. When I looked at the link you provided: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8233 I was surprised to see the heading: *Bug 8233* http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8233-New search engine layer - introduce solr without breaking anything else Isn't the without breaking anything else something that is assumed in the software development process? Yes it is, that's what we have unit testing and regression testing for. You can actually follow the continuous integration testing here http://jenkins.koha-community.org/ . Here is the master branch http://jenkins.koha-community.org/job/Koha_master/ (which what will be the 3.10.0 release). The other active branches are the 'oldstable' 3.6.x branch of which 3.6.6 has just been released. And the 3.8.x branch, of which 3.8.2 has just been released. This 'bot' jenkins builds and installs a Koha, and runs over 10,000 tests every time anything changes, trying to minimise what is unintentionally broken by any new feature. What this bug is actually referring to is the fact that Koha has been able to work with Solr for nearly 2 years now, but that implementation was a replacement of Zebra. IE removing zebra and adding Solr. This new implementation (which works very well so far) instead allows the Library to choose between Zebra or Solr. IE it is Solr added without removing Zebra support. What is even better is that it allows us to add any number of different indexing engines. A lot of our bugs have tongue and cheek, or ironic names. Some are just silly fun, this is one of my favourites http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5158. Sometimes some of us (well mainly me) go a little crazy http://blog.bigballofwax.co.nz/2010/12/14/what-happens-after-updating-the-status-of-300-bugs/ But like Tom Robbins said It is a grave and dangerous mistake to take oneself too seriously :) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Recall function
On Jun 25, 2012 1:28 AM, alaa Badri elbadri_fat...@hotmail.com wrote: Thanks All I will develop it for myself And commit it back to Koha for all to use as well, I'm sure you also meant to say. :) Chris Best Regards, Alaa BadriSystem and network administrator New Generation International Schools01227204728 Subject: Re: [Koha] Recall function From: ro...@catalyst.net.nz Date: Sun, 24 Jun 2012 14:10:17 +0100 To: david.n...@gmail.com; elbadri_fat...@hotmail.com CC: koha@lists.katipo.co.nz University libraries have it, where a student may be allowed, say, 3 recall requests per year to allow for things that are real emergencies. I used it once when I needed to verify something a week before my thesis was due. -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. David Nind david.n...@gmail.com wrote: Hi Alaa. Koha doesn't have this feature as far as I can see in 3.8.1 or 3.8.2 (happy to be corrected if it does). There is an abandoned RFC (request for comment) for this: http://wiki.koha-community.org/wiki/Recall_requests_RFC Recalls are also mentioned in this RFC: http://wiki.koha-community.org/wiki/Messaging_rewrite_RFC To add this type of feature you could log an enhancement request, develop it yourself if you have the skills, or sponsor the development e.g. through another developer or one of the commercial Koha support companies: http://wiki.koha-community.org/wiki/Enhancement_Request_Guidelines As a non-librarian my only comment is that this seems like a very strange 'feature' to have. I have an item checked out, someone else wants it and can't wait until it is returned by the normal due date (using the holds/reserve feature), but can then make me return it early! (I know what my response would be!). After a quick search on the internet it looks like something academic libraries might use. I could understand this type of feature if the loan period for an item was months or years. As 'they' say, every library is a little different David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 On 24 June 2012 20:36, alaa Badri elbadri_fat...@hotmail.com wrote: Dear All I need to know if is recall function added to koha 3.8.1 or not if is not how i can add it or use it in this release Thanks for your effort Best Regards, Alaa BadriSystem and network administrator New Generation International Schools01227204728 Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Rebuild-zebra stops working very often...
Ahh that is not the zebra error log. But the rebuild zebra one. I think you may be confusing zebra with the job to rebuild the zebra indexes, they are 2 quite different things. However not being able to talk to the database is a fatal error for the rebuild zebra script. The database failing will also cause all sorts of other errors. I would get your tech people to look at your database set up. Something very bad is going wrong there. Chris Sonia P. sossola...@hotmail.com wrote: Dear all Thanks again for your help. Here is (below) the content of the zebra error file. Would you please have a look at it and tell me if there are things which could explain why zebra-rebuild stops working now and then? There is that DBIconnect error, but I am not sure it's related. And there is no time day in the error file, so I can't check what happened when zebra rebuild doesn't work properly. (I have removed all the multiple duplicates...) Cheers, Sonia. Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm line 96. DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to loc al MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm lin e 692 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/l ib/C4/Context.pm line 692. DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to loc al MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm lin e 692 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/l ib/C4/Context.pm line 692. DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to loc al MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line 692 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib /C4/Context.pm line 692. error retrieving biblio 12126 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. error retrieving biblio 11493 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. error retrieving biblio 13829 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. $ Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm line 96. $ DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to local MySQL server through socket $ '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 692 error retrieving biblio 14703 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. $ Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm line 96. $ DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to local MySQL server through socket $ '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 692 $ error retrieving biblio 14703 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. $ Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm line 96. $ DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to local MySQL server through socket $ '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 692 $ error retrieving biblio 14703 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. _ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 3.8.2 Released
to prevent leftmenu overlapping it. 8150minor Patron circulation history has a fossil navagation bar 8166minor Adding new currencies exchange rates if not fill any field it save blank record 8195minor The selected link in include menus must be bold 8217minor Focus on search box in Detail page (staff search) 3521trivial Items table in catalogue/detail.pl and cataloguing/additem.pl is sorted nonsensically 6267trivial custom http user-agent in check-url.pl (fix for books.google.com 401 error) 7368trivial General staff client typo omnibus 8222trivial The zip code field is mandatory by default 6684enhancement koha-remove should check the number of arguments it gets 7444enhancement Use T::T date plugin to display dates omnibus 7788enhancement Tiny problems with calling GetShelf 7847enhancement OPAC search dies with plack 7926enhancement Acq search results show empty parenthesis for orders without basket group 7941enhancement Fix version numbers in modules and set up a system to keep them up to date 8080enhancement login and password is pre-filled by the browser when creating a new patron 8107enhancement Disabled buttons not distinguishable from enabled buttons. 8138enhancement Add 773$t field to xslt 8178enhancement circ/circulation.pl under plack duplicates checkout rows New system preferences in 3.8.2 = * ReservesControlBranch * SuspendHoldsIntranet * SuspendHoldsOpac System requirements == Changes since 3.6: * No new system requirements 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.8/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: the following languages: * Chinese -Taiwan- (100%, OPAC 100%) * German (100%, OPAC 100%) * Italian (100%, OPAC 100%) * French (99%, OPAC 100%) * Portuguese (Brazil) (90%, OPAC 100%) * Spanish (87%, OPAC 100%) * English -nz- (78%, OPAC 100%) * Arabic (76%, OPAC 100%) * Danish (75%, OPAC 100%) * Greek (69%, OPAC 100%) * French -canada- (68%, OPAC 70%) * Armenian (68%, OPAC 100%) * Norwegian (67%, OPAC 100%) 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.8 is Release Manager: Paul Poulain paul.poul...@biblibre.com Documentation Manager: Nicole C Engard neng...@gmail.com Translation Manager: Frédéric Demians frede...@tamil.fr QA Manager:Ian Walls koha.sek...@gmail.com QA team: Marcel de Rooy m.de.r...@rijksmuseum.nl, Jonathan Druart jonathan.dru...@biblibre.com Bug Wranglers: Katrin Fischer, Magnus Enger Release Maintainer (3.4.x): Chris Nighswonger cnighswon...@foundations.edu Release Maintainer (3.6.x): Jared Camins-Esakov jcam...@cpbibliography.com Release Maintainer (3.8.x): Chris Cormack chr...@catalyst.net.nz Credits == We thank the following individuals who contributed patches to Koha 3.8.2. 1 D Ruth Bavousett 1 Jared Camins-Esakov 4 Colin Campbell 20 Chris Cormack 4 Christophe Croullebois 1 Stéphane Delaune 4 Frédéric Demians 4 Jonathan Druart 3 Katrin Fischer 2 Amit Gupta 10 Kyle M Hall 2 Mason James 2 Srdjan Jankovic 1 Piotr Kowalski 12 Owen Leonard 2 Julian Maurice 1 Matthias Meusburger 3 Sophie Meynieux 7 Dobrica Pavlinusic 6 Paul Poulain 1 Liz Rea 3 Marcel de Rooy 1 Fridolyn SOMERS 1 Adrien Saurat 2 Robin Sheat 1 Simon Story 1 Marc Veron 1 Ian Walls We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patc...@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
Re: [Koha] Koha 3.8.2 Released
1Stéphane Delaune 4Frédéric Demians That should be 1 Stéphane Delaune 4 Frédéric Demians Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] REPOST: Need step by step to upgrade Koha from 3.x to latest 3.8
On 22 June 2012 11:11, jp_powell nice2o...@gmail.com wrote: I am running on Debian Squeeze. I have made a complete system backup (just in case things don't go the way it should), and dumped the library database into a SQL file. I posted once before for instructions on how to upgrade Koha on Debian and I received 1 response but the person cautioned that it was untested. I was waiting for that person to confirm the process. After reading that response a few times, I really had a hard time trying to follow the process. So, I am reposting the request for step-by-step please. I plan to work on this server this coming weekend so a response would be helpful. If someone would rather work with me via instant messaging, please send email directly to my email address nice2odie at gmail dot com. I live in USA, in the Central Daylight time. Request; I need to be able to upgrade a PRODUCTION KOHA system to the latest version. There should be a process in place to make this easy. Exactly what version are you running, and how did you install it? The answer to both these questions has a huge bearing on how you upgrade. If you installed via the packages, then apt-get upgrade is all you need to do. If you installed via the tarball and are running a version of Koha released in the last few years (3.2.x or later). Then in the INSTALL file are the instructions on how to upgrade. Of course you should always do your upgrade of any software on your staging server first, and then production. Koha is no exception to that rule. I would have a staging server running the exact version you have on production, then upgrade that. If it all goes well, do it on production. From the INSTALL file in the tarball or in git UPGRADE === If you are running in another language other than english, please switch to english before doing the upgrade, the templating system has changed and the templates will need to be regenerated. Once you have upgraded, please regenerate your templates in your chosen languages. If you are upgrading from a previous installation of Koha 3.x, you can use the following: ./koha_perl_deps.pl -u -m # to identify new Perl dependencies Install any missing modules IMPORTANT: Koha 3.4.0 and greater uses Template::Toolkit, this must be installed before the webinstaller can run On debian/ubuntu sudo apt-get install libtemplate-perl Other Linux/Unix platforms Use the packaged version or install from CPAN cpan Template perl Makefile.PL --prev-install-log /path/to/koha-install-log make make test sudo make upgrade Koha 3.4.x or later no longer stores items in biblio records. If you are upgrading from an older version ou will need to do the following two steps, they can take a long time (several hours) to complete for large databases misc/maintenance/remove_items_from_biblioitems.pl --run misc/migration_tools/rebuild_zebra.pl -b -r Hope this helps Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to Make report in CSV/XLS format
* umer.ha...@techlogix.com (umer.ha...@techlogix.com) wrote: Hi, Is there some way that i could make a report in csv (excel) file. currently i am trying to make a report for all the students having fines in their accounts and then output it in CSV format, but the options available are just the 'coma seperated text' and 'tab seperated text'. i want a csv or xls file output. any idea? CSV is comma separated text :) Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Request to be listed as provider of paid support
On 21 June 2012 01:26, Mr Gerhard Bissels gerhard.biss...@library.coop wrote: Dear List, we seem to have forgotten to ask to be listed in the directory of providers of paid support. Could we be added, please? Best wishes No objections from me, I think its a great service you are seeking to provide. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] OPAC User Can Not Login to Koha
On 6 June 2012 20:54, Andi Sugandi andisuga...@gmail.com wrote: Hi all, As $Subject said, OPAC user fails to login to Koha (v. 3.8.1) through form login on Catalog main page or on OPAC login page[0]: This is the koha-opac-error_log (/home/subdomain_name/public_html/cgi-bin/var/log/koha-opac-error_log)[1], and using MySQL Server version 5.1.63. Any suggestion? What user are you trying to login as? You can not login to the opac as the kohaadmin user, you will need to make a real user in the staff interface first. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] how to undo global due date?
Ian Walls koha.sek...@gmail.com wrote: ceilingDueDate and globalDueDate shouldn't be in your 3.8 system; they were deleted as part of the database update that moved them to the circulation matrix (issuingrules table). Yep but if for whatever reason this didn't run or failed the code still refers to at least one of them. That's a legit bug we need to tidy up. Chris You should be able to re-enter your rules in the Circulation and Fines rules area under the Administration. You'll have to do this for all your rules, which could be a pain. What might be easier is: UPDATE issuingrules SET hardduedate = '-YY-ZZ' WHERE hardduedate = '2012-05-17'; Where '-YY-ZZ' is the new global due date you want to set for all materials. If you want finer grain control (only applying a global due date for certain item types, patrons or branches), you'll need to either use the Circulation and Fines editor in Admin, or add a series of additional WHERE clauses to the query. Hope this helps, -Ian On Thu, May 31, 2012 at 5:14 PM, Chris Cormack chr...@catalyst.net.nzwrote: * jrhsigler (jrhsig...@gmail.com) wrote: Thanks, I looked in 'local use' but didn't see any options for changing global due dates. I'm at Koha 3.8 now, but set the global due date when I had 3.4 running. Do you have a sample sql statement that I can use to update the database directly? Thank you! Hi, Sorry about the slow reply, timezones are a pain. Ok the variable is called ceilingDueDate So DELETE FROM systempreferences WHERE variable ='ceilingDueDate'; Will kill that line completely. There is also globalDueDate DELETE FROM systempreferences WHERE variable ='globalDueDate'; To get rid of it However if you wanted to file a bug also, because there must be code still referencing the old dead syspref, that we need to purge. So bonus points if you go to bugs.koha-community.org and add a bug something like Vestiges of code still refer to deprecated syspref globalDueDate Its in C4/Circulation.pm that the bad code is so you could at that, and then someone can write a patch to clean it up, extra super mega bonus points if you write the patch too :) Chris -- View this message in context: http://koha.1045719.n5.nabble.com/how-to-undo-global-due-date-tp5714544p5714621.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] how to undo global due date?
* Eric Sigler (eric.sig...@gmail.com) wrote: Thanks for the help, I checked the database and there was a ceilingDueDate and a GlobalDueDate set in the systempreferences table. I deleted those rows from the database and verified that they're gone. We only have one circulation rule defined so I also deleted it and recreated it. The circulation rule does not have a hard due date defined and simply specifies a 21 day loan period. Unfortunately, we're still experiencing the same problem. When books are checked out, they're still assigned a due date of 5/17/2012. Any other suggestions? I verified that the server's system date is correct. You could try UPDATE issuingrules SET hardduedate = NULL WHERE hardduedate = '2012-05-17'; Actually just check issuingrules to make sure you do indeed only have that one rule. If not, that would be your problem. Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] how to undo global due date?
* jrhsigler (jrhsig...@gmail.com) wrote: Thanks, I looked in 'local use' but didn't see any options for changing global due dates. I'm at Koha 3.8 now, but set the global due date when I had 3.4 running. Do you have a sample sql statement that I can use to update the database directly? Thank you! Hi, Sorry about the slow reply, timezones are a pain. Ok the variable is called ceilingDueDate So DELETE FROM systempreferences WHERE variable ='ceilingDueDate'; Will kill that line completely. There is also globalDueDate DELETE FROM systempreferences WHERE variable ='globalDueDate'; To get rid of it However if you wanted to file a bug also, because there must be code still referencing the old dead syspref, that we need to purge. So bonus points if you go to bugs.koha-community.org and add a bug something like Vestiges of code still refer to deprecated syspref globalDueDate Its in C4/Circulation.pm that the bad code is so you could at that, and then someone can write a patch to clean it up, extra super mega bonus points if you write the patch too :) Chris -- View this message in context: http://koha.1045719.n5.nabble.com/how-to-undo-global-due-date-tp5714544p5714621.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problems with the Koha wiki - registration and editing for new users
The wiki used to relay through my personal linode (whichs runs bugs.koha-community.org) but as you can see something/one is trying to spam quite heavily. What they are doing is entering email addresses that aren't their own so innocent people get mail, they then mark as spam and bugs.koha-community.org ends up in blacklists. I've disabled the relay and removed bugs from the blacklists it was on. Hopefully Galen and the others who look after the wiki can come up with a way to stop it, or another way to confirm users. Chris Paul pau...@aandc.org wrote: At 01:20 PM 5/30/2012 +, someone wrote: I was trying to edit the wiki and had the same problem, no confimration email. I tried, yahoo and gmail as well. Nothing in my work outlook spam filters. Maybe something is badly overwhelmed at the wiki end? I just had a quick look at the User Creation Log http://wiki.koha-community.org/w/index.php?title=Special:Loglimit=500type=newusersmonth=year=; and there have been 500 new accounts created in the last two weeks. Most of them look like automated spammer sign-ups -- and quite frankly I don't think this community group could|would have shown such interest ;-} Best - Paul _ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] how to undo global due date?
On 31 May 2012 02:30, jrhsigler jrhsig...@gmail.com wrote: Greetings, I need some help with a problem I've encountered in the circulation rules. About six months ago I set a global due date for May 17, the end of the semester. Since then, we've updated Koha a couple times, and I can no longer find the page where I set the global due date. (From my reading, it appears that this feature has been replaced with circ rules?) The system is still maintaining the May 17 due date. I'm not sure how to reset this. In the meantime, every time I check out a book, I have to confirm the action and manually create due dates. All books checked out now are immediately overdue I've made sure that there are no hard due dates set in the circulation rules, but this hasn't made any difference. Can you find the systempreference in the localuse tab? Try looking in that tab under systempreferences If not, you can change it in the db. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha-Kobli in Spanish Ministry of the Presidency Library
Hi Domingo Very very pretty, nicely done. I do really like the opac links back to koha-community.org too. Well done and nice to see another Hugh profile library using Koha. Chris info.s...@mecd.es wrote: Good morning, Spanish Ministry of the Presidency Library ( http://mpr.bage.es ) goes live on Koha-Kobli. It is the result of migration of data from the previous library management system and opens the possibility of access to specialized collections in law, politics, history, social sciences, etc. contained in this library. The main mission of the Library of the Ministry of the Presidency is to provide bibliographic support services to the Ministry staff. This project is included in the action of the General Coordination Committee for the General State Authority Libraries (CGCBAGE) of implementing, in a coordinated way, the library management system Koha-Kobli in certain libraries in its network. This action is implemented by the Subdirectorate General of Library Coordination of the Ministry of Education, Culture and Sports as CGCBAGE secretariat. Further information at http://kobli.bage.es/implantacion-de-koha-kobli-1-4-en-las-bages-biblioteca-central-del-ministerio-de-la-presidencia/ Best regards, Domingo Arroyo Koha-Kobli Coordinator Subdirectorate General of Library Coordination Ministry of Education, Culture and Sports Plaza del Rey, 1 28071 Madrid (Spain) info.ko...@mecd.es http://kobli.bage.es _ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] problems when make uprgade koha3.6 to 3.8.1
* kouider bounama (koha4a...@gmail.com) wrote: hi all i make uprgade koha3.6 to 3.8.1 but find this errors when i go to http://127.0.1.1:8080/ Software error: Can't locate DateTime/Format/DateParse.pm in @INC (@INC contains: /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 .) at /usr/share/koha/lib/Koha/DateUtils.pm line 23. What that tells you is you are missing at least one perl module. run ./koha-perl_deps.pl -m In your unpacked tarball, or git checkout, to see if you missing any others. Then install them Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] problems when make uprgade koha3.6 to 3.8.1
* kouider bounama (koha4a...@gmail.com) wrote: i do this cd koha ./koha_perl_deps.pl Usage: ./koha_perl_deps.pl -m Yes as I said you need to run ./koha_perl_deps.pl -m Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] problems when make uprgade koha3.6 to 3.8.1
* kouider bounama (koha4a...@gmail.com) wrote: Total modules reported: 3 DateTime::Format::DateParse0.04 Readonly 1.03 Readonly::XS 1.02 how i can install this or what the commends to install What flavour of linux are you running? If debian or ubuntu, you should be able to sudo apt-get install libdatetime-format-dateparse-perl libreadonly-perl libreadonly-xs-perl Otherwise, cpan them on. Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] problems when make uprgade koha3.6 to 3.8.1
* kouider bounama (koha4a...@gmail.com) wrote: iam use ubuntu thank you i install the 3 modules its work installer web thank you Did the update complete, are you able to login? if so then you can probably ignore those. Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 3.8.1 released
Bug Wranglers: Katrin Fischer, Magnus Enger Release Maintainer (3.4.x): Chris Nighswonger cnighswon...@foundations.edu Release Maintainer (3.6.x): Jared Camins-Esakov jcam...@cpbibliography.com Release Maintainer (3.8.x): Chris Cormack chr...@catalyst.net.nz Credits == We thank the following individuals who contributed patches to Koha 3.8.1. 2 Jared Camins-Esakov 3 Colin Campbell 8 Chris Cormack 2 Stéphane Delaune 7 Jonathan Druart 4 Magnus Enger 6 Katrin Fischer 4 Kyle M Hall 2 Srdjan Jankovic 4 Owen Leonard 1 Julian Maurice 1 Chris Nighswonger 1 Dobrica Pavlinusic 4 Paul Poulain 2 Liz Rea 2 Marcel de Rooy 3 Adrien Saurat 3 Robin Sheat 2 Lyon3 Team 2 Ian Walls We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patc...@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.8.x (i.e., this version of Koha and future bugfix releases) is 3.8.x. The next major feature release of Koha will be Koha 3.10.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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Introduction and Database Transfer Question
Hi Robert, and welcome. The most likely reason you are getting the installer screen is version differences between the Kohas. If the new server has a newer kohaversion number than what is in the .sql the web installer will kick in to upgrade the db. That's what I would check. Chris On May 15, 2012 7:37 AM, Robert Williams willi...@amigos.org wrote: Hi All: I've been lurking for a while, slowly crawling up the Koha learning curve (climbing the curve might be a bit overstated :-) ). I'm working with a library services company preparing to help some of our member libraries test/migrate to Koha. Thanks to contributions here, I've gotten around a couple of vexing problems. So, first, thanks to the everyone for sharing experiences! I have question related to transferring a Koha database from one server to another. I'm using the koha-common Debian packages (3.6.4). I've configured a Debian virtual server (32-bit Debian Squeeze) with all the Koha requirements. It's all running smoothly. I've imported patron and bibliographic data and dome some basic playing with the system. All is well. To test moving the Koha database to a separate machine, I've created a second Koha instance. I have used mysqldump to create a .sql file of the complete database contents. Then I've re-populated the second instance's database using the mysql utility, logging in as the second instance user. When I test access to the second instance, all appears well (except that I need to learn to re-index the second instance data with Zebra--on the way there). I can login to Koha's staff interface and see the patron and bib data. When I try the same procedure, except by transferring the .sql file to a separate computer (64-bit Debian Squeeze; otherwise same setup). I re-populate the new Koha instance there, and can see all the data using the mysql utility (or MySQL Workbench from outside the computer). However, when I try to login to Koha's staff interface, I get the initial web installer screen instead of a staff login screen. If I reload the instance's base Koha database (from a separate/backup .sql file), I can login fine. Try re-loading the real data from the original .sql file, I get the same web installer interface problem. I've probably missed a piece of knowledge somewhere along the learning curve. Hopefully not something obvious. And not something I missed in searching the list archives. Is there some 32/64-bit Debian issue (maybe a character set/code page discrepancy) inherent in the two different versions that might cause the problem? My logical mind says all the database fields should be set correctly in either case, so that's all I can think it might be. Does anybody working with the Debian packages of koha-common have an idea what I might be doing wrong? If I need to be smacked for trying to move a file from 32-bit to 64-bit OS, smack gently ;-) . Thanks! --Robert * Robert L. Williams Manager, Open Source ILS Services Amigos Library Services, Inc. 14400 Midway Road Dallas, TX 75244-3509 800-843-8482, x2870 972-340-2870tel:972-340-2870 (direct) 972-991-6061tel:972-991-6061 (fax) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 3.8.1 entering string freeze
Hi All As promised, the 3.8.x branch has entered string freeze in preparation for the 3.8.1 release next week. So? you ask, What does this mean for me? Are you a developer? - If so just be aware I will only be pushing patches that do not contain changes to any of the translatable strings from now until the release. Are you a translator? - Once the translation manager emails to say the po files are updated, you are clear to translate your hearts out. Are you a Koha user? - If you have the skills or know someone who does, check out the 3.8.x and do some testing on it, that would be awesome. Are you a brewer? - I quite like a nice IPA Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] RDA fields 336, 337, 338
On 12 May 2012 09:09, BWS Johnson abesottedphoe...@yahoo.com wrote: Salvete! T he working Group of spanish Koha-Kobli community (http://kobli.bage.es) is finishing to bring up to date the default framework to the last update of MARC21, the 14 (April 2012), we will send it to Koha community shortly. We believe that it is not at all incompatible to update the default framework with to add functionalities related semantic web and RDA. Anyway we need to be able to collect certain information in the fields and subfields of MARC framework to add these new features Sweet. :D Hi Cecil These could be added to the default framework and plugins developed. But since the Library of Congress has backed right off RDA + MARC and has said that that is not the way forward. We lost urgency on adding this. I think in terms of RDA the work Magnus is doing with SemantiKoha and RDF is going to be much more use in the long run. Excepting that they haven't. This was sent out to the GOVDOCS listserv. Except that they have http://www.loc.gov/marc/transition/news/framework-103111.html Chris Cheers, Brooke _ Please find below Beacher Wiggins, Director for Acquisitions and Bibliographic Access, Library of Congress' announcement of the electronic journal, LCCN. Richard Yarnall, Section Head U.S. Government Documents Section U.S./Anglo Division Library of Congress 101 Independence Ave., SE Washington, D.C. 20540-4274 r...@loc.gov 202-707-9470 202-707-9474 202-707-0380, fax I'm pleased to introduce the newest issue of LCCN, the electronic journal of the Library of Congress Acquisitions and Bibliographic Access Directorate. LCCN was the first e-journal to be issued by the Library of Congress. It was first published in January 1993 and ran until June 2008. After a hiatus of nearly four years, we are reviving the publication in order to share informal news and background stories from LC's technical processing staff with the library community. Policy updates and other official news will continue to be posted on our Cataloging and Acquisitions Website at http://www.loc.gov/aba/ The Acquisitions and Bibliographic Access Directorate is a very different place in April 2012 than it was in June 2008. We have completely redesigned our workflows and merged acquisitions and cataloging tasks; tested and agreed to implement RDA: Resource Description and Access in conjunction with the other U.S. national libraries, probably in March 2013; and begun inputting metadata in original scripts directly to our integrated library system. As staffing has decreased from 600 in 2008 to just under 500 employees today, ABA is a leaner, more efficient organization. We proved that assertion by our record-high cataloging production in 2010 and 2011 and record acquisitions in 2011. Moreover, a career in technical processing at LC is more challenging and intriguing than ever, as LCCN's new series A Day in the Life of ... shows. Welcome to the new LCCN! Beacher J. Wiggins Director for Acquisitions and Bibliographic Access Library of Congress LCCN is available in electronic form only and is free of charge. To subscribe, send a mail message to lists...@listserv.loc.gov with the text: subscribe lccn [firstname lastname]. Please be sure that the text is the body of the message, not the subject line. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] RDA fields 336, 337, 338
On 12 May 2012 10:04, BWS Johnson abesottedphoe...@yahoo.com wrote: Salvete! Excepting that they haven't. This was sent out to the GOVDOCS listserv. Except that they have http://www.loc.gov/marc/transition/news/framework-103111.html That's from October. This is from today. http://lists.psu.edu/cgi-bin/wa?A2=ind1205BL=GOVDOC-LT=0F=S=P=25864 I think they're just kicking the can down the road because it's hard. RDA and FRBR are close in spirit to what Koha originally was, and the sort of thing I'd like to see it become again in future. RDA is fine, MARC is broken, the steering committee acknowledge it is not fit for purpose and RDA + MARC = mess. RDA done properly would be good, RDA done the way the 26 testers have tried and rejected, no not so much Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] RDA fields 336, 337, 338
On 10 May 2012 05:51, Hillyard, Cecil chilly...@washoecounty.us wrote: Hi All, Regarding the RDA fields 336, 337, 338 are these in development somewhere? Will these be fields that can be completed with authorized values that can be developed locally or things with plugins? Hi Cecil These could be added to the default framework and plugins developed. But since the Library of Congress has backed right off RDA + MARC and has said that that is not the way forward. We lost urgency on adding this. I think in terms of RDA the work Magnus is doing with SemantiKoha and RDF is going to be much more use in the long run. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Want to add more feature or module in koha
On May 9, 2012 10:58 PM, sunil sharma koha.sunil...@gmail.com wrote: Dear All, I am Sunil from India and I want to start my carrier with koha, open-source Integrated Library System. I am working at koha from last 4 months and currently at some developing level, I observe all the feature of koha but I want to add some more feature in koha-community's koha like in liblime koha, which are: 1. Libraries can create new receipt templates for reach library by clicking New Receipt Template in the Receipt Template Manager which we add in any sys pref i.e. at Tools. (in other words: Koha will features customizable print slips and a management interface for the creation, alteration, saving, and deleting of customize print slips circulation receipts). This is already done, patches for it are on bugzilla. 2. Koha features a rich set of features around holds: including: - Ability to fill local holds first (thus reducing transportation costs) Already done. - Enriched holds queue report, including sort and pagination support for large list printing and functionality so a hold can be filled (triggered) or passed to another library directly from the report - New hold notices – for holds canceled and/or expired I think this is done already also. 3. the last I want to generate my report in word format also, as by default it is in csv format. Word is proprietary, so I have no interest in this, others might I guess. Hope the community help me on these topics. First place to start is bugs.koha-community.org Chris Thanks in Advance, Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Let Unimarc and USmarc work together
Just a note Koha supports MARC21, UNIMARC and NORMARC. But like Zeno says supporting records of all three (and more) in one installation would be a decent amount of work. And therefore quite unlikely to be done unless someone is willing to fund the work. Chris On Apr 28, 2012 8:58 PM, taj...@cilea.it wrote: Hi Peter Oggetto: [Koha] Let Unimarc and USmarc work together Dear developer, Koha is a wonderful library system. The current version just allows to choose either UNIMARC or USMARC. How can let Koha support to choose both UNIMARC and USMARC? I hope the future version can let more option on marc framework. In the near future Koha will support better the two standard. You can help on this bug for this topic: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6536 But it is impossible to plan now to support records in both UNIMARC and MARC21 format together in the same installation. For example tag 100 has a specific meaning (Main Author as persone) in MARC21 and a very different in UNIMAC (GENERAL PROCESSING DATA, as 008 in MARC21). In theory it is possible but it is very huge change and non ILS has now this feature (thing about Evergreen, Aleph500, Millennium, etc.). Bye Zeno Tajoli ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha release 3.8.0 - Thanks
On 25 April 2012 18:14, librarian librar...@bahria.edu.pk wrote: Thank you very, very much Chris and to all the team that really did a great job keep it up and this is indeed a great job. Congregation I didn't do much this release, just some patches and sign offs, the real people to thank are Release Manager - Paul Poulain QA Manager - Ian Walls Assistant QA - Marcel de Rooy and Jonathan Druart Translation Manager - Frédéric Demians Assistant Translation Manager - Katrin Fischer Documentation Manager - Nicole Engard Bug Wranglers - Katrin Fischer, Magnus Enger, Owen Leonard Packaging Manager - Robin Sheat And the 70 other people with patches and all the people who signed off. In fact in my opinion signing off on a patch is exactly as important as writing one. You can check out some statistics at http://blog.bigballofwax.co.nz/2012/04/24/statistics-for-koha-3-8-0/ I encourage everyone to get involved for 3.10 .. lets get 100 developers and as many people signing off for it :) So if you want to help the project, and get your name in the history, join in. With the fantastic sandboxes Biblibre have developed anyone can signoff. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha 3.8.0 Released
On 24 April 2012 19:19, Paolo Bizzarri paolo_bizza...@yahoo.it wrote: Thank you very, very much Chris and to all the team that really did a great job! Hi Paolo I just sent out the release notes, Paul and the release team did all the hard work, they deserve your thanks not me :) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 3.8.0 Released
-community.org for announcement) Upgrading == If you have a Koha already running, you must take care of the following changes: * The SIP start and shutdown scripts and configuration file have been moved from C4 directory to misc/bin, Update your system or your SIP server won't work anymore * The cleanup_database.pl script has 2 new options, to clean-up imported records and logs, update your crontabnbsp;: --import DAYS purge records from import tables older than DAYS days. Defaults to 60 days if no days specified. --logs DAYS purge entries from action_logs older than DAYS days. Defaults to 180 days if no days specified. * The Date::ICal dependancy has be removed and a DateTime::Format::ICal has been introduced, update your perl packages on your servernbsp;! * The memcache configuration has been moved from koha conf file to Apache configuration file Also note that Koha 3.4.x or later no longer stores items in biblio records. If you are upgrading from an older version ou will need to do the following two steps, they can take a long time (several hours) to complete for large databases misc/maintenance/remove_items_from_biblioitems.pl --run misc/migration_tools/rebuild_zebra.pl -b -r Documentation == The Koha manual is maintained in DocBook format. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, the Koha manual is available: english: http://manual.koha-community.org/3.8/en/ french: http://manual.koha-community.org/3.8/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 are available in this release for the following languages: * French (100%) * Spanish (100%) * German (100%) * Chinese -Taïwan- (97%, OPAC 100%) * Italian (86%, OPAC 100%) * Danish (81%) * Portuguese (79%) * French -canada- (76%) * English -nz- (76%) * Greek (74%) * Norwegian (73%) Note that some strings in online help have been introduced after string freeze, so: * the previous number don't count them * you'll find some strings in english in online help Partial (less than 50%) 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.8 is Release Manager: Paul Poulain paul.poul...@biblibre.com Documentation Manager: Nicole C Engard neng...@gmail.com Translation Manager: Frédéric Demians frede...@tamil.fr QA Manager: Ian Walls koha.sek...@gmail.com QA team: Marcel de Rooy m.de.r...@rijksmuseum.nl, Jonathan Druart jonathan.dru...@biblibre.com Bug Wranglers: Katrin Fischer, Magnus Enger Release Maintainer (3.4.x): Chris Nighswonger cnighswon...@foundations.edu Release Maintainer (3.6.x): Chris Nighswonger cnighswon...@foundations.edu Release Maintainer (3.8.x): Chris Cormack chr...@catalyst.net.nz Credits == The following individuals contributed patches to Koha 3.8.0.: Paul Poulain Owen Leonard Katrin Fischer Chris Cormack Colin Campbell Marcel de Rooy Dobrica Pavlinusic Nicole C. Engard Kyle M Hall Ian Walls Jonathan Druart Jared Camins-Esakov Adrien Saurat Frédéric Demians Julian Maurice Srdjan Jankovic Liz Rea Robin Sheat Magnus Enger Duncan Tyler Elliott Davis Garry Collum Chris Hall Frédérick Capovilla MJ Ray Juan Romay Sieira Chris Nighswonger Alex Arnaud Sam Sanders Maxime Pelletier Matthias Meusburger Sophie Meynieux Tomas Cohen Arazi Mason James Marc Balmer Stéphane Delaune Henri-Damien Laurent D Ruth Bavousett Connor Dewar Christophe Croullebois Zeno Tajoli Gaetan Boisson Aleksa Vujicic Brendan Gallagher Marc Veron Galen Charlton Serhij Dubyk {Сергій Дубик} Janusz Kaczmarek Salvador Zaragoza Rubio Koustubha Kale Kate Henderson Jono Mingard Albert Oller Frère Sébastien Marie Martin Renvoize Peter Lorimer Bart Jorgensen Jorgia Kelsey Lyon3 Team James Mason Jesse Maseto Fridolyn Sommers Jon Aker Greg Barniskis Joy Nelson Nahuel Angelinetti We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patc...@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.8.x (i.e., this version of Koha and future bugfix releases) is 3.8.x. Bugs and feature requests == Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org
Re: [Koha] Koha 3.8.0 Released
On Apr 24, 2012 5:22 PM, Hugo Agud ha...@orex.es wrote: Hello It is a great, great job congratulations to everybody, I have one question on the new release, I read that was planned for release in 3.8 the chance of sharing , subscription patterns (kardex) between koha sites. Is that feature included in 3.8 i have not seen it in the list you have provided Hi Hugo I can't see it in bugzilla or on the wiki. So I don't think anyone has been working on this. Where did you hear about it? Once again, thank you very much for this greeat job! Yes a big thank you to Paul Poulain our release manager, and to the rest of the release team. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Kohacon13 Bid
On 20 April 2012 23:20, Olugbenga Adara gbengaad...@yahoo.com wrote: Hello all, Projektlink Konsult Limited, Nigeria has decided to make a bid for Kohacon13. As some of those at Kohacon10 may remember, I said during my skype presentation that we hope Kohacon will come to Nigeria before Kohacon15. We have now put up a bid on http://wiki.koha-community.org/wiki/Kohacon2013#Proposals_for_hosting I do hope to put up a dedicated page to offer more info about the bid, and your support will really help to encourage us. We are considering hosting within the campus of the International Institute of Tropical Agriculture (IITA) with their world class conference facility. Hi Olugbenga Fantastic! You have my support! See you in Scotland :) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Bulk patron anonymize/delete tool
On 20 April 2012 06:48, Tom Hanstra t...@nd.edu wrote: OK, I think I found the problem. We have a number of patrons who were created (or somehow set) the privacy setting on their accounts. This was not readily visible and not taken into account when we were trying to perform the anonymizing. Where on the OPAC can a patron set their privacy flag? I've not seen where that option can be set. Thanks, Tom Hi Tom If in systempreferences you have OpacPrivacy switched to allow, then on the opac-user.pl page, the borrower will see a link to my privacy That is where they can change their privacy settings Chris On 04/17/2012 10:16 AM, Tom Hanstra wrote: What are your other system preference values with regard to Privacy? Perhaps we have a different combination of options in place? We have: Don't Allow AnonSuggestions Keep for EnableOpacSearchHistory Don't allow OPAC Privacy Allow opacreadinghistory Thanks, Tom On 04/17/2012 03:55 AM, Chris Cormack wrote: On 17 April 2012 09:41, Tom Hanstrat...@nd.edu wrote: 3.6.4 Thanks! Tom Hi Tom So I checked out 3.6.4 set up a borrower to use, and put that borrowernumber (17) into the anonymous patron syspref I then ran the anonymise feature and now select * from old_issues limit 3; +++++---++-++--+-++ | borrowernumber | itemnumber | date_due | branchcode | issuingbranch | returndate | lastreneweddate | return | renewals | timestamp | issuedate | +++++---++-++--+-++ | 17 | 6 | 2009-01-24 | WORK | NULL | 2009-01-03 | NULL | NULL | NULL | 2012-04-17 19:52:30 | 2009-01-03 | | 17 | 2 | 2008-07-23 | WORK | NULL | 2009-04-19 | NULL | NULL | NULL | 2012-04-17 19:52:30 | 2008-07-02 | | 17 | 4 | 2009-05-10 | OFFICE | NULL | 2009-04-19 | NULL | NULL | NULL | 2012-04-17 19:52:30 | 2009-04-19 | +++++---++-++--+-++ They have all been changed to borrower 17, so it seems to be working fine for me I'm not sure what we are doing differently. Chris -- Tom Hanstra Systems Administrator Hesburgh Libraries of Notre Dame Phone: (574)631-4686 213 Hesburgh Library Email: t...@nd.edu Notre Dame, IN 46556 Now, here, you see, it takes all the running you can do, to keep in the same place. If you want to get somewhere else, you must run at least twice as fast as that! Lewis Carroll - Through the Looking Glass ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] patron circulation issue
On 19 April 2012 08:15, Jennifer Coleman-Davidson c...@bonnechereupl.com wrote: Hi, We've recently been having an issue with circulating books to some of our patrons. When we scan the book a yellow box appears near the top of the screen but it doesn't say anything and the system won't allow the patron to sign the book out. It seems to be a patron specific problem and not a book specific problem. We've checked all the patrons' information and nothing seems to be wrong in that area. Any ideas as to what is the underlying cause? Hi Jennifer What version of Koha? And have you checked the circulation rules? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Bulk patron anonymize/delete tool
On 17 April 2012 09:41, Tom Hanstra t...@nd.edu wrote: 3.6.4 Thanks! Tom Hi Tom So I checked out 3.6.4 set up a borrower to use, and put that borrowernumber (17) into the anonymous patron syspref I then ran the anonymise feature and now select * from old_issues limit 3; +++++---++-++--+-++ | borrowernumber | itemnumber | date_due | branchcode | issuingbranch | returndate | lastreneweddate | return | renewals | timestamp | issuedate | +++++---++-++--+-++ | 17 | 6 | 2009-01-24 | WORK | NULL | 2009-01-03 | NULL| NULL | NULL | 2012-04-17 19:52:30 | 2009-01-03 | | 17 | 2 | 2008-07-23 | WORK | NULL | 2009-04-19 | NULL| NULL | NULL | 2012-04-17 19:52:30 | 2008-07-02 | | 17 | 4 | 2009-05-10 | OFFICE | NULL | 2009-04-19 | NULL| NULL | NULL | 2012-04-17 19:52:30 | 2009-04-19 | +++++---++-++--+-++ They have all been changed to borrower 17, so it seems to be working fine for me I'm not sure what we are doing differently. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha 4 timeframe
On 17 April 2012 11:22, clint.deckard clint.deck...@frontiers.co.nz wrote: Greetings, I seem to recall a small discussion at some stage during Kohacon 2010 about the path to Koha 4, does anyone have anything further on this? An update of perl was floated? As far as I know it doesn't exist anywhere :) 3.8.0 will be released april 23, 3.10.0 will follow in October. http://koha-community.org/about/release-schedule/ http://koha-community.org/roles-koha-3-10-0/ Not sure when 4.0.0 would be, maybe April next year, we currently require a minimum of perl 5.10 (up from 5.8 in 3.2) so upgrading the minimum perl version doesn't mean we have to jump a major number. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Bulk patron anonymize/delete tool
On 17 April 2012 09:04, Tom Hanstra t...@nd.edu wrote: Well, that is what we have been doing. We have such a patron and we run the tool with that patron number in the System Preferences. The tool reports what it thinks should happen, which reflects what we expect to happen. But then, when run, no changes are actually made to the database and re-running the tool again reports that the same changes will be made. Hi Tom You have the borrowernumber right? Not the cardnumber? (Just checking) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Bulk patron anonymize/delete tool
On 17 April 2012 09:19, Tom Hanstra t...@nd.edu wrote: Yes. Good thing to check, but yes, I'm using the borrower number. Ok I'll try to recreate your issue tonight, just so we are comparing apples with apples, what version are you running? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Only 7 days until the deadline for submitting your talk for Kohacon12
If you are thinking about presenting at Kohacon12 at either conference or hackfest, you only have 1 week left to get your abstract in. So please head on over to http://koha-community.org/kohacon12/call-papers/ and submit your talk now. You know you want to :) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MARC Bibliographic Framework Test
On 12 April 2012 18:41, Alex87 aleted...@gmail.com wrote: Hi everybody! I state that i'm completely newbie with Koha, i have just install the last version of Koha and i'm trying to use it in local mode on my pc. Exactly what version is it? 3.6.4? You can check on the about page in Koha Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Ghost records
On 10 April 2012 08:49, Lenora Oftedahl o...@critfc.org wrote: I've got ghost records causing errors in a database transfer. I can't pull up these items in the staff interface. Is there another way to pull up these records and purge the last vestiges to get the database clean? We're upgrading from 3.0 to 3.6. Hi Lenora Are these biblios with no items attached? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] KUDOS 2012
On 10 April 2012 09:07, G. Laws glaw...@rhcl.org wrote: Us host KohaCon13? In St. Joseph, Missouri? After New Zealand, India and Scotland? Tell you what, let's all get together in Bangkok, Thailand, from June 1 to June 30 for KohaCon 2013. Nothing in the KohaCon charter says it has to be held near a Koha library, right? I can get there in mid-May and make all the arrangements, and stay till mid-July for cleanup. Hehe Seriously though, it's probably the US turn again, 2009 Plano was the last one, so I would seriously think about a Kohacon13 in the USA. Also there are Koha libraries in Thailand .. I think we'd have to go to Antartica to get away from them :) Also regional ones are a great idea, the NZ Koha users group is going to be having its second ever meeting sometime in the nearish future. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Ghost records
On 10 April 2012 09:42, Lenora Oftedahl o...@critfc.org wrote: As far as I can tell, they aren't even biblios anymore. Is there some way to find items that are not attached to biblios? Yup Try this SELECT itemnumber,barcode FROM items WHERE items.biblionumber NOT IN (SELECT biblionumber FROM biblio) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] KUDOS 2012
On 10 April 2012 10:02, G. Laws glaw...@rhcl.org wrote: Oh no, I took your comments as you intended, I think. So KohaCon13 in USA, you are suggesting? New OrleansSan AntonioMiami...San Fransisco Big cities are expensive, how about Lawrence Kansas .. home of NEKLS Chris PS Volunteering unsuspecting people is my thing ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Adding MARC fields
On 7 April 2012 22:40, Alan Pepelko alanpepe...@aim.com wrote: Koha 3.6 installed on Debian Squeeze. In that case, I bet you have all the subfields set to hidden. Take a look at https://yoursite/cgi-bin/koha/admin/marc_subfields_structure.pl?tagfield=080frameworkcode= And edit the ones you want to show. http://manual.koha-community.org/3.6/en/catadmin.html#marcbibframeworks Look at section 4.1.4 Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Searching by Barcode
On 4 April 2012 18:22, Ephraim Makeke make...@msu.ac.zw wrote: Hi In my cataloging module I would like to search by barcode so that it retrieves an exact copy of an item. At the moment if I search by barcode e.g. BK100, the cataloging module returns: Hi Ephraim Try searching on this ccl=bc,phr=BK100 It should return just that one result. By the way, what version of Koha are you running? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Need SQL query help, please
On 4 April 2012 00:32, Carol Kresge carol.kre...@gmail.com wrote: I have a query to find borrowers with late books that do not have email addresses or mobiles. Now I am trying to modify it so it will show their school from attributes if they have one but won't knock them off the list if they don't. My modification below shows only those with no email and no mobile and a school but knocks people off the list who have no school attribute. How can I modify it so it includes no mobile no email and lists school for those who have one but still includes those who don't? SELECT borrowers.surname,borrowers.firstname,borrowers.mobile,borrowers.email,borrowers.city, biblio.title,biblioitems.itemtype,issues.date_due,borrower_attributes.attribute FROM borrowers LEFT JOIN borrower_attributes on (borrower_attributes.borrowernumber = borrowers.borrowernumber) LEFT JOIN issues on (issues.borrowernumber = borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = issues.itemnumber) LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE issues.date_due DATE_SUB(now(), INTERVAL 8 DAY) AND issues.returndate IS NULL AND borrowers.mobile = ' ' AND borrowers.email = ' ' AND borrower_attributes.code = 'School' ORDER BY borrowers.surname asc; Hi Carol I think this will do it SELECT surname, firstname, mobile, email, city, biblio.title, biblioitems.itemtype, issues.date_due, (select borrower_attributes.attribute from borrower_attributes where code = 'School') as School FROM borrowers LEFT OUTER JOIN borrower_attributes on (borrower_attributes.borrowernumber = borrowers.borrowernumber) LEFT JOIN issues on (issues.borrowernumber = borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = issues.itemnumber) LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE issues.date_due DATE_SUB(now(), INTERVAL 8 DAY) AND issues.returndate IS NULL AND borrowers.mobile = ' ' AND borrowers.email = ' ' ORDER BY borrowers.surname asc; Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha