Time Nick Message 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/ 20:36 * nuentoter waves 20:12 * andreashm waves 20:09 Joubu nuentoter: then you will need to write a patch or ask someone else to do it ;) 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 19:38 rangi heh 19:37 Joubu Whaou, we are in March! 19:36 rangi Joubu: running that code now 19:34 Joubu d 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 then you have a dropdown list to select the number of rows displayed on the page 19:34 Joubu nuentoter: what about simply "SELECT barcode FROM items ORDER BY timestamp DESC;" 19:32 rangi cool joubu will look now 19:27 francharb ;) 19:27 francharb Joubu, nope 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:21 nuentoter is there a way to amend this? or is it not something i can do something about? 19:17 Joubu SELECT barcode FROM items LIMIT 42; 19:17 Joubu should be 19:17 Joubu SELECT barcode FROM items LIMIT '42'; 19:17 Joubu generate 19:17 Joubu SELECT barcode FROM items LIMIT <<number of barcodes>>; 19:17 Joubu nuentoter: indeed it seems that it is not possible 19:07 nuentoter I have copied from other reports what I thought to be the correct syntax but i guess not. 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:03 Joubu nuentoter: what is your query? 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 18:46 jac kidclamp^ 18:45 nuentoter wondering if someone could help me with a little sql report stuff? 18:42 bag it’s great seeing everyone there :) 18:42 bag Fun as always :) 18:42 Joubu Hi bag! How was going the hackfest? 18:29 bag heya Joubu 18:21 Joubu My sleeping hours are not very well defined for the last month... 18:19 oleonard Joubu: You should get to sleep in 2-3 hours if you have to wait that much longer for lunch. 18:13 * Joubu had to switch the lunch and supper time (+2-3h), to meet local requirements 18:10 Joubu not really enjoying the time zone especially but love the new place I live :) 18:08 oleonard Joubu: Other than being boring how are you liking your new time zone Joubu ? 18:07 Joubu francharb: no more exciting questions? :D 18:04 * kidclamp is here 18:01 * oleonard is awake but lurking 18:01 Joubu This tz is so boring, where are you guys? 18:00 Joubu :) 18:00 Joubu tig 17:27 francharb Salut Joubu ! 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:26 Joubu Salut francharb 17:25 francharb Hi all! 17:18 Joubu rangi: https://gitlab.com/koha-dashboard/koha-dashboard/merge_requests/52 ;) 16:13 tcohen oops 16:13 tcohen http://kohadev-intra.mydnsname.org:8081 16:10 bag morning 16:08 reiveune bye 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/ 14:58 kidclamp it is working for me on master 14:55 vfernandes shouldn't have data from field 200 also? or two title indexes? 14:54 vfernandes after the fix the title index only had data from field 205 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:52 kidclamp so that is the record vfernandes 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:49 vfernandes kidclamp: the problem is before the commit to elasticsearch 14:47 vfernandes on method _convert_marc_to_json 14:46 vfernandes i've added some debug to Koha::SearchEngine::Elasticsearch::Indexer 14:45 vfernandes i think the problem is before commit to elasticsearch 14:44 kidclamp did you delete the indexes before rebuilding? 14:44 vfernandes marc mappings: 'marc_map(\'200abcde\',\'title\', -split => 1)' | 'marc_map(\'205abcd\',\'title\', -split => 1)' 14:42 vfernandes after reindexing one record with those two fields filled, only field 205 is indexed as 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:41 vfernandes i'm having a problem with repeatable indexes like title 14:40 vfernandes *see 14:39 vfernandes kidclamp: did you se my messages this morning? 14:37 kidclamp I can try vfernandes 14:25 vfernandes anyone can help me with my elasticsearch problem? 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/ 13:37 oleonard That's funny I've only heard of positivity brownies before. 13:36 wahanui :) 13:36 LibraryClaire wahanui: botsnack positivity cookie 13:36 wahanui the only good morning is a dead one 13:36 kellym good morning 13:26 LibraryClaire hah 13:26 magnuse :-) 13:25 oleonard magnuse: https://sweartrek.tumblr.com/post/155299255463/always 13:19 magnuse oleonard: thanks :-) 13:19 magnuse do not underestimate the power of the hex key! 13:18 LibraryClaire done! 13:18 oleonard magnuse: That seems logical 13:18 * LibraryClaire puts on galsses 13:18 tcohen :D 13:18 kidclamp enjoy making the 2D into 3D 13:18 kidclamp sure thign cait 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:16 LibraryClaire hi tcohen 13:15 tcohen hi LibraryClaire 13:15 LibraryClaire delivery++ 13:15 tcohen lol 13:15 cait can we talk about it later? i just got a big ikea delivery :) 13:14 cait i am actually using a code snippet that i got from rangi 13:13 cait the terms of use of amazon are a big ugh 13:13 cait a bsz thing and open library 13:13 cait ah but not for amazon 13:11 kidclamp cait^ 13:11 kidclamp claire said you built a trick for indirectly requesting covers - to protect the users from amazon 13:11 LibraryClaire sweet 13:11 cait kidclamp: pong? 13:09 cait LibraryClaire: it's all here! 13:09 cait hm? 13:07 tcohen morning 13:06 huginn` kidclamp: The operation succeeded. 13:06 kidclamp @later tell cait ping me about book covers 13:02 * magnuse heard "the black album" for the first time in ages earlier today 13:02 kidclamp nostalgia++ 13:00 * oleonard is inspired to nostalgize, listens to Concrete Blonde's Bloodletting 12:51 oleonard pixies++ 12:47 * kidclamp is listening to the Pixies. It is fun. 11:10 vfernandes shouldn't be two title indexes in this case? I doing something wrong? 11:09 pastebot "vfernandes" at 127.0.0.1 pasted "After fix" (3 lines) at http://paste.koha-community.org/363 11:07 pastebot "vfernandes" at 127.0.0.1 pasted "before fix" (20 lines) at http://paste.koha-community.org/361 11:04 pastebot "vfernandes" at 127.0.0.1 pasted "MARC map rules" (4 lines) at http://paste.koha-community.org/360 10:57 vfernandes in my case Catmandu::Fix is not creating repeatable title indexes 10:18 vfernandes in that case the title index should have data from 200 and 205 10:17 vfernandes for example: in a UNIMARC record with fields 200 and 205 the title index only have data from 205 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:16 magnuse for all the javascript hackers with IE11 out there: bug 18353 10:16 vfernandes i'm having a problem with koha 16.11 and elasticsearch 10:15 vfernandes hi #koha 10:10 cait the barcode has to be globally unique 10:10 cait true 10:09 yyy it will have to be prefixed with each library 10:09 yyy one more doubt is it wont also then accept barcode same for each library 10:08 cait but not totally 10:08 cait it's somewhat separate 10:06 yyy ok 10:04 cait even if you use independentbranches (system preference) 10:04 cait they will still manage to see other libraries patron information etc 10:04 cait but it only means they can't log in for another library it hink 10:03 cait you can restrict the access by ip using your library configuration yes 10:01 yyy in that case my question is auto location based on IP for each library works fine right 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:00 cait each library has its own db then 09:59 cait s 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 yyy or under one installation many libraries option 09:59 yyy create multiple instances is it? 09:59 cait updating and adding patrons in our 3.22.18 works fine 09:59 yyy so for multiple libraries wht is best way to manage koha 09:59 magnuse yes, translated 09:59 cait translated? 09:59 wahanui yep that one is pretty cool actually 09:59 cait yep that one 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:58 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18124 is not accessible. 09:58 jenkins * kyle: Bug 18124: Change the calls to generate and check CSRF tokens 09:58 jenkins * kyle: Bug 18124: [Follow-up] Handle default parameters in a sub 09:58 cait if you have one single installation, lots of stuf is shared 09:58 jenkins * kyle: Bug 18124: Restrict CSRF token to user's session 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 cait you can do that, but they will still see data from each other 09:58 yyy multiple libraries 09:58 cait multiple libraries or mulitple instances? 09:57 yyy ip address range 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 cait the context menu right, not the pulldown/button? 09:57 cait ok thx 09:56 magnuse cait: checked on a swedish setup and 16.11.05 09:56 wahanui i guess which version is recommended? 09:56 cait which version? 09:56 cait hmpf 09:56 magnuse translated 09:55 magnuse cait: lemme check 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 cait magnuse: could you check something for me too? 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:53 cait ? 09:53 cait but can only test with 3.22 - do you have a test login i could test with 09:53 cait hm i have 09:50 magnuse anyone have access to Internet Explorer 11? i have a report of adding/updating patrons failing in it 09:50 marcelr thx khall 08:24 LibraryClaire :) 08:22 marcelr hi LibraryClaire 08:22 * LibraryClaire waves 08:20 huginn` marcelr: The operation succeeded. 08:20 marcelr @later tell khall please push 18124 (security bug is in PQA since March 20 08:19 marcelr hi #koha 07:01 gaetan_B hello 06:53 wahanui what's up, reiveune 06:53 reiveune hello 06:45 alex_a hello 06:32 * cait waves 06:27 fridolin hie tehre 06:05 LibraryClaire morning #koha 05:55 magnuse \o/ 05:55 huginn` magnuse: Error: No such location could be found. 05:55 magnuse @wunder enbo 05:55 * magnuse waves