- Koha - lists.katipo.co.nz

How to import records with number of item in Koha
by shankar reddy Kolle 14 Dec '17

14 Dec '17

Hello, I have installed Koha by packages method on Ubuntu 16.05 along with Maria DB. I have a title (record) with 5 copies (items) in excel. How to convert excel into Marc format using marc editor when importing records along with it's multiple items (that is barcode)? Can you please advice or share the screenshots if you have done it already for your library? I have got confused using marc editor with the existing help documents available on the web. This would help me a lot for importing thousands of records along with items with accuracy. I have also noteddown 952$p ----barcode (items.barcode). Looking for your guidance. Dr. Shankar Reddy... -- Best regards Dr. Shankar Reddy Kolle Deputy Librarian Prof. Ram Dayal Munda Central Library Indira Gandhi National Tribal University, Lalpur, Amarkantak, Anuppur Dist, Madhya Pradesh -484887, India Phone No 09742749018

1 0

Call for News: December 2017 Newsletter
by kohanews 14 Dec '17

14 Dec '17

I'm collecting news for the December newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

SQL help please
by Kerrie Stevens 14 Dec '17

14 Dec '17

Is there a way to write an SQL report where you can input a number of item barcodes (as you do when using batch modify or delete) that results in a table showing title, author, call number etc...? Thanks for any help you may provide! Kerrie Stevens AALIA(CP), MAppSc(Lib&InfoMgt)(CSU), BBus(InfoMgt)(RMIT) College Librarian First Aid Officer College Archivist Copyright Compliance Officer Journal Manager – Journal of Contemporary Ministry Harvest Bible College OFFICE: +61 3 8799 1111 DIRECT LINE: +61 3 8799 1155 EMAIL: kstevens(a)harvest.edu.au STREET ADDRESS: 1 Keith Campbell Court, Scoresby VIC 3179 AUSTRALIA POSTAL ADDRESS: PO BOX 9183, Scoresby VIC 3179 AUSTRALIA WORKING HOURS: Mon - Thurs 8.30am – 4.30pm, Fri 8.30am – 3pm harvest.edu.au CRICOS CODE: 01035C (VIC) Harvest Bible College Ltd. [RTO: 0067] DISCLAIMER: The information contained in this e-mail is confidential and may also be privileged. Opinions expressed are those of the sender and not necessarily the opinions of Harvest Bible College. If you are not the addressee, any use of this communication is strictly prohibited. If you have received this message in error, please contact info(a)harvest.edu.au While Harvest Bible College is using the latest antiviral tools, we do not except responsibility for problems caused by virus or other destructive mechanisms which may be attached to electronic communication. Please scan this email and other attachment for viruses.

6 7

Is the auto-increment fix still necessary in Koha 17.11 ?
by Chris Brown 14 Dec '17

14 Dec '17

Hello, I have just installed Koha 17.11.00 onto a new server. Do I still need to implement the "auto-increment" fix described at wiki.koha-community.org/wiki/DBMS_auto_increment_fix, or is this issue resolved in the latest version of Koha? Thanks, Chris Brown

2 1

Not for Loan
by Ma. Victoria H. Silva-Manuel 13 Dec '17

13 Dec '17

hi. we just recently upgraded to version 17 from 3 and i noticed that in item field "Not for loan" there is no more blank option that when you choose will make the item available. how do i make an item with "Not for loan" status available? thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 1

Reminder: General IRC meeting tomorrow 20:00 UTC 13-December-2017
by Brendan Gallagher 13 Dec '17

13 Dec '17

Hi All - Just a reminder we have a general IRC meeting tomorrow. I think you can find all the links you need here - https://wiki.koha-community.org/wiki/General_IRC_meeting_13_December_2017 That's got that handy dandy time converter on it too. (I live by that ;) ) I hope to see many of you there and if have anything to add to the agenda - now is the time. Cheers, Brendan -- --------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Office: Portland, OR - Office: Redding, CT Phone # (888) 900-8944 http://bywatersolutions.com info(a)bywatersolutions.com

1 0

Batch Check in function
by kamil 13 Dec '17

13 Dec '17

Hi, in Koha exists function named "Batch Check out" but there is no "Batch Check in". A lot of small libraries don't have self-check station. Maybe a good solution would be adding function "Batch Check in"? Thanks a lot Regards -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

1 0

Why are koha emails queued?
by Javed Sahil 13 Dec '17

13 Dec '17

Hi All, I am fed up. I dont want koha to send checkin, checkout email notices in message queue. It should send emails immediately as we send normal emails from gmail account. How is it possible? Regards, Javed Shoukat

3 2

Koha calendar
by Liny Varghese 13 Dec '17

13 Dec '17

Hi, The problem occurred in Home-Tools-Calendar. This problem is occurred recently without changing any settings in Koha. This was working earlier. Suddenly this happened. Koha Calendar is not displaying to set holidays. I just tried with 2 scenarios: a. When I set my library, calendar is not displaying. b. If no library is set, the calendar is showing up. Since it is December, we need to set holidays for the next year, otherwise due days will clash. Any help is very much appreciated Liny Varghese Information Scientist University Library Cochin University of Science and Technology Kochi-22, Kerala<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br /> <table style="border-top: 1px solid #D3D4DE;"> <tr> <td style="width: 55px; padding-top: 13px;"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-anima…" alt="" width="46" height="29" style="width: 46px; height: 29px;" /></a></td> <td style="width: 470px; padding-top: 12px; color: #41424e; font-size: 13px; font-family: Arial, Helvetica, sans-serif; line-height: 18px;">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…" target="_blank" style="color: #4453ea;">www.avast.com</a> </td> </tr> </table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>

2 1

Re: [Koha] SQL help please
by SATISH 12 Dec '17

12 Dec '17

Hi Kerrie, Both sql's formats are working for me with Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with MySQL Thanks to Pedro and Mark. 1) ------------------------------- SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.biblionumber,'</a>') AS biblionumbers, items.barcode ,items.itemcallnumber,biblioitems.isbn,biblio.author,biblio.title FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.barcode = <<Barcode #1>> or items.barcode = <<Barcode #2>> or items.barcode = <<Barcode #3>> or items.barcode = <<Barcode #4>> or items.barcode = <<Barcode #5>> or items.barcode = <<Barcode #6>> ORDER BY LPAD(items.barcode,30,' ') ASC 2) ------------------------------- SELECT i.barcode, title, author, i.itemcallnumber FROM biblio b LEFT JOIN biblioitems bi ON b.biblionumber=bi.biblionumber LEFT JOIN items i ON bi.biblionumber=i.biblionumber WHERE i.barcode = <<Barcode #1>> OR i.barcode = <<Barcode #2>> OR i.barcode = <<Barcode #3>> OR i.barcode = <<Barcode #4>> OR i.barcode = <<Barcode #5>> OR i.barcode = <<Barcode #6>> --------------------------------- With Thanks Satish

1 0