Time  Nick      Message
12:04 kados     hey owen
12:04 owen      hi
12:04 kados     sorry ... I got a late start todaqy :-(
16:13 Genji     hiya all.
16:15 Genji     everyone is still asleep huh?
16:16 chris     busy at work (well the katipods are)
16:16 Genji     had a look at my finished feature request of rach's?
16:17 chris     havent had a chance yet
16:18 chris     maybe at lunch, or after work
17:06 kados     hey owen
17:06 kados     how's it going?
17:06 owen      Pretty well
17:06 owen      Wireless isn't working, but I plugged in.
17:07 kados     huh ... that's strange
17:07 kados     it should be set to dhcp
17:08 kados     owen: seen this? http://www.malevolent.com/weblog/archive/2005/05/01/add-google-maps/
17:08 owen      Yeah, I did see that.
18:17 indradg   chris, around?
18:17 chris     yo
18:17 chris     i think i just put a comment on your blog before :)
18:17 indradg   i see u left a comment in my blog
18:17 chris     yep
18:19 indradg   i'm trying to explore the GTK-Perl route
18:20 chris     yeah i went perl/tk
18:20 chris     cos its easier to get going (less libraries)
18:20 chris     and should run on windows too
18:20 indradg   GTK/Pango renders Indic scripts excellently... further I can always badger Owen Taylor to fix GTK/Pango stuff :P
18:20 chris     cool :)
18:21 chris     the idea behind the curses one, is a really low low bandwidth version
18:21 indradg   i agree
18:21 chris     i want to be able to give ppl lots of options
18:22 chris     so web based, curses, gtk etc
18:22 chris     whatever works best for your situation
18:22 indradg   actually that makes a lot of sense here in india... where a lot of the  library  dont yet have an Inet connection
18:22 indradg   s/library/libraries/
18:23 chris     yeah
18:26 chris     in fact there is no reason you cant have all 3 going at once, gtk in the main library, web based in one other, curses in the mobile library over a cellphone :)
18:27 indradg   yep!
18:28 indradg   btw these guys -> http://www.jadavpur.edu/academics/school_of_cultural_text&records.htm
18:28 indradg   are shortly going to start using Koha for creating catalogs in Bengali
18:28 chris     wicked
18:29 chris     you'll have to get them to do a press release so that russ can put it on the koha.org site :)
18:29 indradg   will do... have a meeting with these guys this week
18:31 indradg   when I showed them Koha on my laptop with bengali books cataloged they got sold abt the idea
18:31 chris     :-)
18:31 chris     nice work
18:31 indradg   thnx
19:31 shedges   indradg:  just saw your note abt the jadavpur library
19:31 shedges   cool!
20:04 Genji     rach is busy today i see. haven't seen any text from her.
23:35 Genji     so very quiet today. unusual. whats up?
23:42 rach      it's monday here @ katipo - our big meetings day, we have staff meeting in the morning, and lots of work comes out at that
23:42 rach      so we're usually pretty flat tack
23:42 rach      and it's still sunday overseas, so everyone else has a day off
23:42 Genji     ah, rach! hiya! seen my finished feature yet?
23:43 rach      usually a quiet day in #koha
23:43 rach      nope I haven't - URL?
23:43 Genji     opac.genjimoto.is-a-geek.org ... quicksearch dummy
23:43 Genji     very limited data that takes advantage of it.
23:44 Genji     oh.. and intranet.genji.is-a-geek.org koha/koha for looking at my new parameter's tables.
23:45 rach      sorry I'm getting a timeout
23:45 Genji     hrm.. oddd... really odd.
23:45 Genji     oh... apache isn't on...
23:45 Genji     wierdness..
23:46 Genji     hrm.. apache errored out.
23:49 Genji     okay. try now.
23:49 Genji     updated dyndns.
23:49 rach      getting somewhere now
23:49 Genji     had my adsl router go down last night.... due to brownout.
23:50 rach      hmm your categories don't work...
23:50 Genji     hrm?
23:50 Genji     what are you trying?
23:51 rach      ah it is a little thing
23:52 Genji     huh?
23:52 rach      when you pick "all categories" if you picked something else before - fiction for example, then it doesn't deselect
23:52 Genji     Yes. All categories overrides all other selection in the categories.
23:52 rach      ah so I expected it to unclick the radio button - but it didn't
23:53 Genji     hmm.... that would require some javascripting.... suppose i could do that.
23:53 rach      hmm - so do you reckon the branches work?
23:54 Genji     nope. problem with transfers, they don't update the marc tables.
23:54 rach      ah
23:55 Genji     i have implomented a $sqlstatement parameter into catalogsearch, so a devel could shove any sqlstatement they want into the search.
23:55 rach      so do you have to get that out of marc tables?
23:55 Genji     so... i could use the old db and get it that way.
23:55 rach      ah right
23:55 rach      what categories does this data know about/have?
23:55 Genji     thats the way i do itemtypes... since marc: catalogseach cannot search for more than one itemtype.
23:56 Genji     so far, two web links, one Adult fiction book, and one adult fiction cd.
23:57 Genji     have a look at the intranet for an idea as to how its designed, data wise.
23:57 rach      what would be a good thing for me to search on to see it :-)
23:57 rach      but can't get a second page of results using filter
23:57 Genji     the four data items are in title 'dummy'
23:58 rach      cool
23:58 Genji     for theosophy, the categories/subcat/itemtypes arn't relievant, since that's the TS data... and we never had this idea.
23:59 rach      cool
23:59 rach      fair enuff :-)
00:00 rach      so you going to give the second page a go too :-)
00:01 Genji     hmm... you mean the book detail search option screen?
00:01 rach      yep - that's the one with the subjects as well
00:01 rach      sorry - instead
00:03 Genji     hmm.. suppose i could. wouldn't take much, since the detail screen contains basically everything to implement the idea.
00:04 Genji     a template designer could do it all, im thinking.
00:05 Genji     so ya, ill do it.
00:09 rach      oh really
00:09 rach      sorry about the templater/htmler bit
00:12 rach      oh i just thought my comment would be a bit weird
00:12 rach      but now it's just more confusing
00:16 Genji     so... lets look at ndradg> yep!
00:16 Genji     <in
00:16 Genji     http://katipo.co.nz/gallery/koha2-4/search_ideas_details_2
00:16 rach      yep
00:16 rach      that's the puppy'
00:16 Genji     hmm.... so, those are all checkboxes, that add that specific item into a new query?
00:17 rach      well the theory here, is that you've found this one, and you either want ones like this, or in fact, not like this
00:17 rach      so that you check the words which are the ones you want
00:17 rach      and that makes a multi keyword querry
00:18 rach      and it does a new search I think - as I don't know if you can know what your previous one way
00:19 Genji     multi keywords? so, by selecting Title words 'everyday life' and search, it does a any text search on 'everyday life' ?
00:19 Genji     or does a title word result in a title search as well as anything else thats selected?
00:20 rach      erm - I dunno, what do you think is most useful
00:20 Genji     hmm... you'd get more results by doing an any text search....
00:21 rach      yep I was thinking they would be keywords I think
00:21 Genji     ah, little bit of coding involved. splitting up the title into words, and ignoring stopwords.
00:21 rach      yep
00:22 rach      because the collections often don't have good subjects
00:22 Genji     down below type/format, you'd have the category and subcat clicks as well.
00:23 rach      if it is in those yes - so it's a "do you want more junior fiction" choice
00:23 Genji     like.. this book would have Adult non fiction Book as its Type/format
00:23 Genji     Adult Non-Fiction book as its Subcategory.
00:23 Genji     err.
00:23 Genji     Adult non fiction
00:24 rach      where do the sub categories come from?
00:24 Genji     and Non-Fiction as its category.
00:24 Genji     all the information for cat, subcat and itemtype are in the books itemtype.
00:24 Genji     this particular book would have ANFB
00:25 rach      we haven't worked with a library with all those levels
00:25 Genji     i have created a categorytable and a subcategory table.
00:25 Genji     ahh... yes. Well.. it was your idea.
00:26 rach      hmm - ah you've made an extra level
00:26 rach      so I had super categories and just itemtypyes (well I meant to)
00:26 rach      http://katipo.co.nz/gallery/koha2-4/search_ideas_1?full=1
00:27 Genji     Had a look at my Category/subcategory editing interface?
00:27 rach      I did the other day
00:27 rach      for category at leat
00:28 Genji     the Subcategory one is a complete replica of the category one. Just uses the itemtypes for a different purpose.
00:29 rach      so it's another grouping of the itemtypes into super cateogories?
00:30 Genji     into itemtype groups.
00:30 rach      uname & pword for intrante?
00:30 Genji     default.
00:30 rach      ah no - koha
00:31 rach      ah right, so that's what we use as class
00:31 rach      I get it
00:31 rach      so we could actually drop itemtypes perhaps off the opac
00:35 Genji     if indeed, an item was in more than one category/subcat.
00:35 Genji     should be a rare thing, unless they use it badly.
00:36 Genji     just had this idea.. of a table... headings itemtype - subcategory - category
00:37 Genji     eh.. then again... scratch that idea.
00:38 Genji     you'd want to have multiple subcats covering a single item.
00:38 Genji     thats how my CD and Book and Video searches work.
00:38 Genji     CD searches 'Adult Fiction CD' all the way to 'Junior Fiction CD'.
00:39 Genji     err.. Junior non-fiction cd.
00:39 Genji     of course, could create yet another table called Mediatypetable.
00:40 Genji     fill that with media type information.
00:41 Genji     but that might be going overboard.
00:48 rach      sorry - people arrived
00:48 rach      no that's cool - was thinking the same thing
00:49 rach      without the extra table stuff, cause I don't think like that :-)
00:49 rach      OK I'm off to walk the dog
00:49 rach      as the cleaners have arrived
00:49 rach      and will shortly get loud
00:51 Genji     laters then.
00:52 Genji     ill put the media type thing into the mix as well.. and take media type out of subcat.
00:52 Genji     since it doesn't really belong.
00:52 rach      I don't recon you need to do aht
00:52 rach      that
00:53 rach      well you could
00:53 rach      but I'd probably want to run it over some real data to see if it's worthwhile
00:54 Genji     right. well.. since some real data hasn't taken advantage of my idea yet.....
00:54 Genji     sorry, your idea.
00:54 Genji     might be difficult to test, without some time assigning itemtypes to items.
00:55 Genji     ooooooo.
00:56 Genji     Kados wants to implement it in his installation.
00:56 Genji     if i get it so he can do so... we can test it on his real data.. yes?
02:30 paul      hello world !
02:30 FrancoisL hello paul...
02:30 hdl       hello
02:30 paul      aujourd'hui, c'est bugsquashing du coté de Marseille
02:31 paul      (et envoi d'un devis)
04:57 Genji     paul... still alive?
04:57 Genji     or your afk?
06:23 paul      Genji, back from lunc
06:29 Genji     hey
06:30 Genji     anything wrong with this statement?
06:30 Genji     select distinct m1.bibid from biblio,biblioitems,items,marc_biblio,marc_word as m1 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.word  like 'reincarnation') and (items.holdingbranch="WNTS")
06:34 Genji     wait.. think i realised it.
06:35 paul      needs a join between biblio & items.
06:35 Genji     need to put biblio.biblionumber=items.biblionumber somewhere in that.. i think....
06:35 paul      that's it ;-)
06:35 paul      (not exactly in fact)
06:35 Genji     hrms?
06:35 paul      otherwise, you won't get results when a biblio has no items.
06:35 paul      you have to do a
06:35 Genji     thats what i want, paul
06:35 paul      so it's OK
06:36 Genji     if a result hasn't got any items, i don't want to know about it, in this query.
06:37 Genji     Bingo! it works.
06:38 Genji     okay.. so i implemented a sqlstring parameter into catalogsearch() to allow the developer to add queries to it. Specifically... in my case, old db queries.
06:38 Genji     the ones that do get updated by transfers and can be searched for more than one itemtype and branch.
06:39 Genji     so, my current sidebar is fully operational. cool.
06:43 Genji     Thanks Paul
06:43 paul      you're welcome.
06:43 paul      do you plan to commit it to cvs (head)
06:43 Genji     not sure you did anything..
06:43 paul      or think it could be interesting for others ?
06:44 Genji     yes, definately interesting for others.
06:44 Genji     Kados likes it.
06:45 paul      so i'm waiting impatiently this bunch of code on koha-cvs mailing list ;-)
06:45 Genji     ill have to tidy my code, insert comments into it, then ill commit it to head.. if i can remember how.
06:45 Genji     hmm?
06:45 Genji     koha-cvs mailing list?
06:47 Genji     anyway. Bedtime. nighters all.
06:51 paul      GenjiZzZz, the koha-cvs mailing list where all commits are sent. So, subscribers to this list (heavy traffic, be warned), are aware of all changes. I'm a fan of this mailing list ;-)
08:48 gavin     hi all
08:54 gavin     would anyone have time for a short discussion about otpmising the web-based opac system?
08:54 paul      not a lot of ppl at this houre
08:54 paul      you should wait 2 hours to get USA too.
08:54 gavin     sorry, forgetting the time difference
08:54 paul      (for instance, it seems i'm alone ;-) )
08:55 paul      where are you located ?
08:55 paul      (/me in France, the dummy country that voted no yesterday)
09:04 gavin     Dublin
09:05 gavin     basically, i've done a fair few of these sort of things and it seems the opac end could be optimised quite a lot without too much work
09:07 gavin     (i'm not sure voting no makes france a dummy country, but that's a different issue)