Time Nick Message 12:00 chris hi nengard 12:01 gmcharlt scopes are the worst creeps of all 12:01 jwagner gmcharld, I'll agree with that! 12:02 chris we probably need more scrums or something 12:02 chris or whatever the latest project management craze is now 12:03 chris 3 min meetings each morning, while doing handstands 12:03 jwagner I've been too busy to keep up with my project management journals, but personally I'm in favor of a steel cage match between the developers and the people asking for the stuff. THAT should be fun :-) 12:03 chris hehe 12:03 gmcharlt two people enter, one spec leaves 12:03 jwagner (And it keeps me safely on the sideline!) 12:04 jwagner But on the bright side, I think there are some things that people are really going to like. 12:06 Amit hi galen, jwagner 12:06 gmcharlt hi Amit 12:06 jwagner Hi Amit 12:06 |Lupin| hello gmcharlt 12:06 gmcharlt and hi |Lupin| et al 12:06 jdavidb chris: re: scrums--we used to do something like that when I was at Honeywell; they started every meeting with a safety message too.. 12:07 chris oh? 12:07 jdavidb When a new boss came aboard, he asked for a quick safety note at his first meeting, and someone said, "Don't speak to David until he's had his caffeine." "No, I meant a *real* safety message!" "That *is* a real safety message." 12:07 jwagner Uh, oh. I know this story.... 12:07 chris hehe 12:07 |Lupin| mysql users: are there tools to automate copying data from one table in one database to another table in another database, pls ? 12:08 chris on the same server? 12:08 chris or different servers? 12:08 nengard gmcharlt is ther a way to set up x-chat to work with growl so that when my name is used in chat it notifies me? someone at LL told me how to do it on my old computer ... but don't have it set on my new one 12:08 |Lupin| same server chris 12:08 |Lupin| but the formats of the tables may b different 12:08 chris jdavidb: coming from a rugby playing country i cant take scrum's seriously 12:08 gmcharlt nengard: Preferences | Chatting Events/Sounds 12:09 chris |Lupin|: in that case, i have no idea 12:09 nengard gmcharlt i went there- i have my name being highlighted but not beeping ... which one do i want to change? 12:09 |Lupin| chris: ok, thanks ! 12:09 jdavidb chris: coming from a non-rugby playing country, I couldn't, either. Having a meeting first thing in the morning is just insane, anyway. 12:09 gmcharlt nengard: from there, enable Growl for Channel Msg Hilight & Privatge Message 12:09 |Lupin| hello nengard 12:10 chris i just want to yell things like "don't kick the ball, pass it" and "Feed the backs" 12:10 jdavidb lol 12:10 nengard hi |Lupin| 12:10 gmcharlt chris: feed the backs? /me imagines high tea on the rugby field 12:10 chris hehe 12:10 jdavidb @quote add <chris> i just want to yell things like "don't kick the ball, pass it" and "Feed the backs" 12:10 munin jdavidb: 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). 12:11 gmcharlt welcome back nengard 12:11 nengard okay - let's see if this works - nope :( 12:11 jdavidb @quote add <chris> i just want to yell things like "don't kick the ball, pass it" and "Feed the backs" 12:11 munin jdavidb: The operation succeeded. Quote #19 added. 12:11 nengard bleh 12:12 |Lupin| nengard: anything we can do to help you testing your new settings ? 12:12 jdavidb Once we've got a hundred quotes in there, I want to see who the most quotable person is--Probably a toss-up between chris, wizzyrea, and pianohacker.. 12:12 nengard |Lupin| just what you did - typing my username - but for some reason it's not notifying me of these messages 12:13 |Lupin| nengard: I'd like to achieve the same in irssi, but can't help you with xchat, sorry 12:13 nengard okay - changed settings again 12:13 gmcharlt nengard: ping 12:13 nengard YIPPPEE :) 12:13 nengard thanks gmcharlt 12:13 nengard it works now 12:14 |Lupin| great 12:14 |Lupin| any irssi users ? 12:16 chris yep 12:16 chris /highlight 12:17 chris hilight even 12:17 chris type /help hilight |Lupin| 12:18 chris you can do all sorts of funky regex's 12:18 chris ok, misuse of an apostrophe 12:19 chris that means it's time for me to go to sleep 12:19 jwagner G'night chris 12:20 chris have a good day all 12:21 gmcharlt good night, chris 12:25 |Lupin| sleep well chris 12:26 |Lupin| and thanks for the irssi hint 12:59 |Lupin| folks 12:59 |Lupin| are there any constraint codes such as branch codes should respect ? 12:59 |Lupin| or can the code be anything ? 13:00 owen Various codes have different constraints I think 13:00 gmcharlt basic one is length = 10 characters 13:00 gmcharlt support for diacritics in such codes is uneven; using plain old ASCII for them is safest 13:01 |Lupin| okay 13:01 |Lupin| I have a bunch of say 80 libraries in a db 13:01 |Lupin| without code 13:01 |Lupin| well in the old system the codeswere nuumbers 13:01 |Lupin| and for each lib we have address, etc. 13:02 |Lupin| what wold you guys recommend for importing all this in Koha ? 13:02 |Lupin| would you say it would be best to generate the codes manually, or would you suggest to reuse the old numbers, or to generate them automatically in another way ? 13:02 gmcharlt |Lupin|: you could continue to use the numeric codes if you wanted, although more described alphabetic codes are easier for your users in the long term 13:03 |Lupin| gmcharlt: but wil l the users see the codes ? I though they would only see the descriptions... ? 13:04 gmcharlt they'll mostly see the descriptions, but may see the codes in same cases 13:04 gmcharlt I mean, OPAC users should only see the descriptions 13:04 gmcharlt staff users may see the codes in some cases 13:05 |Lupin| gmcharlt: right. 13:05 |Lupin| gmcharlt: nobody won't ever see codes without descriptions... 13:06 nengard owen or gmcharlt can you tell me what this means? 13:06 nengard <!-- TMPL_UNLESS name="patron_flagged" --><th>Renew</th><!-- /TMPL_UNLESS --> 13:06 nengard what is patron_flagged? 13:06 slef nengard: grep -rn patron_flagged C4 13:06 owen Is that from one of those recent patches? 13:06 slef (I don't know, but I can find out if no-one else answers) 13:07 nengard owen - no - it's on opac_user.tmpl 13:07 nengard it's me trying to fix a bug that was recently submitted 13:07 nengard slef - tried that in my Koha directory but got nada 13:07 slef nor in mine 13:08 owen It gets set in opac-user.pl 13:08 slef fire up git-blame-mode on it? 13:08 slef see what change introduced the change in the template 13:08 nengard slef very newbie here - what is that? 13:08 owen If the patron has any restrictions: debarred, lost, gonenoaddress, the flagged value gets set 13:08 slef not sure what the equivalents are for other people 13:08 nengard owen - hmmm - i don't htink it's working: http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3443 13:08 munin 04Bug 3443: enhancement, P5, ---, jmf@liblime.com, NEW, Debarred patrons should not be able to renew items in OPAC 13:09 slef git-blame-mode is an emacs thing - colours and tags each line of the source with what commit added it 13:09 slef or last changed it 13:09 nengard thanks slef 13:09 nengard will try that 13:09 gmcharlt git blame filename is the command-line equivalent 13:09 gmcharlt if you're not using emacs 13:09 slef I'm looking for more general equivalents 13:09 slef gmcharlt: I'm told it isn't but I haven't checked. Will check now. 13:10 nengard thanks gmcharlt that's what i would use 13:10 nengard do i need to be in the directory the file is in? 13:10 nengard i assume yes 13:10 slef it's easiest if you are 13:10 slef or at least in the koha.git working directory top-level 13:11 owen I don't see why bug 3443 would be an enhancement. Sounds like basic functionality to me. In fact I think you're right--I think it's something that used to work and broke. 13:11 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3443 enhancement, P5, ---, jmf@liblime.com, NEW, Debarred patrons should not be able to renew items in OPAC 13:11 slef gmcharlt: hrm, git blame command-line is similar, but then you have to do something else to convert the 8-digit hex string at the start into commit details 13:11 |Lupin| actually, are the branch codes chosen once and forever, or is it possible to modify them later ? 13:11 slef (probably: git whatchanged -1 e660a339) 13:12 gmcharlt slef: true, but it's the whole nengard isn't using emacs thing that I suspect would be a bit of a hurdle 13:12 slef |Lupin|: possible but messy I suspect 13:12 slef nengard: try git blame opac_user.tmpl | grep patron_flagged 13:13 slef nengard: then try git whatchanged -1 HEXSTRINGfromStartOfLine 13:13 |Lupin| slef: okay -- so one really needs to pick up good codes... 13:13 slef |Lupin|: yes, picking "ThatMoronsBranch" is a bad idea 13:13 nengard c3e0cf6b koha-tmpl/opac-tmpl/prog/en/opac-user.tmpl (Paul POULAIN 2007-10-12 03:05:33 -0500 185) <!-- TMPL_UNLESS name="patron_flagged" --><th>Renew</th><!-- /TMPL_UNLESS --> 13:13 nengard 2f6a2464 koha-tmpl/opac-tmpl/prog/en/modules/opac-user.tmpl (Paul POULAIN 2008-01-13 01:39:12 -0600 224) <!-- TMPL_UNLESS name="patron_flagged" --> 13:13 nengard ba4c13a5 koha-tmpl/opac-tmpl/prog/en/modules/opac-user.tmpl (Owen Leonard 2008-08-25 11:14:36 -0500 263) <!-- TMPL_UNLESS name="patron_flagged" --><th>Renew</th><!-- /TMPL_IF --><!-- /TMPL_UNLESS --> 13:13 nengard ba4c13a5 koha-tmpl/opac-tmpl/prog/en/modules/opac-user.tmpl (Owen Leonard 2008-08-25 11:14:36 -0500 287) <!-- TMPL_UNLESS name="patron_flagged" --> 13:14 owen See, I knew it should have worked ;) 13:14 nengard oops - that was step 1 - not the second command slef told me to try 13:14 slef ; git whatchanged -1 c3e0cf6b 13:14 slef commit c3e0cf6b428541e1717e098aae5f5b8072409e33 13:14 slef Author: Paul POULAIN <paul@koha-fr.org> 13:14 slef Date: Fri Oct 12 03:05:33 2007 -0500 13:14 slef 13:14 slef #1255 : flagged patron can't renew 13:14 slef 13:14 slef then look at bug 1255 13:15 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=1255 critical, PATCH-Sent, ---, jmf@liblime.com, RESOLVED FIXED, Debarred patrons can renew via the OPAC 13:15 owen Ah, good--even an old bug to be resurrected. 13:16 nengard how come when i pick a bug that i think will be easy for me to fix it turns out to be a mess??? 13:16 nengard should i reopen 1255 and mark 3443 a dup? 13:16 slef nengard: everything is connected. Read Dirk Gently. 13:16 owen nengard: I think so 13:18 slef I think I agree. Update(?) version and priority on old bug though. 13:19 owen nengard: Is this just about the "renew all" button? 13:20 nengard no 13:20 owen If I debar my account I don't see the inline links for renewing individual items, but I do see the renew all button 13:20 nengard it's the renew button 13:20 nengard in the OPAC 13:20 nengard I don't see a renew all in the OPAC ... hang on - have to go back and view 13:20 nengard oh look - i do have a renew all button :) hehe 13:21 owen If that's the only issue it should be an easy template fix 13:22 nengard owen okay - it's the renew all button only 13:22 nengard so I just need to put the flagged line around it 13:22 nengard and it should be fixed? 13:22 nengard right? 13:22 nengard but i'm still confused as to where patron_flagged is set - how would i have figured out what that meant if i was all alone? 13:24 owen I searched the Perl files for "patron_flagged" and got a hit from opac-user.pl 13:24 gmcharlt right - you often need to grep through all of the Perl files, not just the ones in C4 13:24 owen Found this: if ( $borr->{'debarred'} || $borr->{'gonenoaddress'} || $borr->{'lost'} ) { 13:24 owen $borr->{'flagged'} = 1; 13:25 owen } 13:25 nengard thanks for the tips guys 13:25 nengard patch on the way 13:25 nengard i have tested and it works awesome :) 13:27 owen nengard: Are you going to respond to Marshall Breeding's question "Integrating with your ILS through Web services and APIs" ? 13:27 nengard ummmm 13:27 owen I'm curious what your perspective is wrt Koha 13:28 nengard wasn't planning on it ... i think i only skimmed that 13:28 nengard will have to read it thoroughly 13:29 owen gmcharlt: I remember ages ago josh showing me some kind of XML service in Koha where you could pull details for a single record 13:29 owen Does that sound familiar? 13:30 gmcharlt owen: yes - basically, all of the APIs described at https://bws.biblios.net/doku.php are present in Koha 13:30 nengard gmcharlt patch question - how do I write a summary that shows in the body of the email versus the subject line? 13:32 gmcharlt nengard: first one of the batch is what appears in the subject 13:32 gmcharlt then follow it by a blank line 13:32 gmcharlt then the rest of the patch description 13:32 nengard ahhh 13:32 nengard thanks :) 13:32 gmcharlt first line should be no longer than 60 characters or so 13:32 nengard i yell at you all for not putting in descritpions - so I have to make sure i follow my own rules :) 13:33 gmcharlt nengard++ 13:33 owen gmcharlt: What purpose does the "link rel="unapi-server"" tag serve in the OPAC? 13:34 gmcharlt signals to things like Zotero that grok the unapi protocol where to get more information about bibs in a resultset 13:34 gmcharlt owen: http://unapi.info 13:35 owen I thought Zotero was parsing data on the page itself 13:35 gmcharlt owen: no - Zotero uses unAPI and COiNS to grab that info from Koha 13:35 gmcharlt spared them having to write a custom translator for Koha 13:41 nengard owen - style question. for this bug: http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3139http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3139 if i were to move fields what would be the best way to do it? I can float one field left and then put the other field next to it ... but is that the best way to use CSS? 13:41 munin 04Bug 3139: enhancement, P5, ---, oleonard@myacpl.org, NEW, Patron Form Standardization 13:45 owen I'm concerned that moving fields will actually complicate things, make the form more difficult for the eye to scan 13:46 nengard okey dokey should we close the bug then? cause that's all that is left :) 13:47 owen You don't want to arm wrestle or anything? 13:47 nengard nope :) it's not that important to me ;) i save battles for things that really matter :) hehe 13:47 nengard I do want to explore ways to make that page shorter at some time - but that can be done other ways 13:47 owen Then my personal preference would be for you to close the bug 13:47 nengard closing now :) 13:51 owen Hey, how come Evergreen gets to be on the unapi examples page? They must have beat us to it. 13:52 gmcharlt owen: hmm, not an exclusive club 13:52 gmcharlt seriously, I think edsu or rsinger manage that website, ask'em to add Koha 13:53 gmcharlt or maybe it's dchud 13:54 owen Would the request format for Koha be like /unapi?id=koha:isbn:3460048719&format=marcxml ? 13:55 gmcharlt owen: not any longer - it's koha:biblionumber:123 13:55 gmcharlt oddly, not everything has an ISBN 13:56 owen So it's not like a search query where you can try different methods of access 13:56 gmcharlt owen: correctly - Koha's OpenSearch support is closer to that 13:57 gmcharlt oh, and 13:57 gmcharlt owen: you're in a maze of twisty microformats, all remarkably alike ;) 13:58 nengard fun stuff 13:59 owen Someone threaten to wedgie us before we nerd again. 14:08 |Lupin| hmm in case there are SQL experts around 14:09 |Lupin| is it possibl to combine insert and select in one query 14:09 |Lupin| so that the selected results are inserted in a table ? 14:10 collum Lupin: http://dev.mysql.com/doc/refman/5.1/en/insert-select.html 14:11 |Lupin| collum: thanks a lot ! you're great !! 14:38 |Lupin| ERROR 1062 (23000): Duplicate entry '' for key 1 14:38 |Lupin| hmm 14:40 owen So I guess choosing which unapi format to use is just a matter of what one's preference is among the kinds of data returned? 14:43 collum Lupin: without seeing the code, my first inclination is that you need to use a 'distinct' keyword in your select statement. 14:44 |Lupin| collum: I don't know. 14:44 |Lupin| collum: what I'm trying to do is inserting libraries in the branches table. 14:45 |Lupin| collum: before the insertion this table has only one entry 14:45 |Lupin| collum: and there are 87 to be added 14:46 collum Lupin: it looks like you have to eliminate the one that is in the table already with your select statement 14:46 collum Lupin: 'and branchcode != 'brachcode' 14:47 |Lupin| collum: I did that... 14:47 |Lupin| collum: yep it's what I did... 14:47 |Lupin| collum: the only possibility is that there are some duplicates in the results from the select... 14:49 collum Lupin: select distinct(branchcode) from ... 14:49 |Lupin| collum: no actually the rows in the results from the select are unique, just checked. 14:50 |Lupin| collum: yup I tried: first a select without the distinct, then with the distinct, and got the same number of rows for each 14:52 collum Lupin: The next thing I would try would be a limited set. See if one row gets inserted. You can either limit or just say branchcode = branchcode. 14:55 |Lupin| collum: right. 14:55 |Lupin| collum: does mysql have some trace mechanism that would let one know at which point the request fails ? 14:56 |Lupin| ah just changed a little thing and it worked... 14:56 |Lupin| but there were some warnings which were not displayed... 14:57 |Lupin| is there a way to see them ? 14:57 |Lupin| ah show warnings... 14:59 collum Lupin: Sorry, I got sidetracked with something else. Did you find the warnings? 15:00 |Lupin| collum: yep 15:00 |Lupin| collum: Now what remains is to nderstand why my first attempt did not work... 15:39 |Lupin| is it possible to specify that all the users in a given category shall have certain permissions automatically ? 15:48 slef |Lupin| not yet but one tool that would help is being developed twice. I think it might be bug 3332 15:48 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3332 enhancement, P5, ---, mjr@ttllp.co.uk, ASSIGNED, Edit whole category of patrons 15:48 slef that's the one 15:49 |Lupin| slef, ok, will have a look to this one, thanks ! 15:49 slef that would be about adding them afterwards 15:50 slef at least I don't think it's possible yet... but maybe I'm just forgetting how 15:50 nengard slef i do not think it is possible 15:50 nengard you are right 15:51 slef nengard: ta. I tend to use a few bits of koha lots and not things like configuring patrons very often - library staff generally do that 15:51 nengard slef I on the other hand have to do it every time I do training :) so I'm up on that part of things 15:51 slef and it must work fairly well because I don't see many support calls about it ;-) 15:52 slef nengard: I tend to train the head librarian on the technicalities, who then trains their own staff. But maybe I'm working the wrong way ;-) 15:52 nengard if you're not getting calls then it's working a-ok :) 15:53 nengard I usually train however the library wants me to 15:53 nengard i tell them what we can do and let them pick what our schedule is - I'm there to teach them so I leave it up to them 15:54 slef similar, but not having a LibSci in the company probably means our "what we can do" is different 15:54 slef my next fun task may be to arrange training for our own workers :-/ 15:55 nengard slef very true 15:55 nengard don't you also do things differently in the UK than we do here in our libraries? 15:55 |Lupin| :) 15:56 slef nengard: hard for me to comment, not knowing US libs much. 15:56 |Lupin| time to leave, end of working day here 15:56 |Lupin| bye everybody ! 15:56 nengard bye Lupin 15:56 |Lupin| bye nengard, take care 15:56 slef nengard: UK, NL, SE and AU have lots of similarities, though. I'll comment on more as we work there ;-) 15:56 nengard I think someone was talking about some differences between UK and US - thought it was you - guess not 15:58 slef No, I think that was PTFS 15:58 slef about punctuating authorities? 15:58 nengard slef no - it was a while ago - no biggy :) you might want to check out the NEKLS training materials 15:59 nengard they took the manual and my training of them and created videos and guides 15:59 nengard and it's all awesome 15:59 slef All of the co-op-served libraries are specialist in some way, so I take care not to draw UK generalisations. 15:59 nengard http://www.nexpresslibrary.org/training/ 15:59 slef I think I have NEKLS materials bookmarked. Are they linked from koha.org? 15:59 nengard I'll have to check and see if they're linked - but there is the link for you to save 16:00 wizzyrea we should be :P 16:00 Sharon We have a new CE person on staff, so we hope to improve those materials soon, too. 16:00 nengard Sharon that is awesome 16:00 Sharon before our next batch of 7 libraries come on board. We want it to be more professional-looking 16:02 nengard links added here: http://koha.org/documentation/link 16:35 pianohacker Good morning 16:37 nengard mornin pianohacker 16:37 pianohacker Hey, nicole 16:37 pianohacker Haven't seen you here for a while 16:37 pianohacker How are you? 16:37 nengard yeah - been setting up a new computer and before that travel but I'm back 16:37 nengard doing okay 16:37 nengard you? 16:37 jdavidb Howdy, pianohacker. :) 16:38 pianohacker nengard: Good, busy 16:38 pianohacker jdavidb: Hey thar 16:38 nengard busy is good 16:38 pianohacker I suppose :) 16:38 sekjal good day, all 16:38 pianohacker Hi, Ian 16:38 sekjal hey, pianohacker 16:42 CGI098 hi 16:57 Sharon Help - how can we do an exact name search for a patron - we have a heather heath and it pulls up 197 hits! 16:58 pianohacker Not sure if you can do an exact name search 16:58 Sharon can we do 'surname:' 16:58 gmcharlt no, at present it always truncates on the left 16:58 gmcharlt my other left, that is 16:58 Sharon hmm. well that sucks raw eggs 16:58 pianohacker However, you might be able to throw in other information about the patron (like address) 16:59 Sharon nope, added branch and no go. 16:59 Sharon ok, gotta go do a group lunch, i'll play more later 16:59 Sharon ty! 17:00 pianohacker Always glad to say "Idunnotrypokingthis" 17:17 sekjal MeSH takes a long time to index... 17:23 cau0730 hi 17:23 pianohacker hi 17:23 sekjal hello 17:24 cau0730 i have a question and am hoping someone can shed some light on this for me 17:24 cau0730 i work at chinook school division in sask,canada and having a problem with koha 17:25 pianohacker cau0730: That's what we're here for 17:26 nengard This first paragraph match any of you?? hehe http://www.readwriteweb.com/archives/open_source_social_media_community_collaboration_freedom.php 17:26 cau0730 we have been using koha for 3 years but we have really anal librarians here that think it is a bad program. i have been adding quite a few features to koha as the need them and have a quite extensive changelist, now of course i can produce my source to anyone that wants it but i will tell you now that it is based on our school division needs and again a lot of it is due to really anal librarians 17:27 cau0730 also i just started about 9 months ago and the gentleman before me was really not a programmer 17:27 cau0730 stating that 17:27 pianohacker nengard: Hmm. Curtains open, no mcdonalds, and don't drink soda, but I am listening to a remixed game soundtrack 17:27 nengard hehe 17:28 cau0730 i have moved our koha server over to a new box, 64bit ubuntu 9.04 17:29 cau0730 during the move diacritics have broken when adding a new biblio 17:29 pianohacker cau0730: Are all of your tables still set up for utf8? http://wiki.koha.org/doku.php?id=encodingscratchpad 17:31 cau0730 i think so but i will check, just one minute 17:32 pianohacker cau0730: Just out of curiosity, what was your old system 17:32 pianohacker ? 17:32 cau0730 fedora 17:33 pianohacker Your old ILS, rather 17:33 cau0730 the collation is showing as latin1_swedish_ci from items 17:33 pianohacker biblio and biblioitems would be the most crucial 17:34 cau0730 same thing 17:34 cau0730 also marc_subfield_table is swedish 17:35 pianohacker Are you on 2.2 or 3.0? 17:35 cau0730 2.2 17:35 pianohacker Ahh, ok. Then that page above should work perfectly for you 17:36 cau0730 so i need to set them all to utf8 17:36 pianohacker Yup 17:36 cau0730 i am not really that great with encodings can you tell :) btw: i am american.... so you can see that i am naive lol jk 17:37 cau0730 thank you for your help with this :) 17:37 collum Thanks pianohacker 17:37 cau0730 now if i can only give them the search they wanted 17:37 pianohacker cau0730: This encoding stuff is weird, yes 17:38 pianohacker collum: For what? 17:38 cau0730 they want to search french materials without diacritics 17:40 cau0730 boy have i had a hard time with them :) i had to change itemtypes to a circulation code/collection code standard cause they wanted it 17:40 cau0730 and of course i work for a school division so i have to also do other programming work 17:40 collum pianohacker: for your answers. They are always excellent. 17:41 pianohacker Not a problem, happy to help :) 17:47 cau0730 pianohacker: the division just amalgamted three years ago. before that they were using librarypro,Will tech, Maplewood,Resource Mate,Lexifile and the rest card catalogues 17:49 cau0730 and of course the developer before me only took 11 schools on and really screwed up. It is so bad that he never hit on isbns so he just imported all data. We have a database of over 150000 biblios and quite a few of them are crappy entries. Lots of blank entries too 17:57 ebegin cau0730, have you though about moving to the lastest version of Koha? Maybe there is a lot of thing that your library implemented that is already in the new version... 18:00 cau0730 ebegin: i have thought of doing so but we would lose the circ code/collection code method as well as i have extended branching quite a bit to allow ip based branching. i really would move to the newest version if it wasn't for these librarians always ready to throw the whole system out the door. i am facing annihilation of the system and if i suggest upgrading they will defintely break 18:01 pianohacker ebegin: I think koha has an equivalent to your circ codes and collection codes in the form of itemtypes and ccodes 18:02 pianohacker It also has an IP field for branches that allows you to restrict staff login by IP 18:02 collum cau0370: Can you create a duplicate of your koha system on another machine, upgrade it, to show the librarians the new features? 18:02 ebegin true 18:17 sekjal I'll be turning on my production server at the end of next month, and I don't have direct control over our network administration 18:17 sekjal what protocols on what ports should I tell my net admin to enable for my server? 18:18 sekjal obvious http on 80 and 8080 18:18 wizzyrea You using SIP outside your network? 18:18 sekjal wizzyrea: no 18:18 wizzyrea k, no problem there then 18:20 sekjal I want to allow incoming z39.50 connections, so ports 9998 and 9999 18:21 gmcharlt sekjal: note re z39.50 that you actually have complete choice - port 210 is the canonical Z39.50 port, but others (e.g., 9998 and 9999) can be used 18:23 sekjal ah, okay. canonical is better 18:26 sekjal is usually that for biblio, authority, or both? 18:35 gmcharlt sekjal: bib, normally 18:36 gmcharlt but can be used for both, as db name would distinguish 18:37 sekjal excellent 18:54 chris morning 18:54 owen Hi chris 18:58 cau0730 i am still not sure i understand. how come new_from_xm is converting the data. i know that my collation is wrong on the tables but when you post around in addbiblio to add a field all the program does is get the information from the post values and then it adds another field, right? 19:00 |Lupin| hi again 19:01 cau0730 hi 19:06 |Lupin| hi cau0730 19:34 cau0730 okay now my data is all showing up weird 19:39 chris @gcalc 90 fahrenheit in celsius 19:39 munin chris: 90 degrees Fahrenheit = 32.2222222 degrees Celsius 19:41 cau0730 so the data is not corrupt but it isn't viewing it correctly 19:43 cau0730 http://lib.chinooksd.ca:8080/cgi-bin/koha/detail.pl?bib=169915 19:43 cau0730 http://lib.chinooksd.ca/cgi-bin/koha/opac-detail.pl?bib=169915 19:44 cau0730 there you can see that one 19:45 chris messy 19:46 cau0730 to say the least lol 19:48 chris im afraid, its gonna be a hard path back out of that, customised old 2.2.x install ... :( 19:48 chris you have checked the marc_* tables in the db eh? 19:50 cau0730 mysql> show full columns from marc_subfield_table; 19:50 cau0730 +---------------+---------------------+-------------------+------+-----+---------+----------------+---------------------------------+---------+ 19:50 cau0730 | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | 19:50 cau0730 +---------------+---------------------+-------------------+------+-----+---------+----------------+---------------------------------+---------+ 19:50 cau0730 | subfieldid | bigint(20) unsigned | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | | 19:50 cau0730 | bibid | bigint(20) unsigned | NULL | NO | MUL | 0 | | select,insert,update,references | | 19:50 cau0730 | tag | char(3) | latin1_swedish_ci | NO | MUL | | | select,insert,update,references | | 19:50 cau0730 | tagorder | int(11) | NULL | NO | MUL | 1 | | select,insert,update,references | | 19:50 cau0730 | tag_indicator | char(2) | latin1_swedish_ci | NO | MUL | | | select,insert,update,references | | 19:50 cau0730 | subfieldcode | char(1) | latin1_swedish_ci | NO | MUL | | | select,insert,update,references | | 19:51 cau0730 | subfieldorder | tinyint(4) | NULL | NO | MUL | 1 | | select,insert,update,references | | 19:51 cau0730 | subfieldvalue | varchar(255) | utf8_general_ci | YES | MUL | NULL | | select,insert,update,references | | 19:51 cau0730 | valuebloblink | bigint(20) | NULL | YES | | NULL | | select,insert,update,references | | 19:51 cau0730 +---------------+---------------------+-------------------+------+-----+---------+----------------+---------------------------------+---------+ 19:53 cau0730 yeah this isn't good to cause they are cataloging lol 19:54 chris yeah dont go changing them, but id just check a few rows, see if the data is a mess in there 19:54 chris ok gotta go catch my bus 19:54 cau0730 the data looks fine 19:56 cau0730 it is kind of weird. i need to do a little testing here 20:10 slef anyone know how we get onto twitter.com/kohails? It doesn't seem to be using the planet feed 20:17 owen slef: Isn't it just following the hashtag? 20:34 gmcharlt slef: not sure - email nengard 20:44 CGI319 Hello folks. I just finished loading koha on windows. I wanted to try out the intranet but need a login and password. Apparently the person who loaded the software should know what it is (it was me) but I don't recall setting up a password and login. Any ideas? 20:47 chris slef: nengard has a yahoo pipes thing set up 20:47 chris so get her to add to that 20:47 chris back btw 20:49 pianohacker brb, going to see if I can free up some ram so git gc --aggressive can run without swap thrashing 20:58 richard hi 21:00 chris richard: have you seen http://library.kapiticoast.govt.nz/ ? 21:01 CGI319 Hi there, wanted to see if anybody has any input on my question above? ie, where I should look to find out what my login/password is. Sorry for the dumb question, not techie savy... 21:01 chris CGI319: if you can find the koha.conf file 21:01 chris the username and password will be in there 21:02 chris be warned tho, the windows version is old and lacks a lot of features that the new 3.0.x releases have 21:02 richard just looking now 21:02 richard way cool 21:03 CGI319 Yeah, thanks. Unfortunately we are windows only....we have pretty basic needs so hopefully it will do. 21:03 chris CGI319: cool 21:03 chris richard: yeah it looks really good 21:10 pianohacker That was fairly productive. ~15 minutes of CPU grinding brought my .git dir from 100 MB to 64 MB 21:10 chris nice 21:10 CGI319 Chris, I found the koha.conf file and I tried the user name and password user there...user: Koha; pass: password, and it didn't work. 21:11 chris hmm, i wonder how the db is managing to connect then 21:15 pianohacker CGI319: The password under <config>, or <serverinfo> ? 21:16 pianohacker Wait, nvm, this is 2.2 21:18 CGI319 I can get to the opac okay, just can't get into the intranet, if that helps. 21:30 cau0730 pianohacker: do you have any advice for me? my data is displaying wonky 21:31 pianohacker Geh, trying to remember 2.2 database layout 21:32 cau0730 it is funny because it shows the data right in the mysql client but doesn't display it right 21:33 pianohacker Ahh, I think I know why 21:33 pianohacker On that encodingscratchpad page 21:33 pianohacker Try scrolling down to where it talks about modifying dbh 21:33 pianohacker And try that 21:36 cau0730 what part? 21:38 pianohacker http://wiki.koha.org/doku.php?id=encodingscratchpad#if_your_mysql_server_needs_other_default_character_sets 21:42 cau0730 no luck 21:43 pianohacker Huh. Is your browser interpreting things as utf-8 ? 21:43 cau0730 it should be... i have it set up as utf-8 21:47 pianohacker @devs: sysprefs work so far: http://github.com/pianohacker/koha/tree/prefs 21:47 munin pianohacker: downloading the Perl source 21:47 pianohacker Poor munin, wants to be a developer 21:51 cau0730 i feel for you munin :) 22:27 pie hello all :) 22:27 pianohacker Hello 22:27 chris heya pie 22:27 chris pianohacker: pie sits 4 desks away from me at work 22:27 pie hi chris :) 22:28 pie yeah, I wish it were more :-p 22:28 pianohacker Yup, @*.catalyst.net.nz 22:28 pie heh 22:28 chris pie: pianohacker is a koha developer from colorado, and holds the distinction of being the youngest person to commit a patch 22:29 pie that's cool ... and maybe lives at the highest altitude too? 22:30 cau0730 i used to work on the syllable project... www.syllable.org and am working on an os now :) i would rather do low-level c programming or gui c++ programming but yet i am a web developer at work lol 22:30 pianohacker Hmm. I wonder if the web on my smartphone would work on top of one of the fourteeners in the state 22:30 chris heh 22:31 pianohacker ssh + home box = first patch made with hypoxia 22:32 chris lol 22:32 pie learn something new everyday: http://www.14ers.com/ 22:40 cau0730 well i got into a fight over this fix that they wanted lol they want me to fix the character encoding but they aren't willing to wait out the process 22:40 chris ahh, life would be so much easier without users 22:41 chris :) 22:41 cau0730 :) 22:42 anxst i have a problem... i can't seem to get searches on terms with diacritics in them working, at least not when they are stored in a decomposed form in the database 22:42 anxst any ideas? 22:42 chris ahh you want to catch the europeans 22:42 chris i know that the french guys have it working 22:42 cau0730 doesn't help that they are a bunch of politicans here and they just want another "program" cause this one "sucks" and can't "do what we want it to do" 22:42 chris iirc it needs tweaking of the zebra config files 22:42 chris anxst: drop an email to the mailing list is your best bet 22:43 anxst k, will try that... 22:43 chris or come back in about 8 hours, when europe will be awake :) 22:43 cau0730 "we want an editiable marc view" lol same as addbiblio but it doesn't look the same and they are mad lol 22:44 cau0730 can you search using easily without diacritics? does anyone know 22:44 chris not with 2.2 cau0730 22:45 cau0730 zebra gives you this option 22:45 chris yes 22:46 cau0730 what is zebra exactly 22:46 chris an indexing engine 22:47 cau0730 ah okay 22:47 chris takes the marc, indexes it, and provides a fast and powerful search engine 22:48 cau0730 even fuzzy searching is enabled 22:48 chris yes 22:48 chris relevance ranking too 22:49 cau0730 okay i wonder how much work it would be to integrate it 22:49 chris id strongly recommend against trying to integrate it with 2.2 22:49 chris it wont work 22:49 cau0730 why is that? 22:50 chris the marc is stored in totally the wrong way 22:50 chris this is why 3.0 was written 22:50 cau0730 ah 22:50 chris a much better idea is to get a 3.0 going and port your enhancements to it 22:50 chris would be years less work 22:50 chris :) 22:51 cau0730 it would mean a lot of database redesigning though 22:52 chris to get zebra to work, hell yes 22:52 cau0730 oh i mean for me to get my version up to date with 3 22:52 chris a lot of the enhancements already made to 2.2 may well be in 3 22:52 chris i recommend getting a 3.0.3 up and have a look at it, maybe load your data in 22:53 chris forking is always a bad option, you end up where you are, with unsupported code that is really hard to maintain and you lose out on everyone elses work 22:54 cau0730 yeah. i didn't fork :) if it was up to me i would have wrote my own using django and python 22:55 chris i now, but perpetuating the fork is only gonna cause hurt 22:55 chris if you get what i mean 22:55 cau0730 yeah tell that to my superiors :) 22:55 chris got an email address? 22:55 cau0730 rcaudill@chinooksd.ca 22:55 chris im not sure they will listen to me though :-) 22:55 cau0730 oh that is my email address lol 22:56 chris heya joetho 22:56 pianohacker Sounds like you're caught between a rock and a hard place 22:56 chris cau0730: maybe set up a demo to show them 22:56 pianohacker Maybe the liblime public demos? 22:56 cau0730 my predecessor did that but it wasn't enough for them 22:57 chris for 3 ? 22:57 cau0730 of course this is his fault too. he spent two years jacking around 22:57 cau0730 yeah right before he left he showed them three 22:57 chris *nod* if patches had been submitted 22:57 chris the features may well have been in 3 22:57 chris ah well 22:57 cau0730 agreed 22:57 cau0730 it really sucks 22:58 cau0730 although you didn't want his patches :) 22:58 chris hehe 22:59 chris ive been in this situation before 22:59 cau0730 if ($loggedinuser eq '533'){do_this()} elsif{$loggedinuser eq '566')}else ... 22:59 chris ouch 22:59 cau0730 lol 22:59 cau0730 yeah that bad :) 22:59 chris luckily we could convince the library that upgrading and getting back into the community was the win 22:59 pianohacker I've been coding perl for way too long (just a couple of years); the first thing I noticed is that he was doing numerical comparison with eq 23:00 cau0730 that is right 23:00 cau0730 it was horrible code 23:00 cau0730 anyway i have to go. later 23:00 pianohacker bye 23:00 chris cya later 23:04 pianohacker chris: Any thoughts on the prefs code? (If you haven't a look, no biggie, just curious) 23:05 chris ahh its on my list to look at tonight 23:05 chris ill clone the repo and get it up and running and have a poke 23:05 pianohacker cool. How's your koha work going? 23:05 chris havent done any in the last few weeks 23:06 chris been busy with other less interesting stuff, but getting back into it later this week i hope 23:06 pianohacker good good 03:08 Amit hi chris, ebegin, richard 03:09 Amit good morning #koha 03:09 pie good (my) afternoon Amit :) 03:09 Amit hi pie 03:09 pie I love timezones, right until you need to get a computer to do them :) 03:09 pie and then they suck 03:10 Amit Pie: from which country u r? 03:11 pie I'm in NZ too, Chris is just on the other side of the room at the moment (we work together) 03:11 pie I've had a quick look at Koha a couple of month ago but I wanna get into it a bit more soonish :) 03:15 Amit Pie: NZ is my favioutre country 03:15 pie :) 03:15 pie mine too 03:23 Amit @wunder New Delhi India 03:23 munin Amit: The current temperature in New Delhi, India is 28.0°C (8:30 AM IST on July 28, 2009). Conditions: Overcast. Humidity: 89%. Dew Point: 26.0°C. Pressure: 29.47 in 998 hPa (Steady). 03:23 Amit @wunder Dehradun India 03:23 munin Amit: The current temperature in Dehradun, India is 23.0°C (5:30 AM IST on July 28, 2009). Conditions: Thunderstorms and Rain. Humidity: 96%. Dew Point: 23.0°C. Pressure: 29.38 in 995 hPa. 07:31 chris evening 08:18 |Lupin| good morning #koha ! 08:20 chris hi |Lupin| 08:25 Amit hi lupin, chris 08:29 |Lupin| nice to see you all guys 08:29 |Lupin| hope you are all well 09:04 |Lupin| folks 09:04 |Lupin| I have a display problem 09:04 |Lupin| by branchnames contain accents that are handled in a bad way 09:05 |Lupin| however if I do a select branchname from branches where branchname like 'B%'; 09:05 |Lupin| they appear correctly... 09:05 |Lupin| any idea where the problem may come from ? 09:06 kf do you have accents in the codes or in the description? 09:07 |Lupin| kf: in the description -- these are those not displayed correctly. 09:07 |Lupin| kf: no accents in the codes, though. 09:16 |Lupin| kf: did you find some ? are they handled correctly ? 09:16 kf sorry, needed to finish another task first 09:16 kf will look at it now 09:17 kf where do see them displayed wrong? 09:20 kf I have itemtypes and branches with umlauts - this seems to work without problems so far 09:22 |Lupin| kf: okay, so probably something is misconfigured here... 09:23 kf perhaps accents are handled differently 09:23 kf I can rename them to your description to test 09:25 |Lupin| kf: no I don't thik so actually. I have one site called "Association Valentin Haüy" with an umlaut and it does not work either 09:26 kf catalog and search work fine for me 09:30 |Lupin| kf: ok :) 09:31 |Lupin| kf: thanks 09:40 gmcharlt good morning 09:42 chris yikes 09:42 chris isnt it like 5.44am? 09:42 gmcharlt ? 09:43 gmcharlt and what if it is? you wanna make something of it??????? 09:43 gmcharlt ;) 09:44 |Lupin| hi gmcharlt :) 09:44 |Lupin| chris: do you know where the displaying problem cold come from ? 09:45 |Lupin| gmcharlt: don't you like tea ? perhaps a bit less aggressive for the body... 09:45 gmcharlt |Lupin|++ 09:45 |Lupin| :) 09:45 chris is it only in the drop down |Lupin| 09:45 chris ? 09:46 |Lupin| chris: no 09:46 |Lupin| chris: hmm let me check the table of libraries... 09:47 |Lupin| chris: confirmed. When going to Admin -> Libraries and Groups, the display is wrong, too. 09:47 chris hmmm 09:48 chris but its fine in the db? 09:48 |Lupin| chris: and if I view the content of the branches table under mysql, the accents are printed correctly 09:48 |Lupin| chris: yes, it seems ok 09:48 chris the page is being served as utf-8? 09:48 |Lupin| chris: I don't know 09:49 gmcharlt |Lupin|: have you checked your DB character settings? 09:49 chris i havent heard of anyone else having this issue 09:49 |Lupin| chris: but in the <head> section there is an http-equiv which givet the mime tpe (text/html) and the charset, utf8. 09:49 |Lupin| shouldn't that be enough ? 09:49 chris yep, in that case it might be they are stored as latin-1 09:50 chris but displaying as utf-8 09:50 |Lupin| gmcharlt: I think I did but I'm willing to double check because I'm not sure I did it correctly 09:51 gmcharlt also, is your terminal set to UTF-8; if you're looking at the characters via mysql in a Latin-1 terminal mode or the like, may appear correct but be wrongly encoded 09:51 |Lupin| chris: $LANG contains fr_FR.UTF-8 09:52 |Lupin| s/chris/gmcharlt/ 09:52 gmcharlt |Lupin|: here's how you check show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%"; 09:52 gmcharlt show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%"; 09:52 gmcharlt from mysql, even 09:53 |Lupin| let me see 09:55 |Lupin| hmm the w 09:55 |Lupin| hmm the two requests are identical ? 09:55 gmcharlt yrd 09:55 gmcharlt yes - just hadn't indicated where the request begins the first go around 09:56 |Lupin| http://pastebin.com/f1390b606 09:56 |Lupin| ok 09:56 |Lupin| thanks gmcharlt 09:56 |Lupin| these settings look weird to me... 09:57 gmcharlt yeah, they're wrong 09:57 |Lupin| :) 09:57 gmcharlt http://wiki.koha.org/doku.php?id=encodingscratchpad has the correct ones 09:57 |Lupin| I'm really wondering where the sweedish things come from! 09:57 chris sweden 09:57 chris :P 09:57 magnusenger |Lupin|: There is some info about this, at least for MySQL 4.1 here: http://wiki.koha.org/doku.php?id=encodingscratchpad#mysql_4.1 Not sure if there is a big difference to MySQL 5... 09:58 |Lupin| magnusenger: thanks ! 09:58 magnusenger ooops gmcharlt beat me to it... 09:58 |Lupin| oh it's the same link, okay 09:58 magnusenger yep 09:59 gmcharlt downside is that the safest way to correct this would be to change the default DB settings, then create a new Koha database 10:00 gmcharlt presumably one can do enough hacking, possibly including munging a mysqldump file, to transfer your data 10:00 gmcharlt but I'm not sure of the details 10:01 |Lupin| gmcharlt: do you mean that just changing the server configuration as explained on the wiki won't be enough ? 10:02 gmcharlt |Lupin|: right - you also need to make sure that the tables are using the new collations 10:03 |Lupin| gmcharlt: and is there a way to see which settings are used by each table ? 10:03 gmcharlt |Lupin|: e.g., http://dev.mysql.com/doc/refman/4.1/en/charset-conversion.html 10:04 |Lupin| gmcharlt: yep, I knew this one actually,I just don't know what collation means... 10:05 gmcharlt |Lupin|: collation = rules for sorting, basically 10:05 gmcharlt |Lupin|: select column_name, character_set_name, collation_name from information_schema.columns where table_name = 'BIBLIO'; 10:07 |Lupin| gmcharlt: thanks ! 10:07 |Lupin| hmm that's gonna be a bit of work apparently... checking all the tables and all the columns... 10:07 |Lupin| gmcharlt: thanks also for the collation, that's what I thought because of the LC_COLLATE variable. 10:09 gmcharlt yeah, scripting will be your friend for that one, or else doing a mysqldump, munging it to make sure that (a) strings are UTF-8 and (b) you don't break MARC records and loading it into a new DB 10:09 |Lupin| gmcharlt: no marc records in the db for the moment. 10:09 gmcharlt |Lupin|: well, that makes it downright easy then 10:10 |Lupin| Just a few users, some libraries, document types, definition of new marc fields, things like that. 10:10 |Lupin| gmcharlt: yes ? 10:11 gmcharlt in that going through and changing the character set and collation of the tables should do it 10:12 |Lupin| gmcharlt: ok 10:13 |Lupin| I'll experiment 10:13 |Lupin| gmcharlt: thanks a lot, your help was precious. chris' too. 10:14 gmcharlt you're welcome 10:18 |Lupin| hmm in Debian the charset is not even mentionned in my.cnf... weird... 10:24 |Lupin| just restarted mysqld... here is what it says: 10:24 |Lupin| Checking for corrupt, not cleanly closed and upgrade needing tables.. 10:24 |Lupin| any idea about what to do with that ? 10:24 chris ignore it 10:24 chris it says that everytime 10:24 |Lupin| ok :) 10:24 chris unless of course it finds corrupt tables :-) 10:26 |Lupin| hmm 10:26 |Lupin| just tried to see the variables 10:26 |Lupin| they look unchanged... 10:26 |Lupin| isn't it correct to add a file in /etc/mysql/conf.d ? 10:27 |Lupin| with a [mysqld] section containing all the necessary things ? 10:33 |Lupin| ah that's okay 10:34 |Lupin| Stupidly, I called the file conf.d :/ 11:39 nahuel hi 11:40 nahuel hi gmcharlt 11:44 |Lupin| hey nahuel 11:46 nahuel hi |Lupin|