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