May 2002 - Koha-devel - lists.koha-community.org

Forwarded on behalf of rosalie
by Chris Cormack 14 May '02

14 May '02

------- Forwarded message follows ------- To: rosalie(a)library.org.nz Date sent: Mon, 13 May 2002 23:26:57 -0700 From: "SOFYAN ROSYIDI" <sofyan.r(a)eudoramail.com> Send reply to: sofyan.r(a)eudoramail.com Subject: (No Subject) Organization: QUALCOMM Eudora Web-Mail (http://www.eudoramail.com:80) How to install KOHA on Windows operating system? thanks for your help, God bless u ---- Anyone want to take a crack at this? -- Chris Cormack chris(a)katipo.co.nz Programmer 025 500 579 Katipo Communications www.katipo.co.nz

1 0

Heads up
by Nicholas Rosasco 14 May '02

14 May '02

I'll be only sporadically connected to email for the next few days, just as a warning. I'm taking a look at the DocBook info (which is very new to me) I've found. Just a heads up, Nick

1 0

templates
by Tonnesen Steve 14 May '02

14 May '02

Still playing with templates... I've implemented paul's hierarchy suggestion of "theme" directories at the top. What I'd like to be able to do is specifiy an ordered list of preferred templates. For example, one might want to specify: local french default templates. If a template exists in the "local" theme, it will always be used. If a template exists in "french" but not in "local" the "french" template will be used. As a last resort, the "default" template will always be used. Should we develop a naming scheme for themes that are distributed with Koha, to keep them from squashing local or third party themes? Maybe koha-default, koha-french, koha-polish, etc? I'm thinking that Koha will probably ship with at least themes for various languages. I suppose the other option would be to have separate directories for shipped themes and local/third party themes? Steve.

1 0

website table structure
by paul POULAIN 14 May '02

14 May '02

I can't find the website table structure anywere ? can someone send it or tell where it's hidden ? -- Paul

1 0

query optimization
by paul POULAIN 14 May '02

14 May '02

Many queries are build with : (title like '$key[0]%' or title like '% $key[0]%') I was wondering why : * title like '$key%' is index optimizable * title like '% $key%' is NOT index optimizable. optimizable OR not optimizable === NOT optimizable. So the resulting query is not optimizable. So, what's the interest of such a string, as "title like '%'.$key.'%'" has the same result ? -- Paul

2 2

is it a bug ? or I need some explanations...
by paul POULAIN 14 May '02

14 May '02

Hi, I'm working on koha-cvs. I've found a technical bug which hides maybe a functionnal problem. Let me explain : Acquisition. I search a supplier (one I've added recently). It shows a basket (HLT-1064, created 3 days ago), which I click on. I go to basket.pl. This basket contains 1 line, for an item called "madeleine samedi2", qty=1, $est=7 (ok, that's the item I had added. It was a new biblio) When I click on the title, i go to newbiblio.pl. "92536 - Order Detail". Item barcode/Actual cost/Invoice number is empty ( ?? I filled them at the first order). When I validate, I get an error => acquisition.pm due to addorder.pl error : at line 61, $bibitemnum=newbiblioitem($bibnum,$itemtype,$isbn); should be : $bibitemnum= &newbiblioitem({ biblionumber => $bibnum, itemtype => $itemtype?$itemtype:"", isben => $isbn?$isbn:"" }); (thanks to use strict here, it must be a long time ago bug...) Now, i get no technical bug, but... a new "biblioitems" record is created. I think it's a bug, but can someone explain me what's supposed to do the title link in basket.pl. Thanks -- Paul

2 2

Re: [Koha] schema question
by Pat Eyler 13 May '02

13 May '02

Stuart, I'm forwarding your message to the development list where it stands a better chance of being answered. If you're interested in implementing functionality such as this, you may want to subscribe to the development list. thanks, -pate On Mon, 13 May 2002, <s.yeates(a)cs.waikato.ac.nz> wrote: > > Hello > > I've got a couple of quick questions about the Koha database schema. I think I've worked it out, but just want to double check. I'm working from the CVS version and data. > > I'm interested in implementing a collaborative recommendation feature which allowed users to see which books other people who borrowed the current book had also borrowed. Both Amazon and Barnes and Noble use a similar feature. > > In English the query I want is "Which books have been lent to the most people who have also borrowed the current book?" With the restriction that the books I recommend must be available for lending from the current library (it's pointless recommending a book that's not there) and must have more than N borrowers in common with the current book (to protect the privacy of borrowers, N is set to 5 or 10). > > Logically what I want to do is a join across biblio--> items--> issues--> borrowernumber--> issues--> items--> biblio with SELECT, a COUNT and a SORT. This, of course, gives huge intermediate tables, so I'd have to do several SELECTs as I go. > > I may also need to factor in a component of "how much has book A been borrowed by borrowers of book B compared to all other borrowers" to prevent very popular items (think Harry Potter) being recommended for every possible book. This effect would be similar to tf-idf ranking from classical information retrieval. > > My questions are: > (1) How do I tell whether a book is 'available'? I think I need to check the items table and make sure that stack, notforloan, itemlost and wthdrawn are all zero does this sounds right?. > (2) I don't understand the distinction between items and biblioitems > (3) How to I differentiate between children's and adult's books, between fiction and non-fiction? > (4) Would collaborative recommendation be useful in a small library catalog? > (5) Would the small incursion of user privacy be acceptable in a small public library? > > thanks for your help > stuart > > > > > -- stuart yeates <s.yeates(a)cs.waikato.ac.nz> aka `loam' > "To err is human--but it feels divine." -- Mae West > X-no-archive:yes > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

1 0

templating
by Tonnesen Steve 13 May '02

13 May '02

After a bit of playing with HTML::Template I have the following proposal Templates stored in includes directory under templates subfolder, each module (ie search, circ, catalog, etc.) has another subfolder, then another subfolder for each template, and then subfolders for each version of that template. Includes Templates Search Opac Search default.tmpl polish.tmpl french.tmpl local.tmpl Librarian Search default.tmpl polish.tmpl french.tmpl local.tmpl Opac Results default.tmpl Librarian Results default.tmpl We could then have a preference order for choosing templates, ie: local french default If a local template is available, it is used first, then the french template, falling back on the default template if no other is available. I don't know if this is too complicated, or too simple. What do we do if we have three different "default" opac results templates? What about a per-user preference for different templates? Maybe language should be dealt with completely separately... Just airing some thoughts... Steve.

5 4

Have fun...
by Nicholas Rosasco 11 May '02

11 May '02

No objections having been recorded .... The log of the meeting (at least until it wound down and I left) is at http://etome.net/Koha/minutes/meeting-Koha.txt if anyone wants to read something like 3/4 hours of IRC :) -- Simon said he'd get a who-does-what email out soon based on the meeting (thank heaven, as at least I was running principally on caffeine!). Nick

1 0

Double checking m'self
by Nicholas Rosasco 11 May '02

11 May '02

I've doubled checked my email, and I think I've updated (maybe not prettily, but updated) the Wiki in spots based on recent requests and the best version of the working list for the current version. Please tell me if you want anything else in there in the short term, as I may go back an clean things up/de-cruftify. Nick

1 0