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

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

koha 3.0.4 biblio records
by Zico 17 Dec '09

17 Dec '09

Hi, I am using koha 3.0.4 under debian 5.0. The problem is in editing records. If we edit any records, after editing, it shows two same records, both are newly edited records. After that, if we delete one item and if we search for that in OPAC; the error shows: Koha error The following fatal error has occurred: Can't call method "clone" on an undefined value at /usr/share/koha/lib/C4/XSLT.pm line 57. Apache Server version: Apache/2.2.9 (Debian) Server built: Jan 20 2009 17:29:25 Koha 3.00.04.019 Koha DB 3.0004019 MySQL mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 OS Linux debian 2.6.26-1-686 #1 SMP Sat Jan 10 18:29:31 UTC 2009 i686 Perl 5.010000 -- Best, Zico

3 4

System use and best way to beef up a machine
by David Schuster 16 Dec '09

16 Dec '09

Looking for opinions... We have had instances mainly between 8-9 in the morning when the system is overloaded that items are not getting checked in. The librarians assure me they see ALL the titles come up on the screen. My only thought is that I'm having IO issues. What are my best options to assist with this problem? More Memory? I'm running a Dell PowerEduge Smart 2950 III Quad Core Intel Xeon 2.5 GHz(2 processors), with 16 GB memory Between 7:45 and 9:30 in the morning my system usage doing a top goes from 1 to 7, I've seen it go to 12 for the average load 1 minute reading. We had 271,694 returns for November. I suspect the majority of that was between 7:30-9:30 Monday - Friday. Which comes out to be about 250 items checked in during a 2 hour period. Pretty good with no help other than volunteers... But when something doesn't get checked in and they run an overdue it creates more work for the librarian to track the book down. We want to believe Koha is perfect, but we are having some issues. I'd blame the librarian, but I'm hearing this from several schools not just a couple. Thoughts? David Schuster Plano ISD -- View this message in context: http://old.nabble.com/System-use-and-best-way-to-beef-up-a-machine-tp268118… Sent from the Koha - Dev mailing list archive at Nabble.com.

2 1

koha-dev IRC channel ?
by Nahuel ANGELINETTI 16 Dec '09

16 Dec '09

Hi all, I think it should be fine to have a developper irc channel to talk about technical questions, without been flooded by user/install questions, and talk only about code guidelines, futur of koha, ways to do, how to do, etc... What do you think about this? bests, -- Nahuel ANGELINETTI

7 11

Help needed in Label Creator
by nitesh rijal 16 Dec '09

16 Dec '09

Hello all. I'm using KOHA 3.0.3 in Debian Lenny. I have currently tried to set up the label creator for books and patrons. I started creating the labels but ran into a small problem. Generating labels for books is going good, but I'm facing problems in generating labels for patrons. I can generate visible label only when I select the Print Type as "Patron Cards", but this layout gives homebranch, patron type and patron barcode. The thing that annoys me is that I only want the patron barcode nothing else. I have tried to use "only barcodes" type and also assigned barcode field in the text field type but it generates blank pdfs. The only way I can get patron label pdf is by selecting the patron cards type. I tried to look at the documentaion but it doesn't explain about the "patron cards" type. I just want to remove the homebranch library name and parton type from the output generated by "patron cards" type. Please Help. Thank you. -- 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

2 5

koha 3.0.4 not "status" showing in opac
by Bob Birchall ＠ Calyx 15 Dec '09

15 Dec '09

Sorry for cross-posting. I want to bring this across to the general list. I am seeing the same problem as Zico. It is in a 3.0.4 instance with a data base that was upgraded from Koha 2.2.9. The 'status' field in the opac-detail page is blank. The status displays correctly in the detail page of the staff client. Any suggestions? Thanks, Bob ________________________________________ From: koha-devel-bounces(a)lists.koha.org [mailto:koha-devel-bounces@lists.koha.org] On Behalf Of Zico Sent: Monday, 14 December 2009 11:41 PM To: koha-devel(a)lists.koha.org Subject: [Koha-devel] koha 3.0.4 not "status" showing in opac Hi, my koha 3.0.4 opac is not showing the "status" for any books/disks. In my previous koha-3.0.1, this status showed "available" or "not available" by default. But, here in koha-3.0.4 is showing no status. How can i enable it? -- Best, Zico No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.427 / Virus Database: 270.14.106/2563 - Release Date: 12/13/09 19:47:00

1 0

koha 3.0.4 not "status" showing in opac
by Zico 14 Dec '09

14 Dec '09

Hi, my koha 3.0.4 opac is not showing the "status" for any books/disks. In my previous koha-3.0.1, this status showed "available" or "not available" by default. But, here in koha-3.0.4 is showing no status. How can i enable it? -- Best, Zico

1 0