IRC log for #koha, 2011-11-14

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

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

← Previous day | Today | Next day → | Search | Index

koha1