- Koha - lists.katipo.co.nz

Search/List RSS feeds (trigger? add call number?)
by Bales (US), Tasha R 12 Sep '21

12 Sep '21

Good morning, I'm writing with a couple questions about out-of-the-box RSS feeds for searches. I'm interested in how to modify them (I really need one or more of our call numbers/classification numbers to be included), and how they are triggered. I see two types of feeds, below. "Subscribe to this search" * The manual says this feed "will allow you to see when a new item is added to the catalog". * How is a "new item" defined? I've taken a look at opac-opensearch.tt and opac-search.pl, in order to under how date limiting is coming in to play, specifically (which dates, what comparison, what fields, etc.). I do see reference to an 005 date "hack" for Atom, but it seems like only the RSS portions of the code are relevant. I'd like to determine if I can only ever expect newly added records to be returned, or would/could updated records also be returned? "Subscribe to this list" * I don't see information about this feed in the manual. * Since this is a search about already-cataloged, known items, it wouldn't make sense for the RSS to retrieve only newly cataloged records. Therefore, what should trigger a subscriber to receive an update about their list if an item has been updated? Is it the bib 005, or something else? I've tried editing a few records in a list I am subscribed to, expecting to get a new email, but I didn't receive a message. Although this last part may sound confusing, I'm leaving as is, as it may help explain context-I've added the feeds to my Microsoft Outlook, where each matching item shows up as a discrete "email" message in my RSS Feeds folder. Maybe the problem here is my understanding of RSS. My feeds appear to be refreshed every time I check my mail, but I'm only receiving RSS for newly added records. I didn't receive a new feed today of records in my "list" that I edited yesterday. Finally, I find that the RSS output is not usable for my patrons. We really need call number to be included in the RSS. It looks like we could modify the template line below to swap out isbn with another identifier, but I'm not sure how to know what term to swap in after "SEARCH_RESULT.": <dc:identifier>ISBN:[% SEARCH_RESULT.isbn | html %]</dc:identifier> I've tried "report-number", "callnum", "lcn", and "local-classification", which all failed to produce results. Please advise if there are any known examples about customizing the RSS templates for the basic searches above (I didn't see anything promising in the Wiki, when I searched for "RSS" or "opensearch.tt"). Thanks so much for your time, Tasha Bales Enterprise Services http://isesi.web.boeing.com/

2 3

VuFind Summit 2021
by mohan pradhan 10 Sep '21

10 Sep '21

Central Department of Library and Information Science, TU in partnership with Villanova University’s Falvey Memorial Library, the VuFind Summit 2021 is going to be organized on November 15-17, 2021. Welcome you all for presenting your paper and participation. For details click the link: VuFind Summit 2021 <https://vufind.org/wiki/community:conferences:summit_2021:cfp#call_for_pape…> Prof. Mohan Raj Pradhan, Ph. D. Secretary VuFind Software

1 0

Security releases for all stable branches - UPGRADE!
by Jonathan Druart 09 Sep '21

09 Sep '21

Hello everybody, Don't ignore this email! Last week a critical security bug was reported on our bug tracker. We fixed it and built debian packages for the four stable releases we currently support. The security flaw can cause a privilege escalation from OPAC users. It can be highly damaging, especially if your staff interface is accessible via login from everywhere without further security measures like IP restrictions in place. How to fix the problem? If you are using a debian-based system you should upgrade using the debian packages: % apt update % apt install koha-common If you are using an older version of Koha (<19.11) you should either upgrade to a newer version, or apply those two patches (they should apply on older versions as well): https://paste.debian.net/hidden/885fb5ec/ https://paste.debian.net/hidden/1184f523/ https://paste.debian.net/plainh/ae9f9f25 You can apply them using the following command: % wget "https://paste.debian.net/plainh/885fb5ec" -O 28929_1.patch % wget "https://paste.debian.net/plainh/1184f523" -O 28929_2.patch % wget "https://paste.debian.net/plainh/ae9f9f25" -O 28947.patch % patch -p1 -d /usr/share/koha/intranet/cgi-bin/ < /kohadevbox/koha/28929_1.patch % patch -p1 -d /usr/share/koha/opac/cgi-bin/ < /kohadevbox/koha/28929_2.patch % patch -d /usr/share/koha/opac/cgi-bin/opac/ < /kohadevbox/koha/28947.patch The two bugs are 28929 and 28947. As they contain information about how to recreate the vulnerability they will stay hidden two more days to let you upgrade your systems. Let us know if you have any questions! Regards, Jonathan

3 4

install koha
by stefan 09 Sep '21

09 Sep '21

Hi, I'm from Romania, I'm a librarian and I want to install koha on the library computer. I tried using the instructions at https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Install_Ubun… but without success. On the computer i have ubuntu 20.04.3. I want to install koha and then get in the system all the books in the library and all the students that come to the library. I want to get koha up and running individually on this local computer. I don't have a system admin at the school. The computer is connected to the internet. Can somebody explain to me how i configure /etc/koha/koha-sites.conf? Also, what is the difference between web install and IP install. What would be best form me? I don't know about domain names and INTRAPORT AND OPACPORT...

3 2

500 error when choosing patron for purchase suggestion
by Jesse Stallings 09 Sep '21

09 Sep '21

Running 21.05.02 on Debian stretch 9.13. When selecting "set to patron" or "select manager" while entering a purchase suggestion from the staff console, a 500 error rather than a patron search box appears in the popup. This issue seems related to bug 26738 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26738>, where suggestion managers and patrons were unable to be saved, but I'm unable to get even that far. I'm not sure how to troubleshoot this—has anyone else run into this issue? Created bug report 28946 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28946> last week, but hasn't received any attention. Thanks!

1 0

Elasticsearch error stops bulkmarcimport
by Bales (US), Tasha R 07 Sep '21

07 Sep '21

I've occasionally seen this error when loading MARC record on the command line using bulkmarcimport.pl: Bad response received when submitting request to Elasticsearch. When it occurs, the bulkmarcimport ceases, interrupting the load. I've found nothing else in any other logs on the Koha server that help explain the error. I'm not sure what Elasticsearch has to do with my bulkmarcimport, unless it is Elasticsearch trying to index records on-the-fly after they are loaded? Is there an easy way to prevent this error from happening? Perhaps I should stop the Elasticsearch process while doing a bulkmarcimport? My Elasticsearch servers are external to the Koha environment, and I don't see any obvious indexing processes running on my local machine, so I'm not sure how best to intervene to prevent the above issue. I'm currently working my way through loading 1.3 million records, and I've had several redo's already as a result of loads being interrupted partway through (running bulkmarcimport via a cronjob helped *a lot*, but now I've had two ES errors/interruptions in the last day, which has put me a day behind). I am currently working with batches of 200K records or less. Thanks for any tips you may have! In the meantime, I will modify my latest MARC file to try to remove records already loaded and then resubmit the job (in order to save additional hours spent reloading 98K records). Tasha Bales Enterprise Services http://isesi.web.boeing.com/

1 0

Out Of Office until 21 September 2021
by sheralynb 04 Sep '21

04 Sep '21

Thank you for contacting me. I will be out of the office until 21 September 2021 and not checking email. In the event of an emergency, please contact kimc(a)latahlibrary.org. Sheralyn Bassett She/Her/Hers Manager of Technical Services Latah County Library District 110 S. Jefferson, Moscow ID 83843 208-882-3925 ext 120

1 0

report to show the listing of titles entered by each Librarian
by Victor Barroso Oliveira 03 Sep '21

03 Sep '21

Good morning, This report allows you to view the number of items entered for each Librarian. SELECT concat(p.firstname, ' ', p.surname) AS Operador, concat(a.action, ' ', a.info) AS Ação, count(a.timestamp) AS Quantidade FROM action_logs a LEFT JOIN borrowers p ON (a.user=p.borrowernumber) WHERE a.module='CATALOGUING' AND a.timestamp BETWEEN <<Data Inicial (dd.mm.yyy)|date>> AND <<Data Final (dd.mm.yyy)|date>> AND a.info IN ('item','biblio') GROUP BY p.borrowernumber, concat(a.action, ' ', a.info) How can I change this report to show the listing of titles entered by each Librarian?

1 0

List of all cataloged items and the users who inserted the item.
by Victor Barroso Oliveira 02 Sep '21

02 Sep '21

Good afternoon, What would be the sql code to generate a report with a list of all cataloged items and the users who inserted the item.

1 0

Error upgrading Koha from version 18.06 to Koha 21.05
by Admire Mutsikiwa 02 Sep '21

02 Sep '21

Good day. I was trying to upgrade Koha from version 18.06 to 21.05 on Ubuntu 20.05. I installed Ubuntu 20.04 and then installed Koha 20.05. I then used the Koha 18.06 database dump to restore the Koha database after dropping the Koha 20.05 database. On trying to do the database schema upgrade, I am getting the following error: The following error occurred while importing the database structure: DBD::mysql::st execute failed: Referencing column 'message_transport_type' and referenced column 'message_transport_type' in foreign key constraint 'borrower_message_transport_preferences_ibfk_2' are incompatible. at /usr/share/perl5/DBIx/RunSQL.pm line 279, <$args{...}> line 1. Something went wrong loading file /usr/share/koha/intranet/cgi-bin/installer/data/mysql/kohastructure.sql ([SQL ERROR]: CREATE TABLE `borrower_message_transport_preferences` ( `borrower_message_preference_id` int(11) NOT NULL DEFAULT 0, `message_transport_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`borrower_message_preference_id`,`message_transport_type`), KEY `message_transport_type` (`message_transport_type`), CONSTRAINT `borrower_message_transport_preferences_ibfk_1` FOREIGN KEY (`borrower_message_preference_id`) REFERENCES `borrower_message_preferences` (`borrower_message_preference_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `borrower_message_transport_preferences_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ) at /usr/share/koha/lib/C4/Installer.pm line 580. Any pointers will be greatly appreciated. Kind Regards,

2 1