Time |
S |
Nick |
Message |
00:06 |
|
koha-jenkins |
Yippee, build fixed! |
00:06 |
|
wahanui |
Congratulations! |
00:06 |
|
koha-jenkins |
Project Koha_19.11_D10 build #122: FIXED in 35 min: https://jenkins.koha-community[…]ha_19.11_D10/122/ |
00:18 |
|
koha-jenkins |
Yippee, build fixed! |
00:18 |
|
wahanui |
Congratulations! |
00:18 |
|
koha-jenkins |
Project Koha_19.11_U20 build #186: FIXED in 47 min: https://jenkins.koha-community[…]ha_19.11_U20/186/ |
00:21 |
|
|
inlibro joined #koha |
01:07 |
|
|
magnuse joined #koha |
01:21 |
|
|
inlibro joined #koha |
01:23 |
|
|
AndrewFH joined #koha |
02:04 |
|
|
morrism joined #koha |
02:18 |
|
|
morrism joined #koha |
02:21 |
|
|
inlibro joined #koha |
03:22 |
|
|
inlibro joined #koha |
03:23 |
|
|
AndrewFH joined #koha |
03:58 |
|
|
AndrewFH joined #koha |
04:22 |
|
|
inlibro joined #koha |
05:22 |
|
|
morrism joined #koha |
05:22 |
|
|
inlibro joined #koha |
05:22 |
|
|
morrism joined #koha |
05:58 |
|
|
did joined #koha |
06:07 |
|
|
dcook joined #koha |
06:13 |
|
|
chriss joined #koha |
06:22 |
|
|
inlibro joined #koha |
06:56 |
|
|
jsicot joined #koha |
07:16 |
|
|
jsicot joined #koha |
07:19 |
|
jsicot |
Hi #koha |
07:20 |
|
|
reiveune joined #koha |
07:20 |
|
reiveune |
hello |
07:22 |
|
|
inlibro joined #koha |
07:24 |
|
|
sophie_m joined #koha |
07:32 |
|
magnuse |
\o/ |
07:33 |
|
|
morrism joined #koha |
07:48 |
|
|
fridolin joined #koha |
07:58 |
|
|
alex_a joined #koha |
07:58 |
|
alex_a |
Bonjour |
08:09 |
|
|
severine_q joined #koha |
08:09 |
|
severine_q |
good morning #koha :) |
08:20 |
|
|
cait joined #koha |
08:22 |
|
|
inlibro joined #koha |
08:33 |
|
cait |
good morning #koha :) |
08:45 |
|
|
cait1 joined #koha |
08:45 |
|
severine_q |
Good morning cait !! |
08:46 |
|
|
cait2 joined #koha |
08:46 |
|
cait2 |
good morning severine_q :) |
08:49 |
|
* cait2 |
tries to deduplicate |
08:49 |
|
cait2 |
t |
08:51 |
|
cait |
ashimema: Joubu: translate is acting up again |
08:56 |
|
ashimema |
hum |
08:57 |
|
ashimema |
I restarted apache |
09:02 |
|
cait |
thx! |
09:05 |
|
ashimema |
wow.. 113 Academy bugs |
09:05 |
|
ashimema |
we marked up a fair few.. that should keep them busy :) |
09:12 |
|
cait |
we'll see :) |
09:12 |
|
cait |
a lot is manual, it hink having a bit more in koha might have been nice |
09:13 |
|
ashimema |
well.. there's lots of little ACC2 one's :) |
09:14 |
|
ashimema |
so those are nice easy ones to get people started |
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:15 |
|
* ashimema |
likes the idea of bug 25213 |
09:15 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=25213 enhancement, P5 - low, ---, koha-bugs, NEW , Notify reporter when an OPAC problem is resolved |
09:16 |
|
|
lds joined #koha |
09:20 |
|
|
morrism joined #koha |
09:22 |
|
cait |
i think sending notices might be alittle hard already, but we will see .) |
09:23 |
|
|
inlibro joined #koha |
09:26 |
|
ashimema |
humm.. really.. |
09:26 |
|
ashimema |
I thought there were plenty of examples to follow of adding a notice |
09:27 |
|
ashimema |
that.. or just calling SendAlert |
09:29 |
|
cait |
just not sure they will ge tthat far |
09:30 |
|
ashimema |
fair enough |
09:30 |
|
cait |
remember a lot will have got their first glimpse at programming like yesterda |
09:30 |
|
cait |
y |
09:30 |
|
davidnind |
aleisha has pre-selected quite a few and rated, plus 8 students working on Koha! https://wiki.koha-community.or[…]/Catalyst_Academy |
09:30 |
|
cait |
and that with python :) |
09:30 |
|
ashimema |
cool |
09:32 |
|
cait |
really excited about this |
09:32 |
|
cait |
davidnind: thx for the sign-off btw :) |
09:33 |
|
davidnind |
have been a bit slack lately, trying not to do any on aleisha's list until after the academy... |
09:33 |
|
ashimema |
nice, that's a great page.. |
09:33 |
|
cait |
very reasonable i'd say |
10:14 |
|
|
paul_p joined #koha |
10:18 |
|
magnuse |
wow, aleisha++ |
10:19 |
|
cait |
aleisha++ |
10:22 |
|
|
severine_q joined #koha |
10:23 |
|
|
inlibro joined #koha |
10:31 |
|
ashimema |
bug 27454 sorted cait |
10:31 |
|
huginn |
Bug http://bugs.koha-community.org[…]_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 |
pun intended :P |
10:32 |
|
cait |
lol |
10:35 |
|
Joubu |
DT plugins should be in koha-tmpl/intranet-tmpl/lib/datatables or koha-tmpl/intranet-tmpl/lib/jquery/plugins? |
10:35 |
|
Joubu |
IMO they should be in lib/datatables, but they are in jquery/plugins |
10:36 |
|
ashimema |
hum.. |
10:36 |
|
ashimema |
well.. datatables itself is a jquery plugin isn't it.. |
10:36 |
|
ashimema |
so... perhaps |
10:36 |
|
ashimema |
koha-tmpl/intranet-tmple/lib/jquery/plugins/datatables/ |
10:37 |
|
ashimema |
but.. that's more typig. |
10:37 |
|
Joubu |
and then move lib/datatables to jquery/plugins? |
10:37 |
|
ashimema |
perhaps |
10:37 |
|
Joubu |
it has always been there |
10:38 |
|
Joubu |
I would not move it |
10:38 |
|
Joubu |
will wait for Owen's pov |
10:38 |
|
Joubu |
cait: the about page is messy about datatables's licenses... :-/ |
10:43 |
|
cait |
hm? |
10:43 |
|
cait |
because not all are listed or because we are listing false information? |
10:55 |
|
ashimema |
well.. as it's always been there then I would take your first option.. i.e. /lib/datatabls/ |
11:00 |
|
Joubu |
cait: no license for DT, license exist for plugin that has been removed, etc. |
11:00 |
|
Joubu |
ashimema: yes, I will see if oleonard agrees when he will be around |
11:17 |
|
|
dolf joined #koha |
11:20 |
|
|
Oak joined #koha |
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:23 |
|
|
morrism joined #koha |
11:23 |
|
|
inlibro joined #koha |
11:25 |
|
Joubu |
dolf: I think it's biblio.timestamp |
11:26 |
|
Joubu |
yes, the code confirms that |
11:30 |
|
dolf |
Thanks. For the record, this is the project I'm talking about: https://www.drupal.org/project/oai_pmh_harvester |
11:37 |
|
|
davidnind left #koha |
11:43 |
|
cait |
Joubu: I remember a bug also taking the item timstamps into account, maybe depending on configuration? |
11:44 |
|
cait |
bug 19725 claims it's bibio_metadata timestamp |
11:44 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=19725 major, P5 - low, ---, julian.maurice, CLOSED FIXED, OAI-PMH ListRecords and ListIdentifiers should use biblio_metadata.timestamp |
12:05 |
|
dolf |
Hmm, as far as I know, OAI-PMH is just supposed to work with records, not items? |
12:11 |
|
Joubu |
cait is correct, it's biblio_metadata.timestamp! |
12:11 |
|
Joubu |
I was looking at the wrong place |
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:13 |
|
dolf |
I get the same timestamp for `select timestamp from biblio_metadata where biblionumber=5;`. |
12:14 |
|
dolf |
And the same timestamp for `select timestamp from biblioitems where biblionumber=5;` |
12:14 |
|
dolf |
So I'm still stumped about where "Last Modified" comes from. |
12:15 |
|
Joubu |
which version of Koha? |
12:15 |
|
wahanui |
which version of Koha are you using? How did you install |
12:15 |
|
dolf |
20.11, Debian packages. |
12:16 |
|
dolf |
20.11.00.000 |
12:19 |
|
cait |
dolf: you can also include items in your export, the manual has the howto :) |
12:19 |
|
cait |
sorry, was at lunch break, reading back now |
12:20 |
|
cait |
maybe the answer is in the commnts here: https://bugs.koha-community.or[…]_bug.cgi?id=21517 |
12:20 |
|
huginn |
Bug 21517: major, P5 - low, ---, koha-bugs, NEW , OAI returns records outside of specified time range. |
12:21 |
|
cait |
especially comment#2 |
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:23 |
|
|
inlibro joined #koha |
12:25 |
|
dolf |
Hmm, I forgot about that issue (I submitted it). Let me read it again. |
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: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:32 |
|
|
fridolin joined #koha |
12:32 |
|
|
morrism joined #koha |
12:36 |
|
dolf |
OK, will try to read the code myself. I'm just not very familiar with perl syntax. :) |
12:43 |
|
Joubu |
dolf: Koha/OAI/Server/ListBase.pm line 111 |
12:43 |
|
Joubu |
is that where you are? |
12:43 |
|
dolf |
Joubu: Not yet, but now I know where to look, thanks! |
12:44 |
|
Joubu |
it does a max of biblio_metadata, deleteditems and items |
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:49 |
|
Joubu |
looks like it's only use for the "Last modified" display |
12:49 |
|
Joubu |
the "from" and "to" retrieved from the URL are used on biblio_metadata (or deletedbiblio_metadata) |
12:49 |
|
Joubu |
line ~60 of the same file |
12:49 |
|
Joubu |
61 my $table = $deleted ? 'deletedbiblio_metadata' : 'biblio_metadata'; |
12:49 |
|
Joubu |
62 my $sql = " |
12:49 |
|
Joubu |
63 SELECT biblionumber |
12:49 |
|
Joubu |
64 FROM $table |
12:49 |
|
Joubu |
65 WHERE (timestamp >= ? AND timestamp <= ?) |
12:50 |
|
dolf |
Ah, thanks for confirming. I was just staring at those lines... |
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:56 |
|
cait |
hmi wonder |
12:57 |
|
cait |
shoudl we not make themboth the same? |
12:57 |
|
cait |
i mean displaying one and using the other doesn't make much sense |
12:57 |
|
cait |
they won't get harvested that way, which seems to have been the initial goal? |
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? |
13:00 |
|
Joubu |
where are documented the from and to parameter? |
13:07 |
|
dolf |
Joubu: Do you mean this? https://www.openarchives.org/O[…].html#ListRecords |
13:08 |
|
Joubu |
yes, thanks |
13:08 |
|
Joubu |
https://www.openarchives.org/O[…]ol.html#Datestamp |
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:09 |
|
Joubu |
"Harvesters may use datestamps to harvest only those records that were created, deleted, or modified within a specified date range." |
13:09 |
|
Joubu |
in my understanding they should be the same |
13:09 |
|
Joubu |
it's what we are doing we the "Last modified" value |
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:12 |
|
Joubu |
it may impact the response performance as we will have to add 2 joins |
13:23 |
|
|
inlibro joined #koha |
13:24 |
|
Joubu |
Is today bank holiday in the USA? |
13:25 |
|
Joubu |
Looks like it is, Martin Luther King, Jr. Day - Third Monday in January |
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:41 |
|
dolf |
Also, I think the join is only necessary when the user has the "include items" option in their OAI-PMH config. |
13:48 |
|
Joubu |
dolf: do you mean we should only MAX of items.timestamp if "include items" is set? |
13:48 |
|
dolf |
yes, I think so |
13:49 |
|
|
AndrewFH joined #koha |
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:50 |
|
dolf |
Will do. |
13:54 |
|
cait |
new bug sounds great, thx dolf |
13:54 |
|
cait |
also agree on the include items one |
13:54 |
|
cait |
ashimema: LibraryName is what is used for the beginning of the page title |
14:07 |
|
|
AndrewFH joined #koha |
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 |
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:11 |
|
dolf |
Was this an intentional or unintended part of one of the DB schema updates? |
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:17 |
|
Joubu |
dolf: could be 18.06.00.018 or 19.12.00.080 |
14:23 |
|
|
inlibro joined #koha |
14:39 |
|
dolf |
Done. See bug 27463 |
14:39 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=27463 normal, P5 - low, ---, koha-bugs, NEW , OAI-PMH date handling in ListBase.pm |
14:39 |
|
dolf |
Joubu: I'm not sure how to CC them. |
14:40 |
|
Joubu |
done |
14:43 |
|
dolf |
Champion |
14:50 |
|
|
bdonnahue2 joined #koha |
14:53 |
|
|
AndrewFH joined #koha |
14:56 |
|
|
severine_q joined #koha |
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:58 |
|
huginn |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5927 enhancement, P5 - low, ---, nick, Pushed to master , Show series information in search results page |
15:03 |
|
cait |
severine_q: true |
15:03 |
|
cait |
we should have made the bug titlte state the format |
15:03 |
|
cait |
i think most of us are too unfamiliar with unimarc to work on the xslt for it |
15:04 |
|
|
morrism joined #koha |
15:06 |
|
severine_q |
thanks cait ! |
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:24 |
|
|
inlibro joined #koha |
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:41 |
|
cait |
i think i found out |
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:46 |
|
|
AndrewFH joined #koha |
15:52 |
|
Joubu |
https |
15:53 |
|
|
Dyrcona joined #koha |
15:53 |
|
Joubu |
cait: git remote set-url origin https://git.koha-community.org[…]ommunity/Koha.git |
15:54 |
|
|
fridolin left #koha |
16:07 |
|
koha-jenkins |
Yippee, build fixed! |
16:07 |
|
wahanui |
Congratulations! |
16:07 |
|
koha-jenkins |
Project Koha_20.11_U20 build #25: FIXED in 44 min: https://jenkins.koha-community[…]oha_20.11_U20/25/ |
16:22 |
|
|
dpk_ joined #koha |
16:22 |
|
koha-jenkins |
Project Koha_20.11_U2010 build #25: SUCCESS in 59 min: https://jenkins.koha-community[…]a_20.11_U2010/25/ |
16:24 |
|
|
inlibro joined #koha |
16:24 |
|
koha-jenkins |
Yippee, build fixed! |
16:24 |
|
wahanui |
Congratulations! |
16:24 |
|
koha-jenkins |
Project Koha_20.11_U18 build #22: FIXED in 1 hr 1 min: https://jenkins.koha-community[…]oha_20.11_U18/22/ |
16:26 |
|
reiveune |
bye |
16:26 |
|
|
AndrewFH joined #koha |
16:26 |
|
|
reiveune left #koha |
16:29 |
|
koha-jenkins |
Project Koha_20.11_D10 build #41: STILL UNSTABLE in 1 hr 6 min: https://jenkins.koha-community[…]oha_20.11_D10/41/ |
16:53 |
|
koha-jenkins |
Project Koha_20.11_D9 build #34: SUCCESS in 46 min: https://jenkins.koha-community[…]Koha_20.11_D9/34/ |
17:14 |
|
koha-jenkins |
Project Koha_20.11_D11 build #40: STILL UNSTABLE in 49 min: https://jenkins.koha-community[…]oha_20.11_D11/40/ |
17:24 |
|
|
inlibro joined #koha |
17:25 |
|
koha-jenkins |
Project Koha_20.11_U16 build #27: SUCCESS in 1 hr 2 min: https://jenkins.koha-community[…]oha_20.11_U16/27/ |
17:29 |
|
|
AndrewFH joined #koha |
17:56 |
|
|
aswin joined #koha |
17:57 |
|
|
aswin left #koha |
18:05 |
|
|
AndrewFH joined #koha |
18:24 |
|
|
inlibro joined #koha |
18:31 |
|
|
ccordova joined #koha |
18:56 |
|
|
paul_p joined #koha |
19:00 |
|
|
AndrewFH joined #koha |
19:24 |
|
|
inlibro joined #koha |
19:42 |
|
|
AndrewFH joined #koha |
19:48 |
|
|
aleisha joined #koha |
19:57 |
|
|
AndrewFH joined #koha |
20:25 |
|
|
inlibro joined #koha |
20:32 |
|
|
hayley joined #koha |
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 |
20:33 |
|
hayley |
<koha-devellists.koha-community.org>" imported so I don't know what's going on - maybe the move of repo changed something? |
20:59 |
|
|
marie-luce joined #koha |
21:12 |
|
|
catherine joined #koha |
21:13 |
|
|
eden joined #koha |
21:13 |
|
catherine |
hi |
21:13 |
|
eden |
hi |
21:13 |
|
aleisha |
academy students incoming! :) |
21:14 |
|
eden |
hello |
21:14 |
|
wahanui |
kia ora, eden |
21:14 |
|
|
mazen joined #koha |
21:14 |
|
mazen |
hi |
21:14 |
|
wahanui |
bonjour, mazen |
21:14 |
|
mazen |
Hi wahanui |
21:14 |
|
|
ella joined #koha |
21:15 |
|
mazen |
Hello ella |
21:15 |
|
ella |
ello Mazen |
21:15 |
|
|
Jimmy joined #koha |
21:15 |
|
caroline_crazycatlady |
heelo academy! |
21:15 |
|
mazen |
hi jimmy |
21:15 |
|
mazen |
Hello caroline |
21:15 |
|
Jimmy |
Hi! :D |
21:16 |
|
eden |
hi caroline! |
21:16 |
|
|
ava joined #koha |
21:16 |
|
mazen |
hello ava |
21:16 |
|
ava |
hi |
21:16 |
|
wahanui |
hola, ava |
21:16 |
|
|
amy_ joined #koha |
21:16 |
|
amy_ |
hello |
21:16 |
|
wahanui |
niihau, amy_ |
21:17 |
|
caroline_crazycatlady |
welcome! |
21:18 |
|
|
victoria joined #koha |
21:25 |
|
|
inlibro joined #koha |
22:01 |
|
|
cait1 joined #koha |
22:25 |
|
cait1 |
@later tell fridolin can you please reconsider bug 15448 and dependency? |
22:25 |
|
huginn |
cait1: The operation succeeded. |
22:25 |
|
|
inlibro joined #koha |
22:35 |
|
* cait1 |
waves |
22:38 |
|
|
M_Adamyk joined #koha |
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:42 |
|
|
AndrewFH joined #koha |
22:44 |
|
cait |
yes |
23:05 |
|
mtj |
hey #koha |
23:05 |
|
marie-luce |
hi mtj |
23:05 |
|
mtj |
hayley, did you sort your GPG error problem? ^ |
23:06 |
|
cait1 |
wow, the students are fast :) |
23:08 |
|
mtj |
hi marie-luce, cait1 😽ðŸ¨ðŸ¹ |
23:08 |
|
cait1 |
hi mtj :) |
23:08 |
|
cait1 |
aw |
23:15 |
|
|
hayley joined #koha |
23:16 |
|
marie-luce |
nice cat |
23:19 |
|
|
AndrewFH joined #koha |
23:25 |
|
|
inlibro joined #koha |
23:44 |
|
cait1 |
i should sleep instead of trying ot keep up with 8 students much younger and more awake than me :) |
23:44 |
|
cait1 |
open_source_academy++ |
23:44 |
|
aleisha |
:) |
23:59 |
|
|
AndrewFH joined #koha |