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!