- Koha - lists.katipo.co.nz

No Results Found code for Google Books or Amazon
by Hal Bright 05 Apr '12

05 Apr '12

Does Any Library extend an OPAC search query to Google Books or Amazon in the "No Result Found" screen? Thanks, Hal Bright Harold Bright Director of Information Services Farmington Libraries - 6 Monteith Drive Farmington, CT 06032 - hbright(a)farmingtonlibraries.org<mailto:hbright@farmingtonlibraries.org> W 860-673-6791 x 204 - F 860-675-7148 http://www.farmingtonlibraries.org

1 0

III Millennium data migration
by Paul Orkiszewski 05 Apr '12

05 Apr '12

Hi again. I'm trying to export Marc records from a III Millennium ILS and import into Koha. For those who have gone before me - I've read through posts and articles by Ian Wells and Chris Hobbs - can you give me some hints? Particularly, should I try to pre-process marc records files to fit in the Koha marc schema? or tell Koha how to understand the III 9xx fields? Paul -- ------------------------------------------------------------------------ *Paul Orkiszewski* Coordinator of Library Technology Services / Associate Professor University Library Appalachian State University 218 College Street P.O. Box 32026 Boone, NC 28608-2026 E-mail: orkiszewskip(a)appstate.edu Phone: 828 262 6588 Fax: 828 262 2797 ------------------------------------------------------------------------

2 1

Public access
by Paul Orkiszewski 05 Apr '12

05 Apr '12

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 don't know where to look. Help? Paul -- ------------------------------------------------------------------------ *Paul Orkiszewski* Coordinator of Library Technology Services / Associate Professor University Library Appalachian State University 218 College Street P.O. Box 32026 Boone, NC 28608-2026 E-mail: orkiszewskip(a)appstate.edu Phone: 828 262 6588 Fax: 828 262 2797 ------------------------------------------------------------------------

2 2

Re: [Koha] Installation problem
by Chris Cormack 05 Apr '12

05 Apr '12

In general you are much better off following the instructions that come with the tarball (or git clone) In this case INSTALL.ubuntu. What your error belows means is your kohaadmin user can not connect to the database. You set up that use in mysql eh? Chris On 3 Jun 2011 07:54, "Lars J. Helbo" <lars(a)helbo.org> wrote:

7 10

Report help
by Nicole Engard 05 Apr '12

05 Apr '12

I think this requires some regex magic :) So, if anyone can help me out that would be great: How do I create a report for all records that have both of the following items? A 942|c field that says Photographs and a leader fields that shows item type as book? I know that the 94$c is mapped to biblioitems.itemtype - so that's not the issue, it's the Leader bit I need help with. Nicole

2 5

Merging several books under one biblio
by Abdulhameed Muhammad Gambo 05 Apr '12

05 Apr '12

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

1 0

Re: [Koha] Questions on authority import from third party
by Stefano Bargioni 04 Apr '12

04 Apr '12

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 > Date: Wed, 4 Apr 2012 10:30:17 +0200 > From: Hugo Agud <hagud(a)orex.es> > To: Koha list <koha(a)lists.katipo.co.nz> > Subject: [Koha] Questions on authority import from third party > Message-ID: > <CADT_QRStgko_83Mf_qDzoE8CGFHT9vXgCA6ARcBeHuoarakCxA(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > 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 > copies the new authid and doesn't match with the existing authid catalogued > in the bib records. > > We are thinking different options, but I wish to ask you If anybody has > easier sync auth and bib records in koha... > > > a) we can overwrite the 001 koha filed with the 003 (where we copied the > old authid from the old ILS) > b) we can modify the *Authority plugin & indicators* for copying the auth > id into 009 ( the 034 (the old authid) when exists and the 001 (koha > generated authid) when no 034 (the old authid) > > Any hep will be welcomed!! > > -- > > *Hugo Agud - Orex Digital *

2 1

Fwd: Reservoir
by Rachel Hamilton-Williams 04 Apr '12

04 Apr '12

-------- Original Message -------- Subject: Reservoir Date: Wed, 4 Apr 2012 08:57:29 +0800 From: Abdulhameed Muhammad Gambo <amghameed(a)gmail.com> To: koha-owner(a)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 ever i search for a book.

1 0

Questions on authority import from third party
by Hugo Agud 04 Apr '12

04 Apr '12

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 copies the new authid and doesn't match with the existing authid catalogued in the bib records. We are thinking different options, but I wish to ask you If anybody has easier sync auth and bib records in koha... a) we can overwrite the 001 koha filed with the 003 (where we copied the old authid from the old ILS) b) we can modify the *Authority plugin & indicators* for copying the auth id into 009 ( the 034 (the old authid) when exists and the 001 (koha generated authid) when no 034 (the old authid) Any hep will be welcomed!! -- *Hugo Agud - Orex Digital * *www.orex.es* * * Director Avenida Sarriá 29 · 08029 Barcelona <http://twitter.com/OrexDigital> :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539 33 30 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

1 0

Need SQL query help, please
by Carol Kresge 04 Apr '12

04 Apr '12

I have a query to find borrowers with late books that do not have email addresses or mobiles. Now I am trying to modify it so it will show their school from attributes if they have one but won't knock them off the list if they don't. My modification below shows only those with no email and no mobile and a school but knocks people off the list who have no school attribute. How can I modify it so it includes no mobile no email and lists school for those who have one but still includes those who don't? SELECT borrowers.surname,borrowers.firstname,borrowers.mobile,borrowers.email,borrowers.city, biblio.title,biblioitems.itemtype,issues.date_due,borrower_attributes.attribute FROM borrowers LEFT JOIN borrower_attributes on (borrower_attributes.borrowernumber = borrowers.borrowernumber) LEFT JOIN issues on (issues.borrowernumber = borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = issues.itemnumber) LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE issues.date_due < DATE_SUB(now(), INTERVAL 8 DAY) AND issues.returndate IS NULL AND borrowers.mobile = ' ' AND borrowers.email = ' ' AND borrower_attributes.code = 'School' ORDER BY borrowers.surname asc; Thanks for your help! Carol -- supporting Lao youth in their quest for a brighter future.... The Language Project…an American 501(c)3 charity Website: www.thelanguageproject.org Gallery: http://laophotographers.zenfolio.com Lao address: PO Box 905, Luang Prabang, Laos Lao mobile: 856 20 97122771 US address: PO Box 13201, Tallahassee, FL 32317

2 7