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)