- Koha - lists.katipo.co.nz

Re: [Koha] Importing records into Koha
by durgaprasad guda 26 Apr '04

26 Apr '04

Roger Horne wrote: I may have missed the relevant one, but when I changed the author to "Norton, Robert", the LoC & the Institute of Advanced Legal Studies produced the relevant result. That contains no ISDN but Koha seems quite happy with it. ------------- I succeeded for the first time to import records by putting author as 'Norton Robert' So far i always got 'No record found' for all my searches with or without ISBN. I searched for books on engineering , linux etc of more recent origin., and some a few years old that I have with me at home. Prasad __________________________________ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25� http://photos.yahoo.com/ph/print_splash

1 0

authority records
by Tomasz Wolniewicz 26 Apr '04

26 Apr '04

Hi, do I understand correctly that the "authority records" support in Koha is limited to prompting values for a given field, but the bibliographic records do not actually contain references to authority records and hence a change in authority records is not reflected in how the bibliographic record will be presented? Tomasz -- Tomasz M. Wolniewicz Tomasz.Wolniewicz(a)uni.torun.pl http://www.uni.torun.pl/~twoln Uczelniane Centrum Informatyczne Information&Communication Technology Centre Uniwersytet Mikolaja Kopernika Nicolaus Copernicus University, pl. Rapackiego 1, Torun pl. Rapackiego 1, Torun, Poland tel: +48-56-611-2750 fax: +48-56-622-1850 tel kom.: +48-693-032-576

1 0

Importing records into Koha
by Gregory Garretson 25 Apr '04

25 Apr '04

Hello, all, I hope somebody can give me some good advice. I have been asked to put the catalog for a fairly small university department collection online, and Koha seems to be the perfect solution. I've got it installed without much problem, but I'm not sure what the best method is for importing the records. The problem is that they are in an idiosyncratic format in spreadsheet form, not in MARC. It appears that the only format in which Koha (v1.2.3) accepts batch files is MARC. I'm a Perl hacker, and I know about MARC::Record, etc., so I can create MARC records if necessary. BUT here's the problem: whoever catalogued these books did not see fit to record any ISBNs! And Koha apparently rejects any records without ISBNs, according to my tests (though it's hard to know when the error message is "Error: Problem with...<title>"). So, short of typing all the information in, can you suggest a method for getting these records into the database? I assume that the MySQL tables are sufficently complex that I don't want to go mucking about with them. Perhaps there is a Z39.50 solution for getting the ISBNs? Any suggestions would be appreciated. Gregory Garretson Boston University

5 5

RE: Re: [Koha] Export MARC from Koha
by Bigwood, David 25 Apr '04

25 Apr '04

Fields 876-878 are a better choice to include acquisitions data. It includes the cost for each copy, different copies can have been purchased at different prices, or one could be a gift. It also includes where it was purchased, date acquired, item status and other subfields available for each copy. Field 037 is repeatable but not linked to each copy in the same manner. Sincerely, David Bigwood bigwood(a)lpi.usra.edu Lunar & Planetary Institute http://www.lpi.usra.edu/library/whats_new.shtml Cataloging News http://www.catalogablog.blogspot.com -----Original Message----- From: koha-admin(a)lists.katipo.co.nz [mailto:koha-admin@lists.katipo.co.nz]On Behalf Of Steve/Ollie/Steven F. Baljkas Sent: Friday, April 23, 2004 5:39 PM To: Chris Cormack; MJ Ray Cc: koha(a)lists.katipo.co.nz Subject: Re: Re: [Koha] Export MARC from Koha Friday, April 23, 2004 17:30 CDT Hi, Chris et al., > Hi Guys > > Theres also the budget data if using full acquisitions. This might be > useful to export also. Regarding the budget information kept in full acquisitions mode, I have to confess I haven't looked at that function, but there is a MARC tag available for item cost: tag 37. I agree that budgetary info would be useful to transfer, for a whole host of reasons (not the least of which is providing a base for determining replacement cost should an item be lost). As for fines, maybe I am just (too) grateful when things have been returned: rather than fussing about transferring fines, I'd suggest using the occasion of migration to offer an 'amnesty', something my local public library system does at irregular intervals (not dependent on system upgrades) and it seems to have a positive effect. > > >I don't know what is meant exactly by 'financial records' but I am assuming > > >that that is a euphemism for fines. Same as paragraph above. > > > > I doubt that these can be exported in a useful way, but I could be wrong. > > Adding the ability to trigger code on fines to notify another accounting system > > may be interesting to someone. Maybe if one adopted one of the neat ideas Dave Bigwood suggested (thanks Dave, I think what you suggested would be super) there would be some way of transferring the fine information (if substantial at least) to the patron file format? Anyway, just another two cents worth. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, Manitoba, Canada _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Workaround: Using LC with Koha
by dmoses2＠uwo.ca 23 Apr '04

23 Apr '04

Hello Folks: Steven Baljkas (thanks Steven) suggested I write this up for those wanting to use Library of Congress numbers with Koha. There has been much discussion regarding support for LC numbers in future versions of Koha, but until that day arrives here is my workaround. 1. Determine the MARC field used to hold the LC number in your MARC records. This will vary from institution to institution. It is commonly in 090a (which is a local call number field), but the MARC records I'm using have it in 099a. 2. Ensure that this MARC field is mapped properly. Intranet Web Interface > Parameters > MARC tag structure > edit (or add) your MARC field with the LC number and link it to the Koha biblioitems.classification field 3. Link it to Koha Intranet Web Interface > Parameters > Links Koha - MARC DB > Select biblioitems from the dropdown menu > edit the classification field and link it to your MARC field containing the LC number 4. Anytime you change the links between Koha and MARC you should test your changes. Intranet Web Interface > Parameters > MARC Check If everything checks out ok, great. If not. hmmmmm. 5. Whenever you change the links between Koha and MARC it is suggested that you run the rebuildnonmarc.pl script... If you've got a lot of records, this process can take awhile. Make yourself a pot of tea. (I'm not sure this step is necessary) For me the path to this script is /usr/local/koha/intranet/scripts/misc to run the script I often have to tell my system where PERL5LIB is (I don't know why), so I type export PERL5LIB=/usr/local/koha/intranet/modules I make sure I'm in the right directory. cd /usr/local/koha/intranet/scripts/misc Then I run the script... perl ./rebuildnonmarc.pl -c 6. To display the call number field you need to put it in your OPAC template. Here is a snippet (there's lots of stuff before TMPL_IF and after /TMPL_IF) from my opac-details.tmpl file   <b>Call Number: </b> <br />   A caution - the classification field (in the biblioitems table) only holds 25 characters ... you can increase it if you have call numbers that are longer than that by increasing the field length. I had a great time exploring and experimenting with Koha for an independent study I did. If you have any questions, let me know. To see how it looks on my version of Koha see http://69.156.111.211:8080/cgi-bin/koha/opac-detail.pl?bib=652 I've got some duplicate call numbers in my MARC data and I've not clean it up so some of the data may look odd. Good Luck. Don

2 1

Re: Re: [Koha] Export MARC from Koha
by Steve/Ollie/Steven F. Baljkas 23 Apr '04

23 Apr '04

Friday, April 23, 2004 17:30 CDT Hi, Chris et al., > Hi Guys > > Theres also the budget data if using full acquisitions. This might be > useful to export also. Regarding the budget information kept in full acquisitions mode, I have to confess I haven't looked at that function, but there is a MARC tag available for item cost: tag 37. I agree that budgetary info would be useful to transfer, for a whole host of reasons (not the least of which is providing a base for determining replacement cost should an item be lost). As for fines, maybe I am just (too) grateful when things have been returned: rather than fussing about transferring fines, I'd suggest using the occasion of migration to offer an 'amnesty', something my local public library system does at irregular intervals (not dependent on system upgrades) and it seems to have a positive effect. > > >I don't know what is meant exactly by 'financial records' but I am assuming > > >that that is a euphemism for fines. Same as paragraph above. > > > > I doubt that these can be exported in a useful way, but I could be wrong. > > Adding the ability to trigger code on fines to notify another accounting system > > may be interesting to someone. Maybe if one adopted one of the neat ideas Dave Bigwood suggested (thanks Dave, I think what you suggested would be super) there would be some way of transferring the fine information (if substantial at least) to the patron file format? Anyway, just another two cents worth. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, Manitoba, Canada

1 0

Export MARC from Koha
by Philippe Revault 23 Apr '04

23 Apr '04

Hi, I would like to check 2 points about exporting data in MARC with Koha : 1- Is the export format in MARC or in UNIMARC ? 2 - Which datas are exported ? In my test i have only got exported datas like title, dewey, main author, ISBN, notes, document type. I don't have datas like additional authors, subjects, subtitle, publication date, editor... Thank you for your help. PhR.

5 9

Re: [Koha] Export MARC from Koha
by Philippe Revault 23 Apr '04

23 Apr '04

Hi Steven, Thank you for your complete and specific answer. Finally i realize that i have lost some datas (at least subject) somewhere in the process of updating or configuring from 1.2.3 to 2.0.0 I will check this by reinstaling the all thing and report. Thank you and other people again and do not worry. Je suis patient :-). I am using Koha just in order to test it in a private environment. Cordialement, Philippe > Steven F. Baljkas a écrit : > >> Thursday, April 22, 2004 15:25 CDT >> >> >> >> Actually, the *original* MARC format was USMARC. Without everyone going >> jingoistic, that's just a fact. By the 1990s, there were a variety of >> nationalised-MARC systems in the world (USMARC, CANMARC, Australian >> MARC, >> UKMARC, etc., etc., as we have had proof of even on this listserv >> when at >> various times people have written in asking if Danish MARC or Chinese >> MARC, >> etc. would be compatible with/represented in Koha). >> >> UNIMARC made great claims to being an international standard but was >> and is >> essentially Eurocentric, all apologies to IFLA. When you look at the >> MASSIVE >> amount of support documentation generated by the Library of Congress >> and the >> mind-boggling amount of work done by various governmental and private >> companies around MARC21 standards, you come to realise pretty quickly >> that >> there is a reason it is becoming the de facto global standard. >> >> All that aside, yes, UNIMARC was and is intended as an information >> exchange >> format (as is MARC21), and it is comprehended by Koha. From what Paul >> has >> written before, you need to *decide the MARC variety you are going to >> use.* >> >> > Could you tell us which version of Koha you are using? That usually helps > >> the developpers identify where glitches are coming from and how they >> can be >> fixed. And MJR has asked for a list of what is not being exported. >> >> In terms of the MARC coding, I may be able to help. Could you send me >> a test >> sample of the MARC records you are able to export off the listserv? I >> can >> examine them and see if something is happening to the MARC record's >> registry, inadvertent damage to which can cause lost data. >> >> >> >>> 3- Answer to Rachel (see below) : First thing should be to export the >>> entire catalogue but additional datas from the borowers would certainly >>> be nice. >>> >> >> >> While there have been problems for others in exporting data from Koha >> and >> importing data into Koha, overall Koha seems to work for most people. >> Someone will be able to figure out what is glitching. Soyez patient. >> MJR has >> already asked that you send a list of what is missing so they can >> test and >> report it properly as a glitch. And Rachel is one of the big-picture >> people >> involved with Koha, so it is understandable that she took your >> question on >> exporting patron data to that level. Take that as a compliment. >> >> Amitiés, >> Steven F. Baljkas >> library tech at large -- bibliotechnicien >> Koha neophyte >> Winnipeg (Manitoba) Canada >> >> >> >>>> On 2004-04-21 12:37:09 +0100 Philippe Revault <ph.revault(a)free.fr> >>>> >>> >> wrote: >> >> >>>>> 1- Is the export format in MARC or in UNIMARC ? >>>>> >>>> >>>> More likely to be MARC21, as far as I understand the code, but I could >>>> be wrong. >>>> >>>> >>>> >>>>> 2 - Which datas are exported ? >>>>> >>>> >>>> It should be possible to export all. If you are sure things are >>>> missing, let us know, I'll test and make sure it gets recorded. >>>> >>>> >>> >>> Rachel Hamilton-Williams a e'crit : >>> >>> If you're exporting data I assume that the MARC export only does the >>> >> >> catalogue >> >> >>> records - so it doesn't do >>> - Borrowers/patron records >>> - Finacial records? >>> - Reserves >>> >>> Do you think it would be a good idea to have a method for exporting >>> this >>> >> >> data >> >> >>> as well? >>> >> >> >> >> --- >> Outgoing mail is certified Virus Free. >> Checked by AVG anti-virus system (http://www.grisoft.com) >> Version: 6.0.663 / Virus Database: 426 - Release Date: 20/04/2004 >> >> >> >> >> > >

1 0

Migrating from CDS/ISIS to koha
by Ben Hall 23 Apr '04

23 Apr '04

For those winisis and cds/isis users out there, I've finally got round to packaging up my xml2koha script. You can download it from http://www.benality.net/files/xml2koha.tar.gz Please read the README, INSTALL and HOWTO files before running the xml2koha.pl script. Feel free to give me as much feedback as possible on how you went and what needs fixing. This is my first foray into perl programming so excuse any badly laid out code. -- Ben Hall Information Officer Forum Fisheries Agency PO Box 629 Honiara, Solomon Islands ph: +677 21124 fx: +677 23995 em: ben.hall(a)ffa.int ww: http://www.ffa.int/

1 0

Acquisitions and 'Biblios in koha'
by T & J Kotula 23 Apr '04

23 Apr '04

Why is it when I hit 'Go' in .../acqui.simple/addbooks.pl (after typing in an ISBN) I never get any biblios listed in the "Biblios in koha" table, even though the biblio with that ISBN is in the bibioitems table. However it works fine when I type in the title. Looks like a bug to me. Am I missing something? I'm running Koha2.0.0. PS. My Koha.biblio table does not contain ISBN column. Tomasz Kotula

1 0