- Koha - lists.katipo.co.nz

Barcode error
by regina kivuyo 06 Mar '17

06 Mar '17

hello when staff put the item in the koha through catologue it gives the error message , barcode error , i opted to use accession number as barcode so as to avoid duplicate of data in the system but when i search in the database i will found the item with the callnumber , but when i try to search using callnumber or accession number (barcode) in normal way in koha i will not see the item -- regina

1 0

Re: [Koha] Publisher Authority Type
by Hernandez, Heather 04 Mar '17

04 Mar '17

Hi, Krishna! The data in the 260 field (or the 264) is transcribed data--it should be transcribed from the item, and may not be the same as the authorized form of the publisher's name in the authority file. For example, a book may have on the title page (made up example): "Oxford at the University Press 2016." This could be transcribed as: 260 _ _ $a Oxford : $b University Press, $c 2016. But the authorized form of the name of this publisher in the authority file in OCLC & the Library of Congress is: 110 2_ Oxford University Press. So the record would have a 710 field with the authorized form of the name for searching, access, etc.: 710 2_ Oxford University Press. The 260 $b and the 710 may be identical, but not necessarily. The transcription becomes important when trying to identify particular editions, printings, etc., especially in special collections, with rare materials, etc. I hope this helps clarify! Cheers, h2 ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032, heather_hernandez(a)nps.gov http://www.nps.gov/safr/learn/historyculture/museum-collections.htm "The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg

2 3

Koha Community Newsletter: February 2017
by kohanews 03 Mar '17

03 Mar '17

Fellow Koha users: The Koha Community Newsletter for February 2017 is here [ finally! ]: https://koha-community.org/koha-community-newsletter-february-2017/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. Thanks! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Are 700s searchable?
by Ellen Kaye 02 Mar '17

02 Mar '17

Hello, I have a situation in which the co-author of a book is an alum, and we'd like for patrons to be able to locate the book using his name. Because he is the second author, he is in the 700 field, with the first author in the 100. When I search with the last name of the first author and the book title, it comes up. When I search with the last name of the co-author and the book title, it doesn't. Is this something that I can change, or is it a Koha issue? I appreciate any guidance - thanks! Ellen Kaye, MLIS *ellen.kaye(a)goddard.edu <paula.tamburello(a)goddard.edu>* Technical Services Coordinator Eliot Pratt Library, Goddard College 123 Pitkin Road, Plainfield, VT 05667 802.322.1602 <%28802%29%20322-1607> or 802-454.8311 x216 Website: http://www.goddard.edu/lits Catalog: https://catalog.goddard.edu Find Us On Facebook: http://www.facebook.com/EliotDPrattLibrary

2 1

Koha-US Conference CFP
by Christopher Davis 02 Mar '17

02 Mar '17

Dear Koha Users, Koha-US is calling for proposals for conference talks/presentations, round table discussions, poster sessions, etc. for its 2017 annual conference held on August 9-12 in Coeur d'Alene, Idaho, USA. The theme for this year's conference is "Koha: You Can Do It" and is in the enabling attitude of Rosie the Riveter (see attached poster). We are seeking proposals for diverse audiences, from new Koha users, to the most advanced Koha software developers. Please check out the proposal submission form found at https://docs.google.com/forms/d/e/1FAIpQLSfoq_J7IHoTP-KhdGp3I-FYbi0L44BWMjT… for more details. If you are not sure what you could share at this conference, think about the things you wish someone would have told you about when you were struggling or maybe think of a lesson you "learned the hard way." Maybe you could share your experiences integrating Koha into a library program. The Koha community loves to share and presenting at the conference is a great way to do just that. Thank you, Christopher Davis Secretary, Koha-US cgdavis(a)uintah.utah.gov koha poster #6.png <https://drive.google.com/a/uintah.utah.gov/file/d/0B3CXDpFsfriXS2xZRVAwcUFN…>

1 0

Re: [Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days
by Tobin, Jessica L 02 Mar '17

02 Mar '17

Hi Vanda, We run this report daily to keep up with holds that are languishing on the pick-up shelves for too long: SELECT biblio.title AS 'title', p.surname, p.firstname AS 'first name', p.email, p.cardnumber AS 'patron barcode', h.waitingdate AS 'hold available date', i.barcode AS 'item barcode' FROM reserves h LEFT JOIN borrowers p USING (borrowernumber) LEFT JOIN items i ON (h.biblionumber=i.biblionumber) LEFT JOIN biblio ON (i.biblionumber=biblio.biblionumber) WHERE date (h.waitingdate) = DATE_SUB(CURRENT_DATE(),INTERVAL 7 DAY) OR date (h.waitingdate) = DATE_SUB(CURRENT_DATE(),INTERVAL 14 DAY) ORDER BY h.waitingdate It shows the date that the hold became available. Also, it gives us a heads-up on holds that have been available for either 7 or 14 days, but you could remove the OR statement to just show 7 day-old holds. Hope this helps! :) Jess Jessica L. Tobin Technical Services & Systems Librarian Arnold Library Office 206.667.6846 Library Main 206.667.4314 jtobin(a)fredhutch.org Fred Hutchinson Cancer Research Center 1100 Fairview Ave. N., Mail Stop B1-010 Seattle, WA 98109 FRED HUTCH / CURES START HERE fredhutch.org<http://www.fredhutch.org/> Date: Wed, 1 Mar 2017 10:16:06 +0000 From: vanda koha <vandakoha(a)gmail.com<mailto:vandakoha@gmail.com>> To: koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> Subject: [Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days Message-ID: <CAOTDiOPtTBs5EXuS7o7cqQp1ioZO_Zv9+ds0eC=N=Td4SAy1bw(a)mail.gmail.com<mailto:CAOTDiOPtTBs5EXuS7o7cqQp1ioZO_Zv9+ds0eC=N=Td4SAy1bw@mail.gmail.com>> Content-Type: text/plain; charset=UTF-8 Hi everybody, I would like to run a report that would show me all the users, their e-mail adresses, titles and barcodes of items whose holds have been waiting for pickup longer than the ReservesMaxPickupDelay number of days (in our case 7 days). Can anyone please help me with the SQL Report? It would be great if the report showed the number of days or the hold expiration date. Many thanks, Vanda

2 1

SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days
by vanda koha 01 Mar '17

01 Mar '17

Hi everybody, I would like to run a report that would show me all the users, their e-mail adresses, titles and barcodes of items whose holds have been waiting for pickup longer than the ReservesMaxPickupDelay number of days (in our case 7 days). Can anyone please help me with the SQL Report? It would be great if the report showed the number of days or the hold expiration date. Many thanks, Vanda

2 1

SQL query to enable all patrons messaging preferences
by Vimal Kumar V. 01 Mar '17

01 Mar '17

Dear Jonthan, As per your instructions I run the script. All borrowers messaging preferences set to default messaging preferences of concerned Patron categories. Now its OK. Thank you Liz and Jonathan. Following commands applied. Load environment variables sudo su export PERL5LIB="/usr/share/koha/lib" export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml" Run borrowers-force-messaging-defaults script cd /usr/share/koha/bin/maintenance perl borrowers-force-messaging-defaults --doit Regards, -- Vimal Kumar V. Librarian School of Indian Legal Thought Mahatma Gandhi University Kottayam, Kerala Web: http://www.vimalkumar.info Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://dspacegeek.blogspot.in http://moovandan.blogspot.in <http://moovandan.blogspot.in> --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

Re: [Koha] Koha Digest, Vol 136, Issue 40
by Cybermon 01 Mar '17

01 Mar '17

Dear All, Hello, Please I am looking SQL Query for librarian circulation reports to Borrower's circulation report by onsite and check-out between "date range" and "by patron category" sorted by day or librarian My reason for the report is: to count served by which librarian how many onsite and check-out items by patron category with date range. Best regards, Gana

1 0

SQL query to enable all patrons messaging preferences
by Vimal Kumar V. 01 Mar '17

01 Mar '17

Dear Liz, The script borrowers-force-messaging-defaults did not change the messaging preferences of patrons already entered. But default messaging preferences of Patron category visible when we create a new patron. Regards, -- Vimal Kumar V. Librarian School of Indian Legal Thought Mahatma Gandhi University Kottayam, Kerala Web: http://www.vimalkumar.info Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://dspacegeek.blogspot.in http://moovandan.blogspot.in <http://moovandan.blogspot.in> --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

2 1