- Koha - lists.katipo.co.nz

koha-US Board Meeting Reminder: Wednesday, July 5, 2023
by Jennifer Marlatt 03 Jul '23

03 Jul '23

Hello! The next koha-US Board Meeting is Wednesday, July 5, 2023. When: 8:30a PT / 11:30a ET (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+Board+Mee…> ) Where: https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 Agenda: https://docs.google.com/document/d/1ns5bQNntkuMG_MqmVRFHAPPMqatLEqnQIssF7M5… If you have additional topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops, and Android and iOS on mobile devices. For help getting started, visit: https://support.zoom.us/hc/en-us/categories/200101697 These meetings are always free and open to any and all. Jennifer Marlatt koha-US Secretary secretary(a)koha-US.org

1 0

Elasticsearch works in the server but we can not search from OPAC and intranet
by Mengu Yazicioglu 03 Jul '23

03 Jul '23

Hi all, I'm trying to move from Zebra to Elasticsearch on live products. I have to finish all before to come to KohaCon, so with any help you give I'll be so close to come Helsinki ;) Debian 11.7 Koha 22.11.05 Elasticsearch 7.17.11 I've seen that my elasticsearch indices established and ES is working, though I'm not sure whether yellow open says something wrong below green open .geoip_databases 1 0 42 0 40mb 40mb yellow open koha_devinimkoha_authorities 5 1 112921 0 62.8mb 62.8mb yellow open koha_devinimkoha_biblios 5 1 67342 0 121.7mb 121.7mb I can also query data from command line, but I cannot see anything from OPAC and intranet. I've already changed SearchEngine parameter from adminstration to ES. Do we need to change the network.host parameter to some IP in the file elasticsearch.yml or Koha and ES communicate through localhost? Does anyone have an idea? I really do not know what I should look at somewhere else. Thanks. -- Mengü Yazıcıoğlu Devinim

2 2

MARC preview on auts vs. bibs?
by Hernandez, Heather H 30 Jun '23

30 Jun '23

Hi! We've just been upgraded to 22.11 (I LOVE IT!!!) and the MARC preview of authority records is working, but it's different from the MARC preview for bibliographic records and, well, I don't like it. The MARC preview for auts has all the tag labels (e.g., 455 ## - SEE FROM TRACING--GENRE/FORM TERM) and I already know all that—IMO, anyone looking at the MARC preview already knows all that. So it's not really a MARC preview—it's a repeat of the regular display in one pop-up window. I don't like this, because I want a way to see an unlabeled MARC aut record in one screen—to be able to look at it, read it, etc., quickly. There is currently no way to do that, and I think having the MARC preview repeat all the tag/field labels that are already present in the regular display is redundant. I would love for the aut MARC preview to be exactly the same as the bib MARC preview, so there is a way for catalogers to quickly see an unlabeled MARC record that they can examine, scan, read, etc. But am I the only one? Should I put a bug into Bugzilla for this? (Is there a but already there that I couldn't find?) Thanks!! h2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ms. Heather Hernandez (she, her, hers) Technical Services Librarian Library catalog: https://keys.bywatersolutions.com/ San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032 (office, generally M, W, F, telecommuting Tu,Th) heather_hernandez(a)nps.gov<https://webmail.lmi.net/src/compose.php?send_to=heather_hernandez%40nps.gov>

2 4

Re: [Koha] Koha won't import items when importing MARC records
by Caroline Cyr La Rose 30 Jun '23

30 Jun '23

Hi Kevin, Can you have the $y in the same 952 as the rest of the info? Caroline On 2023-06-30 14:50, Furst, Kevin wrote: > Hi Caroline, > > I removed the Story Collection records from b, PRBHS is a > branchcode and I added the only item type I have "BOOKS" to the y > subfield for every record. Reran the import. Same problem. The records > look like this after changes. > > =LDR 00496nam a2200157u 4500 > =008 031201s1979\\\\||||||||||||||||||||eng|u > =010 \\$awsc00002522 > =100 10$aEdgar, Donald. > =245 10$aBritain's royal family in the twentieth century :$bKing > Edward VII to Queen Elizabeth II / > =260 0\$bCrown Pub.,$c1979. > =300 \\$a[ ] p. > =035 \\$a(NL)278906 > =005 20091111115742.0 > =001 19119 > =003 Generic > =952 > \\$p3333300007426Y$aPRBHS$bPRBHS$v20.00USD$x24543$eaRegular@c20050604$h920 > Edg$x548305 > =952 $yBOOKS > > =LDR 00429nam a2200157u 4500 > =008 031201s1980\\\\||||||||||||||||||||eng|u > =010 \\$awsc00002524 > =100 10$aHamer, Martyn. > =245 10$aFamous names in invention / > =260 0\$bWayland,$c1980. > =300 \\$a[ ] p. > =035 \\$a(NL)278908 > =005 20091111115742.0 > =001 19121 > =003 Generic > =952 > \\$p3333300007437-$aPRBHS$bPRBHS$v7.95USD$x24545$eaRegular@c20050604$h920 > Ham$x548307 > =952 $yBOOKS > > =LDR 00431nam a2200157u 4500 > =008 031201s1980\\\\||||||||||||||||||||eng|u > =010 \\$awsc00002527 > =100 10$aMonham, Kathleen. > =245 10$aFamous names in warfare / > =260 0\$bWayland,$c1980. > =300 \\$a[ ] p. > =035 \\$a(NL)278910 > =005 20091111115742.0 > =001 19123 > =003 Generic > =952 > \\$p3333300007440U$aPRBHS$bPRBHS$v20.00USD$x24547$eaRegular@c20050604$h920 > Mon$x548308 > =952 $yBOOKS > > > Note: Until I figure out what the problem is, I only process a small > subset of 299 records each time so there's not a lot of data to parse. > > > *Kevin Furst* > Technology Director > Pine River-Backus Schools > o | 218.587.8030 > @ | kfurst(a)prbschools.org > > Technology Office/Help Desk: 218-587-8510 > > /Confidentiality Notice: This E-mail message, including any > attachments, is for the sole use of the intended recipient(s) and may > contain confidential and privileged information. Any unauthorized > review, use, disclosure or distribution is prohibited. If you are not > the intended recipient, please contact the sender by reply E-mail and > destroy all copies of the original message./ > > > On Fri, Jun 30, 2023 at 1:03 PM Caroline Cyr La Rose > <caroline.cyr-la-rose(a)inlibro.com> wrote: > > Hi Kevin, > > Whenever I have this problem, it's because the branchcode doesn't > exist. > > Is PRBHS a branchcode in your system? > > I also noticed your first 952 has $bStory Collection. Is that a typo > from when you copied, or is this the actual value? If so, then Story > Collection needs to be a branchcode also. > > I'm not sure if the system would block for a lack of item type, but I > noticed your 952's don't have item types ($y) either. I don't > *think* it > would block if there are no item types, it would probably block if > the > item type code was wrong, but you might have problems later in > circulation if your items don't have item types. > > Good luck with your project! > > Caroline > > On 2023-06-30 13:20, Furst, Kevin wrote: > > Hello, > > > > TL;DR = When importing MARC records, items don't import and fail. > > > > I am transitioning from Follett Destiny to Koha. After doing a > MARC export > > from Follett, I noticed that when staging records for import, > Koha would > > parse the biblio records fine but wouldn't find any item > records. After > > searching past messages in this list, I found that Follett has > item records > > as 852 instead of 952. I used MARCedit to change those to 952 > and also > > added a and b records to match the libraries listed in Koha. > After doing > > that and trying again, item records were then found during staging. > > > > However when I import the staged records, it just fails and gives me > > nothing in the detailed messages in the UI. If I remove the 952 > records, it > > works fine and imports all the other records thus I know > something is wrong > > with my 952 entries. I have checked that there are p barcodes > and a and b > > home and current libraries. > > > > In the Koha logs on the server, this is the only error message I > get when I > > try to run an import and it fails. To me it seems like a FK is > missing on > > import but I don't know what. Looking at the schema example, I'm > wondering > > if I'm supposed to be importing things to 942 and 999 along with > 952. I do > > not know if, when importing MARC records, Koha creates its own > enumerated > > ids for biblio, item number, etc. if that stuff isn't in the > import file... > > or if it isn't there, will it fail? > > > > BIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: > DBD::mysql::st > > execute failed: Cannot add or update a child row: a foreign key > constraint > > fails (`koha_library`.`items`, CONSTRAINT `items_ibfk_> > > > > Broken FK constraint at > > /usr/share/koha/lib/Koha/BackgroundJob/MARCImportCommitBatch.pm > line 91. > > > > Here are a couple of 952 records from the Follett export to Koha > import > > file to see if something simple is wrong. I'm hoping it's > something simple > > on these lines. > > > > > > =952 \\$p34517100010472$aPRBHS$bPRBHS$bStory > > Collection$v10.00USD$x14441$eaRegular@c20060929@fTransfer from > PRB Elem.@j > > @j@j@i@i@i$hSC Otf$x1127380 > > > > =952 > \\$p3333300007200O$aPRBHS$bPRBHS$v20.00USD$x17292$eaRegular@c20050604 > > @j@j@j@i@i@i$hR 639 Can pb$x527111 > > > > > > (Beyond that, I haven't really tinkered with anything in the > default MARC > > framework settings in admin. > > Here is my version : > > *Koha version:22.11.05.000 Rosalie* > > > > I would really appreciate any help, I've been working on this > for over a > > week now. > > > > *Kevin Furst* > > Technology Director > > Pine River-Backus Schools > > o | 218.587.8030 > > @ | kfurst(a)prbschools.org > > > > Technology Office/Help Desk: 218-587-8510 > > > > *Confidentiality Notice: This E-mail message, including any > attachments, is > > for the sole use of the intended recipient(s) and may contain > confidential > > and privileged information. Any unauthorized review, use, > disclosure or > > distribution is prohibited. If you are not the intended > recipient, please > > contact the sender by reply E-mail and destroy all copies of the > original > > message.* > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > Caroline Cyr-La-Rose, M.L.I.S. (she/her) > Librarian | Product Manager > > 1-833-INLIBRO (465-4276), ext. 221 > caroline.cyr-la-rose(a)inlibro.com > https://www.inLibro.com <https://www.inLibro.com> > > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > Caroline Cyr-La-Rose, M.L.I.S. (she/her) Librarian | Product Manager 1-833-INLIBRO (465-4276), ext. 221 caroline.cyr-la-rose(a)inlibro.com https://www.inLibro.com

1 0

Re: [Koha] How to limit number of copies?
by Marcel de Rooy 30 Jun '23

30 Jun '23

Victor, Please see bug 34146. That code does not use intranetuserjs. It does use maxlength on the input as suggested by Owen. Marcel ________________________________ Van: Victor Barroso Oliveira <vbovictor(a)gmail.com> Verzonden: donderdag 29 juni 2023 19:02 Aan: Marcel de Rooy <M.de.Rooy(a)rijksmuseum.nl> Onderwerp: Re: [Koha] How to limit number of copies? Hello, The code inserted in "intranetuserjs" has not limited the number of copies. I'm using version 21.05.21 Em qui., 29 de jun. de 2023 às 02:44, Marcel de Rooy <M.de.Rooy(a)rijksmuseum.nl<mailto:M.de.Rooy@rijksmuseum.nl>> escreveu: Bug 34146, patches attached. ________________________________ Van: Koha <koha-bounces(a)lists.katipo.co.nz<mailto:koha-bounces@lists.katipo.co.nz>> namens George <gwilliams(a)nekls.org<mailto:gwilliams@nekls.org>> Verzonden: woensdag 28 juni 2023 16:07 Aan: koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> <koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>> Onderwerp: Re: [Koha] How to limit number of copies? Victor, I'd recommend opening a bug on Bugzilla saying that a system preference should be added to set the maximum number of copies that can be added to a bibliographic record when someone uses the "Add multiple copies of this item" button on additem.pl<http://additem.pl/>. In the meantime, if you put this jQuery in the intranetuserJS system preference, it will set the limit to 10 copies: //Home > Cataloging > Edit TITLE > items (cataloguing/additem.pl?biblionumber=n<http://additem.pl/?biblionumber=n>) //Limit the number of copies that can be added to a biblio using the "Add multiple copies of this item" button $('#cat_additem #number_of_copies').attr('type','number').attr('max','10'); And I'll add that jQuery to the jQuery library in just a few minutes. George On 6/27/2023 7:00 PM, koha-request(a)lists.katipo.co.nz<mailto:koha-request@lists.katipo.co.nz> wrote: > Message: 3 > Date: Tue, 27 Jun 2023 15:36:17 -0300 > From: Victor Barroso Oliveira<vbovictor(a)gmail.com<mailto:vbovictor@gmail.com>> > To: Koha<koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>> > Subject: [Koha] How to limit number of copies? > Message-ID: > <CACyxk604FQOuDbdUVN5pyVvkabRNxGhWZUyWsWvjrr2VppQEvQ(a)mail.gmail.com<mailto:CACyxk604FQOuDbdUVN5pyVvkabRNxGhWZUyWsWvjrr2VppQEvQ@mail.gmail.com>> > Content-Type: text/plain; charset="UTF-8" > > Hello, > In Koha it is possible to Add an instance or choose to "Add Multiple > Copies" simultaneously to a record. > So far so good. More..... I had a situation where an employee mistakenly > typed 800,000 copies for a record. > As a result, when Koha started its automatic Indexing routine, it consumed > all of the server's memory and crashed system access. When I tried to > delete the 800,000 copies in batch, the system crashed. It took slow > deletion from 5,000 to 5,000 to reach 800,000. > Considering the aforementioned case, would any colleague know if we can > limit the quantity in the option "Add Multiple Copies"? > Thanks, > Victor -- George Williams Pronouns: he/him Next Search Catalog Coordinator Send NEXT support e-mails to nexthelp(a)nekls.org<mailto:nexthelp@nekls.org> NEKLS Office: 785-838-4090 Toll Free: 888-296-6963 Fax: 785-838-3989 Next After-Hours: 785-813-1356 For specific support issues, please use: Next Catalog Support: nexthelp(a)nekls.org<mailto:nexthelp@nekls.org> Courier Support: chandwork(a)nekls.org<mailto:chandwork@nekls.org> Technology Support: tech(a)nekls.org<mailto:tech@nekls.org> 4317 W 6th St, Lawrence, KS, 66049 _______________________________________________ Koha mailing list https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-commu…<http://koha-community.org/><http://koha-community.org/> Koha(a)lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.kat…<https://lists.katipo.co.nz/mailman/listinfo/koha><https://lists.katipo.co.nz/mailman/listinfo/koha> _______________________________________________ Koha mailing list http://koha-community.org<http://koha-community.org/> Koha(a)lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Re: [Koha] SSO Shibboleth & oauth issues
by David Cook 30 Jun '23

30 Jun '23

Hey Justin, Sorry to hear you're having issues, but great to see another organisation in NSW using Koha! Let's see if we can help you sort out this issue. What version of Koha are you running, how did you install it, and on which Linux distro? With the Shibboleth, you'll want to look at your Koha logs. With the other auth, are you using OAuth or OIDC? David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 -----Original Message----- Date: Wed, 28 Jun 2023 23:49:06 +1000 From: Justin Dowswell <justin.dowswell(a)tenantsunion.org.au> To: koha(a)lists.katipo.co.nz Subject: [Koha] SSO Shibboleth & oauth issues Message-ID: <CAGzh+UPeBXVz2AsOXMyyXHbCtmY3mYLH3uBPfVYqYzcRCqhxCg(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Hey everyone, I am Justin from the Tenants’ Union of NSW. Lovely to meet you all, albeit in an archaic manner. There is a Koha issue I am having trouble resolving… It’s a strange issue with Shibboleth and now I think the same issue displayed differently with oauth (that I wanted to implement as an alternative), both using the same IdP, and definitely isolated to Koha and/or the server running it. I believe it’s a caching issue of some sort… When I get redirected back to Koha after a successful login with Shibboleth, I get a HTTP 500 error, with this console output, unsure if actually related or not: (index):6577 crbug/1173575, non-JS module files deprecated. (anonymous) @ (index):6577 Refreshing the page redirects once again with a successful login. Oauth has a similar issue. I am redirected back to Koha after a successful login with the identity provider and I am greeted with an error message: > There was an error authenticating to external identity provider: > wrong_csrf_token Refreshing doesn't fix it but clicking the IdP login link again redirects back with a successful login and token. My theory is the redirect is happening too quickly before the token is actually retrieved. I've looked in Shibboleth's logs and have yet to see anything obvious. Thanks in advance, Justin Dowswell -- *The Tenants’ Union of NSW recognises that Aboriginal and Torres Strait Islander peoples are the First Peoples of Australia. Our office is on the lands of the Gadigal of the Eora Nation. We are committed to respecting Aboriginal and Torres Strait Islander peoples, cultures, lands, and histories as we battle for tenants’ rights in NSW. Read our full Acknowledgement of Country <https://www.tenants.org.au/tu/acknowledgement-country>.* <https://www.tenants.org.au/> tenants.org.au <https://www.tenants.org.au/> <https://rentingfair.org.au> <https://www.facebook.com/TUNSW/> <https://twitter.com/TUNSW> <https://www.youtube.com/channel/UCEkW8D86OVVAV0QedKFhl9w> This email transmission is intended only for the addressee and may contain confidential or privileged information. Confidentiality and privilege are not waived if you are not the intended recipient of the email, nor may you use, review, disclose, disseminate or copy any information contained or attached to it. If you received this email in error please delete it and any attachments and notify us immediately by return email. Tenants' Union of NSW can only provide information and advice in the New South Wales and Commonwealth jurisdictions. If you are enquiring from another state or territory please contact your local community legal centre.

2 4

Koha Community Newsletter: June 2023
by Koha Newsletter 29 Jun '23

29 Jun '23

The Koha Community Newsletter for June 2023 is here: https://koha-community.org/koha-community-newsletter-june-2023/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

Re: [Koha] How to limit number of copies?
by George 29 Jun '23

29 Jun '23

Victor, I'd recommend opening a bug on Bugzilla saying that a system preference should be added to set the maximum number of copies that can be added to a bibliographic record when someone uses the "Add multiple copies of this item" button on additem.pl. In the meantime, if you put this jQuery in the intranetuserJS system preference, it will set the limit to 10 copies: //Home > Cataloging > Edit TITLE > items (cataloguing/additem.pl?biblionumber=n) //Limit the number of copies that can be added to a biblio using the "Add multiple copies of this item" button $('#cat_additem #number_of_copies').attr('type','number').attr('max','10'); And I'll add that jQuery to the jQuery library in just a few minutes. George On 6/27/2023 7:00 PM, koha-request(a)lists.katipo.co.nz wrote: > Message: 3 > Date: Tue, 27 Jun 2023 15:36:17 -0300 > From: Victor Barroso Oliveira<vbovictor(a)gmail.com> > To: Koha<koha(a)lists.katipo.co.nz> > Subject: [Koha] How to limit number of copies? > Message-ID: > <CACyxk604FQOuDbdUVN5pyVvkabRNxGhWZUyWsWvjrr2VppQEvQ(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hello, > In Koha it is possible to Add an instance or choose to "Add Multiple > Copies" simultaneously to a record. > So far so good. More..... I had a situation where an employee mistakenly > typed 800,000 copies for a record. > As a result, when Koha started its automatic Indexing routine, it consumed > all of the server's memory and crashed system access. When I tried to > delete the 800,000 copies in batch, the system crashed. It took slow > deletion from 5,000 to 5,000 to reach 800,000. > Considering the aforementioned case, would any colleague know if we can > limit the quantity in the option "Add Multiple Copies"? > Thanks, > Victor -- George Williams Pronouns: he/him Next Search Catalog Coordinator Send NEXT support e-mails to nexthelp(a)nekls.org NEKLS Office: 785-838-4090 Toll Free: 888-296-6963 Fax: 785-838-3989 Next After-Hours: 785-813-1356 For specific support issues, please use: Next Catalog Support: nexthelp(a)nekls.org Courier Support: chandwork(a)nekls.org Technology Support: tech(a)nekls.org 4317 W 6th St, Lawrence, KS, 66049

2 1

TRUNCATE borrowers
by Сычев Игорь Алексеевич 29 Jun '23

29 Jun '23

Hello! How to create a user after (TRUNCATE borrowers) delete all records and keep settings? https://wiki.koha-community.org/wiki/How_to_delete_all_records_and_keep_set… Koha 23.05 Good Luck! Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru

3 4

Koha 22.05.14 released
by Lucas Gass 28 Jun '23

28 Jun '23

Hello! The Koha community is proud to announce the release of Koha 22.05.14. It is a bugfix/maintenance release including 27 bugfixes. The full release notes are available here: https://koha-community.org/koha-22-05-14-released/ Debian packages should be available soon 🎁 -- Lucas Gass Web Developer

1 0