Time  Nick          Message
00:43 mtompset      @seen rangi
00:43 huginn        mtompset: rangi was last seen in #koha 6 days, 3 hours, 20 minutes, and 25 seconds ago: <rangi> back, that took a lot longer than expected
00:44 mtompset      @seen aleisha
00:44 huginn        mtompset: aleisha was last seen in #koha 2 weeks, 1 day, 1 hour, 22 minutes, and 22 seconds ago: <aleisha> thanks cait
00:45 mtompset      @seen josef_moravec
00:45 huginn        mtompset: josef_moravec was last seen in #koha 11 hours, 38 minutes, and 26 seconds ago: <josef_moravec> by #koha
01:00 mtompset      Well, I guess 4 commits from 27 is squashed enough. :)
01:04 wizzyrea      mtompset: nz holiday season ^.^
01:05 mtompset      I saw the times, and figured as much.
01:06 mtompset      wizzyrea: So how did/are you spend/ing the holidays?
01:07 wizzyrea      in the sun, with my fam (kid, dog, hubs) eating ham and taking naps :)
01:13 mtompset      As compared to my freezing cold winter wonderland and feasting on diet approved food. :)
01:14 mtompset      But lots of family and more sleep for sure. :)
01:24 wizzyrea      summer xmas is where it's at ;)
01:47 mtompset      The holidays are where the family is. So, I'll take it regardless of seasonal weather. As long as I have my wife and son around. :)
01:48 mtompset      Please Filipinos rock Christmas starting as early as September 1. :)
01:55 wizzyrea      keke
03:37 mtompset      Happy New Year, wizzyrea_ aleisha :)
03:38 mtompset      Have a good day (24 hour period) and a happy new year, #koha wizzyrea_ aleisha  :)
06:56 magnuse       ~~~
07:40 reiveune      hello
07:40 wahanui       salut, reiveune
07:51 fridolin      hi ther
08:08 josef_moravec hello #koha
08:09 gaetan_B      hello
08:17 matts         hello #koha, happy new year :)
09:33 cait          hi all
09:34 josef_moravec hi cait
09:36 cait          hi josef_moravec
09:36 cait          taking a look at the patron form
09:36 cait          the email validation seems to be broken and passwords are suddenly mandatory
09:36 cait          even if not marked as such :(
09:37 cait          was checking the report from the mailing list
09:37 cait          i don't think any of that was intentional?
09:44 josef_moravec added by bug 18298
09:44 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18298 new feature, P5 - low, ---, jonathan.druart, Pushed to Master , Allow enforcing password complexity
09:48 josef_moravec looks like in opac it checks if mandatory, but in staff it is always required...
09:48 cait          i am filing bugs
09:49 cait          bug 19907
09:49 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19907 normal, P5 - low, ---, koha-bugs, NEW , Email validation on patron add/edit not working
09:49 cait          bug 19908
09:49 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19908 critical, P5 - low, ---, koha-bugs, NEW , Password should not be mandatory
09:51 cait          not sure what happened to the email validation - it appears ok in administration and there is no javascript error on the page
09:51 cait          btw josef_moravec++ thx for being such a qa master :)
09:53 josef_moravec cait: I am not master, I am still learning ;)
09:53 josef_moravec cait: there are some really hard patches in NQA queue, need to learn hard :D
09:55 cait          yeah true
09:56 cait          but you are ahead of me :)
09:56 cait          i spent yesterday fixing my kohadevbox, will hopefully get a bit further today :)
09:56 josef_moravec sometimes could be tricky, I know ;)
11:01 saa           we have some records which we need to update in koha with status written can we know in excel file which tags we need to add to get this status correctly updated when we do marc import which tags are essential while creating mrc file
11:01 saa           written off
11:02 josef_moravec Hi saa
11:02 saa           we wish to add status as written off for all the titles in excel
11:02 josef_moravec It depends on you mappings
11:03 josef_moravec by default it is 952$0
11:03 saa           i just need to knw which tags can be used so that all these titles will have status as written off after data import
11:03 josef_moravec see here the default item field mappings https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx)
11:03 saa           i used this but after import no item is added only record is added
11:04 saa           952$7 is also required or not
11:04 josef_moravec and do you have defined right library codes?
11:04 josef_moravec do you use default biblio framework they come with koha?
11:05 saa           yes
11:06 josef_moravec for anybody interested in testing ;) bug 19908
11:06 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19908 critical, P5 - low, ---, josef.moravec, Needs Signoff , Password should not be mandatory
11:11 josef_moravec saa: you can look at the marc record on manage staged records page for ensure they looks OK
11:11 josef_moravec What about the library codes? Do you have same codes in homebranch field of imported data and in koha?
11:14 saa           yes
11:14 saa           they are same
11:15 saa           here is are the tags i mapped 3, 040$c, 952$a, 952$b	245$a	942$c, 952$y	952$0	952$p	952$C	952$z
11:18 josef_moravec what is 952$C ? shouldn't it be small "c"?
11:18 saa           yes it is small
11:18 josef_moravec ok
11:19 saa           why is it nt updating items but only showing records
11:19 saa           i cleaned earlier batch which was imported
11:19 saa           do i need to do anything from terminal reindex clean batch
11:22 josef_moravec no, items in catalogue should be visible - and if it all works as expected, the records ar indexed in zebra during import
11:24 josef_moravec bug 19907
11:24 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19907 normal, P5 - low, ---, josef.moravec, Needs Signoff , Email validation on patron add/edit not working
12:23 tcohen        hi
12:23 wahanui       bidet, tcohen
12:24 tcohen        @wunder cordoba, argentina
12:24 huginn        tcohen: Error: No such location could be found.
12:48 oleonard      Hi all
13:01 magnuse       kia ora oleonard
13:02 oleonard      Hi magnuse. I submitted a patch updating the NORMARC editor plugins. I hope I didn't mess it up.
13:40 oleonard      Joubu around?
13:40 Joubu         hi oleonard
13:40 wahanui       hi dear loon
13:40 oleonard      Hi, about your comment on Bug 19560 -- changing the GET to POST for the delete action
13:40 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19560 normal, P5 - low, ---, jonathan.druart, Pushed to Stable , Unable to delete library when branchcode contains special characters
13:41 oleonard      It was not strictly necessary to fix the bug, obviously, so I can rework it. I was taught that as a general rule "destructive" actions should use POST
13:43 Joubu         oleonard: I have no idea why I wrote that actually
13:44 Joubu         https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=70162
13:44 Joubu         it was because of this ^
13:45 Joubu         oleonard: I think you can forget this comment for now :)
13:49 magnuse       kia ora nengard
13:49 nengard       happy new year magnuse
13:50 magnuse       oleonard: kewl! but our national library says normarc will be put to death this year, so please don't waste too much time on it :-)
13:50 magnuse       straight back atcha nengard!
13:51 oleonard      magnuse: One MARC format down, how many to go?
13:51 magnuse       oleonard: see also bug 18984
13:51 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18984 enhancement, P5 - low, ---, magnus, NEW , Remove support for NORMARC
13:51 magnuse       too many!
13:52 oleonard      @wunder 45701
13:52 huginn        oleonard: Error: No such location could be found.
13:52 oleonard      I miss huginn's weather reports!!
13:53 oleonard      I want to know in an instant how much colder it is here than it is where magnuse is!
13:54 magnuse       oleonard: https://www.yr.no/place/Norway/Nordland/Bod%C3%B8/Joveien/
13:54 fridolin      magnuse: whouuu big change, maybe UNIMARC will fall some day ;)
13:54 * cait        waves
13:54 cait          back - wet and all... now the sun is shining. of course.
13:54 oleonard      magnuse: https://www.wunderground.com/weather/us/oh/nelsonville/39.4594032%2C-82.23115349999999
13:56 fridolin      17°C here
13:56 fridolin      B)
13:57 kidclamp      -19°C here
13:57 kidclamp      almost the opposite
13:58 magnuse       kidclamp: that is cooold!
13:58 magnuse       (especially if there is wind and humidity too)
13:59 kidclamp      but a high of -4, so have that to look forward to
14:00 cait          we got a loooot of wind, not super cold tho
14:02 magnuse       cait: as in roofs blowing off houses and such?
14:02 cait          almost
14:08 * LeeJ        waves
14:08 LeeJ          hi #koha
14:46 cait          hey all, can we get sign offs for bug 19906 and bug 19907 please?
14:46 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19906 enhancement, P5 - low, ---, oleonard, Needs Signoff , Move template JavaScript to the footer: NORMARC editor plugins
14:46 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19907 normal, P5 - low, ---, josef.moravec, Needs Signoff , Email validation on patron add/edit not working
14:46 cait          hm
14:46 cait          the first was wrong
14:46 cait          19908
14:47 cait          bug 19908
14:47 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19908 critical, P5 - low, ---, josef.moravec, Needs Signoff , Password should not be mandatory
14:47 cait          broken behaviour when adding patrons on stable branches...
15:31 Joubu         David Gustafsson, around?
15:36 reiveune      bye
17:08 josef_moravec bye #koha
17:58 tcohen        gnucifer
17:58 tcohen        ?
18:31 greenjimll    cait: as bug 19908 seems to have a problem with second entry of the password, should testing of bug 19907 wait (as it depends on 19908)?
18:31 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19908 critical, P5 - low, ---, josef.moravec, Failed QA , Password should not be mandatory
18:31 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19907 normal, P5 - low, ---, josef.moravec, Needs Signoff , Email validation on patron add/edit not working
18:36 Joubu         greenjimll: yes
18:37 greenjimll    OK, I'll stop playing with it. :-)
18:52 bag           hiya all
18:53 sen           hiya bag
18:53 LeeJ          hi bag
18:54 bag           heya!
18:54 LeeJ          bag: happy new year
18:54 bag           happy new year!  Or in german - Gutes Neues Jahr!
18:54 * bag         just learned that from cait
18:56 LeeJ          #funfactoftheday
18:57 cait          hehe :)
19:04 magnuse       bag: HI
19:04 wahanui       bonjour, magnuse
19:05 bag           magnuse: knuckles!!!
19:05 magnuse       yeah!
19:23 mtompset      Greetings, #koha.
19:24 bag           hi mtompset
19:24 mtompset      Anyone recall a bugzilla patch related to "DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails at /usr/share/perl5/DBIx/RunSQL.pm line 273." on a web install after dumping the kohadevbox db?
19:29 mtompset      Attempting a reset_all
19:31 mtompset      nevermind... found a bug in a my rebase.... I think that might be it.
19:43 LeeJ          hi mtompset
19:48 mtompset      Greetings, LeeJ
19:48 mtompset      Happy New Year, if I haven't wished it to you already. :)
20:02 pastebot      "mtompset" at 127.0.0.1 pasted "tcohen: Is this installed by default on the kohadevbox?" (1 line) at http://paste.koha-community.org/122
20:07 LeeJ          mtompset: no..whenever I spin up a fresh devbox I always have to install it
20:08 mtompset      Sounds like an issue for the kohadevbox
20:08 cait          it's not usually installed
20:08 cait          might be more 'realistic'?
20:09 Joubu         version of this module has been upgraded recently
20:09 Joubu         WebService::ILS::OverDrive I mean
20:09 LeeJ          cait: well out of a fresh spin up, the full tests fail on Patrons/OverDrive
20:09 Joubu         LeeJ: cpanm WebService::ILS::OverDrive
20:10 LeeJ          Joubu: I know :) just something I noticed in fresh boxes
20:10 LeeJ          Joubu: happy new year btw
20:11 mtompset      I take a longer route: cpan2deb WebService::ILS::OverDrive and then sudo dpkg -i  libwebservice-ils-perl_0.17-1_all.deb
20:12 Joubu         yes definitely better
20:12 mtompset      Yes, Bonne Année!
20:13 mtompset      I like the fact that if it ever hits default repos, then it will upgrade without my intervention. :)
20:17 rangi         hmm i dont think i like release, i think i like released
20:17 rangi         ahh i see Joubu has already covered that
20:18 cait          ah, did I get it wrong?
20:18 rangi         released makes sense
20:18 rangi         Announcing the Koha 16.11.15 release
20:18 rangi         would too
20:18 cait          still says release here? https://koha-community.org/
20:18 rangi         mine will say released
20:18 cait          the emails said released
20:18 rangi         yeah
20:19 rangi         released is more grammatically correct
20:19 cait          ok, i will change the wiki
20:19 rangi         thanks
20:19 cait          Joubu: ^
20:20 Joubu         rangi: The email subjects say "Koha XXX released", but the url and blog post title say "release"
20:21 rangi         yep, we should standardise on released
20:21 Joubu         we could change, but will need to redirect
20:21 rangi         leave it for now
20:21 rangi         just in future
20:21 Joubu         k
20:23 rangi         LeeJ: are you about?
20:23 LeeJ          rangi: mhm
20:24 rangi         what's your gitlab username?
20:24 LeeJ          uhh..one sec
20:25 LeeJ          rangi: looks to be ldjamison
20:26 rangi         you should get an email in a min or so
20:27 LeeJ          rangi: okay!
20:28 LeeJ          rangi: hari hou tau btw :)
20:28 magnuse       oops, i made a plugin for showing counters of things going on in the library: https://counters.test.bibkat.no/ work in progress...
20:28 cait          :)
20:28 rangi         LeeJ: https://gitlab.com/koha-community-devs-users/kohadocs  you should now have master access
20:28 rangi         LeeJ: ngā mihi o tau hou ki a koe hoki
20:29 rangi         LeeJ: in te reo māori adjectives always come after the noun, so tau hou, not hou tau (useless trivia for the day)
20:29 cait          :)
20:29 cait          like spanish i think?
20:30 rangi         magnuse: very cool!
20:30 rangi         magnuse: did i show you grafana yet?
20:30 LeeJ          magnuse++
20:30 cait          magnuse: make sure to add it to the wiki :)
20:31 magnuse       rangi: grafana - don't think so
20:31 magnuse       thanks
20:31 cait          magnuse: where d o the counts show?
20:31 LeeJ          cait: click the link in the middle
20:31 magnuse       there is a bold link to them on the front page
20:32 magnuse       you could put that up on a screen in the library or something
20:32 cait          oh ooops
20:32 cait          neat :)
20:32 * LeeJ        is excited to have magnuse working on plugins with the rest of us crazy folks :D
20:33 magnuse       yeah, i'm pretty excited by the plugins :-)
20:34 * mtompset    scrolled back and looked at links.
20:34 rangi         magnuse: https://grafana.com/
20:34 mtompset      Released is better. "Koha YY.MM.RR Released"
20:35 mtompset      (I capitalized, because it seems like a title to me)
20:35 rangi         magnuse: it can hook straight into the db
20:35 magnuse       rangi: ah yes, i have been playing a bit with that.
20:35 magnuse       oh, cool?
20:36 rangi         yeah so you can have a dashboard that real time reports from the db
20:36 magnuse       i have been using prometheus and parts of the elastic stack (beats etc)
20:36 magnuse       Very Cool!
20:36 magnuse       any special tricks for talking to mysql/maria?
20:36 LeeJ          magnuse: it's so pretty :')
20:36 rangi         nope
20:37 rangi         http://mit-admin.mykoha.co.nz:8080/superset/dashboard/koha/
20:37 LeeJ          magnuse: I've been afk from here for a while because I've been working on a plugin myself...it's an addiction but a useful one at that :)
20:37 rangi         http://mit-admin.mykoha.co.nz:8080/databaseview/show/2
20:38 cait          requires login
20:38 rangi         yep
20:38 magnuse       superset != gafana?
20:38 magnuse       *grafana
20:39 rangi         yup
20:39 rangi         oh i lie
20:39 rangi         no superset is better :) superset is the one airbnb made
20:39 rangi         i did have grafana
20:39 rangi         http://airbnb.io/projects/superset/
20:40 rangi         i switched to superset because you can set it up to talk to the db really easy
20:40 rangi         and with the SQL Lab
20:40 rangi         you can pretty much cut and paste any of our reports
20:41 cait          hm but you have to allow a third party thing sql access?
20:41 rangi         its not third party
20:41 cait          oh you can run it yourself?
20:41 rangi         its sitting on the same server
20:41 cait          that's cool then :)
20:41 rangi         yes
20:42 cait          could it be used for multiple instances?
20:42 rangi         yes
20:42 rangi         you can have multiple databases defined
20:42 * magnuse     wants to explore superset
20:43 rangi         and can give users access to certain ones
20:43 cait          neat
20:43 cait          what about the reports?
20:43 rangi         what reports?
20:43 wahanui       reports is probably http://wiki.koha-community.org/wiki/SQL_Reports_Library
20:43 rangi         http://mit-admin.mykoha.co.nz:8080/superset/sqllab
20:43 rangi         there?
20:43 wahanui       it has been said that there is one... but i don't know it
20:44 cait          set up one sql for multiple
20:44 rangi         search across multiple db at once?
20:44 rangi         or have a dashboard that displays them all?
20:44 rangi         the second one, yep, easy
20:44 rangi         the first one, nope, that would be madness
20:45 rangi         you create slices, then you can add them to your dashboard
20:45 cait          just add one report accessible to multiple
20:45 cait          for their own db :)
20:45 rangi         you'd have to create one per dbd
20:45 cait          ah ok
20:45 cait          maybe could be done with a script or so
20:45 rangi         because they could only see theirs
20:52 Joubu         @later tell oleonard for 19243 I actually need an id like delete_$branchcode on the submit button to find it easily, would it make sense to you?
20:52 huginn        Joubu: The operation succeeded.
20:57 Joubu         @later tell tcohen koha-testing-docker, COVERAGE check is still missing on 16.11
20:57 huginn        Joubu: The operation succeeded.
20:58 Joubu         @later tell tcohen maybe we said we do not care last time we talked about!
20:58 huginn        Joubu: The operation succeeded.
21:17 eythian       cait: http://www.bbc.com/travel/story/20180102-how-sausage-flavours-the-german-language
21:32 jenkins       Project Koha_16.11_D8 build #95: SUCCESS in 2 hr 4 min: https://jenkins.koha-community.org/job/Koha_16.11_D8/95/
21:32 jenkins       * Jonathan Druart: Bug 19568: Escape url params with url filter - opac-opensearch.tt
21:32 jenkins       * Jonathan Druart: Bug 19569: Set X-Frame-Options=SAMEORIGIN - opac-showmarc.ok
21:32 jenkins       * Jonathan Druart: Bug 19570: Add autocomplete='off' for login forms at the opac
21:32 jenkins       * mtompset: Bug 19570: Add autocomplete to opac-main as well
21:32 jenkins       * kyle: Bug 19319: Reflected XSS Vulnerability in opac-MARCdetail.pl
21:32 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19568 is not accessible.
21:32 jenkins       * m.de.rooy: Bug 19319: (QA follow-up) Biblionumber leftovers in opac-detail.tt
21:32 jenkins       * Jonathan Druart: Bug 19319: Only fetch the record if it exists
21:32 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19569 is not accessible.
21:32 jenkins       * amit.gupta: Bug 19611: Fix XSS Flaws in supplier.pl
21:32 jenkins       * amit.gupta: Bug 19612: Fix XSS in members/memberentry.pl
21:32 jenkins       * amit.gupta: Bug 19614: Fix XSS in members/pay.pl
21:32 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19570 is not accessible.
21:32 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19319 is not accessible.
21:32 jenkins       * katrin.fischer: Bug 19796 - Fix doubled up subscription info on OPAC detail page
21:32 jenkins       * chrisc: Bumping version number for 16.11.15 release
21:32 jenkins       * root: Translation updates for Koha 16.11.15
21:32 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19611 is not accessible.
21:32 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19612 is not accessible.
21:32 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19614 is not accessible.
21:32 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19796 trivial, P5 - low, ---, katrin.fischer, Pushed to Stable , [16.11] Subscription info appears doubled up on OPAC detail page
21:32 cait          eythian: you seem strangely obsessed with things german
22:06 JesseM        wonder06614
22:06 bag           I think it’s wunder
22:06 bag           wunder 06614
22:07 bag           @wunder 06614
22:07 huginn        bag: Error: HTTP Error 404: Not Found
22:07 bag           ooohhh JesseM broke it!
22:07 cait          it's not been working for a while
22:07 cait          :(
22:07 JesseM        :(
22:07 bag           darn JesseM broke it that long ago?
22:08 bag           JesseM++
22:08 JesseM        lol
22:08 cait          hm guess so :)
23:35 jenkins       Project Koha_16.11_D8 build #96: SUCCESS in 2 hr 2 min: https://jenkins.koha-community.org/job/Koha_16.11_D8/96/
23:35 jenkins       * gonzalez: Translation updates for Koha 16.11.15
23:35 jenkins       * chrisc: Release notes for 16.11.15
23:35 mtompset      @wunder toronto
23:35 huginn        mtompset: Error: HTTP Error 404: Not Found