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