Time Nick Message 11:57 shaun gtg now - will rach be back by 8:00 GMT? 11:55 shaun ...brighter than the average bear, then... 11:54 paul don't forget : and MARC21 (or UNIMARC) 11:54 paul lol 11:54 shaun lol - "I speak English, Spanish, PHP and Perl" 11:54 paul owen : & a guy that know what is an ILS & librarian daily work ! 11:54 paul shaun : good learning. I was in your situation 3 years ago (good PHP poor perl) 11:53 owen I would really take a spanish- and Perl-speaking expert to do reverse engineering 11:53 shaun I really have to learn perl properly - I am a php person really | I know a little spanish, and I know somebody (non-programmer) who knows a lot more 11:53 paul owen : Ineo has one they said some weeks later 11:52 owen We're sorely lacking in spanish-speaking programmers 11:52 paul ;-) 11:52 shaun oh, no... 11:52 paul (unless YOU volunteer :-D :-D ) 11:52 shaun oh right, I understand now 11:52 paul & reverse engineering would be a pain 11:51 paul because we would not know all what they did 11:51 paul not only 11:51 shaun because it's in spanish (argentina)? 11:50 paul but it would be unuseable ! 11:50 paul if we request a tar.gz from their code, they'll send it for sure. 11:50 paul that's a problem of integrating it properly in official CVS. 11:50 paul that's not a problem of gpl'ing it. 11:50 shaun do you think they will gpl it? 11:48 paul the question is just : how to solve the problem & get the code now ! 11:48 paul (or think he is not) 11:48 paul maybe a developper that is not fluent enough in english 11:48 paul shaun : maybe someone not knowing enough how to be efficient with OSS 11:47 paul yep 11:47 shaun *fails to see logic* 11:47 kados es is espanole right? 11:47 paul & it's hardcoded it seems (i mean : not a translation from english) 11:47 paul right kados. es_AR (argentina english) 11:46 paul otherwise, they could contribute the code easily 11:46 kados spanish I think 11:46 shaun what language is it in? 11:46 paul in fact, that's the main problem !!! 11:46 owen Not even the script and template variables 11:46 owen shaun, that's one of the problems--none of it is in english 11:45 kados paul: 'rubbing it in' is an idiom ... when I hear it it reminds me of a school yard fights where the bully 'rubs' something into the bullied's face ;-) 11:45 shaun document: ooh, nice - where have the screenshots been taken from, and is this in English yet? 11:43 paul (for example : not sure to understand "rubbing", even if I think) 11:42 paul (Ben : don't forget i'm not native english. Sometimes my words have not the same meaning in french & in english. And don't forget i sometimes don't understand english perfectly too) 11:41 shaun (sorry ben, but the way you think my plan to build a linux distro based on the RHEL source was piracy was most entertaining to me) 11:41 owen It's how we all learn. 11:41 owen Ben, they're not rubbing it in, they're /explaining/ 11:41 Ben brb, dinner 11:40 Ben yes, fine; no need to rub it in 11:40 shaun also - if this is a module, the module is not subject to the terms of the GPL unless it includes code from Koha, or another GPL project 11:40 paul the GPL don't say "give back your code". Even if it's highly most efficient for everybody ! 11:40 Ben fine 11:40 kados right 11:40 paul it's only for their internal use ! 11:40 paul they have NO customers ! 11:39 paul but ... 11:39 paul GPL says : you must give your customer the code & freedom to redistribute it. 11:39 shaun they don't have to release it under GPL 11:39 kados mmm ... not really 11:39 paul Not at all. 11:39 Ben ? 11:39 Ben you do all realise that the argentinians are cutting it very thin with the GPL 11:39 paul Being impertinent is not a problem. If you don't forget that WE are Koha, and YOU are the newbie (so you don't know our 5 years history) ;-) 11:35 paul thanks. 11:34 owen Good point paul 11:34 kados right 11:34 Ben :) 11:34 paul so, maybe it's worth 2-3 days delaying bugging him ;-) 11:34 paul and growing of the software. In every case our development team will exist for more 6 months (I hope) and one boy will be dedicated to local Koha's requirements for the Physic Library at UNLP (In background perhaps he could contribute) and the other will be dedicated to digital resources discoveries and making some kind of meta searching for Physics resources. This is the second instance of this project. 11:34 paul No, unfortunately, no. At 20th April week we have an official presentation at National Ministry Of Education for national universities libraries. After that meeting and upon librarians oppinion, perhaps they will request to every university funding for implement and adopt the software into their libraries. In this meeting I will insist over the importance in contributing to the original development project, as the way for ensuring the maintanance 11:34 paul The answer : 11:33 paul my question : Could you please tell us what are your plans at the moment ? do you still expect to be able to commit your modifs toofficial CVS ? do you have a date ? 11:33 paul the last mail I recieved (march, 12) said : 11:33 paul kados : about emiliano. 11:33 Ben the logo in the background image of the intranet homepage of version 1 is in bodomi mt, honest.. 11:33 shaun ??? 11:33 Ben shaun, we are suffering from 5 years worth of development.. 11:32 shaun see http://www.koha.org/images/home-logo.gif 11:32 shaun ben: how? 11:32 kados hehe 11:32 shaun *router flashes wildly* - i love running my own mail server 11:32 Ben shaun, the K is mismatched 11:31 paul (540kb mail sent) 11:31 shaun http://www.myfonts.com/fonts/agfa/centennial/12-linotype-centennial-46-light-italic-11633/win-t1/91068/ - definitely, type in koha 11:31 Ben etc 11:31 Ben unfortunately, perl is not my best subject, but I do know what works visually/ergonomically 11:31 owen Thanks 11:31 owen Please send it again. I'm not sure. 11:30 paul (or do you already have it ?) 11:30 paul (owen, do you want the paper too ?) 11:30 paul those features are already in Argentina 11:30 owen The borrowers table will have to be expanded to include more school-related data 11:30 Ben paul, genial! goodgerster@gmail.com 11:30 shaun shaun@shaunevans.co.uk - thanks 11:29 paul drop your mail address here if you want it. 11:29 paul Ben/ shaun : emiliano, from Argentina sended me a word file with what they did 11:29 shaun take a look at our implementation - we used the year the student joined the school - e.g. 01 for me, which is called "Year 10" 11:29 Ben :) 11:29 Ben whoever 11:29 owen I think I mentioned it on Saturday, Ben 11:28 paul shaun : you must also create a /en directory in you mkdir. 11:28 Ben I don't know; you were the one who told me 11:28 kados paul: do you have emiliano's email address? I'll write him an e-mail requesting it 11:28 paul why ben ? 11:28 owen :( 11:28 Ben yes, but the argentinians won't give it to us 11:28 kados :-) 11:28 paul the bad news : we can't get the code from the guy who wrote it (in Argentina) 11:28 Ben ODFE being Our Dear Friend Eunice 11:28 owen ...and the bad news... 11:27 owen Ben, exactly. 11:27 paul shaun : the good news : opening times is already developped 11:27 owen Right...that's consistent with all libraries, but school libraries will have to deal with more closings, so it's more important 11:27 kados yea ... we've thought about that too 11:27 Ben owen, I concur - ODFE will require something which shows form/year 11:27 shaun (ben and I were thinking about opening times - somebody must not be fined when the library is not open, i.e. on weekends) 11:27 owen I'm sure borrower management is much different if you're dealing with school years and limited year-spans 11:26 owen kados, I'm sure there are things a school library needs that a public one doesn't, and vice-versa 11:26 shaun hi ben 11:26 shaun where are the templates registered (eg `mkdir test` in /intranet/htdocs/intranet-tmpl does not update the list of themes - it is still default and npl) 11:26 kados hi Ben 11:25 Ben hihi 11:24 shaun oops - didn't see that... 11:23 paul 'template' systempref is your friend then ;-) 11:22 shaun I was talking about the intranet, not opac 11:21 shaun ...makes for easy configuration at install time, but the librarian cannot change the theme from windows/ie - our librarian wouldn't take well to telnet ;) 11:21 paul mmm... didn't you saw Koha >> parameters >> systempreferences >> opactheme 11:20 shaun /usr/local/koha/intranet/htdocs/intranet-tmpl/default is actually a symlink to, say /usr/local/koha/intranet/htdocs/intranet-tmpl/npl or .../koha, (if koha will be the name of the default template when it is adopted), or .../school 11:19 paul my customers have very differents needs usually depending on public/academic. 11:19 shaun I have seen some things where a theme is chosen by a symlink to the theme's codename - e.g. 11:19 paul and one for academic ones. 11:19 paul and i'm wondering if we should not have 2 different templates schemes : one for public libraries 11:18 paul anyway, you're right. 11:18 shaun ok 11:18 owen don't worry about what's going to be default and what won't...just get them done and we'll have a discussion together with the rest of the developers 11:18 paul (about odd/even : you're right) 11:18 shaun *looses question mark: ? 11:17 shaun Would it be better for our templates to be implemented as default from 2.3/2.4 (not sure if you use the even=stable, odd=unstable) - to maintain continuity and backward-compatibility if nothing else, even though the changes have nothing to do with the back end in mysql/perl 11:16 kados I'd like to know what the special needs of a school library are 11:16 kados shaun: keep me posted on your ideas 11:15 paul (as 2.2 Release Maintainer) 11:15 shaun yes - as well as contributing the templates we make, I will be editing them to make it more friendly for school libraries (I am also unsure about how to achieve it, but I have been talking with the head librarian a lot about it) 11:15 paul i'll take care of them for 2.2 where applicable 11:15 paul send bugfixes on HEAD too, with an explicite title for your CVS commit. 11:15 paul ok, shaun, you can do whatever you want on HEAD branch of CVS. We will se later if your temlpates have to become the default one. 11:14 owen Maybe there are ways to tailor your templates to that user? 11:13 owen shaun, sounds like you might want to approach the koha interface from the point of view specifically of the school library 11:13 paul ok, I hadn't read this mail yet. 11:13 shaun so I am here now ;) 11:13 shaun I am the founder of a Linux distro that will be used in primary and secondary schools in the UK - based on RHEL, with lots of things that schools find useful, e.g. vnc based remote control, pre-designed intranet and remote management, and I am including lots of OSS that RHEL does not come with, e.g. DansGuardian for filtering - the obvious choice for the library system was Koha, but we thought the interface had a lot of room for improvement, and 11:12 owen And I responded on list. 11:12 owen Ben sent an email to the Koha-Devel list "New Interface & Other Work" on Tuesday April 12 11:11 paul & owen kept it for himslef ;-) 11:10 shaun Well, I think Ben sent an email to Owen about it 11:10 paul shaun, just a question : did you explain your interest to Koha somewhere ? Not to judge if we should help you, just to know ;-) 11:05 shaun thanks - *finds font* 11:05 owen (not one I have) 11:04 owen It tells me that the koha logo is probably some variant of Linotype Centennial 11:04 owen shaun, have you seen this site before? http://www.myfonts.com/WhatTheFont/ 11:04 shaun "you can import it with bulkmarcimport in misc/migration_tools" -- how? 11:01 kados so it actually does export items contrary to the message ;-) 11:00 kados right 11:00 shaun 2.1 mb - importing now... 11:00 shaun thats better (big, big file...) 10:59 kados leave both field blank 10:59 kados ok ... try just exporting everything ;-) 10:59 kados you can import it with bulkmarcimport in misc/migration_tools 10:59 shaun 0 bytes... 10:58 kados it'll come out as 'marc.pl' 10:58 kados end with biblio 4000 10:58 kados start with biblio 3000 10:58 kados http://koha.liblime.com/cgi-bin/koha/export/marc.pl 10:57 kados k... just a sec 10:57 shaun we're alright for borrower data - it's book data that I can't get hold of 10:57 kados http://liblime.com/borrowers 10:56 kados ok ... here's some sample borrowers data: 10:56 shaun thanks 10:56 kados maybe ... give me a sec 10:55 shaun ah... is there any other data I can get hold of? 10:54 kados it's for Koha version 1.2 10:54 kados actually that data isn't really going to work 10:53 shaun umm... how do I import this data into mysql on the command line? (sampledata-1.2.gz) 10:52 shaun yes... 10:52 owen It'd be nice if you could sort IRC users by time zone :) 10:51 shaun no - i have just come across some sample data (importing now, hopefully) 10:51 shaun ok (evening starts at 4 for me ;) ) 10:50 owen Have you gotten any biblio data into your database yet? 10:49 owen ...by the way 10:48 owen rach won't be in for another 3 or 4 hours 10:48 owen The wrong permissions? There's a bug in the install (?) that sets the wrong permissions for that script. 10:47 shaun Is that my fault, or Koha behaviour? 10:47 shaun Also: I have moved the branch and printer items into a .bloc25, underneath all the other content, set up the focusOnFirst() script on all of the circulation pages, and made some <h2>s into <h3>s, as well as moving it all to xhtml 1.0 strict... 10:44 owen Of course selectbranchprinter.pl still has the wrong permissions... >:( 10:41 owen You're right, it isn't showing up is it? (We don't show that in our template, so I never noticed it) 10:36 shaun ...thus, in the released version of 2.2.2, the branch and printer were not displayed on returns 10:36 shaun <b>Printer:</b> <!-- TMPL_VAR NAME="genprname" --> 10:36 shaun <b>Branch:</b> <!-- TMPL_VAR NAME="genbrname" -->, 10:36 shaun were supposed to read: 10:36 shaun <b>Printer:</b> <!-- TMPL_VAR NAME="printername" --> 10:36 shaun <b>Branch:</b> <!-- TMPL_VAR NAME="branchname" -->, 10:33 shaun hang on a moment, I'm digging out the log... 10:32 paul (on phone, but here) 10:32 owen What do you mean about branch and printer being broken? 10:32 paul I am here 10:32 shaun are Paul or Rach on at the moment? 10:32 shaun It appears that the branch and printer were broken in returns - I have fixed this. 10:31 shaun I have done some fixes in circulation - url and un/pw combination are still http://koha.shaunevans.co.uk:8080/ and kohaadmin/hexthouse 10:30 owen Hi shaun 10:30 kados hi there shaun 10:30 shaun hi 10:26 kados ok 10:25 paul (maybe we will delay a few days until you have gnome meeting) 10:25 kados maybe tomorrow 10:25 kados np ;-) 10:25 paul (& no time to dig more) 10:25 paul mmm... can't find how to speak with microphone on gaim. 10:21 owen Nice that they keep it simple. 10:20 kados or something like that ;-) 10:20 kados https://my.screenname.aol.com/_cqr/registration/initRegistration.psp?mcState=initialized&siteId=aimregistrationPROD&createSn=1&siteState=http%3A%2F%2Faim%2Eaol%2Ecom%2Faimnew%2FNS%2Fcongratsd%2Eadp?promo=73010&mcAuth=%2FBcAG0Jj0C0AAK9IAAU%2FvUJj0GkIp0i2ZIsTVJYAAA%3D%3D 10:20 kados paul: here's the registration page: 10:18 kados not sure ... maybe aim.com? 10:17 paul mmm... how to create an accound on aim ? 10:13 kados that would be swell ;-) 10:13 kados if enough of us get webcams we could have Koha video conferences ;-) 10:11 kados I'm in a coffee house so there is some ambiant noise ... but I'd like to try this out ;-) 10:10 kados my aim screen name is joshferraro@mac.com 10:09 kados maybe gaim? 10:09 paul kopete should be the tool. 10:09 kados not sure ... I"m on OSX today ;-) 10:09 paul what tool should I use on my mandrake ? 10:09 kados paul can you chat on AIM? 10:07 paul that requires reading of both 10 000 and 15 000 lines 10:07 kados hmmm... 10:07 kados yep 10:06 paul with your structure you need to do what we already do : a join on marc_words as m1 and marc_words as m2 10:06 kados ahh you're right ... 10:06 kados ok 10:06 paul gnomemeeting 10:05 paul your request would not work, because word can't be something1 AND something2 10:05 kados what video chat program do you use? 10:05 kados cool 10:05 paul kados i'm back. 10:05 kados hey owen 10:02 owen Have you gotten caught up after your trip? 10:02 owen Hi paul. 10:02 paul hi owen 09:56 kados k 09:56 paul (on phone) 09:56 kados (sorting could be done here too) 09:55 kados and we still only have two queries 09:55 kados this would only pull out the results from both right? 09:55 kados select 'wordid', 'tagsubfield' from marc_words where word='something1%' and word='something2%' 09:52 kados you merge where they match if it's an AND search 09:52 paul (with 10 results for both) 09:52 kados right 09:52 paul the 1st being used 10 000 times, the 2nd 15 000 09:52 kados so ... 09:52 paul how do you manage a search on 2 words. 09:52 kados :-) 09:51 paul yes but no. 09:51 kados paul: does that make more sense? 09:51 kados maybe if we designed it well enough we could even do everything in a single query using join 09:50 kados select 'all the display stuff' from marc_words_index where wordid = 'wordid'; 09:50 kados then ... 09:50 kados (we should pull out tagsubfield too) 09:49 kados or maybe two or three max 09:49 kados this is really fast ... only one row 09:49 kados select 'wordid' from marc-words where word = 'somthing%' 09:49 kados so we do an initial query: 09:49 paul thus, your suggestion may be useful for the 2nd part of a search. 09:49 kados well ... let me explain that better 09:48 paul you solve the problem of showing results, but not the problem of selecting what are results 09:48 paul yes but no. 09:47 kados paul: does this make more sense? (I hope) 09:47 kados and 'titledisplay' is the one we display on the search results page 09:46 kados maybe we have 'title' and 'titledisplay' where 'title' is title ~= s/the, a, an, etc.//; 09:45 kados though this may be redundent ... 09:45 kados it could also have 'sortby' columns 09:45 kados so this second table has columns: 'wordid' 'bibid' 'title' 'subtitle' 'itemtype' 'copyrightdate' 'other item info' 'call number, etc' 'copies' 'availability' 09:43 kados and one grabs all the rest of the information from a seperate table indexed by 'wordid' 09:43 kados one grabs the 'wordid' 09:42 kados with my idea we only have two queries 'total' 09:42 kados probably about 12 - 14 queries for each item displayed 09:42 kados etc. 09:42 kados branch status 09:42 kados subtitle 09:42 kados for title 09:42 kados so right no we do many queries to populate the various opac variable for search results display 09:41 kados I probably didn't explain it well 09:41 kados ok 09:18 paul (kados i mean. to beep you ;-) ) 09:18 paul joshua : i don't understand where you gain perfs with your idea. I probably don't understand it well. 09:13 kados paul: ok ... I explained it there ... but perhaps not well ... let me know what you think (or if you don't understand it) 08:54 kados ok 08:50 paul http://www.saas.nsw.edu.au/koha_wiki/index.php?page=KohaRoadmap2.2.x 08:50 paul explain your idea here : 08:47 kados what do you think? 08:47 kados and one to grab EVERYTHING else for display 08:47 kados one to get the 'wordid' 08:46 kados so for searches we only need to do two queries: 08:46 kados wordid, itemnumber, titlesort, authorsort, allsearchrestltsdata 08:46 kados and another table with: 08:45 kados instead of an array of CSV itemnumbers we have a 'word id' 08:45 kados we have marc_words table but slightly different than your idea 08:45 kados i had an idea about marc_words btw 08:44 paul and you're right, i probably breaks searches... 08:44 paul (altough i haven't seen c2004 for instance) 08:44 paul kados : iirc, copyright in UNIMARC can be writte with a letter or without. 08:24 kados this seem to be the 'right' way to do it in MARC21 and it breaks searches 08:23 kados paul: do you know if UNIMARC stores record copyright dates as c2004 instead of 2004? 08:21 kados sounds like a real drag 08:17 paul (and finally get my luggage in Marseille without trouble) 08:17 paul so I missed the aircraft & had to wait 2 more hours for the next one. 08:17 paul I've waited 1hour for a luggage that was already in Marseille. 08:17 paul except that in France, you have to stop to customs if you have something to declare. Otherwise, you just pass through. So the luggages pass also. 08:16 paul 2nd, the girl in Columbus airport told me to get my luggage in Paris before taking the plane for marseille, for customs. 08:15 paul i could'nt be on aisle as in paris => detroit, so I could not really sleep 08:15 paul my trip was not really nice... 08:15 paul a good news (for hdl too...) : 2 new contracts confirmed : IPT (15 000 biblios, migration from another ILS) and Saint Germain sur Morin (new install) 08:14 kados (are you over the jet lag? ;-)) 08:14 kados how was your trip home? 08:14 paul ask me again on next monday if i'm silent 08:14 kados cool 08:14 paul i'll try to give this some thoughts. 08:13 paul that would be great (at least for default) 08:13 kados I have had contact from three other 'consoftia' that are interested in Koha 08:13 kados paul: probably I can do changes in npl and default templates 08:13 paul no, I didn't yet. 08:13 paul ok, I remember 08:13 kados for groups of libraries that want to share Koha but aren't in a system 08:13 paul (are you changes to HEAD in default templates ?) 08:12 paul consortium module ? 08:12 kados cool 08:12 kados have you had a chance to think about a Koha consortium module? 08:12 paul great ! 08:12 paul (writing on the wiki for a "Koha for big libraries" DB modifs now) 08:11 paul hi joshua 08:11 kados paul: welcome home ;-) 03:14 rach thanks 03:13 paul good luck. 03:13 paul bad news for you. 03:12 rach might be a long nite 03:12 rach we got our car broken into so i'm busy cancelling my visa etc, befrore heading to the police station 03:12 paul (koha-fr is down and the provider is quiet since friday :-( ) 03:12 rach nope few hours to go yet 03:12 paul not in bed yet ? 03:12 paul hi rach. 03:11 rach bonjour paul 02:54 paul coucou hdl 01:20 hdl hi 00:19 rachel :-) 22:48 rach s 22:48 rach cheer 22:47 indradg rach, welcome back 18:40 rach morning 16:13 rach morning