Time Nick Message 11:51 jwagner Morning! 11:44 gmcharlt good morning 09:03 wxcv thanks, i'll try without doing that, but i have a feeling you're right. 08:57 chris yeah, i think you need to fake a cookie 08:56 wxcv but doesn't look like that's the way to go 08:56 wxcv i was wondering wether there was something easier, like set_userenv :) 08:56 wxcv yeah, i guess. 08:52 chris well www::mechanize + http::cookies 08:50 chris you could use mechanize, to fake a cookie 08:48 wxcv anyone know how to "emulate" a user session in koha from perl? 08:27 chris hi jo 07:31 chris roll even :) 07:29 chris and give the Electoral commission, and the electoral role all run on OS, and the Ministry of Justice use plone .. there are some feet in the door already 07:28 Elwell cool. Good Luck :-) 07:28 chris whether much comes of it or not, is to be seen, but at least it is possible to actually consider other than MS 07:27 chris one that hasnt been available before 07:27 chris well its a big opportunity 07:25 Elwell chris: the /. story on MS/NZ -- (http://news.slashdot.org/article.pl?sid=09/05/26/0155209 ) will that actually open up the door to more Open Source stuff or in reality just mean each dept buys their own MS licences? 06:51 paul_p hello chris 06:41 chris evening 04:25 Amit heya Jo 04:25 Jo hey Amit 04:25 Amit heya brendan 04:24 brendan hey amit 03:27 mason long time no chat 03:27 mason morning amit 03:26 Amit morning #koha 03:26 Amit hi brendan, chris, mason 01:17 Ricardo Time to go to bed. Take care everyone. Chris: Thanks again for the tips / help! :) 00:31 Ricardo Back in 30 mins, I think... See ya! :) 00:22 Ricardo Hello? 00:02 Ricardo Is the order of the INSERT INTO `authorised_values` ... lines relevant for something (e.g: for display in a list)? 00:01 chris yep 00:01 chris :) 00:00 Ricardo That's what happens when you have a Virtual Machine WITHOUT XWindows :) 00:00 Ricardo Sorry, eheh 00:00 Ricardo (file "/usr/bin/gitk" line 2696) 00:00 Ricardo static unsigned cha..." 00:00 Ricardo #define tri-rt_height 13 00:00 Ricardo #define tri-rt_width 13 00:00 Ricardo "image create bitmap tri-rt -background black -foreground blue -data { 00:00 Ricardo while executing 00:00 Ricardo Error in startup script: invalid command name "image" 00:00 Ricardo Application initialization failed: no display name and no $DISPLAY environment variable 23:54 chris and type gitk 23:54 chris for fun sometime, just change into your koha git repo 23:54 Ricardo OK.Thanks for the info 23:53 chris but mostly commandline 23:53 chris i use gitk sometimes 23:53 Ricardo Do you use some kind of Graphical Interface for git or do you use it like me (command line only)? 23:52 Ricardo Yep! :) 23:52 chris so thats good 23:52 chris rapidly 23:52 chris its getting better though 23:52 chris *nod* 23:51 Ricardo Again: I think git is very powerful, but lacks a bit in the "User friendliness" section 23:51 chris *nod* 23:51 Ricardo right 23:51 Ricardo Do a commit first ? 23:51 chris just do them as 2 commits 23:51 Ricardo Not sure how I split that in git, though... 23:50 Ricardo Oh yeah... agreed 23:50 Ricardo The "smallest" problem they have is that they use 2 letter lowercase country codes (I think country codes, according to ISO 3166, should be UPPERCASE). The Russian do it as UPPERCASE 23:50 chris because then if for some reason they say "oh but we need it like that" 23:50 chris (you dont wnat your translation patch depending on the fixes to the french one, or mixed in with it) 23:49 Ricardo Kinda... 23:49 chris if that makes sense 23:49 chris that way if its not accepted it doesnt block your other stuff 23:49 Ricardo OK (to both. Thanks! :) 23:49 chris Ricardo: yep, do it as a separate patch 23:48 chris he has done some stuff to make the systempreferences translatable 23:48 chris you should talk to jesse (pianohacker) 23:47 Ricardo Speaking of which, I think I detected several mistakes, regarding Country Codes in the authorised_values.sql file of the French. I'm wondering if it's good etiquette to submit that in git :-S 23:46 Ricardo Yeah... Maybe add a "language_id" column to some of the tables. That will be a BIG headache first, but better later, I think 23:45 chris yeah we need to work out a way to make .po files from the sql 23:45 chris was at meetings 23:44 chris heh 23:13 Ricardo (there's a deafening silence here, now ;-) 23:05 Ricardo The PO/Pootle part, on the other hand, works pretty well IMHO :) 23:03 Ricardo Actually, I think this localization should take a major change, regarding SQL files (to avoid much copy+paste+doing similar things/inserts in slightly different ways in several languages)... but that would require a pretty big change to the data model. And that's NOT nice NOR easy :( 23:01 Ricardo OK :) 23:01 chris ill have a chat with paul and hdl if i see them tonight (nz time) 23:01 chris well it assumes to much to be safe really 23:00 Ricardo Right. At least, that's also my opinion 23:00 chris yeah thats even more dangerous 23:00 Ricardo INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (457, 'qualif', '650', ' Editeur'); 23:00 chris hehe yeah 23:00 Ricardo The French hardcode IDs (I like that EVEN less): 22:59 chris yeah 22:59 Ricardo No IDs... I like that better ! :) 22:58 Ricardo INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0',''); 22:58 Ricardo File: blib/INTRANET_CGI_DIR/installer/data/mysql/en/optional/auth_val.sql 22:58 Ricardo I think I found it: 22:58 Ricardo Right. It looks dangerous to me too 22:58 chris i wonder if gmcharlt is around? 22:58 chris it feels dangerous to me 22:57 Ricardo Can't find it for English :( 22:56 chris hmm how does the english one do it? 22:55 Ricardo chris: I see that "authorised_values_\[COUNTRY\].csv.sql" (in the ru-RU and uk-UA translations) use LAST_INSERT_ID() function + some number... Is this safe /recommended? 22:45 Ricardo Eheh 22:45 chris sure is 22:45 Ricardo Much nicer output/layout :) 22:45 Ricardo http://koha.pastebin.com/m5826a159 22:44 chris good plan 22:44 Ricardo I know, I'll copy the French one: 22:43 Ricardo chris: Nice! Thanks for the info :) 22:43 chris http://koha.pastebin.com/ <-- for future ref 22:43 Ricardo Right! 22:43 chris ah yeah not fun 22:42 Ricardo chris: http://pastebin.com/m777dc120 22:41 Ricardo Let me try to show you 22:40 chris oh? 22:40 Ricardo I really, Really, REALLY *hate* editing the "INSERT INTO" SQL statement for the NoZebraIndexes system preference :( 22:30 pianohacker bye, all 22:30 pianohacker Time to get off, have been staring at the same line of code for way too long 21:54 Ricardo chris: Right. I thought so, but wasn't sure. Cool! :) 21:53 chris because we can create the others ones from them + the .po file 21:53 chris we only store the english ones 21:53 chris nope 21:52 Ricardo chris: Still regarding translations... Should the .tmpl files also be submitted through git? 21:51 Ricardo chris: Well, that depends on what's your goal... but OK, I understand you :) 21:50 chris Linux ... no point replacing something proprietary with something else proprietary ;) 21:50 Ricardo chris: Hi Chris! I know, I know... You'd install Linux or Mac OS X, right? ;-) 21:49 chris i can make it more stable :) 21:49 chris :) 21:49 Ricardo OK. I logged off (Windows), logged back in disabled the "Automatic [hard disk] Defragmentation" in Diskeeper 2008. My machine seems to be more stable now 21:32 Ricardo Back in 10 mins (machine highly unstable) 21:25 Ricardo gmcharlt: Oh, OK. Thanks for the info! 21:25 gmcharlt Ricardo: yes, but that's for hdl to do - I'm sure he'll get to it tomorrow 21:25 Ricardo Galen: Hi Galen! :) Is it possible to "cherry pick" my "INSTALL.opensuse" update/patch to the 3.0.x branch (besides of HEAD where you already placed, thanks for doing that BTW)? 21:24 Sharon it came up in some search training I did - US public libraries have a lot of questions about newbery and caldecott winners 21:23 gmcharlt Sharon: not currently 21:20 Sharon Is the 586 Awards field included in the notes/comments search? 21:19 Ricardo Hi everyone! :) 21:00 Jo is the socer over (was 2-nil) when i left home 20:59 Jo well i'm not - its not long after breakfast! 20:59 brendan ha -- yup I'm hungry 20:58 chris now im hungry too 20:52 chris mmm piano cakes 20:51 pianohacker Hmm. I think I prefer this version, especially as I'm kind of hungry right now 20:50 chris :) 20:50 brendan whoops -- sorry about hacking your name 20:50 Jo this is the beauty of a warm, supportive, cooperative koha community... I fel a blog post coming on :) 20:50 pianohacker Hey brendan 20:50 brendan hey pianohcaker 20:50 Jo and pianohacker was instrumental in getting another offer to us. 20:49 Jo (Sharo is one of the generous souls .. 20:49 Jo Hiya Brendan. 20:49 brendan hey Jo Sharon, chris 20:49 Jo hello Sharon! 20:49 Sharon yes 20:49 Jo Sharon moreland? 20:49 chris Sharon: awesome :) 20:48 Jo I am over whelmed at the very generous and munerous responses I have had to my plea for a cataloguing coach. 20:48 Sharon Chris we can officially edit reports now - our install was updated last night with the dev weekend patches and improvements...thank you 20:48 Jo Morning 20:47 hdl_laptop hi chris 20:47 pianohacker Good morning 20:47 chris morning 18:44 atz but the CPAN stuff isn't really 100% yet 18:43 atz yeah, i'm sure there are great commercial executables that you can just throw postscript at and it will make a PDF 18:42 pianohacker PDF support in Perl does seem to be a lesser-of-several-mediocrities problem 18:42 pianohacker Heh 18:42 atz but a lot of that could have been that our implementation also sucked 18:41 atz i remember there were enough widespread issues (format creep, performance) that we were ready to try something else 18:41 pianohacker Were there any other showstoppers? 18:41 pianohacker I'll have to investigate the barcode problem 18:40 pianohacker Yeah. I don't think that's necessary with PDF::API2 18:40 atz bad design... writes everything to a tempfile first 18:39 atz example of the old code 18:39 atz http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=barcodes/barcodesGenerator.pl;h=808227d3457e94e842919ce83bfe4d7eb44aa514;hb=b489690e1e4f5d13065366442798bac4b4401ccb 18:37 pianohacker That's mildly problematic, for a barcode printer 18:36 atz not maintaining spacing on the barcodes, for example... makes them useless 18:35 pianohacker I've noticed a few oddities. What were some you noticed? 18:35 atz pianohacker: we used to use PDF::API2, but it had ample problems as well 18:34 atz so we aren't embedding anything 18:34 atz ebegin: the limitations are you don't get to know what fonts are on the server or the client 18:34 pianohacker thanks 18:34 ebegin pianohacker, I'll check that soon ;) 18:31 pianohacker If you solved the problem and have a patch for #2246, though, you would make many non-US libraries very happy 18:30 pianohacker Hmm. The error I was getting was far more basic: "Wide character in string" 18:29 ebegin pianohacker, Ok... I had to normalize the $field->{data} using Unicode::Normalize. NFD($field->{data}). Maybe there is a best way to do it. I guess PDF::Reuse has some trouble with NFC unicode. 18:24 pianohacker ryan: I might get to it by the end of summer; so many coding projects I want/need to do... 18:24 pianohacker ebegin: http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=2246 18:24 ebegin pianohacker, hold on... I'll check how I solved this :) 18:23 pianohacker ebegin: From my investigation, the module does not support it unless you use a difficult-support hack involving custom-loading TTF fonts 18:22 ebegin pianohacker, do you have problem to output diacritics with PDF::Reuse? 18:21 wizzyrea atz: even with that limitation, it works much better 18:21 ryan pianohacker: no, but i'd give you a ++ if you took the reigns on it. 18:18 pianohacker Are there any plans to change the PDF output module for the label maker? I've had luck outputting diacritics using PDF::API2 18:15 atz it still can't do diacritics 18:15 atz wizzyrea: partially fix, anyway 18:14 wizzyrea atz: didn't you fix the labelmaker? apparently it's a huge hit here lol 18:14 gmcharlt Sharon: thanks 18:01 Sharon gmcharlt our LOST functionality magically returned after the updates...that bug can be closed. 18:01 jwagner Happy dances are always fun :-) 18:00 Sharon I was told they did a 'happy dance' 17:59 Sharon kudos, kudos, kudos 17:59 Sharon I have words of praise and thanksgiving to share from the staff at one of our libraries...they are thrilled with how the label maker now works and are happy to see $b, $p and $n of the 245 in OPAC search results. 17:59 pianohacker hi 17:58 Sharon Hello 17:20 nahuel see you tomorrow 17:20 nahuel hehe i'm going to sleep, too tired :) 17:19 gmcharlt you too 17:19 nahuel :) 17:19 nahuel -s 17:19 nahuel and others countries :) 17:19 nahuel well have a good day in usa :) 17:19 gmcharlt nahuel: thanks! 17:19 nahuel now i'm right :) 17:19 nahuel viewMARC - "Autoriser l'affichage de la vue MARC des notices bibliographiques" 17:19 nahuel viewLabeledMARC "Autoriser l'affichage MARC labellisé des notices bibliographiques" 17:18 nahuel viewISBD - "Autoriser l'affichage de la vue ISBD des notices bibliographiques" 17:17 gmcharlt :) 17:17 nahuel 2s :) 17:17 nahuel arg 17:17 nahuel the 2nd: 17:17 nahuel i'm wrong 17:17 nahuel hmmm 17:17 nahuel and the 3rd 17:17 nahuel "Autoriser la vue MARC des notices bibliographiques" 17:16 nahuel no accent for the first then the 2nd : 17:16 gmcharlt if so, better use pastebin 17:16 gmcharlt any accent characters in that? 17:16 nahuel "Autoriser l'affichage de la vue ISBD des notices bibliographiques" 17:16 gmcharlt are the three 17:16 gmcharlt viewMARC - Allow display of MARC view of bibiographic records 17:16 gmcharlt viewLabeledMARC Allow display of labeled MARC view of bibiographic records 17:15 nahuel gmcharlt, i'm here for 2mn and go home 17:15 gmcharlt viewISBD - Allow display of ISBD view of bibiographic records 17:15 gmcharlt hdl_laptop, nahuel, nicomo: any you around to translate sysprefs 16:12 wizzyrea plenty of mentions of koha on twitter these days 15:47 gmcharlt I'd say so 15:47 gmcharlt but ON UPDATE CASCADE would be better for both of those 15:47 hdl_laptop So should be considered as a bug. 15:46 gmcharlt likewise for on item update 15:46 gmcharlt although on borrower update (i.e., changing the ID of an existing borrowernumber) shouldn't happen often 15:46 gmcharlt that's wrong 15:45 hdl_laptop can you account for the fact that ON borrower UPDATE and item update issue row is set to NULL ? 15:45 gmcharlt hdl_laptop: go ahead 15:45 hdl_laptop gmcharlt: question about issues and foreign keys. 15:28 wizzyrea thanks ^.^ 15:28 pianohacker No problem, good luck 15:28 wizzyrea thanks for the tip 15:28 wizzyrea that's keeping me from my goal 15:28 wizzyrea right. it's gotta be something parent/child-y 15:27 pianohacker You might also try th if td doesn't work. Not familiar enough with the HTML of that page to tell you which it is 15:25 wizzyrea ...trying 15:25 wizzyrea AH 15:25 pianohacker I think :contains() only finds text contained within that element, not any of its children 15:24 pianohacker Try $("#patron-messaging-prefs td:contains('Upcoming Events')").parent() 15:24 wizzyrea (since it doesn't work) 15:24 wizzyrea i want the row containing upcoming events selected so I can squash it 15:24 wizzyrea but this only selects the entire div 15:22 wizzyrea or somesuch 15:22 wizzyrea $("#patron-messaging-prefs tr:contains('Upcoming Events')").css("border","3px solid red"); 15:22 wizzyrea this is what I'm trying to do: 15:19 pianohacker $("#id tr") ? 15:19 wizzyrea or maybe I'm misunderstanding 15:18 wizzyrea this table has a div, but no table ID 15:18 pianohacker Although, since ids have to be unique, #id is usually enough 15:18 pianohacker How do you mean? If you want to find a tr with a given id, you can just do tr#id 15:17 wizzyrea sorry to be such a nub >.< 15:17 wizzyrea I'm missing it in the docs: is there an AND type operator in jquery? like, I want #div AND tr 15:14 wizzyrea *shrug* :) 15:14 jwagner Harrumph. Why can't there EVER be one simple explanation! 15:14 wizzyrea_away no maam 15:14 jwagner Have you done any table changes? I'm strongly suspecting that in our case, because there are some reserves changes. 15:14 wizzyrea_away yea 15:13 jwagner On expired holds? 15:13 wizzyrea_away that it wasn't telling the staff member where to transfer the item to after cancelling a hold 15:13 wizzyrea_away jwagner: we got the same report this morning 15:07 jwagner AHA. I think we've made a reserves table change. We'll investigate that, thanks. 15:07 gmcharlt and would be evident in the Apache error log for that DB 15:07 gmcharlt table changes could do it if there's a column in reserves that's not in that DB's old_reserves table 15:06 jwagner Gonna try it on another development server, I think. 15:06 jwagner Running under git checkout master doesn't show anything with the diff. There are a lot of code branches on this server, and some table changes, but I can't see that any of them would be a factor here. 15:05 gmcharlt a git diff origin/master will tell you if there are in fact any differences in the code 15:05 gmcharlt if the database in question is (supposed to be) completely up to date 15:04 gmcharlt yeah, I'm not seeing any syspref that would be overriding it 15:02 jwagner It's gotta be something unique to this system, I think. I'm testing the same SQL on another server that's at the same level (3.01.00.032), and a cancelled hold shows up fine in the old_reserves table. A puzzlement..... 14:58 jwagner Just logged into the OPAC & cancelled one there too. Neither show up in old_reserves. Any sysprefs that could be a factor? 14:57 jwagner In staff mode, go to the patron record, look at the holds tab, set the pulldown in the Delete column to Yes, click Cancel Marked Requests. 14:56 gmcharlt what path are you using to cancel the requests? 14:55 jwagner Hmmm. They aren't going there on my test system. Wonder what could be blocking them. I'm running a straight koha.org install. 14:53 gmcharlt jwagner: no intentional one - they should be going to old_reserves 14:53 jwagner gmcharlt or anyone -- Does someone know if there has been a change in the way Koha deals with cancelled holds? I had a SQL query working that checked the old_reserves table for expired or cancelled holds. Both were showing up in that table. In latest Koha (give or take an .03x level), cancelled holds don't seem to be written to that table. I am dumping out the entire table contents, and there is no change before and after I cancelled a couple of hold 14:06 nahuel but well, i'll complete this task! I'm sure i will ! 14:06 nahuel :'( 14:05 nahuel hehe 14:05 pianohacker I feel your pain 14:05 pianohacker Rules often seem so simple in theory and so frustrating to implement 14:05 nahuel it's breaking my head 14:05 nahuel toooooo "hard" stuff 14:05 pianohacker Oh, yes 14:04 nahuel this ... stuff of holding by public/branch/itype 14:04 pianohacker Anything exciting? 14:04 nahuel the same :) 13:57 pianohacker Yourself? 13:57 pianohacker Not much, busy working on Koha 13:56 nahuel pianohacker, what's up ? 13:56 nahuel pianohacker, hi jesse ! 13:32 pianohacker Good morning 13:00 gmcharlt you're welcome 12:58 kf added cn Control-number and link works now - thx again! 12:46 gmcharlt right - just not used, but as I said, that part is the simple thing to fix 12:46 kf but my changes were not visible - so I tried en and it worked 12:45 kf thats ok, but I noticed that the xslt-files are in DE-de 12:45 gmcharlt it's not handled by Pootle at translate.koha.org 12:45 gmcharlt but the other thing is that you currently have to translate the XSLT yourself 12:44 gmcharlt yes 12:44 kf ok, perhaps I should file an enhancement-bug for this :) 12:44 gmcharlt there's a simple fix (letting it look for XSLT outside of the en tempalte directory) 12:44 gmcharlt kf: not a present 12:43 kf oh, is it possible to translate xsl-files for detail and results? I tried, but it seems its only using en/xslt 12:43 gmcharlt in which case, you would have to reindex 12:42 gmcharlt that means that a reindexing wasn't done after the melm 001 Control-Number index was added 12:42 kf ok, will try 12:42 gmcharlt and it turns out that the URL works 12:42 gmcharlt if you resave your 208862560 record and index it 12:42 kf great, thx! 12:42 gmcharlt one thing to check 12:42 gmcharlt you don't even need to restart zebrasrv 12:41 gmcharlt ccl.properties only maps from the CCL codes used by Koha's C4::Search to the Z39.50 attributes 12:41 gmcharlt kf: no 12:41 kf gmcharlt: do I have to reindex after changing ccl.properties? 12:38 kf software update, wanted to click no, clicked yes ... now all windows and documents got closed 12:37 gmcharlt was wondering :) 12:37 kf had to reboot :( 12:28 hdl_laptop for you to use it in query 12:28 kf it is, I checked with Galen 12:28 hdl_laptop Control-number should be declared in ccl 12:28 kf hi hdl 12:28 hdl_laptop kf 12:27 kf http://hfjst.bsz-bw.de/cgi-bin/koha/opac-search.pl?q=Control-number:208862560 <wrong 12:27 gmcharlt if you want a short index name, you can add a 'cn Control-number' line to ccl.properties 12:25 gmcharlt I don't think so 12:25 kf case-sensitive? 12:24 gmcharlt ok, so that means that using Control-number as the full index name in your permalink should work 12:24 kf Control-number 1=9001 12:23 gmcharlt so now check ccl.properties for Control-number and/or 9001 12:23 kf yay :) 12:23 gmcharlt ok, so now we know that it's properly indexed 12:23 kf att 9001 Control-number 12:22 gmcharlt ok, so now look for Control-number in the biblios bib1.att 12:21 kf ok, there is melm 001 Control-number - differnt from my print out 12:19 kf MARC21 - but I know we did some changes, or a colleague did, who is now on vacation 12:19 kf y 12:19 gmcharlt have you made any changes to your Zebra config? if not, if you tell me whether you're using MARC21 or UNIMARC, I can look it up for you 12:19 kf ok, I have a printed version of that here, but I will check the file directl 12:18 gmcharlt then look at bib1.att and ccl.properties to see if that index is mapped to a search index qualifier 12:18 gmcharlt there would be a melm 001 IndexName line 12:17 gmcharlt first, look at the record.abs for your MARC format to see if the 001 is indexed at all 12:17 kf searching in zebra files, but im a little confused 12:17 kf where to look at? 12:16 gmcharlt depends on your Zebra config 12:16 gmcharlt kf: yes, if you've indexed the 001, you can generate a permalink using that index name 12:16 kf i tried sn, but cant get it to work 12:16 kf hi, is it possible to generate a link to a koha-record in opac using field 001?