![https://matrix.org/_matrix/med[…]eport%20error.png](https://matrix.org/_matrix/media/v3/download/matrix.org/dRnpfNHbeqvVLtzjMcpewaRV/KOHA%20Report%20error.png){kind=link}
![https://matrix.org/_matrix/med[…]zDBlgUi/image.png](https://matrix.org/_matrix/media/v3/download/matrix.org/hNddmWnZBjfjMtcZFzDBlgUi/image.png){kind=link}
← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | 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 | I need some help regarding KOHA reports | |
| 08:01 | 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 | It was the name of report i got from KOHA wiki | |
| 08:06 | 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 | SELECT *... (full message at <https://matrix.org/_matrix/med[…]OrBrhuvSfWNimnNaI>) | |
| 08:09 | 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 | should i add just this code? | |
| 08:15 | 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 | @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 | 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 | Got to circulation > overdues and check the checkbox on top to also see the checkouts not overdue | |
| 09:10 | gives you a complete list of all checkouts and you can also filter it | |
| 09:10 | hm ok, we cannot filter on collection.. | |
| 09:11 | LibraryHU[m] | i have the checked out reports and checked in list |
| 09:12 | but i want the one with particular collection code | |
| 09:12 | 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 | one moment | |
| 09:13 | LibraryHU[m] | okay |
| 09:13 | 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 | 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 | from items where onloan IS NOT NULL and ccode = <<collection|CCODE>>; | |
| 09:15 | to enter this only | |
| 09:16 | 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 | hm you said you wanted to see what is checked out | |
| 09:18 | if you want to limit by a date we need to adjust | |
| 09:18 | select * = show all columns, every SQL report needs to start with a select | |
| 09:20 | LibraryHU[m] | how can i adjust ? |
| 09:21 | can you please make a complete sql code for me? | |
| 09:21 | showing the currently checked out report issued before 30th may | |
| 09:22 | cait | it would be something like: |
| 09:22 | select * from items where onloan < "2023-05-30" and ccode = <<collection|CCODE>>; | |
| 09:22 | 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.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 | 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 | thanks cait nugged Joubu for the help with the splinters of 8179 | |
| 10:53 | 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 | <.< | |
| 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 | 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 | bug 8179 | |
| 11:40 | huginn | 04Bug 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 | do we have a release party today ? | |
| 11:54 | oleonard | a release nap |
| 11:54 | tcohen | both? |
| 11:54 | :-D | |
| 11:54 | first party, then nap haha | |
| 11:57 | Official soundtrack for the release: https://open.spotify.com/track[…]=9cac7602bd104e86 | |
| 11:57 | (for nap time) | |
| 11:59 | marcelr: around? | |
| 12:21 | marcelr | yes but tcohen isnt |
| 12:31 | 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.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 | kidclamp++ | |
| 12:53 | 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 | :-D | |
| 13:06 | 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.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 | 'fixed' | |
| 13:08 | haha | |
| 13:09 | oleonard | Yup tcohen you did fix it! |
| 13:09 | Thanks! | |
| 13:09 | tcohen | ah, because of the bug title |
| 13:10 | I thought I introduced a hidden/broken char instead of removing the spae | |
| 13:10 | *space | |
| 13:18 | mariadb:lastest(10.10) 21.11.21 -> 23.05 ✔ | |
| 13:20 | mariadb:10.3 21.11.21 -> 23.05 ✔ | |
| 13:21 | cait | aah that explains, tcohen now fixes the bugs before Ifile them |
| 13:21 | ;) | |
| 13:21 | but I hope you didn't after string freeze! | |
| 13:21 | tcohen | I actually did after freeze, with Bernardo's blessing |
| 13:23 | 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 | well, I checked that too, but I wasn't sure if the comments about the files/lines had an impact in translation | |
| 13:24 | they don't he | |
| 13:25 | testing the mysql 8.0 upgrade... | |
| 13:27 | cait | makes sense :) |
| 13:27 | should we be crossing fingers orsomething? | |
| 13:27 | tcohen | not yet |
| 13:27 | I will push to a branch of my own for y'all to check | |
| 13:27 | before pushing the release | |
| 13:28 | mysql:8.0 21.11.21 -> 23.05 ✔ | |
| 13:28 | \o/ | |
| 13:36 | magnuse | \o/ |
| 13:37 | caroline joined #koha | |
| 13:49 | tcohen | is this right/idiomatic? 'GDPR_Policy for PrivacyPolicyConsent' |
| 13:49 | for a ## Renamed system preferences section | |
| 13:52 | marcelr | i liked GDPR_Policy but that's biased |
| 13:53 | you could enforce it | |
| 13:53 | when you now say Enforced to a Consent, it is a bit weird | |
| 13:53 | but it got pushed, so .. | |
| 13:56 | tcohen | you can file a bug |
| 13:56 | not the day for that conversation, though | |
| 13:56 | heh | |
| 13:59 | marcelr | no |
| 13:59 | i commented already | |
| 13:59 | 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 | 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.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 | After "reset_all_unimarc" | |
| 14:18 | "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 | :-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 | ^^^ 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 | the unimarc data we have in misc4dev | |
| 14:34 | 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 | 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 | Joubu++ | |
| 14:35 | Typhoon? | |
| 14:36 | marcelr | well, climate change is actual |
| 14:36 | tcohen | trendy |
| 14:36 | Can I have a bunch of eyes here? | |
| 14:36 | https://gitlab.com/thekesoluti[…]/commits/pre_2305 | |
| 14:36 | I'm checking translations right now | |
| 14:45 | Joubu | Where do we put the feedback? |
| 14:45 | in contrib.yaml you have +emlam: | |
| 14:46 | +1654085678 June 1 2022 Koha 21.11.19 released releases | |
| 14:46 | +1669110639 November 22 2022 Koha 21.11.14 released releases | |
| 14:46 | that's... weird... | |
| 14:47 | tcohen | would that be a timezone issue? |
| 14:48 | Joubu | in the release note: ub.lu.se |
| 14:48 | you are missing changes to mailmap I think | |
| 14:48 | +- Andrew Fuerste-Henry (1) | |
| 14:48 | +- Andrew Fuerste-Henry (41) | |
| 14:48 | tcohen | ok |
| 14:48 | Joubu | +- Amaury GAU (2) |
| 14:48 | +- Amaury Gau (1) | |
| 14:48 | +- emlam (3) | |
| 14:48 | +- Catrina (1) | |
| 14:48 | +- David (2) | |
| 14:48 | +- Anke (1) | |
| 14:48 | +- Thibault (3) | |
| 14:49 | +- 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 | ok then don't fix those | |
| 14:50 | they are things to catch before push actually, or fix at release time | |
| 14:50 | 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 | 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 | nope! | |
| 14:52 | marcelr | Netherlands is a difficult language :) |
| 14:52 | actually it is a country | |
| 14:52 | Joubu | it's a team work to prepare, not a last minute addition, imo |
| 14:55 | 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 | ok! | |
| 14:56 | tcohen | thanks for the reminder |
| 15:14 | gotta feed the kids and take them to school | |
| 15:14 | 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 | something I can do? | |
| 17:24 | 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 | can you find a commit by Amaury GAU | |
| 18:49 | Dyrcona joined #koha | |
| 19:23 | cait | oh i missed that question |
| 19:23 | i know him if that helps? :) | |
| 19:54 | !confetti | |
| 19:54 | confetti! | |
| 19:54 | orr | |
| 19:55 | 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 | 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 | ah | |
| 20:24 | 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 | like ERM module and course reserves can be deactivated | |
| 20:25 | 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 | what are you trying to do? | |
| 20:25 | and there is always a template for every page, yes | |
| 20:25 | 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 | then turn things off and don't give them permissions | |
| 20:26 | it will have the same effect | |
| 20:26 | 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 | hm or jQuery if that doesn't work, you can put CSS and jQuery in configuration | |
| 20:27 | so it won't hinder any updates | |
| 20:27 | 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 | 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 | and then you can adjust | |
| 20:35 | ah | |
| 21:05 | tcohen | congrats #koha, another great release |
| 21:08 | davidnind | tcohen++ |
| 21:18 | bag | tcohen++ |
| 21:21 | cait | tcohen++ |
| 21:21 | throws home-made confetti | |
| 21:21 | o/ '`'`"'`` | |
| 21:24 | Dyrcona joined #koha | |
| 23:22 | magnuse_ joined #koha | |
| 23:32 | magnuse__ joined #koha | |
| 23:50 | cait joined #koha |
← Previous day | Today | Next day → | Search | Index