Re: [Koha] SQL help please

2020-06-02 Thread Ketan Kulkarni
You will have to use the function ExtractValue() for extracting the public note. Once you do that, just download the CSV and sort that column in a spreadsheet application. Should do the trick. On Wed, Jun 3, 2020 at 10:18 AM Kerrie Stevens wrote: > Hi All, > > I want to be able to run a report

[Koha] SQL help please

2020-06-02 Thread Kerrie Stevens
Hi All, I want to be able to run a report that pulls out bib number, title, author & barcode for resources that have "Added to LA" in the 'x-non-public note' field of the item record. That last bit is the bit I'm not sure how to do...? Thank you for any assistance you may provide... Kerrie

[Koha] How do Koha package updates work?

2020-06-02 Thread Dawson Weber
Hello All, I have a Koha library for a personal collection and created the database in March 2019 starting with, I believe, 18.5. I am not much of a tech person but I was able to set up my library on Debian with Digital Ocean and did the installation with packages. Since then, it has updated to

Re: [Koha] Self-service hardware question

2020-06-02 Thread Lari Taskula
Hello Lisa, There are two free and open source software and hardware devices designed to support self-service functionality especially in Koha libraries. They are licensed with GPLv3 and CERN OHL so there are basically two ways to get them - 1. you could assemble these devices yourself, or 2. you

Re: [Koha] Batch import of patrons fails in 19.11.05

2020-06-02 Thread Elaine Bradtke
This went offlist for a bit, but the gist of it is, userid is required even though it's not listed as a requirement in the notes on the Import patrons field. I've filed a bug to update the information on the Patron Import page to reflect this. 25657

[Koha] koha-US June 2020 Meetings & Events

2020-06-02 Thread Jason Robb
koha-US online meetings and events are free and open to all. See our calendar for a full list: http://koha-us.org/calendar/ *Meetings* Board Meeting - Wednesday, June 3rd @ 8:30a PT / 11:30a ET / 3:30p UTC - Meeting Link - https://zoom.us/j/293750042 - Agenda -

[Koha] koha with nginx

2020-06-02 Thread Sunita Barve
Dear all We would like to know whether any one has configured koha with nginx. If yes can someone tell how to do it. -- Sunita Barve, Ph. D. Senior Technical Officer National Chemical Laboratory Dr, Homi Bhaba Road Pune 411008, INDIA Email :sunitaba...@gmail.com