Time  Nick                  Message
22:35 kathryn               no joy finding anything useful
22:30 kathryn               wow we have a lot of tickets regarding duplicates...
22:29 kathryn               but you know me, it could be totally something else I'm thinking of...I'll do a lil search
22:28 kathryn               hi hi wizzyrea :) this rings a bell so I think you probably know someone :)
22:28 wizzyrea              takes ages to save when the duplicate checking is on
22:27 wizzyrea              for example, a record with a title, but no author or ISBN
22:27 wizzyrea              do I know anyone here who has solved the problem of Koha's aggressive duplicate checking causing timeouts when biblios are saved?
21:34 davidnind[m]          good night cait!
21:33 * thd                 must help the extra short people for a few hours before returning to Koha.
21:32 hayley                night cait :)
21:32 thd                   thanks all
21:32 davidnind[m]          thanks cait!
21:32 hayley                thanks davidnind[m] !
21:32 davidnind[m]          thanks everyone! (thd, cait, hayley)
21:31 cait                  good night all
21:31 cait                  davidnind[m]++
21:31 cait                  have to go to sleep now :)
21:31 cait                  i might have miscalculated... but it will probably be still ok
21:31 huginn                Log:            http://meetings.koha-community.org/2019/development_irc_meeting_23_october_2019.2019-10-23-21.06.log.html
21:31 huginn                Minutes (text): http://meetings.koha-community.org/2019/development_irc_meeting_23_october_2019.2019-10-23-21.06.txt
21:31 huginn                Minutes:        http://meetings.koha-community.org/2019/development_irc_meeting_23_october_2019.2019-10-23-21.06.html
21:31 huginn                Meeting ended Wed Oct 23 21:31:05 2019 UTC.  Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4)
21:31 davidnind[m]          #endmeeting
21:30 cait                  11 am currently
21:30 cait                  hould probably be ok in both directions
21:30 davidnind[m]          #info Next meeting: 6 November 2019, 13:00 UTC
21:30 davidnind[m]          will leave as normal time then for the moment
21:30 cait                  but not sure what difference it makes
21:30 cait                  they will soon
21:29 davidnind[m]          6 November 13:00 (normal time), unless daylight savings has kicked in for you
21:29 cait                  will you?
21:28 davidnind[m]          I think so
21:27 cait                  2 weeks?
21:27 davidnind[m]          #topic Set time for next meeting
21:26 davidnind[m]          If there is anything to discuss...otherwise will change to next meeting
21:26 davidnind[m]          #topic General development discussion
21:25 davidnind[m]          thanks cait!
21:25 cait                  davidnind[m]: that's it from me I think
21:25 cait                  #info First is feature slush (features must have passed QA) on 30th November
21:25 cait                  #link https://koha-community.org/calendar/ Koha calendar
21:24 cait                  #info Freeze dates have been announced and added to the Koha calendar on the website
21:24 cait                  #info rel_19_11_candidate keyword in Bugzilla is used to prioritize
21:24 cait                  you can search for the bugs tagged in bugzilla using the advanced search
21:23 cait                  there is a rel_19_11_candidate keyword used by the RM to prioritize
21:23 davidnind[m]          don't think we have any release manager or maintainers present, so skipped ahead :)
21:23 cait                  since the hackfest in Marseille numbers in the queue have been a bit higher, hope to get them down soon
21:23 cait                  oops that's me
21:22 davidnind[m]          #topic Updates from the QA team
21:21 davidnind[m]          yep
21:21 cait                  moving on?
21:21 cait                  #info Calayst's open source academy to take place from 6th-17th January 2020
21:21 hayley                cait: 6th-17th January 2020 :)
21:20 davidnind[m]          No release manager, so I guess we should just skip ahead to Updates from the QA team
21:20 cait                  hayley: also saw that applications for the academy have started again - when will it be?
21:19 davidnind[m]          #info Koha Hackfest held in Finland
21:19 davidnind[m]          #Action davidnind to post to general mailing list for 20.05 roles
21:18 cait                  thx for offering!
21:18 cait                  i tihnk it would be good
21:18 cait                  yesterday was a Koha hackfest in Finland - but don't know enough details for an #info
21:18 davidnind[m]          Will post to the general mailing list nudge people along? If so I'm happy to do that.
21:17 davidnind[m]          I did, just corrected :)
21:17 cait                  yes, we definitely need more people
21:17 davidnind[m]          #info Roles open for 20.05 https://wiki.koha-community.org/wiki/Roles_for_20.05
21:17 cait                  i got excited for a second :)
21:17 cait                  davidnind[m]: i tink you got the wrong link
21:16 cait                  lots of roles still open
21:16 cait                  please sign up!
21:16 cait                  :)
21:16 davidnind[m]          #info Roles open for 20.05 https://wiki.koha-community.org/wiki/Roles_for_19.11
21:16 davidnind[m]          Roles open for 20.05, to be decided at next General IRC meeting
21:16 hayley                #info Hayley, Catalyst IT, Wellington New Zealand (sorry bit late)
21:14 davidnind[m]          #topic Announcements
21:14 huginn                Current chairs: cait davidnind[m]
21:14 davidnind[m]          #chair cait
21:13 cait                  ashimema_? ashimema?
21:13 davidnind[m]          no worries cait
21:12 cait                  #info Katrin Fischer, BSZ, Germany
21:12 wahanui               niihau, thd
21:12 thd                   hello
21:12 cait                  sorry, bit distracted
21:12 davidnind[m]          hi thd
21:12 davidnind[m]          I'll give it a few more minutes...
21:10 davidnind[m]          cait or ashimema around? (it is probably late where they are...)
21:09 thd                   Good, otherwise I have to leave early.
21:08 davidnind[m]          I feel that it will be probably be a quick meeting...
21:07 thd                   #info Thomas Dukleth, Agogme, New York City
21:07 davidnind[m]          #info David Nind, Oamaru, New Zealand
21:06 davidnind[m]          #topic Introductions
21:06 davidnind[m]          #info Agenda https://wiki.koha-community.org/wiki/Development_IRC_meeting_23_October_2019
21:06 huginn                The meeting name has been set to 'development_irc_meeting_23_october_2019'
21:06 huginn                Useful Commands: #action #agreed #help #info #idea #link #topic #startvote.
21:06 huginn                Meeting started Wed Oct 23 21:06:14 2019 UTC.  The chair is davidnind[m]. Information about MeetBot at http://wiki.debian.org/MeetBot.
21:06 davidnind[m]          #startmeeting Development IRC meeting 23 October 2019
21:02 davidnind[m]          Any people around for the development meeting?
20:57 davidnind[m]          corilynn++
20:53 corilynn              I guess I did that right, for once
20:53 huginn                corilynn: The operation succeeded.
20:53 corilynn              @later tell oleonard I'd like his input on the interface implimentation of Bug 18823
20:49 wizzyrea              hi
20:44 corilynn_             (ish)
20:44 corilynn_             and... we need it soon
20:42 corilynn_             right
20:37 cait                  do you also need tomove records between batches or in and out of the catalog?
20:36 cait                  create, edit, delete etc. from the batches
20:36 cait                  ok, so you need a way to edit records organized in batches
20:34 cait                  interesting
20:34 corilynn_             and some clients want 5 subject headings, and some want 3 and some want "$vJuvenile fiction" and some want to have 650 1 for juvenile
20:33 corilynn_             because we catalog for hire
20:33 corilynn_             but we hack that system in other cataloging interfaces to seperate out the different client records
20:32 corilynn_             right
20:32 cait                  like a... draft area?
20:32 cait                  so you prepare batches before they are imported... right?
20:31 corilynn_             through the "Advanced Editor"
20:31 corilynn_             Anyway, i'm not sticky on the interface as long as we can save/edit the records into the import_batch
20:30 cait                  for context
20:30 cait                  just trying to say, workflows are different. Always interested to learn and understand - so explanations help :)
20:30 corilynn_             I'm from Alaska and live in New England (Connecticut), so I'm big on A/C
20:29 cait                  yeah, we are ont big on ac
20:29 corilynn_             just enough to cut the edge off...
20:29 corilynn_             and no A/C or barely any
20:29 corilynn_             cait, I *did* know you were in Germany... and I was there for a few weeks in the summer, it was HOT
20:28 cait                  anatomic models
20:28 cait                  oh
20:28 cait                  libraries can get quite creative
20:28 cait                  locker keys
20:28 cait                  i think they put rfid stickers on too
20:28 cait                  summers have been hot.. they lend it to students
20:28 corilynn_             ve never cataloged any... I can't remember the term... regalia?
20:27 corilynn_             I mean, I'
20:27 caroline_crazycatlady I love how you ask "you catalog fans" as if it was a sports team or something
20:27 cait                  I am in Germany - in case you didn't know - so our infrastructure is different
20:26 cait                  we use niether :)
20:25 corilynn_             OCLC has this feature, as does ITS
20:25 corilynn_             you catalog fans?
20:25 cait                  and things like fans and laptops
20:24 cait                  well, only a little bit
20:24 cait                  our workflows are probably quite different because of the union catalogs - we don't do catalouging in Koha
20:23 cait                  i haven't seen a system that does this efore
20:23 cait                  i think it might be different for us here
20:23 cait                  not going there to check
20:23 corilynn_             I recently discovered that the LibLime Koha has this feature as well
20:22 corilynn_             places where you put records before they are ready for human consumption...
20:22 corilynn_             no, but most cataloging interfaces have "active files"
20:21 cait                  is that described on the bug somewhere? the use case?
20:21 cait                  but you mentioned earlier you need it not to have to take care of many instances
20:20 cait                  corilynn_: not sure - maybe there is already a comment
20:20 cait                  i see it's in discussion now hm
20:20 cait                  hm yeah maybe a little late
20:19 corilynn_             looks like he's out
20:18 cait                  for gui questions oleonard is also  agood person to ask
20:18 corilynn_             ok
20:18 cait                  behind on my qa work... so trying not to promise anything
20:16 corilynn_             you can't weigh in until next week, cait? is that what you are saying?
20:15 corilynn_             I admit the gui is confusing... but I didn't design it... i feel like no one did
20:14 cait                  i can try to weigh in until next week, but probably need to have a closer look
20:14 cait                  not sure if it changed since?
20:14 cait                  and also got confused by the gui
20:14 cait                  tbh - i didn't quite understand the use case the first time i looked at that
20:11 corilynn_             there's some question over how the interface works with deduping.. I get now better how the "Koha" way works
20:10 huginn                Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18823 enhancement, P5 - low, ---, alex.arnaud, In Discussion , Advanced editor - Rancor - add ability to edit records in import batches
20:10 corilynn_             cait, do you mind weighting in again with bug 18823?
19:56 cait                  corilynn_: that would be me :)
19:55 cait                  which bug? I think I missed the beginning of the discussion
19:54 cait                  reading back
19:54 cait                  e
19:54 cait                  oh sorry, was not paying attention her
19:52 kathryn               morning :)
19:47 corilynn_             "Katrin Fischer" from comment 89
19:46 corilynn_             ok.. I know cait (I think it was cait) had weighed in on it as well
19:45 kidclamp              But usually one or two other opinions is a good step
19:45 corilynn_             sweet, thx
19:45 kidclamp              I don't think any of the issues were blockers
19:44 kidclamp              You can respond and switch it
19:31 corilynn_             I don't know the process for getting a feature out of "In Discussion"
19:30 corilynn_             and while it would be enought to justify my existance, kidclamp, I'm not sure it'll make me a happy camper, eh?
19:29 corilynn_             i really need this feature, or I'm stuck administering 16+ different instances of Koha
19:29 corilynn_             we *really* NEED this feature
19:28 corilynn_             I hate to suggest that it's a feature that is off by default, but whatever to get it going through
19:28 corilynn_             it works the way *I* expect it...
19:10 kidclamp              Sure, what is up?
19:06 huginn                Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18823 enhancement, P5 - low, ---, alex.arnaud, In Discussion , Advanced editor - Rancor - add ability to edit records in import batches
19:06 corilynn_             yo, kidclamp, when you've got a minute can we discuss the discussion on bug 18823?
18:40 koha-jenkins          Project Koha_Master_U18 build #410: SUCCESS in 57 min: https://jenkins.koha-community.org/job/Koha_Master_U18/410/
18:25 oleonard              Don't hassle me git, I'm doing my best
18:25 oleonard              "Your branch and 'origin/master' have diverged, and have 3 and 2486 different commits each, respectively."
18:19 caroline_crazycatlady If you only write the amount in "collected from patron", it pays the whole thing
18:19 caroline_crazycatlady I'm testing various parts of 19.05 and I noticed that if you partially pay a fine, you have to write the amount collected twice (once in "amount being paid" and a second time in "collected from patron") is that the intended behaviour? It seems like it's two steps where it could be just one
18:10 koha-jenkins          Project Koha_Master_D9 build #936: STILL UNSTABLE in 32 min: https://jenkins.koha-community.org/job/Koha_Master_D9/936/
17:43 koha-jenkins          Project Koha_Master_U18 build #409: SUCCESS in 57 min: https://jenkins.koha-community.org/job/Koha_Master_U18/409/
17:38 koha-jenkins          Project Koha_Master_D10 build #41: STILL FAILING in 3 min 15 sec: https://jenkins.koha-community.org/job/Koha_Master_D10/41/
17:35 koha-jenkins          Project Koha_Master_D8 build #472: STILL UNSTABLE in 26 min: https://jenkins.koha-community.org/job/Koha_Master_D8/472/
17:08 koha-jenkins          Project Koha_Master_D9 build #935: UNSTABLE in 34 min: https://jenkins.koha-community.org/job/Koha_Master_D9/935/
17:04 huginn                News from kohagit: Bug 23843: Add mapping to Koha::Account::Line <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f5f98af7be74dce81073fe0a42431db7ebac49f7>
17:04 huginn                News from kohagit: Bug 23843: Add mapping to Koha::Checkout <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1957cb64ca8efab68001a9bdec3c0ce02133907b>
17:04 huginn                News from kohagit: Bug 23843: Add mapping to Koha::Club::Holds <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=af2cd5e303d5a4446159110a7da27cc5befd5a64>
17:04 huginn                News from kohagit: Bug 23843: Add mapping to Koha::Hold <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=09ff41d9f12825d5dd042c12871a67300b6c535d>
17:04 huginn                News from kohagit: Bug 23843: Add mapping to Koha::Library <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=430be3e9f3e8ca2313a9b8487a34803edc3aaf2d>
17:04 huginn                News from kohagit: Bug 23843: Add mapping to Koha::Patron <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=255b9b98d01f330b2d6cc48fa3efa2ed599a50c7>
17:04 huginn                News from kohagit: Bug 23843: Add mapping to Koha::Item <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=17a34e3d099f86dad4a84cdb98073d794dcd6c4e>
17:04 huginn                News from kohagit: Bug 23843: Add mapping to Koha::Acquisition::Bookseller <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=70e0a23af66960fdc8d0a32fc57c1858e8f7a010>
17:04 huginn                News from kohagit: Bug 23843: Add mapping to Koha::Acquisition::Fund <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1b9f3621dfc82144e498d6d7d53cdda3b6d352a0>
17:04 huginn                News from kohagit: Bug 23843: Make funds endpoint tests more robust <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ecf030b798297d19926ca037507271ad4c100bfd>
16:51 tcohen                borrowernumber vs. patron_id
16:51 tcohen                do we have a guideline (implict or not) for FK fields names?
16:45 koha-jenkins          Project Koha_Master_D10 build #40: STILL FAILING in 10 min: https://jenkins.koha-community.org/job/Koha_Master_D10/40/
16:40 huginn                Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23793 enhancement, P5 - low, ---, tomascohen, Pushed to master , Add an EmbedItems RecordProcessor filter for MARC::Record objects
16:40 tcohen                also bug 23793 pushed
16:40 tcohen                :-D
16:38 * oleonard            likes tcohen's Halloween enthusiasm
16:36 tcohen                wooo
16:34 huginn                News from kohagit: Bug 23793: Add an EmbedItems RecordProcessor filter for MARC::Record objects <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6189f25dfae19f99800168db7be996e1239efae3>
16:34 huginn                News from kohagit: Bug 23793: Unit tests <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=99a1a6db0f720cf0896a5ea2651cce89e35384ae>
15:36 cait                  if you set list price and invoice price to different settings things get really confusing
15:36 cait                  but... took long to answer that one
15:34 oleonard              Joubu around?
15:28 cait                  apart from the usual 1 cent problem it kind of makes sense
15:28 cait                  so she can look at the formulas
15:28 cait                  actuaqlly going to send the library an excel sheet
15:28 cait                  kidclamp: yeah i think i got it now
15:27 ashimema              acq is eye watering stuff cait
15:27 kidclamp              the setting implies how you will enter prices, koha will calculate the one you didn't entee
15:27 * ashimema            now has koha running under mariadb 10.2.27 inside koha-testing-docker
15:27 cait                  it's still way too confusing :(
15:27 ashimema              got it..
15:27 cait                  oh... it does... it substracts... this is too confuing, sorry all.
15:26 cait                  if the invoice price is set to 'with tax'... should i knot enter it ... with taqx?
15:26 cait                  yeah, it doesn't make sense
15:26 cait                  hm actually
15:26 cait                  l
15:25 cait                  ahsorry, got confused
15:24 cait                  that's fun.
15:24 cait                  but koha adds tax
15:24 cait                  ... so invoice price is without tax... configured
15:17 ashimema              but I can't seem to get koha to run on a recent enough version of mysql or mariadb
15:16 ashimema              I'd love to be able to see these tests fail myself :(
15:16 ashimema              marcelr.. did you ever tell me what db you were running..
15:16 cait                  it makes me want to cry
15:15 cait                  i am not sure you have this joker anymore
15:15 cait                  although that is a mystery too... it's the same as the list price.. but we actually pay tax... so it should not be
15:15 ashimema              can I call a friend?
15:15 cait                  ah sorry, not replacement
15:14 cait                  what is the replacement cost?
15:14 cait                  discount 18 and tax 7
15:14 cait                  so my price exclusive tax is 61.90
15:14 cait                  doesn't help me answer this support ticket
15:13 ashimema              acq prices are a mystery to all of us cait ;)
15:13 cait                  but no matter what i do, I don't get to waht koha says it shoudl be
15:13 cait                  so... if i have the list price excl tax... do i first substract the discount and then add the tax.. or
15:13 koha-jenkins          Project Koha_Master_U18 build #408: FIXED in 34 min: https://jenkins.koha-community.org/job/Koha_Master_U18/408/
15:13 wahanui               Congratulations!
15:13 koha-jenkins          Yippee, build fixed!
15:13 cait                  i am trying to see how a price is calculated in koha
15:12 cait                  if i would understand it
15:12 oleonard              cait: I guess file a bug report?
15:11 cait                  koha... i don't get you
15:08 reiveune              bye
15:02 koha-jenkins          Project Koha_Master_D10 build #39: STILL FAILING in 15 min: https://jenkins.koha-community.org/job/Koha_Master_D10/39/
14:57 Joubu                 marcelr: we do not want to display expected output to stderr, so why we throw it away
14:57 marcelr               htg
14:46 koha-jenkins          Project Koha_Master_D8 build #471: STILL UNSTABLE in 43 min: https://jenkins.koha-community.org/job/Koha_Master_D8/471/
14:38 koha-jenkins          Project Koha_Master_D9 build #934: SUCCESS in 34 min: https://jenkins.koha-community.org/job/Koha_Master_D9/934/
14:36 tcohen                better approaches are welcome of course
14:36 tcohen                if Jonathan opted for that option, I'm sure there's no way to avoid the noise, which we know will be thrown, and we already catch to throw our own exception
14:34 marcelr               tcohen: open STDERR, '>', '/dev/null'; is indeed not the nicest way
14:32 ashimema              Indeed.. well get back to it was soon as I've got the girls from school..
14:31 marcelr               at least it did once..
14:31 marcelr               ashimema: i think that adding $schema->storage->dbh->{PrintError} = 0 in Koha/Account.t should work too
14:30 tcohen                marcelr: I also suspect txn_do
14:29 tcohen                sometimes it doesn't and we do: https://github.com/tomascohen/koha/commit/dee172df9fd8970db185c9f67b9552cbc1898f58#diff-e2903ff5c77853938af89bd68c364848R80
14:29 tcohen                sometimes it works: https://gitlab.com/thekesolutions/Koha/blob/master/t/db_dependent/Koha/Object.t#L312
14:29 marcelr               this one passes with noise we should get rid of somewhere else
14:28 marcelr               ashimema: i guess you should concentrate on the other failing test
14:28 ashimema              At least the test passed.. even if it is a little noisy
14:27 marcelr               tcohen: i also suspect txn_do is our bad guy
14:27 ashimema              So the trick to give them doesnt work any more.. at least I'm not going mad
14:26 marcelr               Patron.t
14:26 marcelr               $SIG{__WARN__} = sub {}; # FIXME: PrintError = 0 not working!
14:25 marcelr               i am on the track now that it is a chain of exceptions somehow in a nested call of txn_do ..
14:24 marcelr               hmm
14:24 tcohen                marcelr, ashimema: we usually set PrintError = 0, but it stopped working and we don't know why
14:15 ashimema              school run.. brb
14:15 ashimema              the way I'm testing it looks the same as other cases where we're using try/catch/rethrow blocks
14:14 ashimema              wondering if I've seen this elsewhere now
14:14 ashimema              agreed..
14:14 marcelr               just didnt like the stderr stuff
14:12 ashimema              indeed
14:12 marcelr               but the exception is correct
14:12 marcelr               yeah was looking at the same thing
14:09 ashimema              I thought throws_ok should catch that
14:09 ashimema              it passes the test but still spits out the error to screen.
14:09 ashimema              that's really odd..
14:06 ashimema              as for the failing test.. I see.. interesting one
14:06 ashimema              I was worried there might be other cases.. but in reality it seems there really shouldn't be.
14:06 ashimema              yeah.. it's taken me a while to dredge through the history to come up with that conclusion..
14:05 ashimema              grr
14:05 marcelr               ashimema: i think that >=0 might indeed be better to prevent problems with the constraint
14:04 ashimema              ooh.. one still fails..
14:04 ashimema              i.e catching 0 and greater than 0 instead of just greater than and making them 'debits'
14:02 huginn                News from kohagit: Bug 13937: (follow-up) Fix searching with UTF-8 characters. <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=2b149c3d7aa7e2f59fcee6d8778f8e0c685cc406>
14:02 marcelr               ashimema: one test only fails now; almost !
13:58 ashimema              at the moment I'm erring on >= 0 means it was once a debit.. as far as I can see so far it's really debit having been 'corrected to zero'.. not seeing cases of credits getting that treatment in the history
13:58 marcelr               yeah >=0 ??
13:57 ashimema              thinking of that in combination with the credit_types bug which follows this one..
13:57 ashimema              I am still debating the > 0 thing in my head...
13:55 ashimema              it's good.. he caught stuff :)
13:55 cait                  i noticed that
13:55 marcelr               qa disclaimer: i said almost ;)
13:55 cait                  marcelr is a tough qa person :P
13:55 ashimema              :)
13:54 marcelr               well you almost convince me. final look..
13:53 marcelr               right
13:53 ashimema              it was still in tests as a Koha::Account::Line->new call
13:53 marcelr               ok good
13:53 ashimema              as for pay.. i was wrong.. it wasn't in pay at all.. i misread the line
13:53 ashimema              though I just also added the DBIC pulling out of the first commit and pushing on top as a final commit (forgot that till just now)
13:53 marcelr               sub pay..
13:52 marcelr               ^^
13:52 ashimema              yes.. it's a rebase
13:52 marcelr               pp[s
13:52 ashimema              back at you marcelr
13:52 marcelr               so good and asleep ;)
13:50 * oleonard            forces a smile and recites, "Yes ashimema is our leader and it is good!"
13:49 wahanui               ashimema is the benevolent dictator
13:49 marcelr               ashimema
13:49 marcelr               ashimema_: you said something about sub pay; where do you change it ?
13:41 marcelr               ashimema_: hope that this is a rebase ;)
13:41 marcelr               Your branch and 'bug23049/bug_23049_inv' have diverged, and have 29 and 53 different commits each, respectively.
13:38 cait                  kidclamp: i don't know, but it woudl be good to answer that very old question
13:36 oleonard              kidclamp: https://media.giphy.com/media/b7MdMkkFCyCWI/giphy.gif
13:35 huginn                Bug 21633: normal, P5 - low, ---, koha-bugs, NEW , Did finesMode = test ever send email?
13:35 kidclamp              https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21633
13:34 kidclamp              does fines mode of 'test' do anything at all>
13:25 caroline_crazycatlady good morning everyone!
13:15 WendyMaq              Mornin'!
13:15 oleonard              Hi WendyMaq
13:14 * oleonard            is getting into the API mindset
13:14 oleonard              tcohen: I'm just tinkering for now.
13:12 tcohen                we can implement that of course!
13:12 tcohen                we could do it as query params
13:11 tcohen                that's correct
13:11 oleonard              tcohen: As far as I can tell there's not a way to pass multiple biblionumbers at once. Is that correct?
13:10 oleonard              tcohen: Thanks, I see now that Postman was looking for the "Accept" header
13:04 tcohen                it is the 'accepts' header/setting
13:03 tcohen                you mean with Jquery?
13:03 tcohen                https://api.jquery.com/jquery.ajax/
13:01 oleonard              tcohen: How do I compose the request with the content type?
12:59 tcohen                application/json will return biblios+biblioitems (with attribute names adapted to our conventions)
12:58 tcohen                but, well, I didn't :-D
12:57 tcohen                I could've chosen to default to application/json
12:57 tcohen                states that a payload with the list of accept-able mime-types should be  returned
12:57 marcelr               tcohen++
12:57 tcohen                https://tools.ietf.org/html/rfc7231#section-6.5.6
12:57 tcohen                the RFC for 406
12:56 cait                  ashimema: ok, sounds like he is ok then :)
12:56 oleonard              Ah that makes sense tcohen. So the content-type should be a param?
12:56 tcohen                https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/406
12:56 ashimema              I 'think' he's back now.. but it still overly busy catching up on other things
12:56 tcohen                406 -> Not acceptable
12:56 ashimema              he's been on a break
12:56 ashimema              i have cait
12:55 tcohen                OR get a 406
12:55 tcohen                depending on the API design, you might have a fallback
12:55 tcohen                when you make a request, and don't specify the expected content-type
12:54 oleonard              tcohen: the output of GET /api/v1/biblios/{biblio_id}
12:54 cait                  has someone emailed him?
12:54 marcelr               or todo points
12:54 ashimema              there's a few bugs in Mirko's queue :(
12:53 marcelr               tcohen: and yeah what about the empty results only the lines oleonard pasted
12:53 oleonard              Hi tcohen
12:53 oleonard              Hi wizzyrea
12:53 tcohen                MiJ is in debian, we just don't pull it (yet, eyes on mirko)
12:53 ashimema              marcelr++
12:53 ashimema              tcohen++
12:53 marcelr               yeah without the regular calls
12:53 ashimema              but there's also a few other little things to clean up
12:52 ashimema              in short.. a bunch of these tests use raw sql inserts
12:52 marcelr               tcohen: read some lines back about api biblios
12:52 tcohen                ashimema sommuned me
12:52 marcelr               hi tcohen
12:52 tcohen                hi alll
12:51 marcelr               ok ashimema waiting for your resolving them :)
12:51 ashimema              thanks for purservering marcelr.. I have a bunch of avenues to look into now.. found a new field of bugs in this highlighted
12:50 oleonard              Pity the poor librarian who has to understand why  OpacBrowser,  OpacBrowseResults, and  BrowseResultSelection are all completely unrelated
12:43 marcelr               bit strange
12:43 marcelr               seeing the same oleonard now
12:40 oleonard              ["application\/json","application\/marcxml+xml","application\/marc-in-json","application\/marc"] ?
12:40 * oleonard            doesn't understand what the output of GET /api/v1/biblios/{biblio_id} is... for?
12:36 marcelr               but it is in the dependencies list
12:35 marcelr               shouild probably be added to the repo still
12:35 oleonard              Or does this highlight an omission?
12:35 oleonard              Is it something that would have been installed automatically if this were a newer installation?
12:35 ashimema              reading
12:35 marcelr               apt-get install libmarc-file-mij-perl
12:34 marcelr               you need a new module oleonard
12:34 oleonard              (on kohadevbox)
12:34 oleonard              I'm getting an error when trying to get a biblio via the api:  Can't locate MARC/Record/MiJ.pm in @INC (you may need to install the MARC::Record::MiJ module)
12:32 marcelr               hope you read them :)
12:32 marcelr               the examples on the bug report i gave you
12:31 ashimema              ?
12:31 ashimema              I think I dropped the accounttype falling back to a default of 'pay' if nothing was passed.
12:31 marcelr               ok and some new..store stuff in the tests
12:30 ashimema              it's the 'pay' method in Koha::Account
12:30 marcelr               oh oh
12:30 ashimema              nailed it!
12:30 marcelr               only that i couldnt find them.. ;)
12:29 marcelr               i cant find bad examples in the regular code too although that does not prove anything ;)
12:26 ashimema              oh man that's allot of screen dumpage
12:26 ashimema              I'm sure it's just the tests and not errant code now
12:26 ashimema              OK.. i've got the big guns out marcelr.. I'm running the tests under perl with DBIC_TRACE set to max to try and spot where it's trying to add bad data
12:26 magnuse               i snuck it back in
12:25 ashimema              I trust it still works (and will test as the final part of QAing it)
12:25 ashimema              I can put that back for you
12:24 magnuse               gah, lost the signed-off line
12:11 marcelr               constrained about constraints
12:11 marcelr               constraint
12:10 marcelr               yeah or no contraint :)
12:10 * ashimema            ponders NULL or NULL
12:10 magnuse               working on a revised patch now
12:10 marcelr               magnuse++ for being grateful for FQAs
12:10 ashimema              :)
12:09 magnuse               ashimema++
12:09 ashimema              I've FQA's 22706 for now magnuse.. those minor updates shouldn't be too honerous and I've flagged it as rel_19_11_candidate so it won't miss the boat.
12:09 marcelr               but allow both to be null
12:09 marcelr               ashimema: what about moving the constraint to not allow both fields to be filled? so A is null OR B is null ?
12:04 ashimema              as for the mixing in schema changes.. that must have happend during a rebase at some point.. I'll pull those out into their own commit
12:04 ashimema              I'd really like to get to the bottom of those issues if I can :(
12:04 marcelr               afraid that we would be testing in production systems
12:03 ashimema              though having it highlights that we have issues
12:03 ashimema              hmm..
12:02 marcelr               ashimema: my conclusion now would be to remove the constraint at least for now
12:01 ashimema              ta
12:00 marcelr               imo does not depend on mariadb version or so
12:00 marcelr               hi ashimema i am still submitting another comment about the failing tests / hang on a bit
11:58 ashimema              hi
11:57 marcelr               ashimema_: around ?
11:57 wahanui               hi oleopard
11:57 marcelr               hi oleonard
11:57 oleonard              Hi marcelr
11:57 marcelr               hi #koha
11:56 oleonard              Hi marcelr
11:56 marcelr               hi #koha
11:56 ashimema              agreed
11:53 magnuse               feels like password handling and checking might need a bit of a refactor, to only do things in one place, but that is beyond the scope of 22706, methinks...
11:52 magnuse               that might be why i did not go for is_password_valid
11:50 ashimema              it worries me we don't seem to check password strength on adding borrowers at all in this class.. it's only in the set_password routine
11:50 magnuse               dunno why i put it below...
11:50 ashimema              yeah.. i think it should be before the store call.. i.e. fail out before attempting to add to the database.
11:49 * ashimema            ponders
11:49 ashimema              you could also have hooked into 'Koha::AuthUtils::is_password_valid' as an alternative hook point
11:49 magnuse               you think the plugin-block should be before "$self = $self->SUPER::store;" right? that does seem to make sense
11:48 magnuse               yup, good question
11:48 ashimema              that can be worked around with documentation no doubt
11:48 ashimema              does having a check_password plugin hook around the existing password validation preferences (i.e. works alongside them) or does it replace them entirely.
11:47 ashimema              also how plugins would be expected to interact with koha sysprefs
11:47 ashimema              skip_validation being one of them
11:47 ashimema              this approach does raise some questions for me
11:46 magnuse               yeah, i guess it should respect 'skip_validation'
11:46 ashimema              all good
11:46 magnuse               guess i have not published the NNPDB plugin yet
11:45 magnuse               https://github.com/Libriotech/koha-plugin-pin
11:45 ashimema              not important if it private though.. I'm not that worried
11:44 ashimema              would be interseting to see your exact use case..
11:44 ashimema              does the plugin that uses this already exist?
11:43 ashimema              also.. for the 'set_password' method.. should the check_password plugin not respect the 'skip_validation' flag that can be passed?
11:43 magnuse               the password checking is just a side effect, though. It struck me that a plugin at the points where the patrondb needs it could also be used to check passwords.
11:42 ashimema              ooh.. this bug highlights a bug in our addmember
11:42 magnuse               hm, is that not what it does? i'll have a look
11:40 ashimema              shouldn't the password validity be checked before the call to store in the member addition routine?
11:39 ashimema              question then..
11:38 magnuse               there is lots of code, but that can all go in a plugin
11:38 magnuse               we might want to have a search box introduced somewhere, but we can deal with that later
11:38 ashimema              interesting.. I thought there was much more than that.
11:38 koha-jenkins          Project Koha_Master_U18 build #407: STILL UNSTABLE in 57 min: https://jenkins.koha-community.org/job/Koha_Master_U18/407/
11:38 magnuse               yeah, at least for the basic functionality
11:37 ashimema              is the password plugin check stuff all that's missing for the norweigen stuff?
11:37 magnuse               hiya oleonard
11:37 magnuse               the other is norwegian ill, but the groundwork for that is already in place
11:37 oleonard              Hi all
11:36 * ashimema            is on it
11:36 magnuse               * one of the few things
11:36 magnuse               would be super awesome if someone could qa 22706, lacking support for the norwegian patron database is one of the things that are holding public libraries in norway back from using koha...
11:32 ashimema              ooh.. didn't realise 22706 was in the qa queue
11:31 magnuse               no, it doesn't, at all :-)
11:24 huginn                Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22706 enhancement, P5 - low, ---, magnus, Signed Off , Add plugin hooks to enable Norwegian national patron database
11:24 huginn                Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20340 enhancement, P5 - low, ---, alex.arnaud, Failed QA , Ability to use authentication plugin
11:24 * magnuse             wonders if Bug 20340 makes Bug 22706 superfluous
11:15 ashimema              it would be nice to get a process in place for keeping HEA in sync with koha releases
11:15 huginn                Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23849 enhancement, P5 - low, ---, jonathan.druart, In Discussion , Update the list of sysprefs to share with Hea
11:15 ashimema              cait.. do you think you might get a change to take a quick look at bug 23849
11:02 cait                  it's lots of patches, so maybe easier to look up in the file/git
11:02 fraktik               ok. thx (14576)
11:02 cait                  yeah same here
11:02 cait                  if you look in updatedatabase.pl for the bug number (big file) you should see what it was supposed to do
11:01 fraktik               >> 05:38 	_fraktik 	https://translate.koha-community.org/ is down for some time?
11:01 cait                  you had it earlier, it was part of the whole bug
11:01 cait                  it was the original one
11:01 fraktik               cait, do you know id of bug, where you tested the transition  between InProcessingToShelvingCart, & ReturnToShelvingCart >> updateitemlocationoncheckin ? So I can link to it?
11:00 ashimema              I poked them earlier.. how long was it down?
10:59 fraktik               ha, https://translate.koha-community.org/ finally back ONLINE! :-)
10:58 huginn                ashimema: The operation succeeded.
10:58 ashimema              @later tell davidnind Ere has addded the begginings of a chapter on SRU/Z39.50 with Elasticsearch to the wiki (https://wiki.koha-community.org/wiki/Setting_up_the_Z39.50_and_SRU_Server).. it would be great to have someone in the docs team look it over and perhaps port some of it to the manual where appropriate.
10:54 magnuse               fraktik: system preferences are in the systempreferences table, other settings like circ rules have their own table(s)
10:13 cait                  fraktik sounds like a good idea
10:07 vfernandes            hi #koha
09:58 fraktik               thx - must go serve as librarian at front desk for an afternoon. will create bugs later on (another idea is: why this WARNING - No system preferences matched your search for: InProcessingToShelvingCart cant say something as OBSOLETE, now use XYZ instead.)
09:44 ashimema              and woop, woop.. more josef time too.. win win
09:44 ashimema              welcome fraktik :)
09:42 fraktik               cait: so, funny thing - in one instance PROC:_PERM_ was used by sestem, in other 4 instances (including our own "main" library") not.  Those setups are in general quite (or should be) close. Created from same template....
09:41 fraktik_              thx magnuse - thats what I was looking for - just forgot that in koha-conf.xml is very very basic setup and everything from GUI is actualy somewhere deep in db (where?)
09:21 magnuse               backups made by the debian packages will be in /var/spool/koha/<instance>/
09:18 fraktik_              we do not use ordering module => all those 4 named by you are (and according to log everytime were) empty.
09:09 cait                  but compareing your backups sould shed more light
09:09 cait                  there is multiple ays item values can be influenced by workflwos
09:08 wahanui               somebody said acquisitions was one area I hope to get us working together on
09:08 cait                  acquisitions
09:08 cait                  AcqItemSetSubfieldsWhenReceiptIsCancelled
09:08 cait                  AcqItemSetSubfieldsWhenReceived
09:08 cait                  there is also: cqItemSetSubfieldsWhenReceived
09:08 wahanui               acq is currently far too slow to be usable, so we need something quickly.
09:08 fraktik_              acq?
09:07 cait                  if you have in circulation and processing...  - could it be that we are lookign for an acq feature?
09:06 cait                  but actually it makes an entry when something is changed. so it looks like you might not have used it?
09:06 cait                  if you changed the prefs with sql.. that woudl not show up in action logs
09:06 cait                  someone else might be able to hlep
09:06 cait                  sorry, not sure how it's set up for you
09:04 fraktik_              I see - i am not root anymore - saved to tmp just fine - now i would need to get the same from 2w old backup for comparision - is it some standart way how to get it? (i remember, part of upgrade step-by-step were some backups, but i do not remember where I would find them)
09:01 fraktik_              but i got: 4x The given value does not seem to be interpretable as a Boolean value at koha-preferences line 71. (71 is some boo_value evaluation) + Cannot write to /root/usti_preferences_config.yaml: Permission denied at /usr/lib/x86_64-linux-gnu/perl5/5.24/YAML/Syck.pm line 106.
09:00 fraktik_              Do I do something wrong? I logged with koha-shell INSTANCE, then i run: @koha:/usr/share/koha/bin/admin$ perl koha-preferences dump -o /root/usti_preferences_config.yaml
08:50 _fraktik              but i found at knihovna-UO Koha@IP/usr/share/koha/bin/admin/koha-preferences skript which could be what i was looking for
08:49 fraktik_              https://koha-usti.knihovna-uo.cz/cgi-bin/koha/tools/viewlog.pl did not gave me even that.
08:49 fraktik_              493437	2015-09-01 12:52:25	1	SYSTEMPREFERENCE	MODIFY	NULL	InProcessingToShelvingCart | 	NULL 493438	2015-09-01 12:52:25	1	SYSTEMPREFERENCE	MODIFY	NULL	ReturnToShelvingCart | 	NULL
08:49 fraktik_              select * from action_logs where module not in ("CRONJOBS", "CIRCULATION", "FINES", "AUTHORITIES", "CATALOGUING", "HOLDS", "MEMBERS", "REPORTS", "SERIAL") AND (info like "%InProcessing%" OR info like "%Shelving%" OR info like "%ItemLocationOn%") limit 5000          gave me just 2 lines (from more then 2M) without any usable info
08:15 kohaputti             cait, oh yes, we had only couple new interested koha developers there
08:15 cait                  :)
08:15 cait                  with rest api etc.
08:14 cait                  hi kohaputti - i was expecting more beginner level patches - looked like you had fun diving into the deep end
08:14 cait                  _fraktik: glad to hear :)
08:08 _fraktik              ' to me.
08:08 _fraktik              Nope, Josef (Pepa - shorter) will be now invested even more in Koha and it's developement (at least I hope) - he is working on semi-national level now (and left 'county-level
08:07 cait                  i will spare you then :)
08:07 _fraktik              Yep, I expected that. I am born and raised in Czech Rep., but my german.... Ich habe Abitur in Deutsche sprache, aber ich sprache nicht... It was my main language in school (9y of GE in total) - but never properly used (and never much liked). So even when I lived in GE for a half a year and somebody spoke to me in german, I formulated answers in english and then tryed to "translate" them to the german...
08:04 cait                  just Katrin btw (much shorter)
08:03 cait                  do you know if Josef will be gone from Koha? He always was a gem on my QA team
08:03 davidnind[m]          hi _fraktik and welcome! Sounds like you have your hands full
08:03 cait                  i was wondering about your umlaut
08:03 cait                  welcome then :)
08:02 _fraktik              ... so I imagine I will be bothering you quite often (I am no programmer or developer myself, so I can help just with reporting, questions or testing - later on, now I am still quite bussy when I am trying to get to know whole ecosystem and same time process couple last libraries to the koha).
07:59 _fraktik              BTW: Hello Katherine, Hi David - let me introduce myself properly - I am replacement for Josef Moravec in Municipal Library Ústí nad Orlicí (CZ) - he went up in the chain to the bigger library and I was left here to fight my way trough those 3 local installations with cca 15 libraries (instances).
07:58 cait                  action_logs (with s)
07:58 cait                  try something like: select * from action_log where info like "prefname%"
07:57 cait                  so that shoudl show what it was before
07:57 cait                  everytime you set a pref int he gui it's logged
07:57 cait                  if you haven't taken measures to delete it - it shoudl all be stored in your action_log table
07:57 cait                  to find out your previous settings
07:56 cait                  oh i got an idea
07:56 cait                  hm
07:56 _fraktik              I will, just do not know what to fill there exactly - is there some config export script (or gui)? Or some default archive of configs (so I could report my old/new config)?
07:52 cait                  you could file a bug report maybe? we might be able to fix the update process or at least improve it to avoid the problem for others
07:52 cait                  _fraktik: sorry to hear that :(
07:51 cait                  hi davidnind[m] :)
07:50 davidnind[m]          hi cait!
07:50 _fraktik              will try to do it (not know what merge req. exactly mean yet, but i will learn) eventually . But for now I am more concerned with 2 weeks worth of books, which are both "in processing" AND in circulation. This "unchanged behaviour" did not worked in our case, obviously. :-(
07:50 davidnind[m]          _fraktik: a change was made yesterday to the manual yesterday for that bug, I'll double check it to make sure nothing was missed and reflects the updated release note (https://koha-community.org/manual/19.05/en/html/systempreferences.html#updateitemlocationoncheckin)
07:42 cait                  for the manual - you can file a documentation bug too - the manual team will try to get to it. or if you woudl like to you could do a merge request for the manual yourself.
07:41 cait                  the diea was 'unchanged behaviour' - this is always what we strive for
07:41 cait                  i hope i didn't miss anything there
07:41 cait                  hm i think there was an update i tested that should make it work like your prefs did before
07:34 _fraktik              c) at least informed admin about those prefs. getting obsolete (I am new local admin for our library and I do not have a clue what and how it was configured before...)
07:33 _fraktik              b) offer some interface for semi-automatic transposition
07:32 _fraktik              + would expect, that upgrade of koha would a) make some automatic basic transformation between InProcessingToShelvingCart, & ReturnToShelvingCart >> updateitemlocationoncheckin
07:30 _fraktik              https://koha-community.org/manual/19.05/en/html/cron_jobs.html?highlight=inprocessingtoshelvingcart
07:30 _fraktik              OK, thx. If I may, this change is not described correctly in manual everywhere yet, I think: https://koha-community.org/manual/19.05/en/html/administration.html?highlight=inprocessingtoshelvingcart
07:17 cait                  important woudl be that the pref description is correct
07:17 cait                  Text to go in the release notes:
07:17 cait                  the 'origin' of the problem was the false text in bugzilla - at the top on the right
07:16 cait                  so it's in a lot of places after generation
07:16 cait                  it's part of the Koha files, but also published on the website
07:16 cait                  it's done with a script
07:16 _fraktik              cait: I was not sure, if the page https://koha-community.org/koha-19-05-release/ is generated automaticaly from source patch releases or if someone assembled it manualy - thats why I am asking here...
07:14 cait                  _fraktik: not sure if we can fix the release notes after release, but if it's something in koha, please always report a new bug an dlink
07:13 huginn                Bug 14576: enhancement, P5 - low, ---, nick, RESOLVED FIXED, Allow automatic update of location on checkin
07:12 _fraktik              yep, i reported it to the original bugpage:  https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14576
07:11 cait                  should be 'updated to the right'
07:11 cait                  _fraktik: that definiteyl sounds like a typo
07:11 cait                  hi all
07:09 _fraktik              OK, so I see where is problem, just dont know where exactly report typo in release note:  "On check in the item’s location is compared to the location on the LEFT and, if it matches, is updated to the location on the LEFT."
07:05 alex_a                Bonjour
06:55 _fraktik              Do anyone know, where "InProcessingToShelvingCart" and "ReturnToShelvingCart" went in 19.05? Our newly created items are no longer automatically placed into our shelves on return and those values I can see in 18.05 installation, but not in new one.
06:53 _fraktik              what do you mean by itemstatus? table items have just "new_status" column, as far as I know.
06:44 magnuse               bonjour reiveune
06:40 reiveune              hello
06:34 saa                   in the query
06:34 saa                   can i also add itemstatus
06:33 _fraktik              saa:    update items set datelastborrowed="2019-09-09" from items i join TABLE_WITH_BARCODES_you_imported t ON t.YOUR_BARCODES_column_in_new_table=i.barcode where i.datelastborrowed>"2019-09-09"
06:28 * ashimema            pokes the translation managers about translate.koha-community.org
06:26 _fraktik              import it: https://www.google.com/search?client=firefox-b-d&q=mysql+import+csv or use some fancy command to work with local file: https://stackoverflow.com/questions/4562911/using-input-from-a-text-file-for-where-clause
06:25 _fraktik              are you able to get your barcode list into some table in database?
06:17 saa                   can u tell me how to do through sql
06:17 saa                   from koha tools is it possible
06:17 _fraktik              *access
06:16 _fraktik              saa: Maybe you can do it with batch tool, but if you do have acces to SQL: table "items", columns datelastborrowed or	datelastseen
06:00 wahanui               what's up, fridolin
06:00 fridolin              hi
05:57 saa                   ok
05:57 saa                   if yes how to do it
05:57 saa                   can i manually set date last seen for every item
05:57 davidnind[m]          would post on general mailing list if you you don't get any response on IRC
05:56 davidnind[m]          saa: reports re not my strong point, and I can't see your exact requirements in the reports library https://wiki.koha-community.org/wiki/SQL_Reports_Library#Inventory.2F_Shelflists
05:53 saa                   how to achieve this
05:53 saa                   we have lot of withdrawn titles and we have added those numbers in a text file but we donot want those withdrawn items to be listed in the report
05:52 saa                   is it possible to mark manually last seen items so that the report can be generated easily before the last seen date
05:52 saa                   i have a question for inventory how to filter out withdrawn titles from inventory report
05:38 _fraktik              https://translate.koha-community.org/ is down for some time?