IRC log for #koha, 2014-06-10

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
00:06 mtj rangi, awesome
00:43 gmcharlt pianohacker: heading out the door; drop me a note, pelase
00:44 pianohacker @later tell gmcharlt The overdrive code depends on being able to connect to OverDrive over HTTPS. It turns out most Koha Debian installations don't ship the necessary packages. What would be the best way to resolve this?
00:44 huginn pianohacker: The operation succeeded.
00:53 mtj hey eythian - what do you think about a koha package update, rebuilding language files?
00:55 rocio joined #koha
01:00 eythian mtj: what do you mean?
01:00 pianohacker: submit a patch for the packages to include it.
01:02 pianohacker eythian: Okay. Two questions: a) does that involve changing debian/control? b) are there any problems that you know of with the packages depending on libio-socket-perl and libcrypt-ssleay-perl?
01:06 eythian ah, I didn't realise it was a perl dep, I figured it was a C lib or something
01:06 in that case, add it to C4/Installer/PerlDependencies.pm and everything will work out.
01:07 pianohacker oh, cool. It's autogenerated?
01:07 mtj eythian: add a final task to the package install,  to update the language files
01:07 eythian mtj: bug 10942
01:07 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=10942 enhancement, P5 - low, ---, tomascohen, Pushed to Master , Provide a way for package upgrades to update template translations
01:08 eythian you mean like it already does? :)
01:08 or do you mean something else?
01:09 mtj no, thats the one :p
01:09 eythian pianohacker: it's not, I manually do it every so often.
01:10 * dcook needs to remember to take a look at PerlDependencies.pm again sometime..
01:10 dcook Of course, when something doesn't come up when checking the deps, you find out pretty fast..
01:14 pianohacker @later tell gmcharlt just filed http://bugs.koha-community.org[…]_bug.cgi?id=12393 for the current favored fix; possible 3.16.1 candidate if it's ready in time?
01:14 huginn pianohacker: The operation succeeded.
01:14 04Bug 12393: normal, P5 - low, ---, jweaver, NEW , OverDrive does not depend on SSL modules for LWP, causing searches to fail
01:16 pianohacker eythian: is there any kind of ordering to PerlDependencies.pm?
01:16 eythian pianohacker: no
01:17 pianohacker heh, okay. Thanks
01:17 eythian++ # Thanks for all your help
01:17 eythian np
01:17 rocio joined #koha
01:28 rocio left #koha
01:43 dcook Bleargh...
01:46 pianohacker eythian: okay, here's a riddle for you. In wheezy, debian split the HTTPS support for LWP into a separate package, called liblwp-protocol-https-perl. We can't depend on this package in squeeze, as it doesn't exist, but without it we don't get HTTPS support in wheezy
01:47 is the answer to this riddle "we no longer support squeeze" or "you should put a comment in PerlDependencies.pm"?
01:47 eythian neither
01:47 pianohacker ooh
01:47 eythian the conversion of PD.pm is scripted, I don't actually read it.
01:48 pianohacker Ah. Wondered if that was so.
01:48 eythian That's a little tricky.
01:48 It's possible that the best solution is to do it manually.
01:48 (which isn't a big deal.)
01:50 jcamins Require either liblwp-protocol-https-perl or liblwp-perl < x.x.x
01:50 eythian yeah
01:50 pianohacker You can do that in debian dependencies?
01:50 eythian sure
01:50 a|b
01:51 pianohacker Cool. Didn't know that
01:51 eythian I'm just trying to figure out the best way to do it
01:51 I'd probably add an override to debian/list-deps
01:51 pianohacker eythian: is there anything I can provide in my patch besides the PerlDependencies.pm update?
01:51 eythian it already has the facility for that, though nothing is using it right now.
01:52 so it'd be something like Whatever::It::Is => 'liblwp-protocol-https-perl|libthe-other-one-perl'
01:54 oh, the code for handling overrides should be moved to the top of the if block
01:54 so that it gets checked first
01:54 pianohacker eythian: so, in this case, LWP::Protocol::https => 'liblwp-protocol-https-perl|libwww-perl<6.00' ?
01:55 heh, lines 71-81
01:55 eythian 'liblwp-protocol-https-perl|libwww-perl (<6.00)' I think is the correct format. Make sure you double check the version is correct.
01:55 yeah, liw did that :)
01:56 https://www.debian.org/doc/deb[…]elationships.html
02:09 http://www.trademe.co.nz/brows[…]55&/listing?rfm=1 <-- does my lounge need this?
02:10 pianohacker hah, yeah, that's cool
02:10 oh. pbuilder does a debootstrap O_o
02:10 * pianohacker goes to make dinner
02:14 eythian well, that's kinda its thing
02:22 jce mtj:  if you're still on, fix-090-to-999.pl worked like a charm.  Now I just need to figure out how to fix the framework and Koha to MARC mappings.
02:23 eythian jce: import them from the sql files in koha
02:23 there's probably other issues in there anyway
02:25 jce eythian:  import the framework and mappings from the sql files?
02:25 eythian yeah, replace the ones currently in the database with the default ones.
02:27 jce Where would I find the sql files that have the defaults?
02:27 eythian left #koha
02:27 eythian joined #koha
02:28 eythian ^W is not delete word back in this IRC client...
02:28 installer/data/mysql/
02:28 jce Thanks.  I'll give it a look.
02:34 I'm looking at installer/data/mysql/en/marcflavour/mar​c21/mandatory/marc21_framework_DEFAULT.sql  Is this what Koha loads up as the default framework in Home->Administration->MARC frameworks?  If so, do I need to load the SQL again, or can I just make a new framework based on the default?
02:39 eythian not sure.
02:39 I'd be inclined to delete all the existing frameworks and reload the default
02:40 Oh, if you create a new framework from default, it won't load that. It'll copy the default that's currently in the system.
02:41 jce Well, there really isn't anything here but a "Test framework" I probably set up when I was first playing around with the initial version of this system in about 2007.
02:42 eythian yeah, then I'd delete it and load the default in.
02:43 jce So you think I should delete the test framework (the only thing there besides 'default') and load the default SQL to refresh the default framework.
02:43 Can I do that in phpmyadmin?
02:43 eythian check the SQL first, make sure it won't go weird if it gets loaded in twice.
02:43 yeah
02:43 I tend to use mysql at the command line though
02:44 jce I'd have to get out my O'Reilly book and read a bit.  :)
02:47 Not sure I'd be able to tell from the SQL whether it would mess things up if I reload it.
02:48 Not afraid of the command line, but just don't spend much time with MySQL.
02:49 eythian it looks like if you load that file, it will add anything that's not there, but won't change anything that's already there.
02:50 Which is normally sensible.
02:50 jce Sounds good to me.
02:50 eythian up to you, I'd probably be inclined to delete everything and load it though
02:50 dcook The only downside is if something has been changed
02:50 eythian just because you might have some really old stuff in tehre.
02:50 * dcook would probably delete everything and load it
02:51 jce Is that all in a particular table I could drop?
02:51 eythian marc_tag_structure and marc_subfield_structure
02:52 jce Ok.  I'm going to export both of those tables, then drop them.
02:54 eythian (note that I assume you're working with a backup of your whole database lying around safely somewhere.)
02:55 jce Yes, an SQL backup, the 'real' server, and another copy of the VM I'm currently working on.
02:55 eythian cool
02:56 jce Should I drop the table or truncate it?
02:57 eythian truncate
02:57 (most likely)
03:03 jce Ok, I've truncated both tables.  phpmyadmin is being a dork and not allowing me to import from the SQL file.  Rather than adjust its attitude, it would probably be easier to load it up via the command line, if I could come up with the proper mysql incantation.
03:04 eythian you have packages installed?
03:05 jce Yes.
03:05 eythian if so, sudo koha-mysql instancename
03:05 then \. /path/to/file.sql
03:09 jce Hmm.  I got some error messages.  Duplicate entries:  999 for key PRIMARY, 999-a for key PRIMARY, 942, 942-a, 952, 952-0, 000, 000-@ for key PRIMARY.
03:12 eythian hmm
03:12 maybe the schema is old
03:12 might be worth dropping the tables if it'll let you and recreating them from kohastructure.sql (copy-paste the creates out, otherwise madness will happen.
03:13 )
03:13 jce Probably is.  I remember running scripts to upgrade schema in the past.  Should I try one of those?
03:14 eythian no, best to do it from fresh.
03:20 jce Ok, I've found the section in kohastructure.sql for marc_subfield_structure.  It has a DROP TABLE IF EXISTS and CREATE TABLE for marc_subfield_structure.  Should I copy just that section and the one for marc_tag_structure and paste them into a new file?
03:20 eythian yeah
03:20 or directly into mysql
03:21 yay, facet bug fixed, now they work properly under ES!
03:21 jce But I want to keep the DROP TABLE IF EXISTS and CREATE TABLE just for these tables, no?
03:21 eythian well, better anyway
03:21 wahanui i heard better was "take cover." :)
03:21 eythian yeah
03:22 because you want to drop them and create them
03:22 jce Right.
03:24 eythian OK everyone, how should facets work? Should they be ordered according to how common that field is within the results, or should it be alphabetical, or something else?
03:26 currently it seems be taking the most popular and sorting them alphabetically.
03:26 *10 most popular
03:26 actually, this is a tricky question given that ES shows the facets for the whole result set, not just the current page.
03:28 OK, so I might have it show the most popular 5 until you expand it when it shows 20. Something like that.
03:31 dcook eythian: Hmm?
03:32 eythian you're going to have to clarify your musing there, dcook.
03:32 dcook Was just about to :)
03:32 I think it would make sense if they were ordered in regards to the number of hits so to speak?
03:32 Like...dates
03:32 eythian that's what I mean by popular
03:32 dcook 2012 (50), 2009 (25), 2010 (4)
03:32 eythian that's what it does now
03:32 dcook Mmm, I figured, but hence the hmm
03:33 * dcook ponders
03:33 dcook I wonder if there is a time when you'd rather have 2012, 2011, 2010, 2009...
03:33 That's a good point
03:33 eythian I'm not going to do that
03:33 I can do magic with date faceting
03:33 but maybe later :)
03:33 dcook hehe
03:33 eythian e.g. I could have it do 1900-1950, 1950-2000, 2000-
03:34 jce All right.  I fixed the default framework schema, and re-imported the default framework from the SQL with no errors reported.  So now I make a new framework from the default?
03:35 eythian if you like
03:35 jce And then fix Koha to MARC mapping.
03:35 eythian you could probably do the same process for that.
03:36 actually, I'm going to fix facet expansion later. It's low priority
03:36 Better getting more things to be searchable.
03:37 dcook :D
03:37 eythian Oh, I'll ahve to implement availability at some stage.
03:38 That'll be terrible.
03:39 whammywon joined #koha
03:39 whammywon hello
03:39 wahanui privet, whammywon
03:39 whammywon does anyone know if koha offers encryption for library files?
03:40 rangi what files?
03:40 wahanui files are not touched by the template translation process, you will have to do it manually
03:40 jce eythian:  Actually, when I look at Koha to MARC mapping now, it has biblionumber mapped to 999.  I wonder if fix-090-to-999.pl did that for me.
03:40 whammywon OK. would I need a third party encryption software?
03:40 eythian http://i.imgur.com/FDzHkWg.png <-- I may have to improve the error handling at some stage too. This might be a little too cryptic.
03:41 rangi whammywon: ignore wahanui, its a bot
03:41 whammywon: what files are you talking about encrypting?
03:41 eythian wahanui: are you a bot?
03:41 wahanui eythian: wish i knew
03:41 whammywon like patron information and history. etc...
03:41 rangi they arent stored in files, but in a database
03:42 whammywon oh. that's right.
03:42 wahanui no it's not.
03:42 whammywon anybody happen to know if MySQL encrypts?
03:42 rangi id doubt it
03:42 but you could put it on an encrypted partition, id imagine it would be hella slow though
03:43 eythian it doesn't.
03:43 whammywon OK. thank you @rangi!
03:43 eythian It probably wouldn't be bad on good hardware
03:43 a lot of newer chipsets have built in AES support, which is stupid fast.
03:43 rangi ah true
03:43 that was a fairly random request
03:44 * dcook found wahanui amusing though
03:44 dcook eythian: Good call on the error handling :p
03:45 jce eythian:  Many thanks for your help.  I think I'm on the right track now.  Going to check out for tonight, though.
03:45 eythian good stuff
03:46 rangi dcook: https://www.youtube.com/watch?v=WGvyjKLLnp4
04:05 trendynick joined #koha
04:12 dcook hehe
04:13 rangi: Oh sure. Invite tourists to feed your vampire habits...
04:16 mtompset Have a great day, rangi dcook eythian #koha.
04:17 eythian later
04:28 dcook joined #koha
04:34 eythian OK, language searching works. Thanks to some badly catalogued data for helping out with that.
04:34 dcook hehe
04:35 eythian "term" : "eng",
04:35 "count" : 3028
04:35 "term" : "en",
04:35 "count" : 17
04:35 "term" : "ng",
04:35 "count" : 15
04:35 rangi heh
04:37 eythian It's reaching the point that I had some unit tests in this. It's getting large enough that making one thing work has a reasonable chance of breaking something else.
04:39 I say this because my previous fix broke something else.
04:47 dcook Sounds familiar
04:48 eythian http://youtu.be/UnphFxH3FxM <-- truely horrifying
04:55 pianohacker joined #koha
04:57 pianohacker eythian: bug 12393 if you're interested
04:57 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=12393 normal, P5 - low, ---, jweaver, Needs Signoff , OverDrive does not depend on SSL modules for LWP, causing searches to fail
04:57 * pianohacker scurries off
05:00 aleisha joined #koha
05:02 rangi aleisha: http://bugs.koha-community.org[…]_bug.cgi?id=12377
05:02 huginn 04Bug 12377: enhancement, P5 - low, ---, kyle, Needs Signoff , Add date pickers to serials-edit.pl
05:02 rangi might be a good one to test
05:16 or http://bugs.koha-community.org[…]ow_bug.cgi?id=643
05:16 huginn 04Bug 643: enhancement, P2, ---, pasi.kallinen, Needs Signoff , Allow override of 'debarred' status
05:17 laurence joined #koha
05:18 jseplae joined #koha
05:21 aleisha cool i signed off on that first one rangi
05:21 rangi awesome!
05:21 wahanui That'll be $1 for the awesome jar, rangi
05:42 dcook Got to love police checks...
05:42 Trying to recall 10 years of addresses...
05:43 I'm back 3 years and I already have 4 listed...
05:43 eythian surely the police aren't doing their job if they don't know that.
05:44 dcook I know, right?
05:44 Oh well. Good data to have for myself anyway...
05:45 * dcook feels bad for the people who check up on these things
05:46 irma send them to us dcook we will vouch for you ;-)
05:46 dcook <3
05:47 I already have my Canadian police check done, so I don't know why the Australian police need 7.5 years of Canadian addresses :p
05:47 The Canadian police didn't need it :p
05:47 eythian well, they don't care: you left :)
05:47 irma just to fill in the boxes on the form?
05:47 dcook Ink fingerprints though...I hope I never have to get ink fingerprints again...
05:47 cait joined #koha
05:47 dcook eythian: good point :p
05:47 irma: Pretty sure that's the one ;)
05:47 * dcook waves to cait
05:48 dcook Let's see if I can recall my address from when I first started uni..
05:48 Yay for email to family members...
05:49 And a good memory :p
05:49 * cait waves back and yawns
05:49 dcook Oh my... my "apartment" has three sets of numbers..
05:49 had*
05:50 It's practically a telephone number
05:50 irma dcook Bon courage!
05:51 eythian hi cait, irma
05:51 dac joined #koha
05:52 irma hi eythian and cait
05:52 cait hallo Irma and hi eythian :)
05:53 dcook 8 addresses in 10 years
05:54 With a total of...11 moves?
05:54 * dcook re-used addresses :p
05:55 eythian I only had 4 or 5 addresses at uni, don't think I could remember them all.
05:55 though, that goes back more than 7.5 years.
05:55 irma hallo cait ... Bist Du nicht zu muede nach der Konferenz?
05:56 Das war letzte Woche?
05:56 dcook eythian: I did 3 qualifications in two different provinces and three different cities...and lived in 4 different locales in that time
05:56 Fortunately, i only moved across the hall between years 1 and 2...
05:57 Even numbered apartments for guys, and I recall the room number based on position within the apartment...
05:57 irma dcook un pigeon voyageur?
05:57 dcook (And one email to my sister)
05:58 irma: Je suppose :p
05:58 Let's hope their website didn't time out..
05:59 irma Oh I should get on with it ... Bis bald! A bientot! Tot Ziens! Despedida!
05:59 dcook A+ :)
06:00 eythian Toodlepip!
06:01 irma eythian Toodle Pip!
06:02 I am serious now ... I must really leave... Ciao!
06:05 cait irma: sorry, was getting ready for work - had 3 days to recover, but now it's  really hot here... :)
06:05 @wunder Konstanz
06:05 huginn cait: The current temperature in Konstanz, Germany is 22.0°C (8:00 AM CEST on June 10, 2014). Conditions: Scattered Clouds. Humidity: 53%. Dew Point: 14.0°C. Pressure: 30.04 in 1017 hPa (Rising).
06:05 cait it's only 8 am
06:06 eythian @wunder nzwn
06:06 huginn eythian: The current temperature in Wellington, New Zealand is 13.0°C (5:30 PM NZST on June 10, 2014). Conditions: Light Rain. Humidity: 88%. Dew Point: 11.0°C. Pressure: 30.18 in 1022 hPa (Steady).
06:07 eythian 'query' => '(_all:a) AND copydate:[1970 TO 1980]'
06:07 cool, date range searching might be working.
06:08 holy crap, it does work
06:10 it's slightly annoying we have both publication date and copydate.
06:10 Though, I suppose they're possibly different things.
06:11 dcook Iirc, they can be different things...but we don't use them that way
06:11 So they're mostly just annoying :p
06:12 Yeah, they can definitely be different...because you can have a publication date of yesterday, but the copyright date might be from decades ago
06:12 * dcook recalls doing stuff with different dates back when he used to catalogue
06:12 eythian yeah. it's just you sort by publication date, but search by copydate
06:12 dcook Yeah, we should probably just be using pubdate
06:12 But I don't think the data supports that :/
06:13 Because of the Koha => Marc mappings
06:13 Well...I suppose we could just use pubdate..
06:13 eythian it'd totally work in ES
06:13 * dcook goes back to his police stuff though
06:13 eythian probably even zebra
06:13 dcook bbiab
06:13 eythian: totes
06:14 The police should redo this form...it mangled my address history...:/
06:14 Well...not mangled. Sorted badly.
06:14 eythian ok, if you're restricting to a branch, is that homebranch or holdingbranch?
06:14 it just comes through as 'branch' in the URL, and record.abs has nothing called just 'branch'
06:15 dcook You'll have to look at Search.pm for that one, I think. Specifically in the limits bit?
06:16 eythian yeah, it passes it through as 'branch:...'
06:16 Maybe it just never worked.
06:16 993:branch homebranch
06:16 ahh
06:16 that'll be it
06:17 cait eythian: yeah publicationdate and copyrightdate are annoying :( just seems quite hard to clean up for existin ginstallations
06:17 eythian yeah
06:17 cait i man... we could
06:18 change all the mappings... copy the data from one column to another... change the reports... but if the library changed the mappings from the default hm.
06:18 wahanui cait: that doesn't look right
06:18 wahanui joined #koha
06:19 eythian cait: well, we'd just have to change the hardcoded bits in Koha I think
06:19 they're named differently, it's just sometimes one is used, sometimes the other.
06:19 cait i think most of the hardcoded bits right now look at both fields
06:19 ah
06:19 it's mostly a unimarc/marc21 problem right now
06:19 unimarc has the default mapping on pubdate
06:20 marc21 has the default mapping to copyrightdate
06:20 so a lot of code 'shoudl' look at both
06:20 for search it probably makes sense to use the normalized form of the year, as the pub date ranges do now... 008? 007? one of those
06:21 eythian yeah
06:21 that's so often wrong though, although maybe I'm using bad data.
06:21 cait maybe
06:21 ours is pretty good there
06:21 but i think migrated data might not always have it
06:22 eythian yeah, it's a bugger to migrate into those control fields.
06:22 cait or people are not aware that they want that to make the pub date range search work
06:22 we try to set a few fields correctly at least, the pubdate being one of them, and the media type things
06:25 eythian oh well, I'll implement things according to what it currently does. Changing it later can be a different battle :)
06:26 I have most of the advanced search form working with ES now.
06:26 cait woohoo :)
06:26 eythian That's one of my milestone goals.
06:26 cait very nice :)
06:26 what's next?
06:26 wahanui somebody said next was translation manager
06:26 eythian no, not translation manager.
06:26 One of the people paying for this wants a browse interface, so I need to figure out how to do that.
06:26 I have some ideas.
06:27 that is, view an ordered list of all things (say, authors), and you can select one to see the results that have that.
06:27 or something along those lines.
06:28 with a search to jump into the middle of it. That's the bit that I don't know how to do yet.
06:28 cait hm ideally it should show how many
06:28 eythian that's totally possible
06:28 cait before you click, that would be nice
06:29 we had that in other ILS i used... always a big thing
06:29 eythian I actually added that to the facets for debug purposes, if you hover on a facet it says "blahblah (23)"
06:29 cait it gets really troublesome for callnumbers
06:29 because most libraries here don't use dewey or similar, but each has their own scheme of things, or a lot have
06:29 hm the facets shoudl totally show the number visibly
06:29 we can do that nwo too - it's just not always correct
06:30 displayFacetCount system preference
06:31 eythian the problem is that zebra facets on what's displayed. ES facets on all the possible results, which is what makes the most sense.
06:31 ah, handy.
06:31 cait yeah i know
06:32 you can set th enumber higher... but it will slow down things significantly
06:32 eythian yeah
06:32 cait but i hope that we get 'real' facets with ES :)
06:33 so we don't have to cheat with the features and it just works :)
06:33 eythian you do. I've also got it now so you can pick and choose what to facet on separate from what's indexed into a field. So you can put 245$c into 'author' and search on it, but it won't show in the facets.
06:34 (I'm cheating: every field you care about for facets creates a field like 'author__facet' internally, and that's used for faceting, but it's not indexed for searching.)
06:34 cait eythian: hm that might lead to the number being incorrect
06:35 it#s a problem we have now too - the indexes are wider than the fields we display in the facets
06:35 i had to 'fix' that for a recent project
06:35 eythian I don't know for sure, but I suspect that ES is smarter than that.
06:35 cait might be :)
06:35 what happns if it can't display anything for the description?
06:36 like... there should be a facet, but there isn#t anything in the fields to display?
06:36 eythian > Also note that terms are counted once per document, even if the occur more frequently in that document.
06:36 then the facet doesn't show up if there's nothing to show.
06:36 cait ah
06:36 makes sense
06:37 curious to take a closer look :) now i need to get myself to work
06:37 i think i have to test some developments today :)
06:37 eythian e.g. right now you only see authors, itype, and topics.
06:37 as that's all I'm faceting right now
06:37 Need to do the other facets soon too.
06:38 dcook Year would be rad :)
06:38 cait and also... the aftermath of library conf to deal with...
06:38 dcook And language..
06:38 wahanui language is filed letter by letter word by word
06:38 cait year, places, language yep
06:38 dcook Maybe record type as well...
06:38 eythian I'm not doing anything that's not already done by zebra at this stage, so it doesn't require changes to opac-results.tt
06:39 dcook Although itype can be a lot more useful than record type I think
06:39 Mmm, fair enough
06:39 Btw, police check sent!
06:39 eythian so, authors, titles (which is an odd one really), topics, places, series, item types.
06:39 dcook I think I have one PDF form and one application to do...then to finish the online form...then that's it!
06:40 eythian I'm not sold on the idea of faceting titles.
06:40 dcook Titles? Is that done currently?
06:40 eythian it's in opac-facets.tt
06:40 dcook Weiiird
06:40 eythian whether they're actually generated is a different matter.
06:40 dcook Ahhh
06:40 Uniform title
06:40 That's a bit different
06:40 eythian oh right
06:40 * dcook just saw it in an instance
06:40 eythian I suppose that makes some sense.
06:40 dcook For sure
06:41 Well...
06:41 Some sense
06:41 eythian oh, libraries and location too. I missed those.
06:41 reiveune joined #koha
06:42 reiveune hello
06:42 wahanui bonjour, reiveune
06:43 eythian oh, content type already works, that's nice of it.
06:46 cait ok, now I have to run...
06:46 bye all
06:46 cait left #koha
06:52 yohann joined #koha
06:53 magnuse joined #koha
06:53 ashimema joined #koha
06:54 * magnuse waves
06:54 alex_a joined #koha
06:55 alex_a bonjour
06:55 ashimema morning #koha
06:55 magnuse @wunder boo
06:55 * dcook waves to alex_a and ashimema
06:55 huginn magnuse: The current temperature in Bodo, Norway is 12.0°C (8:20 AM CEST on June 10, 2014). Conditions: Mostly Cloudy. Humidity: 94%. Dew Point: 11.0°C. Pressure: 30.21 in 1023 hPa (Steady).
06:55 dcook @wunder sydney, australia
06:55 huginn dcook: The current temperature in Sydney, New South Wales is 17.0°C (4:30 PM EST on June 10, 2014). Conditions: Partly Cloudy. Humidity: 48%. Dew Point: 6.0°C. Pressure: 30.33 in 1027 hPa (Steady).
06:55 dcook eythian: content type?
06:55 eythian it's a MARC thing
06:57 dcook Which part of MARC?
06:57 eythian 008/22
06:57 no wait
06:57 somewhere around there anyway
06:57 dcook I was about to say..:p
06:57 eythian 24-27
06:57 dcook That seems a bit dodgy :/
06:57 Since that's dependent on leader values
06:58 eythian It'll be a bit dodgy. It's a minor thing for a future time.
06:58 though, it maps into ccl
06:58 so it'll be doing the same as zebra
06:58 dcook Hmm, I've never encountered it. Weird.
06:59 eythian it's down the bottom of the advanced search
07:00 'query' => '(_all:book) AND NOT onloan'
07:00 I wonder if that works
07:00 dcook Huh...interesting
07:00 * dcook was wondering about the available "facet" as well
07:01 eythian it's a fauxcet
07:02 dcook hehe
07:02 I like that
07:02 These content limits are weird...although I get the idea..
07:02 * dcook wonders how many false positives come up with it
07:03 eythian I dunno, probably quite a few.
07:03 The way MARC does all that is terribly stupid.
07:03 dcook Agreed
07:05 Yeah, these mappings bank on people having mostly book collectinos
07:05 I suppose it's probably an accurate assumption, but it's...icky
07:06 Probably could do it much nicer in DOM...
07:07 Mmm then again...maybe not
07:07 magnuse MARC must die!
07:07 wahanui http://marc-must-die.info/
07:09 paul_p joined #koha
07:10 eythian hmm, I'm going to have to do some fancy mapping stuff to deal with onloan, so that it sets it to, say, '0' if it's not onloan so that it can be searched.
07:11 I'll do that tomorrow. Now I should leave.
07:11 dcook Rest well, eythian ;)
07:11 We totally could do content better with DOM btw...
07:11 GRS-1...*shudders*
07:11 eythian in what sense?
07:11 oh
07:12 yeah
07:12 dcook Checking the leader before putting data in an index and such
07:12 eythian catmandu (what converts MARC to elasticsearch) has a mapping language. It's fairly limited, but functional enough.
07:13 dcook I saw some of your perl4lib emails. It looks...interesting
07:13 eythian ah yep
07:13 dcook Not sure I followed what was going on with those repeated subfields
07:13 eythian at the moment I'm generating them from a database.
07:13 dcook ?
07:15 eythian oh, it was taking 650aAAA$vBBB$vCCC and giving me subject:["AAA", "BBBCCC"], where I wanted subject:["AAA","BBB","CCC"]
07:15 now I get subject:[["AAA"],["BBB"],["CCC"]] which is weird but works fine.
07:18 * eythian is outta here
07:18 eythian later all
07:19 dcook Yeah, I would want subject:["AAA","BBB","CCC"]. subject:[["AAA"],["BBB"],["CCC"]] is weird...but...I guess so long as it works?
07:19 night!
07:19 eythian++
07:43 Joubu hello
07:44 Can someone please test bug 12396? This should be pushed asap
07:44 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=12396 blocker, P5 - low, ---, olli-antti.kivilahti, Needs Signoff , MTT FIX: Due notices (DUEDGST) are multiplicated and everybodys all ODUEDGST are sent to everyone who should receive them.
07:51 magnuse joined #koha
08:03 paxed fun fun fun.
08:08 (wasn't that tested properly?)
08:10 jseplae Hello all - a Koha-newbie here! I'm doing an internship involving, among other things, Koha-development. I've been working on some usability-improvements for the cataloguing/additem -view that are currently organization-spesific - is there a need for a generalized way to automatically fill the available SigNum form fields (for example)?
08:16 mveron joined #koha
08:17 mveron Hi #koha
08:19 * mveron is in search for somebody to sign-off bug 12266 (z39.50 authority search broken)
08:19 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=12266 normal, P3, ---, gmcharlt, Needs Signoff , The z39.50 authority search to create new auth record works randomly
08:28 sophie_m joined #koha
08:36 Joubu mveron: I keep my token for the QA step ;)
08:44 mveron Joubu: Ok  :-)
09:02 cait joined #koha
09:28 nc-th joined #koha
09:33 magnuse joined #koha
09:34 nc-th I am using Koha 3.14. I have a question about RLIST. Please correct me if I am wrong. If I have 2 users in the RLIST for a serial, once the Library staff receives the new issue and catalogs, the first user in the RLIST will receive a notification email. Then after the first user returns the serial, the system will generate another notification email to the second user. Is that right?
10:03 aruntomar joined #koha
10:11 kivilahtio joined #koha
10:11 magnuse kia ora kivilahtio
10:11 kivilahtio ki ora magnuse
10:12 magnuse: Do you have any idea if there is some functiomnality to do with overlaying Marc records? Specifically we have an issue with getting slim MARC records from our bookvendor and fully catalogued MARC records from our bibliographic cataloguing company. The full records don't have 856 and overwrite the bookvendor 856 field.
10:13 so we stage import a record which overlays an existing record, and we lost some fields we dont want to lose
10:13 I am looking to make an improvement on that based on the matching rules, as that seems to provide the GUI needed.
10:14 so you could select the matching rule and an overlay rule
10:14 magnuse: Any ideas if there is some feature I am overlooking?
10:17 BTW we are running week 2 of Koha in production :)
10:17 It is much less worse than I anticipated. Things are running quite smoothly
10:47 magnuse kivilahtio: yay for things running smoothly
10:48 and i don't *think* there is anything that does what you want to do
10:48 but i think there have been some talk about it
10:48 tcohen joined #koha
10:49 magnuse maybe in relaton to the marc modification templates?
10:49 kivilahtio: if i were you i'd send an email to the dev list and ask what others have thought about in this area
11:12 NateC joined #koha
11:22 mveron joined #koha
11:27 drojf joined #koha
11:27 drojf hi #koha
11:30 mtj hiya magnuse, kivilahtio, drojf
11:30 drojf hi mtj
11:31 mtj kivilahtio:  did you manage to find some good performance from your prod server?
11:31 kivilahtio mtj: pretty awesome
11:31 mtj: Looking forward to changing to nginx + starman + plack
11:32 mtj: but it looks like plack for staff client is stil lin development
11:32 magnuse: they can't work so I'll hack something up for them
11:33 magnuse: I think I will reuse the matching rules somehow, lets see what I cook up :)
11:34 mtj: read a book about nginx last weekend, because got pretty frustrated to the apache2 limitations. It is pretty damn hard to authenticate our users with Koha credentials using apache2
11:35 we have print notices and offline .koc files that need to be distributed, so having an apache2 indexed directory with mod_auth_dbd
11:35 but apache2 md5 password hashing is not compatible with the mysql md5 hashing gaaaaahhh
11:35 I dont wanna hack up a LDAP
11:35 mtj meh, typical :/
11:36 kivilahtio nginx has perl authentication, I think it is a perl module which authenticates
11:36 I mean a perl script which can authenticate
11:36 mtj: That will nicely solve the authentication issue :)
11:36 mtj kivilahtio:  some interesting speed  stuff for koha   -> https://developers.google.com/speed/pagespeed
11:37 kivilahtio thanks!
11:37 mtj ...it seems to fix some common problems after koha upgrades, too
11:38 ...around browsers caching old versions of css and js files, after upgrade
11:40 its very quick to install, so worth a little play :)
11:41 https://developers.google.com/[…]d/module/download
11:41 kivilahtio we have had issues with mac users with safari from accessing our OPAC
11:42 they are forwarded to their opac-details.pl from Liferay, and they are prompted to authneticate on the fly
11:42 but this seems to be an issue for some safari's
11:42 apparently all works smoothly fomr the OPAC main page
11:43 mtj you are on 3.14.x, with bootstrap opac?
11:44 kivilahtio erm yes
11:44 actually we are running master from 2 months ago, but aiming to rebase asap
11:44 there are already some bugs, but no show stoppers
11:45 we are going to 3.16
11:45 + our modifications
11:46 magnuse kivilahtio: after bug 12396 has been fixed, i presume?
11:46 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=12396 blocker, P5 - low, ---, olli-antti.kivilahti, Needs Signoff , MTT FIX: Due notices (DUEDGST) are multiplicated and everybodys all ODUEDGST are sent to everyone who should receive them.
11:47 kivilahtio magnuse: I already fixed that and we contained the problem and all the PR mess :)
11:47 people are generally very understanding and we havent got much fuzz
11:47 ofc it is rather nasty but there was no PR hit
11:48 magnuse: I think we might even end up in the local newspaper about that :)
11:48 magnuse: which might lead more people into our library. I feel any publicity is good publicity for us :)
11:48 magnuse: Tho I hope the titles are not larger, than when we migrated :)
11:49 we actually made the local news :)
11:49 nengard joined #koha
11:50 kivilahtio *made it to the local news
11:50 magnuse kivilahtio: cool :-)
11:53 meliss joined #koha
12:17 collum joined #koha
12:32 kivilahtio magnuse: I just heard that the radio is interviewing our library director about the incident
12:34 oleonard joined #koha
12:36 * cait waves and reads back
12:36 ashimema hi cait
12:38 oleonard Hi everyone
12:38 cait kivilahtio: overlay things... there is a bug for that in bugzilla
12:38 drojf!!!
12:38 wahanui hmmm... drojf is from Germany and developing Koha on a raspberry pi!
12:39 kivilahtio cait: There is? Not findable with overlay search term
12:40 drojf hi cait :)
12:41 cait i was going to send a search party for you 1
12:41 :)
12:41 kivilahtio: i can dig it up if you give me a moment
12:41 there is also something for your problem with distributing files
12:41 kivilahtio cait: you shall have one :)
12:41 cait and you shoudl talk to ashimema :)
12:42 drojf cait: a party \o/
12:42 ^^
12:42 cait bug 10477
12:42 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=10477 enhancement, P5 - low, ---, kohapatch, Failed QA , Increased flexibility for upload of Staged MARC records
12:43 cait the plus side... there is a patch to rescue
12:44 it's something we'd like to see too
12:46 bug 11317
12:46 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=11317 enhancement, P5 - low, ---, fcapovilla, Needs Signoff , Add a way to access files from the intranet.
12:46 Joubu kivilahtio: you would have find it if you used bzsplitter ;)
12:47 kivilahtio I dont understand that sp33k
12:47 I almost have a solution :)
12:48 oleonard nengard: Did you test Bug 12391 on master? Because it looks like Bug 12073
12:48 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=12391 major, P5 - low, ---, oleonard, NEW , printable versions of opac showing all kinds of html
12:48 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=12073 minor, P5 - low, ---, frederic, Pushed to Master , OPAC detail page printing show links URL
12:48 nengard I did not ... i'll go do that now
12:50 owen okay it works in master
12:50 so i guess we need that fixed on 3.14 if possible
12:50 I did find a problem in master's print version though
12:50 the credits are up at the top - i'll report separately
12:50 oleonard Bug 12260?
12:50 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=12260 enhancement, P5 - low, ---, oleonard, NEW , Printing a page from bootstrap shows unnecessary links
12:51 edveal joined #koha
12:52 nengard nope
12:53 http://screencast.com/t/iztmgf6AIUG
12:53 the footer showing at the top
12:53 you want a new bug for that?
12:54 oleonard Yes
12:54 nengard k
12:54 oleonard I guess we all need to do a little more printing during testing
12:55 nengard done
13:15 Dyrcona joined #koha
13:32 talljoy joined #koha
13:32 gaetan_B joined #koha
13:32 gaetan_B bonjour
13:34 Joubu oleonard: I tried to qa bug 12380 this morning but I didn't understand the problem
13:34 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=12380 normal, P5 - low, ---, gmcharlt, Signed Off , can't tab to save buttons on add item
13:35 Joubu oleonard: what do you mean by "try tabbing through the add item form fields"?
13:35 cait btw general reminder - we got a dev meeting tomorrow :)
13:35 http://wiki.koha-community.org[…]ing,_11_June_2014
13:38 oleonard Joubu: In the add/edit item form, place your cursor in any of the fields (barcode, call number, etc). Use the tab key to move to the next field. When you get to the end of the form the cursor jumps to the top of the page instead of selecting the "add item" button
13:41 Joubu oleonard: haaa! I learnt a new word today, I didn't know that "press the tab key" could be used with the "to tab" verb :)
13:41 oleonard Ah yes English speakers love to make verbs out of everything!
13:42 slef oleonard: ITYM English speakers love to verb everything ;)
13:45 oleonard Quite right :0
13:46 :)
13:53 rambutan verbose vocalization. There, it's an adjective too.
14:10 cait @wunder Konstanz
14:10 huginn cait: The current temperature in Konstanz, Germany is 32.0°C (4:00 PM CEST on June 10, 2014). Conditions: Scattered Clouds. Humidity: 16%. Dew Point: 10.0°C. Pressure: 29.98 in 1015 hPa (Falling).
14:10 cait gah.
14:22 nengard @wunder 78754
14:22 huginn nengard: The current temperature in University Hills, Austin, Texas is 20.1°C (9:22 AM CDT on June 10, 2014). Conditions: Clear. Humidity: 92%. Dew Point: 19.0°C. Pressure: 29.93 in 1013 hPa (Steady).
14:34 druthb @wunder 77098
14:34 huginn druthb: The current temperature in West U, West University Place, Texas is 27.1°C (9:34 AM CDT on June 10, 2014). Conditions: Scattered Clouds. Humidity: 74%. Dew Point: 22.0°C. Pressure: 29.82 in 1010 hPa (Rising).
14:43 nengard anyone remember if there is an existing bug report for the fact that the check in check boxes don't trigger holds or transfers? I know this is a long standing issue, just not sure how to find the bug report
14:43 bug 3514
14:43 found it
14:43 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=3514 major, P3, ---, koha-bugs, NEW , Returning items through patron Details tab doesn't activate all circulation functions
14:45 alex_a_ joined #koha
14:54 cait nengard: there shoudl be no check box now if the item is on hold
14:54 so a return should not be possible in that case
14:54 i think maybe transfers are not caught
14:54 nengard cait it still doesn't trigger transfers
14:54 right
14:54 i have confirmed this is the case on master and 3.14.x
14:55 transfers are not triggered still
14:55 cait by transfer you mean a transfer caused by a hold?
14:55 nengard nope
14:55 i mean a transfer
14:55 cait or is there a way to request a transfer without?
14:55 nengard here's the scenario
14:55 cait ah, so when the book needs to 'go back home' after return?
14:55 nengard yes
14:55 i'll stop typing the scenario :)
14:56 cait ah ok :)
14:56 sorry :)
14:56 nengard no it's okay!
14:56 Your 1 sentence was way better than the 6 I was going to write :) hehe
14:56 going to put this info on the bug report
14:57 rocio joined #koha
15:02 tgoat joined #koha
15:02 cait leaving for today - bye all
15:02 adiós
15:02 cait left #koha
15:05 yohann left #koha
15:12 nengard gmcharlt around?
15:13 gmcharlt nengard: what's up?
15:13 nengard bug 10314
15:13 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=10314 critical, P5 - low, ---, kyle, Failed QA , CanItemBeReserved does not respect the holds policies
15:13 nengard you changed the status on that last year and then there were replies after your failing it
15:13 do you need more info on that?
15:14 gmcharlt I'll take a look at the video
15:32 kmlussier joined #koha
16:40 pianohacker joined #koha
16:45 gaetan_B bye!
16:53 nengard joined #koha
16:58 reiveune bye
16:58 reiveune left #koha
17:11 gmcharlt pianohacker: what are the additional packages in question?
17:28 JoeLib001 joined #koha
17:29 JoeLib001 Hello Everyone. :-) I am still having problems with my Pending Orders not showing up when I go to receive them. I just upgraded from 3.14.x to 3.16.
17:41 talljoy hi koha!
17:41 got a quick package question.  will running sudo /etc/init.d/koha-common restart  cause any service disruption to libraries?  safe to do during the day?
17:41 JoeLib001 Hello you. :-)
17:41 talljoy Good afternoon!
17:42 JoeLib001 I would guess that it would cause service disruption. Shouldn't cause it to be down for long though.
17:43 talljoy okay.  i'm hesitant to pull a large library down due to my ignorance.  ;-)
17:43 barton thanks JoeLib. That was going to be my guess as well.
17:43 right there with you talljoy.
17:44 JoeLib001 From what I understand, you would be restarting the services, which would take them down for a short period of time. It's just the way things work.
17:44 dawa joined #koha
17:45 JoeLib001 I am dealing with an issue where I can't see any Pending Orders.
17:45 Which is driving me crazy.
17:45 The only thing I have done is switch to 3.16 from 3.14 and I can't find anything that should have broken it. XD
17:47 talljoy pending orders?  i.e. notforloan status is -1 or somesuch?
17:49 JoeLib001 In Acquisitons when I create an invoice, I should receive a list of pending orders, so I can receive them on the invoice. Nothing shows up.
17:51 I found the bit of code that spits out a list of pending orders, created a MySQL Report, and ran that. That actually shows what it should, so I have no idea what's broken. ;-)
17:54 talljoy curious.  acq is not one of my strongest areas.
17:54 but i suspect there was some db change in between 3.14 and 316 and the new acq is looking for something you don't have perhaps?  did you check updatedatabase to see if anything changed at the db level?
17:55 or my favorite....create a dummy order to see what that looks like in the db and see how it's different from your other records. ;-)
17:55 good luck joe!
17:58 JoeLib001 Thanks. :-)
17:59 The odd thing is that it still doesn't work, if I create a new order.
18:05 pianohacker gmcharlt: liblwp-protocol-https-perl | libwww-perl (<6.02), libio-socket-perl
18:05 *io-socket-ssl-perl
18:05 barton I've got a quick question about zebra output logs...
18:06 I'm seeing the following, popping up every few seconds:
18:06 oleonard pianohacker: You kiss your mother with that mouth?
18:06 barton 13:00:42-10/06 zebrasrv(3276) [warn] ir_session (exception)
18:06 gmcharlt pianohacker: two thoughts
18:06 1. bite the bullet and force add the deps when 3.16.1 is packaged (we'd need to check with eythian about that)
18:06 or
18:06 2. build a metapackage called koha-overdrive-support-deps or the like
18:06 that gets removed when 3.18 is relased
18:07 pianohacker gmcharlt: to avoid adding dependencies on a minor version update?
18:07 gmcharlt right
18:07 pianohacker yeah, makes sense
18:07 add the overdrive-deps package to the Suggest: list or something
18:07 gmcharlt yeah
18:08 pianohacker sounds like a good idea, I'll talk to eythian about it
18:09 I also need to check with him that my patch works, since I can't seem to get the debian packages to build
18:43 nengard_ joined #koha
18:52 phred_ joined #koha
18:54 druthb left #koha
19:10 cait joined #koha
19:11 tgoat joined #koha
19:15 * cait waves
19:25 * magnuse waves
19:28 * dbs waves
19:31 magnuse ~~~~~
19:32 * pianohacker tilde's
19:33 cait heh
19:34 pianohacker: learned how to say the time in spanish today :) (well in theory at least)
19:45 SherryS joined #koha
19:45 SherryS left #koha
19:46 pianohacker cait: woo!
19:46 cait: ¿Qué hora es?
19:46 cait hmm
19:47 son las diez menos 13?
19:47 trece...?
19:47 i said 'in theory' heh
19:48 21:47 here
19:58 kmlussier joined #koha
19:59 pianohacker cait, hmm, not sure how this works with 24 hour time
20:00 cait: Son las veintidos menos trece?
20:01 cait hm i think i could have added something about it being at night...
20:01 our examples in the book are not 24 hour time
20:02 pianohacker I'm not sure where that part goes
20:02 cait: Son las diez de la noche menos trece?
20:02 cait: sorry, heading out, bbl
20:02 have a good evening!
20:11 cait pianohacker: sorry i ran away - cya soon :)
20:18 JoeLib001 Anyone know much about Acquisitions? I haven't been able to figure out why the invoices are not listing any pending orders.
20:19 nengard cause an invoice is for a finalized order ... not a pending order
20:19 a pending order is in a basket
20:19 JoeLib001 I am trying to receive orders on my invoice, but none of them show up.
20:19 cait JoeLib001: if you want to receive - you have to make sure that you have closed the basket
20:20 JoeLib001 Oh...
20:21 cait also, you need to add a 'new shipment'  from the vendor - that will create a new invoice
20:21 JoeLib001 I have never done that until now...
20:22 New Shipment?
20:22 cait search for thevendor - there is a button
20:22 wahanui joined #koha
20:23 JoeLib001 Ah, yes, the receive shipment button.
20:23 The step I was overlooking was the closing the basket in Koha.
20:24 They are showing up to be received on my invoice now.
20:24 cait closed = ordered :)
20:25 irma joined #koha
20:33 JoeLib001 Thanks. :-)
20:33 Now, I just need to close 2 years worth of baskets and we'll be golden..... XD
20:38 cait oh
20:38 how did that happen? you never did the receive process?
21:03 JoeLib001 I did the receive process, but it never needed a closed basket to receive it. ;-)
21:04 Somewhere between 3.14.? and 3.16 that was "fixed". XD
21:06 cait oh hm
21:07 we have been tellling libraries to close the baskets for some time now.. .i hope they do
21:07 you could do it with sql i think
21:10 nengard I've been telling librarians they don't have to close the basket
21:10 cause they didn't have to
21:24 cait ifyou don't close it, the whole status system doesn't work
21:24 for example you can't search for 'ordered' orders
21:24 and for claiming i think you needed to close it for some versions now
21:25 nengard you can't search by ordered now ... do you mean 'pending'
21:25 cait you can search ordered
21:25 one sec
21:25 nengard i see 'new', 'pending', partially received, received, cnacelled
21:25 cait ah, maybe they renamed it to pending
21:25 so new = ordrs in non-closed baskets
21:26 pending = closed baskets
21:46 JesseM_away joined #koha
21:47 nengard left #koha
21:48 wizzyrea also ... baskets.
21:50 cait hm?
21:50 JesseM_a_ joined #koha
21:50 wizzyrea I hate this terminology.
21:51 cait true
21:51 i translated it mostly to order ... but it seems they keep coming back
21:52 pianohacker hi cait :)
21:52 cait wb pianohacker :)
21:52 pianohacker was running off to the gym
21:52 cait i was running off finding dinner :)
21:52 pianohacker oh right it's like 11 there now
22:18 eythian hi
22:18 wahanui niihau, eythian
22:19 cait hi eythian :)
22:22 sophie_m joined #koha
22:22 papa joined #koha
22:22 sophie_m left #koha
22:27 eythian https://plus.google.com/u/0/+a[…]posts/8a7oUic3tib <-- Rijksmuseum library
22:30 wizzyrea ...that is awesome
22:33 sophie_m joined #koha
23:09 wizzyrea troutslap is <reply> https://24.media.tumblr.com/2b[…]1r33ieuo1_400.gif
23:09 troutslap?
23:09 wahanui https://24.media.tumblr.com/2b[…]1r33ieuo1_400.gif
23:10 sophie_m left #koha
23:14 JoeLib001 Thanks for the help nengard and cait. :-) I would send you both cookies, but they don't seem to fit in my ethernet cable. XD
23:15 Bye for now. :-)
23:33 dcook Dang, Rijksmuseum library looks awesome

← Previous day | Today | Next day → | Search | Index

koha1