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 |