Time  Nick          Message
00:05 * tcohen      overstepped on 9579
00:19 mtompset      dcook: MySQL query to find a record with a 999$c on it?
00:22 tcohen        SELECT biblionumber FROM biblioitems WHERE ExtractValue(biblioitems.marcxml,'//datafield[@tag="999"]/subfield[@code="c"]')<>''
00:24 * wizzyrea    giggles at wahanui's new trick
00:24 tcohen        which one?
00:24 wahanui       somebody said which one was that? The fixed navbar?
00:24 mtompset      shh wahanui
00:24 wahanui       I'M EXCERCISING eythian's ROBOT RIGHT TO FREE DATA TRANSMISSION
00:24 * mtompset    laughs.
00:24 eythian       rats
00:24 mtompset      Mistake, eythian. ;)
00:24 eythian       no wahanui, shh wahanui is <reply>I'M EXCERCISING \MY ROBOT RIGHT TO FREE DATA TRANSMISSION
00:24 wahanui       okay, eythian.
00:25 mtompset      shh wahanui
00:25 wahanui       I'M EXCERCISING MY ROBOT RIGHT TO FREE DATA TRANSMISSION
00:25 mtompset      There we go. ;)
00:27 tcohen        night #koha
00:27 * wizzyrea    hopes pianohacker pops up
00:29 mrx           Hi Guys, I have a couple of queries?
00:30 mrx           Is it possible to search through all isbns using sql? Like isbn listed in 020|z or in case of multiple 020s?
00:30 mrx           Using Catalog -> search catalog I can search any isbn and it will bring up results even with muliple 020 fields and also  apparently search z subfield but while trying to fetch same isbn using sql like 'Select biblionumber from biblioitems where  isbn=9781922244024' it is not returning anything.
00:30 mrx           Do I have to use some different sql query?
00:30 mtompset      dcook: I think I figured out why I couldn't do steps 5-7 in the bug.
00:30 mtompset      The export didn't put out the 999$c.
00:31 dcook         mtompset: That's odd.
00:31 mtompset      How do you export?
00:31 wizzyrea      there might be a report for that in the sql library mrx
00:31 dcook         Using the export bibliographic holdings tool, I believe
00:31 dcook         It's been a little whie
00:31 mtompset      Because I just trigged an error on MARC non-unicode.
00:32 mtompset      Ah... I'm at the biblio and using Save button drop down.
00:32 dcook         Interesting
00:32 wahanui       Interesting is, like, sometimes good and sometimes bad
00:34 wizzyrea      I think they are all in there - you probably need a LIKE instead of an =
00:35 wizzyrea      mrx ^
00:35 rangi         academy: 11566 is the bug to attach your accessibility stuff too
00:35 wizzyrea      because as you have it, it will only come back if you have one ISBN that matches what you've given.
00:36 rangi         emmah, alexh, Roman_ etc
00:37 mrx           wizzyrea: http://wiki.koha-community.org/wiki/SQL_Reports_Library has all reports or there are some other links too?
00:37 wizzyrea      that has all of the user submitted reports, yes
00:38 dcook         Hmm?
00:38 * aleishaa    waves
00:38 wizzyrea      aleishaa?
00:38 wahanui       JUST LET ME WORK!!!!
00:38 wizzyrea      hehehehehe
00:38 dcook         mrx: Searching the 020 using ExtractValue will give you a concatenated string of all the results
00:38 * francesca   waves bacl
00:38 aleisha       hahahahahaha
00:38 dcook         of all the isbns*
00:38 aleisha       wizzyrea?
00:38 wahanui       somebody said wizzyrea was silly
00:39 * wizzyrea    nods
00:39 * francesca   waves *back
00:39 wizzyrea      francesca?
00:39 wahanui       I love the 11th doctor!
00:39 * dcook       hides
00:39 wizzyrea      sorry sorry you're doing work and stuff. We'll stop now
00:40 dcook         Work?
00:40 wahanui       Work is progressing nicely
00:40 * dcook       nods
00:43 mtompset      11th or 12th? The whole war doctor caused a bizarre temporal renumbering, I think. Women should explicitly swoon over David Tennant not over an wibbly wobbly timey wimey mess of a number. :P
00:43 wizzyrea      ok, now
00:43 francesca     well matt smith is the 11th actor to play the doctor so we call him the 11th doctor
00:44 wizzyrea      ^^ what she said
00:44 daniel_       David is the best doctor
00:44 wizzyrea      ^^ what he said
00:44 MrAgent075    Agreed.
00:44 emmah         yes^^
00:44 rangi         if you wanna know what you changed
00:44 rangi         run git status
00:45 dcook         Oh, David Tennant...*beams*
00:45 francesca     but technically matt smiths doctor was in his last body as the 10th doctor used a regenration to heal himself and kept the same face(the meta crises doctor )
00:46 francesca     and the war doctor (john hurt) was counted as a regeneration as well, making matt smith the 11th doctor, but in his final body
00:47 wizzyrea      get the popcorn
00:47 wahanui       I'm a bot, wizzyrea. Not a popcorn transfer technician.
00:47 wizzyrea      hrmph.
00:47 francesca     in the christmas speical the timelords granted matt smith another cycle or regenerations so peter capaldi is the 12th doctor, but the 13th regeneration
00:47 francesca     does this help?
00:48 mtompset      all find and dandy, but David Tennant beats Matt Smith any day.
00:48 mtompset      Oh, and the Doctor doesn't need to be granted another cycle by the TimeLords.
00:49 francesca     well he got one anyway
00:49 mtompset      His psychopathic wife, River Song, likely gave "all her regenerations" when we revived him in Nazi Germany. :P
00:49 mtompset      (Amy said it to River)
00:49 francesca     true but we don't actually know that for sure
00:50 wizzyrea      popcorn
00:50 wizzyrea      popcorn?
00:50 wahanui       well, popcorn is a vital part of any work day.
00:50 wizzyrea      true.
00:50 francesca     lol
00:50 wizzyrea      http://persephonemagazine.com/wp-content/uploads/2013/01/jon-stewart-popcorn11.gif
00:50 wizzyrea      is what I was getting at.
00:50 francesca     nice
00:50 mtompset      wizzyrea++ # nice link!
00:51 MrAgent075    If that were true, I'd like to see Catalyst 'shouting' their employees (& part-time volunteers) popcorn.
00:54 mtompset      What ticks me off is Netflix only has until Season 7 episode 6 with Matt Smith.
00:54 wizzyrea      we get fancy coffee and fruit, much more than that is rather stretching it don't you think?
00:54 pastebot      "francesca" at 127.0.0.1 pasted "hover link css" (10 lines) at http://paste.koha-community.org/81
00:54 francesca     you may want to take out the > but see if it works with them first
00:55 francesca     mtompset if you're looking for a good site to watch doctor who online go to doctorwhomedia.uk
00:55 * dcook       gets...
00:55 dcook         A place to put his water bottle?
00:55 MrAgent075    @wizzyrea: "You can't always get what you want, but if you try sometimes, you get what you need...."
00:55 huginn        MrAgent075: I've exhausted my database of quotes
00:56 wizzyrea      ah MrAgent075 you can leave off the @ :)
00:56 wizzyrea      @ makes huginn feel crabby.
00:56 eythian       yeah, this ain't twitter :)
00:56 MrAgent075    Or Facebook...
00:56 wahanui       facebook is *not* a universal authenticator!
00:56 francesca     hahahaha
00:57 francesca     true though
00:57 MrAgent075    Man, I'm feeling love from the bots today... :D
00:57 eythian       @quote random
00:57 huginn        eythian: Quote #139: "library_systems_guy: I guess I could put (git-bz) in /usr/games because Koha + git = fun times" (added by wizzyrea at 05:55 PM, May 31, 2011)
00:59 dcook         Man...I've had two issues recently where backing up the database and restoring it to dev has fixed issues :S
00:59 mtompset      "Doctor Who Media does not fully support Mozilla Firefox." -- oh foobar to them.
00:59 dcook         Inexplicably fixed issues..
01:00 francesca     "francesca" at 127.0.0.1 pasted "hover link css" (10 lines) at http://paste.koha-community.org/81  you may want to take out the > but see if it works with them first
01:00 francesca     what!! thats sad
01:01 mtompset      No such message for IE.
01:01 mtompset      Super foobar to them.
01:01 wizzyrea      ah yea netflix runs a year behind. If one lived in a place that had netflix.
01:02 francesca     we don't have netflix in nz
01:02 francesca     do we?
01:02 MrAgent075    We have video streaming services, but I'm not sure if Netflix is operating here...
01:03 wizzyrea      you do not technically have netflix here, no.
01:04 yhager        is there a way to send mass email to all library patrons through Koha?
01:04 wizzyrea      yhager, no.
01:04 eythian       report and mail-merge is the best way
01:04 wizzyrea      don't do that, unless every single person in your library has opted in.
01:05 dcook         My public library mass emails us :o
01:05 dcook         Only about workshops though, and they're always during work :/
01:05 dcook         (They usually look boring anyway)
01:05 wizzyrea      that is so wrong, unless you signed something that said it was ok when you registered.
01:05 * wizzyrea    considers that abuse of borrower submitted data.
01:05 dcook         Hmm
01:06 * dcook       tries to remember if he has a copy of that document somewhere
01:06 yhager        eythian: mail-merge?
01:07 eythian       https://www.google.com/search?btnG=1&pws=0&q=mail+merge <-- yhager
01:07 mrx           Another query, if two different users try to update same record at the same time, is it possible to lock the rescord so that other can not edit or some way of managing muliple edits so no change is lost or overwritten?
01:07 yhager        eythian: okay, that I can do myself. thought you meant something specific :)
01:07 eythian       wizzyrea: it totally depends on your situation, a corporate library could do it happily, as could a special-interest one in general.
01:07 wizzyrea      big no no for a public
01:08 wizzyrea      a corporate could, because they are presumably employees.
01:08 dcook         mrx: As far as I know, there are no locks.
01:09 yhager        we are a very small community library, and we have an upcoming event. We'll do it manually this time, but I'll want to set up some system that will allow people to opt-out.
01:09 dcook         There should be though
01:09 wizzyrea      any library where a borrower self presents and gives data should be opt-in to any emails that are outside standard ILS operations (overdues, holds, fines)
01:09 * wizzyrea    has very strong opinions about it
01:09 * dcook       has noticed :p
01:10 rangi         so if you look at this
01:10 rangi         http://opac.library.org.nz/
01:10 rangi         or
01:10 wizzyrea      (but I'm not, as it might seem, trying to be actively hostile :))
01:10 dcook         But when you sign up to the library, you're not signing up to the ILS
01:10 dcook         You're signing up to the library
01:10 rangi         http://ils.stdc.govt.nz/
01:10 rangi         or
01:10 dcook         That said, I think you have a point about specifying it in your terms of library membership though..
01:10 wizzyrea      the library still needs to declare their intentions with your data
01:10 rangi         http://library.waitaki.govt.nz/
01:10 dcook         wizzyrea: Agreed
01:10 * dcook       really wonders where his membership doc is now...
01:11 mtompset      francesca: The site was http://doctorwhomedia.co.uk/
01:11 dcook         I signed up before I got my personal filing system up and running..
01:11 mrx           dcook: humm ok
01:11 dcook         mrx: I've never known it to be an issue, but it's theoretically possible
01:11 dcook         For there to be mangling that is
01:12 wizzyrea      even in big systems, it's pretty rare for two librarians to be working on the exact same record at the exact same time. The workflow just generally doesn't work that way
01:12 wizzyrea      if you have an example of a workflow where this would be an issue I'm sure we'd be happy to hear it
01:13 jcamins       wizzyrea: dueling catalogers!
01:13 wizzyrea      get your banjo!
01:14 mtompset      dcook: YAY! I got it tested for steps 5-7.
01:16 * wizzyrea    suspects that "installing pazpar2"will become relevant when this external searches patch gets in
01:16 dcook         wizzyrea: Yarp. That's partially why I want to test the patch..
01:17 wizzyrea      that's what I'm trying to do
01:17 dcook         \o/
01:18 dcook         Hence wanting pianohacker to come along, yes?
01:18 wizzyrea      heh yea
01:20 rangi         http://catalogue.bu.univ-rennes2.fr/
01:24 MrAgent075    @quote random
01:24 huginn        MrAgent075: Quote #210: "< oleonard> You could carpet a floor in FIXME's from C4/Search" (added by jcamins at 12:35 PM, July 17, 2012)
01:26 mrx           I'm not sure will the scenario fit in real library system or not but at the moment we have different users responsible for handling title descriptions and title subject headings and came across simultaneous record updatation problems
01:27 jcamins       I have three pizzas worth of dough left, but no idea what to put on them.
01:28 jcamins       I already have two pizzas worth of caramelized onion-goat cheese.
01:28 jcamins       Advice welcomed.
01:29 MrAgent075    I wonder what the conversion equation for pizza worth to kg is...
01:29 MrAgent075    Because I can't precisely imagine a pizza worth of anything.
01:30 jcamins       MrAgent075: I mean, I already made two full pizzas with caramelized onion and goat cheese. ;)
01:30 MrAgent075    jcamins: I see... :)
01:30 francesca     pizza!
01:30 gmcharlt      Catalyst_Academy++ # moar prettier dashboard
01:31 MrAgent075    Umm... Hmm... Depends on what's available.
01:31 wizzyrea      francesca++
01:31 francesca     :)
01:33 rangi         francesca: https://www.ohloh.net/p/koha_dashboard/contributors/summary
01:33 rangi         everyone else
01:34 rangi         https://www.ohloh.net/p/koha/contributors?highlight_key=first_checkin&time_span=30+days
01:34 MrAgent075    I haz an idea for pizza jcamins.
01:34 MrAgent075    jcamins: Just alot of Cheese...
01:34 rangi         https://www.ohloh.net/p/koha
01:35 jcamins       MrAgent075: I don't really have much in the way of cheese.
01:35 jcamins       I decided to do a cinnamon sugar flatbread.
01:36 rangi         if you claim your commits
01:36 rangi         then you get
01:36 rangi         https://www.ohloh.net/accounts/ranginui
01:37 francesca     so do we claim them?
01:37 mtompset      francesca++ # dr. who fan and 2 commits in 23 hours
01:38 francesca     :)
01:38 MrAgent075    jcamins: Good way to go - wish I could try them.
01:39 rangi         http://meta.ohloh.net/2013/07/announcing-ohloh-badges/
01:40 Roman_        daniel_?
01:40 mrx           thanks wizzyrea: I'm not sure will the scenario fit in real library system or not but at the moment we have different users responsible for handling title descriptions and title subject headings and came across simultaneous record updatation problems
01:44 francesca     @quote random
01:44 huginn        francesca: Quote #13: "<atz> ricardo: ask and ye shall receive.... eventually, ye shall stop asking." (added by gmcharlt at 08:31 PM, July 09, 2009)
01:45 MrAgent075    I wonder how we can create quotes on here...
01:48 MrAgent075    wizzyrea: PROGRESS // The bar in add-item.pl is working & is fixed. Just thinking... Might place it down at the bottom of the page. All-in-all, it is functioning.
01:48 wizzyrea      ohhh nice
01:48 wizzyrea      !
01:48 wizzyrea      MrAgent075++
01:49 wizzyrea      mrx: hm, yeah that'd do it. What kind of library?
01:52 * dcook       shakes his fists and shouts "Double-encoding!!!"
01:56 mtompset      MrAgent075: could it be were someone doesn't have to scroll? -- Just noting my dislike for scrolling. :)
01:57 MrAgent075    mtompset: like... let's say... if the bar was to appear at the bottom of the screen already? Or that it'd be at the top? I think either option would be sensibly possible.
01:57 wizzyrea      MrAgent075: I think it should closely mirror the cataloguing interface
01:57 wizzyrea      i.e. at the top, and floating.
01:58 MrAgent075    Brill, will keep it at the top... But what about the table? ... :/
01:58 wizzyrea      :) a problem to solve
01:59 mtompset      well, sometimes pages put things at the bottom, and the content in between varies.
01:59 wizzyrea      mtompset: the thing he is working on is making the add item save button float like the buttons do in cataloguing.
01:59 wizzyrea      on the edit bib page.
01:59 mtompset      Okay. :)
01:59 rangi         Roman_: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11089   <-- see if you can fix this
02:00 huginn        04Bug 11089: enhancement, P5 - low, ---, oleonard, NEW , Item edit screen should use floating toolbar like cataloging interface
02:00 MrAgent075    'additem.pl' had the buttons on the bottom, originally.
02:00 mtompset      Anyways.
02:00 mtompset      So, let's say we have a bug, and there's a problem, and I fix it while testing it for sign off. Do I still sign off?
02:00 wizzyrea      ooh now it's a race ^.^
02:01 gmcharlt      mtompset: yes, assuming it's a correction, and not, say, a follow-up that completely revamps the patch
02:01 rangi         http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11363 <-- fair game too for someone
02:01 huginn        04Bug 11363: minor, P5 - low, ---, koha-bugs, NEW , Label printer profile units are not translatable
02:02 mtompset      for example, gmcharlt, there was a string quoting problem. I fixed the string quoting problem, so the patch would do what it was supposed to do.
02:02 gmcharlt      mtompset: yep, that's small enough
02:02 gmcharlt      a larger follow-up you might attach to the bug, and ask the original patch submitter to sign off on your follow-up
02:02 mtompset      okay... just checking. :)
02:04 mrx           wizzyrea: we have an online bookstore (wheelers.co.nz) and at the moment offering custom developed ebook lending system to libraries but we are evaluating koha for marc record management as a separate solution, if possible
02:04 wizzyrea      Ah cool!
02:06 mtompset      dcook: finally. the bug is signed off. :)
02:07 * wizzyrea    swears a bit at pazpar2
02:07 wizzyrea      on an outside chance that anyone knows, what is the config file you start it with for Koha?
02:08 gmcharlt      etc/pazpar2/pazpar2.xml
02:09 wizzyrea      yay thank you gmcharlt
02:09 gmcharlt      also see misc/bin/koha-pazpar2-ctl.sh
02:09 wizzyrea      gmcharlt++
02:09 wizzyrea      <3 thank you
02:10 wizzyrea      that, I feel like that is not written down anywhere.
02:11 * wizzyrea    says, realising that the manual was not consulted
02:11 * wizzyrea    facepalms
02:12 wizzyrea      oh, doesn't matter anyway because it's not there.
02:12 * gmcharlt    makes no guarantees that it got documented, given the age and relative disused of the feature
02:13 wizzyrea      well it's about to become relevant
02:13 gmcharlt      http://librarypolice.com/wiki.koha.org/en:development:frbrlikegroupingandmetasearch.html
02:20 wizzyrea      ohh thanks
02:29 dcook         When comparing two systems that seem to have the same code and the same database...it helps to make sure they have the same indexing configuration
02:29 * dcook       facepalm
02:29 wahanui       facepalm is a tiny member of the Arecaceae family whose preference for warm, humid environments makes it a perfect choice for cultivation in the human nasal cavity.
02:35 mtompset      Arecaceae ... *laugh*
02:36 eythian       It's the traditional family for palms
02:41 mtompset      Yes, which is why it is funny.
02:43 mtompset      Out of curiosity, are hypens in an ISBN13 in any particular positions?
02:45 rangi         ok. we are gonna finish at 4.30 today
02:46 pastebot      "francesca" at 127.0.0.1 pasted "font change for header" (7 lines) at http://paste.koha-community.org/82
02:49 francesca     @quote random
02:49 huginn        francesca: Quote #213: "jwagner: There are few problems that can't be solved with patience, ingenuity, and a large kick in the pants (assuming servers wear pants, that is)." (added by wizzyrea at 06:18 PM, August 07, 2012)
02:52 MrAgent075    Now getting onboard the Dashboard Train.
02:57 pastebot      "francesca" at 127.0.0.1 pasted "more code for header" (5 lines) at http://paste.koha-community.org/83
02:58 rangi         MrAgent075: http://wiki.koha-community.org/wiki/File:Koha-logo-black-and-white.jpg
02:58 rangi         http://wiki.koha-community.org/w/images/Koha3-staff-client-logo.svg
03:02 eythian       ah good, there is an svg logo
03:03 wizzyrea      hm those are somewhere in the git repo as well I think...
03:07 francesca     @quote random
03:07 huginn        francesca: Quote #39: "chris <chris> nope, ive made it my aim in life not to learn js or html" (added by ricardo at 06:00 PM, October 07, 2009)
03:08 pastebot      "francesca" at 127.0.0.1 pasted "changing font for h3" (5 lines) at http://paste.koha-community.org/84
03:13 francesca     chris you also need to do the same thing to .span8 h3 {
03:20 aleisha       https://docs.google.com/file/d/0BxgQvS2dQklRc0c2YmpzbHhTeVJLTC1LOU14ZVJReUN6T29n/edit
03:20 francesca     thanks
03:22 wizzyrea      MrAgent075 is funny
03:23 MrAgent075    #memories
03:24 francesca     you kept going on in the presentation about how the nav bar was awful in design terms, yet your presentation is pretty much entirely purple and orange...
03:30 wizzyrea      ohsnap
03:32 francesca     goodbyyye! see you/talk to you tomorrow :)
03:47 pastebot      "MrAgent075" at 127.0.0.1 pasted "logo for Koha Dashboard" (23 lines) at http://paste.koha-community.org/85
04:00 wizzyrea      that url is going to be problematic
04:00 wizzyrea      for the image
04:01 MrAgent075    Which is why it should be uploaded to the server that is operating the Dashboard site.
04:01 MrAgent075    I can't do that...
04:11 mtompset      @later tell cait Remember that loss of currency problem on basket groups? Check out bug 11471.
04:11 huginn        mtompset: The operation succeeded.
04:13 mtompset      Anyone want a simple signoff? :)
04:14 mtompset      It helps stop floody warnings when you are setting up a library's patron categories. :)
04:16 MrAgent075    wizzyrea: better URL (not temporary :] // http://files.pilcrowsquared.com/koha_128dpi.png)
04:16 MrAgent075    wizzyrea: is that alright?
04:30 mtompset      Well, have a great day (24 hour period), #koha wizzyrea MrAgent075 dac Oak and others. :)
04:45 eythian       rangi: there is definitely a memory leak under plack. Where do you change things like how many requests it does before a restart I want to experiment with it.
04:49 eythian       oh, it's in the init script
04:54 dcook         10 minutes and I'm at the Koha web installer
04:54 dcook         Not bad
04:55 dcook         I even dawdled at the beginning...
04:57 eythian       hmm, I just hit memory limits with plack on a 3GB machine. This is going to need some tuning.
04:57 dcook         13 minutes!
04:57 dcook         pas mal
05:22 eythian       starman seems to reap memory more when it's not busy. That's unfortunate.
05:43 dcook         When using Debian packages, are we defaulting to DOM indexing with 3.14?
05:43 eythian       no, not yet
05:43 dcook         Huh...
05:43 dcook         Ok, thanks, eythian :)
05:43 eythian       I don't think so anyway
05:44 dcook         I suppose I could just check the files..
05:44 eythian       I'd look, but I'm in the middle of seeing how far I can push a production Koha server without it falling over, and really don't want it to fall over :)
05:44 * gmcharlt    has just looked at it -- the default is indeed DOM nowadays
05:44 dcook         No worries, eythian
05:45 dcook         gmcharlt: Thanks. That makes sense.
05:45 eythian       gmcharlt: for packages?
05:45 dcook         Is there any way to specify grs1 instead?
05:45 gmcharlt      eythian: yep, unless you're munging koha-create when you package
05:45 gmcharlt      see commit aba3db26 (when you're not tortuing a poor, defenseless server, that is)
05:46 gmcharlt      ;)
05:46 dcook         Just checked as well. Defo DOM.
05:46 gmcharlt      dcook: and yes -- koha-create --biblio-dix grs1 ...
05:46 eythian       ah, I remember that now :)
05:46 gmcharlt      er
05:46 gmcharlt      --biblio-idx
05:46 dcook         Ah, yes
05:46 dcook         Excellent
05:46 * paxed       is getting high blood pressure before 8am...
05:46 dcook         gmcharlt++
05:46 dcook         eythian++
05:46 dcook         paxed: Indexing related?
05:46 paxed         dcook: translation related.
05:47 eythian       it was just gmcharlt, I lied to you :)
05:47 dcook         eythian: Your answer might not have been correct, but the spirit was there :)
05:47 dcook         Unless you were meaning to mislead me...
05:47 dcook         In which case, points for seeming genuine!
05:48 dcook         Now what was I doing..
05:48 eythian       OK, 2000 requests to opac-detail, 10 concurrent, mean response time 350ms and memory use peaked at about 60%. Now I'm getting somewhere.
05:48 paxed         just out of curiosity, is owen leonard american?
05:49 gmcharlt      yep
05:49 paxed         do you happen to know if he speaks any other language than english?
05:50 dcook         Ooo the man page for koha-create has been updated. That's handy..
05:50 dcook         paxed: I think he speaks some Czech
05:50 eythian       dcook: yeah, magnus_away is good for making sure that happens.
05:50 eythian       it might also have a good --help, some of the scripts do
05:51 dcook         Hmm, not sure that I necessarily understand --use-database..
05:51 dcook         Actually, I think I do, and it's not what I'm thinking
05:52 eythian       It lets you use a pre-existing mysql database instead of creating one
05:52 dcook         Well, what I want to do is clone a DB
05:52 dcook         Or can you have two instances running off the same DB with different config?
05:52 eythian       my method for that is to do a dump, and then after a koha-create load the dump in.
05:52 eythian       I really wouldn't do that
05:53 dcook         Yeah, it sounds mental
05:53 eythian       you _can_ but it's probably not a good idea
05:53 eythian       there's also not much point
05:54 dcook         How do you load the dump into a koha-create?
05:54 dcook         Ideally, that's what I was thinking of doing, but I don't see a place to specify the name of the new instance
05:54 eythian       it depends, but generally you can do cat dump.sql | sudo koha-mysql newinstance
05:55 dcook         Interesting...I'll give that a shot
05:55 eythian       there are situations where that may abort (primarily if the dump has 'use koha_anothername'), in which case you can do sudo koha-mysql instance and then use \. to load the dump
05:56 eythian       the first way uses one transaction so the wrong name causes the whole load to abort, the second doesn't.
05:56 dcook         I was wondering about 'use koha_anothername'
05:57 eythian       in the second case, the use fails, but everything else works.
05:57 eythian       so that's OK
05:57 dcook         Oooh :D
05:58 * eythian     has zebra using 20% CPU and koha using the remaining 180%...
06:01 dcook         All right, let's give this a go..
06:01 eythian       978ms per search, not too bad, but you don't want to be doing 10 at once. A mean of nearly 10 seconds per request.
06:02 eythian       I don't think I can squeeze more performance out of this server, but I know it's not going to go down in a flaming heap.
06:02 eythian       could do with 2 more cores really.
06:02 dcook         Hmm, that's not good..
06:03 * dcook       mutters to himself
06:03 dcook         mysqldump: Got error: 1045: Access denied for user 'koha_devone'@'localhost' (using password: YES) when using LOCK TABLES
06:03 eythian       hmm
06:03 eythian       oh
06:03 eythian       that's not koha
06:03 eythian       (as in, not an error from koha)
06:03 dcook         Yeah, I know. Mysql error.
06:04 dcook         But not sure why..
06:04 wahanui       somebody said not sure why was still pulling it
06:04 eythian       are you using the right password?
06:04 dcook         I dumped the same database not that long ago
06:04 dcook         I'm just using koha-dump
06:04 eythian       oh
06:04 eythian       that is an error from koha then
06:04 eythian       sorta
06:04 eythian       that's not expected
06:04 eythian       unless you've manually created that db
06:04 dcook         Hmm, perhaps I broke it the first time..
06:05 dcook         Yep
06:05 eythian       then you probably didn't grant access to it
06:05 dcook         Interesting
06:05 wahanui       hmmm... Interesting is sometimes good and sometimes bad
06:05 dcook         Mmm, right
06:05 dcook         Because I loaded it up as the root user as the koha user couldn't do it
06:06 eythian       yeah, you can't do that
06:06 eythian       well, you shouldn't do that
06:06 eythian       because then this happens :)
06:06 dcook         hehe
06:06 dcook         Indeed.
06:06 eythian       a grant _might_ take care of it
06:06 dcook         I'll just start over..sort of
06:07 dcook         Interesting...that first method didn't work..
06:07 dcook         ERROR 1227 (42000) at line 140990: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
06:08 eythian       you'll have to grant as the root user
06:08 eythian       hi cait
06:08 dcook         When doing " cat dump.sql | sudo koha-mysql newinstance" ?
06:09 eythian       well in that case, you'll have to grant to the database for the koha user
06:09 eythian       or see what like 140990 is.
06:09 eythian       maybe it's something weird
06:09 * cait        waves
06:10 dcook         heya cait :)
06:10 cait          hi dcook and eythian
06:14 dcook         Hmmm, I think koha_devone and koha_devtwo have full privileges? :S
06:14 eythian       what does that mean?
06:14 dcook         " GRANT ALL PRIVILEGES ON `koha_devtwo`.* TO 'koha_devtwo'@'%'"
06:14 dcook         So I'm wondering why there were those issues with dumping/restoring..
06:15 eythian       there's some oddness with the way that mysql does privileges sometimes.
06:15 eythian       s/privileges/anything/
06:16 dcook         Seems like it :S
06:16 eythian       in particular, I'm not sure you want @'%'
06:16 eythian       have a look at how koha-create does it.
06:17 dcook         CREATE DATABASE \`$mysqldb\`;
06:17 dcook         CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd';
06:17 dcook         CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd';
06:17 dcook         GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`;
06:17 dcook         FLUSH PRIVILEGES;
06:17 eythian       yeah that
06:17 wahanui       yeah that is golded jcamins
06:18 dcook         Huh...
06:18 dcook         Yeah, when i look at the user table, it looks like the koha_ users don't have that many privileges..
06:19 eythian       it's not just a user, it's also correlated with where you're connecting from
06:19 dcook         Right. The error said localhost annd there are entries in the user table for localhost as the host as well
06:20 dcook         But I can dump devtwo but not devone (possibly because of that earlier manual mangling job I did)
06:21 rangi         eythian: i remapped capslock to left shift
06:21 rangi         (*()#$&#$#*
06:21 rangi         and i can do that again
06:22 eythian       rangi: that is totally bizarre
06:22 rangi         still cant do a exclamation mark
06:22 rangi         but everythign else works
06:22 rangi         yeah it really is
06:22 eythian       no not-equals for j00!
06:22 rangi         xmodmap -e "keycode 66 = Shift_L"
06:22 eythian       map another key you never use to !. Like z, no one needs z.
06:23 dcook         Hmm that second method got further..
06:23 rangi         :)
06:24 dcook         wtf...
06:24 rangi         good idea there is the menu key over by the right control
06:24 rangi         i never use that
06:24 dcook         My first database appears to have disappeared..
06:24 dcook         That might be why it couldn't dump..
06:24 rangi         can someone fire up xev
06:25 eythian       that's my có₥pøśê key
06:25 rangi         and tell me what the name is when they push shift+1
06:25 dcook         Oh wait, I'm an idiot..
06:25 eythian       KeyPress event, serial 34, synthetic NO, window 0x3600001,
06:25 eythian       root 0xb6, subw 0x0, time 1023361165, (502,530), root:(2423,602),
06:25 eythian       state 0x11, keycode 10 (keysym 0x21, exclam), same_screen YES,
06:25 eythian       XLookupString gives 1 bytes: (21) "!"
06:25 eythian       XmbLookupString gives 1 bytes: (21) "!"
06:25 eythian       XFilterEvent returns: False
06:26 rangi         cool exclam
06:26 rangi         thanks
06:26 rangi         !!!!
06:26 rangi         yay
06:26 rangi         !!
06:26 rangi         i can write #! again
06:27 rangi         bizzare
06:27 rangi         but workable
06:27 eythian       it sure sounds like something liquid or otherwise conductive got in there.
06:28 * dcook       has no idea what happened in the end, but thinks he has a workable solution?
06:28 dcook         eythian++
06:28 rangi         yeah the weird thing is in xev if i hit left shift
06:28 rangi         it all works fine
06:28 eythian       oh, curiouser and curiouser.
06:28 rangi         state 0x1, keycode 50 (keysym 0xffe1, Shift_L), same_screen YES,
06:28 rangi         but if i push shift and 1
06:28 rangi         xev sees nothing
06:29 eythian       ah
06:29 eythian       yeah, something is munted in hardware.
06:30 rangi         yeah gotta be
06:32 dcook         After all that, my conclusion is...grs1 blows.
06:33 dcook         And that ampersands get encoded and recoded way too many times in way too many spots..
06:34 dcook         Oh, but I was going to look at the TT filter...
06:34 dcook         But it's 5:34...
06:35 eythian       rangi: I've found a starman configuration that gets slow under high load, but never seems to run out of RAM. It's all CPU bound now, which is nicer.
06:36 rangi         excellent
06:37 dcook         Maybe one more experiment before the gym..
06:42 dcook         Bleargh. Whatever.
06:46 dcook         night all
06:46 wahanui       goodnight dcook. You'll be back.
06:46 dcook         thanks again, eythian
07:06 cait          time for the dentist... ew.
07:06 cait          bbl
07:47 * magnuse     waves
07:49 magnuse       bonjour reiveune
07:49 magnuse       @wunder boo
07:49 huginn        magnuse: The current temperature in Bodo, Norway is -7.0°C (8:20 AM CET on January 16, 2014). Conditions: Clear. Humidity: 58%. Dew Point: -14.0°C. Windchill: -18.0°C. Pressure: 30.18 in 1022 hPa (Steady).
07:50 magnuse       windchill--
07:50 reiveune      hello
07:50 wahanui       kai ora, reiveune
07:52 magnuse       kia ora paul_p
07:54 paul_p        hi magnuse. Just read a mail from Arve (oslo p.l.) . Good new ;-)
07:54 marcelr       hi #koha magnuse reiveune paul_p
07:56 alex_a        bonjour
07:56 marcelr       hi alex_a
07:59 magnuse       paul_p: yup :-)
08:18 alexia        hello! we have a problem with our koha installation. We had a server crash a couple of days ago, and after we managed to bring it back online, the system does not return any results when searcing bibliographic records or authorities. I have re-indexed the system but still nothing appears. We also get some lock errors on the
08:18 alexia        file /var/log/koha/koha-zebra-daemon-output.log
08:19 alexia        10:07:35-16/01 zebrasrv(9) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/authorities/shadow..LCK [Permission denied] 10:07:45-16/01 zebrasrv(10) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/norm..LCK [Permission denied] 10:07:45-16/01 zebrasrv(10) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/shadow..LCK [Permission denied]
08:19 alexia        any help?
08:19 wahanui       i guess any help is appreciated ;)
08:20 HB            Hey koha i try to run  build_oai_sets.pl i get Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl                              /5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/pe                              rl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at ./build_oai_sets.pl                               line 45.
08:20 HB            annyone has tips ?
08:27 cait          ah no Joubu yet
08:27 cait          hi gaetan_B :)
08:27 gaetan_B      hello :)
08:28 ashimema      Mornin' all
08:28 cait          hi ashimema :)
08:31 HB            hey
08:57 paxed         cait: in commit bbe6497 there's +VALUES( 'Laoo', 'script', 'en', 'Laotisch'); in file installer/data/mysql/de-DE/mandatory/subtag_registry.sql -- that should be 'de', not 'en', right?
08:57 cait          paxed: i think you might be right, but can't look at the file right now :(
08:57 cait          if you file a bug somewhere i will take a look later
08:57 cait          probably me who messed it up in the first place
08:59 cait          ok, meeting time
08:59 wahanui       i think meeting time is always going to favour one section of the globe
08:59 cait          bbl
09:01 magnuse       have fun cait!
09:04 magnuse       paul_p: has the hackfest been announced officially yet?
09:05 paul_p        magnuse nope, it's on my todo list. But date are marc 10-14th
09:08 magnuse       paul_p: yup, but some people might need an "official" announcement to refer to, to get the green light to go :-)
09:09 paul_p        magnuse yes, I know. could you ask God to add 12 hours to each day please ;-)
09:15 magnuse       paul_p: will do! ;-)
09:17 Joubu         hello
09:19 magnuse       bonjour Joubu
09:22 marcelr       hi Joubu
09:26 HB            is there a command to get your intance
09:30 magnuse       HB: if you installed with the packages you can do "sudo koha-list" to see all your instances
09:34 HB            thx got it running but just to be sure (thx fr the mail) i would not have found it myself ++++
09:40 magnuse       HB: do "man koha-common" for a list of available koha-* commands :-)
09:42 HB            aha more secrets reveiled :)
09:54 paxed         cait: UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurencyFormat';  -- should be Cur_r_ency?
11:12 magnuse       woooo that was fun
12:04 tcohen        morning #koha!
12:11 cait          magnus: make it 18 hours please
12:14 marcelr       hi tcohen
12:14 tcohen        hi marcelr, thanks for signing
12:14 marcelr       np
12:21 tcohen        how is the qa team doing?
12:21 tcohen        too many stuff to qa?
12:30 magnuse       w00000t!!! http://digital.deichman.no/blog/2014/01/16/oslo-public-library-chooses-the-free-and-open-koha-integrated-library-system/
12:34 magnuse       confetti!
12:34 wahanui       o/ '`'`'`'`'`'`'`'`
12:34 tcohen        magnuse++ petter++\o/
12:34 magnuse       woohoo!
12:43 petter        hi koha!
12:45 kivilahtio_   hi petter!
12:45 petter        hi olli!
12:46 cait          petter
12:46 cait          petter++
12:46 cait          can't type
12:46 cait          good news!
12:46 wahanui       it has been said that good news is it looks like it's running properly.
12:47 kivilahtio_   patter++ can't type :)
12:47 petter        So my library now finally and officially has approved of us changing to koha!
12:48 kivilahtio_   I think your library takes the term "shadow IT" to the MAX
12:48 petter        haha
12:48 kivilahtio_   considering you have been working with Koha for how many years?
12:48 petter        well, this is quite fast actually, for an organization like ours
12:49 petter        and the bureaucracy we have
12:49 kivilahtio_   but good you made it
12:49 petter        so now we can start actually WORKING on it; rather than endless meetings, workshop, risk-assesments and so on
12:49 kivilahtio_   c u in the other side then
12:50 tcohen        petter: congratulations!
12:50 petter        :)
12:50 tcohen        petter++
12:51 petter        Secret tip: we'll be hiring a koha-perl-ninja soon.. Anyone feel like coming to Oslo?
12:51 tcohen        honeymoon doesn't count, right?
12:51 kivilahtio_   :)
12:51 tcohen        heh
12:51 petter        hehe
12:51 petter        maybe we can work something out:)
12:51 petter        working holiday?
12:53 tcohen        if by work you mean drink lots of beer?
12:53 kivilahtio_   I would if I could
12:53 kivilahtio_   tcohen: beer in Oslo is expensive
12:53 petter        sure, beer is a big part of the job
12:53 petter        our boos is brewing, so dont worry about cost!
12:53 petter        boss
12:53 tcohen        kivilahtio_: well, a tiny amount then
12:54 tcohen        heh
12:57 kivilahtio_   did I already ask here about Solr?
12:57 kivilahtio_   I did
12:57 kivilahtio_   cait siad it's not production ready
12:57 kivilahtio_   but I would like to know how far is solr from being production ready
12:58 kivilahtio_   because we are facing LOTS of issues with Zebra facets
12:58 kivilahtio_   and searches in general
12:59 petter        I'd rather wait for ElasticSearch
12:59 kivilahtio_   I feel we need to work a lot with Zebra to make it work for us and the code doesn't look too nice
12:59 petter        coming in 3.16?
12:59 kivilahtio_   3.16?
12:59 petter        i think
12:59 kivilahtio_   petter: Any idea when 3.16 is due?
13:00 cait          kivilahtio_: i think probably less work fixing koha's facets than making solr ready for production
13:00 petter        http://lists.koha-community.org/pipermail/koha-devel/2013-December/040113.html
13:00 petter        in may
13:00 cait          but that's only my impression
13:00 kivilahtio_   cait: ok
13:00 cait          kivilahtio_: 6 months after 3.14 ;)
13:01 kivilahtio_   lol
13:01 kivilahtio_   damn it
13:01 kivilahtio_   gotta hit the Zebra book
13:01 kivilahtio_   I was hoping I wouldn't have to learn yet another library technology
13:01 petter        olli, hwen are you going live?
13:01 kivilahtio_   ASAP
13:01 kivilahtio_   :)
13:01 petter        I see
13:01 kivilahtio_   we are going live 1.1.2014
13:01 petter        zebra it is then!
13:01 cait          kivilahtio_: the problem with zebra facetting are well known and there has been a poc at kohacon i think, but i am not sure anyone is actively working on it
13:02 cait          using zebra's facets instead of having koha make facets...
13:02 cait          kivilahtio_: that's already expired
13:02 kivilahtio_   cait: gee? you think so?
13:03 kivilahtio_   well I am going on a holiday this saturday so...
13:03 kivilahtio_   I don't need to worry about that
13:04 petter        You'l be reading zebra manual on the beach, miserable
13:04 tcohen        facets in zebra seem to work great as we saw on kohacon13
13:04 kivilahtio_   petter: I won't :)
13:04 petter        hehe, I hope so!
13:04 kivilahtio_   tcohen: I received some reports that they don't but maybe it is something else on the OPAC's left frame
13:05 tcohen        we don't currently use Zebra's facets
13:05 kivilahtio_   tcohen: hmm, but you do use facets?
13:06 tcohen        we use a poorly documented Zoom::Results feature
13:06 tcohen        ->render()
13:06 jcamins       tcohen: better to describe it as "we compute the facets using custom code," IMO.
13:06 tcohen        we also do that
13:06 kivilahtio_   tcohen: Do you have a separate server for that ? :)
13:06 jcamins       While we do use ->render(), that makes it sound like facets are coming from Zebra.
13:07 jcamins       :)
13:07 tcohen        heh
13:08 tcohen        there is a problem with multibyte chars in facets that is addressed by 9579
13:08 francharb     Good morning #koha
13:08 kivilahtio_   good afternoon francharb!
13:08 francharb     :)
13:09 tcohen        kivilahtio_: when I say "we" i mean the stable source code, not my university's Koha deploy
13:10 kivilahtio_   tcohen: So if I install for git, am I using Zoom::Results?
13:10 kivilahtio_   with default configuration?
13:10 tcohen        that's how we've been doing it for years I guess
13:11 * magnuse     guesses so too
13:11 kivilahtio_   tcohen: thank you! I'll look into it when I get back from my holiday week
13:12 tcohen        Zoom::Record->render()
13:12 jcamins       But that doesn't actually generate facets at all.
13:12 jcamins       All that does is creates a string that can be parsed using string parsing in Perl.
13:13 tcohen        what do u mean?
13:14 jcamins       tcohen:
13:14 jcamins       Whoops.
13:14 jcamins       C4::Search lines 509-539.
13:15 tcohen        yes, i almost have all those lines in my head since kohacon13 heh
13:15 jcamins       We parse the result of the render() call to generate facets, but the render() call is not actually a meaningful part of the facet generation.
13:16 jcamins       We could just as easily use a MARC::Record object in that context, and it would make no difference.
13:16 tcohen        you are saying that what we are building does not have the semantics of what one would call facets
13:16 jcamins       (in terms of functionality, which is what kivilahtio_ is interested in)
13:17 jcamins       No, what we are building has the semantics of facets, but based on the scrollback, kivilahtio_ is planning to read about ->render() so that he can modify the behavior of facets.
13:17 kivilahtio_   jcamins: I think the entities I represent are interested in those things :)
13:17 tcohen        jcamins: agreed, that's what 11096 does
13:18 tcohen        i was focusing on the effects bug 9579 has (read "the problems we have with facets")
13:18 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9579 major, P1 - high, ---, tomascohen, Needs Signoff , Facets truncation broken for multi-byte characters
13:19 jcamins       tcohen: and with luck, by the time kivilahtio_ gets back from vacation, there won't be any calls to ->render() anyway.
13:19 kivilahtio_   jcamins: looking forward to it :)
13:20 tcohen        i hope so jcamins
13:20 kivilahtio_   jcamins: what I find extrememly cool is your capability to read my mind
13:20 kivilahtio_   jcamins: I wonder how you do it.
13:20 jcamins       kivilahtio_: a lot of painful experience talking about search in Koha.
13:21 kivilahtio_   but I gather from this conversation that I should just wait, regarding facet generation
13:23 jcamins       kivilahtio_: some of the bugs have patches, but if you want to substantially improve facets (for example, making the availability facet work), that could probably be started now, just on top of work that's already been done.
13:23 tcohen        what problems do u actually have kivilahtio_ ?
13:23 * oleonard    waits for jcamins to read his mind
13:23 kivilahtio_   tcohen: lemme, see, I have some screenshots around
13:24 kivilahtio_   oleonard: jcamins already read my mind regarding the availability facet
13:24 jcamins       oleonard: I'm getting... "coffee... cookies... fudge... cookies... cookies? cookies? cookies!"
13:24 * tcohen      remembers how awesome jcamins' cookies are
13:24 oleonard      jcamins: You're reading your own mind again. Oh wait, except for the coffee part.
13:24 kivilahtio_   it must be boring to read one's own mind
13:25 jcamins       oleonard: I may have been a bit in advance.
13:28 kivilahtio_   Locations-facet apparently has something worng?
13:28 kivilahtio_   I can't believe these bug reports
13:28 kivilahtio_   Under locations-facet, we have Serials and show more
13:29 kivilahtio_   When one clicks "show more",  "show more" vanishes, and nothing happens!!!
13:29 kivilahtio_   so there is only "Serials" under Locations-facet
13:30 kivilahtio_   :D
13:30 kivilahtio_   the facets work well
13:58 oleonard      Bug 11567
13:58 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11567 major, P5 - low, ---, koha-bugs, NEW , Shortcut is searching with every keypress
13:59 oleonard      Anyone else have that problem?
14:00 tcohen        i have seen it in master a while ago, but after a couple of testing for other stuff (I assumed it was a problem with the patches I was testing) the problem dissappeared
14:07 kivilahtio_   I had similar issues today, but it vanished after reloading/refreshing
14:11 magnuse       yup, i had that, updating my templates/translation fixed it
14:13 * magnuse     commented on the bug
14:14 * tcohen      thinks maybe it is time to check bug 10942
14:14 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10942 enhancement, P5 - low, ---, koha-bugs, Needs Signoff , Provide a way for package upgrades to update template translations
14:17 magnuse       that would be neat :-)
14:22 tcohen        magnuse: it is just a couple of signoffs away :-P
14:42 cait          tcohen: how is work going on the new time machine module?
14:42 tcohen        :-P
14:45 oleonard      cait: Ask him yesterday.
14:47 cait          oleonard: oh, i will put a reminder in my calendar
15:13 paxed         oleonard: re my comment (#5) on bug 11487: let's say the language must add something to the number to make it grammatical. (think: "1st" or "2nd" in english). would that be enough to convince you concatenating strings is very bad for translation?
15:13 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11487 normal, P5 - low, ---, koha-bugs, Failed QA , Untranslatable tooltip "Dates of birth should be entered in the format ..."
15:14 oleonard      paxed: The goal of the reformatted comment was to remove the requirement that the number must be modified
15:16 paxed         ...sorry?
15:17 oleonard      I don't see how the example you provide applies to the bugs we're talking about.
15:17 paxed         "Päivämäärät pitää syöttä %s -muodossa."
15:18 paxed         _("Dates of birth should be entered in this format:")+ " '"+[% format %]+"'";
15:20 oleonard      You're saying that [% format %] needs to be modified somehow to be grammatically correct?
15:21 paxed         no. i'm saying the translator should be able to decide where in that sentence it goes.
15:21 cait          paxed, oleonard: i commented on bug 11488
15:21 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11488 normal, P5 - low, ---, emmaheath.student, Needs Signoff , Untranslatable warning "Are you sure you want to write off ..."
15:22 oleonard      cait++
15:22 oleonard      Joubu++
15:22 oleonard      ...for suggesting alternative solutions.
15:24 Joubu         It is not perfect because only 1 placeholder is possible. But it fixes this specific string.
15:24 cait          thin the problem here was probably the tt variable in the message
15:24 cait          poor emma :( I told her a non working solution.
15:25 Joubu         And it avoids modifying the translate script...
15:25 paxed         doesn't koha use jQuery? it has placeholder replacement functions, iirc.
15:25 cait          oleonard: i remember something about the paging for datatables using multiple variable replacement, something like __PREV__?
15:29 oleonard      Look at datatables.inc
15:35 huginn        New commit(s) kohagit: Bug 7143: add another name to the about page <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=4e4a33ef5deecc32711092d78d87f2eefe3fbcf5> / Bug 7143: Updating about page and history <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ef7480f362a0286b13e1ba1b99e58c6d2ca7ba72>
15:40 Joubu         tcohen: bug 10987, why did you switch back the status to NSO?
15:40 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10987 enhancement, P5 - low, ---, tomascohen, Needs Signoff , Too many 'see also' and 'usedfor/see from' labels occurences
15:41 tcohen        Joubu: I fixed a couple of minor problems (rebased against latest 10691), but mostly because I added bootstrap to get bonus points
15:42 Joubu         tcohen: ha yes (rebased+bootstrap). I did not see that!
15:44 tcohen        i think it can be safely signed btw
16:03 * Joubu       are sending 2 bonus points to tcohen
16:04 tcohen        heh
16:05 * cait        adds another for being tcohen
16:06 cait          tcohen: hm do you think 10908 should go into 3.12?
16:06 cait          i see that my coworker has added it to our 3.12.7 branch
16:07 cait          together with 10605
16:07 cait          which will be in 3.12.9
16:07 tcohen        i thought i had 10908 on 3.12
16:07 tcohen        gotta test it,
16:23 cait          tcohen++ thx :)
16:35 cait          bye all
16:49 rambutan      looks like magnus is buying donuts this week
16:49 rambutan      :) don't know that he had anything to do with it
16:52 oleonard      ?
16:53 tcohen        Anne Lena Westrum's email to the koha list
16:55 oleonard      magnuse isn't going to have time to buy donuts with all the work they'll have for him
16:55 * oleonard    hopes donuts were included in the contract
17:14 * cait        waves
17:22 rambutan      waves
17:26 Joubu         bye all
17:43 gaetan_B      bye !
17:45 reiveune      bye
18:01 tcohen        can anyone confirm bug 11533
18:01 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11533 major, P5 - low, ---, gmcharlt, NEW , "use" QueryParser breaks authority search
18:01 tcohen        ?
18:02 gmcharlt      tcohen: it works for me, but previous experience indicates that knowing exactly what kind of search you're doing would help for the bug report
18:03 gmcharlt      e.g., main heading vs all headings, contains vs starts with, and so forth
18:03 tcohen        isn't the unit test enough evidence?
18:03 gmcharlt      ah
18:03 gmcharlt      let me take a look
18:04 tcohen        thanks!
18:08 gmcharlt      tcohen: OK, so the difference between the UI and the test is that the UI has sets the default sort order to heading A-Z
18:08 gmcharlt      while the test has the sort order as 'none'
18:09 gmcharlt      and it looks like it's sort-order none that doesn't work in QP, specifically
18:09 tcohen        ok, and it happens to be the default, right?
18:11 gmcharlt      looks like Heading A-Z is the implicit default if there's no op CGI parameter
18:12 tcohen        besides the difference between the regression test and the UI handling sorting
18:13 tcohen        I can say the result is "no results" as soon as I enable QP
18:13 tcohen        in the UI
18:13 gmcharlt      only if the sort order is none
18:13 gmcharlt      a-z, z-a, works for me
18:14 tcohen        ok, how should I proceed? fix QP to default to something?
18:15 gmcharlt      tcohen: one moment, let me check something
18:23 pastebot      "gmcharlt" at 127.0.0.1 pasted "tcohen: try this one on for size" (13 lines) at http://paste.koha-community.org/86
18:27 tcohen        hmm, i have $sortby: HeadingAsc and QP
18:28 gmcharlt      which works for me
18:28 gmcharlt      with or without that patch
18:31 tcohen        gmcharlt: i just did a super-fresh master install
18:31 tcohen        added a couple of authority records, and nothing else
18:33 tcohen        how can I upload a screencast?
18:33 gmcharlt      tcohen: I've used http://www.techsmith.com/jing.html in the past
18:35 tcohen        gmcharlt: for me it doesn't work with QP, no matter which order I choose
18:36 * magnuse     waves
18:36 gmcharlt      tcohen: well, turn off the TortureTomas syspref!
18:36 gmcharlt      ;)
18:37 tcohen        that'd be great gmcharlt heh
18:38 tcohen        I just want to move to using QP so we can add our work hours to that
18:41 tcohen        maybe we broke it recently and you have an old QP file?
18:42 gmcharlt      no, they're in sync for me
18:46 * tcohen      is puzzled, and gives up
18:46 gmcharlt      tcohen: does the test case pass for you, at least, with the patch?
18:47 rangi         if you like the new dashboard
18:47 rangi         then you can thank  https://secure.flickr.com/photos/4nitsirk/11978856444/in/set-72157639826342535
18:47 rangi         the young woman on the left
18:48 tcohen        gmcharlt: yes, they pass
18:48 rangi         tcohen: emma is on the left https://secure.flickr.com/photos/4nitsirk/11978737674/in/set-72157639826342535
18:48 tcohen        she's really young!
18:49 rangi         yep they are all 16 or 17
18:49 rangi         https://secure.flickr.com/photos/4nitsirk/11979264396/in/set-72157639826342535  <-- the koha team (with francesca missing to the right
18:50 rangi         https://secure.flickr.com/photos/4nitsirk/11978337445/in/set-72157639826342535  <-- piwik
18:51 rangi         (matthieu the original author (and lead developer still) on the right)
18:52 magnuse       ooh, that's cool!
18:52 rangi         i think every project, drupal, mahara, piwik and Koha got some code into core
18:52 magnuse       awesome!
18:52 cait          rangi: cool photos :)
18:52 wahanui       That'll be $1 for the awesome jar, magnuse
18:52 cait          did you see magnuse big news yet?
18:52 rangi         the students are doing their reports back today, so we will find out
18:53 rangi         yep :)
18:53 rangi         tweeted it :)
18:53 magnuse       :-)
18:53 cait          :)
18:53 cait          a week of good news
18:53 rangi         cait: anitsirk took the photos, she takes good photos
18:53 cait          yep she does :)
18:53 magnuse       mother energy?
18:54 cait          ?
18:54 rangi         ah yeah, energy drink
18:54 rangi         about 6 coffees worth of caffeine
18:54 magnuse       lol
18:54 * magnuse     likes the look of this whiteboard: https://secure.flickr.com/photos/4nitsirk/11978868724/in/set-72157639826342535/
18:55 rangi         trust me, i need about 8 of those
18:55 rangi         ah yep that goes with this
18:55 gmcharlt      tcohen: once I finish witha  meeting I'll attach the patch + more test cases to the bug
18:55 pianohacker   that reminds me, we need to get a good coffee setup for hackfest
18:55 rangi         http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11558
18:55 huginn        04Bug 11558: enhancement, P5 - low, ---, oleonard, NEW , Collector bug for Academy bootstrap3 upgrading work  - Not ready (not even close) for use yet
18:55 magnuse       pianohacker: us hackfest?
18:56 magnuse       s/us/U.S./
18:56 tcohen        gmcharlt: thanks, I'm leaving home now, but will try to do more testing on this. My first thought was it was a local problem, but a fresh setup yielded the same results
18:56 rangi         magnuse: and also http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11566
18:56 huginn        04Bug 11566: enhancement, P5 - low, ---, oleonard, NEW , Fixing accessibility on OPAC
18:56 tcohen        we'll sort it out sooner or later
18:56 tcohen        bye!
18:56 tcohen        and congrats rangi
18:56 rangi         cya tcohen
18:57 tcohen        FOSS for the win!
18:57 rangi         @quote add  < tcohen> FOSS for the win!
18:57 huginn        rangi: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command).
18:57 magnuse       rangi: will there be any more work done on 11558 by the students?
18:57 rangi         @qyote get 3
18:57 huginn        rangi: downloading the Perl source
18:58 rangi         @quote search identify
18:58 huginn        rangi: 1 found: #73: "<chris_n> owen: try /msg munin identify nick..."
18:58 rangi         @qyote get 73
18:58 huginn        rangi: downloading the Perl source
18:58 rangi         @quote get 73
18:58 huginn        rangi: Quote #73: "<chris_n> owen: try /msg munin identify nick password" (added by owen at 12:38 PM, April 29, 2010)
18:58 rangi         magnuse: probably not, we are out of time, but i will collate it together into a branch
18:58 rangi         and get it to a testable state
18:59 rangi         @quote add  < tcohen> FOSS for the win!
18:59 huginn        rangi: The operation succeeded.  Quote #289 added.
19:01 magnuse       rangi: very cool!
19:02 rangi         pianohacker: https://fbcdn-sphotos-d-a.akamaihd.net/hphotos-ak-ash4/1385436_10201323207815161_1419204447_n.jpg
19:03 rangi         right gotta go back downstairs now for the last day of academy
19:03 pianohacker   pfffft
19:05 magnuse       rangi: have fun!
19:14 magnuse       kia ora as
19:39 rangi         https://secure.flickr.com/photos/4nitsirk/sets/72157639826342535/
19:45 aleishaa      https://secure.flickr.com/photos/4nitsirk/sets/72157639826342535/
19:46 rangi         https://secure.flickr.com/search/?q=kohacon13   <-- kohacon13 in Reno last year
19:50 rangi         http://bugs.koha-community.org/bugzilla3/buglist.cgi?bug_status=Needs%20Signoff&columnlist=product%2Ccomponent%2Cassigned_to%2Cbug_status%2Cshort_desc%2Cchangeddate%2Cbug_severity&list_id=86769&order=changeddate%20DESC%2Cbug_severity%2Cbug_id%20DESC&query_based_on=Needs%20Signoff&query_format=advanced
19:50 rangi         does that url work for people?
19:51 francesca     works for me
19:52 oleonard      That's a big list :|
19:52 rangi         so students lets see if we can make that list a big shorter by testing and signing off
19:56 pianohacker   cait: translation q
19:56 cait          filling up my queue is the plan? :)
19:56 * magnuse     cheers the students on
19:57 cait          pianohacker: yes?
19:57 magnuse       yeah, fill all the queues!
19:57 pianohacker   cait: Is there any way at all to do formatted translations in JavaScript?
19:58 cait          ?
19:58 cait          what are you trying to do?
19:58 pianohacker   For example, "Found 10 matches in 3 external targets"
19:59 pianohacker   There's ways to break that up so it isn't needed, but it looks a lot less natural
19:59 cait          i think we had this discussion earlier
19:59 pianohacker   possibly
19:59 cait          there seems to be a jquery replace thing
19:59 cait          look at the logs from today
20:00 cait          there was a discussion with paxed and oleonard
20:00 pianohacker   woot! Thanks.
20:00 cait          well not a perfect solution, but maybe some ideas :)
20:01 pianohacker   And is it considered kosher to leave the tags inside a short HTML bit? like
20:01 rangi         mtompset: one of the students is going to test bug 11513
20:01 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11513 minor, P5 - low, ---, mtompset, Needs Signoff , Warnings in Patron categories
20:01 pianohacker   $stuff.html( _( "<span>Yay!</span>" ) );
20:02 mtompset      Sounds good to me, rangi. I think the test plan is easy enough to follow. :)
20:02 rangi         yep
20:02 oleonard      pianohacker: No
20:02 cait          well in that example i wouldn't leave it in
20:03 magnuse       @later tell slef: a cycling library unconference between barcelona and lyon - something for you? :-)http://cyc4libse.tumblr.com/post/73532123683/woop-woop-i-ar-cyklar-vi-till-kaunas-och-lyon-dock
20:03 huginn        magnuse: The operation succeeded.
20:03 cait          if you just wan to bold one word... i might leave it... to not break up the sentence but best to avoid totally
20:03 mtompset      pianohacker: you forgot the style="display: none" ;)
20:03 pianohacker   so $stuff.html( '<span>' + _( "Yay!" ) + '</span>' ) ?
20:04 cait          way better
20:04 * pianohacker loves our translaters and hates our JS translation system...
20:04 cait          feel free to improve ;)
20:04 pianohacker   heh well that's the thing
20:05 pianohacker   you'd need the kind of masochistic fool who'd do something like redo the sysprefs
20:05 pianohacker   and where are we gonna find one of those?
20:05 * mtompset    looks at pianohacker. :)
20:09 cait          http://www.librarytechnology.org/ltg-displaytext.pl?RC=18805 < opl again :)
20:09 cait          or someone who would redo catalouging ;)
20:12 pianohacker   woo! and yeah, that kinda weirdo
20:15 wizzyrea      pianohacker
20:15 wahanui       somebody said pianohacker was a Dune fan, it seems.
20:15 wizzyrea      just the person I wanted :)
20:15 pianohacker   uh oh
20:15 pianohacker   wazzup :)
20:16 wizzyrea      well I am trying to use your z39.50 external search patch
20:16 wizzyrea      and for the life of me I cannot make pazpar2 cooperate
20:17 pianohacker   wizzyrea: do you have all of the new config files from the patch and its followups?
20:17 wizzyrea      yep, I applied all of them
20:17 pianohacker   and the pazpar2 config files are installed?
20:18 MrAgent075    http://paste.koha-community.org/87
20:18 rangi         thanks
20:18 wizzyrea      that's what I don't know
20:18 rangi         students http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ef7480f362a0286b13e1ba1b99e58c6d2ca7ba72#patch1
20:19 pianohacker   someone more familiar with the perl installer: is there an easy way to reinstall select config files from the templates?
20:20 cait          no
20:20 cait          mysql client
20:20 cait          or myswl on command line... or... :)
20:20 cait          pianohacker: i have an idea for another great gui project for you
20:20 cait          circulation rules :)
20:26 gmcharlt      pianohacker: it depends
20:27 gmcharlt      there's an update_zebra_conf Makefile target, for example
20:27 rangi         MrAgent075++ checkout out the dashboard now
20:27 * cait        does
20:27 cait          logo? :)
20:28 rangi         yep
20:28 cait          woo :)
20:28 MrAgent075    Yay, it works! :)
20:28 MrAgent075    (Person who make the .svg logo)++
20:29 cait          :)
20:29 pianohacker   gmcharlt: Am I reading that code right? It looks like it should also update the pazpar2 configuration
20:29 cait          the dashboard looks great
20:29 gmcharlt      pianohacker: correct
20:30 pianohacker   hell yeah
20:30 pianohacker   gmcharlt++
20:30 cait          gmcharlt++ :)
20:31 francesca     http://pbrd.co/1dzopVX link to favicon for dashboard
20:32 pastebot      "francesca" at 127.0.0.1 pasted "favicon code" (3 lines) at http://paste.koha-community.org/88
20:36 francesca     @quote random
20:36 huginn        francesca: Quote #213: "jwagner: There are few problems that can't be solved with patience, ingenuity, and a large kick in the pants (assuming servers wear pants, that is)." (added by wizzyrea at 06:18 PM, August 07, 2012)
20:37 MrAgent075    rangi: possibly impliment the maxlength attribute on the Random Quotes? #koha-dashboard
20:38 rangi         hmm yeah, wanna paste me the code?
20:40 wizzyrea      that's really pretty!
20:42 cait          :)
20:42 cait          can i make a suggestion?
20:42 t-houlks      chris, where's that list that has all of our patches saying if they're signed off or not?
20:42 cait          the hover on the toolbar is a bit dark, maybe it could pop a bit more?
20:42 cait          looking at it in firefox
20:42 rangi         t-houlks: http://wiki.koha-community.org/wiki/Catalyst_Academy
20:43 t-houlks      cheers
20:43 francesca     I'm fixing the hover colour for the links now
20:44 cait          cool, thx francesca
20:44 francesca     is there a particular colour you would like the links to turn when when hovered over?
20:44 wizzyrea      light grey
20:45 francesca     ok
20:45 MrAgent075    rangi: Where are the quotes being generated from? The idea I had seems like the easy way out, but ultimately, a script should be made where quotes that are at the limit of 'x' and under should be put up.
20:46 pastebot      "francesca" at 127.0.0.1 pasted "changing link hover colour" (4 lines) at http://paste.koha-community.org/89
20:46 rangi         they are from the bot
20:46 rangi         fetched from a file
20:46 rangi         if you look here
20:47 rangi         MrAgent075: https://gitorious.org/koha-dashboard/koha-dashboard/source/ebf43d2e810b4e7a2cb0defe13a1c7d431c9d377:data
20:47 rangi         the koha_irc_quotes.txt file
20:47 rangi         is where they come from
20:50 gmcharlt      with the latest and greatest from http://librarypolice.com/~gmc/koha_irc_quotes.txt
20:54 rangi         thanks gmcharlt
20:56 cait          :)
20:57 cait          @wunder Konstanz
20:57 huginn        cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 4.7°C (9:55 PM CET on January 16, 2014). Conditions: Mostly Cloudy. Humidity: 90%. Dew Point: 3.0°C. Windchill: 5.0°C. Pressure: 29.74 in 1007 hPa (Rising).
20:57 rangi         @wunder nzwn
20:57 huginn        rangi: The current temperature in Wellington, New Zealand is 15.0°C (9:30 AM NZDT on January 17, 2014). Conditions: Partly Cloudy. Humidity: 72%. Dew Point: 10.0°C. Pressure: 29.62 in 1003 hPa (Steady).
20:59 cait          way too warm here still
21:00 rangi         @wunder melbourne
21:00 huginn        rangi: Error: No such location could be found.
21:00 rangi         @wunder melbourne, australia
21:00 huginn        rangi: The current temperature in AO-GSO, Melbourne, Victoria is 28.8°C (7:48 AM EST on January 17, 2014). Conditions: Clear. Humidity: 45%. Dew Point: 16.0°C. Pressure: 29.80 in 1009 hPa (Steady).
21:00 rangi         that is too warm, its getting to 45 there today
21:00 rangi         i hope its cooler by february
21:06 magnuse       @wunder boo
21:06 huginn        magnuse: The current temperature in Bodo, Norway is -6.0°C (9:50 PM CET on January 16, 2014). Conditions: Clear. Humidity: 58%. Dew Point: -13.0°C. Windchill: -16.0°C. Pressure: 30.15 in 1021 hPa (Steady).
21:07 pastebot      "francesca" at 127.0.0.1 pasted "link hover colour fix" (7 lines) at http://paste.koha-community.org/90
21:11 francesca     color: rgb(184, 184, 184);
21:13 pianohacker   francesca: not a fan of hex colors? :)
21:15 oleonard      Bye #koha
21:19 MrAgent075    @wunder London, England
21:19 huginn        MrAgent075: The current temperature in London / Heathrow Airport, United Kingdom is 7.0°C (9:00 PM GMT on January 16, 2014). Conditions: Light Rain. Humidity: 84%. Dew Point: 5.0°C. Pressure: 29.17 in 988 hPa (Falling).
21:19 MrAgent075    @wunder Maarssen, Netherlands
21:20 huginn        MrAgent075: The current temperature in Maarssenbroek, Maarssen, Netherlands is 6.7°C (10:19 PM CET on January 16, 2014). Conditions: Scattered Clouds. Humidity: 99%. Dew Point: 7.0°C. Windchill: 7.0°C. Pressure: 29.42 in 996 hPa (Rising).
21:26 pastebot      "MrAgent075" at 127.0.0.1 pasted "maxlength attribute to Random Quotes" (9 lines) at http://paste.koha-community.org/91
21:47 cait          good night #koha
21:47 pianohacker   good night cait
21:47 cait          bye pianohacker :)
21:50 pastebot      "francesca" at 127.0.0.1 pasted "new favicon" (2 lines) at http://paste.koha-community.org/92
21:51 francesca     heres the link to the image http://pbrd.co/Km1RLy
21:54 MrAgent075    wizzyrea: you on Lv. 7?
22:01 wizzyrea      ya
22:01 wizzyrea      ok that favicon is super cute.
22:01 pianohacker   is that a reference to a floor or a game?
22:02 pianohacker   That is an excellent favicon yes
22:02 * wizzyrea    uses it on the koha website
22:02 * pianohacker thought at first wizzy was talking about habitrpg :)
22:05 francesca     wow.
22:07 * francesca   is very excited
22:07 pianohacker   about? :)
22:08 francesca     the favicon I designed  for the dashboard being used on the koha website
22:09 rambutan      francesca: you have some artistic ability it would seem?
22:10 francesca     not really.. I just use inkscape
22:10 pianohacker   inkscape++
22:10 rambutan      inkscape requires some artistic ability!
22:14 mrx           Hi guys, I am using ExtractValue as below to search isbn listed in a record as a second 020 field but the statment is not returning anything but if I use the first isbn listed in 020 filed of the same record it returns all 020 fields. Is there a way to search isbn other than the first listed in 020 filed?
22:14 mrx           SELECT ExtractValue((SELECT marcxml FROM biblioitems WHERE
22:14 mrx           isbn=9781922244024), '//datafield[@tag="020"]/subfield[@code>="a"]') AS
22:14 mrx           ITEM
22:16 wizzyrea      francesca: http://img585.imageshack.us/img585/9908/6ykn.png
22:18 rangi         mrx: no
22:18 rangi         is the short answer
22:19 rangi         the only way is to do LIKE %value%
22:19 rangi         which might get you some false positives occassionally
22:21 francesca     so exciting!!
22:23 mrx           rangi: what will be the LIKE query in this case as I'm unable to get it to work I think
22:28 rangi         SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') as isbns WHERE isbns LIKE '%9781922244024%'
22:29 rangi         actually
22:29 rangi         SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') as isbns FROM biblioitems WHERE isbns LIKE '%9781922244024%'
22:30 rangi         something like that anyway
22:33 mrx           rangi: humm, unfortunately returns same results as before. It only appears to search the for 1st listed isbn not the rest...
22:35 wizzyrea      maybe you'd have better luck with something like select biblionumber, isbn from biblioitems where isbn LIKE '%9781922244024%'
22:36 wizzyrea      guess it would depend on how you catalogued them.
22:38 mrx           wizzyrea: what do you mean by how you catalogued them as that query return same result
22:43 rangi         Roman_: https://web.archive.org/web/20130403095533/http://dashboard.koha-community.org/
22:43 francesca     tom heres the link to the image http://pbrd.co/Km1RLy
22:45 wizzyrea      do you have multiple 020a fields per record, or several isbns in a single 020a?
22:46 mrx           wizzyrea: multiple 020s
22:52 francesca     tom http://img585.imageshack.us/img585/9908/6ykn.png
22:59 wizzyrea      SELECT biblionumber, isbns FROM (select biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') AS 'isbns' FROM biblioitems) as isbns where isbns LIKE '%YOURISBN%';
22:59 wizzyrea      or something.
22:59 wahanui       i think something is fishy
22:59 wizzyrea      me too. Me. Too.
23:02 dcook         wizzyrea: What's the scenario?
23:02 wahanui       rumour has it the scenario is a problematic patch across versions
23:02 wizzyrea      he wants to see all biblionumbers that have a certain ISBN in one of their multiple 020a's
23:03 wizzyrea      biblioitems isbn only has the first, but the xml has them all.
23:03 dcook         Pretty sure that your first "select biblionumber, isbn from biblioitems where isbn LIKE '%9781922244024%'" should work for that then
23:03 dcook         Oh wait
23:03 dcook         Durr
23:03 dcook         Nvm
23:04 dcook         select biblionumber from biblioitems where ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') like '%ISBN%'
23:04 wizzyrea      he wants to see the ISBN as well
23:04 wizzyrea      isbns*
23:04 dcook         select biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') as 'isbns' from biblioitems where ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') like '%ISBN%'
23:04 dcook         or..
23:05 dcook         select biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') as 'isbns' from biblioitems having `isbns` like '%ISBN%'
23:05 dcook         May or may not need those mysql backticks...can't recall for sure..
23:05 dcook         Actually subfield[@code>="a"] should probably just be subfield[@code="a"]
23:06 dcook         No real reasoon to have that > in there
23:06 wizzyrea      either way, a buffet of queries there for him to choose from
23:06 dcook         Yep
23:06 * dcook       was just wondering because this seems to have been the same question from yesterday? :S
23:06 jcamins       dcook: or, if performance is a concern: SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code="a"]') AS 'isbns' FROM biblioitems WHERE marcxml LIKE '%ISBN%';
23:07 dcook         Hmm, probably. Although you might have that same number somewhere other than the 020$a
23:07 dcook         Doubtful though
23:07 jcamins       dcook: if performance is a concern, filter after-the-fact.
23:07 dcook         Totes
23:08 jcamins       (to get rid of whichever records don't match)
23:08 wizzyrea      mrx: all of that ^ was for you.
23:08 wizzyrea      (also, that's pretty magic, 4 people, 3 countries, one question.)
23:09 jcamins       I don't actually know what we're trying to do.
23:09 wizzyrea      (3 timezones as well)
23:09 mrx           Thanks heaps guys, very much helpful
23:09 jcamins       Something to do with ISBNs.
23:09 mrx           much appreciated
23:11 huginn        New commit(s) kohagit: Bug 10987: (follow-up) fix display of authorities containing only one see from or... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e686dd25438b66de751551c8f8fecff115b661d4> / Bug 10987: remove duplicate 'see also' and 'see from' labels from authority search... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=910dff28254b8a93ed03884b0e768fd7c013f449> / Bug 10691: (follow-up) replace HTML co
23:11 jcamins       Wow, I'm loving this module maintainer gig.
23:11 jcamins       Within five minutes of getting home, someone's taken care of it for me. :D
23:11 jcamins       gmcharlt++
23:26 francesca     @quote random
23:26 huginn        francesca: Quote #123: "rangi: #thingsihavelearnt if there is a mad scheme a library somewhere will be doing it ... except madder" (added by wizzyrea at 09:20 PM, March 30, 2011)
23:27 wizzyrea      too right
23:30 dcook         mhm
23:30 * dcook       is looking at MFHD
23:30 jcamins       Avaunt foul spirit!
23:32 dcook         It seemed like a good idea in theory?
23:33 jcamins       dcook: I find your theory to be wholly disturbing.
23:33 jcamins       :P
23:33 dcook         hehe
23:34 dcook         I just wonder if MARC is fully implemented anywhere or has ever been
23:34 dcook         There are so many fields that a user would never use
23:34 dcook         There are so many fields that a librarian would probably never use
23:35 francesca     @quote random
23:35 dcook         There are so many fields that a super anal archivist might use...but with no one ever looking at it again
23:35 huginn        francesca: Quote #214: "obelos: Perhaps this means it's time for HLT to choose a different name so we can all move on with our work without this distraction." (added by mtj at 01:52 AM, August 08, 2012)
23:35 dcook         marc?
23:35 wahanui       The MARC specs live at http://www.loc.gov/marc/bibliographic/ - abandon hope all ye who enter here.
23:35 dcook         Hmm
23:35 dcook         die marc?
23:35 dcook         die marc!
23:35 dcook         I'll leave it there :p
23:42 wizzyrea      to that quote I say http://kohadevreactions.tumblr.com/post/69868436107/ptfs-liblime-trademark-application-for-kohails-in
23:42 dcook         lol
23:43 dcook         @karma davidtennant
23:43 huginn        dcook: davidtennant has neutral karma.
23:43 dcook         davidtennant++
23:43 dcook         Just sayin'
23:44 dcook         http://kohadevreactions.tumblr.com/post/73499272725/someone-tells-you-of-a-stubborn-bug-kohails
23:44 dcook         It took way too long but sort of figured out that double encoding of ampersands..
23:45 dcook         Well, not so much figured out as ran out of room to debug
23:45 dcook         OH SNAP
23:45 * dcook       facepalm
23:45 wahanui       rumour has it facepalm is a tiny member of the Arecaceae family whose preference for warm, humid environments makes it a perfect choice for cultivation in the human nasal cavity
23:45 dcook         I lies
23:45 dcook         I just found it
23:45 dcook         #$*^(%^@@%@)!
23:51 dcook         So much rubber duck...