- Koha - lists.katipo.co.nz

Using the Recalls feature
by Eric Phetteplace 21 Jan '23

21 Jan '23

Hi collective wisdom, Are there other libraries out there using the fairly new (as of 22.05) Recalls feature? Our prior ILS had recalls so we were looking forward to using this but as our circulation staff tested it, we began running into some problems. I've read the wiki page <https://wiki.koha-community.org/wiki/Catalyst_IT_Recalls> and the manual documentation <https://koha-community.org/manual//22.05/en/html/circulation.html#recalls> but they either omit some details or there are bugs. Here are our issues: There's no indication from a patron's details page if their items have been recalled. When you check in an item with a recall on it, a pop-up does not appear like the documentation says and a notification is not sent to the patron who placed the recall. If the current due date on a checked out item is closer than the recall period, recalling an item *extends* the due date (e.g. item is due tomorrow, recall period is one week, recall => item is due in one week). Question: if the RecallsMaxPickUpDelay setting controls recall expiration, then what does the "Recall pickup period" circulation rule do? The *Place recall* action displays even when it's not relevant (e.g. on a bib with all available items). Finally, if you are not logged in and you select *Place recall*, you are taken to the login page, then to the patron details page. You have to re-navigate to the place you were originally to place the recall again. I have a convoluted OpacUserJS hack to work around this but thought I should point this out, it doesn't match user expectations. Are we doing something wrong? Or should I file some bug reports for these issues? If anyone else is using recalls in production, I would love to hear from you. Best, ERIC PHETTEPLACE Systems Librarian, Libraries (he/him) ephetteplace(a)cca.edu | o 510.594.3660 (cca) *CCA is situated on the traditional unceded lands of the **Chochenyo and Ramaytush Ohlone** peoples.* Black-owned bookstores in Oakland: Ashay by the Bay <https://ashaybythebay.com/>, Marcus Books <https://www.facebook.com/marcus.books/> :(){ :|: & };:

2 2

Wiki account requests - now working
by David Nind 20 Jan '23

20 Jan '23

Account requests for the Koha Community Wiki are now working ( https://wiki.koha-community.org) Following the Wiki upgrade last year, some work was required to get the email notification working. This was resolved and working again from about mid-December. If you unsuccessfully tried to request an account after the Wiki upgrade (and up until about mid-December), please try again. Notes: - New account requests are emailed a confirmation request - please check your spam folder if it doesn't arrive within a reasonable timeframe. - Please include some information in your profile: it doesn't have to be much, just enough to help us separate you from spam requests (such as you are interested in Koha, or your organisation uses Koha). - Confirmed new account requests are moderated by selected community members, so there may be a delay before your account is active: at most this is normally done within a day or so (moderation is used to minimise spam registrations). David Nind | david(a)davidnind.com Oamaru 9492, New Zealand m. +64 21 0537 847

1 0

The Terrific Every-Other-Thursday Training Video | S3E10 | Custom Alerts
by BRANNON, CHRISTOPHER 20 Jan '23

20 Jan '23

Where's George? Probably doing something exciting. Sorry we didn't give you a heads up. But if you want a better heads up in Koha, then this week's video is for you. Christopher will share how to create custom alerts for check in, or whatever else floats your boat. He'll demonstrate how he created a custom alert for deactivated devices that have made their way back to the library. https://youtu.be/IMW_6DIoh4o Christopher Brannon koha-US 2023 President

1 0

[Docs] Screenshot update extravaganza at Hackfest
by Caroline Cyr La Rose 19 Jan '23

19 Jan '23

Hi everyone! I'm not sure if I'm allowed to say, "We're doing this at hackfest!" without consulting anyone, but here goes... We had a documentation meeting today and Aude raised the idea of using the hackfest to pool our resources to update the screenshots in the manual for the new staff interface design. We thought this was a great idea! We don't currently have an automation setup or anything so if any developer is open to help us with this it would be great. I know Jonathan talked to me of "Cucumber" many years ago, and David was also working on something, but neither panned out so far. Barring automation, if we all get into it and work as a team, we could do a lot of them manually too. Note that this is open to virtual participation! It's fun to be together to work alongside each other, but if someone can't make it to Marseille, the chat will be open or we can plan video chats too. Regards, Caroline <https://inLibro.com/en> Caroline Cyr-La-Rose, M.L.I.S. Librarian | Product Manager P 833-INLIBRO (465-4276) <tel:833-465-4276>, poste 221 E caroline.cyr-la-rose(a)inlibro.com www.inLibro.com <https://inLibro.com/en>

1 0

Sorry, your Google login failed
by tony.h 19 Jan '23

19 Jan '23

Greetings, I'm having trouble getting the Google login to work since upgrading/rebuilding Koha (we rebuilt the VPS and followed the install guide: https://wiki.koha-community.org/wiki/Debian) *The problem:* 1) I can log in through my local account, no problem. 2) I then try to login through my Google account 3) After pressing allow from the accounts.google.com site, a message is displayed: /Sorry, your Google login failed. .../ The full message is below. "Log in to your account Google login Sorry, your Google login failed. The email address you are trying to use is not associated with a borrower at this library. Please note that the Google login will only work if you are using the e-mail address registered with this library. If you want to, you can try to log in using a different account Log in with Google If you do not have a Google account, but do have a local account, you can still log in:" There are no errors in the Apache log files. *Configuration* Since we had troubles, I'm following the testing guide to configure the OAuth login: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10988#c68 I removed the Google OAuth entries: DELETE FROM systempreferences WHERE variable LIKE 'GoogleO%'; I then ran the upgrade schema tool, as I did when I imported the db: sudo koha-upgrade-schema keiin_lib I added values back in admin panel (Home › Administration › System preferences > Google OpenID Connect I confirmed the 4 values are displayed in the MySQL DB: SELECT * FROM systempreferences WHERE variable LIKE 'GoogleO%'; Any thoughts? Tony -- View this message in context: http://koha.1045719.n5.nabble.com/Sorry-your-Google-login-failed-tp5895227.… Sent from the Koha-general mailing list archive at Nabble.com.

5 5

22.11.02 Koha String Freeze
by O'Mara, Jacob 18 Jan '23

18 Jan '23

Hello all, Happy New Year! This email is to announce a String Freeze for the coming 22.11.02 release of Koha stable. Kind regards, -- *Jacob O'Mara* *Junior Software Engineer* E: jacob.omara(a)ptfs-europe.com <andrew.auld(a)ptfs-europe.com> P: +44 (0) 1483 378728 ext. 1019 www.ptfs-europe.com

1 0

Koha upgrade and restore issue
by vinod mishra 18 Jan '23

18 Jan '23

Hello I wish to restore the database from one server to other in same version (22.05.07.000) but while running the " *sudo koha-upgrade-schema library*" command it through following error. Almost same error getting while running " *sudo koha-rebuild-zebra -v -f library* " command. Please suggest the possible issue. root@koha-OptiPlex-9010:/home/koha# sudo koha-upgrade-schema library Upgrading database schema for library DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. Use of uninitialized value in numeric lt (<) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 78. DBD::mysql::db do failed: Table 'koha_library.bookshelf' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::db do failed: Table 'koha_library.shelfcontents' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. Undefined subroutine &main::DropAllForeignKeys called at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 86. root@koha-OptiPlex-9010:/home/koha# With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 URL: http://vinod.itshelp.co.in/ ORCID ID: http://orcid.org/0000-0003-4666-7874 Scopus ID: 57223138343 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*

1 0

SQL for Report generation - Help needed
by Manoj Kumar 18 Jan '23

18 Jan '23

Can anyone help me to write the sql code for retrieving Most checked out books of a particular range of call numbers and the patron who took those books. Regards manoj -- manoj

1 0

Fine calculation on over dues books
by Banesh Hiremath 18 Jan '23

18 Jan '23

Hi, I'm using the KOHA 21.05.02.000 version. In this version, the fine does not appear on overdue items, but it appears after the book is returned. When students access the OPAC, the fine does not appear. Please assist us in resolving the above issue. -- Thanks and Regards B. K. Hiremath

4 3

debian OS image cd or dvd - which one to be used?
by SATISH 17 Jan '23

17 Jan '23

Hi, Regarding installation of Operating System (Debian for Koha) what is the difference between using cd image or dvd image. I understand that the DVD image has a complete set of packages whereas NetInst CD image has only a limited number of packages required to boot into installation. I follow wiki pages and other various blogs for installation. However, I would like to know, selecting cd or dvd really helps koha or maintenance of the system? because I am going to use the packages method of installation for koha. Kindly advise. -- *Satish MV* Librarian - Govt. Engineering College Opp. Dairy Circle, B.M.Road, Hassan 573 201 Karnataka, INDIA Mobile: +91 9449765737

2 1