Time Nick Message 10:37 chris hehe 10:37 paul_p time to go for lunch here. /me heads to McDo 10:36 chris oh yeah they call themselves a restaurant, but so does the pie cart outside the wellington railway station :) 10:36 paul_p if it's ironic, then he should rewrite "'restaurant'" instead of "restaurant" 10:35 Elwell nope, sadly not in McD speak :-( 10:35 chris im pretty sure the reporter was being ironic, ill ask tomorrow :) 10:34 Elwell me wonders how loose the definition of 'restaurant' has to be 10:34 paul_p ah, ok, quite different here... 10:34 chris most of the mcdonalds here are open 24 hours 10:34 chris students mostly, who only work 15-20 hours a week each 10:33 chris they count all the part timers 10:33 paul_p 30 restaurants & 6000 staff... can't believe that there are 200 ppl in each McDo ! 10:31 Amit today delhi vs night riders match 10:31 Amit hmm 10:30 chris but i will need to go to sleep soon 10:30 chris it is on tv live here 10:30 Amit yes 10:30 Amit IPL 10:29 chris Amit: are you watching the game? 10:21 chris i dont think anyone counts mcdonalds as food :) 10:20 chris yes i think so :) 10:19 paul_p not sure if it's a joke ;-) 10:19 paul_p I love: "The results come as McDonald's announces an aggressive expansion plan in New Zealand, building 30 more restaurants and hiring another 6,000 staff over the next three years." 10:18 chris we are catching up :) 10:18 chris paul_p: http://www.stuff.co.nz/life-style/food-wine/2386320/Kiwis-hot-on-heels-of-leisure-loving-French 08:23 kf1 sounds like a plan 08:20 chris kf1: i think i need to wait til my children are a little bit older, then get a eurail pass and travel all around with the family 08:19 chris http://translate.koha.org/ru/opac3_0/ <-- if you ever want to fix any of the translation Hui_Nan_ :) 08:18 chris and of course i need to visit france again 08:18 chris certainly, the woman i was tallking to on the plane convinced me i should visit heidelberg 08:17 kf1 still missing my guest familiy there - they moved and I lost contact years ago 08:16 kf1 chris: will you consider another visit to germany for your list too? 08:16 Hui_Nan_ St.Pete is a very nice town! 08:15 kf1 was on student exchange in st. petersburg years ago - was great 08:15 Hui_Nan_ actually some text is in english, some in ukrainian but a lot of text is in russian %-) 08:14 chris Russia is on my list of places I want to visit 08:14 chris but that is very cool :) 08:14 chris ahhh i think the russian translation is up to date 08:14 Hui_Nan_ I'm in Russia, Ivanovo 08:14 Hui_Nan_ sure 08:13 chris Hui_Nan_: can I ask where in the world you are from? 08:13 Hui_Nan_ good 08:12 chris that is the whole thing, from setting up git, cloning a repository and submitting a patch 08:11 chris if not http://wiki.koha.org/doku.php?id=en:development:git_usage 08:11 chris you know how to use git already? 08:10 Hui_Nan_ btw, point me to some instruction on what should I do if I have a super-duper patch for koha? 08:03 chris if you get in fast, you will be the 90th committer to Koha :) 08:03 Hui_Nan_ that's what I intend to do %-) 08:02 hdl_laptop Hui_Nan_: door is open, please join in ;) 08:01 chris hmm, it looks like the cat has been on the keyboard 07:56 Hui_Nan_ and provide a "button" which makes the job 07:56 Hui_Nan_ I think framework test could warn a user, that some 'really' required fields are not set as required 07:55 chris \ 07:55 chris \\\\\\\\ 07:55 chris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\ 07:55 chris \ 07:55 chris ]' Kahu wearing mom's pearls while waiting 07:53 Hui_Nan_ actually such a records should not appear at all 07:46 hdl_laptop if you want to remove those records from your catalogue 07:45 hdl_laptop this could be a solution. 07:41 Hui_Nan_ is that all I need? 07:41 Hui_Nan_ I believe I could remove the corresponding records from biblio, biblioitem and rebuild zebra's index with the reset option 07:40 Hui_Nan_ how to find it? 07:39 hdl_laptop mmm there has been a patch for that I think. 07:39 Hui_Nan_ no way, koha reports: Can't call method "title" on an undefined value at /home/www/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 882 07:38 Hui_Nan_ now I can't remove them by librarian interface 07:38 Hui_Nan_ I entered some biblios (no items) without a title (no 200$a unimarc field) 07:37 Hui_Nan_ hello all! 07:27 kf1 :) 07:11 chris :) 07:10 paul_p s/guys/people/ (could be some woman here ;-) ) 07:10 paul_p hello GMT-x guys ! 07:10 nahuel hi chris ! 07:09 chris hi paul_p and nahuel 06:52 kf1 hi chris 06:45 Amit hi chris 06:44 chris hi kf and amit 06:16 kf hi Amit 06:15 Amit hi kf 05:17 brendan off to bed... 05:17 brendan Good night #koha 04:05 brendan heya amit 03:56 Amit good morning #koha 03:55 Amit hi brendan, chris, mason 03:49 chris is there a way in the opac to do a search that returns all results? 03:33 mason sweet link bignose 02:40 chris yeah its all cloud 2.0 now anyway 02:39 bignose-work fuck the cloud: <URL: http://ascii.textfiles.com/archives/1717> 02:36 atz chris: I would, but I can't find where on the cloud to plug my keyboard 02:35 ron :) 02:34 chris i just do everything in the cloud 02:34 atz don't have the annoying sync/platform problems between desktop and laptop 02:33 atz works well, since I have to do presentations and stuff elsewhere anyway... 02:33 atz actually, my setup is a MacBook w/ a Dell 20-inch behind it 02:32 ron meh 02:32 ron hence the dual screen setup 02:32 ron I'm trying to convince him that he doesn't need a replacement desktop but instead a notebook with an external screen 02:32 ron yup, me too 02:30 atz the mapping would be %C4::Auth_with_ldap::mapping 02:23 atz but I'm sure you've noticed that already 02:23 atz basically all the LDAP code is in C4::Auth_with_ldap and all the config is in koha-conf.xml 02:22 bignose-work atz: okay, I look forward to it. 02:22 atz i'll post PDF's tomorrow then 02:21 atz really? crap. i didn't realize that. 02:21 bignose-work atz: got a link to download? that wants bogus registration nonsense 02:20 atz http://www.slideshare.net/ohiocore/koha-integration-ldap 02:19 ron no kidding. ;-) 02:19 atz np 02:19 bignose-work atz: thank you for being available for these questions, I've been stalled for a while on this. 02:19 atz i'll say at outset, it hasn't been done yet 02:18 atz let me find my slides link... 02:17 bignose-work atz: that's completely outside my experience; what is that, and how do I invoke it as a shell command? 02:17 atz it has to use the same LDAP-to-Koha mapping as the login-time replication 02:16 bignose-work the unknown for me is, what should that job actually do? 02:16 bignose-work atz: making it happen is no problem; we already have a process to hook into 02:15 atz there is no "push" from LDAP into the Koha DB though 02:15 atz i imagine a crontab-able job that could query on some schema field like "date added" 02:13 bignose-work I'm looking for an automated process, that can be added to the existing automated "create a new LDAP account" process, that will set up the account for use by Koha without further manual configuration required 02:13 atz there is no implementation for that 02:12 ron paradigms are fun, no? 02:12 ron :) 02:12 bignose-work something isn't being communicated here :-) 02:11 bignose-work atz: by querying LDAP, surely? 02:11 atz bignose-work: how would you know the user exists? 02:11 bignose-work but we're saying that Koha can't talk about a user that exists in LDAP, but hasn't yet logged in? 02:10 atz OK, in any case you will do export/import to satisfy (1) 02:10 ron I'm obviously missing something here 02:10 chris what atz said :) 02:10 atz ron: if koha authenticates to LDAP, then can copy the info at that time 02:10 chris then fetches the info and creates a user in koha 02:10 chris it authenticates against ldap 02:09 ron how could they login if their account had not yet been 'fetched;? 02:09 atz bignose-work: the design is not "go dump all my users from LDAP and import them right now" 02:09 bignose-work the creation of the account in Koha should be by import from LDAP, no? 02:09 bignose-work that seems backward 02:09 atz ron: no, I mean they would have to login to Koha before their account was "fetched" from LDAP 02:08 ron ?/ 02:08 ron atz: do you mean they'd need to login to linux before getting their koha account 02:08 ron that's probably fine 02:08 atz before their account is added in Koha 02:08 bignose-work with the additional wrinkle that "new LDAP users" means both users who will be Koha patrons, and users who will be Koha admins 02:08 ron first, before what? 02:08 atz so for (2) is it still unacceptable for them to log in first? 02:08 bignose-work ron: yes 02:07 ron bignose-work: is that right? 02:07 ron 2) automated mechanism for new system LDAP users to be reflected in koha 02:07 ron 1) migration/copying of users from existing LDAP database 02:07 atz this would be a good area for either patron import or LDAP integration to cover though 02:06 ron what bignose-work &I are trying to achieve is two things, I guess; 02:06 atz (and I'm adding more of those as we speak) 02:06 ron of course 02:06 atz moreso if you use "Granular Permissions" 02:06 ron ah, ok 02:06 atz account-by-account, and there are different areas of permission to be granted 02:05 ron are admins defined on an account-by-account basis, or can it be done via a LDAP group? 02:05 pianohacker Good night #koha 02:05 atz technical: it's in a different table (not borrowers) 02:05 atz admin accounts still require a human's blessing for both technical and security reasons 02:04 bignose-work okay. and admin accounts? 02:03 atz patron import will work fine on a CSV file 02:03 atz bignose-work: then you don't want the current LDAP functionality. you want an export from their ldap server 02:03 bignose-work much better would be a command that can be automated in the account-creation process 02:02 bignose-work I don't want the "add a new account" instructions to also include "the user needs to log into Koha before their permissions can be set" 02:02 atz one is logical... you need a username and password 02:02 atz there are 3 different kinds of "requirements" 02:02 bignose-work atz: so what is needed when an LDAP account is added or modified? 02:01 atz chris has covered it 02:01 ron not nearly as much as *I* do. ;-) 02:01 bignose-work atz: hoping to speak to you when you're around. 02:01 chris np, i hope you can get it to work in a useful way 02:01 bignose-work chris: thanks for your help so far. 02:01 chris but america is asleep at the moment 02:01 chris you would be best off talking to atz as he did a lot of the ldap work, and ive yet to use it in production anywhere 02:00 bignose-work we're trying to plug this as much as possible into the existing account management and creation 02:00 chris to ldap? yes 01:59 bignose-work IIUC, this needs to also be done each time a new user is added? 01:59 chris then you could make users in koha with those borrowernumbers and set permissions 01:59 chris unless you know the unique identifier they will be using that is being mapped to borrowernumber 01:58 chris then no, cant really be set up in advance 01:58 bignose-work I don't have access to the LDAP database myself. 01:57 bignose-work I'm trying to set this up so it will work well when transported to a client site and use *their* LDAP database. 01:57 chris as long as they have the same borrowernumber 01:57 chris or you can create the users in koha first 01:57 bignose-work ah. so this can't be done in advance easily? 01:56 chris and give them the permissions they need 01:56 chris then you can go to edit the user, and choose set permissions 01:56 chris basically you need those people to sign in at least once so the users get made in the koha table 01:56 chris right 01:56 bignose-work the same LDAP database also contains users we want to be Koha admins 01:55 chris or set some default so they wont be null 01:55 chris in the koha borrowers table, so you can either map those 01:55 chris so there are 6 fields that cant be null 01:54 chris If you do not have a corresponding LDAP field, you may still account for a required field with a default value 01:54 bignose-work the minimum for PAM LDAP auth, at any rate. 01:54 bignose-work AFAIK (still checking) we're just using the inetOrgPerson schema and so on. 01:53 bignose-work yes, but it seems to be assuming I've got a rich schema to map to whhat Koha wants 01:53 chris http://wiki.koha.org/doku.php?id=en:development:ldap 01:52 chris you have looked at the ldap area on the wiki eh? 01:51 bignose-work so, if I have an existing set of user accounts in LDAP, what is actually needed in Koha for using that set of users as a pool of admins and borrowers? 01:51 bignose-work chris: okay. 01:47 chris that would be some patches we would love to receive :) 01:47 chris not out of the box no 01:46 bignose-work Is Koha able to use PAM for user authentication? 23:38 mason will do, i'm due for a morning coffee 23:37 chris say hi from me 23:37 chris sweet 23:37 mason out at kapiti today..., very nice! 23:36 mason hiya chrissa 23:36 chris hey mason 22:35 chris cool, just checking 22:35 gmcharlt the latter 22:35 chris or we just let zebra take care of it for us? 22:35 chris with our rebuild_zebra cronjob, do we do any locking? 22:34 gmcharlt hmm? 22:34 chris atz or gmcharlt, either of you around? 20:24 chris he has some good stories :) 20:23 chris walter who works on kete a lot, spent a summer in antartica 20:23 pianohacker We could always elect somebody the same way we did at the dev meeting ;) 20:22 chris heh 20:22 brendan if you can talk one of them into it -- a site visit would be required :) 20:22 brendan good suggestion pianohacker ! 20:19 chris we should certainly try :) 20:19 pianohacker I wonder if we could persuade one of the scientific outposts in Antarctica to use Koha, get all seven continents 20:18 chris ohh koha in galapagos 20:17 pianohacker morning chris 20:14 chris morning 19:55 schuster OK thanks I was trying 'NULL' ' ' etc... relearning sql for mysql from Sybase! 19:54 atz schuster: yeah, you have to say IS NULL or IS NOT NULL to be 100% accurate 19:46 danny i normally just say IS NULL 19:35 schuster ok one more question - I'm trying to find items that have a null value.. ? <> 'null' or what is the correct syntax? 18:53 schuster hmmm that didn't work, but if I put a group by cardnumber at the end it did... Thanks! 18:42 schuster AH... slight differences in SQL! Thanks I'll try that. 18:41 atz schuster: DISTINCT 18:40 schuster When I do this statement I get a list of all borrowers at 010 that don't have homeroom as an attribute, but the borrowers have more than one attribute how can I get the cardnumber to show only once on the list? 18:40 schuster select cardnumber, code, attribute from borrowers left join borrower_attributes using (borrowernumber) where code <> 'homeroom' and branchcode = '010'; 18:39 schuster Trying to get unique key from SQL 18:14 wizzyrea true. <thinking> 18:14 pianohacker Easy enough to remove from the RSS template, probably 18:14 pianohacker If I had to guess, it's probably the nbsp and <isbn> problems that are killing wordpress 18:11 wizzyrea boo: http://feedvalidator.org/check.cgi?url=http%3A%2F%2Fnekls.kohalibrary.com%2Fcgi-bin%2Fkoha%2Fopac-search.pl%3F%26limit%3Dbranch%3ANEKLS%26format%3Drss2 18:06 wizzyrea_afk I have not, I shall 17:23 pianohacker wizzyrea_afk: When you get back, have you run the feed through http://feedvalidator.org/ ? 17:19 wizzyrea afk... thinking about it over lunch. 17:19 wizzyrea which is to say it doesn't work. :P 17:18 wizzyrea I can get it to work in google reader but the wordpress rss parser just toots all over itself when presented with a koha RSS url 17:14 wizzyrea example: do a search for newest acq items, and display that feed on another page 17:13 wizzyrea has anybody tried using the search RSS feeds to display content on another website? 16:16 slef time to do some quick-reward website design I think 16:16 slef it's a Bank Holiday here, yet I've been doing koha email most of the day :( 16:14 pianohacker hello all 16:10 brendan greetings slef and all around #koha 16:09 brendan back home. 16:09 slef wb brendan 16:03 wizzyrea afternoon paul_p :) 14:44 jwagner Bonjour paul_p! 14:44 paul_p good morning to US ppl ! 14:44 paul_p hi wizzyrea & jwagner 14:44 jwagner morning wizzyrea 14:43 wizzyrea mornin peps 14:43 wizzyrea_wkend /nick wizzyrea 14:41 jwagner kf, two or three different things. Testing with Russian and Korean records; not sure about other languages. IE doesn't display all diacritics (browser set to Encoding Unicode UTF-8; changing to Cyrillic didn't help). In Firefox, some records display fine, others show as codes (e.g., <U+1100><U+1169><U+110C><U+1175><U+1112><U+116E><U+11AB> ). Not sure if that's a display problem or a data problem. And it seems that you can cut and paste a word with a 14:33 kf jwagner: whats your problem with diacritics? I have some experience with german umlauts, where diacritics are displayed strange, but not totally wrong. it helped to tell Koha to use another normal form for output. 14:11 jwagner OK, thanks. 14:11 atz yeah, what I mean is we can't affect the change from the server side 14:11 jwagner Well, that's at least a better answer than "can't do it" 14:10 atz the answer might be "install this font" 14:10 jwagner OK, that may be a new one. I'll try to get it documented. Don't like the sound of "may not be possible" :-( 14:10 atz at least, not as part of koha 14:10 atz and it may not be possible to fix 14:10 atz I haven't seen that ticketed 14:09 jwagner You said you had a bunch of IE fixes in the works. Did they include diacritics display? 14:09 atz ? 14:09 jwagner Hi, atz -- question for you? 13:00 kf ok, will do 12:58 jwagner kf, gotta run to a meeting. Thanks for checking -- if anything occurs to you, let me know. It may just be a bad karma kind of thing :-( 12:51 Crusoe bye 12:49 kf ok, I made a suggestion but got no mail so far - thats worse 12:47 jwagner This one is a little behind but not much: 3.01.00.014 12:46 kf which version is your system? I cant test it with one of mine, have 3.01 stable and 3.2 development version, but not up to date 12:44 jwagner I'm not sure why it's on myself -- I'll check with the site. But I'm still much puzzled about where it's getting my address -- the syspref is set to the library's address. 12:44 kf is your email in KohaAdminEmailAddress system preference? 12:42 kf sound as its not supposed to work at all :( 12:41 kf found a bug about this: http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=2776 12:31 jwagner It is set to On. 12:30 kf r u using emailPurchaseSuggestions? 12:28 kf hm 12:27 jwagner My own email address is nowhere in the policies or config that I can find. Why is the system using it? 12:27 jwagner I got a bounceback email from the response to one patron's suggestion, and it seems to somehow be using my own email address as the sender instead of the library. I can't figure out where it's getting that from. Suggestions.pm is pulling the email address from somewhere I can't trace offhand looking at it: my $queryMail = "SELECT suggestions.*, boby.surname AS bysurname, boby.firstname AS byfirstname, boby.email AS byemail, lib.surname AS libsurname, l 12:25 kf I tested / played with them, but dont know if thats familiar enough 12:24 jwagner Someone around who is familiar with the acquisitions suggestions?