Re: [Koha] Report help

2012-04-04 Thread Nicole Engard
I found out that we're looking at too much in this. I removed a bit and now it all seems to work :) Nicole On Wed, Apr 4, 2012 at 9:44 AM, Nicole Engard wrote: > Nope :( No results, and we know there are some problem records. I only > made the following changes: > > SELECT CONCAT(' href=\"/cgi-

[Koha] Merging several books under one biblio

2012-04-04 Thread Abdulhameed Muhammad Gambo
Dear all i have several books with the same title, author name but with having different biblio number, how can i merge them to be under one biblio. thank you ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.

Re: [Koha] Public access

2012-04-04 Thread Doug Dearden
Hi Paul, Take a look at your koha-httpd.conf file. This can be in a different location depending on what type of install picked. As your staff client is working, this file is being read by apache, so hopefully you know where it is. If you don't you can find it by going to the command line an

Re: [Koha] Need SQL query help, please

2012-04-04 Thread Carol Kresge
Yes! perfect...thanks. On Wed, Apr 4, 2012 at 10:14 AM, Chris Cormack wrote: > On 4 April 2012 15:12, Carol Kresge wrote: > > They only go to one school each. another possibility is they do have more > > than 1 item checked out > > > Writing this without the data to test, but I *think* this will

Re: [Koha] Need SQL query help, please

2012-04-04 Thread Carol Kresge
They only go to one school each. another possibility is they do have more than 1 item checked out On Wed, Apr 4, 2012 at 9:58 AM, Chris Cormack wrote: > On 4 April 2012 14:53, Carol Kresge wrote: > > Thanks, but I get an error with both and it won't run > > error: 1242 subquery returns more than

Re: [Koha] Need SQL query help, please

2012-04-04 Thread Carol Kresge
Thanks, but I get an error with both and it won't run error: 1242 subquery returns more than 1 row Maybe that is because I should have mentioned that the User attribute "school" goes to an authorised value category and has a lot of different values (they go to many different schools...Phongkham, P

[Koha] Public access

2012-04-04 Thread Paul Orkiszewski
I can access the staff interface on an installation of 3.06 I've put on an instance of Debian Squeeze in Amazon: http://ec2-23-20-95-197.compute-1.amazonaws.com:8080 but I can't figure out how to get into the public interface. My guess is that it's something in the apache config files, but I

Re: [Koha] Report help

2012-04-04 Thread Nicole Engard
Nope :( No results, and we know there are some problem records. I only made the following changes: SELECT CONCAT('',biblionumber,'') AS biblionumber FROM biblioitems, (SELECT biblioitemnumber,SUBSTR(marcxml,INSTR(marcxml, "")+8+6,1) AS leader6,SUBSTR(marcxml,INSTR(marcxml, "")+8+7,1) AS leader7

Re: [Koha] Questions on authority import from third party

2012-04-04 Thread Hugo Agud
Hi Stefano Yes we need to match $9 and 001... but 001 is assigned by Koha, we have the right number at auth 003... we will correct with some mysql, but perhaps somebody knows an easier way... Thanks a lot for your advice ;) 2012/4/4 Stefano Bargioni > If I'm not wrong, in your $9's you need t

Re: [Koha] Questions on authority import from third party

2012-04-04 Thread Stefano Bargioni
If I'm not wrong, in your $9's you need to have the 001 of the corresponding auth. Or better, auth_header.authid. The utility misc/link_bibs_to_authorities.pl can do this. You will lose previous $9's, of course. But there are problems with subjects. Then run rebuild_zebra.pl -b -r. Bye. Stefano

[Koha] Fwd: Reservoir

2012-04-04 Thread Rachel Hamilton-Williams
Original Message Subject:Reservoir Date: Wed, 4 Apr 2012 08:57:29 +0800 From: Abdulhameed Muhammad Gambo To: koha-ow...@lists.katipo.co.nz how to delete the records found in reservoir in Koha 3.04 the system always end with some records in reservoir when ev

[Koha] Questions on authority import from third party

2012-04-04 Thread Hugo Agud
Dear all We have imported bib records and auth records from a local system successfully, but now we have the bib records with tag 9 with old authid, that doesn't match with the new koha authid (after importing koha have assigned a new authid) and If we add a new record of an existing auth, it copi

Re: [Koha] Searching by Barcode

2012-04-04 Thread Chris Cormack
On 4 April 2012 18:22, Ephraim Makeke 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