Time Nick Message 23:44 aleisha :) 23:44 cait1 open_source_academy++ 23:44 cait1 i should sleep instead of trying ot keep up with 8 students much younger and more awake than me :) 23:16 marie-luce nice cat 23:08 cait1 aw 23:08 cait1 hi mtj :) 23:08 mtj hi marie-luce, cait1 😽ðŸ¨ðŸ¹ 23:06 cait1 wow, the students are fast :) 23:05 mtj hayley, did you sort your GPG error problem? ^ 23:05 marie-luce hi mtj 23:05 mtj hey #koha 22:44 cait yes 22:39 M_Adamyk Quick question: once a patron's account is changed, the only way to see what was changed is through the modification logs, correct? 22:35 * cait1 waves 22:25 huginn cait1: The operation succeeded. 22:25 cait1 @later tell fridolin can you please reconsider bug 15448 and dependency? 21:17 caroline_crazycatlady welcome! 21:16 wahanui niihau, amy_ 21:16 amy_ hello 21:16 wahanui hola, ava 21:16 ava hi 21:16 mazen hello ava 21:16 eden hi caroline! 21:15 Jimmy Hi! :D 21:15 mazen Hello caroline 21:15 mazen hi jimmy 21:15 caroline_crazycatlady heelo academy! 21:15 ella ello Mazen 21:15 mazen Hello ella 21:14 mazen Hi wahanui 21:14 wahanui bonjour, mazen 21:14 mazen hi 21:14 wahanui kia ora, eden 21:14 eden hello 21:13 aleisha academy students incoming! :) 21:13 eden hi 21:13 catherine hi 20:33 hayley <koha-devel@lists.koha-community.org>" imported so I don't know what's going on - maybe the move of repo changed something? 20:33 hayley hello, anyone around who knows debian packaging? I am trying to build a package the way I normally do but am getting the error W: GPG error: http://debian.koha-community.org/koha 20.11 InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3C9356BBA2E41F10 - but earlier up inn the command line I have gotten gpg: key 3C9356BBA2E41F10: public key "Koha Debian Package Signing Key 17:25 koha-jenkins Project Koha_20.11_U16 build #27: SUCCESS in 1 hr 2 min: https://jenkins.koha-community.org/job/Koha_20.11_U16/27/ 17:14 koha-jenkins Project Koha_20.11_D11 build #40: STILL UNSTABLE in 49 min: https://jenkins.koha-community.org/job/Koha_20.11_D11/40/ 16:53 koha-jenkins Project Koha_20.11_D9 build #34: SUCCESS in 46 min: https://jenkins.koha-community.org/job/Koha_20.11_D9/34/ 16:29 koha-jenkins Project Koha_20.11_D10 build #41: STILL UNSTABLE in 1 hr 6 min: https://jenkins.koha-community.org/job/Koha_20.11_D10/41/ 16:26 reiveune bye 16:24 koha-jenkins Project Koha_20.11_U18 build #22: FIXED in 1 hr 1 min: https://jenkins.koha-community.org/job/Koha_20.11_U18/22/ 16:24 wahanui Congratulations! 16:24 koha-jenkins Yippee, build fixed! 16:22 koha-jenkins Project Koha_20.11_U2010 build #25: SUCCESS in 59 min: https://jenkins.koha-community.org/job/Koha_20.11_U2010/25/ 16:07 koha-jenkins Project Koha_20.11_U20 build #25: FIXED in 44 min: https://jenkins.koha-community.org/job/Koha_20.11_U20/25/ 16:07 wahanui Congratulations! 16:07 koha-jenkins Yippee, build fixed! 15:53 Joubu cait: git remote set-url origin https://git.koha-community.org/Koha-community/Koha.git 15:52 Joubu https 15:43 cait tried git remote set-url origin git://git.koha-community.org/Koha-community/Koha.git but it doesn't look like it works yet 15:41 cait i think i found out 15:36 cait Joubu: can you remind me how i switch to the new repo? I didn't do that yet on my dev env it looks like and can't locate your email 15:06 severine_q no problem for that, it's just I couldn't see any difference on my opac, so I was wondering if my understanding for this patch was correcte :) 15:06 severine_q thanks cait ! 15:03 cait i think most of us are too unfamiliar with unimarc to work on the xslt for it 15:03 cait we should have made the bug titlte state the format 15:03 cait severine_q: true 14:58 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5927 enhancement, P5 - low, ---, nick, Pushed to master , Show series information in search results page 14:58 severine_q I've got a tiny (and probably stupid) question : bug 5927, I saw that only MARC21Utils have been modified, so it's not supposed to apply with Koha using Unimarc, right ? 14:43 dolf Champion 14:40 Joubu done 14:39 dolf Joubu: I'm not sure how to CC them. 14:39 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27463 normal, P5 - low, ---, koha-bugs, NEW , OAI-PMH date handling in ListBase.pm 14:39 dolf Done. See bug 27463 14:17 Joubu dolf: could be 18.06.00.018 or 19.12.00.080 14:13 cait i assume there was a change ont he table that causes this, but i am not sure which one it would be 14:11 dolf Was this an intentional or unintended part of one of the DB schema updates? 14:10 dolf matter how small you make the date increment (seconds is the smallest), you will at some point have to harvest all 38740 items at once! (That is, if you have include_items enabled). 14:10 dolf Just an aside, before I create that new bug report. I was puzzled about the fact that none of my items in my library have a timestamp older than 2020-07-13. In fact, 38740 items share the exact same timestamp of "2020-07-13 22:43:46". Then I realized, this is when I updated Koha from 19.11.05 to 20.05.01 . So the update changed all of the item dates. This is understandable, if items needed to be updated, but it's problematic for the OAI-PMH process, because no 13:54 cait ashimema: LibraryName is what is used for the beginning of the page title 13:54 cait also agree on the include items one 13:54 cait new bug sounds great, thx dolf 13:50 dolf Will do. 13:50 Joubu dolf: I would suggest you to open a new bug report and cc Julian (jajm), Ere and Frédéric (Demians) 13:48 dolf yes, I think so 13:48 Joubu dolf: do you mean we should only MAX of items.timestamp if "include items" is set? 13:41 dolf Also, I think the join is only necessary when the user has the "include items" option in their OAI-PMH config. 13:27 dolf Joubu: I'm not convinced that the performance of the join would be worse, because then you don't have to execute a separate query for each record, as is currently the case (as far as I can read the code). It might even be faster. 13:25 Joubu Looks like it is, Martin Luther King, Jr. Day - Third Monday in January 13:24 Joubu Is today bank holiday in the USA? 13:12 Joubu it may impact the response performance as we will have to add 2 joins 13:11 dolf I know lots of SQL but zero Perl. Would love to help implement, but ... it won't be easy and the code quality might suffer. 13:09 Joubu it's what we are doing we the "Last modified" value 13:09 Joubu in my understanding they should be the same 13:09 Joubu "Harvesters may use datestamps to harvest only those records that were created, deleted, or modified within a specified date range." 13:09 dolf cait: I can't see why they should differ :) (But I'm also trying to think of a test case where it would fail, and I don't have any proof of that yet) 13:08 Joubu https://www.openarchives.org/OAI/openarchivesprotocol.html#Datestamp 13:08 Joubu yes, thanks 13:07 dolf Joubu: Do you mean this? https://www.openarchives.org/OAI/openarchivesprotocol.html#ListRecords 13:00 Joubu where are documented the from and to parameter? 13:00 ashimema did I imagine a bug where we put the opac page title behind a syspref so it was easy to replace it? 12:57 cait they won't get harvested that way, which seems to have been the initial goal? 12:57 cait i mean displaying one and using the other doesn't make much sense 12:57 cait shoudl we not make themboth the same? 12:56 cait hmi wonder 12:54 dolf So I'm still trying to think this through, but I feel like this might explain why some records don't get harvested. Not sure yet. 12:50 dolf Ah, thanks for confirming. I was just staring at those lines... 12:49 Joubu 65 WHERE (timestamp >= ? AND timestamp <= ?) 12:49 Joubu 64 FROM $table 12:49 Joubu 63 SELECT biblionumber 12:49 Joubu 62 my $sql = " 12:49 Joubu 61 my $table = $deleted ? 'deletedbiblio_metadata' : 'biblio_metadata'; 12:49 Joubu line ~60 of the same file 12:49 Joubu the "from" and "to" retrieved from the URL are used on biblio_metadata (or deletedbiblio_metadata) 12:49 Joubu looks like it's only use for the "Last modified" display 12:46 dolf I saw that, yes. But is that max also used for matching the query, or only when calculating the "datestamp"? If the former, I'm still left with the question: Which date is used when matching the query? 12:44 Joubu it does a max of biblio_metadata, deleteditems and items 12:43 dolf Joubu: Not yet, but now I know where to look, thanks! 12:43 Joubu is that where you are? 12:43 Joubu dolf: Koha/OAI/Server/ListBase.pm line 111 12:36 dolf OK, will try to read the code myself. I'm just not very familiar with perl syntax. :) 12:29 cait sorry, have to pass on that one - it's int he code somewhere for sure... just too slow for me to find it right now 12:27 dolf OK, I read it. Still unclear about one thing: Is `SELECT MAX(timestamp)` used when querying the biblios to see if they match `&from=2017-01-19&until=2017-01-20`, or when displaying the data, or both? 12:25 dolf Hmm, I forgot about that issue (I submitted it). Let me read it again. 12:22 cait dolf: a lotof libraries also include items when the records are harvested for a discovery -and they want a change on the callnumber or so show up there as well. Alternatives are using API like DAIA, but in that case the item data is usually not searchable in the discovery 12:21 cait especially comment#2 12:20 huginn Bug 21517: major, P5 - low, ---, koha-bugs, NEW , OAI returns records outside of specified time range. 12:20 cait maybe the answer is in the commnts here: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21517 12:19 cait sorry, was at lunch break, reading back now 12:19 cait dolf: you can also include items in your export, the manual has the howto :) 12:16 dolf 20.11.00.000 12:15 dolf 20.11, Debian packages. 12:15 wahanui which version of Koha are you using? How did you install 12:15 Joubu which version of Koha? 12:14 dolf So I'm still stumped about where "Last Modified" comes from. 12:14 dolf And the same timestamp for `select timestamp from biblioitems where biblionumber=5;` 12:13 dolf I get the same timestamp for `select timestamp from biblio_metadata where biblionumber=5;`. 12:12 dolf So when I look at `select timestamp from biblio where biblionumber=5;`, I get `2017-01-19 13:54:38`. Then I navigate to `oai.pl?verb=ListRecords&metadataPrefix=marcxml&from=2017-01-19&until=2017-01-20` to see what I get. Indeed, that biblio is listed, but the "Last Modified" says "2020-07-13 20:43:46". So there are two different dates being used here. What's the difference? 12:11 Joubu I was looking at the wrong place 12:11 Joubu cait is correct, it's biblio_metadata.timestamp! 12:05 dolf Hmm, as far as I know, OAI-PMH is just supposed to work with records, not items? 11:44 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19725 major, P5 - low, ---, julian.maurice, CLOSED FIXED, OAI-PMH ListRecords and ListIdentifiers should use biblio_metadata.timestamp 11:44 cait bug 19725 claims it's bibio_metadata timestamp 11:43 cait Joubu: I remember a bug also taking the item timstamps into account, maybe depending on configuration? 11:30 dolf Thanks. For the record, this is the project I'm talking about: https://www.drupal.org/project/oai_pmh_harvester 11:26 Joubu yes, the code confirms that 11:25 Joubu dolf: I think it's biblio.timestamp 11:21 dolf Hi :) I'm trying to debug an issue with an OAI-PMH client that I wrote. Some records seem to not get harvested when running through all the dates using the OAI-PMH client. Can someone tell me which field(s) in the Koha database is/are used to determine the "Last Modified" on the /cgi-bin/koha/oai.pl?verb=ListRecords page? 11:00 Joubu ashimema: yes, I will see if oleonard agrees when he will be around 11:00 Joubu cait: no license for DT, license exist for plugin that has been removed, etc. 10:55 ashimema well.. as it's always been there then I would take your first option.. i.e. /lib/datatabls/ 10:43 cait because not all are listed or because we are listing false information? 10:43 cait hm? 10:38 Joubu cait: the about page is messy about datatables's licenses... :-/ 10:38 Joubu will wait for Owen's pov 10:38 Joubu I would not move it 10:37 Joubu it has always been there 10:37 ashimema perhaps 10:37 Joubu and then move lib/datatables to jquery/plugins? 10:37 ashimema but.. that's more typig. 10:36 ashimema koha-tmpl/intranet-tmple/lib/jquery/plugins/datatables/ 10:36 ashimema so... perhaps 10:36 ashimema well.. datatables itself is a jquery plugin isn't it.. 10:36 ashimema hum.. 10:35 Joubu IMO they should be in lib/datatables, but they are in jquery/plugins 10:35 Joubu DT plugins should be in koha-tmpl/intranet-tmpl/lib/datatables or koha-tmpl/intranet-tmpl/lib/jquery/plugins? 10:32 cait lol 10:31 ashimema pun intended :P 10:31 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27454 trivial, P5 - low, ---, martin.renvoize, Needs Signoff , Additional patron attributes change sequence on every reload of edit page 10:31 ashimema bug 27454 sorted cait 10:19 cait aleisha++ 10:18 magnuse wow, aleisha++ 09:33 cait very reasonable i'd say 09:33 ashimema nice, that's a great page.. 09:33 davidnind have been a bit slack lately, trying not to do any on aleisha's list until after the academy... 09:32 cait davidnind: thx for the sign-off btw :) 09:32 cait really excited about this 09:30 ashimema cool 09:30 cait and that with python :) 09:30 davidnind aleisha has pre-selected quite a few and rated, plus 8 students working on Koha! https://wiki.koha-community.org/wiki/Catalyst_Academy 09:30 cait y 09:30 cait remember a lot will have got their first glimpse at programming like yesterda 09:30 ashimema fair enough 09:29 cait just not sure they will ge tthat far 09:27 ashimema that.. or just calling SendAlert 09:26 ashimema I thought there were plenty of examples to follow of adding a notice 09:26 ashimema humm.. really.. 09:22 cait i think sending notices might be alittle hard already, but we will see .) 09:15 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25213 enhancement, P5 - low, ---, koha-bugs, NEW , Notify reporter when an OPAC problem is resolved 09:15 * ashimema likes the idea of bug 25213 09:14 ashimema and I imagine some of the 'Problem reports' ones might get some love as it was an academy feature of Aliesha's in the first place.. she might like to hold someone's hand in enhancing that area. 09:14 ashimema so those are nice easy ones to get people started 09:13 ashimema well.. there's lots of little ACC2 one's :) 09:12 cait a lot is manual, it hink having a bit more in koha might have been nice 09:12 cait we'll see :) 09:05 ashimema we marked up a fair few.. that should keep them busy :) 09:05 ashimema wow.. 113 Academy bugs 09:02 cait thx! 08:57 ashimema I restarted apache 08:56 ashimema hum 08:51 cait ashimema: Joubu: translate is acting up again 08:49 cait2 t 08:49 * cait2 tries to deduplicate 08:46 cait2 good morning severine_q :) 08:45 severine_q Good morning cait !! 08:33 cait good morning #koha :) 08:09 severine_q good morning #koha :) 07:58 alex_a Bonjour 07:32 magnuse \o/ 07:20 reiveune hello 07:19 jsicot Hi #koha 00:18 koha-jenkins Project Koha_19.11_U20 build #186: FIXED in 47 min: https://jenkins.koha-community.org/job/Koha_19.11_U20/186/ 00:18 wahanui Congratulations! 00:18 koha-jenkins Yippee, build fixed! 00:06 koha-jenkins Project Koha_19.11_D10 build #122: FIXED in 35 min: https://jenkins.koha-community.org/job/Koha_19.11_D10/122/ 00:06 wahanui Congratulations! 00:06 koha-jenkins Yippee, build fixed!