IRC log for #koha, 2023-05-31

All times shown according to UTC.

Time S Nick Message
00:05 khall joined #koha
05:15 dcook joined #koha
05:18 dcook__ joined #koha
05:31 cait joined #koha
06:44 cait joined #koha
06:47 cait1 joined #koha
06:51 cait2 joined #koha
06:51 cait3 joined #koha
06:53 reiveune joined #koha
06:53 reiveune hello
06:55 thibaud_g joined #koha
06:57 cait joined #koha
07:24 alex_ joined #koha
07:59 LibraryHU[m] Hello
07:59 LibraryHU[m] I need some help regarding KOHA reports
08:01 LibraryHU[m] I want to make a report of items checked out of a particular collection code. Can anyone help in creating it
08:02 Joubu Hi, did you have a look at the wiki page? https://wiki.koha-community.or[…]L_Reports_Library
08:03 LibraryHU[m] I got a report from this website but there is some error while creating the report
08:03 Joubu what did you try and which error did you get?
08:05 LibraryHU[m] Items filtered by branch, collection code and last checkout date
08:05 LibraryHU[m] It was the name of report i got from KOHA wiki
08:06 LibraryHU[m] i copied the sql code and paste on to my koha where i was creating a new report. however, it saved the report with collection code but when i open the report it gives me some error
08:08 Joubu which sql code did you try and which error did you get?
08:08 * LibraryHU[m] uploaded an image: (47KiB) < https://matrix.org/_matrix/med[…]eport%20error.png >
08:09 LibraryHU[m] this was the error
08:09 LibraryHU[m] SELECT *... (full message at <https://matrix.org/_matrix/med[…]OrBrhuvSfWNimnNaI>)
08:09 LibraryHU[m] i tried this code
08:10 Joubu replace utf8_unicode_ci with utf8mb4_unicode_ci
08:12 davidnind FYI - here is the link to the report in the SQL library https://wiki.koha-community.or[…]iltered_by_branch.2C_collection_code_and_last_checkout_date
08:14 LibraryHU[m] Joubu: Replace with the code?
08:14 LibraryHU[m] should i add just this code?
08:15 LibraryHU[m] davidnind: i tried this but after adding this i got the error
08:15 Joubu replace the 3 occurrences of "utf8_unicode_ci" with "utf8mb4_unicode_ci"
08:21 LibraryHU[m] can you please give me the exact sql code so that i could copy it and add in the report. TIA
08:27 Joubu I have adjusted the query on the wiki
08:39 Joubu @later tell tcohen did you already notice a big lag for jenkins jobs? I've pushed 20min ago and Koha_Master hasn't started yet
08:39 huginn Joubu: The operation succeeded.
08:40 Joubu @later tell tcohen the trigger is on gitlab, which hasn't been updated yet
08:40 huginn Joubu: The operation succeeded.
08:40 Joubu @later tell tcohen maybe we should switch back to github...
08:40 huginn Joubu: The operation succeeded.
09:03 LibraryHU[m] Thank you for your help i got the report after replacing the said code
09:07 LibraryHU[m] the mentioned list is showing the checked out books from start but i want to get a report of the books which are still checked out and not returned
09:09 cait you can use the circulation reports for this
09:09 cait Got to circulation > overdues and check the checkbox on top to also see the checkouts not overdue
09:10 cait gives you a complete list of all checkouts and you can also filter it
09:10 cait hm ok, we cannot filter on collection..
09:11 LibraryHU[m] i have the checked out reports and checked in list
09:12 LibraryHU[m] but i want the one with particular collection code
09:12 LibraryHU[m] how we can obtain the list of currently checked out books with a collection code
09:13 cait i believe the report in the wiki is more complicated than what you need
09:13 cait one moment
09:13 LibraryHU[m] okay
09:13 LibraryHU[m] i just want to get a report of items currently checked out with particular collection code
09:13 cait try this as a base: select * from items where onloan IS NOT NULL and ccode = <<collection|CCODE>>;
09:14 cait yes
09:14 LibraryHU[m] can you give me a full sql code?
09:14 cait that was a full sql
09:15 LibraryHU[m] okay should i just add this code?
09:15 LibraryHU[m] from items where onloan IS NOT NULL and ccode = <<collection|CCODE>>;
09:15 LibraryHU[m] to enter this only
09:16 LibraryHU[m] an we have a report which takes date as an input and shows the books due after that date
09:17 cait select * from items where onloan IS NOT NULL and ccode = <<collection|CCODE>>;
09:17 cait hm you said you wanted to see what is checked out
09:18 cait if you want to limit by a date we need to adjust
09:18 cait select * = show all columns, every SQL report needs to start with a select
09:20 LibraryHU[m] how can i adjust ?
09:21 LibraryHU[m] can you please make a complete sql code for me?
09:21 LibraryHU[m] showing the currently checked out report issued before 30th may
09:22 cait it would be something like:
09:22 cait select * from items where onloan < "2023-05-30" and ccode = <<collection|CCODE>>;
09:22 cait but I can#t help more right now
09:51 aude_c[m] Hi cait, thanks for flagging Bug 33790 (and sorry for the late reply; public holiday here on Monday and forgot to login here yesterday...) I'll take a look later (and very likely come back to you with questions!!)
09:51 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=33790 normal, P5 - low, ---, koha-bugs, Needs Signoff , Fix and add various links to the manual
10:02 cait aude_c[m]: thx for having a look :)
10:02 cait I just thought it might also be something to keep in mind when making changes
10:34 Joubu cait: how did you made the list? manually?
10:46 thibaud_glt joined #koha
10:50 tcohen hola #koha o/
10:52 tcohen thanks cait nugged Joubu for the help with the splinters of 8179
10:53 tcohen Joubu: yeah, I noticed but didn't have the time to focus on that, that's why I trigger manually if I'm anxious
11:27 alex_ joined #koha
11:30 tcohen computer decided to freeze this morning
11:31 tcohen <.<
11:39 cait Joubu: yes, i was trying to fix a bug asking for one broken help link and found a lot missing, but more by "this was added/moved recently" knowledge
11:40 cait testing them all seemed a bit much and not sure if you can automate, because they will go to start page if you don't have a working/exact link, no error
11:40 cait bug 8179
11:40 huginn Bug https://bugs.koha-community.or[…]w_bug.cgi?id=8179 new feature, P5 - low, ---, agustinmoyano, Pushed to master , Receiving multiple order lines at once
11:53 marcelr joined #koha
11:53 marcelr o/
11:53 marcelr do we have a release party today ?
11:54 oleonard a release nap
11:54 tcohen both?
11:54 tcohen :-D
11:54 tcohen first party, then nap haha
11:57 tcohen Official soundtrack for the release: https://open.spotify.com/track[…]=9cac7602bd104e86
11:57 tcohen (for nap time)
11:59 tcohen marcelr: around?
12:21 marcelr yes but tcohen isnt
12:31 marcelr de spanning stijgt
12:31 oleonard If I make a terminology change in a file like api/v1/swagger/definitions/identity_provider.yaml how do I test that change?
12:32 marcelr kidclamp: bug 33404
12:32 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=33404 major, P5 - low, ---, m.de.rooy, Needs Signoff , Authorities imported from Z39.50 in encodings other than UTF-8 are corrupted
12:32 marcelr could you confirm the latest changes
12:50 kidclamp SO
12:51 marcelr thx kidclamp
12:51 marcelr kidclamp++
12:53 marcelr tcohen++ # new release is almost there (no hurry but dont keep us waiting lol)
12:55 oleonard cait still around?
12:57 khall joined #koha
13:00 cait kind of :)
13:04 khall_ joined #koha
13:05 Dyrcona joined #koha
13:05 tcohen ok
13:06 tcohen :-D
13:06 tcohen closer
13:06 oleonard cait I just wondered if you could double-check Bug 33851, I can't see the problem in master
13:06 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=33851 trivial, P5 - low, ---, oleonard, NEW , Punctuation: Notes␠: %s
13:06 tcohen testing different mariadb versions upgrading from older version
13:06 oleonard Low priority obviously
13:06 tcohen oleonard: was that me? sounds familiar
13:07 oleonard tcohen: Are you logging in as cait to file bugs now?
13:07 tcohen No, I mean I fixed an extra space between 'Notes' and ':' recently :-P
13:08 tcohen 'fixed'
13:08 tcohen haha
13:09 oleonard Yup tcohen you did fix it!
13:09 oleonard Thanks!
13:09 tcohen ah, because of the bug title
13:10 tcohen I thought I introduced a hidden/broken char instead of removing the spae
13:10 tcohen *space
13:18 tcohen mariadb:lastest(10.10) 21.11.21 -> 23.05 ✔
13:20 tcohen mariadb:10.3 21.11.21 -> 23.05 ✔
13:21 cait aah that explains, tcohen now fixes the bugs before Ifile them
13:21 cait ;)
13:21 cait but I hope you didn't after string freeze!
13:21 tcohen I actually did after freeze, with Bernardo's blessing
13:23 tcohen mariadb:10.5 21.11.21 -> 23.05 ✔
13:23 cait we probably have Notes: somewhere translated already
13:24 tcohen what he said
13:24 tcohen well, I checked that too, but I wasn't sure if the comments about the files/lines had an impact in translation
13:24 tcohen they don't he
13:25 tcohen testing the mysql 8.0 upgrade...
13:27 cait makes sense :)
13:27 cait should we be crossing fingers orsomething?
13:27 tcohen not yet
13:27 tcohen I will push to a branch of my own for y'all to check
13:27 tcohen before pushing the release
13:28 tcohen mysql:8.0 21.11.21 -> 23.05 ✔
13:28 tcohen \o/
13:36 magnuse \o/
13:37 caroline joined #koha
13:49 tcohen is this right/idiomatic? 'GDPR_Policy for PrivacyPolicyConsent'
13:49 tcohen for a ## Renamed system preferences section
13:52 marcelr i liked GDPR_Policy but that's biased
13:53 marcelr you could enforce it
13:53 marcelr when you now say Enforced to a Consent, it is a bit weird
13:53 marcelr but it got pushed, so ..
13:56 tcohen you can file a bug
13:56 tcohen not the day for that conversation, though
13:56 tcohen heh
13:59 marcelr no
13:59 marcelr i commented already
13:59 marcelr on the bug
14:00 tcohen we should settle those on (dev?) meetings
14:03 cait hm i think a privacy consent is general enough
14:03 cait and you could translate it the way you like :)
14:08 Joubu tcohen: I was wondering... Shouldn't take profit of this special day and push bug 20271?
14:08 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=20271 enhancement, P1 - high, ---, koha-bugs, In Discussion , Merge deleted biblio, biblioitems, biblio_metadata, and items tables
14:08 Joubu it's in discussion, but that's almost PQA
14:14 kidclamp that's quite a statement ^ :-D
14:15 oleonard-away XD
14:17 tcohen Joubu: hahaha
14:18 oleonard Has anyone tried testing with UNIMARC data? I'm getting errors from searches as if the sample data is malformed
14:18 oleonard After "reset_all_unimarc"
14:18 oleonard "Unsupported UNIMARC character encoding [] for XML output for UNIMARC; 100$a -> Heylin, Clinton. at /usr/share/perl5/MARC/File/XML.pm line 570"
14:20 tcohen Joubu: we haven't picked a codename for 23.05, do you think 'Failure' would be cool enough?
14:20 tcohen :-P
14:23 davidnind oleanard: I've never had much luck with reset_all_unimarc (at least the last time I tried, which was a while ago now) - I tend to edit .env to change KOHA_MARC_FLAVOUR and then start up KTD)
14:24 oleonard davidnind: KOHA_MARC_FLAVOUR = "UNIMARC" or "unimarc" ? Do you remember?
14:24 davidnind oleonard: lowercase, so KOHA_MARC_FLAVOUR=unimarc
14:25 oleonard I thought I tried that, but I'll try again thanks!
14:29 davidnind oleonard: I'm not getting an error with a UNIMARC instance in the staff interface when searching, but I am getting this error when searching on the OPAC (any search term): Can't call method "itemtype" on an undefined value at /kohadevbox/koha/opac/opac-detail.pl line 709
14:33 davidnind ^^^ the error is when I click on the search results to view the OPAC detail page
14:33 Joubu because unimarc data are bad
14:33 marcelr Failure is a great name :)
14:33 Joubu that's not coming from ktd
14:34 Joubu the unimarc data we have in misc4dev
14:34 Joubu IIRC some French people told me they were about to submit a PR, or at least tell me what needed to be done
14:34 Joubu it was at the hackfest... next time will be at the next hackfest :D
14:34 marcelr tcohen: Disaster would be a nice alternative
14:35 Joubu keep going, Apocalypse
14:35 marcelr Joubu++
14:35 tcohen I like Apocalypse <.<
14:35 tcohen Joubu++
14:35 tcohen Typhoon?
14:36 marcelr well, climate change is actual
14:36 tcohen trendy
14:36 tcohen Can I have a bunch of eyes here?
14:36 tcohen https://gitlab.com/thekesoluti[…]/commits/pre_2305
14:36 tcohen I'm checking translations right now
14:45 Joubu Where do we put the feedback?
14:45 Joubu in contrib.yaml you have +emlam:
14:46 Joubu +1654085678     June  1 2022    Koha 21.11.19 released  releases
14:46 Joubu +1669110639     November 22 2022        Koha 21.11.14 released  releases
14:46 Joubu that's... weird...
14:47 tcohen would that be a timezone issue?
14:48 Joubu in the release note: ub.lu.se
14:48 Joubu you are missing changes to mailmap I think
14:48 Joubu +- Andrew  Fuerste-Henry (1)
14:48 Joubu +- Andrew Fuerste-Henry (41)
14:48 tcohen ok
14:48 Joubu +- Amaury GAU (2)
14:48 Joubu +- Amaury Gau (1)
14:48 Joubu +- emlam (3)
14:48 Joubu +- Catrina (1)
14:48 Joubu +- David (2)
14:48 Joubu +- Anke (1)
14:48 Joubu +- Thibault (3)
14:49 Joubu +- ml-inlibro (1)
14:49 tcohen I decided not to spend time fixing those, but I can :-D
14:49 Joubu The "Tech release notes" part is great!
14:50 Joubu ok then don't fix those
14:50 Joubu they are things to catch before push actually, or fix at release time
14:50 Joubu or can be fixed later, but the release notes will be "bad"
14:51 davidnind oleonard: I just tested, and got the same error message as you when using reset_all_unimarc after starting KTD when KOHA_MARC_FLAVOUR=marc21 (I don't get that error when starting KTD when KOHA_MARC_FLAVOUR=unimarc)
14:51 tcohen they can still be fixed
14:51 tcohen about the tech notes
14:51 Joubu "+- Nederlands-Nederland (Dutch-The Netherlands) (80.9%)" Why is that so complicated? :D
14:51 tcohen do you have something we shuold comment on?
14:51 Joubu lol
14:51 Joubu nope!
14:52 marcelr Netherlands is a difficult language :)
14:52 marcelr actually it is a country
14:52 Joubu it's a team work to prepare, not a last minute addition, imo
14:55 Joubu tcohen: did you pick the sec bug?
14:56 tcohen the one in 33702?
14:56 Joubu yes
14:56 tcohen yes, it is there
14:56 Joubu yes
14:56 Joubu ok!
14:56 tcohen thanks for the reminder
15:14 tcohen gotta feed the kids and take them to school
15:14 tcohen back to this in about 1.5 hours
15:39 reiveune bye
15:39 reiveune left #koha
17:10 tcohen back
17:24 cait oh i missed things
17:24 cait something I can do?
17:24 cait guess I am too late :)
17:47 bag joined #koha
18:10 cait left #koha
18:11 cait joined #koha
18:24 tcohen hola cait
18:25 tcohen can you find a commit by Amaury GAU
18:49 Dyrcona joined #koha
19:23 cait oh i missed that question
19:23 cait i know him if that helps? :)
19:54 cait !confetti
19:54 cait confetti!
19:54 cait orr
19:55 cait o/ '`'`"'``
20:21 ksorbo[m] Is there any way to customize the main staff menu. (Not the top menu navbar, I know how to do that). I am talking about the menu that appears here cgi-bin/koha/mainpage.pl
20:22 cait which menu?
20:22 cait do you mean the big module 'buttons'?
20:22 ksorbo[m] Yes. (When you click the Koha logo on the top left)
20:23 cait sorry, I don't understand
20:23 * ksorbo[m] uploaded an image: (29KiB) < https://matrix.org/_matrix/med[…]zDBlgUi/image.png >
20:23 cait the logo is a link back to he start page, not a menu
20:23 cait ah
20:24 cait you can put your own HTML below on that page, but visibility of the 'buttons' depends on permissions and for some on preferences
20:24 cait like ERM module and course reserves can be deactivated
20:25 cait but what do you want to do?
20:25 ksorbo[m] So, edit mainpage.pl? or is there a template for that page?
20:25 cait that's the worst idea
20:25 cait what are you trying to do?
20:25 cait and there is always a template for every page, yes
20:25 cait but in general there is better ways than to edit any files
20:25 ksorbo[m] I would like simplify the system for our staff, removing items that are never used
20:25 cait what are you trying to do?
20:25 cait then turn things off and don't give them permissions
20:26 cait it will have the same effect
20:26 cait if you don't give someone acq permissions, the links to acq won't show up anywhere
20:26 ksorbo[m] OK. Makes sense
20:26 cait or use CSS to hide if you really want to
20:27 cait hm or jQuery if that doesn't work, you can put CSS and jQuery in configuration
20:27 cait so it won't hinder any updates
20:27 cait but using the permission systems will also take care of other spots you would see the modules, so that's probably the most complete solution
20:27 ksorbo[m] I really would like to have more shortcuts on the top nav menu, but it is limited in the amount of space across the top. E.g., I now have a link on the top nav directly to user reports, and another to the Label maker from Bywater, etc.
20:29 cait you could add a pull down menu
20:30 ksorbo[m] Do you have sample code for that?
20:33 cait i'd look at how the other pull down looks like and buit after that
20:34 cait i have something sec
20:35 ksorbo[m] @cait - Thanks. I think you have solved my problem today!! Appreciate it
20:35 huginn ksorbo[m]: I suck
20:35 cait put this in the param: https://paste.koha-community.org/14778
20:35 cait and then you can adjust
20:35 cait ah
21:05 tcohen congrats #koha, another great release
21:08 davidnind tcohen++
21:18 bag tcohen++
21:21 cait tcohen++
21:21 cait throws home-made confetti
21:21 cait o/ '`'`"'``
21:24 Dyrcona joined #koha
23:22 magnuse_ joined #koha
23:32 magnuse__ joined #koha
23:50 cait joined #koha

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