- Koha - lists.katipo.co.nz

Re: [Koha] Koha 18.11 - SQL report to select ISBNs by Subject
by Alvaro Cornejo 21 Mar '19

21 Mar '19

Hi Okpa Please always copy the list. Therefore others can benefit from the discussion and you can receive help from more people. You need to enter your staff interface and go the the ABOUT page. There you will find details about the issue you have. Regards, Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com Le jeu. 21 mars 2019 à 03:08, Okpa, Nkanu <nokpa(a)aul.edu.ng> a écrit : > Good morning sir. Please, i need a lasting solution to this problem below. > Check in message > > 9780321837929: Elementary statistics. > <http://library-intra.aul.edu.ng/cgi-bin/koha/catalogue/detail.pl?type=intra…> > > The item has not been checked in due to a configuration issue in your > system. You must ask an administrator to take a look at the about page > <http://library-intra.aul.edu.ng/cgi-bin/koha/about.pl#sysinfo> and > search for the "data problems" section >

1 0

Koha is using 100% CPU
by Victor Barroso Oliveira 20 Mar '19

20 Mar '19

Koha is using 100% CPU and causing slow access. How can I solve this problem?

2 1

Kohacon19
by Chris Cormack 20 Mar '19

20 Mar '19

Kia ora koutou For those of us fortunate enough to be able to go to Kohacon this year I have started a page https://wiki.koha-community.org/wiki/Kohacon19/Social Where people can record their flight times and perhaps make some plans for social events. Please feel free to add to it. Chris -- Sent from my Android device with K-9 Mail. Please excuse my brevity.

1 0

Koha 18.11 - SQL report to select ISBNs by Subject
by Craig Butosi 20 Mar '19

20 Mar '19

Hi everyone, Running Koha 18.11 on Ubuntu 16.04 w/ MariaDB. Having a bit of trouble understanding the db structural changes made in 18.xx and how SQL reports are built in Koha 18.11. I know some tables and such have changed since the old 16.xx days. *I'd like to create a report that draws a list of ISBNs, along with call number and title, for my coverflow carousel based on subject (i.e., 650$a) keyword*. I'd like to start featuring subject-based resources on the carousel, not just new items. Any help would be very much appreciated. Just a note: there are a few reports on the Koha SQL reports wiki that involve querying on the 650 field; but these do not work for what I would like to achieve. Many thanks, Craig Butosi, MA, MLIS, B Mus (Hons) Library: library.craigbutosi.ca

5 9

Holds and one day loans
by Magnus Enger 19 Mar '19

19 Mar '19

Kia ora, dear Community! Here's a tricky one, at least it has proven so to me... Say a library has two kinds of books: - One-day-loan - loans that are due at 23:59 on the day you borrow them and that can not be reserved/put a hold on - Regular loan - can be borrowed for e.g. 28 days and can be reserved Item-level holds are not allowed On shelf holds are "if all unavailable" RecordA has two items: - Item1 is a One-day-loan, sitting on the shelf - Item2 is a Regular loan, on loan to someone Question 1: How can we allow someone to put a hold on this record, when Item1 is sitting on the shelf? (It's like Item1 should not be taken into account when checking if "all" are unavailable.) Then we change the situation a bit: - Item1 is a One-day-loan, on loan to someone - Item2 is a Regular loan, on loan to someone - There is at least one hold on the record Question 2: If Item1 is returned, how can we stop that from triggering the "there is a hold on this". One-day-loans should never be used to fill holds. In addition: - Item1 is a One-day-loan, sitting on the shelf - Item2 is a Regular loan, sitting on the shelf = It should not be possible to place a hold on this record. Anyone got a solution to all of this? I'd love to hear it! Best regards, Magnus Enger Libriotech, Norway

2 1

String Freeze (Maintenance Branches)
by Renvoize, Martin 19 Mar '19

19 Mar '19

Hi All, Just a quick notification that we're not in string freeze for the maintenance branches, with the series of maintenance releases due on the 18th. Go forth and update your translations, Many thanks, *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize(a)ptfs-europe.com *Fax:* +44 (0) 800 756 6384 www.ptfs-europe.com Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info(a)ptfs-europe.com

1 1

Funding a Koha Community Position
by Jessica Zairo 19 Mar '19

19 Mar '19

Good Evening, ByWater Solutions is excited to announce funding a position in the Koha community. The goal of the funding is to support the development process in the Koha community. You can read the complete statement here on the ByWater Solutions Website! https://bywatersolutions.com/news/bywater-solutions-americas -forefront-provider-of-koha-support-sponsors-another-koha-community-position Thanks, Jessie -- Jessica Zairo Marketing & Outreach Coordinator ByWater Solutions bywatersolutions.com Phone:(888)900-8944

2 4

Request vs. Walk-in Circulation report
by Chad Roseburg 19 Mar '19

19 Mar '19

Anyone got any reports or tricks kicking around for examining the percentage of circ from walk-in vs. originating in a request at a given branch? Thanks in advance! Chad -- Chad Roseburg Assoc. Director / IT Automation Dept. North Central Regional Library

2 1

Setting up autorenewals for a borrower category
by Carlos Lopez 19 Mar '19

19 Mar '19

Hi folks We seem to have a problem with automatic item renewals for a specific borrower type (in that they don't seem to be autorenewing). For this specific group we have the following circ rules: Loan period 30 ... Renewals allowed (count) 5 Renewal period 30 No renewal before 15 Automatic renewal Yes No automatic renewal after 4 ... Our understanding is that items borrowed by this group of borrowers would autorenew 4 times (for an automatic loan period of 120 work days, with a possible further 30 days available after renewing manually. Is that not the case? We do not have an autorenewal notice set up. Would this make a difference? We're on version 18.05. With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | library(a)dml.vic.edu.au | library.dmlibrary.org.au -- Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.http://www.mailguard.com.au/mg

3 4

Publisher + Video Editing
by jeff haskell 18 Mar '19

18 Mar '19

Hi my learned listmates, Working as a library technician, the county offers certain courses for continuing education. I’ve contacted instructors who teach MS Publisher and shared a file I’ve been trying for a long time to recreate and then edit but these instructors had no suggestions. I subscribed to an online MS Publisher forum and posted my Publisher question and then reposted and it neared over 20 views but no responses. Has anyone found a good online forum to help them troubleshoot Publisher projects? I’ve watched numerous YouTube tutorials but none addressed the task I’m trying to accomplish. I’m happy to share that file via email with anyone who’d be willing to take a look at it? It’s a small file. It’s really too much describe in just words. Also, has anyone found a good video editing online forum? Again, this would not be for a tutorial but for interactive conversations like this online group? Thank you.

2 1