IRC log for #koha, 2012-09-10

All times shown according to UTC.

Time S Nick Message
00:04 jcamins Excellent!
00:04 jcamins Skinning almonds: even worse than writing unit tests
00:23 wajasu Whew! done.
00:23 wajasu jcamins++
00:32 wajasu jcamins_away: 8209 is passwd QA, so i expect its on master, so i can try 8726 now
00:33 wajasu i'm taking a break first.
00:34 wajasu i notice if i do a search "1000"    in OPAC,  that  "1,000 Things to love in America" doesn't give results.  Not that it should, but if you have a comma '1,000' it does find it.  Just sayin.
00:58 mtj hi #koha
00:59 rangi try switching fuzzy searching on wajasu
00:59 mtj i was curious about the perl/ipv6 topic before...
01:00 mtj this looks promising ->[…]rs/perl-ipv6.html
01:00 mtj … so, fixed(ish) on perl-5.14?
01:01 rangi its bogus
01:01 mtj 'Perl 5.14 ships with a complete set of IPv6-related functions in the Socket module.'
01:01 rangi its supported it for years in bunches of modules
01:01 rangi now its core
01:02 mtj aaah, ok - thats good to know :)
01:02 rangi i wouldnt worry about it it was a hastitly thought up excuse to explain an already decided behaviour
01:02 rangi don't feed the trolls :)
01:02 mtj amen to that...
01:02 mtj and, also…. ->
01:04 mtj and nicole's koha manual too ->[…]sphinx/index.html
01:04 rangi ohh so pretty!
01:04 rangi nice :)
01:04 rangi just missing the chapters?
01:05 rangi very nice tho
01:05 mtj hmm, the TOC is built into the 'pages' dropdown...
01:06 rangi ahhh
01:06 mtj not sure about the chapters stuff… (i did it laaate last nite)
01:06 mtj … and didnt check anything
01:09 jcamins_away wajasu: you may need to resolve conflicts in sysprefs.sql and updatedatabase, but they should be pretty easy.
01:11 mtj they great news about my 'koha-docs' stuff, is that its all automated/scripted
01:13 rangi yay!
01:13 mtj so, from that ->  ...
01:13 mtj … to this ->
01:13 mtj all automagicical
02:12 wajasu i tried barb, to, love, amer and 1st 6 numbers of isbn and it found the book ...1000 things to love about America.   Is that the fuzzy serach?
02:14 mtj sounds fuzzy to me :)
02:15 rangi wajasu: check the sysprefs
02:15 rangi it will tell you if its on or not
02:16 wajasu sysprefs have QueryFuzzy = Try!
02:17 wajasu i'm going to try to test 8726 now
02:26 wajasu jcamins_away: it tried to apply 8276 but => fatal: sha1 information is lacking or useless (Koha/
02:27 rangi check what it depends on
02:27 rangi you probably need to apply that/them first
02:28 wajasu 8209 is passed QA so its on master, correct?
02:29 rangi nope
02:29 rangi its passed qa
02:29 wajasu ok. then
02:29 wajasu i'll try it.
02:30 rangi[…]nt-patch_Workflow
02:33 wajasu reconciling updatabase and sysprefs sql
02:33 wajasu for 8209
03:11 wajasu after all the dependsOn:     fatal: sha1 information is lacking or useless (installer/data/mysql/sysprefs.sql
03:12 wajasu the patch file mentions jquery ui datepicker  version upgrades
03:14 pastebot "wajasu" at pasted "after applying all dependOn is get" (47 lines) at
03:16 wajasu maybe i need 8143
03:19 wajasu no its in my git log already
03:26 rangi well if you ahve tried all the depends, then its a patch does not apply
03:39 wajasu jcamins was rebasing and  reposting patches for me all afternoon for 8211  so its probably the same deal. tommorrow then.
03:39 wajasu thx
03:41 wajasu i'll probably get 8726 done in my morning.  do you have any specific patches i should persue tomorrow?
04:08 cait joined #koha
04:29 mib_iz3xvq joined #koha
04:36 Oak Guten morgen miss cait
04:38 cait Salaam Oak
04:54 Oak :)
05:03 laurence joined #koha
05:14 Oak magnuse
05:14 Oak kia ora #koha
05:47 rangi Mtj I think you meant passed qa not pushed for qa?
05:48 mtj oops, fixed :)
06:04 cait mtj++
06:05 cait pretty manual and installation documentation :)
06:10 magnuse Oak
06:13 cait hi magnuse
06:14 magnuse hiya cait
06:14 magnuse yeah, mtj++
06:41 cait work time bbl
06:44 alex_a joined #koha
06:44 alex_a bonjour #koha
06:47 reiveune joined #koha
06:47 reiveune hello
06:50 matts hi !
06:50 alex_a1 joined #koha
06:56 julian_m joined #koha
06:57 asaurat joined #koha
06:57 sophie_m joined #koha
07:01 paul_p joined #koha
07:01 paul_p joined #koha
07:05 mbalmer joined #koha
07:05 gaetan_B joined #koha
07:06 gaetan_B hello
07:24 drojf joined #koha
07:24 drojf good morning #koha
07:38 magnuse hiya drojf et al
07:38 drojf hei magnuse
07:39 magnuse :-)
07:42 mtompset joined #koha
07:42 mtompset Greetings, #koha.
07:58 jcamins_away wajasu: rebased bug 8209 and bug 8726.
07:58 huginn Bug[…]w_bug.cgi?id=8209 enhancement, P5 - low, ---, jcamins, Passed QA , "Did you mean?" suggestions based on authorities
07:58 huginn Bug[…]w_bug.cgi?id=8726 enhancement, P5 - low, ---, jcamins, Needs Signoff , Did you mean? plugin for broader/narrower/related terms
08:00 mtompset jcamins_away?! What timezone are you? I wouldn't have expected you for another couple hours.
08:01 jcamins mtompset: EST.
08:01 jcamins It's 4am.
08:01 jcamins My wife had a 6:15 calltime two hours away.
08:02 jcamins I spent the last two hours telling myself that I was going to fall back asleep, but eventually I had to just give up.
08:02 mtompset Ah, okay.
08:02 mtompset Might as well be productive, right?
08:03 jcamins Exactly.
08:03 jcamins Rebase all the things!
08:03 kf joined #koha
08:08 * mtompset chants, "Rebase! Rebase! Rebased!"
08:09 mtompset jcamins?
08:09 wahanui jcamins is, like, A-Grade developper on Koha willing to rewrite it from top to bottom. Good Luck jcamins or a very naughty wahanui teacher
08:09 * mtompset laughs, "Nice addition."
08:09 kf lol
08:09 kf how did that happen?
08:10 mtompset Wasn't me, thankfully.
08:10 jcamins lol
08:11 mtompset Hi, kf.
08:12 kf hi mtompset, wahanui and jcamins
08:14 mtompset mtj is the Mason James that wanted to be "Installation Documentation Manager" on the list, right?
08:15 jcamins Speaking of mtj... mtj, wouldn't you like to QA 8649? :)
08:19 mtompset bug 8649?
08:19 huginn Bug[…]w_bug.cgi?id=8649 enhancement, P5 - low, ---, jcamins, Signed Off , C4::Search needs a unit test
08:24 mtompset What do you think of bug 8742, jcamins? :)
08:24 huginn Bug[…]w_bug.cgi?id=8742 trivial, P5 - low, ---, mtompset, Needs Signoff , Example uses perl 5.8 in Makefile.PL
08:26 jcamins We should probably change the example to not be list a hardcoded perl version.
08:36 jcamins kf: fixed the tree opening.
08:38 BobB joined #koha
08:41 kf jcamins++
08:44 rangi paul_p: did you try the tests? they fail before the patch and pass after, and that error you are getting is not the one that was being caused
08:45 mtompset I put a patch to try to find a reasonable perl version.
08:45 jcamins paul_p: that sounds like a different error, possibly not related to bug 8089.
08:45 huginn Bug[…]w_bug.cgi?id=8089 enhancement, P5 - low, ---, gmcharlt, Signed Off , Use Koha::Cache everywhere
08:46 jcamins Jinx!
08:46 rangi heh
08:51 reiveune1 joined #koha
08:51 rangi i just tested on master
08:52 rangi before the patch, i cant edit a borrower
08:52 * jcamins did too.
08:52 rangi after the patch i can
08:52 jcamins Ditto.
08:52 rangi so im not sure where that other error is coming from
08:54 mtompset Oh the joys of bug hunting. :)
08:54 * mtompset cheers rangi and jcamins on. :)
08:55 rangi we're done, can't recreate, sounds like a local issue
09:06 julian_m joined #koha
09:07 reiveune joined #koha
09:25 alex_a joined #koha
10:00 asaurat joined #koha
10:01 laurence joined #koha
10:02 mtompset Hmmm... I just had a weird thought.
10:02 mtompset What if someone creates two repository lists to the same repository?
10:03 mtompset Should work still, right?
10:04 jcamins Of course.
10:04 jcamins That's how I have my RMaint repo set up.
10:05 jcamins One for pushing, one for fetching.
10:07 kf rangi, jcamins: why not comment on the bug?
10:08 jcamins kf: rangi did.
10:08 kf ahcool
10:34 alex_a joined #koha
10:35 jcamins Wow. Bug 8300 was a challenge.
10:35 huginn Bug[…]w_bug.cgi?id=8300 enhancement, P5 - low, ---, gmcharlt, Needs Signoff , Koha should have mechanized testing suite
10:43 asaurat left #koha
11:23 Barrc joined #koha
11:36 reiveune1 joined #koha
11:44 nengard joined #koha
11:46 asaurat joined #koha
12:07 drojf joined #koha
12:11 nengard morning #koha
12:11 nengard you're all featured on today :)[…]pen-source-openly
12:11 kf hi nengard
12:13 nengard hiya
12:14 mtompset Greetings, nengard.
12:16 clrh joined #koha
12:17 oleonard joined #koha
12:17 Oak joined #koha
12:20 drojf ctrl+f "freedom" on … "not found" …
12:22 nengard agreed
12:22 nengard but that's my point
12:22 nengard it's not about the letter of the law (or license) it's about what we believe, feel, etc
12:27 kf magnuse: around?
12:27 magnuse um, yup
12:27 kf could you create a wiki page for the gbsd this friday?
12:27 kf I can edit it, but I am stupid when it comes to adding new pages with mediawiki
12:28 magnuse hehe, will do
12:30 drojf nengard: that may work on a "per project" basis. we as the koha community do things in a certain way and some of us call it "open source". personally my associations with the term "open source" are very much in the direction of the roy-tennant-quote and there is nobody preventing companies from labelling their projects "open source" that have this kind of philosophy. "free software" in the fsf/gpl meaning seems more explicit to me.
12:30 magnuse kf:[…]bug_squashing_day
12:30 magnuse next gbsd is[…]bug_squashing_day
12:30 magnuse next gbsd?
12:30 wahanui next gbsd is[…]bug_squashing_day
12:31 magnuse wahanui: forget next gbsd
12:31 wahanui magnuse: I forgot next gbsd
12:31 magnuse next gbsd is[…]bug_squashing_day
12:31 magnuse next gbsd?
12:31 wahanui next gbsd is[…]bug_squashing_day
12:31 magnuse yay
12:31 kf thx :)
12:31 kf it's on my list for today to send that mail :)
12:31 magnuse yay!
12:31 * magnuse had forgotten...
12:31 kf h
12:31 kf m
12:31 kf I was thinkign aobut adding a link to paul's list of patches in the newsletter
12:32 kf and mention the deadlines
12:32 kf thatok for you?
12:32 nengard drojf and I understand that and so do those here in this room - but the average librarian or average computer user doesn't understand why there are different definitions - as an educator I want people to understand that choosing Koha means choosing community, means choosing freedom, means all that free software is defined as, even though we call it the 'open source' ils
12:32 magnuse excellent, kf!
12:32 kf magnuse: wait until it's done
12:32 kf have to update some documentation first
12:32 magnuse kf: that's why i didn't ++ you yet ;-)
12:33 kf wise :)
12:35 kf grr. outlook forgot my settings, for like the thenth time
12:35 kf tnis is not funny
12:35 magnuse :-(
12:38 samuel joined #koha
12:38 tcohen joined #koha
12:38 samuel hi everybody
12:40 samuel could someone tell me what is the best way to insert items in kohar?  All my recors have been added but i 've ton insert and link records with items. I've a text file with all my items but i've some problems ton convert it in marc file.
12:40 kf hi samuel
12:40 drojf nengard: according to search engines, we call it "free and open source software", while the fork calls it "open source".
12:41 kf the easiest way is to add it using the import scripts in 952 fields.
12:41 kf I think you could also fill the items table directly, but the hard part is to get the right biblionumbers for your records. And you will have to do a full reindex. Or you can write a perl script using the API for adding items.
12:42 samuel with bulkmarcimport? In france, it's in 995 fields
12:43 kf oh sorry, that's right
12:43 kf for UNIMARC it's 995
12:43 kf yes, you can use staged or bulkmarcimport - but you need marc for that
12:44 samuel yes and that's where i have some problems with marcedit to do a marc file.
12:45 edveal joined #koha
12:48 kf samuel: not sure how to help you here :(
12:48 oleonard Hi #koha
12:48 samuel dont' worry, i'm looking for.Our ils make me crazy :-)
12:49 kf what are you currently using?
12:49 Topic for #koha is now  Welcome to #koha this channel is for discussion of the Koha project and software The Next General Meeting is 10 October 2012 at 10:00 UTC+0
12:50 nengard drojf this is a longer conversation then one I can have by typing it all out :) and it's monday morning and my brain isn't working - suffice it to say that librarians and most general computers users don't make the distinction between free and open source - they lump it together  (right or wrong - that's what they do)
12:50 samuel kf:marcedit
12:51 kf ah, I meant as an ILS :)
12:51 edveal left #koha
12:52 drojf nengard: i agree we should not discuss this in detail now, i have a paper to work on :)
12:52 oleonard nengard: As more and more "open source" projects appear on the radar of those librarians, I think it behooves us to start educating about the distinction. Just as we had to educate about the difference between "free" and "open source"
12:53 talljoy joined #koha
12:53 kf oleonard++
12:53 samuel KF:Our ILS is an old french ILS. In fact, it's not really an ILS, at the beginning, its 's an ECM. It's very very very old and , no good solutions to export
12:53 kf yes, I think we should use the correct terms
12:53 nengard oleonard, what distinction are you talking about? - i do educate people about what free software is versus open source software
12:53 kf still have to learn a lot myself - trying to get it right
12:55 oleonard nengard: I mean exactly the distinction you talk about in your blog post and article: The difference between open in name only and open in spirit.
12:55 nengard :) oh!
12:55 nengard see - it's monday morning and my brain isn't working right yet
12:55 nengard hence the reason i can't have a deep discussion :)
12:55 oleonard I believe that's what drojf is getting at about adding the "freedom" to the "open source"
12:58 nengard oh!
12:59 nengard got it!
12:59 nengard now - a question - what tutorial videos do we need?? :)
12:59 nengard I'm out of ideas
13:00 nengard is there an easy way to find a vendor using their ID number?
13:01 nengard one library wanted a video on how to find out the vendor name using the ID number that's being put in the item record during acquisitions
13:01 kf hm
13:01 edveal joined #koha
13:01 kf I think you can't do that easily right now
13:01 jcamins nengard: I think you have to enter it into the URL, but I could be mistaken.
13:01 kf amybe a custom report
13:01 kf yeah or manipulate the url
13:01 nengard that's what i was worried about
13:02 nengard not sure i want to do a video on how to change the URL
13:02 kf I think you could probably use jQuery to create a link...
13:02 kf on the page
13:02 nengard and a report in a video isn't copy-able
13:02 nengard kf ? ooooooo
13:02 nengard i like that idea
13:02 nengard i did report bug 8676
13:02 huginn Bug[…]w_bug.cgi?id=8676 enhancement, P5 - low, ---, oleonard, NEW , show vendor name in source of acquisition
13:02 kf I mean it should be possible to get the number shown and place a link somewhere near to it - but have no time to work that out right now :(
13:03 kf nengard: I think the problem with that is, that a pull down will not work
13:03 nengard that's okay
13:03 kf We have a special library with several hundreds of vendors
13:03 nengard yeah,
13:03 nengard and so do a lot of libraries
13:03 kf what we would need is show the name - read only maybe
13:03 oleonard nengard: Did you see my request for a screenshot on that bug?
13:03 kf or a new feature
13:03 nengard but jquery might be the way to go
13:03 kf like make the field use a autocomplete thingy
13:03 nengard oleonard, i did not, adding one now
13:04 kf or a search button to search for the vendor like we do in serials
13:06 ago43 joined #koha
13:06 nengard OOOOO  -I got it
13:06 nengard I know how to show people to do this
13:06 mtompset Does anyone know how to DELETE a wiki page?
13:06 nengard I'll be back with a link for you all
13:06 nengard i think that's a special permission
13:07 mtompset Even if I created the page?
13:08 oleonard mtompset: Don't you simply empty the contents of the page?
13:08 * oleonard vaguely recalls?
13:08 mtompset I tried that.
13:08 mtompset The page still exists.
13:09 oleonard Exists as an empty page?
13:09 mtompset yes.
13:09 oleonard Try the help.
13:09 mtompset where is that?
13:09 wahanui i heard that was pulled from the fields
13:10 mtompset wahanui forget that
13:10 wahanui mtompset: I forgot that
13:10 oleonard mtompset: Left-hand sidebar?
13:10 mtompset Ah, normal users can't do it.
13:11 mtompset Well, I figure our fearless "Installation Documentation Manager" (mtj) will fix it whenever. :)
13:12 NateC joined #koha
13:13 mtompset mtj++ # for verbalizing and volunteering regarding such a position. :)
13:14 paul_p joined #koha
13:16 saa joined #koha
13:19 nengard kf, jcamins:[…]-koha-3-8-6345112
13:19 nengard and oleonard
13:19 wahanui oleonard is still here, if you just wish hard enough. or Koha's master UI designer
13:19 nengard hehe
13:20 wajasu jcamins_away: will try 8209 and 8726
13:20 saa i have been getting no results in OPAC even cron job is set in 3.8.3 koha zebrasrv gives error as "DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at /home/koha/bin/ line 124."
13:20 gmcharlt @quote random
13:20 huginn gmcharlt: Quote #17: "<wizzyrea> holy flaming bacon batman!" (added by jdavidb at 09:40 PM, July 17, 2009)
13:20 saa can someone help
13:21 saa i am preparing livecd for koha with new version of koha
13:23 trea joined #koha
13:23 mtompset Sorry, saa, but a livecd is not recommended.
13:23 mtompset By the time you finish burning it, and passing it around, the next version will already be released.
13:23 saa we knw but still it is useful
13:24 saa for workshops on koha
13:25 saa and where people are nt aware about installation or cannot handle installation
13:25 mtompset Yes, but then those people will take the livecd with them, and cascade the problem.
13:25 kf mtompset: there are places where people can't download so much data easily
13:26 mtompset I know, kf. But outside of the workshop, a support nightmare has been created.
13:28 mtompset (assuming they take the LiveCD with them)
13:28 oleonard mtompset: You can ask that this disadvantage be pointed out, but you can't stop people from wanting to create LiveCDs
13:29 saa we burn these iso on CDROM and distribute during workshop
13:29 saa which is very helpful and handy for participants
13:30 saa can someone help to solve the above error
13:30 kf magnuse: why is it so hard to find a mail from you about gbsd? I wanted to steal shamelessly :)
13:30 mtompset What error?
13:31 oleonard posted above mtompset
13:31 saa koha zebrasrv gives error as "DBD::mysql:t execute failed: Table 'koha.zebraqueue' doesn't exist at /home/koha/bin/ line 124
13:31 oleonard saa: That means your Koha database wasn't created properly
13:31 mtompset Did you do the web installer steps?
13:32 magnuse kf: cause i go out of my way to hide them? ;-)
13:33 mtompset If you did the web installer steps, it should create all the tables necessary. And if it didn't then there is something wrong with your koha database.
13:34 saa but it didnt give any error while web installer is ran
13:34 magnuse kf try googling for: koha-devel Global Bug Squashing Day
13:34 mtompset Then your koha database's tables are messed up.
13:35 saa i just ran web installer step by step
13:35 saa what could go wrong
13:35 mtompset Did you have tables in your koha database before you ran the web installer?
13:35 saa no
13:35 mtompset Is your koha database called koha?
13:35 saa just blank koha database is created with providing permissions
13:36 saa yes koha database kohaadmin user
13:36 kf hm
13:36 mtompset All the defaults...
13:36 kf when I write friday that's wrong - right
13:36 kf ?
13:36 kf because it's not friday everywhere?
13:36 mtompset friday
13:36 kf or is it?
13:36 kf oh it is
13:36 mtompset Friday?
13:36 wahanui Friday is probably It's Friday, Friday Gotta get down on Friday
13:36 kf i hate timezones
13:36 saa yes
13:37 saa DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /home/koha/bin/ line 125.
13:38 oleonard kf: For reference, magnuse did state a day of the week in previous announcements even if it isn't entirely accurate for everyone
13:38 saa last line of zebraqueue log
13:38 magnuse kf, oleonard: it is friday, wherever you happen to be, that's why it is effectively 48 hours, not 24
13:39 vfernandes joined #koha
13:39 vfernandes hi guys
13:39 oleonard There you go kf. Thanks magnuse of course you're right
13:39 mtompset blank db... ran webinstaller... no errors... zebraqueue error?
13:39 vfernandes i'm having a little problem with one of mine Koha installation
13:39 magnuse kf, oleonard: "The 24 hours of Friday September 14th 2012, in whatever time zone you are in." :-)
13:40 mtompset "The 48 hours of Friday September 14th, 2012, of whatever time zone you wish." ;)
13:40 vfernandes the overdue notices are not being sent to the user/patron... instead of that is being build a multipart on the database and are sent to root@localhost
13:41 mtompset Sorry, saa... I can't see how that logically could happen.
13:42 saa ok
13:43 magnuse kf: more than ok! :-)
13:43 oleonard kf++
13:43 kf oleonard: I take your ++ that I didn't make any embarassing typos? :)
13:44 oleonard Looks good to me kf
13:45 kf koha and koha-devel?
13:45 mtompset The end time needs 5 more minutes. ;)
13:46 mtompset Well... 4:59.999999 ;)
13:46 mtompset But that's the wiki.
13:48 magnuse kf: that's what i have usually done
13:48 kf it's done
13:48 vfernandes no one can help me?
13:48 magnuse kf++
13:49 kf yay
13:49 kf now I got the karma :)
13:49 kf @karma kf
13:49 huginn kf: Karma for "kf" has been increased 202 times and decreased 0 times for a total karma of 202.
13:49 oleonard vfernandes: Do you have the  AutoEmailPrimaryAddress system preference set to something other than "first valid?"
13:50 mtompset @karma mtompset
13:50 huginn mtompset: Karma for "mtompset" has been increased 20 times and decreased 1 time for a total karma of 19.
13:50 kf eek
13:50 mtompset Wow, I suck.
13:50 magnuse @karma cait
13:50 huginn magnuse: Karma for "cait" has been increased 318 times and decreased 1 time for a total karma of 317.
13:50 kf almost edited the template
13:51 maximep joined #koha
13:51 mtompset @karma mbalmer
13:51 huginn mtompset: Karma for "mbalmer" has been increased 9 times and decreased 0 times for a total karma of 9.
13:51 wajasu vfernandes: i believe that when a patron does not have an email configured, the overdue notices are batched up and sent tot he syspref KohaAdminEmailAddress.  root@localhost is the default KohaAdminEmailAddress.  See if that patron has an email address configured.
13:51 mtompset mbalmer++ # for making me feel better.
13:51 kf mtompset: I have been around for a while
13:51 wizzyrea actually that address is configured in the sysprefs
13:51 magnuse kf: the template is there to be edited, so we can improve it from one gbsd to the next :-)
13:51 wizzyrea er sorry library definitions
13:51 wizzyrea admin -> library and branches
13:51 Oak kf++
13:52 kf magnuse: I wanted to add a not about the bugs and dates in the rlelease newsletter
13:52 kf and I seem to not beig able to do it
13:52 kf help?
13:52 wahanui help is at if no-one here can help.
13:52 kf hm thx wahanui
13:52 wahanui yw
13:52 magnuse hm, click the edit tab on top of the page, not the links "inside" the page?
13:52 kf oooh
13:52 kf ok
13:52 wizzyrea what are you trying to do
13:52 magnuse first question?
13:52 wahanui "What are you trying to do?"  "What is the goal?" or "What problem are you experiencing?"
13:53 julian_m_ joined #koha
13:53 kf wizzyrea: I am trying to add '''Deadlines for the 3.10 release and an (incomplete) list of bugs and patches that will be affected by that can be found in the [[…]etter-10-2012-08/ monthly RM newsletter]!'''
13:53 kf as an additional note under the headline What
13:53 * mtompset has a musical flashback, "Help! I need somebody. Help! Not just anybody. Help!" ;)
13:53 reiveune joined #koha
13:53 * kf gives up
13:54 wizzyrea kf are you logged in?
13:54 Oak take a deep breath kf ans try again
13:54 oleonard Whoa:[…]bin/
13:54 kf I edited the template - magnuse will repair it maybe... :)
13:54 magnuse kf: yeah, you can't put things inside the template text without changing the template. just put it above the template?
13:54 wizzyrea wtf are you guys doing lol.
13:54 kf editing the wiki :)
13:55 wizzyrea lol ok
13:55 alex_a joined #koha
13:55 magnuse oleonard: yeah, there is some squashing to be done!
13:55 oleonard magnuse: I'm surprised. It was as low as 62 last week I thought
13:56 mtompset Wednesday Thursday Friday, wizzyrea? ;)
13:56 * Oak will tell someone wizzyrea used the f word... :)
13:57 vfernandes wajasu
13:57 vfernandes thats correct
13:57 mtompset Greetings, Oak.
13:57 Oak hello mtompset :)
13:57 vfernandes i thought that koha look for the valid email (work or home) bu always tries to sent to the home email
14:04 wajasu vfernandes: well, maybe a note in the documentation might be in order if it doesn't say so already.  there are many other notices, and supporting secondary or tertiary email addresses might be a lot to test.
14:06 wajasu vfernandes: i only know about this because i worked on bug 8378 and hope it goes out for our future release
14:06 huginn Bug[…]w_bug.cgi?id=8378 critical, P5 - low, ---, koha-bugs, Signed Off , <fine> syntax not working on overdues anymore
14:06 paul_p joined #koha
14:07 rambutan joined #koha
14:07 libsysguy joined #koha
14:08 * magnuse wanders off
14:08 sophie_m joined #koha
14:09 kf hi paul_p
14:09 Oak wb paul_p
14:10 kf hi sophie_m :)
14:11 paul_p (was not afk, it's just my SDSL that's still crazy...)
14:11 paul_p (at a meeting)
14:27 oleonard The "suspension in days" feature is what sets a date in the debarred field, correct?
14:29 kf hm I think you can also set it manually
14:29 kf but it should be that
14:30 jcamins oleonard: I thought suspension in days was supposed to do that but didn't.
14:35 sophie_m hi kf : we are regularly disconnected here :/
14:40 kf sophie_m: :(
14:40 julian_m_ joined #koha
14:53 tcohen hi #koha, a question on 110$t
14:53 tcohen is there a rule for when that the ocurrence of $t is valid?=
14:54 tcohen indicators, presence of other subfield than $a, etc?
14:54 Barrc another silly git it the norm to clone the repo to a new working dir for each patch? That is, suppose I clone the repo - work on a small patch then want to move to another patch?
14:54 jcamins No. Not at all.
14:55 jcamins tcohen: $t should not be used on 1xx fields in MARC21.
14:55 jcamins It can only be used in 6xx and 7xx.
14:55 oleonard Barrc: Do you mean clone a new repo or create a new branch?
14:55 jcamins Barrc: you create a new *branch* for each bug you want to test.
14:55 jcamins git?
14:55 wahanui git is[…]Control_Using_Git
14:56 jcamins ^^ that page explains branch creation, I think.
14:56 Barrc oleonard: That's my query I suppose (I have looked at the wiki). Support I create a branch, then do some work. The files here are modified......
14:57 jcamins Barrc: you commit your changed files to your branch. Then you have the commit saved, and can switch to a new branch to do something else.
14:57 tcohen jcamins: found an example of its usage here
14:57 Barrc So, when I switch to another branch, the modified files get reverted to the original ones?
14:57 oleonard Barrc: If you type "git branch" does it list only "master" ?
14:57 jcamins Barrc: no, you can't switch branches unless you commit your changes.
14:58 Barrc oleonard: No, I have master and the branch I made to work on
14:58 jcamins tcohen: that's odd. I was always told that $t couldn't be used in 1xx.
14:58 Barrc I am finished with that now and would like to move on to something else!
14:58 oleonard Barrc: That's good. You shouldn't commit your changes to your master branch
14:58 Barrc I think I have!
14:58 Barrc git log seems to show it
14:58 oleonard Barrc: So commit your changes to your custom branch and create a new one based on master
14:58 oleonard Oh, commits in master.
14:59 jcamins This is why I don't have a master branch.
14:59 jcamins It's impossible to inadvertantly commit to it.
15:00 oleonard Barrc: Check out master, then create a new branch without specifying what it's based on.
15:00 oleonard The new branch should have the changes you made to master.
15:00 oleonard Then you can check out master again and "git reset --hard origin"
15:01 Barrc ah - cool. So, the reset will get me back to the original files. Then in future, do you recommend not committing to master, is that the preferred method?
15:01 oleonard Right, do not commit when you're in the master branch
15:01 oleonard If you want to have a master branch you should keep it clean
15:02 oleonard ...just like they told you in 6th grade. Zing!
15:03 Barrc oleonard: thanks!
15:05 reiveune bye
15:05 reiveune left #koha
15:11 Barrc One more question! If you don't commit to master how can you see the change on the dev install of Koha? If you know what I mean!?
15:12 oleonard Barrc: Whatever branch is checked out is the branch your Koha installation is running off of
15:13 jcamins Barrc: you check out the branch you want to use.
15:13 mtompset Greetings, oleonard, jcamins, and tcohen.
15:13 tcohen hi mtompset
15:16 asaurat left #koha
15:24 bag good morning
15:29 Barrc So, sorry for the struggle here....but - I preform a git clone. I now have a clone directory of the repository. Do I run a dev install off this?
15:29 mtompset YES.
15:29 Barrc or do I create a working branch first?
15:29 mtompset well, branch first.
15:29 mtompset Hmm... either?
15:29 wahanui either is, like, fine
15:29 mtompset Some one else?
15:30 wizzyrea I don't think there's a "best practice" for that
15:30 wizzyrea certainly if you are writing code, it's better to be on a branch.
15:30 wizzyrea but if you just want to run koha off of a git clone
15:30 wizzyrea I don't think you need a branch
15:31 * mtompset nods.
15:31 mtompset I'd go with that. :)
15:31 jcamins Barrc: here's how I do it: git clone. Run through the install. Decide to develop things. Check out a new branch based on origin/master, and delete my master branch.
15:31 wizzyrea ^^ I was about to type this exact thing
15:31 wizzyrea though I usually leave my master alone.
15:31 mtompset that way you don't get confused over "master". :)
15:31 jcamins Right.
15:32 mtompset Actually, for 3.6.x and 3.8.x, I did what jcamins said.
15:32 Barrc jcamins: Excellent. So, say I do just that, and have a branch called "Bar".
15:32 jcamins And I have a git shortcut for checking out current master: git com = git checkout origin/master
15:32 mtompset Just so that I knew which one it was. ;)
15:32 wizzyrea ^^ I do this too
15:39 logbot joined #koha
15:39 Topic for #koha is now  Welcome to #koha this channel is for discussion of the Koha project and software The Next General Meeting is 10 October 2012 at 10:00 UTC+0
15:40 drojf kf: i would assume that those who are really interested in koha have specific questions for us later and the rest will just listen to that
15:40 drojf no idea how many people will really be interested in koha though
15:40 wajasu i set suggest on in admin, and i can type whatever, and always get no results.  though my arizona results are findable.  i'm grabbing lunch, will check in later to see if you have time.
15:40 kf if there are a few really interested peopel that's ok :)
15:41 drojf yup. and if nobody cares we are close to the food :D
15:42 jcamins wajasu: I won't have any time today, but if you put a note of what queries you're trying, and what authority records they should match, I'll see what I can see.
15:42 kf lol
15:43 jcamins wajasu: oh, wait, you mean suggestions in the staff client? They weren't added yet.
15:43 wajasu jcamins:  i just searched for "bacon" and i really only have the geonames in the db from testing 8211, so i got no results with no visible suggestions.  IN OPAC
15:43 jcamins Ah, of course.
15:44 jcamins You'll only get suggestions if you search for Arizona, Phoenix, United, or States.
15:44 * jcamins should have specified "you should have multiple authority records" in the test plan.
15:45 jcamins What I'd do is turn on "BiblioAddsAuthorities" and AutoCreateAuthorities, and catalog a bunch of things.
15:45 oleonard wajasu++ # for testing
15:45 rambutan joined #koha
15:45 wajasu searching for Arizona gave me all the results from the 8211 geoname heirarchy.   do i need to add more authority records with Arizona subject heading that aren't part of that heirarchy?
15:46 wajasu ok. ill try adding some
15:46 oleonard I think anyone who is tired of waiting for a signoff should lead a testing walkthrough on GBSD. Maybe even set up a schedule.
15:46 jcamins oleonard: intriguing idea.
15:46 jcamins wajasu: I tend to forget that most people don't have 40k+ authorities sitting around for testing purposes.
15:47 oleonard Who has two thumbs and doesn't have 40k+ authorities sitting around for testing purposes?
15:47 oleonard This guy.
15:47 mtompset 40k+ AUTHORITIES?!
15:47 wajasu can i borrows your 40k+ for a moment? :)
15:48 wajasu i don't have time to key them in.
15:48 jcamins wajasu: Sure, but uploading might take a bit.
15:48 jcamins wajasu: how about I give you 10k?
15:48 mtompset Suddenly 428 authorities looks like piddly squat.
15:48 jcamins Faster to upload.
15:49 jcamins Actually, here's a smaller set.
15:49 jcamins 3500.
15:49 wajasu nice.
15:50 jcamins I don't know quite where I got this set from, but that's okay.
15:50 mtompset Okay. Dumb library question... what is an authority? and how does that relate to a bibliographic record? Be easy. I'm not a librarian.
15:51 jcamins I thought I had only 3500?
15:51 wizzyrea dumb question?
15:51 wahanui there are no dumb questions.
15:51 mtompset Well, I'm showing my library ignorance.
15:51 mtompset So I feel dumb.
15:51 wizzyrea feeling dumb is different from being dumb. ;)
15:51 mtompset thankfully!
15:51 jcamins Wait. Way to misread.
15:52 jcamins That's 350k
15:52 drojf kf: as you are an IT law expert… wouldn't it be appropriate for my university library to tell me in the imprint that they are loading things from amazon, and maybe also what these things are? not to speak of the implication that if would be logged in to amazon they'd probably know all my searches too?
15:52 wizzyrea feeling dumb?
15:52 wahanui feeling dumb is different from being dumb. ;)
15:52 wizzyrea yesssssss
15:54 wizzyrea oo[…]pr_09102012.shtml
15:55 * wizzyrea likes these librarything people.
15:55 jcamins Nifty.
15:55 kf drojf: yes
15:56 kf drojf: they would have to tell you and it should be opt in
15:56 kf or they would have to tell you before it's too late
15:56 kf that is what I was told... but it's not easy to do :(
15:56 drojf kf: i have just seen it now, i don't know what it does. they tell me about "addthis" in the imprint, but not about amazon, bibtip and google
15:56 wajasu got em
15:56 kf drojf: and I may be wrong too, because I am not really an expert, but we have been discussing that here
15:57 drojf maybe it's really new. i think i'll try to write them a friendly email about it. when i feel friendlier about it ;)
15:58 jcamins wajasu: I don't really know what authorities are in that, so you'll want to take a peek at your authority list to figure out what you might get suggestions on.
15:58 jcamins (and note that none of the authorities will be linked, so following the suggestions won't return any results)
16:00 kf time to leave here :) bye all :)
16:01 jcamins Also note that there are no crazy GND or otherwise German authorities in there.
16:01 kf :P
16:01 wajasu for my understanding.  what triggers suggestions?  what would i need to add to get suggestions to popup.  just an authority with a subject heading with Arizona? (but not linked)
16:01 wajasu search comes back with Konstanz over and over.
16:01 jcamins wajasu: it depends which suggestion plugin you activated.
16:01 wajasu just kidding :)
16:01 drojf lol
16:02 * jcamins wasn't amused.
16:02 * jcamins was horrified. :P
16:02 kf lol
16:02 jcamins (for those who don't know, I was battling a Konstanz authority record for four hours yesterday)
16:02 kf and it led to improvement :P
16:02 jcamins It did.
16:03 trea joined #koha
16:03 drojf so more konstanz, more improvement
16:03 drojf ;)
16:03 kf yay
16:03 wajasu which suggestion plugin. must if active a specific one?
16:03 melia joined #koha
16:03 jcamins wajasu: you have to choose which one you're interested in using.
16:04 jcamins In the "Did you mean?" configuration screen.
16:05 wajasu does that popup? or is it an patron profileish thing?
16:05 jcamins What do you mean?
16:05 jcamins Go to the administration section.
16:05 wajasu where is the did you mean config screen?
16:05 jcamins At the end there's a "Did you mean?" configuration thing.
16:05 wajasu i only det admin syspref.
16:06 jcamins Oh, in that case the patch isn't applied.
16:06 jcamins It sounds like you have 8209, but not 8723.
16:07 wajasu 8726
16:07 jcamins Sorry.
16:07 * jcamins was working on 8523 yesterday.
16:07 kf now really gone :)
16:07 wajasu my git log shows 8726 applied.
16:08 jcamins And you don't see Did you mean? at the end?
16:08 * jcamins will post a screenshot.
16:08 jcamins (that's fast)
16:08 wajasu i found it
16:09 wajasu i thought you only ment the syspref
16:09 wajasu i can't spell today.
16:10 wajasu its showing up now.
16:10 jcamins Ah. No, sorry.
16:10 wajasu its works YAY!!!!
16:10 jcamins That config screen is the best part! :D
16:14 wajasu I like it.  when i do related terms search my search text field has   su-rl=Arizona  instead of su-rl:Arizona    Are they equivalent?
16:14 jcamins Yes. = is actually preferable to : with our current query parser.
16:18 laurence left #koha
16:18 Barrc left #koha
16:21 jcamins wajasu: with a new QueryParser we'll switch to : instead of =, but in my opinion it's better to have the most-functional behavior *now*, and it's easy to change later.
16:22 gaetan_B bye
16:25 wajasu can you describe what needs to be added to get a result from an authority file plugin (w/o 10Kauths) ?
16:25 wajasu i like the drag and drop plugin order :)
16:26 jcamins wajasu: yeah, it's easy. Just link an authority to a bib record. :)
16:27 jcamins (then do a search for a term that appears in the authority, and it'll say 'Did you mean "Smith, John"' and when you click on Smith, John you'll get a list of books by/about him.
16:28 jcamins For example, if you have an authority record for Puff Daddy, you could search for one of his other names, and follow a suggestion to get to his biography.
16:28 jcamins (note: I don't know what his actual name is, just that it changed a lot)
16:28 jcamins (I also don't know if anyone has written a biography of him)
16:29 jcamins (also, I'm not 100% sure that I'm gendering Puff Daddy correctly, but it seems to me that "Daddy" implies masculine gender)
16:29 jcamins (P.S. I think s/he's an a musician or actor)
16:30 wizzyrea you got it right.  :)
16:32 wajasu i thought if I searched for  "Arizona"   and click the authority file link, i might be able to get some other biblio linked. but i wondered if i link with some topical term, the general keyword search will it pick up.
16:34 jcamins wajasu: this is most useful for names, really.
16:34 jcamins Puff Daddy used to be P. Diddy. If you searched for "P Diddy" in the catalog, you probably wouldn't find his biography, because he's now "Puff Daddy."
16:34 jcamins However, the suggestion plugin would suggest "Puff Daddy" from a search for "P Diddy."
16:35 wajasu does he have a holographic manifestation available yet?
16:35 wizzyrea that's tupac :P
16:35 wizzyrea I think.
16:35 wajasu right.
16:35 wizzyrea didn't p diddy just change his name again?
16:35 jcamins Hehe. I know that Tupac is a rapper.
16:36 jcamins wizzyrea: I don't know. Probably is an unpronounceable symbol.
16:36 * wizzyrea giggles
16:36 jcamins That seems to be the way people are going these days.
16:36 wizzyrea no… who was it that just changed their name to become a reggae artist….
16:37 wizzyrea it was a rapper...
16:37 wizzyrea OH
16:37 wizzyrea i
16:37 wizzyrea it was Snoop Dogg
16:37 wizzyrea he is now Snoop Lion
16:37 wizzyrea no, i'm totally not kidding
16:37 wizzyrea an
16:37 wizzyrea d I don't even follow this stuff really.
16:37 jcamins Seriously?
16:37 wizzyrea seriously
16:37 jcamins I'm glad I wasn't taking a drink, because that did in fact make me laugh.
16:37 wizzyrea :D
16:38 oleonard Snoop should upgrade to Mountain Lion.
16:38 * wizzyrea giggles
16:38 wizzyrea all I googled was "changed name reggae"
16:39 wizzyrea you would think there would be more than one of these, but every hit was "snoop dogg changes name to snoop lion"
16:39 jcamins wizzyrea: probably because it's just so absurd.
16:39 wizzyrea yes, it's utterly absurd.
16:39 tcohen is it possible that Koha has problems retreiving CHRON_TERM authorities?
16:40 oleonard Sorry tcohen we're only talking about rappers now
16:40 oleonard ;)
16:40 jcamins tcohen: probable, in fact.
16:40 wizzyrea and Reggae artists :P
16:41 tcohen You didn't read my question well, I actually asked if you have heard Cunninlynguists?
16:42 jcamins lol
16:44 tcohen If I was listening some old beastie boys tapes, and wanted to ask zebra for some CHRON_TERM using yaz, how would I do it?
16:44 jcamins tcohen++ # awesome!
16:45 jcamins @attr 1=Chronological-term "term"
16:45 huginn jcamins: I've exhausted my database of quotes
16:46 jcamins Alternatively, @and @attr 1=authtype "CHRON_TERM" @attr 1=Heading-Main "term"
16:47 jcamins drojf: in a German library catalog, what would "[3] Bl." mean?
16:47 wajasu i'm signing off on this 8726. after lunch.  superb work jcamins!!!   I'm going to bea able to create some nice heirarchies.
16:47 jcamins Thanks!
16:47 wajasu maybe the tag cloud stuff can use the subject heirarchies
16:48 jcamins wajasu: oooh. That'd be very cool.
16:48 * jcamins had never thought of that.
16:48 jcamins wajasu++
16:48 drojf jcamins: do you have a full example?
16:49 wajasu i'd put it onthe front page.  it would describe our library.
16:49 jcamins drojf:
16:50 drojf wajasu: the tag cloud uses only one subfield at the moment AFAIR so that would need some tuning
16:50 jcamins drojf: the tag cloud uses tags, so a script could easily be written to extract authority things.
16:51 drojf jcamins: that might mean "Blatt" (sheets of paper)
16:51 wajasu i also thought it might be cool that as you were cataloging a biblio, on the right side margin, possibly related authority records could appear using ajax.
16:52 jcamins drojf: thanks!
16:52 drojf jcamins: it seems to be some kind of advertisement
16:52 jcamins wajasu: yeah, the cataloging module desperately needs an overhaul.
16:52 jcamins drojf: yup. It's a prospectus. Pretty cool.
16:53 jcamins If you're the type of person who likes prospecti.
16:53 * wajasu lunch, then signoff
16:53 mveron joined #koha
17:04 ala_3vo joined #koha
17:16 ala joined #koha
17:17 ala Hello #koha
17:17 ala_3vo joined #koha
17:18 ala_3vo Hello #Koha
17:18 drojf hello ala_3vo
17:19 ala_3vo Hi there drojf
17:21 ala_3vo I have just attended a Koha workshop conducted by USP and SPC yesterday. Good for a start in the Pacific
17:23 cait joined #koha
17:26 drojf yeah for koha world domination ;)
17:27 * drojf goes home to his 17000k light
17:27 cait oh, what did I miss?
17:27 jcamins 17000k light?
17:27 cait don't tell me you plotted out world domination witout me?
17:27 drojf cait: (19:17:47) ala_3vo: I have just attended a Koha workshop conducted by USP and SPC yesterday. Good for a start in the Pacific
17:28 drojf jcamins: lots of blue, makes me awake. getting dark here
17:28 cait yeah here too...
17:28 * cait tries to find something for dinner
17:28 jcamins drojf: I thought blue was to put you to sleep?
17:28 drojf maybe i should hide one of the lamps in the library
17:29 drojf jcamins: not really :)
17:29 Oak joined #koha
17:31 talljoy1 joined #koha
17:32 Shane-S joined #koha
17:33 talljoy1 left #koha
17:34 talljoy1 joined #koha
17:34 Shane-S Anyone know of an easy way to group patrons and do a barcode/name page of them. We are a school and would to group kids easily by primary teacher name. Right now I have to manually add them all into a batch per teacher
17:34 Shane-S and I can't name the batch so I have to keep it written down like batch 4 is for Jane Doe's homeroom
17:35 jcamins Shane-S: I might.
17:36 jcamins I don't know how to do it using the barcode tool, but I've used reports to print out barcode sheets.
17:36 jcamins Save it as a CSV, then change the font for the barcode column.
17:37 jcamins That may or may not be in any way useful to you.
17:37 trea-lunch left #koha
17:40 tcohen jcamins, how do I connect to a local zebra server trough a socket? (it IS listening in a socket, right? which is it as default?)
17:41 jcamins tcohen: it is listening through a socket, but yaz's documentation is wrong.
17:41 jcamins Let me find it.
17:41 tcohen authoritysocket
17:41 tcohen /var/run/koha/zebradb
17:41 jcamins yaz-client unix:///home/jcamins/koha-dev/v​ar/run/zebradb/authoritysocket -c ~/koha-dev/etc/zebradb/
17:42 tcohen thanks!
17:42 jcamins (replacing the paths with ones appropriate for your installation, of course)
17:43 tcohen hmmmmmmmmm
17:44 tcohen Number of hits: 0
17:45 jcamins Hm.
17:46 jcamins Try the second search I suggested.
17:46 * jcamins doesn't use CHRON_TERM (full disclosure)
17:46 tcohen they're not being indexed I guess, or wrong index
17:47 jcamins That was the reason for the secord search. :)
17:50 tcohen both return 0 hits
17:51 jcamins Okay, take out the @and @attr 1=authtype
17:52 tcohen find @attr 1=Heading-Main "Na"
17:52 tcohen Number of hits: 1
17:52 tcohen find @and @attr 1=authtype "CHRON_TERM" @attr 1=Heading-Main "Na"
17:53 tcohen Number of hits: 0
17:53 wajasu rangi: i had to retest/SIGNOFF 8209 though it passed QA.  i can't change status to SIGNED-OFF from PASSED-QA.
17:55 jcamins wajasu: right, it already passed QA.
17:55 jcamins No need to sign off.
17:56 Shane-S jcamins: alright, now I just need to get a barcode font on my librarian's system :P
17:57 tcohen jcamins, what do I need to add to a query to get the actual results?
17:59 jcamins tcohen: Let me check.
18:00 tcohen show
18:00 jcamins Yes. :)
18:00 ala_3vo joined #koha
18:01 mbalmer joined #koha
18:01 tcohen oops
18:01 tcohen no 148 on record.abs
18:02 jcamins Oh.
18:02 jcamins That explains it.
18:02 jcamins But you should be using DOM.
18:02 jcamins koha-authority-indexdefs.xml
18:02 tcohen i didn't because I was getting some weird error
18:02 tcohen when indexing
18:02 tcohen guess I'll have to give it a try
18:02 tcohen (again)
18:02 jcamins Ah. You're going to run into all sorts of trouble with authorities.
18:02 jcamins (not using DOM)
18:03 jcamins The error was with bibliographic records, yes?
18:03 mbalmer dpavlin_ , ayt?
18:03 jcamins The 148 probably isn't indexed with DOM either.
18:03 tcohen we weren't able to search for chronological terms
18:03 jcamins tcohen: yes, that's because you just determined it isn't indexed.
18:03 jcamins I meant the weird error was with bibs indexed as DOM.
18:04 tcohen yeah, I meant that this was the only problem we've got yet
18:04 tcohen ohhh
18:04 tcohen is there a path for migrating from GRS-1 to DOM?
18:05 jcamins Run Makefile.PL with the --prev-install-log option.
18:06 tcohen that will set everything to point koha to use dom
18:06 jcamins tcohen: no,  you'll have to choose DOM.
18:07 tcohen i remember changing in koha-conf.xml some entries to point to -dom files
18:07 jcamins Oh, you could do that too.
18:08 tcohen i'll follow your advise on a test install and try to reindex
18:08 tcohen i remember an error on smth about Bib-1 not defined...
18:09 mtompset Question... does libchi-perl not return a version number?
18:09 mtompset How do I manually check?
18:10 mtompset dpkg -l says I have it installed, but ./ -m -u says I have version 0*
18:13 mbalmer PostgreSQL 9.2 was released today.
18:14 tcohen is it worth a patch? (the addition of chronological terms indexing)
18:15 mbalmer left #koha
18:16 oleonard This concludes the Postgres non-sequitor portion of our broadcast
18:19 tcohen jcamins, it worked! (grs-1 chronological terms indexing
18:19 rambutan joined #koha
18:20 oleonard Okay, relevant to Bug 7067: Is there any good reason the process_message_queue cron can't be run every minute?
18:20 huginn Bug[…]w_bug.cgi?id=7067 enhancement, P5 - low, ---, kyle.m.hall, Needs Signoff , allow patron self registration via the opac
18:26 chris_n joined #koha
18:26 alex_a joined #koha
18:27 jcamins tcohen: yes, definitely worth a patch.
18:28 tcohen 148 appears to be indexed in DOM (according to authority-koha-indexdefs.xml)
18:28 gmcharlt oleonard: I'd want a lockfile to make sure that multiple runs don't occur simultaneously, but other than that, no reason not to run it as frequently as once a minute
18:28 jcamins tcohen: excellent!
18:29 oleonard gmcharlt: Is the lockfile something that needs to be added by the patch?
18:30 gmcharlt oleonard: yeah, I'd say so
18:30 gmcharlt I'll add a comment to the bug
18:32 jcamins cait: does "wie" in German mean something closer to "while," "because," or "how"?
18:37 tcohen jcamins, done. Bug 8750
18:37 huginn Bug[…]w_bug.cgi?id=8750 enhancement, P5 - low, ---, gmcharlt, Needs Signoff , Chronological terms authorities not correctly indexed
18:37 jcamins tcohen++
18:42 * mtompset dislikes libchi-perl.
18:43 jcamins mtompset: you don't have to use it. It's optional.
18:43 mtompset I determined I had to install Log::Any and Moose to get CHI to return a version number.
18:43 jcamins mtompset: ew, and now you're going to have it loading Moose.
18:44 * jcamins uses Moose-less CHI.
18:44 mtompset Well, it wouldn't tell me a version number otherwise.
18:45 YoungPublicLibrarian joined #koha
18:45 * jcamins can think of worse things.
18:45 cait hi YoungPublicLibrarian
18:45 YoungPublicLibrarian Hello everyone!
18:45 jcamins Such as loading Moose when it's not necessary. ;)
18:45 mtompset Yes, but if it doesn't tell me a version number, what else may break?
18:46 jcamins mtompset: nothing.
18:46 jcamins It's optional, and I developed it without installing Moose.
18:46 mtompset You wrote CHI?
18:46 jcamins No.
18:46 jcamins I wrote Koha's drivers for it.
18:46 mtompset Ah.
18:48 mtompset I also had to install 4 other libraries after convincing CHI to return a version number to convince CHI::Driver::Memcached to return a version number.
18:50 * jcamins refers to his above statement regarding Moose.
18:51 jcamins Of course, if you're using Plack it's worth setting up Moose.
18:51 cait YoungPublicLibrarian: still around?
18:51 mtompset Hash::MoreUtils, Carp::Assert, Data::UUID, Time::Duration::Parse
18:51 cait mtompset, jcamins: I think you scare people away :)
18:51 YoungPublicLibrarian Current problem: I am trying to create a report that will return results showing all of one particular libraries patrons who have fines with a total over a certain amount. I need the report to show each fine as well as the sum of the patron's fines. Anyone have any ideas?
18:52 mtompset Sorry, cait. Sorry, YoungPublicLibrarian. :)
18:52 YoungPublicLibrarian No worries
18:52 jcamins YoungPublicLibrarian: I have good news and bad news. The good news: you have a very good question. The bad news: I don't have an easy answer.
18:52 cait hmm
18:52 tcohen jcamins, leaving now, thanks for your advise
18:52 cait I have done something similar for one of our libraries
18:52 cait give me a second to see if I can access the report
18:52 mtompset Bye, tcohen
18:52 tcohen (happy librarians @ UNC)
18:53 jcamins Yay!
18:54 YoungPublicLibrarian I have a report already created, but for some reason it only shows some of each patron's fines, instead of all of the fines. I've been tryign to figure out why this would be, but have come to no conclusions yet...
18:55 cait
18:55 cait that#s my report - maybe you can modify it
18:55 cait you could change the amount for example
18:55 wajasu jcamins: 8743 sha1 information is lacking or useless (C4/
18:56 jcamins bug 8743
18:56 huginn Bug[…]w_bug.cgi?id=8743 critical, P3, ---, jcamins, Needs Signoff , ZOOM error when merging authority change to biblios
18:56 jcamins Oy.
18:56 jcamins Lemme rebase.
18:56 wajasu ok
18:56 jcamins wtf did I do to my repo, though?
18:56 jcamins wajasu: but wait, were you able to reproduce the bug?
18:57 jcamins Rebased.
18:57 YoungPublicLibrarian cait: the problem with that report is that it gives each accounts total instead of the total and each fine for the accounts. I'm working on modifying the report to fit my needs, unfortunately my knowledge of SQL is pretty basic...
18:57 cait hm not sure I get what you want to do
18:58 jcamins YoungPublicLibrarian: I'm not sure it's possible to do what you want, unfortunately.
18:58 wizzyrea YoungPublicLibrarian: that sounds like two different reports
18:58 cait I agree with wizzyrea
18:58 cait I think
18:58 jcamins That's how I did a similar thing.
18:58 cait if I understand it correctly :)
18:58 wizzyrea you want to show each patron's outstanding fines, and the total fine for each patron
18:58 jcamins You might be able to do a subquery, but it wouldn't be nice.
18:58 wajasu i looked for the error you mentioned.  nothing in UI.  i saw "[warn] Missing attribute 'type' in attribute info" on stdout when i ran rebuild-zebra though. i also checked my biblio and the linked authority field had not changed.
18:59 wizzyrea you can do both of those things, but not in the same report (at least not as I'm currently conceiving of it)
18:59 jcamins wajasu: in that case you can't test the patch. It appears only for a very limited number of people.
18:59 YoungPublicLibrarian Okay. I can understand that. Then what I would like is a report that shows each patron's fines when the patron is from a particular library. Let me post the report I'm using
18:59 jcamins wajasu: and it's pretty spectacular when it shows up.
18:59 wajasu it a UI error?
19:00 jcamins wajasu: you get a 500, an error in the log, and in certain circumstances your authority data is screwed up.
19:01 jcamins It happens 100% of the time or 0% of the time on any given installation, and I can't see any commonalities.
19:01 wajasu my biblio data wasn't updated.  i guess thats not enough.
19:01 pastebot "YoungPublicLibrarian" at pasted "Fines and Fees by Branchcode" (17 lines) at
19:01 jcamins No, it's a much more dramatic error.
19:01 jcamins :/
19:02 wajasu ok. i'll drop that one.
19:02 mbalmer joined #koha
19:02 cait mbalmer: am Donnerstag
19:02 YoungPublicLibrarian That's the report I'm using now. But like I said, it only shows maybe 3 out of 5 individual fines for a patron, instead of all 5 fines and I can't figure out why...
19:03 mbalmer cait, leckerli essen.. ? ;)
19:03 cait möglich
19:03 mbalmer haha....
19:03 wahanui haha is there already a branch for 3.6?
19:03 cait YoungPublicLibrarian: hm.
19:04 mbalmer moeglich. das will ich dann mal sehen...
19:04 cait I see that I worked with subqueries in sums in my report, but I am not sure why right now :)
19:04 cait do you want to have a sum, or repeated lines for each fine?
19:05 YoungPublicLibrarian I'm putting the results into an Access database to format into a letter I can send to the patron about their fines. So I want each fine they have to print out on a seperate line.
19:06 cait hm
19:06 cait I think there could be several reasons
19:06 cait deleted record
19:06 YoungPublicLibrarian In the report however, I would like to be able to limit the results to only patrons who have a total of fines over a certain amount. If possible...
19:06 cait deleted item
19:06 cait or something else... right now I am not sue
19:06 libsysguy joined #koha
19:06 cait you are pulling a lot of information together in that report
19:07 * mtompset waves, "Okay, bye, #koha."
19:08 YoungPublicLibrarian Yeah, which is probably why its giving me problems...
19:08 cait I think to try and get to the error
19:08 cait i would go back and simplyfy it
19:08 cait like try to get the acounts bit right with the borrowernumber and other information
19:08 cait and then go step by step
19:08 cait form there
19:11 YoungPublicLibrarian Hm...I'm not actually sure what you mean. Like I said my knowledge of SQL, and programming in general, is pretty limited...If it wasn't for the reports library I wouldn't even have gotten this far...
19:12 jcamins YoungPublicLibrarian: you'll be an expert before long. :)
19:13 YoungPublicLibrarian lol, yeah I've learned more about SQL and programing since we adopted Koha than I ever did in my college course I took on the subject!
19:13 cait :)
19:13 cait when you have use for the knowledge, that happens
19:13 cait :)
19:16 cait well.. I like stuff like that, might not be the same for everyone
19:17 cait the problem with helping you is that I don#t have a test base with good data I can access from here
19:17 cait and without checking what I do it's quite hard
19:20 tcohen jcamins: bug 8209, searches in 4xx fields?
19:20 huginn Bug[…]w_bug.cgi?id=8209 enhancement, P5 - low, ---, jcamins, Passed QA , "Did you mean?" suggestions based on authorities
19:20 jcamins tcohen: yes.
19:20 jcamins So does bug 7417.
19:20 huginn Bug[…]w_bug.cgi?id=7417 enhancement, P5 - low, ---, jcamins, Passed QA , Include alternate forms from authorities in bibliographic searches
19:20 jcamins Both have passed QA.
19:22 tcohen i've just marked bug 5705 as duplicate of 8209
19:22 huginn Bug[…]w_bug.cgi?id=5705 enhancement, P5 - low, ---, gmcharlt, RESOLVED DUPLICATE, search 4XX fields in authorities and link to 1XX
19:24 YoungPublicLibrarian joined #koha
19:24 YoungPublicLibrarian Sorry guys...I stepped away from the computer and someone closed my screen...
19:26 cait oh
19:26 cait I said that it's hard for me to help because I have no access to proper test data from home
19:26 cait so can't test
19:27 YoungPublicLibrarian Ah, I see. I can understand that. And its hard for me to test because the libraries in our consortium don't have the permissions to write, edit, and test reports...
19:31 YoungPublicLibrarian Okay, well I'm heading to lunch now. But I will be back later today to ask some more specific questions about the report and what each part of it mean
19:33 cait enjoy your lunch
19:34 rangi Morning
19:34 rangi And why not let them write reports?
19:35 YoungPublicLibrarian Consortium politics...only the "real" IT personnel get permissions to write reports...which is a pain!
19:35 mbalmer haha
19:35 YoungPublicLibrarian ok...I'm gone. Back soon! Thanks everyone!
19:36 cait good morning rangi )
19:41 rangi Politics .... Is there anything they can't ruin?
19:42 gmcharlt or a legitimate fear of 5-way Cartesian joins?
19:42 jcamins lol
19:42 rangi They'll only do that once
19:43 libsysguy mmm cross products are the best gmcharlt
19:43 libsysguy *disclaimer* best =~ best way to halt your database
19:44 gmcharlt heh
19:44 rangi I bet we could run explain first
19:45 libsysguy I read an interesting article yesterday[…]e-has-two-tables/
19:45 gmcharlt rangi: that would be better than nothing, though couldn't be definitive
19:45 rangi And say this is going to try to return millions of rows
19:45 rangi Yep
19:46 rangi Personally in my experience I trust IT ppl less than librarians
19:46 rangi I'd reverse the permissions :-)
19:49 wizzyrea hah
19:51 rangi @wunder nzwn
19:51 huginn rangi: The current temperature in Wellington, New Zealand is 11.0°C (7:00 AM NZST on September 11, 2012). Conditions: Partly Cloudy. Humidity: 44%. Dew Point: -1.0°C. Pressure: 29.62 in 1003 hPa (Steady).
19:51 cait @wunder Konstanz
19:51 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 17.7°C (9:45 PM CEST on September 10, 2012). Conditions: Clear. Humidity: 86%. Dew Point: 15.0°C. Pressure: 30.06 in 1018 hPa (Steady).
19:51 rangi I see no clouds but it is crisp
19:52 cait today was nice - sunny and warm
19:52 cait seems the weather here has finally forgiven robin for leaving
19:52 rangi Hehe
19:52 rambutan It's interesting to watch the QGIS people going through the same process, setting up tests, that Koha is at the same time. Strange correspondence
19:52 rangi He's in den haag now
19:53 cait ah
19:53 cait I was wondering
19:53 jcamins rambutan: I like QGIS.
19:53 jcamins My computer does not.
19:53 cait so on vacation now?
19:53 rambutan So jcamins, why does your computer not like QGIS?
19:54 jcamins rambutan: I think something to do with the amount of data contained in a map of Saint Petersburg.
19:54 rangi Semi vacation
19:55 jcamins It goes urrrrrrrrkkkkkkk and the cursor starts jumping.
19:55 jcamins :)
19:55 rambutan ah. ic. yea, that's a problem.
19:56 chris_n` joined #koha
19:58 cait jcamins: tell me to continue testing :)
19:58 jcamins cait: continue testing.
19:58 jcamins You're close to done on bug 8523.
19:58 huginn Bug[…]w_bug.cgi?id=8523 enhancement, P5 - low, ---, jcamins, Needs Signoff , Authority hierarchies only support UNIMARC
19:59 cait you have to work on your serious face
19:59 chris_n` joined #koha
20:02 chris_n` joined #koha
20:04 rangi Bbiab
20:10 kathryn joined #koha
20:13 wajasu joined #koha
20:13 kathryn morning all :)
20:14 cait morning kathryn
20:14 kathryn hiya cait!
20:17 cait :)
20:23 rangi back
20:30 tcohen joined #koha
20:44 rangi oh bug squash day on friday
20:48 cait yep
20:48 cait and I have a long train ride on friday in a nice train with power supply
20:49 rangi excellent
20:53 gaetan_B joined #koha
20:54 rambutan cait: are you going to the QGIS conference in Kassel?[…]assel-092012.html
20:54 nengard left #koha
21:16 bag oh nice bug squashing day coming :)
21:37 rambutan joined #koha
21:39 rambutan left #koha
21:59 edveal left #koha
22:00 maximep left #koha
22:07 wajasu i can't believe i finally got bug 8215 tested
22:07 huginn Bug[…]w_bug.cgi?id=8215 enhancement, P5 - low, ---, kyle, Signed Off , Add Course Reserves
22:07 bag nice wajasu
22:07 wajasu khall: congrats!!!
22:07 wajasu @later tell khall Congrats!!! on 8215
22:07 huginn wajasu: The operation succeeded.
22:09 wajasu bag: let me know if you have any specific bugs you really need tested and i'll try to work it.
22:10 bag ah I'm currently helping melia try and test some bugs from the needs_signoff
22:10 bag so nothing at the moment :)
22:10 wajasu ok.
22:11 * wajasu on break
22:17 tcohen joined #koha
22:21 jcamins_away OCLC's numbering scheme has once again proven to be too short-sighted.
22:22 rangi run out of digits?
22:22 jcamins_away Yup.
22:22 jcamins_away Again.
22:22 rangi eggs
22:22 jcamins_away After, what, two years?
22:22 wajasu 13 not enough
22:23 jcamins_away wajasu: 9.
22:23 jcamins_away 9 wasn't enough.
22:23 wajasu we should use ipv6 addresses
22:23 jcamins Now they finally realized that they can't keep on zero-padding their numbers.
22:24 rangi heh
22:25 * jcamins is now entirely vindicated in his argument that GRS-1 needs to be gone in a year.
22:26 jcamins Matching on OCLC numbers will break again.
22:28 rangi right
22:38 rangi heh
22:39 wajasu wow! that was quick. got mine already.
22:39 jcamins lol
22:41 rangi now you can waste some money on a domain
22:42 jcamins
22:42 jcamins Someone's selling subdomains and making money?
22:42 rangi no thats a 2ld
22:42 rangi just came into being
22:43 rangi
22:43 rangi check the drop down, those are the domains you can get in .nz
22:43 * jcamins scratches his head.
22:43 jcamins Why?
22:43 jcamins I don't expect you to know the answer, of course.
22:44 jcamins Just... why?
22:44 jcamins Doesn't .nz pretty much communicate "kiwi"? :P
22:44 ibeardslee yeah .. the cynic in me agrees with that
22:44 ibeardslee it's pretty much going
22:44 rangi yep
22:44 rangi its money
22:44 rangi why do businesses do anything :)
22:45 * jcamins suggests as a good domain name.
22:45 jcamins Then you can name your servers after fruits.
22:45 ibeardslee
22:45 jcamins
22:45 rangi heh
22:45 jcamins It's for a New Zealand-themed smoothie company. :)
23:00 rangi melia++ #sign offs
23:00 melia aaww thanks :) bag helped me
23:00 bag ;)
23:01 idreambooks joined #koha
23:02 jcamins rangi: do I recall that Catalyst was going to be doing some work on call slip functionality?
23:03 jcamins Let me rephrase that.
23:03 jcamins Do I remember *correctly* that Catalyst is going to be doing some work on call slips?
23:03 rangi i dont think so
23:04 rangi at least i don't recall
23:04 jcamins Oh well.
23:04 jcamins You should. :)
23:06 rangi hehe
23:06 idreambooks hi guys...idreambooks guy here. i submitted a bug report as you guys suggested:[…]w_bug.cgi?id=8733
23:06 huginn Bug 8733: enhancement, P5 - low, ---, oleonard, NEW , Adding critic reviews to book pages
23:06 rangi yep saw that thanks
23:06 idreambooks we have a way to retrieve the readometer based on ISBN numbers now!
23:07 rangi excellent
23:07 idreambooks i was thinking we could dedicate resources for this implementation but would need help from you guys
23:07 papa joined #koha
23:08 idreambooks how long would it take for the changes to get approved after the patch has been sent?
23:09 rangi there is no set time
23:10 rangi[…]-get-into-master/
23:11 rangi hmm i bet i can do something with that api right now
23:11 rangi 2 secs
23:11 idreambooks "The average is 32.6686." is this days...33 days
23:11 rangi yep
23:11 rangi but averages are misleading
23:12 rangi median is the important number
23:12 idreambooks ah
23:12 rangi does it work with 10 digit isbn, or just 13 ones?
23:12 jcamins Also, something to keep in mind: that includes bugs and enhancements that may be used by only one library in the world, and therefore very hard to check.
23:12 jcamins And you have two factors in your favor:
23:13 jcamins 1) is very shiny, and shiny things are always a favorite for testing
23:13 jcamins 2) many of the people who do testing will test patches by new developers before testing other patches
23:16 idreambooks it is 13 ones i think...
23:16 rangi cool
23:16 idreambooks u need 10 ones too?
23:17 bag alright all - catch you later tonight - dinner date is calling
23:17 rangi naw, we can convert them
23:17 idreambooks jcamins: graeat! good to hear
23:17 idreambooks one thing i wanted to ask you guys....[…]sers/NorthAmerica
23:17 idreambooks according to that there are 40 odd libararies that have websites that use koha
23:18 idreambooks once the patch is pushed to master, do these library systems get updated too?
23:21 rangi when they decide to upgrade yes
23:22 idreambooks oh i c....any idea how often they upgdare typically?
23:23 rangi nope no idea at all (40 odd is way less than actuality, there are at least 600 in the US alone)
23:25 idreambooks oh really...i went off the number in wikipedia that had web based systems. do all these 600 have web based systems?
23:26 rangi koha is web based
23:26 rangi you cant really run it any other way
23:26 rangi do you mean that have public facing sites?
23:27 idreambooks yeah...thats what i meant
23:27 idreambooks 'cos some of the ones listed dont have websites i can see
23:27 idreambooks also some library catalogues are not up to date :|
23:28 jcamins idreambooks: yes, libraries can update as frequently or infrequently as they want.
23:28 jcamins And there's no way of knowing how many libraries make their Koha OPAC public.
23:31 jcamins Hundreds in the US, certainly.
23:31 jcamins melia: do you know off the top of your head how many hundred libraries ByWater supports in the US?
23:33 jcamins idreambooks: suffice it to say, it's a large number. Well upward of 100 libraries in the US. Probably in excess of 200. I don't know if it's closer to 200, 300, or 400 though.
23:33 melia hhhmm. I'd say about 125 different libraries, but some of those are consortiums that have 40+ libraries each...
23:34 idreambooks jcamins: ic...over a 100 libraries are public facing....probably more than 200
23:34 jcamins idreambooks: right.
23:35 idreambooks the "Amazon Reviews" section seem to be blank in most public facing libraries. not sure if it is because amazon is not sending reviews back or a bug
23:36 jcamins idreambooks: Amazon provides reviews for a very small percentage of books.
23:36 jcamins idreambooks: I just counted the number of libraries in one consortium that I happen to know is using Koha. They have 78.
23:37 idreambooks jcamins: cool. you guys are massive. are you the largest in the world or something?
23:37 jcamins Not me.
23:37 jcamins I don't work for ByWater.
23:37 jcamins melia does.
23:38 jcamins Only one of the collecions I work with has a public catalog.
23:38 rangi hmm you do understand Koha is an open source project eh? So a big community of developers and libraries and companies
23:38 idreambooks oh i meant koha being the larget ILS
23:38 rangi no
23:38 rangi far from it
23:39 rangi but its growing all the time
23:40 ibeardslee it is the most awesome though
23:40 idreambooks yup...koha is open source maintained by core contributors like yourselves. i figured you guys were all volunteers (that like to contribute) or work for a library system...
23:42 jcamins idreambooks: we don't really have a "core contributor" concept quite the same as, say, the Linux kernel does.
23:43 melia sorry, I'm only half listening. there are several hundred libraries in the US using Koha, some of which are supported by ByWater (a support company).  there are many other libraries throughout the world using Koha, some of which use different support companies. the Koha community is made up of a bunch of developers who might work for one of the many different support companies, or might just volunteer to work on Koha out of the goodness
23:43 melia their generous hearts.
23:43 jcamins There is an elected release team, but other than that developers come and go as they find the need to fix bugs/add features/kill time/whatever.
23:45 jcamins (so once your patch adding support for the API to Koha, you'll be a Koha developer too:)
23:45 idreambooks ah ic...yeah i am just curious how it all works :)
23:45 idreambooks that's awesome!
23:45 jcamins Incidentally, libwebcats (http://www.librarytechnology.o[…]webcats/ says there are more than 24k libraries in the US, and it is by no means comprehensive.
23:47 idreambooks wow...that's a lot of libraries. they all probably have electronic records too
23:48 jcamins That's all sorts of libraries, of course. Not just public libraries.
23:48 NateC joined #koha
23:53 idreambooks i am somewhat technical (i can code but not a pro). another member of our team is super technical and im trying to get him to show koha some love

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