Time Nick Message
01:07 kidclamp @later tell fridolin bug 20546
01:07 huginn` kidclamp: The operation succeeded.
02:22 wizzyrea can someone confirm for me, in 18.05, does the item circulation history show the borrower names for you?
03:10 wizzyrea @later tell cait i've added a page for KohaCon18 but it currently has really limited content - it'd be good if someone could add that.
03:10 huginn` wizzyrea: The operation succeeded.
05:18 jenkins Project Koha_17.11_D8 build #55: FAILURE in 26 sec: https://jenkins.koha-community.org/job/Koha_17.11_D8/55/
05:18 jenkins Jonathan Druart: Bug 20685: Escape letter template content in textarea
05:18 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20685 normal, P5 - low, ---, jonathan.druart, Pushed to Stable , Modify letter template does not render correctly
06:26 reiveune hello
06:33 marcelr hi #koha
06:36 calire morning #koha
06:36 marcelr hi calire
06:40 calire hey marcelr :)
06:59 calire does anyone know if the renewal date of a patron is stored in the database anywhere?
07:01 marcelr calire: what about date_renewed
07:02 calire marcelr in borrowers? I don't see it
07:02 marcelr yeah in borrowers
07:02 calire did it exist in 16.11 already?
07:02 marcelr not sure in master now
07:02 calire ok
07:02 marcelr but i guess it should
07:02 calire I couldn't see it in the schema
07:03 marcelr you can find it by renewal but with renew
07:03 marcelr a versus e
07:03 marcelr can = cant
07:04 calire it only appears in teh schema from 17.11
07:04 marcelr ok
07:04 calire thanks anyway :(
07:04 marcelr maybe it was renamed?
07:06 calire I checked throug the fields a lot before I asked, just in case and didn't see anything obvious, only the dateenrolled and dateexpiry
07:06 calire seems odd to not have it
07:07 marcelr yeah expiry and renewed are more or less the same
07:08 marcelr renewed is the past expiry date
07:08 calire yes
07:08 marcelr so we did the job in the past with only dateexpiry
07:08 marcelr there is a pref that impacts those dates
07:10 calire bug 6758
07:10 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6758 enhancement, P5 - low, ---, kyle, RESOLVED FIXED, Capture membership renewal date for reporting purposes
07:11 marcelr must be the one 17.11
07:11 calire yeah
07:11 marcelr hmm i even signed off..
07:11 marcelr :)
07:11 marcelr seen too much patches
07:11 calire :D
07:12 calire I lose track of what is old and what is new if I spend time on master
07:12 marcelr yeah
07:14 marcelr hi cait
07:37 ashimema mornin' #koha
07:46 cait hi marcelr and ashimema
07:46 cait marcelr++ and jajm++
07:46 marcelr cait++ ashimema++
07:46 marcelr jajm++
07:47 marcelr calire++
07:47 marcelr no one forgotten? :)
07:48 ashimema lol
07:49 marcelr ashimema: please let me know when you run out of plusses
07:49 marcelr is that english?
07:49 marcelr pluses
07:49 ashimema yup.. though I'm actually not sure of the plural of plus myself there.. doesn't look right
07:50 ashimema lol.. looks like pluses and plusses are both valid..
07:50 marcelr strange that the plural of plus gives so much trouble
07:50 * ashimema goes in search of the difference
07:50 marcelr dont bother ;)
07:51 marcelr if one should have a plural, it should be plus
07:51 marcelr plus++
07:51 ashimema single s seems to be more widely accepted..
07:51 ashimema so `pluses`
07:51 marcelr the other one is the french form (no offense)
07:52 ashimema english is a mongral language.. we steal from everyone ;)
07:52 marcelr mongral
07:52 marcelr learned a new word
07:53 ashimema `a dog of no definable type or breed`
07:53 magnuse isn't that mongrel?
07:53 marcelr QA term? your code is somewhat mongral ? probably not
07:53 ashimema hehe.. I like that word.. that's the literal meaning but we use it to basically mean 'a thing without known parentage'
07:54 ashimema ack.. lol.. I can't spell today
07:54 ashimema it is indeed `e`
07:55 ashimema i.e. English is a mongrel language because it's not pure.. we borrow from all sorts of other languages without any real care as to where it came from.
07:55 ashimema marcelr++
07:57 cait @later tell wizzyrea could we link directly to the conference website maybe? I think maintaining 2 while it's not done yet probably makes not much sense
07:57 huginn` cait: The operation succeeded.
08:01 marcelr @later tell kidclamp please push 20866 (seeing these fails now and again :)
08:01 huginn` marcelr: The operation succeeded.
08:10 ashimema So.. whose going to KohaCon18.. I'm weighting up which of the next Marseille Hackfest, KohaCon and YAPC::EU I go to this year... would love to do all three but don't think I'd get that pass the boss man (or the other half 😉)
08:10 calire me
08:15 ashimema @later tell kidclamp sorry I missed dani yesterday :(
08:15 huginn` ashimema: The operation succeeded.
08:16 magnuse my colleague petter is going to kohacon18, but not me. we both plan to go to marseille in 2019 if they will have us. and if sweden gets kohacon19 we will both go there
08:24 marcelr isnt kohacon19 going to New Zealand for the 20 years ?
08:25 ashimema I thought that was 2020
08:28 marcelr ok maybe i am mistaken
08:28 marcelr yapc Rescuing a Legacy Codebase
08:29 marcelr glasgow should be close to you
08:30 ashimema well.. allot closer than the US ;)
08:47 marcelr anyone able to see if t/db_dependent/Koha/Patrons/Import.t also has 58 failing tests of 124 ?
08:55 ashimema er.. what koha version.. master?
08:55 * ashimema is currently working through the failing tests for D9 18.05.x branch.. bloomin dbi numberic precision changes
08:56 ashimema but D8 all tests are passing for me.
09:02 marcelr master
09:02 marcelr will create a new fresh db
09:15 ashimema using devbox marcelr? The reset_all is a lovely command:)
09:15 magnuse tcohen++
09:16 marcelr no devbox now
09:34 marcelr @later tell kidclamp we also need the fix for Upload.t on bug 20727
09:34 huginn` marcelr: The operation succeeded.
09:35 marcelr @later tell Joubu could you please finish QA on 20727 ?
09:35 huginn` marcelr: The operation succeeded.
10:04 eythian cait: google reminded me that this was 6 years ago today: https://photos.app.goo.gl/xgbuSj9YjE8qbmZI3
10:05 eythian ^-- also rangi
10:08 * ashimema was there too
10:11 marcelr anyone willing to fix bug 20901 and 20902 is welcome
10:11 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20901 normal, P5 - low, ---, chris, NEW , Koha/Patrons/Import.t fails on fresh database
10:11 marcelr have to go now; bye #koha, will be afk 3w
10:19 * kidclamp waves
10:19 ashimema :)
11:41 oleonard Hi #koha
11:50 calire hi oleonard
11:53 oleonard @later tell Joubu I think 20468 is good. We should consider highlighting the rows affected, but that can be a follow-up
11:53 huginn` oleonard: The operation succeeded.
13:06 Joubu hi #koha
13:06 oleonard Hi Joubu
13:08 caroline Hi Joubu!
13:08 calire hi Joubu
13:10 Joubu tcohen: Are we going to have a Koha_Master_D9?
13:11 ashimema I think he was intending on it Joubu
13:11 ashimema but hasn't got there yet..
13:12 ashimema I've donated a server for extra Jenkins capacity so we should be able to do it.. but he's not gone on there yet to set it all up (and I've not yet worked through it either.. but me doing it would take significantly longer anyways)
13:12 ashimema I've = PTFS Europe in that context.. ;)
13:13 ashimema man running db_dependant/00-strict.t takes ages :(
13:20 clrh I got a small and dirty poc with sparql and wikidata on a opac-detail page - I would like to share to have feedback, does someone interested ? (planning to do the same with data.bnf after) it is not production ready, what is the best way ? bz named "poc" ? gitcrosoft? biblibre repo ?
13:22 tcohen morning
13:22 tcohen Joubu: there's already Koha_Master_D9
13:24 ashimema is there.. where?
13:24 tcohen ashimema: D9 is there since yesterday
13:24 ashimema just not been built since it was added?
13:25 tcohen ah
13:25 tcohen Master
13:25 tcohen :-D
13:25 tcohen yes, I will add it
13:25 oleonard clrh: I vote Bugzilla
13:25 tcohen sorry for the confusion
13:25 ashimema https://jenkins.koha-community.org/view/all/builds was looking there
13:25 tcohen I will add D9 and U1804
13:26 tcohen I'm trying to find the best way to do it without needing to add many tasks in jenkins (all basically the same)
13:26 clrh thanks for feedback oleonard
13:27 ashimema :)
13:27 ashimema Well.. I'm still working through fixing the test failures for D9 at the minute.. been a bust few days here so haven't been able to give it my full attention :(
13:27 ashimema I imagine master will fail on the same issues.
13:28 Joubu clrh: you can also fork gitlab.com/koha-community/koha ;)
13:29 Joubu but it's always better to submit on bugzilla if there are no thousands of patches
13:29 clrh Joubu: oh :)
13:30 clrh Joubu: ok first step on bugzilla and if more, then fork on gitlab :)
13:41 jenkins Yippee, build fixed!
13:41 jenkins Project Koha_17.11_D8 build #56: FIXED in 33 min: https://jenkins.koha-community.org/job/Koha_17.11_D8/56/
13:49 huginn` News from kohagit: Bug 2426: DBRev 18.06.00.002 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3f01fcae9723edf0485f431878a34551e814090a>
13:49 huginn` News from kohagit: Bug 20120: (QA follow-up) display correct amount in redirect <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=20bd2d2bd50e4e8b4f8b40e7d1df521a0e01bc09>
13:49 huginn` News from kohagit: Bug 20889: Prevent not for loan items to be checked out <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6049836023be61771c25fe038f02378ede96fff5>
13:49 huginn` News from kohagit: Bug 20889: Add tests - not for loan items cannot be checked out <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=326aa0667d86dc8c0d8a8becf440bfb25d2c76c1>
13:49 huginn` News from kohagit: Bug 20886: Do not cast undef to 0 (TO_JSON) <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=2529a218eef278278bc6bfbfe28267b4acbf9c17>
13:49 huginn` News from kohagit: Bug 20877: Do not consider DB user has permissions <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=421746dd6337814f96adc6d79a773a2a23f50556>
13:49 huginn` News from kohagit: Bug 20778: (bug 19777 follow-up) Fix subscription deletion <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d86ff0f5db72a1291958458e07ac7d9868ac4ac0>
13:49 huginn` News from kohagit: Bug 20875: (bug 16735 follow-up) Fix library list for OpacAddMastheadLibraryPulldown <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f8ea20344b931bb92e6b48639ae626f604853ffe>
13:49 huginn` News from kohagit: Bug 18821: (QA follow-up) Last tweaks for performance <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3d68ab447eda3eb5a25444b1ceaeea96b446c64b>
13:49 huginn` News from kohagit: Bug 20851: Add module to circ/article-request-slip.pl <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6650c7efb41072a2937bfb6ce90ef08f5c442066>
13:49 huginn` News from kohagit: Bug 20829: Handle non-existent barcode when linking to host item <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=564e9ce1ee4fbaa4a52bccd3f087abfafb69d985>
13:49 huginn` News from kohagit: Bug 18821: Convert to using cache with date checking <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=495512f6eacdc306932290784cca4e5d01a053f9>
13:49 huginn` News from kohagit: Bug 2426: Remove deprecated management permission <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=870913b3c3a83568c219d6e22b7110ffd217370c>
13:49 huginn` News from kohagit: Bug 20756: Compiled CSS <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f7176c356de79ef76e9191be4c822ffb5adb622d>
13:49 huginn` News from kohagit: Bug 20756: OPAC "Share list" button should be styled with an icon <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=cbb5207c1cc5f196ad2682a24ae1db7fb9301876>
13:49 huginn` News from kohagit: Bug 18821: TrackLastPatronActivity is a performance killer <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6491ba0233ac019614487efafef6e35c9ffef6eb>
13:49 huginn` News from kohagit: Bug 20120: force scalar context for CGI->param <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=11223294b6167822708893dbde3ff84d55155b69>
13:49 huginn` News from kohagit: Bug 20700: MARC21 add/update leader/007/008 codes <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=eeeb15c8f8db59c36108110a417b132a5d8bab85>
13:49 huginn` News from kohagit: Bug 20053: Drop type attribute "text/javascript" in OPAC templates <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3e91d99a15f5882312378a06af4851cbb4237ef8>
13:49 huginn` News from kohagit: Bug 20120: (QA follow-up) Pass on_editing parameter for Price plugin <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d4cf19ac04ce49cc980cdf88dfa351b3c7740130>
13:49 huginn` News from kohagit: Bug 20120: Prevent writeoffs of more than the amount owed for a fee <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=515cab0c46467efbdcb7e4cbbac7ccdb38e8845a>
13:54 jenkins Project Koha_Master_D8 build #498: FAILURE in 1 min 49 sec: https://jenkins.koha-community.org/job/Koha_Master_D8/498/
13:54 jenkins * Jonathan Druart: Bug 20866: Make ArticleRequests.t pass even if table is not empty
13:54 jenkins * m.de.rooy: Bug 20866: (QA follow-up) Use build_object and remove two tests
13:54 jenkins * Jonathan Druart: Bug 20889: Add tests - not for loan items cannot be checked out
13:54 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20866 normal, P5 - low, ---, jonathan.druart, Pushed to Master , ArticleRequests.t fails on existing requests
13:54 jenkins * Jonathan Druart: Bug 20889: Prevent not for loan items to be checked out
13:55 jenkins * kyle: Bug 18821: TrackLastPatronActivity is a performance killer
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20889 critical, P5 - low, ---, jonathan.druart, Passed QA , Items marked as not for loan can be checked out
13:55 jenkins * kyle: Bug 18821: Convert to using cache with date checking
13:55 jenkins * m.de.rooy: Bug 18821: (QA follow-up) Last tweaks for performance
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18821 major, P5 - low, ---, kyle, Passed QA , TrackLastPatronActivity is a performance killer
13:55 jenkins * Jonathan Druart: Bug 20877: Do not consider DB user has permissions
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20877 is not accessible.
13:55 jenkins * Jonathan Druart: Bug 20875: (bug 16735 follow-up) Fix library list for
13:55 jenkins * kyle: Bug 20120: Prevent writeoffs of more than the amount owed for a fee
13:55 jenkins * kyle: Bug 20120: (QA follow-up) Pass on_editing parameter for Price plugin
13:55 jenkins * Jonathan Druart: Bug 20120: force scalar context for CGI->param
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20875 major, P5 - low, ---, jonathan.druart, Passed QA , OpacAddMastheadLibraryPulldown displays an empty list
13:55 jenkins * Nick Clemens: Bug 20120: (QA follow-up) display correct amount in redirect
13:55 jenkins * katrin.fischer: Bug 2426: Remove deprecated management permission
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16735 enhancement, P5 - low, ---, kyle, RESOLVED FIXED, Replace existing library search groups functionality with the new hierarchical groups system
13:55 jenkins * Nick Clemens: Bug 2426: DBRev 18.06.00.002
13:55 jenkins * Jonathan Druart: Bug 20829: Handle non-existent barcode when linking to host item
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20120 normal, P5 - low, ---, kyle, Passed QA , Prevent writeoffs of more than the amount owed for a fee
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2426 normal, P3, ---, katrin.fischer, Passed QA , Management permissions is deprecated
13:55 jenkins * oleonard: Bug 20053: Drop type attribute "text/javascript" in OPAC templates
13:55 jenkins * Jonathan Druart: Bug 20778: (bug 19777 follow-up) Fix subscription deletion
13:55 jenkins * Jonathan Druart: Bug 20886: Do not cast undef to 0 (TO_JSON)
13:55 jenkins * gonzalez: Bug 20700: MARC21 add/update leader/007/008 codes
13:55 jenkins * oleonard: Bug 20756: OPAC "Share list" button should be styled with an icon
13:55 jenkins * oleonard: Bug 20756: Compiled CSS
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20829 normal, P5 - low, ---, jonathan.druart, Passed QA , 'Link to host item' gives internal server error
13:55 jenkins * m.de.rooy: Bug 20851: Add module to circ/article-request-slip.pl
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20053 normal, P5 - low, ---, indradg, Passed QA , Drop type attribute "text/javascript" for <script> elements used in OPAC templates
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20778 normal, P5 - low, ---, jonathan.druart, Passed QA , Unable to delete a subscription
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19777 enhancement, P5 - low, ---, oleonard, RESOLVED FIXED, Move template JavaScript to the footer: Serials, part 3
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20886 normal, P5 - low, ---, jonathan.druart, Pushed to Master , Koha::Object::TO_JSON indiscriminately casting to integer
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20700 trivial, P5 - low, ---, bgkriegel, Pushed to Master , Update MARC21 leader/007/008 codes
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20756 trivial, P5 - low, ---, oleonard, Pushed to Master , OPAC "Share list" button should be styled with an icon
13:55 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20851 trivial, P5 - low, ---, m.de.rooy, Pushed to Master , Missing module in circ/article-request-slip.pl
14:02 tcohen kidclamp, Joubu: I'm taking a look
14:03 kidclamp thanks tcoehn
14:03 tcohen its me :-D
14:03 tcohen we removed —use-memcached and the docker image is still using it
14:03 Joubu it's always you
14:04 tcohen yeah, maybe I'd better quit right?
14:04 oleonard kidclamp++
14:04 kidclamp heh, I am stepping out while you fix it, back in a bit
14:04 Joubu tcohen: ;)
14:04 Joubu tcohen: we should actually exit on error
14:04 tcohen is that a yes???
14:05 Joubu you know me, you know my answer
14:05 tcohen set -e?
14:06 Joubu es
14:06 Joubu yes
14:25 ashimema bug 20906
14:25 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20906 normal, P5 - low, ---, martin.renvoize, Needs Signoff , Fix Debian 9 Test Failures
14:26 ashimema woop woop, my todoist to community git watcher works a charm.. you just filled up my todo list @kidclamp
14:27 ashimema hey tcohen.. should WebService::ILS::OverDrive be missing from KohaDevBox?
14:27 ashimema or is that just an oversight somewhere?
14:28 tcohen it should be there
14:29 ashimema hmm
14:29 tcohen oversight
14:29 tcohen probably
14:29 ashimema db_dependant/00_strict.t fails because it's missing in both D8 and D9 untill I cpanm it.
14:29 ashimema interesting
14:30 cait eythian: I think you send me that pic every year.... but it's also fun to see it every year :)
14:30 tcohen ashimema: Youtube::Downloader::Something
14:30 tcohen is also missing
14:31 tcohen it would be great that Webservice::ILS was already packaged
14:31 * LeeJ waves
14:31 LeeJ hi #koha
14:31 tcohen #endmeeting
14:31 tcohen hi LeeJ
14:31 LeeJ #tcohenismean
14:31 tcohen :-D
14:33 ashimema lol
14:33 * ashimema sends tcohen cookies
14:34 LeeJ so I'm working on my closed stacks project and to prepare for the eventual removal of the C4 namespace, can someone point me in the direction of how to use the Koha schema results call/something similar so I could (for example) get biblio information (author, title, callnumber) from a barcode?
14:46 Joubu Koha::Items->find({barcode => $barcode})->biblio->title;
14:50 jenkins Project Koha_Master_D8 build #499: UNSTABLE in 41 min: https://jenkins.koha-community.org/job/Koha_Master_D8/499/
14:50 jenkins * Jonathan Druart: Bug 20866: Make ArticleRequests.t pass even if table is not empty
14:50 jenkins * m.de.rooy: Bug 20866: (QA follow-up) Use build_object and remove two tests
14:50 jenkins * Jonathan Druart: Bug 20889: Add tests - not for loan items cannot be checked out
14:50 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20866 normal, P5 - low, ---, jonathan.druart, Pushed to Master , ArticleRequests.t fails on existing requests
14:50 jenkins * Jonathan Druart: Bug 20889: Prevent not for loan items to be checked out
14:50 jenkins * kyle: Bug 18821: TrackLastPatronActivity is a performance killer
14:50 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20889 critical, P5 - low, ---, jonathan.druart, Pushed to Master , Items marked as not for loan can be checked out
14:50 jenkins * kyle: Bug 18821: Convert to using cache with date checking
14:50 jenkins * m.de.rooy: Bug 18821: (QA follow-up) Last tweaks for performance
14:50 jenkins * Jonathan Druart: Bug 20877: Do not consider DB user has permissions
14:50 jenkins * Jonathan Druart: Bug 20875: (bug 16735 follow-up) Fix library list for
14:50 jenkins * kyle: Bug 20120: Prevent writeoffs of more than the amount owed for a fee
14:50 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18821 major, P5 - low, ---, kyle, Pushed to Master , TrackLastPatronActivity is a performance killer
14:50 jenkins * kyle: Bug 20120: (QA follow-up) Pass on_editing parameter for Price plugin
14:50 jenkins * Jonathan Druart: Bug 20120: force scalar context for CGI->param
14:50 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20877 is not accessible.
14:50 jenkins * Nick Clemens: Bug 20120: (QA follow-up) display correct amount in redirect
14:50 jenkins * katrin.fischer: Bug 2426: Remove deprecated management permission
14:50 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20875 major, P5 - low, ---, jonathan.druart, Pushed to Master , OpacAddMastheadLibraryPulldown displays an empty list
14:50 jenkins * Nick Clemens: Bug 2426: DBRev 18.06.00.002
14:50 jenkins * Jonathan Druart: Bug 20829: Handle non-existent barcode when linking to host item
14:50 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16735 enhancement, P5 - low, ---, kyle, RESOLVED FIXED, Replace existing library search groups functionality with the new hierarchical groups system
14:50 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20120 normal, P5 - low, ---, kyle, Pushed to Master , Prevent writeoffs of more than the amount owed for a fee
14:50 jenkins * oleonard: Bug 20053: Drop type attribute "text/javascript" in OPAC templates
14:50 jenkins * Jonathan Druart: Bug 20778: (bug 19777 follow-up) Fix subscription deletion
14:50 jenkins * Jonathan Druart: Bug 20886: Do not cast undef to 0 (TO_JSON)
14:50 jenkins * gonzalez: Bug 20700: MARC21 add/update leader/007/008 codes
14:50 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2426 normal, P3, ---, katrin.fischer, Pushed to Master , Management permissions is deprecated
14:51 jenkins * oleonard: Bug 20756: OPAC "Share list" button should be styled with an icon
14:51 jenkins * oleonard: Bug 20756: Compiled CSS
14:51 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20829 normal, P5 - low, ---, jonathan.druart, Pushed to Master , 'Link to host item' gives internal server error
14:51 jenkins * m.de.rooy: Bug 20851: Add module to circ/article-request-slip.pl
14:51 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20053 normal, P5 - low, ---, indradg, Pushed to Master , Drop type attribute "text/javascript" for <script> elements used in OPAC templates
14:51 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20778 normal, P5 - low, ---, jonathan.druart, Pushed to Stable , Unable to delete a subscription
14:51 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19777 enhancement, P5 - low, ---, oleonard, RESOLVED FIXED, Move template JavaScript to the footer: Serials, part 3
14:51 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20886 normal, P5 - low, ---, jonathan.druart, Pushed to Stable , Koha::Object::TO_JSON indiscriminately casting to integer
14:51 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20700 trivial, P5 - low, ---, bgkriegel, Pushed to Master , Update MARC21 leader/007/008 codes
14:51 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20756 trivial, P5 - low, ---, oleonard, Pushed to Master , OPAC "Share list" button should be styled with an icon
14:51 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20851 trivial, P5 - low, ---, m.de.rooy, Pushed to Master , Missing module in circ/article-request-slip.pl
14:51 LeeJ thanks Joubu...is there somewhere that has more information on how to use those queries?
14:52 LeeJ just a bit unclear as to the syntax/format when writing them
14:56 LeeJ so the result set is just a hash then..?
14:57 Joubu LeeJ: my $item = Koha::Items->find({ barcode => $barcode }); # will return a Koha::Item object
14:57 Joubu my $biblio = $item->biblio # will return a Koha::Biblio object
14:57 Joubu my $title = $biblio->title # will return a scalar (string)
15:03 reiveune bye
15:04 LeeJ Joubu: so then conceptually, for example, the Koha::Biblio object can be used to access any column from the biblio table
15:07 Joubu yep
15:07 LeeJ :D
15:08 LeeJ so then to get a patron's firstname and surname based on their borrowernumber it would be:
15:08 LeeJ my $patron = Koha::Patrons->find({ borrowernumber => $borrowernumber});
15:09 LeeJ then my $first_name = $patron->firstname and my $surname = $patron->surname
15:09 LeeJ yes?
15:11 Joubu my $patron = Koha::Patrons->find($borrowernumber);
15:11 Joubu is enough, because the borrowernumber is the primary key
15:11 Joubu if you want to fetch an item from an itemnumber: Koha::Items->find($itemnumber);
15:12 Joubu but with a barcode (which is defined as unique key), you need to specify the column to use
15:15 LeeJ oooooh
15:16 LeeJ so use the find({ value => $value }) for non-primary key attributes but use find($value) for primary keys
15:16 LeeJ I'M SO EXCITED I GET IT NOW
15:16 LeeJ that find is very powerful I see
15:21 tuxayo ^_^
15:22 LeeJ hi tuxayo
15:22 LeeJ tuxayo: my face exactly lol
15:22 tuxayo hi hi
15:22 LeeJ so much easier than the old get methods I used to try to use haha
15:26 LeeJ Joubu++
15:27 Joubu LeeJ: almost, non-primary key but unique keys!
15:28 Joubu for others attributes you may get an iterator:
15:28 Joubu my Koha::Patrons->search({ firstname => 'John' });
15:28 Joubu my $patrons = Koha::Patrons->search({ firstname => 'John' }); # instead
15:29 Joubu while ( my $p = $patrons->next ) { sprintf "%s %s is number %s", $p->firstname, $p->surname, $p->borrowernumber; }
15:36 LeeJ oooh
15:36 LeeJ sweet
15:36 LeeJ thanks Joubu :)
15:36 LeeJ Joubu: for my purposes I thankfully won't have to worry about more than one patron name at a time since records are transmitted in a single queue
15:37 LeeJ and since I snag the borrowernumber from the template I just use that for the query
15:37 * LeeJ will be excited to complete this 2+ year project
15:40 Joubu @later tell rangi can you move (export/create) koha-dashboard to gitlab.com/koha-community or give me access please?
15:40 huginn` Joubu: The operation succeeded.
15:45 eythian cait: I think google reminds me of it every year
16:00 cait possibly
16:01 cait I'll never look so slim again :D
16:01 cait bye all :)
16:01 cait will not be around much next week - German library conference
16:02 cait hopefully meeting lots of koha users there :)
16:16 indradg have a slight non-Koha question... what are you using to monitor zebra servers
16:17 indradg for service uptime
16:28 LeeJ hi indradg..if you're looking for a solution there's always Nagios
16:29 indradg LeeJ: of course the old trusted.. or if you hate the UI, then its fork Ichinga :P
16:29 LeeJ hahaha
16:31 indradg no.. actually what i´m interested to learn is how are most people running their zebra is monitoring it... i already have a script in place for nagios... but want to know if someone has had a better idea