- Koha - lists.katipo.co.nz

RE: [Koha] import question
by Williams, Olwen - SAL 09 Jul '03

09 Jul '03

Maybe I can shove my 2cents worth in here, since I was involved with the database design. There were sever reasons for the design. Firstly it was good database normalisation to no repeat information. Secondly it made reserves more flexible. If I reserve "Return of the King" I don't care if it's a Hard or Softback. So a reserve could give either because the would be the same biblio, but different biblioitems. On the other hand I might require a large-print version, and in this case the reserve would specify the particular biblioitem. There may be two of those paperbacks. These are each items, and when I take one out the item is what's recorded. It has an accession number. When I bring it back it records against the item code. I had doubts about this structure at first, and would have made it 2 levels based on my little library experience, but I was persuaded to do it this way, and I think it is a good type of structure to use. Olwen Williams olwen.williams(a)safeair.co.nz -----Original Message----- From: Chris Cormack [mailto:chris@katipo.co.nz] Sent: Wednesday, July 09, 2003 11:06 AM To: Derek Dresser Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] import question On Tue, Jul 08, 2003 at 03:37:51PM -0400, Derek Dresser said: > hello, > Hi Derek > I am working on setting up 2.0.0pre1. It installs fine and I am using the > bulkmarcimport.pl script to import ~8,000 biblios in USMARC format from our > old Winnebago system. So far so good. They seem to import fine. I can > query the database and see the data. Excellent sounds good so far :) > > Now I seem to have 8,000 biblios, but no items. It seems that a biblio is a > description of a possible book, but I actually need some items in my catalog > to be able to check them in and out. Is this correct. Can someone give a > brief explanation of the difference between a biblio, biblioitem, and item > in the database and give me an idea of how I can actually convert those > 8,000 biblios to books? > OK, here goes :) The way the koha orignal database was built was to separate data about say a book (or a video, or a serial etc) into 3 parts. To demonstrate, ill use The Return of the King (cos the premiere for the movie of this will be in wellington where i live :-)) 1/ biblio = which contains information such as title, subtitle, author, copyrightdate, abstract. And links to the bibliosubject and additionalauthors tables to hold subject information. You can see that information here http://hlt.katipo.co.nz/cgi-bin/koha/detail.pl?type=intra&bib=12180 Login:hdl pass:testing In the biblio box on the left. 2/ biblioitems, this is the next level down, and biblio can 'own' one or many biblioitems. Biblioitems hold information such as itemtype, dewey classification, publication date. We can see this more easily here http://hlt.katipo.co.nz/cgi-bin/koha/moredetail.pl?type=&item=&bib=12180&bi= 13371 (where the group is what we call the biblioitem) or here http://hlt.katipo.co.nz/cgi-bin/koha/moredetail.pl?type=&item=&bib=12180&bi= 28772 So in this example, we have one biblio, which has 2 biblioitems. now onto part 3 3/ Items Items hold item specific information, like which branch the item is at, how many times its been issued, replacement cost etc. http://hlt.katipo.co.nz/cgi-bin/koha/moredetail.pl?type=&item=&bib=12180&bi= 28772 the thee boxes headed barcode are the items. So we have 1 biblio, with 2 biblioitems, 1 of which has 1 item, and one of which has 3 items. > Sorry, I'm a computer guy, not a library scientist.... but I'm learning ;-) > Me too :) Thats probably why it was done this way. It didnt make sense to us, to replicate information. IE we didnt want to have 2 biblios for the return of the king in this case, with the same author the same title, but the itemtype, and number of pages and classification being different. Or to have 4 items 3 of which contained a lot of the same stuff (all information about the F free fiction biblioitem) and one which contained the information about the talking book item. So this intermediate level, biblioitem was introduced. I hope this helps explain things a bit, if not, let me know and ill try and explain it better Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris(a)katipo.co.nz www.katipo.co.nz _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ____________________________________________________________________ CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify Safe Air Ltd immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of Safe Air. _____________________________________________________________________ For more information on the Safe Air Group, visit us online at http://www.safeair.co.nz/ _____________________________________________________________________

1 0

Problems with 2.0.0pre1
by T & J Kotula 08 Jul '03

08 Jul '03

1. addbiblio.pl breaks all my browsers in various ways: - IE5.5, NS6.0, Opera: there is no green background on category rows (010, 020 etc). Also the 'Add biblio' button and 'z3950 search' link extend beyond the window on the right hand side, and force horizontal scrollbars - NS4.7: page is properly centred and green backgrounds are present, however an entire block of MARC fields are repeated 9 times, resulting in a very loooong page. Clicking on +- link generates an even larger page - 900kb, again with all fields repeated many times - IE5.5 'Add biblio' causes IE to report an error on line 1834 - links '0', '1' etc don't go anywhere I've read through Pat's email listing all reported bugs and couldn't find what I'm experiencing. BTW the above mentioned bugs were also present in previous V1.9.X releases. I reinstalled 2.0.0pre1 from scratch just to be sure the problems I'm experiencing weren't caused by all the upgrades I made in the past. I have a standard RH8 install. Am I missing something? Help. 2. There is also a bug in the installation script as it needs to create /usr/local/koha/log/logs directory - otherwise httpd will not start 3. catmaintance.pl doesn't work Thanks for any help you can offer me. Tomasz Kotula.

3 2

Translating KOHA
by Christian Hennecke 07 Jul '03

07 Jul '03

I'm currently setting up KOHA for the centre for further training at my university and for the staff to be able to feed the database, I have to translate at least parts of the interface to German. What is the recommended way to translate KOHA? Are there any "tools" available? In the mailing list archive I read about a previous effort to translate KOHA to German, but I couldn't find any related packages. Has it been cancelled? -- Christian Hennecke

3 4

Re: [Koha] OverDue Charges
by Mohamed Amin 07 Jul '03

07 Jul '03

>On Mon, 7 Jul 2003, Mohamed Amin wrote: > > I've did what you asked me ( export LANG=us ) and the result was > > > > #perl fines2.pl > > perl: warning: Setting locale failed. > > perl: warning: Please check that your locale settings: > > LANGUAGE = (unset), > > LC_ALL = (unset), > > LANG = "us" > > are supported and installed on your system. > > perl: warning: Falling back to the standard locale ("C"). > > > > what sholud I do next ? > >Ah, sorry, go ahead and do > > LANG=C > >and you should be ok. I just tested this and it worked for me. > >-- ></chris> Tahnks a lot it workes _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

1 0

Problems with 2.0.0rc1
by koha＠cdeacf.ca 07 Jul '03

07 Jul '03

Hi, I've just finished the installation of Koha on a RHL 8.0 server, loaded the sample data and I have the following difficulties: 1) When trying to add a new biblio (without ISBN), I get a screen with with a boxed titled "MARC biblo" with numbers from 1 to 9, hyperlinked to nothing. Cliking on any nuymber or on the Add Biblio button does nothing. I've put the result page at http://www.cdeacf.ca/~simonp/addbiblio.pl.html 2) When trying to add a website, I get a blank page 3) On the MARC search, no fields or subfields are availables, no search are possible... 4) In the Circulation module, I get an error when trying to return a book. I have this in the error log: $branch not defined at /home/httpv/koha/modules/C4/Circulation/Circ2.pm line 841., referer: http://koha.cdeacf.ca/cgi-bin/koha/circ/returns.pl I wonder if the sample_data file is outdated, or if I missed some steps to setup koha properly. Any ideas? Cheers, Simon

4 3

Re: [Koha] OverDue Charges
by Mohamed Amin 07 Jul '03

07 Jul '03

>On Sun, 6 Jul 2003, Mohamed Amin wrote: > > When I tried to run it through the command line it gave me this error > > > > # Perl fines2.pl > > > > Malformed UTF-8 character (unexpected non-continuation byte 0x6e, >immediatly > > after start byte 0xee ) at >/usr/lib/perl5/vendor_perl/5.8.0/Date/Manip.pm > > line 5958. > > > > and this error line is repeated > > > > I don't know what's wrong > >Let me guess, you're using a recent version Red Hat (8 or 9). We see this >error a lot and it's known to cause problems now and then, but generally >it hasn't been meaningful. Your LANG environment variable is set to make >everything work as if it was in a UTF-8 universe. Try doing > > export LANG=US > Perl fines2.pl > >And see if it acts better. Since LANG is probably already exported you >can do this all one line in cron and such: > > LANG=US Perl fines2.pl > >-- ></chris> Hi Christopher Hicks Thanks for your help. you are right , I'm using RedHat Linux 8.0 , I've did what you asked me ( export LANG=us ) and the result was #perl fines2.pl perl: warning: Setting locale failed. perl: warning: Please check that your locale settings: LANGUAGE = (unset), LC_ALL = (unset), LANG = "us" are supported and installed on your system. perl: warning: Falling back to the standard locale ("C"). what sholud I do next ? thanks for you for chris and for everyone in Koha mailing list Mohamed Amin _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus

2 1

Dewey
by Heather Waite 07 Jul '03

07 Jul '03

Hello, I am a student librarian at an environmental centre at which we have recently installed Koha and are setting up a library. We are interested to know as to how people have gone about 'printing out' the Dewey or classification number for the item, as Koha does not have this function. Thank you Heather Waite h.waite(a)optusnet.net.au

1 0

Re: [Koha] OverDue Charges
by Mohamed Amin 06 Jul '03

06 Jul '03

Hi Chris When I tried to run it through the command line it gave me this error # Perl fines2.pl Malformed UTF-8 character (unexpected non-continuation byte 0x6e, immediatly after start byte 0xee ) at /usr/lib/perl5/vendor_perl/5.8.0/Date/Manip.pm line 5958. and this error line is repeated I don't know what's wrong Mohamed Amin _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

2 1

OverDue Charges
by Mohamed Amin 06 Jul '03

06 Jul '03

Hi Chris I've wrot a cron file OverDue.cron , the file contained the following. 15 17 * * * /usr/local/koha/intranet/scripts/misc/fines2.pl then I've started the cron job . but nothing happened next day there r no charges calculated what's wrong with that ? thanks for your help Mohamed Amin Network Administrator National Training Institute Egypt _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

2 1

[lambert@amigos.org: Webhosting & Koha]
by Chris Cormack 04 Jul '03

04 Jul '03

----- Forwarded message from Greg Lambert/Amigos <lambert(a)amigos.org> ----- Subject: Webhosting & Koha To: koha-admin(a)lists.katipo.co.nz From: "Greg Lambert/Amigos" <lambert(a)amigos.org> X-MIMETrack: Serialize by Router on AmigosLotus/Amigos(Release 5.0.11 |July 24, 2002) at 07/03/2003 09:24:27 AM X-BeenThere: koha(a)lists.katipo.co.nz X-Mailman-Version: 2.0.11 List-Help: <mailto:koha-request@lists.katipo.co.nz?subject=help> List-Post: <mailto:koha@lists.katipo.co.nz> List-Subscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>, <mailto:koha-request@lists.katipo.co.nz?subject=subscribe> List-Id: Discussion list for the Koha Library system <koha.lists.katipo.co.nz> List-Unsubscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>, <mailto:koha-request@lists.katipo.co.nz?subject=unsubscribe> List-Archive: <http://lists.katipo.co.nz/public/koha/> I am working on a short-term project for a University Law Library to rebuild a book collection that was destroyed in a flood. In all, there are about 28,000 titles. We are using Innovative Interfaces (III) as our main acquisitions module, but did not buy the OPAC because it was > $100K to purchase. One of the things we would like to do for the faculty is to have an OPAC they can view of the materials we are replacing. And it looks like Koha would do the trick. We are using HostRocket as our webhosting server (www.hostrocket.com) They use Linux servers with Apache, MySQL, PHP, and Perl. I have @1 GB of space. My questions are as follows: 1. Has anyone installed Koha on a webhosted server? 2. Can the MARC records from the current system (III) be exported to Koha? (I saw something about one-at-a-time uploads, but is there a way to batch these, or do multiple uploads?) 3. If MARC records can be exported to Koha, can the upload program be modified to "overlay" duplicate MARC records? (This is a unique project where we are ordering "replacements" and thus the MARC records are in the system, we would just need to import certain fields to update the current MARC record.) 4. Can Koha be modified? The key example is that the Faculty want to be able to comment on certain books (e.g., "This book is extremely important to our collection," or "This book is worthless, do not order it!") TIA!! -Greg Greg Lambert, JD, MLIS Project Manager Amigos Library Services, Inc. 5000 Gulf FWY Building 9 - Univ. Business Park Houston, Texas 77023-4600 713/923-2373 x225 office 877/707-1577 toll-free 713/923-2192 fax 281/433-9145 cell lambert(a)amigos.org http://www.amigos.org ----- End forwarded message ----- -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris(a)katipo.co.nz www.katipo.co.nz

3 2