Time Nick Message 06:22 * magnuse waves 06:57 Joubu hi 06:57 wahanui kia ora, Joubu 06:59 reiveune hello 06:59 wahanui que tal, reiveune 07:00 marcelr hi #koha 07:07 Dangu Hello everyone. I'm trying to customize a koha installation (which is 3.22 btw). I saw that there should be an option named OPACSMALLIMAGE, but it's nowhere to be found either in opac preference setting or by searching the option with the "search-field" 07:07 Dangu do you have any ideas ? 07:20 Joubu Dangu: What is supposed to do this option? 07:25 cait morning #koha 07:27 marcelr hi cait 07:28 gaetan_B hello 07:37 LibraryClaire morning 07:37 cait morning all :) 07:44 Joubu v 07:45 magnuse wasn't OPACSMALLIMAGE removed when we got the bootstrap theme for the opac? 07:47 cait hm shoudl be, why? 07:49 magnuse someone was asking about it earlier 08:51 cait @later tell drojf did you get changed flight times too? 08:51 huginn cait: The operation succeeded. 09:03 atheia hello #koha :-) 09:03 cait hi atheia :) 09:12 Joubu Could someone delete that page https://wiki.koha-community.org/wiki/Debean_Squeez_Script? 09:12 Joubu I emptied it but it seems that I don't have the rights to delete it 09:15 cait me neither it hnk 09:16 cait you can use an Obsolete thing maybe 09:16 cait i think it was something like {{obsolete}} or similar - shoudl be on other pages too 09:16 eythian that was a seriously useless page. Why are there "sudo halt" statments everywhere? 09:18 cait huh 09:19 cait ok, why would one database sort bilbionumber asc and the other biblionumber desc if the sort criteria is the same otherwise? 09:20 eythian are they sorting at all? 09:22 drojf hi #koha 09:22 drojf cait: yep got a new time 09:23 drojf more time for sight seeing in berlin ;) 09:23 eythian drojf: Stone Brewery is opening a brewbar type thing in Berlin 09:23 drojf not sure what that is? 09:25 drojf their web page says that a) they value sustainability and b) they distribute beer in cans. lol 09:26 magnuse "Debean Squeez Script" has been deleted 09:26 eythian they're a good brewery 09:26 eythian also, cans are better for beer than bottles, Germany is a bit behind on the good beer front these days :) 09:27 drojf if they make beer from stones, that should work for me. stones are gluten free, right? :) 09:27 eythian yep 09:27 ashimema what's the science behind cans being better than bottles for beer then eythian? 09:28 drojf i think that is a lie :P 09:28 eythian ashimema: lower oxidation rate due to a better seal, and less light let in primarily. 09:28 ashimema me too ;) 09:28 ashimema the light I can understand 09:28 eythian they're also more efficient as they pack better. 09:28 ashimema never would have guessed the seal was better especially though 09:28 eythian it's really a lot better 09:28 drojf hm yeah sustainability is not shipping your beer around the world :P 09:28 ashimema mwah.. I still like bottles.. but I'm not snobby against cans really 09:29 eythian drojf: that's why they're making a brew bar in berlin 09:29 ashimema just usual don't have good beer in them to start with in this country ;) 09:29 drojf eythian: good point 09:29 wahanui I know! The blade went right through that child! 09:29 ashimema they deffo pack better though.. I'll give you that 09:29 eythian in NZ cans are getting more and more popular due to the improvement in quality 09:30 eythian especially if it's something you're storing. 09:30 ashimema there's aren't many good ales in cans over here.. and I'm not the biggest lager drinker.. though it has it's time and place too 09:30 magnuse good point? 09:30 wahanui I know! The blade went right through that child! 09:30 magnuse wahanui: forget good point 09:30 wahanui magnuse: I forgot good point 09:30 drojf i never liked canned beer 09:31 drojf i am a bottle child 09:31 magnuse good point? 09:31 drojf that is probably something only working in german :D 09:31 drojf flaschenkind 09:31 magnuse hehe 09:31 magnuse flaskebarn in norwegian 09:31 drojf i would not mind glutenberg bringing over their cans though. from canada to berlin would make more sense in cans 09:31 eythian drojf: well, you're held back from good quality beer by 500 years of silly tradition anyway :) 09:32 eythian also, you put your beer into a glass unless you're some sort of heathen. 09:32 drojf ugh 09:32 drojf fancyshmancy 09:33 drojf we drink our beer from the bottle. right in the street 09:33 drojf or at the construction site we work at ;) 09:33 eythian http://idealog.co.nz/design/2015/07/beautiful-beer-garage-projects-alcoholic-art <-- also, you get better designs 09:38 magnuse gotta love it when the link to detail view looks like this http://bibliotek.alingsas.se/web/pub/results?p_p_state=normal&p_p_lifecycle=1&p_p_action=1&p_p_id=crDetailWicket_WAR_arenaportlets&p_p_col_count=4&p_p_col_id=column-2&p_p_col_pos=2&p_p_mode=view&back_url=http%3A%2F%2Fbibliotek.alingsas.se%2Fweb%2Fpub%2Fresults%3Fp_p_id%3DcrDetailWicket_WAR_arenaportlets%26p_p_lifecycle%3D1%26p_p_state%3Dnormal%26p_p_mode%3Dview%26p_p_col_id%3Dcolumn 09:38 magnuse -2%26p_p_col_pos%3D2%26p_p_col_count%3D4%26facet_queries%3D%26search_item_no%3D0%26sort_advice%3Dfield%253DRelevance%2526direction%253DDescending%26search_item_id%3D57847%26agency_name%3DASE100189%26search_type%3Dsolr&facet_queries=&search_item_no=0&sort_advice=field%3DRelevance%26direction%3DDescending&search_type=solr&arena_member_id=360354316&search_item_id=57847&agency_name=ASE100189 09:38 drojf lol 09:40 Joubu eythian: the "Aro noir" looks great :) 09:41 eythian Joubu: I have the t-shirt of that one 09:43 drojf is anyone using catmandu to create marc recods from non-marc sources? 09:43 Joubu rangi brought some nice cans in Cordoba, I tasted a Saison which was really good. I Don't remember the name, but the can was nice 10:04 drojf a few days ago i accidentally installed koha insteads of koha-common. that made me wonder what we are going to do with that? 10:04 drojf does it work at all? does anyone use it? what is the difference to koha-common? 10:05 Joubu N: Unable to locate package koha 10:07 drojf Joubu: when you build your own you get one 10:07 Joubu ha, never heard about that package 10:08 drojf i can upload one if you like ;) 10:30 Joubu @later tell tcohen Tomas, wake up! 10:30 huginn Joubu: The operation succeeded. 10:48 jcamins drojf: it was never really finished. 10:49 drojf jcamins: the koha package? what was it supposed to do differently? 10:50 jcamins drojf: it can only be used for a single instance, which is preconfigured. 10:51 drojf hm ok… so it is limited to a part of what koha-common can do? or is there something that only koha can do? 10:52 drojf is there a use case when you would want koha instead of koha-common, because you can't achieve what you want to do with koha-common? or would it just be simpler to set up maybe? (less options) 10:54 drojf uh that coffee made me want to do a lot of stuff… simultanously 11:02 jcamins drojf: no, koha-common is more functional, and easier to set up since koha didn't quite work the way it was planned. 11:02 jcamins At least, that's how I see it. 11:03 drojf we should probably get rid of koha completely and eventually rename koha-common to koha? 11:06 jcamins Yes, that's something that I thought about during 3.12. 11:39 drojf C4/Auth_cas_servers.yaml.orig is driving me nuts. how the hell can i make it not get deleted all the time? 11:39 drojf whenever i commit something, that damn file is going away 11:51 cait sorry, meeting... 11:51 cait drojf: bit anoying - now it will get late until we get to thessaloniki 11:53 Joubu drojf: that's funny, I noticed its existence this morning! 11:54 drojf Joubu: did it get deleted accidentally for you too? 11:55 Joubu drojf: yep exactly 11:55 drojf cait: how much later is it now? i did not spend much attention 11:55 drojf Joubu: did you find a way to make it stay? or will we delete it because it wants to die? 11:56 cait i think we get in after eight now 11:56 cait i can check sec 11:56 Joubu drojf: it happened when I was playing with pbuilder 11:56 drojf oh! 11:56 cait yeah 11:56 cait 17:15 - 20:45 11:56 drojf what was the old one? 11:56 cait 16:00 11:57 drojf oh thats really late 11:57 cait so would have been 19:30 i think? 11:57 drojf with getting the luggage, getting to the hotel and all :/ 11:57 cait yeah 11:57 cait puts a dent in dinner plans 11:57 drojf you already had dinner plans for thessaloniki? 11:57 cait do you know if somene else is ont hat flight now too? 11:57 cait no... but there would have been the option :) 11:58 drojf zeno is not going to greece. not sure which flight pianohacker is going to take. eythian maybe? 11:58 eythian I haven't booked yet, lazy. 11:59 cait and atheia 11:59 cait but he wnted to return in between i think? 11:59 cait eythian: tsk 11:59 eythian this weekend 12:01 drojf cait: the early flight is not really a better option i think. but paying the night without any time in the evening is annoying 12:02 drojf so we have to party that evening! 12:02 cait we can still go out and party ;) 12:02 cait hehe 12:02 drojf :D 12:02 cait well we will start the party at the airport 12:02 cait and hope everything works out there 12:02 cait please ask me if i checked in online... 12:02 cait i hope i don't forget that 12:03 cait and not now.... in Berlin ;) 12:03 drojf i was just starting to type that 12:05 cait mabe they will change times again... there is still time for that 12:10 drojf but now we made party plans! 12:14 drojf Joubu: true, the files gets deleted by the build process. don't know where, but at least i know why now, thanks 12:14 drojf brb 12:49 cait eythian: the sorting is right - but it's all the same as far as i can tell - same year 12:49 cait and then it falls back to biblionumber... but one catalog does asc and the other desc :( 12:51 eythian are you sure it's falling back, and not doing database order (which is to say, undefined) 12:53 oleonard Hi #koha 12:54 tcohen hi oleonard #koha 12:55 tcohen morning Joubuy 12:55 tcohen morning Joubu 12:57 cait eythian: the bilbionumbers appear nicely sorted 12:57 cait eythian: but biblionumbers are database order.... 12:57 oleonard Only Joubu's special friends get to call him Joubuy 12:57 eythian cait: only if you're lucky, it's not a promis 12:57 eythian e 12:57 cait hmmm 12:57 cait how could i check that? 12:58 cait is the order in mysql workbench the one it should be in? without sort? 12:58 cait well without any order by 12:58 eythian maybe, probably 12:58 cait eythian: i will check that 12:58 cait thx! 12:58 eythian though, is this a search through zebra? because that could be different again. 12:58 cait yeah zebrea 12:59 eythian but, rule of thumb is that unless you're asking for an ordering with anything, there's no promised ordering. 12:59 cait the searches i compare are both searches for rcn with an identifier - so pretty similar 13:00 cait eythian: it just appears strange that the sorting seems so perfect... just the other way around 13:00 cait i'd expect it to be not sorted etc.... but that seems odd 13:00 eythian yeah, that would be surprising 13:01 cait [off] https://palatina-search.bsz-bw.de/cgi-bin/koha/opac-search.pl?q=rcn:281513562 https://hs-lorsch.bsz-bw.de/cgi-bin/koha/opac-search.pl?q=rcn:375416552 13:01 cait the instances run on the same server and koha code... so I thought it was configuration,b ut comparig prefs... it looks identical so far 13:02 cait identical zebra config files too 13:03 cait all search prefs identical 13:03 cait *sigh* 13:06 tcohen oleonard: poor-typing-skilled friends you mean 13:08 eythian cait: log zebra queries and see what it's doing there. 13:15 cait eythian: not really an option right now 13:15 cait i will think some more about it - thx for the help 13:26 eythian http://mycli.net/ <-- this is handy, btw 13:59 * magnuse calls it a week - have fun #koha! 14:02 oleonard Happy weekend magnuse 14:15 oleonard It would be super-awesome if someone were to swoop in and fix Bug 15816 14:15 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15816 major, P3, ---, koha-bugs, NEW , Timeout login redirects to home page 14:16 Joubu +1 :) 14:19 oleonard https://36.media.tumblr.com/a1853aa8551717f205b27501e3265068/tumblr_o312ke6aBz1ultu3qo2_1280.jpg 15:01 eythian wahanui: better is better than not better at all 15:01 wahanui ...but better is "take cover." :)... 15:01 eythian wahanui: better is also better than not better at all 15:01 wahanui okay, eythian. 15:02 reiveune bye 15:11 tcohen oleonard: how awesome in a 1-10 scale? 15:11 oleonard I said *super* awesome, so like 11 or 12. 15:12 tcohen hehe 15:12 tcohen @later tell Joubu shouldn't you sign 16221? 15:12 huginn tcohen: The operation succeeded. 15:13 tcohen problem with that oleonard is that it requires black magic 15:14 Joubu tcohen: keeping the QA token 15:14 oleonard Hm. I am reluctant to sacrifice a goat for a bug fix tcohen 15:14 tcohen oleonard: what about 'for the ability to understand whats going on under the hood'? 15:15 tcohen Joubu: I can QA it 15:27 oleonard Bug 6906 test plan says "Regenerate Koha Schema files." How do I do that? 15:27 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6906 enhancement, P5 - low, ---, alex.sassmannshausen, Needs Signoff , show 'Borrower has previously issued $ITEM' alert on checkout 15:31 tcohen oleonard: you need a clean DB 15:31 tcohen (no tables) 15:31 tcohen say > CREATE DATABASE dbic; 15:32 tcohen then you do 15:32 tcohen mysql dbic < installer/data/mysql/kohastructure.sql 15:32 tcohen and finally 15:32 tcohen perl misc/devel/update_dbix_class_files.pl --db_name dbic 15:33 tcohen if your user needs a password for the DB 15:33 tcohen misc/devel/update_dbix_class_files.pl --help will tell you the params 15:33 tcohen ah, run it on your top-level koha source tree 15:34 oleonard top-level koha source tree? 15:35 tcohen git clone .../koha.git kohaclone ; cd kohaclone 15:35 tcohen ? 15:38 oleonard Thanks tcohen 15:39 Joubu the script does not take db_user and db_passwd as parameter, you will have to manually edit the file 15:40 oleonard It says it does 15:40 Joubu ha yes, indeed 15:42 Joubu I have tried to make it use KOHA_CONF automatically some weeks ago 15:42 Joubu but found that it was the original behavior and it was considered as a bug 15:44 pianohacker ? 15:44 pianohacker why? 15:45 Joubu pianohacker: e0b0ae20531736ede2cd1113baf16323cb69b3d9 15:45 Joubu The purpose of this is to intentionally put up a roadblock to reduce 15:45 Joubu the chance that a developer (or release manager) accidentally updates 15:45 Joubu the schema files to include local testing cruft such as temporary 15:45 Joubu tables. 15:45 pianohacker ... 15:45 pianohacker this feels like one of those unnecessarily high speedbumps 15:46 Joubu same for me 15:56 gaetan_B bye 16:01 ianb_ Hi. Is Joy (Nelson) there? I was wanting to check who might know the authority search config on Heather Hernandez's system 16:02 bag morning 16:02 bag talljoy1 ^^^^ 16:03 ianb_ Hi. forgive me if slow: I've not used irc for years 16:03 talljoy i'm here. 16:03 talljoy wasn't expecting you so soon ianb_ i understand it is close to 'clocking out' time! 16:03 talljoy you must be in england. 16:03 talljoy no worries. 16:04 ianb_ Not only clocking out time but got to find cat and dog and take to the vet soon :-( 16:05 ianb_ Arte 16:05 ianb_ ...Are you the right person to know the setup on that system for matching authorities for import/overlay? 16:06 talljoy i'll be reviewing the set up over the weekend (i'm on weekend duty) and i'll have a better sense of the setup/issues/config/etc next week if you want to ping me 16:06 talljoy and i am the person you are looking for! 16:07 drojf Joubu++ 16:08 ianb_ great. Thank you for this. I looked quite deeply into it on our system a month or two back but didn't crack it at the time. We thought we had tried most things. Have a good weekend and look forward to chatting next week. 16:14 beatsforthemind What would be the Zebra SRU equivalent of doing a ‘Search the catalog’ search? 16:15 beatsforthemind Recreating a ‘Search for 'kw,wrdl: term’’ search 16:18 beatsforthemind Doing a Zebra ’searchRetrieve’ with a single ‘query’ term returns different results (or at least in a different order) than doing a ‘Search the catalog’ search with the same term. 16:23 Joubu see you #koha, have a good wwek-end! 16:28 oleonard Bye Joubu 16:53 drojf woah 16:53 drojf @wunder berlin, germany 16:53 huginn drojf: The current temperature in Berlin Tegel, Germany is 12.0°C (6:50 PM CEST on April 15, 2016). Conditions: Thunderstorm. Humidity: 88%. Dew Point: 10.0°C. Pressure: 29.59 in 1002 hPa (Steady). 16:54 drojf so much for shopping 17:03 pianohacker beatsforthemind: the query sent off to Zebra by Koha is actually rather complex, with a lot of extra stuff to do relevance ranking and (if desired) fuzzy searching, query stemming, etc 17:04 beatsforthemind I would love to be able to recreate the default ‘Search the catalog’ Zebra query 17:04 pianohacker beatsforthemind: you comfortable with Perl? 17:05 beatsforthemind I’m decent with PHP, haven’t done much with Perl 17:05 beatsforthemind I’ve been looking at opac-search.pl 17:06 pianohacker beatsforthemind: Search.pm is where you'll want to look 17:06 pianohacker specifically parseQuery 17:06 drojf "want" 17:06 drojf good luck 17:06 drojf throw breadcrumbs to find your way out again 17:06 beatsforthemind Where can I find that file? 17:07 drojf do you have access to the server? 17:07 beatsforthemind I do 17:08 drojf rain stopped, gotta go. later #koha 17:16 pianohacker beatsforthemind: where on your server is opac-search.pl? 17:17 beatsforthemind /usr/share/koha/opac/cgi-bin/opac 17:17 pianohacker beatsforthemind: Search.pm should be in /usr/share/koha/lib/C4/ , then 17:19 beatsforthemind thanks 17:19 beatsforthemind I am looking through it 17:25 * cait waves 17:30 beatsforthemind This is a fairly complicated file 17:31 eythian http://nedroid.com/2016/04/mr-fix-computer-2/ <-- teehee 17:39 beatsforthemind It would be nice if there were more examples of how to use @attr 17:39 beatsforthemind or that query type 17:39 beatsforthemind x-pquery? 17:46 beatsforthemind Is there anyway to log the exact query that is being built? 17:49 oleonard eythian: I find that comic to be completely unrealistic. 17:49 oleonard The printer works?! 18:01 oleonard beatsforthemind: I'm sorry you're having such bad luck getting answers. I wish I knew what to suggest. 18:02 oleonard Also, saying "This is a fairly complicated file" about Search.pm is quite the understatement. 18:02 beatsforthemind It’s ok, this chatroom has been helpful 18:02 oleonard Many a Koha developer has wished for Search.pm's death. 18:57 * oleonard whispers, "Happy weekend everyone" 19:10 tcohen @later tell mtompset please check what happened to t/db_dependent/Filter_MARC_ViewPolicy.t that seems to completely fail here 19:10 huginn tcohen: The operation succeeded. 19:12 tcohen later #koha 19:43 beatsforthemind Is there anyway to use Search.pm to return results outside of Koha? 19:53 cait beatsforthemind: what's your goal? 19:53 cait i mean, what are you trying to do? 19:54 beatsforthemind Looking to more less replicate the ‘Search the catalog’ search through a URL query of the Zebra SRU. 19:56 beatsforthemind So building a URL alonf the lines of http://myserver.com:9999/biblios?version=1.1&operation=searchRetrieve&query=water&startRecord=1&maximumRecords=10&recordSchema=marcxml 19:56 cait hm yeah, but waht for? 19:56 cait i mean, what do you want to use it for? 19:56 cait maybe we could suggest something if we have a better idea about your project 19:57 barton beatsforthemind: I think that I would be leaning toward elasticsearch. 19:57 beatsforthemind A client (non-profit enviromental org) is looking to query their Koha database and use the records on another website (WordPress). 19:58 beatsforthemind They want to get the results of a kw,wrdl search and place them on a different site. 20:00 beatsforthemind Using Zebra I was parsing the MARCXML response with this -> https://github.com/scriptotek/php-marc 20:01 beatsforthemind They also want to be able to return records by tag, I’ve figured this out. 20:02 cait hm 20:02 cait yeah sru should be right then 20:02 beatsforthemind But, they also want to do a general search on records that have a specific tag 20:02 cait but maybe it's not so bad if you don#t get a perfect replicate 20:03 cait as someone pointed out earlier, there is some logic in search.pm that you probably can't replicate with sru - but might not have to 20:04 beatsforthemind I guess my skills as a developer might not be were they need to be for me to replicate what is going on there. 20:07 beatsforthemind Does elastic search implement another server tech like Lucene or Solr? 20:08 drojf ES uses lucene. like solr does 20:08 drojf i think 20:10 pianohacker_DND yup 20:13 drojf i used a public report in koha for a webapp once. that gave me JSON of my query result to use in the webapp. maybe that is an option here too 20:15 beatsforthemind How do you generate this JSON? 20:16 barton beatsforthemind: if you make the report public, it's available as a web service. I forget how the url is constructed off hand. 20:17 cait drojf: depending on the size of the db it might be a bit slow 20:17 barton or depengng on the query ;-) 20:17 cait but it could work... but works direclty on the mysql database then 20:20 drojf http://opac.abunchofthings.net/cgi-bin/koha/svc/report?id=1 20:20 barton drojf++ 20:22 drojf yes it uses sql queries. so it's not going to be a copy of the zebra search 20:22 beatsforthemind This might work 20:25 drojf it's probably easier to work with than zebra ;) 20:30 beatsforthemind It sort of gives me what I’m looking for. It doesn’t replicate a general search and the flat json might be little hard to work with. 20:31 beatsforthemind The repo I linked for parsing marcxml works pretty great 20:32 drojf you can make the sql query output whatever you need. inclusing the marcxml blob 20:32 drojf *including 20:34 beatsforthemind At that point query the database directly might be a decent option as well. 20:34 beatsforthemind querying* 20:49 beatsforthemind Actually, is the MARC data for records that Zebra is indexing stored in the database? 20:50 cait biblioitems.marcxml 20:53 beatsforthemind ah, thanks 22:44 DooRooK Hey Koha IRC. 22:44 DooRooK Has anyone already tried to install the CoverFlow plugin ? 22:45 kidclamp Many times DooRooL 22:45 kidclamp Many times DooRooK 22:45 DooRooK I'm having issue trying to make it works 22:45 kidclamp Where are you having problems? 22:46 DooRooK i'm following this tutorial : http://bywatersolutions.com/2014/08/18/koha-coverflow-plugin/ 22:46 kidclamp so you have plugin installed as per directions here: https://github.com/bywatersolutions/koha-plugin-coverflow 22:46 kidclamp ? 22:47 DooRooK it seems that the files where the plugin should be installed are not there. /var/lib/koha/mylib/plugin remain empty 22:47 DooRooK and nothing appear in my OPAC 22:47 kidclamp Are the permissions for the directory set right? 22:48 DooRooK hmmm, haven't checked, the directory was made by koha 22:48 kidclamp Try the github directions 22:48 kidclamp make sure that apache can access and write the pluginsdir 22:48 kidclamp if on jessie you need to add 22:48 kidclamp the stanza mentioned in github instructions 22:49 kidclamp and I am leaving for the weekend, but email the listserv or find me on monday 22:49 kidclamp if you still have issues 22:49 kidclamp good luck DooRooK 23:05 DooRooK Well, I still have no clues, the permission are set, the report is made, plugin seems to be installed (Can see it made the opacuserjs) and the alias are also set in the apache2 file my library