- Koha - lists.katipo.co.nz

Re: [Koha] OPAC display "double vision"
by Paul 09 Oct '12

09 Oct '12

At 11:37 AM 10/9/2012 +0200, Fischer, Katrin wrote: >Hi Paul, >This seems to do the trick for me: Hi Katrin -- and for me :=) Found one more "floating RLIN" in the 600$a fields and also ran it for all other 6xx without further errors showing up. Many thanks for a great start to my day. Paul >SELECT > biblionumber >FROM > biblioitems >WHERE > ExtractValue(marcxml,'//datafield[@tag="600"]/subfield[@code="a"]') = "" > AND > ExtractValue(marcxml,'count(//datafield[@tag="600"]/subfield[@code="a"])') = 1 > >Found the solution here: >http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html#function_extractv… > >Katrin > > > > -----Original Message----- > > From: Paul [mailto:paul.a@aandc.org] > > Sent: Monday, October 08, 2012 10:58 PM > > To: Fischer, Katrin; Koha list > > Subject: Re: AW: [Koha] OPAC display "double vision" > > > > At 09:40 PM 10/8/2012 +0200, Fischer, Katrin wrote: > > >Hi Paul, > > > > > >I think your problem could be related to a 6xx field without $a. The > > >label > > >Subject(s) is showing up, but there is no link after it. I think there > > >is an open anchor tag that doesn't close breaking your display here. > > > > Hi Katrin -- many thanks for the reply, you "hit the nail on the head." > > > > We did have for this record: > > > > =600 \\$a $915837 > > > > which is the "RLIN" for the author (how it got there, from the 100$a, > > with an empty 600$a is a mystery), and now after deleting the RLIN, > > there's no 600 and the web page is just fine. > > > > Would you by any chance have a suggestion as to a mysql query to find > > other records that contain the same error. I've tried: > > > > SELECT biblio.biblionumber, biblio.title, biblio.author FROM biblio > > RIGHT JOIN biblioitems ON biblio.biblionumber = biblioitems.biblionumber > > LEFT JOIN items ON biblio.biblionumber = items.biblionumber WHERE > > ExtractValue(marcxml,'//datafield[@tag="600"]/subfield[@code>="a"]') > > IS NULL AND > > ExtractValue(marcxml,'//datafield[@tag="600"]/subfield[@code>="9"]') > > > > but get nothing. Maybe (wild dream?) there's no other erroneous records, > > but much more probably the mysql code misses the truth (it runs without > > apparent error, but...) > > > > Again, many thanks and best regards -- Paul > > > > > > >Katrin > > > > > > > > >-----UrsprÃ¼ngliche Nachricht----- > > >Von: koha-bounces(a)lists.katipo.co.nz im Auftrag von Paul > > >Gesendet: Mo 08.10.2012 21:32 > > >An: Koha list > > >Betreff: [Koha] OPAC display "double vision" > > > > > >For just a very few of our holdings (and so far we haven't found a > > >pattern for the behaviour), we are getting a "double vision" effect in > > >Firefox, Chrome, Opera so it doesn't seem to be browser specific. > > > > > >The book/item is found without problem, but just under the "Holdings - > > >Title notes - Comments" tabs, it starts a new "page" with "No results > > >found!" As soon as you click on any of those tabs, the "double" > > >disappears ... but "reload" brings it back ... > > > > > >For an example please see > > ><http://navalmarinearchive.com/ims/opac_double.jpg> > > > > > >Has anyone else ever noticed this behaviour in Koha 3.8.x? > > > > > >Many thanks -- and for Canadians, Happy Thanksgiving Day. > > > > > >Paul > > > > --- > > Maritime heritage and history, preservation and conservation, research > > and education through the written word and the arts. > > <http://NavalMarineArchive.com> and <http://UltraMarine.ca> > > --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

1 0

Re: [Koha] OPAC display "double vision"
by Paul 09 Oct '12

09 Oct '12

At 09:40 PM 10/8/2012 +0200, Fischer, Katrin wrote: >Hi Paul, > >I think your problem could be related to a 6xx field without $a. The label >Subject(s) is showing up, but there is no link after it. I think there is >an open anchor tag that doesn't close breaking your display here. Hi Katrin -- many thanks for the reply, you "hit the nail on the head." We did have for this record: =600 \\$a $915837 which is the "RLIN" for the author (how it got there, from the 100$a, with an empty 600$a is a mystery), and now after deleting the RLIN, there's no 600 and the web page is just fine. Would you by any chance have a suggestion as to a mysql query to find other records that contain the same error. I've tried: SELECT biblio.biblionumber, biblio.title, biblio.author FROM biblio RIGHT JOIN biblioitems ON biblio.biblionumber = biblioitems.biblionumber LEFT JOIN items ON biblio.biblionumber = items.biblionumber WHERE ExtractValue(marcxml,'//datafield[@tag="600"]/subfield[@code>="a"]') IS NULL AND ExtractValue(marcxml,'//datafield[@tag="600"]/subfield[@code>="9"]') but get nothing. Maybe (wild dream?) there's no other erroneous records, but much more probably the mysql code misses the truth (it runs without apparent error, but...) Again, many thanks and best regards -- Paul >Katrin > > >-----Ursprüngliche Nachricht----- >Von: koha-bounces(a)lists.katipo.co.nz im Auftrag von Paul >Gesendet: Mo 08.10.2012 21:32 >An: Koha list >Betreff: [Koha] OPAC display "double vision" > >For just a very few of our holdings (and so far we haven't found a pattern >for the behaviour), we are getting a "double vision" effect in Firefox, >Chrome, Opera so it doesn't seem to be browser specific. > >The book/item is found without problem, but just under the "Holdings - >Title notes - Comments" tabs, it starts a new "page" with "No results >found!" As soon as you click on any of those tabs, the "double" disappears >... but "reload" brings it back ... > >For an example please see <http://navalmarinearchive.com/ims/opac_double.jpg> > >Has anyone else ever noticed this behaviour in Koha 3.8.x? > >Many thanks -- and for Canadians, Happy Thanksgiving Day. > >Paul --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

2 1

Approve Patron's contact information
by sheikh303 09 Oct '12

09 Oct '12

When a patron edits his/her contact information, it shows that approval is required by the librarian. Need help on how to approve this update request. Or is possible to disable this approval process. thanks. -- View this message in context: http://koha.1045719.n5.nabble.com/Approve-Patron-s-contact-information-tp57… Sent from the Koha-general mailing list archive at Nabble.com.

3 4

OPAC display "double vision"
by Paul 08 Oct '12

08 Oct '12

For just a very few of our holdings (and so far we haven't found a pattern for the behaviour), we are getting a "double vision" effect in Firefox, Chrome, Opera so it doesn't seem to be browser specific. The book/item is found without problem, but just under the "Holdings - Title notes - Comments" tabs, it starts a new "page" with "No results found!" As soon as you click on any of those tabs, the "double" disappears ... but "reload" brings it back ... For an example please see <http://navalmarinearchive.com/ims/opac_double.jpg> Has anyone else ever noticed this behaviour in Koha 3.8.x? Many thanks -- and for Canadians, Happy Thanksgiving Day. Paul

2 1

Acquisitions / Lack of Rollover
by BRANNON, CHRISTOPHER 08 Oct '12

08 Oct '12

Our library has been using Acquisitions this last year, and just realized that there is no rollover functionality. We are wondering if any other libraries use acquisitions. If so, what do you do with orders that haven't been filled from a previous budget without a rollover feature? ___________________________ Christopher Brannon IT Coordinator Coeur d'Alene Public Library 702 E Front Ave Coeur d'Alene, ID 83814 (208)769-2315 Ext. 456 cbrannon(a)cdalibrary.org www.cdalibrary.org

1 0

Record matches in bulk MARC imports
by Elaine Bradtke 08 Oct '12

08 Oct '12

I am contemplating setting up different record matching rules since an ISBN is lacking for many of our titles and I know there are some overlaps with what's already in the system. - I would like to build a record matching rule on author, title and publication date. Has anyone done this already? - How can I see what the new parameters are doing before I import the staged records (at the point when they're still in the reservoir)? Just to make sure it is working as expected. Is there a way to output a list of matched records at this stage? - As the staged records are imported, do you have the opportunity to interact with the matched records (say yes or no to import, or override the setting for individual matched records?) Maybe I'm asking for too much control, but we've got lots of very similar titles without ISBN (Twenty-four country dances for the year XXXX) in the collection. Maybe I should upload these in smaller batches? We're running 3.08.05. -- 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

Item checkout by a librarian
by sheikh303 08 Oct '12

08 Oct '12

Hi there, >From SQL Report Library at koha wiki, I can get the report of all items checked out today. But I want to generate the report librarian wise. a report of today's checked out items by a librarian. Any suggestion will be appreciated. Thanks in advance. -- View this message in context: http://koha.1045719.n5.nabble.com/Item-checkout-by-a-librarian-tp5729155.ht… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Restrict Continuous Checking Out
by sheikh303 07 Oct '12

07 Oct '12

Hi there, Is possible to restrict a patron from checking same item twice back to back? A book must be checked by at least one patron before s/he can check it out again. I am using koha 3.02 thanks in advance. -- View this message in context: http://koha.1045719.n5.nabble.com/Restrict-Continuous-Checking-Out-tp572911… Sent from the Koha-general mailing list archive at Nabble.com.

4 4

DOM versus GRS-1
by Barry Cannon 06 Oct '12

06 Oct '12

** Sorry if this double posted - having some problem with the list ** Hello, I recently upgraded a site from Koha 3.6 to 3.8.5 (via 3.8.3). Shortly afterwards we noticed that there was quite a few biblios not appearing on the search results even though they exist in the database. After trying many, many things I decided to switch from DOM to grs-1 and rebuild the indexes. This has resolved the problem and the search results are now correct. Switching back to DOM brings back the problem. Does anyone know why this might be the case - broadly speaking. Should DOM and grs create the same index result set by using different filters or are these types of differences expected? Thanks Barry

5 4

Re: [Koha] Live CD on Kubuntu
by Vimal Kumar V. 06 Oct '12

06 Oct '12

Dear Indranil Da, Your Live CD project based on UCK and Kubuntu seems interesting. Here UCK failed to build live cd, here is the log file message, Copying resolv.conf... cp: not writing through dangling symlink `/home/vimal/tmp/remaster-root/etc/resolv.conf' Unmounting /home/vimal/tmp/remaster-root/var/cache/apt... Unmounting /home/vimal/tmp/remaster-root/tmp/customization-scripts... Unmounting /home/vimal/tmp/remaster-root/tmp... Unmounting /home/vimal/tmp/remaster-root/sys... Unmounting /home/vimal/tmp/remaster-root/run... Unmounting /home/vimal/tmp/remaster-root/root... Unmounting /home/vimal/tmp/remaster-root/proc... Unmounting /home/vimal/tmp/remaster-root/dev/pts... Failed to copy resolv.conf, error=1 Build ended at 2012-10-05 22:42:22 Now I am experimenting with Ubuntu Builder code.google.com/p/*ubuntu*-*builder .* * * *Can you share your experience with UCK and Kubuntu.* * * *Regards,* -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

2 1