- Koha-devel - lists.koha-community.org

REST API and new defaults
by Zeno Tajoli 06 Oct '23

06 Oct '23

Hi to all, thinking about BZ 33036, the basic idea is to change a part of ../cataloguing/merge.pl to create a 'merge' verb inside Koha/REST/V1/Biblios.pm then use this new verb in a new version of ./cataloguing/merge.pl But if we use REST inside standard scripts, I think we need to change those defaults: a)RESTBasicAuth: from 'Not enabled' to 'Enabled' b)Plack as mandatory As I see also ERM needs those defaults So is it a direction to take? In .. ../cataloguing/merge.pl I insert a check on the environment. Cheers Zeno Tajoli

1 0

ILL ISO18626 implementation to Koha
by Olli-Antti Hypernova 04 Oct '23

04 Oct '23

Top of the evening Koha! I am working on ISO18626 with Koha and have been designing how to provide that feature for Koha. The RFC so far: https://wiki.koha-community.org/wiki/ISO18626_RFC If somebody is interested in joining our ISO18626 discussion this Friday the 6th, 15:00 UTC+0, please email me for the meet.jit.si-link. We will be discussing various issues regarding how to "make it happen". Best regards, Olli-Antti Kivilahti CTO Hypernova Oy

1 0

Add a Usage Statistics module to ERM
by Field, Jonathan 03 Oct '23

03 Oct '23

Hi all, I just wanted to bring your attention to Bug 34587 which is another enhancement to the ERM module to introduce Data Providers, COUNTER and SUSHI to Koha. There is no formal test plan to this (as it is a big feature) but you can watch my video at KohaCon 23 this year which shows how all of the features work (and the workflow). It's about 30 minutes long. We have provided a permanent sandbox here - http://staff-usagestats.sandboxes.ptfs-europe.co.uk/cgi-bin/koha/erm/eusage… which we will leave live and it would be great if anyone who has an interest in this topic/feature could do some testing and feedback any comments/issues on the bug. We'd love to add it to the next version as it is of interest to many libraries. Credentials will be required for testing, please check if your organisation has access to any valid SUSHI credentials in order to test. Other details can be found at the Project Counter registry - https://registry.projectcounter.org/ All credentials are redacted in the sandbox and will not be visible to other users. In the released version, credentials will be visible in the ERM module. I'm also happy to answer any specific questions about this feature directly if anyone has any. Many thanks Jonathan -- Jonathan Field Managing Director PTFS Europe [image: Phone icon] M: +44 7919 372002 | T: +44 1483 378728 ext. 1000 [image: Email icon] jonathan.field(a)ptfs-europe.com [image: Link icon] www.ptfs-europe.com [image: Click to open Twitter] <https://twitter.com/PTFSEurope> [image: Click to open YouTube] <https://www.youtube.com/@PTFSEurope> [image: Click to open PTFS Europe webpage] <https://www.ptfs-europe.com>

1 0

Koha Community Newsletter: September 2023
by Koha Newsletter 29 Sep '23

29 Sep '23

The Koha Community Newsletter for September 2023 is here: https://koha-community.org/koha-community-newsletter-september-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-devel] cannot display branchname and patron category description in card layout
by Michael Hafen 26 Sep '23

26 Sep '23

I have in the past also made many customizations to Koha, but I was working in 3.2 then. After trying to port forward my customizations when there was a Koha release, I decided I needed to learn code revision control to make it easier to manage my changes. The Koha Community Wiki has a nice page on using Git for tracking code changes and making patch files: https://wiki.koha-community.org/wiki/Version_Control_Using_Git There is also a Bug Reporting Guidelines page: https://wiki.koha-community.org/wiki/Bug_Reporting_Guidelines And a Coding Guidelines page: https://wiki.koha-community.org/wiki/Coding_Guidelines That should be of interest as you continue working on Koha. To use the Bugzilla you need to have an account first, so you'll have to make one if you haven't already. Then pick the Koha project. In components there is a 'label / patron card printing' component that I think this change would fall under. The rest of the options should be fine with the defaults, just need to enter a summary and a description. Once you have the enhancement bug, you can take the bug number, as explained in the wiki page, and use that in the patch title when adding the patch to the bug. We are expected to have a test plan, which in this case is as easy as: create patron card layout with <categorycode> in one of the text fields. run a batch with that layout and see the categorycode. apply patch run a batch with that layout and see that the category description now appears Let us know if you have any more questions. On Mon, Sep 25, 2023 at 11:52 PM Zahid Iqbal <zahidiqbal.isb(a)gmail.com> wrote: > Michael i really appreciate the suggestion and your time to communicate. > but thing is that i have not use koha bugzilla. > 2. how to create an enhancement request? > 3. how can i set my code revision tracking? > 4. the PATCH how to create patch (currently using Koha 22.11.07 version) > sorry i have no experience in creating patch > > i want to learn new technologies and tools. > can you guide me the steps 2 3 4 that i have no experience. > > Currently our library is using Koha 22.11.07 version. The older version > which was version 2.2.9 and recently (4 months ago) i > have transfer data(books,patrons,circulation) from Koha 2.2.9 to Koha > 22.11.07 > i have done customization, report generation, create new modules in PHP if > not present in koha according to library needs. > > thanks and regards, > > On Mon, Sep 25, 2023 at 9:51 PM Michael Hafen <michael.hafen(a)washk12.org> > wrote: > >> I'm glad you got that figured out. >> Be aware that you will have to make that change again if that file is >> ever updated in a Koha release. I would say it's not likely, but certainly >> it can happen. >> I suggest at this point either getting that into a patch and create an >> enhancement request on the Koha Bugzilla, or set up your own code revision >> tracking to make it easier to watch that file for changes. I've done both >> for the variety of changes I've made to the code, and I recommend trying >> the enhancement request for this change. >> >> >> On Sat, Sep 23, 2023 at 1:33 AM Zahid Iqbal <zahidiqbal.isb(a)gmail.com> >> wrote: >> >>> I have completed the patron category description and it is correctly >>> showing in pdf file from patron card creator. >>> anyone that needs help for patron category description is not showing in >>> pdf please do the following. >>> In *C4/Patroncards/Lib.pm *file. >>> >>> search for line "*$get_branch = 1 if grep{$_ eq 'branchcode'} @fields;*" >>> after, add following lines >>> >>> my $get_patroncategory = 0; >>> $get_patroncategory = 1 if grep{$_ eq 'categorycode'} @fields; >>> >>> search for line "*return $borrower_attributes;*" before this line, add >>> following lines >>> >>> if ($get_patroncategory) { >>> $query = "SELECT description FROM categories WHERE categorycode >>> = ?"; >>> $sth = C4::Context->dbh->prepare($query); >>> $sth->execute($borrower_attributes->{'categorycode'}); >>> if ($sth->err) { >>> warn sprintf('Database returned the following error: %s', >>> $sth->errstr); >>> return 1; >>> } >>> $borrower_attributes->{'categorycode'} = >>> $sth->fetchrow_hashref()->{'description'}; >>> } >>> >>> >>> Thanks for the help Michael, it really helps me. At least I do not have >>> to track this file. >>> >>> >>> >>> On Fri, Sep 22, 2023 at 10:31 AM Zahid Iqbal <zahidiqbal.isb(a)gmail.com> >>> wrote: >>> >>>> Thanks Michael that will be very helpful. I will look into the code >>>> and get back to you. For now i am working on picture uploading (restrict >>>> image not more than 4KB and not more then 150 Height Width dimension) so >>>> the database does not get heavy. >>>> >>>> On Thu, Sep 21, 2023 at 9:38 PM Michael Hafen < >>>> michael.hafen(a)washk12.org> wrote: >>>> >>>>> If you are looking at the code, look at C4/Patroncards/Lib.pm in the >>>>> get_borrower_attributes() function. That's where the branchcode to >>>>> branchname conversion is handled, I figure that would be the place to do a >>>>> categorycode to category description conversion. >>>>> >>>>> On Thu, Sep 21, 2023 at 12:17 AM Zahid Iqbal <zahidiqbal.isb(a)gmail.com> >>>>> wrote: >>>>> >>>>>> thanks for the response. >>>>>> i have checked the branchcode, it is displaying correctly in patron >>>>>> card as you told. 👍 >>>>>> but i cannot find any solution for categorycode. I will still look >>>>>> into code. Maybe I will find a solution for that. >>>>>> >>>>>> On Wed, Sep 20, 2023 at 9:08 PM Michael Hafen < >>>>>> michael.hafen(a)washk12.org> wrote: >>>>>> >>>>>>> I have a layout using "<sort2>" in the text box for field 2. Looks >>>>>>> like the code will change "<branchcode>" into the library name. No such >>>>>>> luck in current code for patron category though. >>>>>>> >>>>>>> On Tue, Sep 19, 2023 at 11:17 PM Zahid Iqbal < >>>>>>> zahidiqbal.isb(a)gmail.com> wrote: >>>>>>> >>>>>>>> Hi, In koha 22.11 can someone guide to print branchname and patron >>>>>>>> category description on pdf file for patron card creator >>>>>>>> >>>>>>>> 1. print branchname not branchcode >>>>>>>> 2. print patron-category-description not categorycode >>>>>>>> >>>>>>>> >>>>>>>> what are the values i have to type in text box for field1 and >>>>>>>> field2 in patron card layout for printing branchname and >>>>>>>> patron-category-description? >>>>>>>> >>>>>>>> i am stuck with this problem and cannot find any other solution >>>>>>>> Can anyone suggest that i have to change the code or is there any >>>>>>>> other way that it can be solved? >>>>>>>> I am not an expert in coding, any help will be appreciated. >>>>>>>> >>>>>>>> Best Regards >>>>>>>> -- >>>>>>>> *Zahid Iqbal* >>>>>>>> _______________________________________________ >>>>>>>> Koha-devel mailing list >>>>>>>> Koha-devel(a)lists.koha-community.org >>>>>>>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >>>>>>>> website : https://www.koha-community.org/ >>>>>>>> git : https://git.koha-community.org/ >>>>>>>> bugs : https://bugs.koha-community.org/ >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Michael Hafen >>>>>>> Washington County School District Technology Department >>>>>>> Systems Analyst >>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>>> *Zahid* >>>>>> >>>>> >>>>> >>>>> -- >>>>> Michael Hafen >>>>> Washington County School District Technology Department >>>>> Systems Analyst >>>>> >>>>> >>>> >>>> -- >>>> *Zahid* >>>> >>> >>> >>> -- >>> *Zahid Iqbal* >>> >>> >> >> -- >> Michael Hafen >> Washington County School District Technology Department >> Systems Analyst >> >> > > -- > *Zahid Iqbal* > -- Michael Hafen Washington County School District Technology Department Systems Analyst

1 0

Re: [Koha-devel] barcodes issue
by Michael Hafen 25 Sep '23

25 Sep '23

Most likely you don't have a barcode input filter since I think the default is to not have one. So that's fine. I'm curious where you put the barcode now that you report it is not in the 'p' subfield. The 'p' subfield is the standard place for barcodes in Koha, and circulation won't be able to find the barcode if it's put anywhere else, unless you change how the databases items.barcode field is mapped to the Marc subfields. On Mon, Sep 25, 2023 at 11:06 AM Nasr Alyas <nasralyashassan(a)gmail.com> wrote: > Hi Michael, thanks for your respond, I am using koha version 22.11.03 and > Mysql version 8.0.34. > and for this: Did you put the barcode in a field other than the item > record 'p' subfield? and answer is no. > and for this: Do you have a barcode input filter set? I don't anything > about it! > > في الاثنين، ٢٥ أيلول، ٢٠٢٣, ٧:٥٤ م Michael Hafen < > michael.hafen(a)washk12.org> كتب: > >> Which version of Koha are you using? Which version of MySQL / MariaDb? >> Did you put the barcode in a field other than the item record 'p' >> subfield? Do you have a barcode input filter set? >> >> On Mon, Sep 25, 2023 at 10:51 AM Nasr Alyas <nasralyashassan(a)gmail.com> >> wrote: >> >>> Hi, I have a problem with my Koha system I have some books in my system and I have assigned a barcode to each book in opac I have the barcode for each book but the issue is when I want to check out one of the books it gives me this barcode does not available in the database and when I go to the database there is no barcodes. >>> >>> So how can I fix this? >>> any help! >>> >>> _______________________________________________ >>> Koha-devel mailing list >>> Koha-devel(a)lists.koha-community.org >>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >>> website : https://www.koha-community.org/ >>> git : https://git.koha-community.org/ >>> bugs : https://bugs.koha-community.org/ >>> >> >> >> -- >> Michael Hafen >> Washington County School District Technology Department >> Systems Analyst >> >> -- Michael Hafen Washington County School District Technology Department Systems Analyst

1 0

barcodes issue
by Nasr Alyas 25 Sep '23

25 Sep '23

Hi, I have a problem with my Koha system I have some books in my system and I have assigned a barcode to each book in opac I have the barcode for each book but the issue is when I want to check out one of the books it gives me this barcode does not available in the database and when I go to the database there is no barcodes. So how can I fix this? any help!

2 1

Re: [Koha-devel] cannot display branchname and patron category description in card layout
by Michael Hafen 25 Sep '23

25 Sep '23

If you are looking at the code, look at C4/Patroncards/Lib.pm in the get_borrower_attributes() function. That's where the branchcode to branchname conversion is handled, I figure that would be the place to do a categorycode to category description conversion. On Thu, Sep 21, 2023 at 12:17 AM Zahid Iqbal <zahidiqbal.isb(a)gmail.com> wrote: > thanks for the response. > i have checked the branchcode, it is displaying correctly in patron card > as you told. 👍 > but i cannot find any solution for categorycode. I will still look into > code. Maybe I will find a solution for that. > > On Wed, Sep 20, 2023 at 9:08 PM Michael Hafen <michael.hafen(a)washk12.org> > wrote: > >> I have a layout using "<sort2>" in the text box for field 2. Looks like >> the code will change "<branchcode>" into the library name. No such luck in >> current code for patron category though. >> >> On Tue, Sep 19, 2023 at 11:17 PM Zahid Iqbal <zahidiqbal.isb(a)gmail.com> >> wrote: >> >>> Hi, In koha 22.11 can someone guide to print branchname and patron >>> category description on pdf file for patron card creator >>> >>> 1. print branchname not branchcode >>> 2. print patron-category-description not categorycode >>> >>> >>> what are the values i have to type in text box for field1 and field2 in >>> patron card layout for printing branchname and >>> patron-category-description? >>> >>> i am stuck with this problem and cannot find any other solution >>> Can anyone suggest that i have to change the code or is there any other >>> way that it can be solved? >>> I am not an expert in coding, any help will be appreciated. >>> >>> Best Regards >>> -- >>> *Zahid Iqbal* >>> _______________________________________________ >>> Koha-devel mailing list >>> Koha-devel(a)lists.koha-community.org >>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >>> website : https://www.koha-community.org/ >>> git : https://git.koha-community.org/ >>> bugs : https://bugs.koha-community.org/ >>> >> >> >> -- >> Michael Hafen >> Washington County School District Technology Department >> Systems Analyst >> >> > > -- > *Zahid* > -- Michael Hafen Washington County School District Technology Department Systems Analyst

3 4

Carrousel display issue on sandbox
by Shi Yao Wang 22 Sep '23

22 Sep '23

Hello, Our carrousel plugin display is broken on koha sandbox and it's due to the plugin's js/image files not being found (on webpage inspect console). Tested this on 2 sandboxes with the exact same errors. Any idea how this could be fixed on the sandboxes? Thanks, Shi Yao Wang

4 10

Re: [Koha-devel] ktd and persistent data
by januszop＠gmail.com 20 Sep '23

20 Sep '23

Hi Jonathan, Thank you very much for you kind reply and explanation. This is really comforting—at least I can be sure this was not because of my ignorance that it did not work. As to the merge request, if I understand it correctly, we would have to edit the .env file and put there the environment variable USE_EXISTING_DB by hand after creating the db (i.e. before the second run of kp)? Why not to put the environment variable in the docker-compose.persistent.yml file (by adding there a value for the key services//koha//environment//USE_EXISTING_DB) and then conditionally skip the creation of the database in populate_db.pl if 1) the variable is set AND 2) the database exists and is not empty (which could be tested as it is now, with prefs_count or $patrons_count, for instance)? In addition, in this case probably an alias should be created for ‘docker volume rm koha_db-data’ to easily delete the volume if necessary… Wouldn’t it be a possibility? Best greetings, Janusz From: Jonathan Druart <jonathan.druart(a)gmail.com> Sent: Monday, September 18, 2023 11:36 AM To: januszop(a)gmail.com Cc: koha-devel(a)lists.koha-community.org Subject: Re: [Koha-devel] ktd and persistent data Hi Janusz, It does not work. There is a merge request however: https://gitlab.com/koha-community/koha-testing-docker/-/merge_requests/410 Cheers, Jonathan Le sam. 16 sept. 2023 à 00:42, <januszop(a)gmail.com <mailto:januszop@gmail.com> > a écrit : Hi All, This is (probably) my first post on this list. I had the pleasure of meeting some of you recently in Helsinki (and before that in Dublin in 2019). I live in Krakow, Poland and take care of several Koha installations in medium-sized scientific and theological libraries. Much of my time is spent analyzing and correcting bibliographic data. However, if my libraries encounter any problems in Koha, I try to report them in Bugzilla and, if possible, provide patches as well (I sent the first official patch in 2011). Sometimes I don't have enough patience or time and I patch problems locally (forgive me, I feel guilty here)... The Helsinki meeting encouraged me to use ktd more intensively. Here, however, I run into a problem trying to use persistent data (kp command as described at https://gitlab.com/koha-community/koha-testing-docker/-/wikis/Koha-Testing-D ocker). Docker creates the koha_db-data volume as expected. However, after shutting down the test environment (with kd command), when trying to run it again (kp), the koha container does not start properly -- it ends with the message: Database is not empty! at /kohadevbox/misc4dev/populate_db.pl <http://populate_db.pl> line 103. Indeed, the populate_db.pl <http://populate_db.pl> script is executed unconditionally when starting this container. Question: what am I doing wrong or what did I not understand? What should be the scheme of working with persistent data? I would appreciate a hint. Greetings, Janusz _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha-community.org <mailto:Koha-devel@lists.koha-community.org> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/

2 1