- Koha - lists.katipo.co.nz

Extracting empty bibliogrphic records
by lukasz.mesek＠alingsas.se 27 Jan '17

27 Jan '17

Hello, I would like to extract all the empty bibliografic records, to use Batch record deletion afterwards. We have quite a lot of empty records so maybe CSV is a good to use? Any ideas are more than welcome. Med vänlig hälsning Lukasz Mesek Vuxenbibliotekarie Alingsås bibliotek lukasz.mesek(a)alingsas.se

3 2

Date Wise List of Checked In Books
by Scott Owen 27 Jan '17

27 Jan '17

Hi all, I'm trying to use the following SQL...from the Koha reports page, and it appears that it isn't working on Koha version: 3.22.06.000 Before I take off and do my own query....I thought I'd ask if anyone has a current / working version of this query. Thanks, -S ************************************************************ ****************************************Date Wise List of Checked In Books - *Developer:* Vimal Kumar V., Mahatma Gandhi University Library - *Module:* Circulation - *Purpose:* To generate date wise list of checked in books - *Example:* List of checked in books between 2013-07-20 to 2013-07-25 - *Status:* Complete SELECT old_issues.returndate,items.barcode,biblio.title,biblio.author,borrowers.firstname,borrowers.surname,borrowers.cardnumber,borrowers.categorycode FROM old_issues LEFT JOIN borrowers ON borrowers.borrowernumber=old_issues.borrowernumber LEFT JOIN items ON old_issues.itemnumber=items.itemnumber LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber WHERE old_issues.returndate BETWEEN <<Between Date (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> ORDER BY old_issues.returndate DESC

2 1

items table has more records than in biblio table and biblioitems tables !!
by Tanzeem M.B 27 Jan '17

27 Jan '17

After doing an import, the items table in koha is having 7 more records than in biblio and biblioitems tables. How does this happen? How to fix this? -With Thanks & Regards Tanzeem M.B

5 4

Import records and update items
by Felix Hemme 27 Jan '17

27 Jan '17

Hi, I'm running Koha 16.05.05 and would like to add barcodes to all existing items afterwards. I export bibliographic data for one library, including items in marc format. Then I edit the records using MarcEdit and add some barcodes. I reimport the records using the stage marc records for import tool with matching rule on controlnumber 001. I select "Ignore incoming records" and "Replace items if matching bib was found (only for existing items)". After the import is complete, Koha displays "number of records ignored" = 1 and "number of items replaced" = 1. But when I view the record in staff and OPAC view, nothing changed. According to this mail matching on items is done checking 952 $p https://lists.katipo.co.nz/public/koha/2015-April/042590.html. But my existing items don't have any barcodes yet. Do you know a workaround for this? Regards, Felix -- Felix Hemme Thüringer Universitäts- und Landesbibliothek (ThULB) Bibliotheksplatz 2 · 07743 Jena · Postfach · 07737 Jena Tel: 03641 940-126 · Fax: 03641 940-022 http://www.thulb.uni-jena.de<http://www.thulb.uni-jena.de/>

3 3

1. Help needed in advanced searching with barcode (Tanzeem M.B)
by Ramakant 27 Jan '17

27 Jan '17

You can use bc = 35 to search particular barcode Thanks and Regards, ======================================================================== Ramakant Senior Library Information Assistant P K Kelkar Library, Indian Institute of Technology Kanpur Uttar Pradesh PH. No. 0512025907323 Mo. +91 8090049089 Email: <mailto:ramakant@iitk.ac.in> ramakant(a)iitk.ac.in , <mailto:ramakant.iitk@gmail.com> ramakant.iitk(a)gmail.com

1 0

Circ stats of deleted items
by Christopher Davis 27 Jan '17

27 Jan '17

Dear Colleagues, Will someone please remind me if the circulation statistics of an item are included in something like a year-end report if the item was deleted from Koha before the report was run. My institution's circulation numbers are down this year and we're attempting to discover why. TIA, Christopher Davis, MLS Systems & E-Services Librarian Uintah County Library cgdavis(a)uintah.utah.gov (435) 789-0091 ext.261 uintahlibrary.org basinlibraries.org facebook.com/uintahcountylibrary instagram.com/uintahcountylibrary

2 1

Hello
by Nathan Cluff 26 Jan '17

26 Jan '17

Hello Koha community, I am a system administrator at Arizona State University and have inherited a Koha database. I have been wanting to dabble in Koha for a while so now I am jumping into a full live database. The original setup was running Koha 3.x (sorry I don't have the original version readily available) but I am updating hardware and software for the library and in doing so we are now using Koha 16.05. Now the reason for the posting, everything appears to have imported properly into the new build but one problem I am having is when exporting spine labels to PDF it capitalizes everything. When I view the item record, go through the quick spine label creator or export to csv the capitalization is correct. I have not been able to find where to change this. Thank you Nathan Cluff System Administrator Arizona State University School of Earth and Space Exploration P.O. Box 6004 Tempe, Arizona 85281 P: 480-727-2149 | C: 480-593-2502

2 2

Re: [Koha] Help needed in advanced searching with barcode
by vikram zadgaonkar 26 Jan '17

26 Jan '17

Hi, You can use bc:35 to search particular barcode or use advance search. On 26-Jan-2017 10:20 AM, "Tanzeem M.B" <tanzeem.mb(a)gmail.com> wrote: When I search for a bibliographic record using advanced search with barcode eg 35 I get all the records with barcode containing 35, ie 135,35, 3501 etc. how can I limit the search to getting the record with barcode exactly matching "35" only? _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Help needed in advanced searching with barcode
by Tanzeem M.B 26 Jan '17

26 Jan '17

When I search for a bibliographic record using advanced search with barcode eg 35 I get all the records with barcode containing 35, ie 135,35, 3501 etc. how can I limit the search to getting the record with barcode exactly matching "35" only?

1 0

Koha 16.05 - Holds Script - Run Frequency
by Craig Butosi 25 Jan '17

25 Jan '17

Hi all, Koha 16.05 on Ubuntu 14.04 LTS Can someone confirm the name and location of the script that controls the processing of hold requests? By 'processing' I mean when a patron clicks on "Place Hold" from the OPAC, and then that request gets entered into the "Holds to Pull" screen in the staff client. I see in directory /etc/koha/cron.hourly/ there is a script called "build_holds_queue.pl". Is this the one? If it is, then if I wanted to run it as frequently as every 15 minutes (instead of every hour), how would I go about doing that (I've never had to edit a cron in the cron.hourly folder, only in crontab)? Are there any issues will running this script more frequently than every hour? (We are a library with a user base of about 600, and with a collection of about 50,000 items; by most standards a small library). Many thanks all! Craig Butosi, MA, MLIS, B Mus (Hons.) LIBRARY SERVICES MANAGER the royal conservatory TELUS Centre for Performance and Learning 273 Bloor Street West Toronto, ON M5S 1W2 416.408.2824 x338 www.rcmusic.ca<http://www.rcmusic.ca/> Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.

2 3