Time Nick Message 05:55 * magnuse waves 05:55 magnuse @wunder enbo 05:55 huginn` magnuse: Error: No such location could be found. 05:55 magnuse \o/ 06:05 LibraryClaire morning #koha 06:27 fridolin hie tehre 06:32 * cait waves 06:45 alex_a hello 06:53 reiveune hello 06:53 wahanui what's up, reiveune 07:01 gaetan_B hello 08:19 marcelr hi #koha 08:20 marcelr @later tell khall please push 18124 (security bug is in PQA since March 20 08:20 huginn` marcelr: The operation succeeded. 08:22 * LibraryClaire waves 08:22 marcelr hi LibraryClaire 08:24 LibraryClaire :) 09:50 marcelr thx khall 09:50 magnuse anyone have access to Internet Explorer 11? i have a report of adding/updating patrons failing in it 09:53 cait hm i have 09:53 cait but can only test with 3.22 - do you have a test login i could test with 09:53 cait ? 09:54 huginn` New commit(s) kohagit: Bug 18124: Change the calls to generate and check CSRF tokens <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=574d48362d32c14920712ae35bdd28101785315c> / Bug 18124: [Follow-up] Handle default parameters in a sub <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7190593d9dd38001c2d101bcad5cddc222a45ebe> / Bug 18124: Restrict CSRF token to user's session <http://git.koha-community.org/gitweb/? 09:55 cait magnuse: could you check something for me too? 09:55 cait the edit items/delete items that appears when you click somwehrer in the items table over the item form - translated or not? 09:55 magnuse cait: lemme check 09:56 magnuse translated 09:56 cait hmpf 09:56 cait which version? 09:56 wahanui i guess which version is recommended? 09:56 magnuse cait: checked on a swedish setup and 16.11.05 09:57 cait ok thx 09:57 cait the context menu right, not the pulldown/button? 09:57 yyy if we use single installation of koha and create multiple libraries will koha allow to access staff client based on the IP defined for each library 09:57 yyy ip address range 09:58 cait multiple libraries or mulitple instances? 09:58 yyy multiple libraries 09:58 cait you can do that, but they will still see data from each other 09:58 jenkins Project Koha_Master_D8 build #138: STILL FAILING in 33 sec: https://jenkins.koha-community.org/job/Koha_Master_D8/138/ 09:58 jenkins * kyle: Bug 18124: Restrict CSRF token to user's session 09:58 cait if you have one single installation, lots of stuf is shared 09:58 jenkins * kyle: Bug 18124: [Follow-up] Handle default parameters in a sub 09:58 jenkins * kyle: Bug 18124: Change the calls to generate and check CSRF tokens 09:58 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18124 is not accessible. 09:58 magnuse cait: there is a little two line "menu" that shows inside any table cell i click in, on e.g. /cgi-bin/koha/cataloguing/additem.pl?biblionumber=106 09:59 cait yep that one 09:59 wahanui yep that one is pretty cool actually 09:59 cait translated? 09:59 magnuse yes, translated 09:59 yyy so for multiple libraries wht is best way to manage koha 09:59 cait updating and adding patrons in our 3.22.18 works fine 09:59 yyy create multiple instances is it? 09:59 yyy or under one installation many libraries option 09:59 cait if they are really separate libraies and don't loan to eacho ther/share patrons i'd go with separate instance 09:59 cait s 10:00 cait each library has its own db then 10:01 yyy but if under one funding agency or the bks also same at same other branch only patrons may be different can one choose one installation option 10:01 yyy in that case my question is auto location based on IP for each library works fine right 10:03 cait you can restrict the access by ip using your library configuration yes 10:04 cait but it only means they can't log in for another library it hink 10:04 cait they will still manage to see other libraries patron information etc 10:04 cait even if you use independentbranches (system preference) 10:06 yyy ok 10:08 cait it's somewhat separate 10:08 cait but not totally 10:09 yyy one more doubt is it wont also then accept barcode same for each library 10:09 yyy it will have to be prefixed with each library 10:10 cait true 10:10 cait the barcode has to be globally unique 10:15 vfernandes hi #koha 10:16 vfernandes i'm having a problem with koha 16.11 and elasticsearch 10:16 magnuse for all the javascript hackers with IE11 out there: bug 18353 10:16 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18353 major, P5 - low, ---, koha-bugs, NEW , Fix "Save" button on add/edit patron in IE11 10:17 vfernandes for example: in a UNIMARC record with fields 200 and 205 the title index only have data from 205 10:18 vfernandes in that case the title index should have data from 200 and 205 10:57 vfernandes in my case Catmandu::Fix is not creating repeatable title indexes 11:04 pastebot "vfernandes" at 127.0.0.1 pasted "MARC map rules" (4 lines) at http://paste.koha-community.org/360 11:07 pastebot "vfernandes" at 127.0.0.1 pasted "before fix" (20 lines) at http://paste.koha-community.org/361 11:09 pastebot "vfernandes" at 127.0.0.1 pasted "After fix" (3 lines) at http://paste.koha-community.org/363 11:10 vfernandes shouldn't be two title indexes in this case? I doing something wrong? 12:47 * kidclamp is listening to the Pixies. It is fun. 12:51 oleonard pixies++ 13:00 * oleonard is inspired to nostalgize, listens to Concrete Blonde's Bloodletting 13:02 kidclamp nostalgia++ 13:02 * magnuse heard "the black album" for the first time in ages earlier today 13:06 kidclamp @later tell cait ping me about book covers 13:06 huginn` kidclamp: The operation succeeded. 13:07 tcohen morning 13:09 cait hm? 13:09 cait LibraryClaire: it's all here! 13:11 cait kidclamp: pong? 13:11 LibraryClaire sweet 13:11 kidclamp claire said you built a trick for indirectly requesting covers - to protect the users from amazon 13:11 kidclamp cait^ 13:13 cait ah but not for amazon 13:13 cait a bsz thing and open library 13:13 cait the terms of use of amazon are a big ugh 13:14 cait i am actually using a code snippet that i got from rangi 13:15 cait can we talk about it later? i just got a big ikea delivery :) 13:15 tcohen lol 13:15 LibraryClaire delivery++ 13:15 tcohen hi LibraryClaire 13:16 LibraryClaire hi tcohen 13:17 magnuse huh, my circ rules say hard due date = "on 2017-05-23" for one specific itemtype and all patron categories. if i issue a book of that type to myself today, shouldn't the due date be 2017-05-23? 13:18 kidclamp sure thign cait 13:18 kidclamp enjoy making the 2D into 3D 13:18 tcohen :D 13:18 * LibraryClaire puts on galsses 13:18 oleonard magnuse: That seems logical 13:18 LibraryClaire done! 13:19 magnuse do not underestimate the power of the hex key! 13:19 magnuse oleonard: thanks :-) 13:25 oleonard magnuse: https://sweartrek.tumblr.com/post/155299255463/always 13:26 magnuse :-) 13:26 LibraryClaire hah 13:36 kellym good morning 13:36 wahanui the only good morning is a dead one 13:36 LibraryClaire wahanui: botsnack positivity cookie 13:36 wahanui :) 13:37 oleonard That's funny I've only heard of positivity brownies before. 14:02 jenkins Project Koha_Master_D8 build #139: STILL FAILING in 2 min 35 sec: https://jenkins.koha-community.org/job/Koha_Master_D8/139/ 14:25 vfernandes anyone can help me with my elasticsearch problem? 14:37 kidclamp I can try vfernandes 14:39 vfernandes kidclamp: did you se my messages this morning? 14:40 vfernandes *see 14:41 vfernandes i'm having a problem with repeatable indexes like title 14:42 vfernandes for example i've defined on Koha administration interface that title should be indexed from field 200 and field 205 14:42 vfernandes after reindexing one record with those two fields filled, only field 205 is indexed as title 14:44 vfernandes marc mappings: 'marc_map(\'200abcde\',\'title\', -split => 1)' | 'marc_map(\'205abcd\',\'title\', -split => 1)' 14:44 kidclamp did you delete the indexes before rebuilding? 14:45 vfernandes i think the problem is before commit to elasticsearch 14:46 vfernandes i've added some debug to Koha::SearchEngine::Elasticsearch::Indexer 14:47 vfernandes on method _convert_marc_to_json 14:49 vfernandes kidclamp: the problem is before the commit to elasticsearch 14:51 pastebot "vfernandes" at 127.0.0.1 pasted "Record data before fix ($importer = $fixer->fix($importer))" (20 lines) at http://paste.koha-community.org/364 14:52 kidclamp so that is the record vfernandes 14:53 pastebot "vfernandes" at 127.0.0.1 pasted "After fix ($importer = $fixer->fix($importer))" (3 lines) at http://paste.koha-community.org/365 14:54 vfernandes after the fix the title index only had data from field 205 14:55 vfernandes shouldn't have data from field 200 also? or two title indexes? 14:58 kidclamp it is working for me on master 15:58 jenkins Project Koha_Master_D8 build #140: NOW UNSTABLE in 1 hr 38 min: https://jenkins.koha-community.org/job/Koha_Master_D8/140/ 16:08 reiveune bye 16:10 bag morning 16:13 tcohen http://kohadev-intra.mydnsname.org:8081 16:13 tcohen oops 17:18 Joubu rangi: https://gitlab.com/koha-dashboard/koha-dashboard/merge_requests/52 ;) 17:25 francharb Hi all! 17:26 Joubu Salut francharb 17:27 francharb when koha runs as a z39.50 server, has anyone tried to hide withdrawn items (items.withdrawn =1) from external z39.50 search ? 17:27 francharb Salut Joubu ! 18:00 Joubu tig 18:00 Joubu :) 18:01 Joubu This tz is so boring, where are you guys? 18:01 * oleonard is awake but lurking 18:04 * kidclamp is here 18:07 Joubu francharb: no more exciting questions? :D 18:08 oleonard Joubu: Other than being boring how are you liking your new time zone Joubu ? 18:10 Joubu not really enjoying the time zone especially but love the new place I live :) 18:13 * Joubu had to switch the lunch and supper time (+2-3h), to meet local requirements 18:19 oleonard Joubu: You should get to sleep in 2-3 hours if you have to wait that much longer for lunch. 18:21 Joubu My sleeping hours are not very well defined for the last month... 18:29 bag heya Joubu 18:42 Joubu Hi bag! How was going the hackfest? 18:42 bag Fun as always :) 18:42 bag it’s great seeing everyone there :) 18:45 nuentoter wondering if someone could help me with a little sql report stuff? 18:46 jac kidclamp^ 19:00 nuentoter I am trying to get a report that will pull the 30 most recent barcodes, but my sql knowledge is only budding. I seem to have some syntax error that I cannot reconcile 19:03 Joubu nuentoter: what is your query? 19:06 nuentoter my report is ordered by items.dateaccessioned and then has a limit of 30 on it currently. and it works correctly. but I simply want to change the 30 into an input box for the person running the report. 19:07 nuentoter I have copied from other reports what I thought to be the correct syntax but i guess not. 19:17 Joubu nuentoter: indeed it seems that it is not possible 19:17 Joubu SELECT barcode FROM items LIMIT <<number of barcodes>>; 19:17 Joubu generate 19:17 Joubu SELECT barcode FROM items LIMIT '42'; 19:17 Joubu should be 19:17 Joubu SELECT barcode FROM items LIMIT 42; 19:21 nuentoter is there a way to amend this? or is it not something i can do something about? 19:22 nuentoter I thought it was poor syntax on my part but I seem to be getting the same result as you Joubu 19:27 francharb Joubu, nope 19:27 francharb ;) 19:32 rangi cool joubu will look now 19:34 Joubu nuentoter: what about simply "SELECT barcode FROM items ORDER BY timestamp DESC;" 19:34 Joubu then you have a dropdown list to select the number of rows displayed on the page 19:34 Joubu well, the query is not what you want, it will not be the last inserted, but the last modified or inserted as the timestamp column is set to now() when a row is update 19:34 Joubu d 19:36 rangi Joubu: running that code now 19:37 Joubu Whaou, we are in March! 19:38 rangi heh 20:01 nuentoter Joubu: unfortunately that last one won't work for what we need it for. For now I'll simply be having people scrape what they need from the csv afterwards 20:09 Joubu nuentoter: then you will need to write a patch or ask someone else to do it ;) 20:12 * andreashm waves 20:36 * nuentoter waves 21:09 jenkins Project Koha_Master_D8 build #141: STILL UNSTABLE in 1 hr 34 min: https://jenkins.koha-community.org/job/Koha_Master_D8/141/