- Koha - lists.katipo.co.nz

Problem checking out books
by Darla Grediagin 28 Aug '12

28 Aug '12

Good morning, This weekend we updated to 3.06.07. I can no longer check books out to people. Circulation recognizes the catalog items, when I check the item out to someone, the status will change from 'available' to nothing. The item won't show up as checked out or have a due date, the word available just goes away. If I look at what the patron has checked out, they will have nothing checked out. if I scan to check an item to check it in, it will tell me that the item isn't checked out and the status doesn't change to available. Any help you have will be very much appreciated, Darla -- Darla Grediagin District Librarian Bering Strait School District Unalakleet, Alaska Web Address : http://bssdonline.org/course/view.php?id=51 Blog: http://aklibrarian1.edublogs.org/ OPAC: http://opac.bssd.org:8282

1 0

Fwd: Re: Barcode info and maybe SQL/MARCXML help needed
by Galen Charlton 28 Aug '12

28 Aug '12

[meant to send this to the list --gmc] -------- Original Message -------- Subject: Re: [Koha] Barcode info and maybe SQL/MARCXML help needed Date: Tue, 28 Aug 2012 12:53:27 -0400 From: Galen Charlton <gmc(a)esilibrary.com> To: Doug Dearden <dearden(a)sarsf.org> Hi, On 08/28/2012 12:09 PM, Doug Dearden wrote: > 1. If I fix the barcodes in the items table, will that do it? > Or does Koha store them somewhere else? That's almost enough -- the other place is in the Zebra indexes for bibliographic searches on the Zebra barcode index. > 2. Even if Koha only uses the ones in the items table, any > ideas how to fix my UpdateXML statement so it works? (Just to keep > things matched up). Rather than updating biblioitems.marcxml, a better approach would simply be rebuild your Zebra index (or use touch_all_biblios.pl to tell Koha to reindex just the bibs whose items you modified). Unless you had changed your MARC frameworks to use the 852 field for item data rather than the 952, if the 852s are from your previous system, I'd suggest that you actually *delete* them. A bib export from Koha will include the item data in 952 fields if you need them for record interchange or union catalog purposes, and getting rid of the legacy 852s avoids the risk of confusing staff about the state of an item record. Regards, Galen -- Galen Charlton Director of Support and Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

2 2

Re: [Koha] corporate author field does not show in staff normal view
by Mirko 28 Aug '12

28 Aug '12

Hi Irakli, please always reply to the list so others can follow the discussions. That increases the chance of getting answers from other people too. I don't know of documentation for the XSLT in Koha. What I did was open the file, look how things are done for other fields and use that for fields I wanted to edit or add. -- Mirko Irakli Garibashvili schrieb > Thanks! > that is helpful! > > Could you point any documentation for XSLT? > > Irakli > > -------------------------------------------------- > From: "Mirko" <5p4m(a)gmx.de> > Sent: Friday, August 24, 2012 3:24 PM > To: <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] corporate author field does not show in staff > normal view > >> Hello Irakli, >> >> Irakli Garibashvili schrieb am 24.08.2012 13:21:23 >> >>> >>> Is there any way to control display format - "normal view"? >> >> Are you using XSLT? If not, try turning on XSLT for the staff client >> in your configuration. If the fields you need do not show by >> default, you can edit the respective file(s) or better use your own >> version. Please have a look at >> >> http://manual.koha-community.org/3.8/en/administration.html#XSLTDetailsDisp… >> >> >> http://manual.koha-community.org/3.8/en/administration.html#XSLTResultsDisp… >> >> >> -- Mirko >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >

1 0

Barcode info and maybe SQL/MARCXML help needed
by Doug Dearden 28 Aug '12

28 Aug '12

Hello all, We are running Koha version 3.4 - all the details are pasted below. I am working on cleaning up our barcodes, as we mistakenly converted them from our old system (Follett) adding some characters to some of them, and have also input them incorrectly when cataloging since then. The librarian doesn't have any problem checking things in and out right now as they are consistently wrong, so she knows how to reinterpret a barcode into the format that has been recorded in the database. Our concern is for that future time when we want to do inventory using a scanner, and the barcode as scanned doesn't match what is in the database. I have found barcodes in two places. In the items table, barcode field and in the biblioitems table, marcxml field. From what I can tell the latter location dates back to our conversion from Follett, as I left the information that Follett stored in the 852 record intact against that day when we might need it. I have figured out how to update the items table using an SQL "Update" statement. I have also figured out how to get a report out of the biblioitems table using a Select statement against the marcxml field like this: SELECT ExtractValue (marcxml ,'//datafield[@tag="852"]/subfield[@code="p"]') FROM biblioitems WHERE marcxml RLIKE '<datafield tag="852"' AND ( ExtractValue(marcxml, '//datafield[@tag="852"]/subfield[@code="p"]/text()') LIKE 'T000____'); In trying to rewrite this to update the barcode portion of the field, to remove the leading "T" I came up with this: SELECT UpdateXML (biblioitems.marcxml, '//datafield[@tag="852"]/subfield[@code="p"]/text("T000____")', RIGHT('//datafield[@tag="852"]/subfield[@code="p"]/text()',7)) However, that returns an error "Unknown table 'biblioitems' in field list" . So I have a few of questions. 1. If I fix the barcodes in the items table, will that do it? Or does Koha store them somewhere else? 2. Even if Koha only uses the ones in the items table, any ideas how to fix my UpdateXML statement so it works? (Just to keep things matched up). 3. If an UpdateXML statement won't work on the marcxml field, any suggestions for another approach? Thanks, Doug Dearden School for Advanced Research sarweb.org Koha version: 3.04.01.000 OS version ('uname -a'): Linux SAR75Linux 2.6.32-5-686 #1 SMP Tue Mar 8 21:36:00 UTC 2011 i686 GNU/Linux Perl interpreter: /usr/bin/perl Perl version: 5.010001 Perl @INC: /home/koha/koha-3.4.1 /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 . MySQL version: mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) using readline 6.1 Apache version: Server version: Apache/2.2.16 (Debian) Zebra version: Zebra 2.0.47 (C) 1994-2010, Index Data ApS Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: e4e44d1916c6e80e01aad163b487ee41c22272ba Using ICU

1 0

SQL commands appearing on report
by Shelley & Kurt Kemperman 28 Aug '12

28 Aug '12

We recently updated to version 3.8 and suddenly the SQL command lines are appearing at the top of any report we run/print. Any ideas to get rid of this?

4 4

BibLibre sandboxes unavailable tomorrow
by Paul Poulain 28 Aug '12

28 Aug '12

Hello Koha users & developers, Tomorrow, we will do some changes to our infrastructure, sandboxes (http://wiki.koha-community.org/wiki/Sandboxes) may be unavailable tomorrow (european work hours) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

Re: [Koha] Upgrade to 3.8 causes phantom search results
by Elaine Bradtke 27 Aug '12

27 Aug '12

Thanks Chris, that seems to have fixed it. So glad it was a Bank Holiday in the UK today, or the library director would have been having kittens by now. Elaine On Mon, Aug 27, 2012 at 9:36 PM, Chris Cormack <chrisc(a)catalyst.net.nz>wrote: > * Elaine Bradtke (eb(a)efdss.org) wrote: > > Strange thing happened after we upgraded to 3.8 (from 3.4). We seem to > have > > ghosts > > Hits that lead nowhere, in both the OPAC and staff interface. > > When a search is performed it lists x number of results. > > Scroll down the list and many of them look normal > > Some however have a result number, and nothing else - no title, no items, > > nothing. If you mouseover the link it says biblioitemno= [blank] > > If you click on edit record, you get a blank form. > > > > It appears that somehow the number of hits is doubling, and half of these > > are non-existent. This conclusion is from a very small sample set, > working > > with a few titles that I know are unique. The ghost appears immediately > > following the real record in the hit list. > > Rebuilt the zebra, and it still does it. > > We didn't notice it at first, because in the staff interface, the ghosts > > come at the end of the hit list, and when I test upgrades I tend to go > for > > searches that I know will hit a wide swath of the catalogue, so I didn't > > see the problem at the end of the list. > > Oddly, it's more noticeable in the OPAC. > > > > http://catalogue.efdss.org/ if you want to see. > > Try search terms queen and mogul for a small set of hits. > > > > Is there some setting that would cause this? I admit to meddling with > some > > of the global preferences following the upgrade, but nothing radical. > > Changing them back didn't seem to fix the problem. > > Hi Elaine > > One thing you could try is > > http://koha-community.org/faq/double-ups-search-results-clear-index-start-a… > > Chris > > -- > Chris Cormack > Catalyst IT Ltd. > +64 4 803 2238 > PO Box 11-053, Manners St, Wellington 6142, New Zealand > -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

1 0

Koha 3.8.x: Loan for 0 days
by Oscar Gaona 27 Aug '12

27 Aug '12

Hi all I've been configuring a Circulation Rule with Zero (0) days for loans in Koha 3.2, 3.4 and 3.6 without any problems ('Checked out on' date and 'Due date' are the same) but for Koha 3.8.x this seems impossible: 'Due date' displays a date 21 days after the 'Cheked out on' date. Where can be the problem? Any idea to solve it? Thanks in advance. Oscar

2 2

Upgrade to 3.8 causes phantom search results
by Elaine Bradtke 27 Aug '12

27 Aug '12

Strange thing happened after we upgraded to 3.8 (from 3.4). We seem to have ghosts Hits that lead nowhere, in both the OPAC and staff interface. When a search is performed it lists x number of results. Scroll down the list and many of them look normal Some however have a result number, and nothing else - no title, no items, nothing. If you mouseover the link it says biblioitemno= [blank] If you click on edit record, you get a blank form. It appears that somehow the number of hits is doubling, and half of these are non-existent. This conclusion is from a very small sample set, working with a few titles that I know are unique. The ghost appears immediately following the real record in the hit list. Rebuilt the zebra, and it still does it. We didn't notice it at first, because in the staff interface, the ghosts come at the end of the hit list, and when I test upgrades I tend to go for searches that I know will hit a wide swath of the catalogue, so I didn't see the problem at the end of the list. Oddly, it's more noticeable in the OPAC. http://catalogue.efdss.org/ if you want to see. Try search terms queen and mogul for a small set of hits. Is there some setting that would cause this? I admit to meddling with some of the global preferences following the upgrade, but nothing radical. Changing them back didn't seem to fix the problem. -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

1 0

3.8 Authorities - need help with see references
by Elaine Bradtke 27 Aug '12

27 Aug '12

First, I'd like to say I appreciate the finer grain control the new version has as far as creating authorities goes. But. . . and this is a problem I had in earlier versions as well - I still can't get my see references to display properly. When you search on the correct term the references to incorrect forms are displayed. for example: Topical Term: World War, 1914-1918 used for/see from: WW I used for/see from: World War I But that's not very useful if someone is searching on the incorrect form. In fact, if you search on the incorrect form in authorities it displays what is intended as a see reference as if it were an authorized heading, and does not list the reference to the authorized version. I've resorted to adding [Not Used] to the incorrect form 1XX field. Example: Topical Term: WW I [Not Used] You have to click on Details see what heading is authorized, and then it displays in tiny type above the authority record, with no explanation. Here's the 260 for this heading: 260 ## - COMPLEX SEE REFERENCE--SUBJECT a Heading referred to World War, 1914-1918 5 Institution code UKLoVW Note: I have entered a $0 with the record number for the correct heading, set it to display in the MARC framework, but it still doesn't display unless you are actually editing the authority record. I have gotten lost in the maze of MARC format for authorities and don't know which way is up anymore. I think I've got the 008 for the see references set correctly. Tried everything I could think of, but it still isn't working. Has anyone gotten see references to work? And if so, could you show me what you did? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

2 1