Time Nick Message 06:53 reiveune hello 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.org/wiki/SQL_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/media/v3/download/matrix.org/dRnpfNHbeqvVLtzjMcpewaRV/KOHA%20Report%20error.png > 08:09 LibraryHU[m] this was the error 08:09 LibraryHU[m] SELECT *... (full message at <https://matrix.org/_matrix/media/v3/download/matrix.org/afYaNyyOrBrhuvSfWNimnNaI>) 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.org/wiki/SQL_Reports_Circulation#Items_filtered_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 04Bug https://bugs.koha-community.org/bugzilla3/show_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: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: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 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8179 new feature, P5 - low, ---, agustinmoyano, Pushed to master , Receiving multiple order lines at once 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/1KTObLMW9mwk2iPjP3daHb?si=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 04Bug https://bugs.koha-community.org/bugzilla3/show_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? 13:00 cait kind of :) 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 04Bug https://bugs.koha-community.org/bugzilla3/show_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: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 04Bug https://bugs.koha-community.org/bugzilla3/show_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/thekesolutions/Koha/-/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 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 :) 18:24 tcohen hola cait 18:25 tcohen can you find a commit by Amaury GAU 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/media/v3/download/matrix.org/hNddmWnZBjfjMtcZFzDBlgUi/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/ '`'`"'``