Time Nick Message 03:19 AmitG heya chris gm 04:25 * rangi waves from the bus 05:00 AmitG heya kmkale 05:15 cait good morning #koha 05:43 AmitG heya cait :D 05:45 cait hi AmitG :) 06:39 kmkale Namaskaar #koha 06:42 huginn New commit(s) needsignoff: [Bug 6210] Choose framework on Merge <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6210> 06:52 cait hi kmkale :) 06:52 kmkale hi cait :) 07:24 alex_a bonjour #koha 07:25 cait bonjour alex_a :) 07:25 alex_a cait: :) 07:26 cait @wunder Konstanz 07:26 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 3.3�C (8:24 AM CET on November 14, 2011). Conditions: Overcast. Humidity: 94%. Dew Point: 2.0�C. Windchill: 3.0�C. Pressure: 30.37 in 1028.3 hPa (Steady). 07:26 cait brr. 07:26 alex_a @wunder marseille 07:26 huginn alex_a: The current temperature in Marseille, France is 11.0�C (8:00 AM CET on November 14, 2011). Conditions: Clear. Humidity: 76%. Dew Point: 7.0�C. Pressure: 30.27 in 1025 hPa (Steady). 07:27 alex_a brr. too 07:28 cait but I win :) 07:29 AmitG @wunder New Delhi 07:29 huginn AmitG: The current temperature in New Delhi, India is 27.0�C (12:30 PM IST on November 14, 2011). Conditions: Haze. Humidity: 37%. Dew Point: 11.0�C. Pressure: 29.98 in 1015 hPa (Falling). 07:29 AmitG @wunder Dehradun 07:29 huginn AmitG: The current temperature in Dehradun, India is 23.0�C (11:30 AM IST on November 14, 2011). Conditions: Haze. Humidity: 54%. Dew Point: 15.0�C. Pressure: 29.96 in 1014 hPa. 07:29 AmitG @wunder Bangalore 07:29 huginn AmitG: The current temperature in Bangalore, India is 27.0�C (11:30 AM IST on November 14, 2011). Conditions: Haze. Humidity: 25%. Dew Point: 10.0�C. 07:29 francharb morning #koha 07:30 AmitG heya francharb 07:30 wahanui francharb falls asleep easily at sea. Don't believe me? Just ask Brooke. 07:30 cait hi francharb :) 07:30 cait ok, bbiab 08:00 reiveune hello 08:01 kf back 08:06 asaurat hi! 08:06 kf hi asaurat, matts, sophie_m and hdl :) 08:07 sophie_m heloo kk :-) 08:07 sophie_m kf 08:07 matts hi kf 08:11 hdl hi kf 08:12 rangi hi hdl asaurat matts and sophie_m 08:13 sophie_m hi rangi 08:17 hdl hi rangi 08:19 clrh hello 08:20 kf hi clrh :) 08:23 AmitG heya hdl, kf 08:24 hdl hi AmitG 08:24 kf hi again AmitG 09:08 rangi wb slef 09:08 kf mornig slef 09:49 rangi @wunder wellington nz 09:49 huginn rangi: The current temperature in Wellington, New Zealand is 13.0�C (10:00 PM NZDT on November 14, 2011). Conditions: Partly Cloudy. Humidity: 72%. Dew Point: 8.0�C. Pressure: 30.09 in 1019 hPa (Rising). 09:49 kf @wunder Konstanz 09:49 huginn kf: The current temperature in Taegerwilen, Taegerwilen, Germany is 3.7�C (10:45 AM CET on November 14, 2011). Conditions: Overcast. Humidity: 92%. Dew Point: 2.0�C. Windchill: 4.0�C. Pressure: 30.36 in 1028.0 hPa (Steady). 09:50 kf brr 10:15 Carl Hello there! 10:15 Carl Carl in Sweden here 10:15 kf hi Carl 10:15 Carl I have a quesion about the relevance rankning in the Koha OPAC 10:16 Carl ascending or descending 10:16 magnuse hiya Carl 10:17 Carl You can change that under "Searching preferences" and "Results Display" 10:17 Carl but nothing happens 10:17 kf Carl: not sure relevance supports asc/desc 10:18 Carl but, in my installation it is ascending 10:18 Carl so the book I search for comes last in the list 10:19 Carl it should be the other way around 10:20 kf have you changed the setting since installation? 10:20 magnuse if you and koha/zebra have the same idea of relevance... 10:20 Carl yes 10:21 Carl I mean, the the possibility to change the results display under system preferences 10:22 Carl My idea of relevance rankning is that if you search for a title it should at least not be last in the results list :) 10:24 Carl So, should I talk to the IT guy about Zebra? 10:25 magnuse hm, it's probably got something to do with zebra 10:25 magnuse but i'm not sure how the relevance is calculated or configured 10:26 kf me niether 10:26 kf did you turn field weighting on? 10:27 Carl "field weighting", were do I do that? 10:27 kf in search 10:27 kf there are several paramters for zebra 10:28 kf I would try to turn off fuzzy search, stemming and auto truncation 10:28 kf it might give you better search results 10:28 Carl ok 10:29 magnuse yeah, that's worth a try 10:31 Carl hm, nothing changes 10:31 Carl but, It still seems to me that the problem is about the desc/asce-function 10:32 kf which version are you using? 10:32 Carl because the best hit is the last 10:32 Carl actually, uppgraded to 3.6 today! 10:32 Carl but I had the same problem with 3.2 10:33 kf hm 10:33 kf do other sorts work correctly for you? 10:33 dpavlin_away Carl: do you have more than 1000 results by any chance? Zebra ignores sort order with more than 1000 (but configurable in Zebra configuration) results 10:34 kf hi dpavlin :) 10:34 kf good idea! 10:34 * dpavlin just my 0.02$ :-) 10:37 magnuse yeah, good question 10:39 Carl no, just 23 10:40 magnuse dang ;-) 10:40 kf hm 10:41 kf have you tried turning off all the search parameters? 10:45 Carl ok, have to go for now 10:45 Carl thank you for your kind assistance! I'll be back... 10:46 kf bye Carl 11:47 kf marcelr++ 13:28 oleonard A very pleasant Monday to you all, #koha. 13:31 * jwagner thinks "pleasant" and "Monday" don't go together in the same sentence. But that's just me.... 13:47 kf hi oleonard 13:47 kf hi jwagner 13:47 jwagner hi kf 13:47 kf not worse than other days 13:50 hakim Hi 13:50 kf marcelr++ 13:50 kf h hakim 13:50 hakim How are you 13:50 hakim a quick question about Koha 13:51 hakim I couldn't find a translation of Koha in Dari/Persian 13:51 hakim how hard is it to translate it into these languages 13:51 hakim ? 13:51 kf it's a lot of work, but not hard 13:51 kf it's a lot of strings 13:52 kf hakim: have you seen translate.koha-community.org? 13:52 hakim what is koha coded with? 13:52 hakim what scripting language? 13:53 oleonard Perl 13:53 kf hakim: but you don't need to know perl for translating 13:53 kf hakim: we have a web interface ofr translation, or you can use an editor like poedit - you get a file with all strings in english and translate this into your language 13:54 hakim Movable type is written with perl I could translate it into Dari 13:55 oleonard But you don't need to know any code to translate, hakim 13:55 hakim i just edited all files in notepad and translated the interface into Dari 13:55 oleonard In fact if you try to translate Koha this way you won't be able to share the translation with others 13:55 jcamins_away hakim: that would not be a good way to translate Koha. 13:55 hakim Thanks jcamins 13:55 hakim one more question 13:56 hakim does koha source support unicode? 13:56 hakim i want to do a data entry in Dari language which is similar to Arabic 13:56 jcamins hakim: yes, you can enter data in Dari. 13:56 hakim also search for Dari phrases? 13:57 jcamins I am not sure how searching will work, though. 13:57 jcamins kf: do you know? 13:58 kf hakim, jcamins: I think it will require use of icu 13:58 hakim logically if I can do data entry in Dari i should be able to search for Dari in simple and advanced search modes. right? : Jcamins 13:58 kf like we did for hebrew 13:58 kf but it's possible 13:58 hakim kf: what is icu 13:58 wahanui i guess icu is a horrible monster that doesn't do what anyone expects. 13:58 kf hakim: not sure I can explain that right, and don't listen to wahanui 13:59 kf hakim: different type of indexing for the zebra search 13:59 magnus_afk hakim: wahanui is a bot trying to be clever ;-) 13:59 kf hakim: it requires changing a few files, but it can be done 13:59 jcamins hakim: are you with ACKU? 13:59 hakim jcamins: ACKU? 13:59 kf hakim: we use it for one of our libraries that has hebrew data - data entry works just fine 14:00 hakim kf: how about search? 14:00 wahanui search is, like, described as “ti,wrdl: chest †I assume 'ti' means title but what does 'wrdl' mean 14:00 jcamins Afghanistan Center at Kabul University. There was an e-mail on the list from someone at ACKU. 14:01 hakim jcamins: Not from ACKU, i'm with INEX technologies in Afghanistan 14:02 jcamins Hm. I don't think I met anyone there. 14:02 hakim I got the point that I can translate it into Dari but i'm still lost with searching section 14:02 hakim jcamins: have you been here? 14:02 jcamins hakim: the short answer is, we don't know how searching will work. 14:03 hakim any one has worked on Arabic translatoin? 14:03 kf I think there is an arabic koha 14:03 kf hakim: http://translate.koha-community.org/ar/ 14:04 hakim kf: thanks let me give it a try 14:04 kf hakim: I would try contacting the translators - we have a mailing list for translators too 14:04 kf mailing lists? 14:04 wahanui mailing lists are at http://koha-community.org/support/koha-mailing-lists/ 14:04 magnus_afk search? 14:04 wahanui search is, like, described as “ti,wrdl: chest †I assume 'ti' means title but what does 'wrdl' mean 14:04 magnus_afk wahanui: forget search 14:04 wahanui magnus_afk: I forgot search 14:05 kf http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate 14:05 hakim whanui: dont forget it 14:05 hakim it's important 14:05 kf hi sekjal :) 14:05 sekjal hi, kf! 14:05 jcamins hakim: There's someone who has gotten searching for Arabic records working, but I'm not sure if he's made any changes to make searches work. 14:06 hakim jcamins: how is he? 14:06 kf @later tell wizzyrea I noticed koha-translate is missing from the mailing liste page on kc.org :) (http://koha-community.org/support/koha-mailing-lists/) 14:06 huginn kf: The operation succeeded. 14:07 jcamins hakim: he used to go by the nik "genji," I think, but he changed his nick, and I don't remember the new one. 14:08 kf hakim: perhaps try a search for koha and arabic 14:08 kf in google 14:08 hakim i've tried 14:10 jcamins hakim: the best advice I can give is "try it with ICU," and see if it works. 14:10 hakim jcamins: i'm sorry, but what is ICU? 14:11 kf ICU is a library 14:11 kf kind of 14:11 kf it makes it possible to index your data in another way, different from the one koha uses as standard 14:11 kf so it requires a bit of change to the files 14:11 kf but it does work for some libraries and it's doable 14:22 Barrc Can anyone help me with a git question? I have added a coupld of new files (not changed an existing one) but when I commit it only picks up the files changed and not the new one? 14:25 sekjal Barrc: you need to add the files first: git add /path/to/file.pl 14:26 Barrc sekjal: Thanks - was following this: http://wiki.koha-community.org/wiki/Version_Control_Using_Git but there is no mention of adding the files! 15:01 wizzyrea mornin 15:03 magnus_afk kia ora wizzyrea 15:04 wizzyrea heyas, how's norway this afternoon? 15:05 magnus_afk @wunder boo 15:05 huginn magnus_afk: The current temperature in Bodo, Norway is 4.0�C (3:50 PM CET on November 14, 2011). Conditions: Mostly Cloudy. Humidity: 70%. Dew Point: -1.0�C. Windchill: -1.0�C. Pressure: 30.15 in 1021 hPa (Steady). 15:05 magnus_afk autumny, but cozy indoors 15:05 * magnus_afk just lit a fire on the hearth 15:06 kf hi wizzyrea :) 15:06 wizzyrea question, do the checkout notices pull their title info from the indexes or direct from the database? 15:07 kf all from the database 15:07 kf afaik 15:07 kf the notices 15:07 wahanui the notices is, like, another place that does multiselect 15:07 kf or do you mean the slips? 15:08 kf forget the notices 15:08 wahanui kf: I forgot notices 15:08 wizzyrea the checkout notices 15:08 wizzyrea the email 15:08 kf ah 15:08 kf afaik the database 15:08 kf but it's bad 15:08 kf because it can't do items 15:08 kf at least not in 3.2 - I have a ticket about that from one of my libraries 15:09 kf and they don't use items.content or <item> to create the list 15:09 kf it's def different than other notices 15:09 kf consistency++ 15:22 moodaepo @wunder 56001 15:22 huginn moodaepo: The current temperature in MSU Physics Dept, Mankato, Minnesota is 4.6�C (9:21 AM CST on November 14, 2011). Conditions: Mostly Cloudy. Humidity: 77%. Dew Point: 1.0�C. Windchill: 3.0�C. Pressure: 29.48 in 998.2 hPa (Steady). 15:24 ebegin moodaepo, there is a zipcode for the MSU Physics Dept ? 15:25 moodaepo ebegin: Heh I'm guessing that's the monitoring area zip code...it's not CERN : ) 15:26 ebegin moodaepo, yeah, make sense :) 15:26 ebegin @wunder montreal canada 15:26 huginn ebegin: The current temperature in Montreal, Quebec is 16.0�C (10:00 AM EST on November 14, 2011). Conditions: Mostly Cloudy. Humidity: 63%. Dew Point: 9.0�C. Pressure: 29.61 in 1003 hPa (Rising). 15:28 wizzyrea I'll just tell you, it's 9C here 15:28 wizzyrea :P 15:28 druthb @wunder 38401 15:28 huginn druthb: The current temperature in Spring Hill, Tennessee is 20.9�C (11:27 AM AST on November 14, 2011). Conditions: Mostly Cloudy. Humidity: 76%. Dew Point: 16.0�C. Pressure: 29.94 in 1013.8 hPa (Steady). 15:28 * wizzyrea waves at druthb 15:29 oleonard @wunder 45701 15:29 huginn oleonard: The current temperature in Ohio University, Athens, Ohio is 20.0�C (10:20 AM EST on November 14, 2011). Conditions: Mostly Cloudy. Humidity: 59%. Dew Point: 12.0�C. Pressure: 29.64 in 1003.6 hPa (Falling). 15:29 * druthb waves at wizzyrea 15:32 * ebegin "wunders" where in the world wizzyrea is ? :) 15:34 kf @wonder Konstanz 15:34 huginn kf: I've exhausted my database of quotes 15:34 wizzyrea @wunder lawrence, ks 15:34 huginn wizzyrea: The current temperature in Lawrence Live-Courtesy of the Khoury's, Lawrence, Kansas is 11.6�C (9:32 AM CST on November 14, 2011). Conditions: Clear. Humidity: 57%. Dew Point: 3.0�C. Pressure: 29.66 in 1004.3 hPa (Steady). 15:34 wizzyrea ah but my computer says (said) 9 a bit ago 15:35 kf @wunder Konstanz 15:35 huginn kf: The current temperature in Taegerwilen, Taegerwilen, Germany is 3.9�C (4:28 PM CET on November 14, 2011). Conditions: Overcast. Humidity: 89%. Dew Point: 2.0�C. Windchill: 4.0�C. Pressure: 30.27 in 1024.9 hPa (Rising). 15:36 ebegin 16.0�C is quite a nice day for a nov. 14th here in quebec 15:43 magnuse @wunder boo 15:43 huginn magnuse: The current temperature in Bodo, Norway is 4.0�C (4:20 PM CET on November 14, 2011). Conditions: Mostly Cloudy. Humidity: 75%. Dew Point: 0.0�C. Windchill: -1.0�C. Pressure: 30.15 in 1021 hPa (Steady). 15:43 druthb hi, magnuse! 15:43 magnuse o/ 16:11 reiveune à demain 16:11 kf time to leave :) 16:11 kf bye all! 16:22 wizzyrea anybody have a link to a very small library somewhere in either latin america, india, or africa? 16:22 wizzyrea I don't want big, I want as small as they come 16:22 wizzyrea but web accessible 16:36 oleonard I guess you're going to have to go start one wizzyrea 16:36 wizzyrea hmm 16:37 magnuse wizzyrea: check lib-web-cats or the wiki? 16:39 wizzyrea good call both. 16:39 * wizzyrea forgets about libwebcats 16:45 Barrc If I change/add an entry to a table in MySQL (for a new enhancement) which files do I need to edit (for a git commit). Is it just the updatedatabase.pl? Can I put it anywhere in that file? 16:50 Oak oh well 16:51 cait hi #koha 16:52 druthb cait, you just missed Oak. 16:58 cait oh 16:58 maximep Barrc: http://wiki.koha-community.org/wiki/Tutorial_for_Updating_Database_Files 16:59 oleonard ...with a couple of corrections 17:00 oleonard Barrc: When you're testing you can give the DBversion a real revision number, but when you submit leave the last set as 'XXX' instead of the incremented number 17:00 maximep yeah, this page really needs to be simplified and updated :/ 17:00 oleonard Barrc: And don't edit kohaversion.pl in your patch. Only in testing. 17:11 Barrc oleonard: Thanks - I'm having some trouble getting my head around git. Does everyone else find it easy at first!? 17:11 oleonard I didn't, but I like it now 17:12 jcamins Barrc: does *anyone* find it easy at first? ;) 17:12 Barrc Not just me then, good!!! 17:12 wizzyrea git is the best and worst friend you'll ever have. 17:12 cait hehe 17:13 cait I love git 17:13 wizzyrea ...until you hate it 17:13 cait but until you get the concept it's a bit hard 17:13 wizzyrea and then you love it again 17:13 cait hehe 17:13 wizzyrea ...until you hate it 17:13 * cait puts some lebkuchen/ginger bread in the middle of #koha 17:13 wizzyrea well, at least that's how I feel about it 17:13 cait i couldn#t resist at the super market 17:14 oleonard I usually avoid hating git by assuming it's smarter than me (which it is) 17:15 cait :) 17:15 Barrc My head starts expanding right up to explosion point whenever I sit down and look at git......:-) 17:16 wizzyrea i usually consult the koha wiki's documentation 17:16 wizzyrea there's a recipe in there for just about everything normal we do 17:16 oleonard I think a lot of git documentation makes the mistake of trying to make you understand *too* much about git right off the bat 17:16 wizzyrea *nod* I agree 17:16 oleonard I feel very comfortable with it having been taught specific tasks rather than a huge overview 17:16 wizzyrea like many things, it's better to start with a task 17:16 wizzyrea and apply the theory to the task later. 17:23 * oleonard still hasn't gotten to the theory part 17:25 sekjal directed acyclic graphs 17:26 wizzyrea sekjal, how covenient that you popped up 17:26 wizzyrea i have a QA request :) 17:26 wizzyrea bug 7207 17:26 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7207 normal, PATCH-Sent, ---, cnighswonger, ASSIGNED , Cannot export label batches 17:27 cait hehe 17:27 nengard good morning #koha I'm here in WA traininga new Koha library 17:27 nengard say hello 17:27 wizzyrea hi WA peeps :) 17:27 oleonard Hi new Koha library 17:27 wizzyrea < Kansas 17:27 oleonard < Ohio 17:27 * sekjal waves to the librarians from his home state 17:27 jcamins Hello from New York. 17:27 sekjal < MA, currently 17:28 * jcamins didn't realize that sekjal was from WA. 17:28 nengard he's not 17:28 cait hi :) 17:28 sekjal jcamins: yup 17:28 nengard alright back to work!! 17:28 nengard ttyl 17:28 cait from Konstanz, Germany :) 17:28 wizzyrea wait, us back to work, or them? 17:28 cait not sure 17:28 wizzyrea nengard is all crackin the whip on us 17:28 * cait will have dinner first 17:28 oleonard nengard should have demonstrated IRC's utility by forcing us to answer random Koha trivia 17:29 wizzyrea :) 17:29 cait hehe 17:29 wizzyrea yes, that would be more instructive wouldn't it 17:29 cait you know who would win that game 17:29 cait wahanui! 17:29 wahanui i am a bot 17:29 cait I know sweetie 17:29 cait wahanui botsnack mushroom soup with noodles 17:29 wahanui :) 17:30 druthb wahanui: cait? 17:30 wahanui That's Ms. Cait to you! 17:30 druthb ! 17:30 druthb wahanui: wizzyrea? 17:30 wahanui I LIKE SCIENCE! 17:30 * druthb giggles 17:30 wizzyrea Who was the first koha library? is <reply> Horowhenua Library Trust in New Zealand (http://www.library.org.nz) 17:30 wizzyrea Who was the first koha library? 17:30 * wizzyrea really wanted that to work. 17:31 * wizzyrea will keep trying with wahanui in private 17:31 wizzyrea i will coerce him with thin mints. 17:31 druthb the first koha library is <reply> Horowhenua Library Trust in New Zealand (http://www.library.org.nz) 17:31 cait first koha library is Horowhenua Library Trust in New Zealand 17:31 druthb first koha library? 17:31 wahanui Horowhenua Library Trust in New Zealand (http://www.library.org.nz) 17:31 * druthb wiggles her eyebrows 17:31 wizzyrea showoff. 17:31 wizzyrea ;) 17:31 wizzyrea <3 17:31 druthb wahanui: druthb? 17:31 wahanui She finally snapped, like we all knew she would. 17:31 cait and typing faster than me too :) 17:31 druthb lol 17:31 wizzyrea !! 17:32 oleonard first Koha library in the US is <reply> Athens County Public Libraries (http://www.myacpl.org) 17:33 wizzyrea first koha library in the US? 17:33 wahanui Athens County Public Libraries (http://www.myacpl.org) 17:34 wizzyrea squee! 17:34 cait :) 17:34 cait wizzyrea snack lebkuchen :) 17:34 wizzyrea nom nom nom 17:44 cait ok 17:44 cait plan for tonight... learn something about regex 17:45 druthb s/Columbia, TN/Konstanz/ #can I use regex to make a teleporter? 17:45 cait hmmmmm 17:45 jcamins cait: most useful thing I ever learned about regex: there are different types of regular expressions, and that's why all the documentation seems to say different things. 17:45 cait that would be nice 17:46 cait jcamins: that sounds confusing! 17:46 jcamins You probably knew that, but it took me years to figure that out. 17:46 cait no i didn't 17:46 * jcamins still can't use regular expressions with grep. 17:46 cait but I still hope the Learning Perl book will explain :) 17:46 cait me neither... we will see how it works out 17:47 cait I am in chapter 7 now , 7,8 and 9 are about regex 18:01 oleonard Nice comment to find in a Drupal module : "//THIS IS BAD.. fix before any release." 18:01 wizzyrea oh dear. 18:01 cait hmm 18:01 jcamins oleonard: was it released? 18:02 cait at least there is a comment... so we can assume the developer knew better 18:02 oleonard jcamins: It was 18:02 jcamins oleonard: well. That's unfortunate, isn't it? 18:03 * jcamins would suggest adding a build test for FIXMEs to Koha, but it would undoubtedly fail. 18:03 cait people would stop using FIXMEs I think 18:03 jcamins cait: yeah, but would they fix things? 18:04 jcamins (I know, probably not) 18:04 jcamins There are approximately 425 FIXMEs in Koha. 18:04 cait you gave the answer ;) 18:04 oleonard jcamins: I've often wondered about auto-filing one bug for each FIXME. 18:04 cait wow 18:04 cait I would like to see more bug fixing anyway 18:04 cait it's most of the time about new feature 18:04 cait s 18:04 cait and we have such bad bugs in bugzilla :( 18:05 * oleonard is unfortunately chasing bugs in this Drupal module instead of in Koha today 18:06 cait I was not talking about you Owen - you are fixing bugs like crazy :) 18:06 * jcamins is unfortunately busy on non-Koha stuff. 18:06 cait ... and I am trying to learn perl 18:06 * oleonard was just expressing his dissatisfaction with his current circumstances 18:07 cait I have no doubt you will hunt them down 18:07 cait the bugs in the drupal module 18:07 wizzyrea [off] oh my old.koha.org is still up 18:08 jcamins It's history! 18:13 NCARLibrary hey gang 18:13 NCARLibrary quick SQL question...i want this report to give me lost only, not missing. 18:14 NCARLibrary (hm...it's not pasting for me) 18:15 NCARLibrary is this thing on? 18:16 jwagner NCARLibrary, you're posting if that's what you mean 18:17 cait NCARLibrary: talking about paste.koha-community.org? 18:17 cait you can paste the URL when it's not working to paste into the channel 18:17 NCARLibrary ok, i'll do that. 18:17 NCARLibrary http://paste.koha-community.org/115 18:18 cait ok 18:18 cait I think you want some specific lost values 18:18 NCARLibrary yes 18:18 cait check your authorised value LOST 18:18 cait in the interface 18:18 NCARLibrary okay 18:18 cait and then 18:19 jwagner Missing is one of the lost values. You probably want to select on items.itemlost = 1 rather than !=0 18:19 cait items.iemslost in (your numbers, comma separated) 18:19 cait for those status you want to show up 18:19 jwagner Or as cait just said, list all the ones you do want :-) 18:19 jwagner and you don't need to link to the auth val table 18:19 NCARLibrary ah, i see. 18:20 NCARLibrary lemme try that. standby 18:20 NCARLibrary bingo! 18:20 NCARLibrary thank you, oracles. 18:21 cait np :) 18:21 cait yes, I think the last and is not necessary 18:22 cait hm or perhaps it is 18:22 cait if you want to get the right description 18:22 cait yeah, I think you need it 18:50 aarkerio hi! If I send a form in Koha with: <textarea name="ttcode"> 18:50 aarkerio Can I get it with: my $foo = $cgi->param('ttcode') ? 18:50 aarkerio or need I another library? 18:51 cait aarkerio: what do you want to do? 18:51 cait aarkerio: if there are other fields in that form already, try to see how it's done there 18:52 aarkerio I need save the value of ttcode in a MySQL table 18:52 cait I fear I am not fluent enough in perl to tell you 18:52 jcamins aarkerio: your code snippet should work, but I can tell you that you almost certainly don't want to be doing whatever you're doing. 18:52 cait i normally find somewhere where it works and copy/modify that :) 18:54 aarkerio I need to save scientific journal articles, I created the table "articles" in MySQL 18:54 aarkerio and now I want to code the CRUD process for that table 18:55 jcamins aarkerio: I would stress in the strongest way possible that this is not a good idea. 18:57 aarkerio well, I wanna become familar with Koha API, so I think this is a good way to know the CRUD process 18:57 jcamins aarkerio: having said that, if you insist on doing it, good luck! 18:58 jcamins aarkerio: the way to become familiar with Koha is not to write something that will be incompatible with every other installation of Koha. 18:58 jcamins At least, that's my feeling. 18:58 aarkerio my question is if I only need my $foo = $cgi->param('ttcode') in order to get POST values in an HTML form 18:58 jcamins I believe that will work, yes. 18:59 jcamins aarkerio: it's just standard Perl. :) 19:00 maximep of course you have to define $cgi :p 19:04 aarkerio cool!, and for debug $vars, do you recommend: print Dumper $vars; ?? 19:06 maximep sure, or you can use warn to send it to the log iirc 19:06 jcamins Better to use warn, I'd think. 19:07 jcamins aarkerio: what benefit do you expect to get from having a separate articles table instead of using the existing functionality to catalog articles? 19:08 aarkerio there is a functionality for in Koha for cataloging articles? 19:08 jcamins aarkerio: yes, create analytic records for each article. 19:09 aarkerio I didn't know that, there is a doc about it? 19:09 jcamins aarkerio: it's just standard cataloging practice. 19:09 aarkerio or a wiki? 19:09 wahanui a wiki is http://wiki.koha-community.org 19:09 jcamins aarkerio: I don't think there's anything about cataloging articles specifically in Koha. 19:09 jcamins Your catalogers should know how to do it, though. 19:11 aarkerio well, I will catalog journals using the ISSN number 19:12 aarkerio the situation is I have the articles data in XML format so I can create a Koha plugin to 1) read the XML 19:12 aarkerio 2) create the analytic record 19:12 aarkerio I will use the perl DOM libraries for XML 19:13 cait you will have to create marc records out of your xml 19:13 jcamins A much better option is to create an XSLT stylesheet to convert your XML into MARCXML analytic records. 19:13 cait and you want to look at 773 fields for the articles 19:14 oleonard sekjal: You're being far too pragmatic on the Mobile OPAC issue. The solution is obviously for 5 or 6 different people to develop on in isolation and then tell everyone it's ready, but no show anyone the code. 19:14 aarkerio but anyway I need save the XML of each article somewhere 19:14 aarkerio that is why I create the new MySQL table 19:14 jcamins aarkerio: yes, save it into a file, then convert it into MARC, then load the MARC into Koha. 19:14 oleonard In fact I think it's a game we just weren't invited to. Who can develop a mobile OPAC the most secretly? Go! 19:16 aarkerio yes, but the cataloguers are in four different places and I think is better save XML in a table using Koha API 19:16 aarkerio I think I can offer the code as Koha plugin for medical articles 19:16 jcamins aarkerio: well, I can't talk you out of this, so I will consider my responsibility here to have been discharged. :) 19:17 aarkerio well, I need C4::SQLHelper for MySQL CRUD, right? 19:17 cait aarkerio: the problem with your approach is indexing 19:17 cait you want to search for them later on I guess... 19:17 cait so you should not do it like that 19:18 cait make it part of your existing marc records for the serials, or make it separate records 19:18 jcamins aarkerio: probably not, no. I don't think anyone knows how to use C4::SQLHelper. 19:18 cait so zebra can pick up the information 19:18 jcamins aarkerio: your best bet is to read the rest of the Koha code, to see how it works, and based on that figure out what you're doing. 19:18 aarkerio my approach is: 1) gathering all XML articles in a table (this out of "koha") 19:18 wizzyrea question: what is the difference between a keyword search for evanov* vs evanov% 19:19 wizzyrea catalog* keyword search 19:19 jcamins wizzyrea: the first is for Zebra the second for MySQL. 19:19 aarkerio 2) Convert XML to analytical records linked using 773 "inside" koha 19:19 wizzyrea the net result of which is... 19:19 aarkerio 3) Delete the table with xml data 19:19 cait wizzyrea: I am with jcamins 19:19 wizzyrea (dumb question then, the results are different because...) 19:19 cait not sure how zebra handles % 19:19 jcamins wizzyrea: the first works as you expect, the second doesn't. 19:20 wizzyrea lulz, that's fair 19:20 wizzyrea ty 19:20 jcamins The second doesn't have a defined result. 19:20 wizzyrea gotya 19:21 wizzyrea i just told them 19:21 wizzyrea the canonical answer is: the first works as you expect, the second doesn't" 19:21 jcamins :) 19:22 * wizzyrea remembers the principle of least astonishment, boggles 19:22 * wizzyrea gives up 19:22 wizzyrea the principle of least astonishment is http://www.google.com/url?sa=t&rct=j&q=prinicple%20of%20least%20surprise&source=web&cd=1&ved=0CCoQFjAA&url=http%3A%2F%2Fen.wikipedia.org%2Fwiki%2FPrinciple_of_least_astonishment&ei=52nBTpLdLcji2QWEpfS3BQ&usg=AFQjCNFvxTstdT6MqctDDC3tPVBn5lh8Fw 19:22 wizzyrea forget the principle of least astonishment 19:22 wahanui wizzyrea: I forgot principle of least astonishment 19:22 jcamins Yikes! 19:22 wizzyrea the principle of least astonishment is http://en.wikipedia.org/wiki/Principle_of_least_astonishment 19:22 wizzyrea that was the principle of MOST astonishment 19:22 * jcamins is astonished by that URL. ;) 19:23 wizzyrea see, that was a case where I was astonished because what I expected didn't happen 19:23 * wizzyrea just learned this principle yesterday 19:28 * oleonard thinks Microsoft works under the Principle of most astonishment 19:28 rhcl Interesting to note that Eric Raymond, no less, has discussed the principle in a book. May have to dig out the book/section sometime. 19:28 rhcl "Applying the Rule of Least Surprise" from The Art of Unix Programming by E.S. Raymond 19:29 oleonard Microsoft: "Wouldn't it be great if a little box popped up every ten minutes to steal keyboard focus and trigger a restart?" 19:30 sekjal oleonard: everyone loves secret OPACs the best 19:30 * wizzyrea giggles maniacally 19:31 sekjal aarkerio: no, you definitely do not need C4::SQLHelper 19:32 aarkerio sekjal, thanks for answer, do you know a doc about how make the CRUD in Koha? 19:32 * oleonard will put all 7 mobile OPACs in a mixer and blend them for a smooth result 19:33 rhcl What about the IPACs? 19:33 cait 7?! 19:34 sekjal aarkerio: in your scripts, use C4::Context->dbh to create a $dbh 19:34 oleonard cait: Sorry, I meant 8 or 9. 19:34 cait I really don#t want to know, right? 19:34 * oleonard might have his numbers off 19:34 * cait goes back to her book 19:35 sekjal then my $sth = $dbh->prepare("SQL statement here"); 19:35 sekjal and $sth->execute(whatever, params) to execute it 19:35 sekjal this will give you all the selects, updates, deletes and such you need in the Koha DB 19:35 rhcl The college students want to use postgresql for their IPAC database. No reason not to, right? 19:36 aarkerio sekjal, coool! let me check the API and other koha code 19:37 sekjal aarkerio: if possible, it's better to use existing Koha subroutines for common functions like adding, modifying and deleting biblios, since that will catch various other bits of logic that a straight SQL statement won't 19:37 sekjal but, there isn't always a pre-existing subroutine, so going straight to dbh is sometimes necessary 19:48 rhcl If a db has a defined API, is it automatically an "intelligent db"? Is "intelligent db" itself a firm definition? 19:50 rhcl The idea of an intelligent db is that ideally the application should hit the API instead of directly manipulating the relational data in the db, right? Is this concept, if correct, relevant to abstracting the db in koha 19:50 rhcl ? 19:52 mustard yes, rhcl, that's exactly correct 19:52 rhcl hey, OK, thanks for the freedback 19:53 oleonard Handy. 19:53 cait rhcl: I don't know it :) 19:53 oleonard So is anyone else developing a mobile OPAC in secret? 19:53 sekjal rhcl: if we abstracted the Koha structure into a group of objects and their interactions, then yes, we could mask the relational layer, and just have an API 19:53 Ice_Station_Zebra Yes, we are. It's based on Koha 3.02 and we'll release it one year after it's live in productino 19:54 oleonard Thanks Ice_Station_Zebra, that sounds like a great idea! 19:55 rhcl There was a session (I think) on mobile OPACs at the last LITA conference. The slides might be online somewhere if that's any help. 19:55 jdavidb I'm just here to confuse you. 19:55 druthb Doesn't he always do that? sheesh...thought we ran that guy off.. 19:56 rhcl they comes and they goes 20:07 wizzyrea sekjal: re 7207 - the patches, if you look at the two I squashed together 20:07 wizzyrea one was to revert 20:07 wizzyrea the other was to change 20:08 wizzyrea so, the original bug 20:08 wizzyrea rangi fixed something to make perl critic happy 20:08 wizzyrea but it broke export 20:08 wizzyrea let me find the IRC log 20:09 sekjal wizzyrea: gotcha. My concern is whether the third line that was changed in the original patch shouldn't also be re-jiggered to fit the updated format 20:09 wizzyrea chris_n would have to speak to that 20:10 wizzyrea i personally wouldn't put anybody on master who uses labels with that bug in there. 20:11 sekjal yeah, it's a nasty one 20:15 wizzyrea here it is: http://stats.workbuffer.org/irclog/koha/2011-11-09#i_810914 20:17 wizzyrea I guess perhaps critic didn't get upset about the 3rd line? 20:18 NCARLibrary hey peeps. yet more sql challenges... 20:19 NCARLibrary http://paste.koha-community.org/116 20:19 NCARLibrary i used != as a "not equal to" 20:19 NCARLibrary but it doesn't seem to be working 20:20 sekjal wizzyrea: it's currently in a format that's Perl-Critic-happy, but the it's got the same basic problem as the two changed lines in the patch for bug 7207 20:20 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7207 normal, PATCH-Sent, ---, cnighswonger, ASSIGNED , Cannot export label batches 20:20 cait NCARLibrary: not in (comma separated list in '') 20:21 cait hm 20:21 NCARLibrary so i should use () around it? 20:21 cait but 20:21 cait you might want to use truncation too? 20:21 cait or is the itemnote only MISSING FL or inventory? 20:21 cait one word? 20:21 wizzyrea or the itemnote is MISSING FL inventory 20:22 NCARLibrary it's one phrase for a group of items "MISSING FL inventory" 20:22 NCARLibrary one thing 20:22 wahanui well, one thing is sure there is no AllowIssuingForPatronsWithOverdues in C4/Members.pm in the untarred source tree of koha-3.02.01.tar.gz 20:22 cait AH OK 20:22 cait sorry, caps 20:22 cait that sould workthen 20:22 cait I think 20:22 wizzyrea not like? 20:22 NCARLibrary so it should look like this itemnotes != ('MISSING FL inventory') 20:23 cait NCARLibrary: no, you don't need the () 20:23 maximep no, it was fine before 20:23 cait I was wrong 20:23 NCARLibrary oh 20:23 cait my head was still on checking a list of values... like we did before 20:23 maximep u can try <> instead of !=... but it should be the same :S 20:23 NCARLibrary it seems to be giving me items that DO have that phrase 20:24 cait how does the item note of one of those items look like? 20:24 cait is anything beofre or after the phrase? 20:24 NCARLibrary no 20:24 NCARLibrary i checked that 20:25 cait can you post an example? 20:25 cait for an itemnote that should not be in there? 20:25 NCARLibrary what if i just used = NULL instead of != to my phrase? 20:25 cait you could use itemnotes is NULL 20:25 NCARLibrary trying 20:27 NCARLibrary ooh! it looks much better. 20:27 NCARLibrary thanks. i'll go with it and come back if i run into issues. 20:27 wizzyrea we forgot to ask the most important question 20:27 wizzyrea "what are you trying to do" 20:27 NCARLibrary ? 20:27 wizzyrea :P 20:27 NCARLibrary ah yes 20:28 NCARLibrary We need to be able to periodically review items that've been marked LOST or MISSING (I created two reports). But there're 20:29 NCARLibrary a bunch of MISSING items that were marked thus whilst performing an inventory at our FL location. 20:29 NCARLibrary So, I wanted to exclude those from this report. 20:29 NCARLibrary seems like this will work now 20:32 NCARLibrary ciao 20:53 wizzyrea cait dear, are you about? 20:53 druthb cait went to bed, wizzyrea. 20:53 wizzyrea oh so she did 20:53 wizzyrea der 20:53 wizzyrea ty 20:53 druthb :) no worries. 20:54 * wizzyrea thinks we need to have a global koha party day 20:54 wizzyrea everybody is way stressed out. 20:55 huginn New commit(s) needsignoff: [Bug 7207] Cannot export label batches <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7207> 20:55 druthb wizzyrea++ 20:56 wizzyrea oy I really want that one fixed lol 21:02 sekjal does anyone in channel use the borrowers.ethnicity field in their installation? 21:02 sekjal is it even accessible through the interface anymore? 21:02 oleonard rangi would be the one to ask 21:02 oleonard It was a New Zealand library requirement 21:04 sekjal I'm seeing it's still got plenty of hooks in the code, but it seems like this is something that could now better be captured by Borrower Extended Attributes 21:04 sekjal I ask because I'm looking at a hack to repurpose it 21:04 sekjal to capture the patron's preferred language 21:05 sekjal (so notices can go out translated) 21:07 wizzyrea oo 21:07 oleonard Another jQuery UI modal cart test: http://screencast.com/t/j2XCnLwe 21:08 wizzyrea oleonard, that is quite lovely 21:08 wizzyrea i like your search, too. 21:08 wizzyrea are you telling us something? 21:08 wizzyrea ;) 21:09 oleonard That I'm crabby? 21:09 wizzyrea well ARE YOU? 21:09 sekjal word of advice to folks: take an aspirin before reading C4/Overdues.pm 21:10 * oleonard can't be that crabby around wizzyrea 21:10 wizzyrea @quote add <sekjal> word of advice to folks: take an aspirin before reading C4/Overdues.pm 21:10 huginn wizzyrea: The operation succeeded. Quote #164 added. 21:10 wizzyrea awww 21:11 sekjal I wish I could take the crowbar to that whole module (and the overdue and advanced notices scripts, while I'm at it) 21:11 * oleonard hands sekjal the crowbar, but no sack of money to go with it 21:11 wizzyrea i think libsysguy would agree with that sentiment 21:12 maximep Ive had several headaches from looking at Overdues.pm code haha 21:12 sekjal I'm not even sure it's worth trying to salvage... may make more sense to just replace it completely 21:15 * oleonard will have to refrain from being crabby all on his own 21:15 sekjal I need a way to get the appropriate overdue message by just passing the branchcode, patron category, and date due 21:16 * sekjal checks the overdue triggers table structure 21:17 bg hey there bshum 21:18 bshum bg: Hi there :) 21:18 bg how's good ole cold CT 21:18 bg @wunder 93109 21:18 huginn bg: The current temperature in K6LCM - Westside / Mesa, Santa Barbara, California is 18.0�C (1:16 PM PST on November 14, 2011). Conditions: Scattered Clouds. Humidity: 67%. Dew Point: 12.0�C. Pressure: 29.86 in 1011.1 hPa (Steady). 21:18 bg @wunder 06762 21:18 huginn bg: The current temperature in Watertown, Connecticut is 16.7�C (4:08 PM EST on November 14, 2011). Conditions: Overcast. Humidity: 58%. Dew Point: 8.0�C. Pressure: 29.84 in 1010.4 hPa (Steady). 21:18 bshum bg: Heh, dark and gloomy 21:18 bg oh not too bad temp wise 21:19 bshum bg: I think it's supposed to rain tonight. 21:19 bg bummer 21:24 NCARLibrary Question: Under authorized values, I have a category of LOST. Terms included in this are Missing, Lost, Lost and Paid For, etc. 21:25 NCARLibrary It seems that on the OPAC side, regardless of what subterm is chosen, an item will simply appear as "Lost" 21:25 NCARLibrary Is this correct? 21:25 wizzyrea I thought missing showed as missing, but I could be wrong 21:25 * wizzyrea checks 21:27 wizzyrea no I think you're right 21:27 wizzyrea in the staff client it shows the label 21:27 wizzyrea but in the OPAC it just says "lost" 21:27 wizzyrea or "item lost" 21:27 NCARLibrary right. any way around this? 21:28 NCARLibrary I'd love for it to say "Missing" on the OPAC side (when it's missing on staff client side) 21:28 wizzyrea 1s, i'm gonna check this for real :) 21:30 wizzyrea i'm sure there is a way, it might be easy, it might not be, but any way you do it will involve a change to the koha templates 21:30 wizzyrea (and I just verified, it does just say "item lost" 21:30 wizzyrea just curious, what type of a library are you from? 21:31 NCARLibrary Special Library (quite small) 21:31 wizzyrea also just curious, in your mind what is the difference to a patron between "missing" and "lost" 21:32 NCARLibrary good question 21:33 NCARLibrary lost sounds less hopeful i guess 21:33 wizzyrea (in my system, missing is an internal status - the library has misplaced it. Lost confers powers to charge the patron for the lost book) 21:33 NCARLibrary i see, right. 21:33 wizzyrea (to a patron, it doesn't matter) 21:33 wizzyrea (they can't check it out, it's dead to them, so to speak) 21:34 NCARLibrary and actually we don't charge patrons ever for anything 21:34 wizzyrea So maybe 21:34 wahanui somebody said So maybe was the condition which is not working 21:34 wizzyrea what you want is to replace "item lost" text 21:34 wizzyrea with "missing" 21:34 NCARLibrary right 21:34 wizzyrea which could probably be done wholesale pretty easily with jquery 21:35 NCARLibrary ? 21:35 wizzyrea if you wanted everything to say "missing" instead of "item lost" 21:35 NCARLibrary oh i see. so they all say missing or they all say item lost 21:35 NCARLibrary ? 21:35 wizzyrea right you got it 21:35 NCARLibrary ok 21:36 NCARLibrary well, i'll have to consult with my coworker. she's been keepin me comin back to the chatline here all day! 21:36 wizzyrea think about it and lmk, I can help you with that 21:36 wizzyrea :) I can relate. 21:36 NCARLibrary thx 21:37 wizzyrea yw 21:44 sekjal wow, schema.koha-community.org is wicked awesome 21:45 wizzyrea it totally is 21:45 wizzyrea eythian++ rangi++ nengard++ 21:45 sekjal I was going to draw out a database table connection chart, but it will do that for me, with up to 2 degrees of separation 21:45 * wizzyrea grabs sekjal and bounces and squees 21:45 wizzyrea it's so great! 21:46 * druthb takes pictures 21:47 sekjal http://schema.koha-community.org/tables/borrower_message_transport_preferences.html 21:48 sekjal trying to detangle that particular rat's nest 21:48 sekjal (see 2-degree graph) 21:48 wizzyrea oh gracious. 21:49 sekjal the categories and borrowers connections are fine... 21:50 sekjal message_attributes is just a list of all the patron-controllable messages in the system 21:50 sekjal message_transport_types is just a single column of controlled values 21:51 sekjal message_transports combines the message type with ways it can be delivered 21:52 sekjal I think we need to add a "priority" column to the borrower_message_transport_preferences table 21:52 wizzyrea "now" or "later" 21:53 wizzyrea ? 21:53 wizzyrea sort of thing? 21:53 sekjal if we hope to support anything more than email 21:53 sekjal we also need a "targeting" system for message transports 21:54 sekjal the email to use, the phone number to SMS, the address to mail to 21:55 wizzyrea I always wondered why we didn't just send email to people's phone using their phone's email address. 21:55 sekjal works well in the US, but not everywhere else 21:55 sekjal not all cell providers have SMS gateways 21:56 sekjal but I'd like to see that as one delivery option 21:56 sekjal that's the next trick 21:56 sekjal there are multiple ways to send an SMS 21:56 sekjal email, using an SMS::Send::Driver, via a third-party service like Talking Tech 21:57 sekjal Koha should be able to handle whichever 21:57 sekjal and have that be transparent to the patron 21:59 wizzyrea any kiwis about? 21:59 wizzyrea I have a question about HLT, dk if you can answer 22:03 wizzyrea nm :) 22:10 Brooke 0/ 23:17 rhcl @seen rangi 23:17 huginn rhcl: rangi was last seen in #koha 13 hours, 28 minutes, and 16 seconds ago: <rangi> @wunder wellington nz 23:30 rhcl talljoy 23:30 talljoy yes 23:32 rhcl for the past two hours everybody has been logging off. just thought it noteworthy that at this late hour (US) somebody was coming alive 23:32 talljoy i like the night. 23:34 rhcl humm 23:34 huginn New commit(s) needsignoff: [Bug 6303] Display Organisation and Parent Organisation names when viewing a borrower of type organistaion <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6303> 23:34 * talljoy notes she is not a vampire. just not a morning person 23:52 rhcl well, I am a hungry person