Time Nick Message
06:13 marcelr o/
06:58 fridolin I opened Bug 33830
06:58 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33830 normal, P5 - low, ---, oleonard, NEW , Title and author not on same line anymore
06:58 fridolin maybe a unwanted side effect
08:17 Joubu oleonard: What's the expected style for the sticky toolbars? I am seeing: https://snipboard.io/VZBJYD.jpg (no border) and https://snipboard.io/mTjyb8.jpg (with border)
08:18 Joubu oleonard: nevermind, there is a specific box-shadow rule for .searchheader. So I guess having the 2 styles is expected here.
08:39 nikkom Hi
08:44 magnuse hi nikkom
08:54 nikkom You know there was a function named SearchSuggestions in version 21.11.04. We had changed that function and I added a new field in the query. Now we upgraded our library and I need to do the same thing in version 22.11.04. But in this version SearchSuggestions is removed. Instead of this function there is this lin "$suggestions= Koha::Suggestions->search_limited( $suggestion_only )" My question is how can I add new field in here
08:57 nikkom The field that I added to SQL in the SearchSuggestions function is: (select DISTINCT lib from authorised_values WHERE category = 'Bsort1' AND authorised_value = U1.sort1) facultysuggestedby,
09:01 nikkom I found search_limited sub in module Koha/Suggestions.pm. Bu there is no SQL statement how can I add a new field?
09:01 Joubu what are you doing with the result?
09:02 Joubu U1 is the suggester, so you could loop on the result of $suggestions, and access patron's sort1 with:
09:02 Joubu while ( my $s = $suggestions->next ) { say $s->suggester->sort1 }
09:03 Joubu you have the code, and then you will need to get the lib using the TT plugin for instance
09:05 nikkom I need to take authorised_value of related sort1
09:10 Joubu if you are in a template then use [% AuthorisedValues.GetByCode( 'Bsort1', suggestion.suggester.sort1 ) %]
09:11 nikkom I will try. Thanks
09:30 magnuse Joubu++
09:33 nikkom @Joubu - It is now working thank you very much ....
09:33 huginn nikkom: I'll give you the answer just as soon as RDA is ready
09:59 Joubu tcohen: about the selenium tests - that's always the same errors. 29565 - we could raise again the timeout value and see if it fixes the problem.
10:00 Joubu the other one is 32671 - I have no idea what's going on there
11:25 marcelr o/
11:38 tcohen hola #koha o/ holiday here but I'll be around for 4 hours or so
11:38 tcohen we have a failure on mysql 8.0, the ill_requests.t file
11:39 tcohen DB_IMAGE=mysql:8.0 ktd up -d
11:39 tcohen ktd --shell
11:39 tcohen prove t/db_dependent/api/v1/ill_requests.t
11:41 Joubu el dia del locro? :)
11:41 tcohen Joubu: si!
11:42 tcohen extrañas el locro? jaja
11:45 tcohen next meeting
11:45 marcelr hi tcohen
11:45 tcohen hi marcelr
11:45 tcohen Joubu: how do I run the meetings script?
11:45 tcohen (sorry :-/)
11:48 tcohen we need a meeting next wednesday
11:49 Joubu no me gusta tanto el locro, pero una vez por ano si! :)
11:50 Joubu perl koha-meeting.pl? :D
11:50 Joubu perl koha-meetings.pl --update --page Development_IRC_meeting_25_January_2023 --confirm
11:50 Joubu something like that
11:51 tcohen eah, sorry
11:51 davidnind This is what I used for a previous meeting: perl koha-meetings.pl --update --page Development_IRC_meeting_26_April_2023 --confirm
11:51 tcohen I was missing the --confirm
11:51 tcohen but I recalled (too) that I never had the calendar thing correctly
11:51 tcohen will try now
11:52 Joubu tcohen: pull!
11:52 Joubu we made some changes recently (last couple of months?)
11:53 tcohen yeah, I read them, related to the new wiki version
11:53 tcohen what sets the minutes on the previous one
11:53 tcohen ¡??
11:53 ZahidIqbal[m] hi everyone
11:53 oleonard Bug 33832
11:53 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33832 major, P5 - low, ---, koha-bugs, NEW , Can't change a patron's username without entering passwords
11:53 tcohen davidnind: it didn't work :-/
11:53 tcohen can someone help me with this?
11:54 pastebot "tcohen" at 127.0.0.1 pasted "✘-255 ~/git/koha-meetings [m" (10 lines) at https://paste.koha-community.org/13936
11:55 davidnind Does anyone know who looks after api.koha-community.org ? Links at the top for 22.11, 22.05 and Development work, but none of the other links for the different Koha versions work
11:55 tcohen davidnind: it's been ashimema and I lately
11:57 Joubu tcohen: you forgot the "next meeting" section at the last dev meeting...
11:57 Joubu so yes, the script cannot guess it
11:57 tcohen feck
11:57 ZahidIqbal[m] can some help me in authentication failure using api all system preferences rest api's enabled given full access to user then show failure api/v1/patrons/1 in browser
11:58 tcohen ZahidIqbal[m]: are you the one that wrote to the list?
11:58 ZahidIqbal[m] yes in koha list email
11:58 tcohen how are you interacting with the API and what is the expected result?
11:59 ZahidIqbal[m] i donot know where i am wrong
11:59 tcohen ok, but what are you trying to do
11:59 tcohen I'll give you an example, if I put ..../api/patrons/1 on a browser, pointing to a Koha domain
12:00 tcohen I get an authentication failure, because Koha expects, in the browser, a valid session to be active with the right permissions
12:00 ZahidIqbal[m] our cms team is connecting with koha api to get and then post patrons data automatically but they say that error occur authentication failure
12:01 tcohen what kind of authentication are they using against the API?
12:01 ZahidIqbal[m] i have given full rights to user how create api
12:01 tcohen ZahidIqbal[m]: I suggest
12:01 ZahidIqbal[m] i have enable all rest api on system preference using koha version 21.11
12:01 tcohen that you install the Postman tool in your machine
12:02 tcohen and verify the interaction with the API using the credentials you passed your cms team
12:03 tcohen you only need to enable RESTBasicAuth if the CMS is going to use Basic Auth
12:03 ZahidIqbal[m] on internet searching i found out that there is some token but cannot understand how to generate it
12:03 tcohen oh
12:03 tcohen in that case
12:03 tcohen stick to Basic Authentication
12:03 ZahidIqbal[m] i have generate client id secert code
12:03 tcohen but hey
12:03 tcohen you don't usually deal with tokens
12:03 ashimema I can try to revisit the older api docs davidnind, tcohen
12:03 tcohen you let a library do it for you
12:04 tcohen ashimema: I bet it is some change we've made to run different redocly versions
12:04 davidnind ashimema++ Thanks!
12:04 tcohen we talked about making the build explode if any of them failed
12:04 ashimema it's got something to do with the redocly versions
12:04 ashimema bloody annoying
12:04 ashimema yeah
12:04 Joubu ZahidIqbal[m]: curl -v -s -u USER:PASSWORD --request GET https://IP/api/v1/patrons --header "Content-Type: application/json"
12:04 ashimema indeed
12:04 Joubu that's the easiest to try if basic auth is working
12:04 ashimema too many things as usual
12:05 ZahidIqbal[m] that is code which they will run? Joubu
12:05 ZahidIqbal[m] ?
12:05 tcohen ZahidIqbal[m]: you need to check if Koha and the cerdentials you created are functional
12:05 tcohen that command will let you do that
12:05 tcohen once you figured Koha is ok
12:05 tcohen then the problem is how the CMS people are doing things
12:05 ZahidIqbal[m] tcohen: how to check
12:06 ZahidIqbal[m] how can i run?
12:06 tcohen on a terminal
12:06 tcohen command line
12:06 tcohen on linux
12:06 ZahidIqbal[m] is there any ubuntu package install for the command?
12:07 tcohen sudo apt install curl
12:07 tcohen but you have it most probably
12:07 tcohen ashimema, Joubu: I booked the flights to be in Finland :-D
12:07 Joubu \o/
12:08 magnuse \o/
12:08 ZahidIqbal[m] 👍️Joubu tcohen
12:12 Joubu Is Sam Lau around?
12:20 ZahidIqbal[m] i cannot past the output can anyone help me coping text from virtual machine cmd to desktop
12:23 ZahidIqbal[m] is this ok here is the output when running curl code TCP_NODELAY set... (full message at <https://matrix.org/_matrix/media/v3/download/matrix.org/QHBAanVlqSIkZNYlCVmiersa>)
12:25 ZahidIqbal[m] Joubu: is this ok
12:26 davidnind Zahid Iqbal: you can use https://paste.koha-community.org/
12:27 ZahidIqbal[m] thanks davidnind i shall try this
12:27 Joubu try http instead of https?
12:29 marcelr kidclamp: please check bug33404 again, added the test with so many mocks
12:29 tcohen PedroAmorim[m]: there's a random failure when running on MySQL 8
12:30 tcohen DB_IMAGE=mysql:8.0 ktd up -d
12:30 tcohen prove t/db_dependent/api/v1/ill_requests.t
12:31 tcohen ^^ PedroAmorim[m] please take a look
12:31 tcohen soma caching taking place?
12:34 marcelr tcohen: you will like the mocking in Breeding_Auth.t on bug 33404
12:34 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33404 normal, P5 - low, ---, m.de.rooy, Needs Signoff , Authorities imported from Z39.50 in encodings other than UTF-8 are corrupted
12:34 Joubu tcohen: it's a sort problem
12:34 Joubu if you are expecting a given order you need to request it
12:34 Joubu so that the query will have the ORDER BY clause
12:34 Joubu otherwise you cannot rely on it
12:39 tcohen Joubu: you're right!
12:40 tcohen marcelr: I generally like mocking, will take a look shortly
12:40 tcohen :-P
12:44 PedroAmorim[m] hey
12:44 PedroAmorim[m] do you still need me to take a look at illrequests.t?
12:46 PedroAmorim[m] Joubu: 33786, I did wonder if assigning a variable inside an if statement would be cause for discussion! =)
12:46 PedroAmorim[m] I'll rewrite it
12:47 Joubu PedroAmorim[m]: it's not assigning the problem, it's fine
12:47 Joubu but you need to declare it at some point
12:48 Joubu let your_var=something?
12:54 PedroAmorim[m] I can understand if it's a matter of preference but the code works, and that variable is only used inside the if anyway
12:55 Joubu "the code works"? :D
12:56 PedroAmorim[m] https://stackoverflow.com/questions/2576571/assign-variable-in-if-condition-statement-good-practice-or-not
12:56 PedroAmorim[m] I will rewrite the patch
12:58 Joubu I first thought the 2 occurrences where linked, but you actually just use a tmp var
12:58 Joubu were*
12:58 Joubu l.81 and 180
13:00 PedroAmorim[m] yes, one check for the kohaTable prefilter and another to set the table id
13:01 Joubu I would then just add 'let'
13:01 Joubu in front of the 2 occurrences
13:01 Joubu or make it more readable on 2 lines :D
13:01 PedroAmorim[m] this was just to DRY the code inside the get_prefilter_value function
13:02 PedroAmorim[m] because I'm also using it in 30719 (not yet pushed)
13:02 Zahid[m] <Joubu> "try http instead of https?" <- Joubu: it works
13:03 Zahid[m] thanks everyone for helping
13:20 tcohen Glad to hear, Zahid[m]
13:21 tcohen Zahid[m]: the conclusion, then, is that your setup works, and the other folks need to check what they are doing
13:21 tcohen and you proved Basic Auth works
13:21 tcohen and that's what they should be using
13:21 tcohen not related to OAuth at all
13:21 tcohen don't hide, dcook
14:23 oleonard What is the purpose of having the option to have strict_sql_modes on or off?
14:28 marcelr htg
16:43 oleonard caroline around?
16:44 caroline yes
16:54 oleonard caroline: I was just looking at Bug 33839
16:54 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33839 normal, P5 - low, ---, oleonard, NEW , Local cover images not showing in search results
16:54 oleonard When you tested did you also have Coce enabled?
16:55 caroline Doesnt look like it
16:55 caroline https://staff-caroline.sandbox.bywatersolutions.com/cgi-bin/koha/admin/preferences.pl
16:55 caroline oh, the image is there now https://staff-caroline.sandbox.bywatersolutions.com/cgi-bin/koha/catalogue/search.pl?q=shakespeare
16:55 caroline is it possible it takes a while to show up?
16:56 oleonard I don't know, but I was about to say I couldn't reproduce the problem :D
16:56 caroline Ok, I just added an image to the 2nd record https://staff-caroline.sandbox.bywatersolutions.com/cgi-bin/koha/catalogue/search.pl?q=shakespeare
16:57 caroline Seems like a "me" problem then!
16:58 oleonard I noticed a JS error in the console for Coce images so I was concerned it was related...
16:58 caroline I reverted the other path on my local installation and the image showed up instantly, but with the sandbox, it seems to require a hard refresh (ctrl+f5)
19:14 nikkom Hi joubu, I would like to ask another question about SearchSuggestion in v21.11.04. In this function we were taking related values like STATUS or date etc. from filtering form and after filtering them in this function. What about version 22.11.04? Where are we make those filterings? Because we want to add new filters there
19:14 nikkom Thats why I am asking
19:31 davidnind nikkom: Joubu is normally finished for the day by now, you may wish to do an "@later tell" to leave a message (for an example, see https://irc.koha-community.org/koha/2023-05-24#i_2488223)
19:37 x-patron Hi all - I'm trying to use the CircAutoPrintQuickSlip preference to be able to printing receipts quicker. The manual says that you can press enter or scan a blank barcode - but what is a blank barcode?
19:38 x-patron I generated a barcode with a bunch of spaces, but that didn't seem to work.
19:44 caroline x-patron, just press enter when you're in the box or click the button
19:44 caroline click in the barcode box; press enter
19:45 x-patron Yes, that works as intended. But I'm looking for a solution that doesn't require interaction with the keyboard
19:46 caroline Click on the "Check out" button next to the box without entering a barcode
19:51 x-patron Cool, that works too - is there anyway to do it with just the barcode scanner?
19:52 caroline Not as far as I know...
19:52 caroline It'd have to be empty, but then that doesn't print
19:58 x-patron That's what I'm encountering. Anytime I try to generate a blank barcode using an online service, it requires me to enter at least one character.
20:11 davidnind Maybe I'm misunderstanding this, but this indicates using a blank sheet of paper for a "blank barcode" https://koha-community.org/manual/23.05/en/html/circulation.html#printing-receipts - I don't have a scanner, but not sure if that works or not...
20:12 caroline I'm not sure, it has to do the "enter" part, which is usually the end character of the barcode
20:26 x-patron I tried to use a blank sheet of paper, but that didn't work
20:26 x-patron I did find a way to produce a barcode with just ENTER, though.
20:29 davidnind I was trying to find out how you could create a barcode with just an ENTER, hopefully that works. How did you create the barcode with just an ENTER?
20:30 x-patron I don't understand enough of the specifics regarding barcode design/coding, but barcodes are capable of communicating/encoding binary data. These are called escape sequences.
20:31 x-patron I used this free barcode generator and noticed an option for "Evaluate Escape Sequences": https://barcode.tec-it.com/en/Code128
20:33 x-patron They list the sequence for ENTER right in the example section of the 'Evaluate Escape Sequences' - it turns out it's simply \n
20:33 davidnind Thanks! I'd just found that one.
20:33 x-patron I generated the image, printed it out, and tested it. And it worked!
20:33 davidnind Excellent!
20:34 caroline we should add the image to the manual maybe? I wonder if that would be legal
20:35 x-patron For anyone else who may need it, here's a link with the code already generated - save the image, print it out [maybe put it on a Word/LibreOffice document with a simple instruction like 'Scan to Print Quick Slip'], and scan it at the end of a checkout transaction to test it: https://barcode.tec-it.com/en/Code128?data=%5Cn
20:37 x-patron @caroline - I would imagine that barcode escape sequences are universal enough that the images produced through that particular website aren't under copyright - but that's just my assumption.
20:37 huginn x-patron: I've exhausted my database of quotes
20:39 x-patron Considering that, I think it would be a great idea to include it in the manual. It's an unexplained aspect of the manual as it is currently written and it would help others who are looking to reduce the amount of clicks + keystrokes necessary to simply print checkout receipts
20:39 davidnind caroline: I'm not sure. I'll see if I can figure out how to generate a barcode with escape sequences using free and open source software and an openly licensed font... (in the past I've used Excel with an openly licensed/free barcode font, seeing if this is possible in LibreOffice Calc)
20:39 davidnind x-patron++
20:39 caroline of course! the manual is an eternal work in progress, that's why conversations like this (or the mailing list) are interesting
20:40 caroline davidnind, I tried with the barcode generator in Koha (Cataloging > Barcode image generator) and it insists on numeric values only :/
20:41 davidnind 8-(
20:43 x-patron Cool, I didn't know Koha had a barcode generator - makes sense.
20:49 x-patron I wonder if Koha's inability to accept non-numeric values has to do with it not having Code 128 as a barcode type.
20:59 x-patron It seems like in ASCII, ENTER is referred to as Carriage Return and it has its own code (I think ~013). I tried entering that in the Koha barcode generator using Code9 as the barcode type, but it still didn't work. So I'm not sure it's possible through Koha itself.
20:59 x-patron I already found a workable solution, though. Thank you all.
21:01 davidnind x-patron: I found this resource - different types of barcodes allow different characters, and as you say the Koha barcode generator doesn't have a Code 128 generator https://www.keyence.com/ss/products/auto_id/codereader/basic/barcode-types.jsp
23:36 dcook @later tell tcohen Your comment about hiding made me laugh hehe. I think I was asleep by then...
23:36 huginn dcook: The operation succeeded.