- Koha - lists.katipo.co.nz

biblio vs. biblioitems
by Tonnesen Steve 13 Dec '00

13 Dec '00

Why is there a biblio table and a biblioitems table? Is there a one-to-one correspondence between items in the two tables, linked by the biblionumber fields? If this is the case, what is the purpose of the biblioitemnumber field? Steve.

3 2

MARC Records
by Tonnesen Steve 12 Dec '00

12 Dec '00

MARC records have an astonishing amount of detail, both in terms of data about the book, as well as ways in which the data can be described. I'm wondering how I should handle the first difficulty: subject headings. MARC records have several different entries for subjects: 650 Subject added entry -- Topical term Subjects like Mammals, Nuclear Warfare, Law, Alcohol, Child Welfare, etc. Appears to be the most common type of subject entry, at least with my data. 651 Subject added entry -- Geographic name Subjects like Canada, Rome, Moon, China, British Columbia, etc. 600 Subject added entry -- Personal name Subjects like Plato, Helen Keller, Charlemagne, etc. In addition each subject entry also specifies a source "system" such as Library of Congress Subject Headings or Sears Subject Headings. Obviously Koha doesn't have this complexity of subject headings, and probably doesn't need it, but I'm suspecting that we probably don't want to mix subject headings from different cataloging systems. Any possibility of adding a field to bibliosubject to specify a subject heading system used? Also, should I be adding any subject headings gathered from MARC records to the catalogueentry table (which I assume is used to deter librarians from adding new, conflicting subject headings like "Cows" and "Bovines"). I also have a request. Could people send me some samples of their MARC records so I can do some sanity checking? A lot of my MARC records are not from "formal" sources, but were hand entered by the librarian here. I'm also curious to know how librarians typically use commercial CDs of MARC records. Do they import all of the records into their library system at once, or just import records for books they hold? How are the MARC records typically stored on a CD? Is it just one big file full of MARC records? Steve.

3 2

MARC Records
by Tonnesen Steve 12 Dec '00

12 Dec '00

Is anybody working on supporting Marc records at all? I've written a short perl script that will parse the data in a Marc records file, and could probably write something up that would insert records into the Mysql database, if work isn't being done on this already. How are Marc records normally handled? Is biblio data entered in only for books that the library holds, or is an entire CD full of biblio data loaded into the library database? I'm thinking that a new table should be added that will hold the entire Marc record for a bibliography, as the Marc record will certainly contain more info than the Koha Mysql tables currently will contain. Storing the Marc records would mean that the record itself could be parsed and displayed on the screen for each biblio if more info was desired. Steve Tonnesen.

2 1

Installation Log
by Tonnesen Steve 10 Dec '00

10 Dec '00

I'd like to post my log regarding installing Koha both to document my experience and to get some feedback on snags I'm hitting: Steve Tonnesen Network Administrator Coast Mountains School District Terrace, BC CANADA ---- 1. Installed required Debian packages: install mysql-base, mysql-server, mysql-client, libmysqlclient6 packages install dbd and dbi packages libdbi-perl libdbd-mysql-perl install libdate-manip-perl package 2. downloaded and untarred koha-1.06.tar.gz databaseinstall.sh mysqlrootpass Koha kohausername kohauserpass This script created the database, tables, and access account perfectly. 3. Edited scripts/C4/Database.pm with kohausername and kohauserpass Also had to set name of database to 'Koha' <-- wasn't documented in INSTALL file 4. Edited scripts/C4/Output.pm set $path to location of includes I used /usr/local/koha/librarian/htdocs/includes 5. Copied C4 directory to /usr/lib/perl5/5.005/i386-linux 6. Created virtual servers in apache's httpd.conf: ------------------------------------------------ <VirtualHost 192.168.10.230> ServerName opac.cmsd.bc.ca DocumentRoot /usr/local/koha/opac/htdocs/ ScriptAlias /cgi-bin/ /usr/local/koha/opac/cgi-bin/ </VirtualHost> <VirtualHost 192.168.10.231> ServerName koha.cmsd.bc.ca DocumentRoot /usr/local/koha/librarian/htdocs/ ScriptAlias /usr/local/koha/librarian/cgi-bin/ </VirtualHost> ------------------------------------------------ 7. Created koha directories in /usr/local/ /usr/local/koha/ /usr/local/koha/opac /usr/local/koha/opac/htdocs/ /usr/local/koha/opac/cgi-bin/ /usr/local/koha/opac/cgi-bin/koha/ /usr/local/koha/librarian/ /usr/local/koha/librarian/htdocs/ /usr/local/koha/librarian/cgi-bin/ /usr/local/koha/librarian/cgi-bin/koha/ 8. Copied files cp -a koha-1.06/opac-html/* /usr/local/koha/opac/htdocs/ cp -a koha-1.06/scripts/*.pl /usr/local/koha/opac/cgi-bin/koha/ cp -a koha-1.06/intranet-html/* /usr/local/koha/opac/htdocs/ cp -a koha-1.06/scripts/*.pl /usr/local/koha/librarian/cgi-bin/koha/ cp -a koha-1.06/scripts/acqui /usr/local/koha/librarian/cgi-bin/koha/ 9. Populated Database Tables: insert into aqbookfund values ('1', 'Annual Book Budget', 'DIST'); insert into aqbookfund values ('2', 'Fund Raising', 'SCH'); insert into aqbookfund values ('3', 'Textbooks', 'SCH'); insert into aqbudget values ('1', '2000-12-01', '2001-12-01', 5500); insert into aqbudget values ('2', '2000-12-01', '', 1200); insert into aqbudget values ('3', '2000-12-01', '2001-12-01', 8000); insert into branches values ('STWE', 'Stewart Elementary School', '4523 Sea Way', 'Stewart, BC', 'V0T 1W0', '250 636 2241', '250 636 2544', 'jsnair(a)cmsd.bc.ca', 0); insert into branches values ('SHE', 'South Hazelton Elementary School', '4521 21st Ave.', 'South Hazelton, BC', 'V0J 2R0', '250 842 6688', '250 842 5153', 'stonnesen(a)cmsd.bc.ca', 0); Some problems that I have encountered thus far: 1. When adding entries to basket, link to supplier points to whitcouls.html which is supposed to be a demo page, I gather, but doesn't exist in any case. 2. When viewing basket, total is always $16.95 (hard coded in basket.pl) and subtotal, gst and total are always blank. 3. When receiving an order, I can select the book that was received from the order and enter the appropriate information, but clicking on the "Save Changes" link on the next page returns an error (tries to load /cgi-bin/koha/acqui/, which is a directory, not a script).

2 1

RE: [Koha] Card Numbers
by Williams, Olwen - SAL 06 Dec '00

06 Dec '00

Hi there, I was involved a while ago in some programming on Koha. It's a standard check digit routine. Base 11 from memory. Horowhenua are supplied with the barcodes, but writing a program to generate numbers is an easy task (or you can change the algorithm seeing as you have access to the source). More years ago than I'll own up to it was the first task I was given as trainee programmer. -----Original Message----- From: Tonnesen Steve [mailto:tonnesen@cmsd.bc.ca] Sent: Thursday, 7 December 2000 06:26 To: koha(a)lists.katipo.co.nz Subject: [Koha] Card Numbers Here's my first question about Koha. How are the card numbers generated? I looked through the code and found the algorithm for checking validity of card numbers and determined that 123456789 was a valid card number, but how does one normally generate these? :) Steve. _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Card Numbers
by Tonnesen Steve 06 Dec '00

06 Dec '00

Here's my first question about Koha. How are the card numbers generated? I looked through the code and found the algorithm for checking validity of card numbers and determined that 123456789 was a valid card number, but how does one normally generate these? :) Steve.

1 0

Re: Koha
by Rachel Hamilton-Williams 05 Dec '00

05 Dec '00

HI Rob - Rosalie passed your message on to me "Open Source" is a particluar type of free software. The speach on the website (as all public speaches are) is perhaps a little simplistic. Open Source software means that you give away the source code to the software - uncompiled. I don't think that's what you do is it? I liken it to the difference between giving away a cake (free software) and giving away the recipie to make the cake (open source software). It means that any other person could take our source code, make changes too it, and then give it away themselves or even sell it (although there are some cavets in our license). Anyways, I did check very carefully before claiming to be the first "Open Source Library Management System" in the world - and as far as I know we actually are - but the key thing there is open source - not free, I certainly wouldn't claim that at all! I hope that clears up the misunderstanding. I do think it's great that you're giving away your software for free, so I hope it's all going well for you Cheers Rachel > If that is that so, then I think your claim of a world first is a bit > ambititious. I think that my statement is probably a bit ambiguos - trying not to be too wordy and took a few to many out perhaps, always tricky when it's got a mixed audience :-) > I heard that you had thousands of downloads. We stopped counting the > downloads for two reasons, 1) there were heaps, 2) it is available on > a number of servers around the world where we can't track downloads. That sounds great for you. We were pretty chuffed at our number of downloads in such a short time (that was in the first month or so) > At least it is nice to know that he first 2 "open" and free library > programs available on the 'net both came from New Zealand! There is greenstone too which is an open source digital library system - www.nzdl.co.nz > Would you like me to put a link to your page on our Athenaeum Light > page? I believe that we should make it easy for users to find the free > software. That would be fabulous thank you - your software seems aimed at school libraries whereas ours is more public libraries - so that would seem a nice synergy. We are still really sorting out the Koha site, but I'm sure that over the christmas holidays I'll do a bit more work on it and can return the favour. Cheers Rachel _____________________________________________________________ Rachel Hamilton-Williams Katipo Communications WEBMISTRESS ph 025 300 825 or +64 04 389 1285 mailto:rachel@katipo.co.nz PO Box 7039, Wellington http://www.katipo.co.nz New Zealand

1 0

Koha mentioned in Biblio Tech Review
by Bob Pearson 04 Dec '00

04 Dec '00

Koha gets a mention in Biblio Tech Review. http://www.biblio-tech.com/html/koha.html Bob Pearson

1 0

Re: [Koha] (Fwd) Koha
by Stuart A Yeates 04 Dec '00

04 Dec '00

Rob said: > Someone else said: > > Rachel We recommended to the library that they release the > > software as "Open Source". That means that anyone else can > > download the software and run it up on their machine without > > paying either us or Horowhenua Library Trust a cent. > > > > Rosalie Not just for the glory (though this is a world > > first)! > If that is that so, then I think your claim of a world first is a bit > ambititious. > > We've been giving away our school library software (Athenaeum Light) > for 3 years now, over the internet. No strings. All passwords. Savvy > users can modify the code, if they have the knowhow and tools. It is > certainly different to what you have, but the basic concepts are the > same. I think the 'world first' was referring to the open source nature of the project see . It is indeed great to hear that other people doing Open Source libraryware. We at the New Zealand Digital Library (http://www.nzdl.org) have been producing Open Source for fully digital libraries since 1995. We deliberately target low end humanitarian and similar organisations, with support for many languages (including the right-to-left reading order and large character sets), platforms back to win 3.11 and no propriortry software needed. See http://www.gnu.org/ for a definition of what we mean when we say open source. While there's a difference between digital library software and library automation software (the former deals with electronic documents the later with physical documents), I imagine that there are many similarities. stuart -- stuart yeates <s.yeates(a)cs.waikato.ac.nz> aka `loam' "Oh, havoc," cried Pooh, as he let slip the heffalumps of war. X-no-archive:yes

1 0

web interface
by Sharon Cornwall 03 Dec '00

03 Dec '00

We operate our online catalogue using Inmagic DB/Textworks. Would it be possible to use Koha to operate an Intranet using Inmagic, or is it necessary to use the Koha catalogue also? Thank you Sharon Cornwall Nurses Librarian Health Waikato Library Health Waikato Ph: 07 8398899 ext. 8166 Private Bag 3200 Hamilton Fax: 07 8398897 New Zealand

2 1