- Koha - lists.katipo.co.nz

Re: [Koha] Re: user comments
by Chris Cormack 03 May '02

03 May '02

> > > > Then of course you couldnt see if it was more popular with children or > > adults, or more often borrowed by institions or normal borrowers etc. <snip> > > If you need this information you can have a database table like the > user table but without the actual identifying features when the book is > returned you use that table to identify the borrower rather than the user > table. Round the DOB to year of birth, address to suburb and you can still > do most of your report writing. You might want to even wait until all > books borrowed by a particular day have been returned and use the same > anonymised record---then you can even still do "people who liked XXX also > like YYY" features (collaborative recommendation/filtering). This is true. Well if its feature thats needed by people, (anonymised data that is). I can certainly put it on the todo list. People could anonymise the data themselves by running something like update issues set borrowernumber=0 where returndate is not null; Thered be no way then you could match a borrower with a returned item. So short term fix you could run a cron job to anonymise your issues data each night, (or every 5 minutes even) Long term we can put it on the todo list, and we'll get an option to run with anonymised data into the configuration file Thanks Chris

1 0

RE: Setup costs for database using Microsoft Access
by Rosalie Blake 03 May '02

03 May '02

Hello Aroha, Coralie and Jennifer, First of all my apologies for non-response to your inquiries, and thanks to Jennifer for her response which said most of what I would have said. I broke my wrist (right, dammit!) on the day your inquiry hit the list, and I am only just back to fulltime work, and clearing the bottom of my email bin, now. So I am sorry, but in case it's still useful, here goes: On 18 Feb 2002, at 8:26, Coralie wrote: > > Kia ora koutou > > One of our local iwi research centres has asked me for some help with > putting together a funding application to setup a database for their > collection of reports, papers and maps - approx. 2000 items > (bibliographic detail and keywords). They have some experience with > Microsoft Access so are wanting to use this for the database. > > Has anyone done anything similar that might be help me guage the time > involved in setting up the database. > > Any suggestions would be greatly appreciated. > > Regards > > Coralie Campbell-Whitehead > Circulation and Extension Services Librarian > H.B. Williams Memorial Library Ph. 06 867 6709 > PO Box 747 Fax 06 867 9068 > Peel Street Email: > campbell(a)gpl.govt.nz Gisborne > http://www.gpl.govt.nz > On 18 Feb 2002, at 11:18, Jennifer Geard wrote: > Hi All, > > Aroha asked: > > ... I too have an iwi that is wanting to catalogue their library and > > is > wanting information similar to what you have asked. They are also > wanting to know what cataloguing programme would best suit their > needs. Does anyone know what is available on the market for small > libraries such as these and costs? > > Is Rosalie Blake on this list? Yes > Will she have replied by the time my message goes through? She should have, but she didn't! > > Two of the options to consider are Koha http://www.koha.org/ and > Greenstone http://www.greenstone.org/. Both are NZ-built: Koha by > Katipo in conjunction with Horowhenua Library Trust; Greenstone by > Waikato University's NZ Digital Library Project in conjunction with > UNESCO and the Humanity Libraries Project. Both are open-source, > issued under the GNU public licence. Both software packages are > available free of charge. > > Note that you'll need one computer that runs Linux if you want to run > Koha. Greenstone comes in versions for Windows and Unix (the Unix > version works on Linux). Koha for Windows NT is working now. I've taken the liberty of posting this reply to the koha list, where the techies who know about such things lurk. If you want to know more about running Koha under Windows, a message to the koha list will bring results, I'm sure. You may be interested that Te Wananga o Raukawa is installing Koha in their library in Otaki. Katipo is (I think) helping them with their installation and setup. You can contact katipo at www.katipo.co.nz and join the koha list by following links on that site. Cheers, Rosalie Blake Horowhenua Library Trust

1 0

RE: [Koha] A simple question about Class
by Yaogeng Cheng 30 Apr '02

30 Apr '02

>Here it gets tricky > >What you actually see as class on the screen on the item details page is an almagation of >3 fields. > >it goes classification,dewey,subclass > >Looking in the database for the above book >it has classification=J >dewey=612.82 >subclass= > >Hence J612.82 > >So for something like J612.32aa >You'd have >classification=J >dewey=612.32 >subclass=aa Yet, where should/could I put classification (J) into the database from your web interface? I did not find a field called classification or similar in koha web site. Please enlighten. Thanks a lot! Yaogeng

1 0

RE: [Koha] A simple question about Class
by Williams, Olwen - SAL 30 Apr '02

30 Apr '02

I'd be wary of this approach. I don't remember well what happens, but the dewey number is decimal for sorting, and the J will be in a separate field (but I can't remember where precisely. If you are using the Dewey system don't tamper with the datatype. On the other hand if you are using another system feel free to modify the type to suit, but there may be some other validation and formatting that has to change, for example formatting that puts leading zeroes on dewey numbers less than 100. -----Original Message----- From: Roger Buck [mailto:rog@saas.nsw.edu.au] Sent: Tuesday, 30 April 2002 11:07 To: rachel(a)katipo.co.nz Cc: Yaogeng Cheng; koha(a)lists.katipo.co.nz Subject: Re: [Koha] A simple question about Class # From the example koha db tables for <biblioitems.dewey>: dewey double (8,6) default NULL I think this means that the dewey entry is restricted to being a numeric data type (double precision - up to 8 digits displayed, with up to 6 digits following the decimal point)? As far as I know, the Dewey numbers are "labels" - their value is not used for computation - so the dewey number could be entered as a "text" data type? I'd guess that simply changing the db entry to something like: dewey varchar (16) default NULL might cover most of your needs? I am just a newbie at this stuff and the above is all just guess-work - so make modifications at your own risk ;^) R. _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

RE: [Koha] A simple question about Class
by Yaogeng Cheng 30 Apr '02

30 Apr '02

Rachel: Thanks a lot for your information. I have the following puzzle to be solved. >> In http://hlt.katipo.co.nz/, if you search by "Understanding your >> brain" by Title in the cataloge page. Then you click the TITLE >> Understanding your brain, You get the Class J612.82. How did J get >> into it? What did J represent and how can I input it into the Koha >> system? >As it's a non fiction book the class is the dewey number. You enter it either >as part of acquisioning a book or if you've already got an entry, by clicking on >the "modify" button in the group record - you get this page. >http://hlt.katipo.co.nz/cgi- bin/koha/modbibitem.pl?bibitem=93999&biblio=41244&submit.x= >41&submit.y >=22 However, if I enter J612.82 as part of acquisioning a book, Koha doesn't take it. By I do can modify it to J612.82 or a123 as you showed me(for that thanks a lot). It seems in acquisionting page, the dewey number can not take anything with letters. It can only take numbers. That is the reason why I ask how did this J get into http://hlt.katipo.co.nz/ dewey part? Thanks again! Yaogeng

4 3

RE: [Koha] A simple question about Class
by Williams, Olwen - SAL 30 Apr '02

30 Apr '02

I think the J is the class, in this case Junior non-fiction, and is concatenated with the Dewey number. -----Original Message----- From: Yaogeng Cheng [mailto:ycheng@neiglobal.com] Sent: Tuesday, 30 April 2002 10:37 To: koha(a)lists.katipo.co.nz Subject: RE: [Koha] A simple question about Class I use the simple acquisitions which seems to be the only way for my company to use, because we need to put a lot of our own CD into the library. Thanks, Yaogeng -----Original Message----- From: Rachel Hamilton-Williams [mailto:rachel@katipo.co.nz] Sent: Monday, April 29, 2002 3:34 PM To: Yaogeng Cheng Subject: RE: [Koha] A simple question about Class Hi > Can you let me know when this get solved? I would like very much to > fix this problem(Maybe the last one to me). Can you confirm what version of acquisitions your using please? Cheers Rachel > Thanks a lot! > > Yaogeng > > -----Original Message----- > From: Rachel Hamilton-Williams [mailto:rachel@katipo.co.nz] > Sent: Monday, April 29, 2002 3:25 PM > To: Yaogeng Cheng > Cc: koha(a)lists.katipo.co.nz > Subject: RE: [Koha] A simple question about Class > > > Hi > > > Thanks a lot for your information. I have the following puzzle to be > > solved. > > > > >> In http://hlt.katipo.co.nz/, if you search by "Understanding your > > >> brain" by Title in the cataloge page. Then you click the TITLE > > >> Understanding your brain, You get the Class J612.82. How did J > > >> get into it? What did J represent and how can I input it into the > > >> Koha system? > > > > >As it's a non fiction book the class is the dewey number. You > > >enter > > >it > > either > > >as part of acquisioning a book or if you've already got an entry, > > >by > > clicking on > > >the "modify" button in the group record - you get this page. > > > > >http://hlt.katipo.co.nz/cgi- > > bin/koha/modbibitem.pl?bibitem=93999&biblio=41244&submit.x= > > >41&submit.y > > >=22 > > > > However, if I enter J612.82 as part of acquisioning a book, Koha > > doesn't take it. By I do can modify it to J612.82 or a123 as you > > showed me(for that thanks a lot). It seems in acquisionting page, the > > dewey number can not take anything with letters. It can only take > > numbers. That is the reason why I ask how did this J get into > > http://hlt.katipo.co.nz/ dewey part? > > I suspect for HLT it actually came in with their big data import - but > they may also use a different acquisitions module to you - they use > the full acquisitions within the library, where as at the moment on > the demo site I think it is the simple acquisitions that is running. > > However it sounds like you might have found a bug between the two > systems > - because I'd have thought you could enter in the same info in both. > > Cheers > Rachel _____________________________________________________________ > > Rachel Hamilton-Williams Katipo Communications > WEBMISTRESS ph 021 389 128 or +64 04 934 1285 > mailto:rachel@katipo.co.nz PO Box 12487, Wellington > http://www.katipo.co.nz New Zealand > Koha Open Source Library System > http://www.koha.org > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > _____________________________________________________________ Rachel Hamilton-Williams Katipo Communications WEBMISTRESS ph 021 389 128 or +64 04 934 1285 mailto:rachel@katipo.co.nz PO Box 12487, Wellington http://www.katipo.co.nz New Zealand Koha Open Source Library System http://www.koha.org _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

RE: [Koha] A simple question about Class
by Yaogeng Cheng 30 Apr '02

30 Apr '02

I use the simple acquisitions which seems to be the only way for my company to use, because we need to put a lot of our own CD into the library. Thanks, Yaogeng -----Original Message----- From: Rachel Hamilton-Williams [mailto:rachel@katipo.co.nz] Sent: Monday, April 29, 2002 3:34 PM To: Yaogeng Cheng Subject: RE: [Koha] A simple question about Class Hi > Can you let me know when this get solved? I would like very much to > fix this problem(Maybe the last one to me). Can you confirm what version of acquisitions your using please? Cheers Rachel > Thanks a lot! > > Yaogeng > > -----Original Message----- > From: Rachel Hamilton-Williams [mailto:rachel@katipo.co.nz] > Sent: Monday, April 29, 2002 3:25 PM > To: Yaogeng Cheng > Cc: koha(a)lists.katipo.co.nz > Subject: RE: [Koha] A simple question about Class > > > Hi > > > Thanks a lot for your information. I have the following puzzle to be > > solved. > > > > >> In http://hlt.katipo.co.nz/, if you search by "Understanding your > > >> brain" by Title in the cataloge page. Then you click the TITLE > > >> Understanding your brain, You get the Class J612.82. How did J > > >> get into it? What did J represent and how can I input it into the > > >> Koha system? > > > > >As it's a non fiction book the class is the dewey number. You > > >enter > > >it > > either > > >as part of acquisioning a book or if you've already got an entry, > > >by > > clicking on > > >the "modify" button in the group record - you get this page. > > > > >http://hlt.katipo.co.nz/cgi- > > bin/koha/modbibitem.pl?bibitem=93999&biblio=41244&submit.x= > > >41&submit.y > > >=22 > > > > However, if I enter J612.82 as part of acquisioning a book, Koha > > doesn't take it. By I do can modify it to J612.82 or a123 as you > > showed me(for that thanks a lot). It seems in acquisionting page, the > > dewey number can not take anything with letters. It can only take > > numbers. That is the reason why I ask how did this J get into > > http://hlt.katipo.co.nz/ dewey part? > > I suspect for HLT it actually came in with their big data import - but > they may also use a different acquisitions module to you - they use > the full acquisitions within the library, where as at the moment on > the demo site I think it is the simple acquisitions that is running. > > However it sounds like you might have found a bug between the two > systems > - because I'd have thought you could enter in the same info in both. > > Cheers > Rachel _____________________________________________________________ > > Rachel Hamilton-Williams Katipo Communications > WEBMISTRESS ph 021 389 128 or +64 04 934 1285 > mailto:rachel@katipo.co.nz PO Box 12487, Wellington > http://www.katipo.co.nz New Zealand > Koha Open Source Library System > http://www.koha.org > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > _____________________________________________________________ Rachel Hamilton-Williams Katipo Communications WEBMISTRESS ph 021 389 128 or +64 04 934 1285 mailto:rachel@katipo.co.nz PO Box 12487, Wellington http://www.katipo.co.nz New Zealand Koha Open Source Library System http://www.koha.org

1 0

RE: [Koha] A simple question about Class
by Yaogeng Cheng 30 Apr '02

30 Apr '02

Can you let me know when this get solved? I would like very much to fix this problem(Maybe the last one to me). Thanks a lot! Yaogeng -----Original Message----- From: Rachel Hamilton-Williams [mailto:rachel@katipo.co.nz] Sent: Monday, April 29, 2002 3:25 PM To: Yaogeng Cheng Cc: koha(a)lists.katipo.co.nz Subject: RE: [Koha] A simple question about Class Hi > Thanks a lot for your information. I have the following puzzle to be > solved. > > >> In http://hlt.katipo.co.nz/, if you search by "Understanding your > >> brain" by Title in the cataloge page. Then you click the TITLE > >> Understanding your brain, You get the Class J612.82. How did J get > >> into it? What did J represent and how can I input it into the Koha > >> system? > > >As it's a non fiction book the class is the dewey number. You enter > >it > either > >as part of acquisioning a book or if you've already got an entry, by > clicking on > >the "modify" button in the group record - you get this page. > > >http://hlt.katipo.co.nz/cgi- > bin/koha/modbibitem.pl?bibitem=93999&biblio=41244&submit.x= > >41&submit.y > >=22 > > However, if I enter J612.82 as part of acquisioning a book, Koha > doesn't take it. By I do can modify it to J612.82 or a123 as you > showed me(for that thanks a lot). It seems in acquisionting page, the > dewey number can not take anything with letters. It can only take > numbers. That is the reason why I ask how did this J get into > http://hlt.katipo.co.nz/ dewey part? I suspect for HLT it actually came in with their big data import - but they may also use a different acquisitions module to you - they use the full acquisitions within the library, where as at the moment on the demo site I think it is the simple acquisitions that is running. However it sounds like you might have found a bug between the two systems - because I'd have thought you could enter in the same info in both. Cheers Rachel _____________________________________________________________ Rachel Hamilton-Williams Katipo Communications WEBMISTRESS ph 021 389 128 or +64 04 934 1285 mailto:rachel@katipo.co.nz PO Box 12487, Wellington http://www.katipo.co.nz New Zealand Koha Open Source Library System http://www.koha.org _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Question about 'Dewey' entry!
by Yaogeng Cheng 29 Apr '02

29 Apr '02

>I am not a librarian so hopefully someone will correct me - I think that the physical >location can be specified/determined from the 'Dewey' entry??? Can someone tell me if this is the right way to do it? -- How to locate the book/CD in the bookshelf when I find them by searching them in Koha web page.? If this is the right way to do it, How can I do it? -- where to input Dewey entry and how to retrieve it? Is this is not the right way to do it, then what is and how to do it? Thanks Yaogeng

2 1

A simple question about Class
by Yaogeng Cheng 29 Apr '02

29 Apr '02

In http://hlt.katipo.co.nz/, if you search by "Understanding your brain" by Title in the cataloge page. Then you click the TITLE Understanding your brain, You get the Class J612.82. How did J get into it? What did J represent and how can I input it into the Koha system? Thanks a lot! Yaogeng

3 2