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

(no subject)
by Richard Forristall 23 Dec '09

23 Dec '09

New to Koha - had koha installed on a production server & needed a development version - created one on a new server using the koha virtual appliance at http://kylehall.info/index.php/projects/koha/koha-virtual-appliance/ Koha works fine, but I can't search on the catalog in OPAC pages. Using SQLyog, I copied the database from the production server to the development version. I try to search in the development version and get no results. I search in the production version and get results -- for the same word. Are there files associated with the search that are not part of the MySQL database that I'm missing? Thanks in advance for any guidance. Rick ------------------------------------------- Rick Forristall Programmer Analyst Goodwill of Central AZ 602.535.4078 -------------------------------------------

2 1

Koha 3.0.5 + cannot print labels
by Zico 22 Dec '09

22 Dec '09

Hi, i have just installed koha-3.0.5. Everything looks cool so far. But, the point is, i cannot print labels from there. When i go to Tools-> Label and Patron Card Creator -> Create a new batch -> *Add item(s) to batch * No windows comes... i mean, after clicking "Add item(s) to batch" .. another window should come.. as i saw in koha-3.0.1 & 3.0.4! But, nothing is coming here!!! Here, i want to add that, My active layout is ok. -- Best, Zico

3 11

Need for reindex with Zebra?
by David Schuster 22 Dec '09

22 Dec '09

In a legacy system that I used to be using we were encouraged to once a year do a complete system reindex to clean things up and make the system perform better. I have not seen any recommendations anywhere on this so was looking for opinions. I'm coming up on a very long holiday that would be perfect for this type of work. Thanks! David Schuster Plano ISD -- View this message in context: http://old.nabble.com/Need-for-reindex-with-Zebra--tp26575069p26575069.html Sent from the Koha - Dev mailing list archive at Nabble.com.

3 4

Will my patches for Bug 3730 (submitted in October) be applied for Koha 3.0.5?
by Ricardo Dias Marques 21 Dec '09

21 Dec '09

Hi all, I've been monitoring the git.koha.org web site for the 3.0.x branch of Koha: http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=shortlog;h=3.0.x I noticed that Henri-Damien LAURENT submitted the release notes for 3.0.5. So, I assume that Koha 3.0.5 release is imminent and that is great. Thanks again to Henri for being the release maintainer for the 3.0.x branch! :) The release notes for 3.0.5, in git is available at: http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=misc/release_notes/r… Short URL for that: http://tinyurl.com/ydau23n However, I can't find the following patch(es) of mine, for Bug 3730, that I submitted in October, in the Release Notes for 3.0.5: [Koha-patches] [PATCH] Fix for Bug 3730 - Wrong ISO 639-2 Language Code for Portuguese in database http://lists.koha.org/pipermail/koha-patches/2009-October/004766.html [Koha-patches] [PATCH] Follow-up patch for my Fix for Bug 3730 http://lists.koha.org/pipermail/koha-patches/2009-October/004770.html So, my question is: will my patches for Bug 3730 (submitted in October) be applied for Koha 3.0.5? Or were my patches rejected by some reason (I can't find any reference to that)? BTW: I noticed some small mistakes in the Release Notes for 3.0.5 (for instance, due to the recent Pootle upgrade done by Chris Cormack, the URL http://translate.koha.org/languages/ isn't valid anymore). Thanks in advance! :) Cheers, Ricardo Dias Marques lists AT ricmarques DOT net Installation Guide for Installing Koha 3 on openSUSE 11 http://wiki.koha.org/doku.php?id=opensuse_11.0

2 2

Multiple Library Search :: Help Needed
by nitesh rijal 21 Dec '09

21 Dec '09

Hello all. We have hosted 10 different Libraries at 10 different Public IPs. Now while searching the koha catalog from the OPAC view of any one of the libraries, is it possible to limit the search to one of the libraries we have hosted??? I mean to say that suppose that we browse the opac interface with the IP of Libarary A, then is it possible to select the branch as Libarary B in the limit options provided by KOHA and then get the results from only Library B ??? I have already added certain libraries and group into it. Libarary A : 202.70.88.22 Libarary B : 202.70.88.23 Please Help. -- Nitesh Rijal BE IT email: rijal.it(a)gmail.com url: http://niteshrijal.com.np facebook: http://facebook.com/openrijal twitter: http://twitter.com/openrijal +9779841458173

3 2

koha 3.0.4 + holdings + "no physical items available"
by Zico 20 Dec '09

20 Dec '09

Hi, in my new Koha 3.0.4 system which running under Debian 5.0; i am facing problem regarding holding issue. Say, i have 5 holdings for some book; now if i search for that book in OPAC; it shows me that, there are 5 holdings but *only one* physical item is showing there... others are showing that... "no physical items for this record"! How can i get rid of this? -- Best, Zico

1 0

Help with SQL report
by Adrea Lund 18 Dec '09

18 Dec '09

Dear KOHA Users, With the help of Beverly Church at Liblime (Thank You Beverly!!), our library is trying to get an SQL report that we can use for weeding our collections. We are getting closer to what we want, but we have gotten stuck - are there any SQL gurus out there who can help us? Right now we have the following 2 reports. we want to merge them into one report (I'll describe how below). Report #1 gives us all items within a specified call number range with less than 5 total circulations during a specified time period (circulations include issues, renewals and local use). select count(*), itemcallnumber as ' call number', dateaccessioned, author, title, barcode, datelastseen as 'last seen', itemlost as 'lost status', damaged from statistics, items, biblio where statistics.itemnumber = items.itemnumber and items.biblionumber = biblio.biblionumber and statistics.type in ('issue','renew', 'localuse') and date(datetime) between '2004-01-01' and '2009-12-31' and itemcallnumber between 'MUSIC 1999 CD' and 'MUSIC ZZ TOP CD' group by statistics.itemnumber having count(*) < 5 order by cn_sort Report #2 gives us a list breakdown by year of all items within a specified call number range that have less than 5 total circulations during any year within a specified time frame (circulations include issues, renewals and local use). select year(datetime) as 'year', count(*), itemcallnumber as ' call number', dateaccessioned, author, title, barcode, datelastseen as 'last seen', itemlost as 'lost status', damaged from statistics, items, biblio where statistics.itemnumber = items.itemnumber and items.biblionumber = biblio.biblionumber and statistics.type in ('issue','renew', 'localuse') and date(datetime) between '2004-01-01' and '2009-12-31' and itemcallnumber between 'MUSIC 1999 CD' and 'MUSIC ZZ TOP CD' group by year, statistics.itemnumber having count(*) < 5 order by cn_sort We would like to merge them into a report which gives us the "individual" circulation counts by year, but also limits the list of materials to ones with a total circulation of less than 5 during the total specified time period. Is there a way to include totals and sub-totals on the same report? We would greatly appreciate any help! Thank you, Adrea Adrea Lund Head of Adult Services Grand County Public Library 257 E. Center St. Moab, UT 84532 435-259-1111 ext11

5 8

integrating koha with fedora-commons IR
by david hon 18 Dec '09

18 Dec '09

Hi All, Can anyone provide some insight? I have setup Fedora 3.2.1 IRs on multiple TCP ports, including 8080, evaluating various config. options. I'd like to setup a Koha instance, but need to use a non-default configuration (different tcp port, etc). Would I edit koha-conf.xml or koha-httpd.conf before or after the install via perl Makefile.PL ; make ; make install? Any feedback is welcome. grep -i listen etc/* koha-conf.xml:<listen id="biblioserver" >unix:__ZEBRA_RUN_DIR__/bibliosocket</listen> koha-conf.xml:<listen id="authorityserver" >unix:__ZEBRA_RUN_DIR__/authoritysocket</listen> koha-conf.xml: koha-conf.xml:<listen id="mergeserver">tcp:@:__MERGE_SERVER_PORT__</listen> koha-conf.xml:<server id="mergeserver" listenref="mergeserver"> koha-conf.xml:<server id="biblioserver" listenref="biblioserver"> koha-conf.xml:<server id="authorityserver" listenref="authorityserver" > Cheers, -- david davidb.hon(a)gmail.com (honsys.blogspot.com) 352-275-7438 David.Hon(a)noaa.gov 301-713-2607x134 1315 East-West Highway, SSMC3 Room 2453 Silver Spring, MD 20910 David.B.Hon(a)nasa.gov 301-614-TBD Greenbelt, MD 20771 NASA/Goddard, B32 Room-TBD

2 1

Re: [Koha-devel] [Koha] Koha as an SFX Target
by Chris Cormack 17 Dec '09

17 Dec '09

2009/12/18 Walls, Ian <Ian.Walls(a)med.nyu.edu>: > For the SFX Target, I think all I need to do is get the proper Parser (which generates the URL), and the Parse params (variables), and save it as a new Target. Then it should be an easy matter to add a "Search for this title in Koha" link to the SFX menu. > > I'd love to see Koha function as an Open Link Resolver. IndexData has a Perl module, Keystone::Resolver, which may be a start. http://search.cpan.org/~mirk/Keystone-Resolver-1.18/lib/Keystone/Resolver.pm. We'd also need to look at some of our Zebra indexes and make sure they can be mapped to OpenURL fields. > > I'll share all the info as it comes my way, and once I get it working, publish a how-to (may take a while). > Shifting to the dev list Ian, if you do some work on this, a public git branch with it in would be awesome, then we can get some collaboration going hopefully :) Chris

1 0

sort-string-utf.chr
by Marcel de Rooy 17 Dec '09

17 Dec '09

Hi, Recently somebody on this list wrote to add the line "encoding utf-8 " to /etc/koha/zebradb/lang_defs/en/sort-string-utf.chr. I just discovered that from that time on I have multiple errors in the log of rebuild_zebra like: [fatal] Bad value-set specification [warn] Failed to read character table sort-string-utf.chr It appears that this file also had latin1 file encoding in my OS. Saving it with utf-8 file encoding seems to resolve the situation.. Regards, Marcel

4 4