June 2023 - Koha - lists.katipo.co.nz

Restore the default Marc Framework
by Victor Barroso Oliveira 04 Sep '24

04 Sep '24

Hello, how to restore the default Marc Framework to the original pattern? koha version 22.05.05 ubuntu 20 Thanks, Victor

4 5

Re: [Koha] How to copy patron permissions?
by BRANNON, CHRISTOPHER 22 Jan '24

22 Jan '24

Michael, I've had some jQuery in the Koha library for quite a while. You should take a look at https://wiki.koha-community.org/wiki/JQuery_Library#Add_clear_and_preset_pe… There are 3 versions of this for different versions of Koha, but this latest one includes a clear permissions button, a couple of preset permission buttons, and a copy permissions button. Please check it out. We also did a video tutorial on this enhancement in season one of The Terrific Every-Other-Thursday Training Videos. You can find that here: https://youtu.be/M6aQITCJY0U. ___________________________ Christopher Brannon IT Coordinator 702 E Front Ave Coeur d'Alene, ID 83814 (208)769-2315 Ext. 456 cbrannon(a)cdalibrary.org www.cdalibrary.org Keep tabs on us at: Date: Tue, 26 Apr 2022 10:39:58 +0200 From: Michael Kuhn <mik(a)adminkuhn.ch> To: Koha <koha(a)lists.katipo.co.nz> Subject: [Koha] How to copy patron permissions? Message-ID: <abc69231-a587-77d5-01d2-7f98e5b16174(a)adminkuhn.ch> Content-Type: text/plain; charset=UTF-8; format=flowed Hi Is it possible to copy the permissions of another patron when creating a new one? I always thought this would happen when copying/duplicating an existing patron. But when I actually tried it today the permissions were not there with the new patron and I had to set them manually. Best wishes: Michael Kuhn

4 3

record won't delete
by Lauren Denny 08 Jul '23

08 Jul '23

Hi everyone, I have a record that will not delete. When I try to delete the record or merge it with another record I get this message: An error has occurred!*Error 500*This message may have been caused by any of the following reasons: - You made use of an external link to an item that is no longer available - You followed an outdated link e.g. from a search engine or a bookmark - You tried to access a page that needs authentication - An internal link in the client is broken and the page does not exist What's next? - Use top menu bar to navigate to another part of Koha. - To report a broken link or any other issue, please contact the Koha administrator. Send email <library%40teamwork-global.net> Does anyone have an idea of what is happening? Lauren

4 9

regex to put space between the classification number and author letters
by Lauren Denny 06 Jul '23

06 Jul '23

Hi everyone, I have about 5000 records with no space between the classification number and author letters. Here are a few examples: 491.431SA 431PA 260RE I would like to add a space so that they become: 491.431 SA 431 PA 260 RE Is there a way to add the space in the call number using the Koha item batch modification? I feel like I could use regex to add a space after the numbers or before the letters but don't know enough about regex to know how. Could someone help? Or offer another way to edit them? Thanks, Lauren

2 1

Koha won't import items when importing MARC records
by Furst, Kevin 04 Jul '23

04 Jul '23

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.*

3 3

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