- Koha - lists.katipo.co.nz

SQL help please
by Kerrie Stevens 13 Dec '17

13 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 13 Dec '17

13 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 12 Dec '17

12 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 12 Dec '17

12 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 12 Dec '17

12 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 12 Dec '17

12 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

Email not being sent from koha
by Javed Sahil 12 Dec '17

12 Dec '17

Hi everyone, I have configured postfix, mailutils and gmail with my Ubuntu 16.04 to send Email Notifications from koha 16.11. I can send emails from command line using the following command: echo "This is a test." | mail -s "test message" javedshoukat900(a)gmail.com emails are received on this address: javedshoukat900(a)gmail.com but when I issue the command: ./process_message_queue.pl following message appears: connect to gmail.com failed (Connection timed out) connect to gmail.com failed connect to gmail.com failed (Connection timed out) no (more) retries! at ./process_message_queue.pl line 66. any idea? plz. -- Regards,0 Javed Shoukat Management Trainee Officer (MTO) Lahore University of Management Sciences (LUMS), Lahore. Contact #: +92 300 6548748 <+92%20300%206548748> Email: javedshoukat900(a)gmail.com

1 0

Koha 17.11 Modification log problem
by Abdulsalam Yousef 11 Dec '17

11 Dec '17

Hello all, Showing patron Modification log from koha 17.11 doesn't show any system log for the patron, Instead it redirects to ( http://domain_name/cgi-bin/koha/circ/circulation.pl?borrowernumber= Thanks in advance.

3 2