Time Nick Message 00:30 thomas63[m] Hi Koha team... (full message at <https://matrix.org/_matrix/media/v3/download/matrix.org/rJhkMGbchjvwWmTZUpGFKRUT>) 05:27 PriyanshuSoni[m] Hello everyone, 05:27 PriyanshuSoni[m] I am creating a welcome note template in koha and i also want to send browwers.userid and browwers.password. How can i do so? 05:27 wahanui i heard Hello everyone, was it ok to ask for some guidance here ? 05:35 Joubu thomas63[m]: did you send en email to the list? 05:36 Joubu wahanui: forget Hello everyone, 05:36 wahanui Joubu: I forgot hello everyone, 05:37 TriveniChandriki[m] Priyanshu Soni: I can help on this. Please give access 05:37 Joubu PriyanshuSoni[m]: You don't have access to the plain text password, it's useless to send the password field 05:37 Joubu No, don't give access 05:37 Joubu you can help here without getting access 05:39 TriveniChandriki[m] Sure 06:06 marcelr o/ 06:20 johnwaynechesterton[m] Hi friends! How does koha uniquely identy an author in the database? 07:18 * cait waves 07:18 aude_c[m] Hi johnwaynechesterton , are you using authorities? 07:18 cait it's QA Friday! (didn't you know?) 07:18 aude_c[m] (Hi @cait! All the best for QA Friday :D) 07:19 * cait waves at aude_c[m] :) 07:59 magnuse \o/ 07:59 aude_c[m] đ 08:40 johnwaynechesterton[m] <aude_c[m]> "Hi johnwaynechesterton , are you..." <- not using Koha atm. I am looking at the db schema for inspiration. I am working a very simple e-library for epubs from scratch for fun 08:46 aude_c[m] Ah ok. I mentioned using authorities because you would have an authid 08:46 aude_c[m] But not all libraries use authorities. In that case they'll tend to run reports on the biblio.author field 08:47 aude_c[m] It's not perfect, as you can imagine - it depends on the quality of their bibliographic records 08:50 johnwaynechesterton[m] Is this what you meant by biblio.author? https://gitlab.com/koha-community/Koha/-/blob/master/installer/data/mysql/kohastructure.sql#L1071 08:52 aude_c[m] Yes 08:52 aude_c[m] Though I find it easier to use the schema site https://schema.koha-community.org/22_11/tables/biblio.html 09:17 marcelr MatthewBlenkinsop[m]++ 09:18 anke_b[m] Hi, did anyone stumble upon the problem that in 23.05 subscriptions can't be created because of a HTTP 500 and the message "[WARN] DBIx::Class::ResultSetColumn::new(): Attempting to retrieve non-unique column 'biblionumber' on a resultset containing one-to-many joins will return duplicate results. at /usr/share/koha/lib/Koha/Objects.pm line 421"? I found a bug with this error message 09:18 anke_b[m] (https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34360) but don't really understand if this is the same problem. 09:18 huginn 04Bug 34360: enhancement, P5 - low, ---, koha-bugs, NEW , [WARN] DBIx::Class::ResultSetColumn::new(): Attempting to retrieve non-unique column 'biblionumber' on a resultset containing one-to-many joins will return duplicate results 09:20 paulderscheid[m] joubu around? 09:20 anke_b[m] Sorry, now again: We have the problem in 23.05 that subscriptions can't be created because of an HTTP 500 and a message "Control fields (generally, just tags below 010) do not have subfields, use data() at /usr/share/koha/lib/Koha/Object/Mixin/AdditionalFields.pm line 68." in the plack error log. 09:21 Joubu paulderscheid[m]: yes 09:22 paulderscheid[m] When do we want to start the discourse project? 09:22 Joubu after the release? 09:23 paulderscheid[m] Have there been some discussions since KohaCon? 09:23 paulderscheid[m] Alright 09:24 anke_b[m] anke_b[m]: We checked that we don't have any subfields in the control fields in the record. 09:24 anke_b[m] Should I file a bug? 09:26 Joubu anke_b[m]: it's coming from "additional fields" 09:26 Joubu have a look at Administration > Additional fields > Table 'subscription' 09:26 Joubu /cgi-bin/koha/admin/additional-fields.pl?tablename=subscription 09:27 Joubu do you have a MARC field that is a control field? (ie. without $ field/subfield separator) 09:28 anke_b[m] Joubu: We have a 001 in the place you mentioned which has MARC field mode "Get value from MARC record" and Searchable=Yes 09:30 Joubu You could try to remove it and see if it fixes the problem 09:31 Joubu not in production please, I don't know the side-effects 09:34 anke_b[m] Joubu: Thanks a lot! That helped. 09:35 anke_b[m] * @Joubu: Thanks 09:35 anke_b[m] We did try it in the test instance. How could we find out about possible side effects? 09:35 Joubu you should file a bug anyway :) 09:36 Joubu did you just create the additional field? 09:36 Joubu or just upgraded Koha? (in that case it would be a regression) 09:37 anke_b[m] @Joubu I am not sure when exactly the librarians created the additional field, but very probably that was some time ago. The moment from which the subscription didn't work was after the upgrade from 22.05 to 23.05. 09:37 huginn anke_b[m]: I've exhausted my database of quotes 09:38 Joubu please provide those info when you open the bug 09:40 anke_b[m] Joubu: Yes, we will. Thanks again! 09:51 Joubu marcelr: I am not switching the status to FQA when I am asking questions. I usually expect the author or other QA members to give their opinion 09:51 Joubu You are switching them to FQA without giving your opinion ;) 09:51 marcelr yes and some will only reply when they notice that the status changed; just watch 09:52 marcelr we have a large queue so we should be decisive 09:53 marcelr the switch to FQA btw means that i think the question is legitimate.. 09:54 Joubu otoh I agree with you, it is showing disrespect to not reply when a questui 09:55 Joubu otoh I agree with you, it is showing disrespect to not reply when a question is asked 09:55 Joubu and I mainly ignore those reports later... 09:57 marcelr yes but it gets stuck in the queue 09:57 marcelr other qa ignore it too.. 09:57 cait i think switching is good to get attention 09:57 Joubu close/won't fix: lack of feedback 09:57 Joubu :D 09:58 marcelr hmm 09:58 cait and the queue is too full, we need devs to do their part, but please no FQA without comments/questions :) 09:58 cait if it's a bug fix we might still want to have it 09:58 cait (closing wontfix is not ideal then) 09:58 marcelr no worries 09:58 Joubu was joking.. 09:58 cait yeah, you know all that... i just felt i should say something heh 09:58 Joubu trying at least 09:59 Joubu well, compare the ratio enhs/bugs 09:59 marcelr back to 124 now 09:59 cait I am hopefully joining you soon 09:59 cait just had some tstuff come up :( 09:59 marcelr 14 bugs 09:59 marcelr this is your day cait to get it down to 100 10:00 cait it would be nice, wouldn't it? 10:01 marcelr sure 10:02 Joubu I cannot help today. I am working on the move to weblate. 10:03 marcelr Joubu++ 10:03 marcelr htg 10:25 oleonard o/ 10:38 ES[m] Hi 10:38 wahanui kia ora, ES[m] 10:38 ES[m] Does somebody know if Cutter-Sanborn has also an UNIMARC version? 11:01 cait I really don't know 11:19 cait QA team ping? 11:30 ashimema Hello 11:32 cait :) 12:09 * cait waves at oleonard and kha 12:09 cait khall 12:10 * khall waves 12:10 cait :) 12:10 cait khall: I had a question for kidclamp - is he on vacation? 12:10 cait or just hiding from me :D 12:11 khall cait he's here, I'll ping him 12:11 cait so hiding... tsk 12:12 cait i was wondering if you and/or kidclamp could have a look at my patch attempt on bug 34686 12:12 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34686 enhancement, P5 - low, ---, koha-bugs, NEW , reserve_id should be linked in tmp_holdsqueue 12:16 cait is there an easy way to fake the data for bug 34853? 12:16 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34853 minor, P5 - low, ---, martin.renvoize, Signed Off , Move EDI link to new line in invoice column of acquisition details display 12:17 cait oleonard: or can you tell maybe if the effect is the desired one? haven't seen a clearfix in action:) 12:17 cait it's a template change only 12:20 oleonard cait: Just looking at the patch I would say you can use <div> instead of <span> and not need the class 12:21 cait true 12:21 cait but I am not sure i want to change it without actually being able to see 12:23 ashimema I have a feeling I copied the approach from somewhere 12:23 tcohen[m] hola #koha o/ 12:24 cait hola tcohen 12:25 * cait hands you a coffee and a cinnamon bun - 12:25 cait and now go push things. 12:25 * ashimema rebases bookings again and remind himself where on earth it's got to 12:26 cait is it signed off yet? 12:26 ashimema pass 12:26 ashimema no 12:27 * ashimema just checked 12:27 cait hm ther eis other big stuff in NQA still... 12:27 ashimema though it's now in production at one bywater site 12:27 ashimema and about to go into production here 12:27 cait that's good to know 12:27 cait maybe they could help with sign-off? 12:27 ashimema yes 12:27 ashimema I really need to focus on getting it in. 12:28 ashimema all the distractions of late have made it a lot later than hoped 12:28 ashimema and the original goals for it have swollen 12:28 cait follow-up bugs? 12:28 wahanui follow-up bugs are never filled 12:28 cait wahanui! 12:28 wahanui i am a political leader 12:28 ashimema issue is I need to break it down 12:28 cait lol 12:28 ashimema that's where I've got held up 12:28 ashimema it grew fast 12:28 ashimema and is all in one big branch at the moment 12:29 * oleonard votes for wahanui 12:29 ashimema I really aught to split it up to stand any chance of getting it in 12:29 ashimema it really doesn't help that it's not really testable in a sandbox âšī¸ 12:29 ashimema the datetime handling we have in Koha screws it 12:30 cait oleonard: do you want to know that the previous next icons on datatable in suggesitons are broken? 12:30 oleonard Yes :D 12:30 cait now i've sent kidclamp and khall into hiding 12:30 cait oleonard: ok, I am filing 12:31 cait oh i hope it's not me,... just running a yarn build to make usre 12:32 cait ook, it WAS me 12:36 * kidclamp waves 12:36 cait you are back! I missed you so much! ;) 12:37 kidclamp heh, thanks! Sometimes I forget to reopen the window after a restart 12:44 kidclamp khall: Why do we have both tmp_holdsqueue and hold_fill_targets? 12:44 khall that's a great question for srdjan 12:45 khall kidclamp we've talked about possibly merging those tables 12:45 kidclamp like you and I have? 12:45 khall that is correct 12:45 kidclamp :-D 12:45 kidclamp so there you go cait 12:45 kidclamp we all agree :-) 12:52 cait heh 12:52 cait thx :) 12:54 cait but can someone explain wha the table does? 12:54 cait and how sure are we it's 1:1? 12:55 kidclamp CreateQueue POD:Top level function that turns reserves into tmp_holdsqueue and hold_fill_targets. 12:56 cait yes, I ran into that one... but far from unerstanding it 12:57 kidclamp AddToHoldTargetMap puts the mapped items into hold_fill_targets / CreatePicklistFromItemMap puts them into the tmp_holdsqueue 12:57 cait it's confusing code 12:58 ashimema confusing code in koha... never 12:59 kidclamp I am guessing here - it looks like tmp_holdsqueue was the table used for circ/view_holdqueue 13:00 kidclamp it adds patron information etc - so I think the design was hold_fill_targets is for checking which on e should fill, and was a lighter table - and tmp_holdqueue was for display withmore info 13:00 kidclamp but as khall mentioned, ask srdjan 13:02 cait srdjan is not really around I think 13:02 kidclamp yeah, I meant that more like 'the answer is lost to the sands of time' 13:03 kidclamp or 'why try to understand something that by definition is beyond understanding' 13:03 kidclamp :-D 13:03 cait i hope not that it's beyond understanding 13:03 cait but it's a little scary I got to admit 13:04 kidclamp we can understand the code, but not the why 13:04 cait that doesn't necessarily make me feel better :) 13:10 MartinWitjens[m] Who knows how to adjust the order of fields for patrons? 13:10 cait PedroAmorim++ # creating the ILL setup script - one of the best ideas ever 13:10 cait MartinWitjens[m]: the order is not fully configurable 13:10 cait for addresses there is AddressFormat to do some changes 13:10 cait what are you trying to do? 13:11 MartinWitjens[m] I have found the unshow - option, but the order for e.g. adress does not make sense in The Netherlandas 13:11 cait yes, check the system prference AddressFormat 13:11 MartinWitjens[m] I need: adres, zipcode, city 13:11 MartinWitjens[m] in that order 13:11 cait yes, did you check the system preference yet? 13:12 cait French or German might work for you 13:12 MartinWitjens[m] did not check that, thanks!!! 13:12 cait both have zip city 13:12 MartinWitjens[m] I think this will solve it! 13:12 cait and it also takes care of the opac :) 13:12 cait and the detail tab... etc. 13:13 MartinWitjens[m] works like a charm!! 13:13 MartinWitjens[m] tx again 13:16 cait sure, check the other setting son the I18N tab in sys prefs too 13:16 cait might be other helpful things there :) 13:17 Joubu for those who don't read their emails - https://wiki.koha-community.org/wiki/Translation_server_migration_weblate 13:17 cait will hopefully read soon 13:20 cait kidclamp++ khall++ 13:22 cait tcohen++ 13:25 Joubu sudo systemctl unmask docker 13:25 Joubu oops 13:26 ashimema Joubu++ 13:27 cait true :) ashimema++ too 13:29 ashimema grr 13:29 ashimema why is it that every time I dig back into bookings I uncover new bugs.. 13:29 ashimema bugs I'm sure I've already fixed 13:29 ashimema grr 13:29 ashimema rebases suck 13:56 Joubu bug 34762 - is that a behaviour people would want? 13:56 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34762 enhancement, P5 - low, ---, matt.blenkinsop, Failed QA , Add a search based select component to ERM 13:56 Joubu you have to "type at least two characters" to see the content of the dropdown list!? 13:58 cait maybe to get suggestions? 13:58 Joubu suggestions? 13:59 cait like see a part of the entries that fit the entered characters 14:00 Joubu Do you mean "filtering"? 14:00 Joubu we can already filter a select2 14:14 PedroAmorim[m] I feel like typing at least 2 characters to show suggestions coming from an async request is fairly standard behavior is it not? Probably misunderstanding the thing here! 14:16 PedroAmorim[m] if you're searching for something in particular in a universe of hundreds of thousands records, you're likely not getting anything relevant before at least 2 characters, likely more than that 14:17 PedroAmorim[m] I think this is what was happening with bywater in ERM where they have 200k vendors 14:17 Joubu we need infinite scrolling and filtering 14:17 PedroAmorim[m] and you want to link a specific vendor to an agreement 14:17 Joubu if you have 200k vendors and type 2 characters, you will still get too many anyway 14:18 PedroAmorim[m] yes, but it's at least 2 characters, meaning the more you type, the better the results, but you get something as soon as 2 characters 14:18 Joubu 32474 is the way, but we need to fix the funky behaviours 14:23 Joubu kidclamp: 34188 - "1. Why Forced* instead of Force*?" 14:25 oleonard Good point Joubu, "Force" does sound more consistent with similar prefs 14:39 kidclamp We can make that change joubu 14:40 kidclamp I agree 14:43 cait oleonard: is it hard to only show columsn with datatables when there is data? 14:43 cait thinking about item holds and date due in the holdings table in opac 14:43 oleonard cait: I've never tried it. I don't know if there is a DataTables-specific way to do it 14:48 cait hm we have some tables with columns appearing/disappearing depending on prefs... maybe could have a look there 14:48 cait it would probably be not that different? setting a flag and using it like the pref 14:48 cait datatables config scares me a little 14:51 oleonard cait: Just wait til you try Bug 34913 ;) 14:51 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34913 is not accessible. 14:52 oleonard ...which is ready for testing unless folks would like me to break it up into smaller chunks 14:52 cait oh my 14:52 cait yeah I'll wait - i missed that one 14:53 cait do we have a list of plugins we need to check too? (compatibility or so?) 14:54 oleonard I don't know about that 14:55 cait was thinking lke the export... column configs and such 14:56 oleonard Oh right... "Test all the things" is all I can say! 14:56 cait sounds fun 14:56 cait but maybe next week's fun :) 14:57 cait have a great weekend all! 14:57 oleonard BUT I can write detailed and specific test plans if that is preferable. It's basically "check every DataTable and make sure it works like it used to" 14:57 cait hehe 14:57 cait submit as you think is best 14:57 cait i wonder if we need to keep it in security - easier to get the sign-offs otherweise 14:58 cait maybe we could ask a few people and add them tot he bugs manually 14:58 cait have to go! :) 15:09 MatthewBlenkinsop[m] <Joubu> "32474 is the way, but we need to..." <- I think I may have just found a way of getting rid of the scroll bump 15:09 MatthewBlenkinsop[m] Adding a patch now 17:32 oleonard CookieConsentBar html customization doesn't seem to be working 17:37 oleonard Oh no I must have left out the publication date 18:26 ashimema I do that all the time.. those blocks really shouldn't need a publish date 18:28 oleonard I think there are some that do, but I think we need more hints for the user that the content will be hidden without it 18:29 ashimema Ho, is there 18:29 ashimema I thought all were dated 18:31 oleonard I think there's a good case for being able to pre-fill a block for display later in the month for instance. I could plan ahead and set something for display 1 Oct through 31 Oct 18:38 ashimema I think it should be optional 18:39 ashimema Maybe a checkbox for display always 18:39 ashimema As supposed to require a date for all 18:40 oleonard Happy weekend all o/ 19:32 thomas63[m] Joubu: yes, I sent a mailt to the list 19:34 davidnind thomas63++ 19:35 davidnind thomas63: I don't recall seeing an email from the general Koha mailing list - was this recently? 19:37 davidnind also, greetings from Otago! 19:38 thomas63[m] yesterday, maybe it was a wrong mail address 19:38 thomas63[m] I used koha@lists.katipo.co.nz 19:41 davidnind that is the right address for the General Koha Mailing list, but you need to be a subscriber (which I assume is the case) (https://lists.katipo.co.nz/pipermail/koha/) 19:41 thomas63[m] I got an automated answer stating: "Is being held until the list moderator can review it for approval." 19:41 thomas63[m] no, I am not a subscriber 19:42 davidnind I'm not sure who moderates that list, but I'll assume it will come through when it has been moderated 19:43 thomas63[m] đī¸ 19:54 cait i missed what the email is about, bu tnot sure how regularly it's moderated 19:58 cait maybe safer to subscribe and resend 20:05 davidnind Was about a phone app for an offline scanner https://irc.koha-community.org/koha/2023-09-29#i_2511812 23:07 thomas63[m] subscribing to the mail list needs the same moderator to act đ 23:25 davidnind normally you get a message to confirm your subscription, then you can post to the mailing list without moderation - maybe the configuration has changed....