- Koha - lists.katipo.co.nz

ssl for koha login
by Alvaro Cornejo 10 Jun '18

10 Jun '18

Hi I´m trying to setup a ssl connection to Koha (using letsEncrypt certs ) so my users, admin and opac can have a secure connection. I´ve folllowed letsEncrypt & certbot instrucctions but neither opac nor admin pages work. I´ve tried directing connections manually and configuring apache for redirect unsuccessfully. Any hints on this? This is mostly to avoid the upcoming chrome config where it will display an unsafe site warning to any site requiring login that does not use ssl Regards, Alvaro

3 5

Out Of Office until 6-20-2018
by sheralynb 09 Jun '18

09 Jun '18

I appreciate your message. I am out of the office until 20 June 2018. If this is an emergency please contact sheilag(a)latahlibrary.org Thank you! Sheralyn Bassett Technical Services Assistant Latah County Library District

1 0

Re: [Koha] Koha upgrade from 17.11 to 18.05
by Father Vlasie 08 Jun '18

08 Jun '18

I used apt-get rather than apt: apt-get update apt-get upgrade apt-get install koha-common That is what worked for me on Debian 9. It may be superstition but I do not trust apt without the get! Hoping this helps, Father Vlasie St. Photios Orthodox Theological Seminary 510 Collier Way, Etna, CA 96027, U.S.A. Website: www.spots.school > On 28 May 2018, at 07:32, koha-request(a)lists.katipo.co.nz wrote: > > Date: Mon, 28 May 2018 10:25:11 +0200 > From: Narcis Garcia <informatica(a)actiu.net <mailto:informatica@actiu.net>> > To: koha(a)lists.katipo.co.nz <mailto:koha@lists.katipo.co.nz> > Subject: Re: [Koha] Koha upgrade from 17.11 to 18.05 > Message-ID: <bc0f9293-745d-8846-fc10-37c7fb3c07b0(a)actiu.net <mailto:bc0f9293-745d-8846-fc10-37c7fb3c07b0@actiu.net>> > Content-Type: text/plain; charset=utf-8 > > This rare method (no apt upgrade), is not working for me in Debian 9 + > Koha 17.11 : > > $ sudo apt install koha-common > Reading package lists... Done > Building dependency tree > Reading state information... Done > Some packages could not be installed. This may mean that you have > requested an impossible situation or if you are using the unstable > distribution that some required packages have not yet been created > or been moved out of Incoming. > The following information may help to resolve the situation: > > The following packages have unmet dependencies: > koha-common : Depends: libnet-oauth2-authorizationserver-perl but it is > not going to be installed > E: Unable to correct problems, you have held broken packages. > > When I try normal method; any of: > apt upgrade > apt full-upgrade > apt-get upgrade > apt-get dist-upgrade > ; general packages can't be upgraded without uninstalling koha-common

3 2

Import the MARC21 with Item details
by Laxmi Lal Menaria 08 Jun '18

08 Jun '18

Hello everyone, I have marc21 file with more than 20K records, I would need to import in the Koha with the barcode, I have updated the Marc21 file with MarcExit tool and added items with 952, but still it doesn't reflect in the Koha catalog. When tried to use circulation it says invalid. So please let me know how can I import marc21 file with barcode data. For barcode I have tried these 2 things: =952 \\$a2442 ;$b2442 ;$o2442 ;$p2442 ;$yBooks =952 \\$p2442 Both are not working, please let me know how can I fix it. -- Thanks, Laxmilal Menaria | +91 982 955 3793 | http://laxmilalmenaria.com/

5 17

Meeting invite & call for agenda items - koha-US Users Group: June 13th, 2018
by koha-US Secretary 08 Jun '18

08 Jun '18

Date: Wednesday, June 13th, 2018 Time: 10:30 AM - 11:30 AM CDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+June+gene…> ) Location: https://kslib.zoom.us/j/450230564 <https://kslib.zoom.us/j/450230564%E2%80%8B> Agenda: *http://koha-us.net/index.php/Agenda2018-06-13 <http://koha-us.net/index.php/Agenda2018-06-13>* Feature creep and the cleanup of unused/nonfunctional features is high on our list of topics this month. If you're planning to attend, we would encourage you to take a look at bug 20396 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20396> and then view the various bugs linked in the 'Depends on' section. We will discuss features of interest and talk about how to voice your opinion. The full agenda is linked above. If you have additional topics, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended for optimal participation, but not required. These meetings are free and open to any and all. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Staff Collection in Koha
by Chad Roseburg 07 Jun '18

07 Jun '18

Just curious as to how other libraries set up staff only collections. I suspect that I am overthinking this. We'd like to create a collection for librarian-led programs, Eg., movie night, program kits ...etc. Such that: - Hidden in OPAC via OPACHiddenItems - Easily searchable by staff - Non-floating - No reserves or checkouts allowed except to staff I see 2 - 3 possibilities: - Item Type - Location or branch "Staff Collection" - Some combination of the 2 (?) I'm not a fan of using item type as it complicates the role and meaning ( taxonomic ) of item type for material classification so I'm leaning towards creating a branch and assigning rules to this branch. Shelving location does not offer the same flexibility, correct? I don't see a way to set rules by shelving location. That would be ideal as this collection is housed at an existing branch. Thank you! -- Chad Roseburg Assoc. Director / IT Automation Dept. North Central Regional Library

2 2

New Google Group for Koha and EDS users
by Myka Kennedy Stephens 07 Jun '18

07 Jun '18

Hello Koha folks, Our library implemented EBSCO Discovery Service three years ago. In that time I have learned that implementation is an ongoing, perennial process. I find that I still have new questions and new frustrations as I work to integrate EDS with Koha in a way that works for our users and meets all their research and access needs. It occurs to me that I am not alone in this quest and there are others of you out there. We might be struggling with the same or similar issues. We might have thoughts and ideas about how the EDS API plugin for Koha might be improved. We might be able to help one another when things go awry. To this end, I've created a Google Group: https://groups.google.com/forum/#!forum/kohaeds-user-group It is a public group for anyone to read. Members of the group may post, and anyone can join. I've set up a simple open-ended question for folks to answer in order to join so that we can cut down on spam. If you are a Koha library who also uses EDS or are thinking about EDS, I hope to see you in the group! Anyone interested in assisting me with managing the group, please email me off-list. Cheers, Myka -- Deaconess Myka Kennedy Stephens, MDiv, MSLIS Seminary Librarian and Assistant Professor of Theological Bibliography Lancaster Theological Seminary 555 West James Street Lancaster, PA 17603 717-290-8704 mkstephens(a)lancasterseminary.edu https://library.lancasterseminary.edu

3 4

fines keeps increasing for check in items
by Akin Adigun (Akinomatics) 07 Jun '18

07 Jun '18

Hello, pls i have this strange question that i need an answer to. A patron that borrowed book and Accruing fine keeps increasing despite the return of the book and when I check the account of the Patron most of this added value to the amount after the return of the item(s) is/are always with either FU and some with F under the account type. What can be responsible and what can be done. I am using Koha 3.22.04.000 on Debian 8.2Thanks

1 0

Help with funding the koha-community.org webserver
by Liz Rea 07 Jun '18

07 Jun '18

Hi all, I've been funding the koha-community web server for about 5 years now, and I've been happy to have the disposable income available to me to do that personally. As it turns out, this year I don't really have that and I could really use some help paying for it. The server is paid for yearly, this year it was $308 NZD It's all paid up until June of next year. If you'd be interested in tossing a few dollars my way to support running the website, I'd be really grateful. I think it would be better to have a community funded server anyway. I'm happy to keep looking after the server and website too. I don't have a plan currently for how best to receive the funds - ideas welcome on this front as well. Thanks for your consideration, Cheers, Liz

8 10

Variables in reports
by Cab Vinton 06 Jun '18

06 Jun '18

Hi, All -- We have a report with the following WHERE clause: WHERE b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND homebranch='KIMBALL') AND b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND homebranch='PLAISTOW') AND b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND homebranch='SANDOWN') Is there a way to declare & assign variables within a standard report? I'm familiar w/ the section in the Reports wiki on runtime parameters & variables (https://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Parameters) I've also played around w/ SET statements. But no luck finding a way to avoid repeating the date calculation three times without getting errors. As an aside, here's another approach to finding items owned by all 3 branches: WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= i.dateaccessioned AND i.homebranch IN ('kimball','plaistow','sandown') GROUP BY biblionumber HAVING count(DISTINCT homebranch) = 3 Thanks in advance for any guidance. All best, Cab Vinton Plaistow Public Library Plaistow, NH

2 2