IRC log for #koha, 2023-09-29

All times shown according to UTC.

Time S Nick Message
00:30 thomas63[m] Hi Koha team... (full message at <https://matrix.org/_matrix/med[…]chjvwWmTZUpGFKRUT>)
00:59 oleonard joined #koha
00:59 oleonard_ joined #koha
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 joined #koha
06:06 marcelr o/
06:17 johnwaynechesterton[m] joined #koha
06:20 johnwaynechesterton[m] Hi friends! How does koha uniquely identy an author in the database?
06:53 cait joined #koha
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-commun[…]ructure.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.[…]ables/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.or[…]bug.cgi?id=34360) but don't really understand if this is the same problem.
09:18 huginn Bug 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/Obje​ct/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-f​ields.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:16 khall joined #koha
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:05 khall joined #koha
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 Bug https://bugs.koha-community.or[…]_bug.cgi?id=34686 enhancement, P5 - low, ---, koha-bugs, NEW , reserve_id should be linked in tmp_holdsqueue
12:12 kellym joined #koha
12:16 cait is there an easy way to fake the data for bug 34853?
12:16 huginn Bug https://bugs.koha-community.or[…]_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:35 kidclamp joined #koha
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:37 khall joined #koha
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:09 MartinWitjens[m] joined #koha
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.or[…]migration_weblate
13:17 cait will hopefully read soon
13:20 cait kidclamp++ khall++
13:22 cait tcohen++
13:23 Dyrcona joined #koha
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:39 MartinWitjens[m] left #koha
13:41 emlam joined #koha
13:56 Joubu bug 34762 - is that a behaviour people would want?
13:56 huginn Bug https://bugs.koha-community.or[…]_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 Bug https://bugs.koha-community.or[…]_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:00 cait left #koha
15:00 bag joined #koha
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
17:56 khall joined #koha
17:59 fridolin joined #koha
18:12 caroline_catlady joined #koha
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:34 khall_ joined #koha
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/
18:53 khall joined #koha
18:54 khall__ joined #koha
18:56 khall___ joined #koha
19:03 cait joined #koha
19:07 khall joined #koha
19:22 caroline joined #koha
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[…]3-09-29#i_2511812
20:07 JBoyer joined #koha
21:43 fridolin joined #koha
22:43 alohabot joined #koha
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....

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary