IRC log for #koha, 2017-03-30

All times shown according to UTC.

Time S Nick Message
00:11 Francesca joined #koha
00:18 caboose-afk joined #koha
00:19 caboose-afk joined #koha
00:25 caboose-afk joined #koha
00:49 BobB joined #koha
01:21 caboose-afk joined #koha
01:22 caboose-afk joined #koha
01:27 Francesca joined #koha
01:55 Francesca joined #koha
02:37 papa joined #koha
02:37 kathryn joined #koha
02:37 Scott-CSPL joined #koha
02:37 deb-CSPL joined #koha
02:37 ibeardslee joined #koha
02:37 pastebot joined #koha
02:37 gmcharlt joined #koha
02:37 misilot joined #koha
02:37 bshum joined #koha
02:37 barbara joined #koha
02:37 chris_n joined #koha
02:37 eythian joined #koha
02:37 huginn` joined #koha
02:37 cdickinson joined #koha
02:37 sallyf joined #koha
02:37 rhamby joined #koha
02:37 rangi joined #koha
03:52 jamesb_ joined #koha
04:26 Francesca joined #koha
04:41 cait joined #koha
04:46 sameeenz joined #koha
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:01 LibraryClaire joined #koha
06:05 LibraryClaire morning #koha
06:27 fridolin joined #koha
06:27 fridolin hie tehre
06:32 * cait waves
06:44 alex_a joined #koha
06:45 alex_a hello
06:47 fridolin joined #koha
06:53 reiveune joined #koha
06:53 reiveune hello
06:53 wahanui what's up, reiveune
06:56 AndrewIsh joined #koha
07:00 gaetan_B joined #koha
07:01 gaetan_B hello
07:03 sameeenz joined #koha
07:12 cait joined #koha
07:22 baptiste joined #koha
07:26 gaetan_B joined #koha
07:26 Infra_3600 joined #koha
07:29 Snorri joined #koha
07:30 Snorri left #koha
07:48 Francesca joined #koha
08:05 alex_a joined #koha
08:19 marcelr joined #koha
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 :)
08:28 gaetan_B joined #koha
08:51 gaetan_B joined #koha
09:12 Francesca joined #koha
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/[…]35bdd28101785315c> / Bug 18124: [Follow-up] Handle default parameters in a sub <http://git.koha-community.org/[…]cad5cddc222a45ebe> / 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 yyy joined #koha
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[…]ha_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` Bug http://bugs.koha-community.org[…]_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/a​dditem.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 alex_a joined #koha
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 joined #koha
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` Bug http://bugs.koha-community.org[…]_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:33 cait left #koha
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?
11:28 baptiste joined #koha
11:31 laurence joined #koha
11:33 vfernandes joined #koha
11:38 laurence left #koha
11:39 laurence joined #koha
11:43 Dyrcona joined #koha
11:44 oleonard joined #koha
11:46 caboose joined #koha
11:46 meliss joined #koha
11:55 Dyrcona joined #koha
11:57 alex_a joined #koha
11:59 alex_a joined #koha
12:17 cait joined #koha
12:18 kidclamp joined #koha
12:37 cait joined #koha
12:37 jzairo joined #koha
12:47 * kidclamp is listening to the Pixies. It is fun.
12:51 oleonard pixies++
12:54 nengard joined #koha
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:05 tcohen joined #koha
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:20 kmlussier joined #koha
13:25 oleonard magnuse: https://sweartrek.tumblr.com/p[…]5299255463/always
13:26 magnuse :-)
13:26 LibraryClaire hah
13:33 Putti joined #koha
13:36 kellym joined #koha
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.
13:46 kholt joined #koha
13:54 alex_a joined #koha
13:55 jenkins joined #koha
14:02 jenkins Project Koha_Master_D8 build #139: STILL FAILING in 2 min 35 sec: https://jenkins.koha-community[…]ha_Master_D8/139/
14:20 laurence left #koha
14:21 Scott-CSPL joined #koha
14:25 vfernandes anyone can help me with my elasticsearch problem?
14:31 cait joined #koha
14:37 kidclamp I can try vfernandes
14:38 fridolin left #koha
14:39 vfernandes kidclamp: did you se my messages this morning?
14:40 vfernandes *see
14:40 barton joined #koha
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:48 jac joined #koha
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:06 LibraryClaire left #koha
15:58 jenkins Project Koha_Master_D8 build #140: NOW UNSTABLE in 1 hr 38 min: https://jenkins.koha-community[…]ha_Master_D8/140/
16:08 reiveune bye
16:08 reiveune left #koha
16:10 bag morning
16:13 tcohen http://kohadev-intra.mydnsname.org:8081
16:13 tcohen oops
16:56 cait joined #koha
17:07 winston_obrien joined #koha
17:18 Joubu rangi: https://gitlab.com/koha-dashbo[…]merge_requests/52 ;)
17:25 francharb joined #koha
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 !
17:47 kellym joined #koha
17:59 kholt joined #koha
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:03 talljoy joined #koha
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:23 jls joined #koha
18:29 bag heya Joubu
18:40 kathryn joined #koha
18:41 nuentoter joined #koha
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:42 jbeno joined #koha
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:20 cait joined #koha
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
19:51 decode__ joined #koha
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:10 andreashm joined #koha
20:12 * andreashm waves
20:36 * nuentoter waves
20:55 misilot joined #koha
21:05 kampouris joined #koha
21:08 caboose-afk joined #koha
21:08 Francesca joined #koha
21:09 jenkins Project Koha_Master_D8 build #141: STILL UNSTABLE in 1 hr 34 min: https://jenkins.koha-community[…]ha_Master_D8/141/
21:59 kholt left #koha
22:06 caboose joined #koha
22:20 Francesca joined #koha
22:25 caboose joined #koha
22:31 caboose joined #koha
22:47 papa joined #koha
23:51 kmlussier joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary