Hello, I wrote last week about trying to import MARC records missing ISBNs into Koha. I've since upgraded to 2.0.0 and have been able to upload my MARC files. So far so good! Now I'm encountering the same problem that others have recently mentioned, including Bernadette:
I would concur with much of what Steven has said re Koha. As for LC classification, at our library we've come up with a temporary solution of including LC numbers in the biblio in the notes section!! Seriously once the developers come up with a solution to LC numbers will be great.
Our books are also catalogued with LC numbers, and I have been trying to figure out either an elegant solution or a hack, to enable me to use those numbers in Koha. Can any one offer any suggestions? Much appreciated, Gregory Garretson Boston University
Hi everybody, Here is the solution I propose for LC and any other callnumber : * a field has already been added in items table. It's called itemcallnumber. * this field will be "connected" to : biblio dewey OR LoC number OR manual & local classification. if connected to dewey or LoC, it will automatically be filled. So every library can have it's own callnumber system. Sounds this good ? For 2.0 I've no other suggestion than the workaround suggested here. The dmoses one being the best, imho. NOTE : why put the callnumber in items & not in biblio you may ask ? it's because some libraries may have 2 differents callnumbers for 2 items of the same biblio. Sounds silly (& quite old), but exists. And you can't ask a 100 000 items library to reorganize it's shelves ;-) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
Tuesday, April 27, 2004 15:50 CDT Hi, Paul, Your solution --
Here is the solution I propose for LC and any other callnumber : * a field has already been added in items table. It's called itemcallnumber. * this field will be "connected" to : biblio dewey OR LoC number OR manual & local classification. if connected to dewey or LoC, it will automatically be filled.
So every library can have it's own callnumber system.
-- sounds good to me. I just want to make sure I understand though: will we still be able (in MARC21 terms) to have a 050 tag with the original LC-assigned call number **separate** from the number we choose and assign for our own catalogue?? I know that sounds strange, but sometimes one needs to correct LC (shrieks of horror; gasps at impudence) or other copy, as in the military library where I worked on contract, but we still wanted to have the original number there, if for no other reason than to justify the time we were spending in classification. Many ILS also allow for something similar so that one can retain original classification information in case one wants to revert or adopt another system later, or just for sharing purposes.
For 2.0 I've no other suggestion than the workaround suggested here. The dmoses one being the best, imho.
Way to go, Don!! :-)
NOTE : why put the callnumber in items & not in biblio you may ask ? it's because some libraries may have 2 differents callnumbers for 2 items of the same biblio. Sounds silly (& quite old), but exists. And you can't ask a 100 000 items library to reorganize it's shelves ;-)
Certainly not. What you explain happens a lot. And it's not such a bad thing in an age of shared cataloguing. (For me, it seems quite familiar to as when I started university, my uni library had 4 different catalogues, with many items existing in two or more.) Libraries are places where weird and wonderful things happen all the time. ;-) Amitiés, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, Manitoba, Canada --- 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
Tuesday, April 27, 2004 15:35 CDT Hi, Gregory, Glad to read that the import of MARC records is going better with the upgrade. :-) Bernadette wrote in to share her library's temporary solution (clever, Bernadette!!), to wit:
of including LC numbers in the biblio in the notes section!!
Our books are also catalogued with LC numbers, and I have been trying to
The developers are aware of the LC issue and I just want to stress - for the sake of the harmony of the Koha family (shalom beit) - that we are all aware of the complexity and huge amount of work they are doing and are not complaining. figure out either an elegant solution or a hack, to enable me to use those numbers in Koha. Can any one offer any suggestions? Actually, you might have just missed Don Moses' very kind posting of his workaround solution, which I found very elegant (way to go, Don!). Rather than make you hunt through the archive, here it is in full from April 23, 2004: 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 (** see below line for MJR's addendum) 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 <!-- TMPL_LOOP NAME="BIBLIO_RESULTS" --> <!-- TMPL_IF name="classification" --> <b>Call Number: </b><!-- TMPL_VAR name="classification" --> <br /> <!-- /TMPL_IF --> <!-- /TMPL_LOOP --> 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 ---------------------------------------------------------------------------- --------- ** in response to Don's statement above to run the script I often have to tell my system where PERL5LIB is (I don't know why), so I type [...] MJ Ray added that Koha uses its own perl modules as well as your system's ones. You can also do the same by the command: perl -I../../modules rebuildnonmarc.pl -c Anyway, hope all this helps, Gregory. Let us know how it goes. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, Manitoba, Canada --- 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
If your call number is contained in one subfield of your MARC holdings tag, you can map it to biblioitems.classification and everything should work OK. Doesn't matter if it's Dewey, LC, or any other scheme. The problem comes if your call number is spread across several subfields. Stephen Gregory Garretson said:
Hello,
I wrote last week about trying to import MARC records missing ISBNs into Koha. I've since upgraded to 2.0.0 and have been able to upload my MARC files. So far so good!
Now I'm encountering the same problem that others have recently mentioned, including Bernadette:
I would concur with much of what Steven has said re Koha. As for LC classification, at our library we've come up with a temporary solution of including LC numbers in the biblio in the notes section!! Seriously once the developers come up with a solution to LC numbers will be great.
Our books are also catalogued with LC numbers, and I have been trying to figure out either an elegant solution or a hack, to enable me to use those numbers in Koha. Can any one offer any suggestions?
Much appreciated,
Gregory Garretson Boston University
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
participants (4)
-
Gregory Garretson -
paul POULAIN -
Stephen Hedges -
Steven F. Baljkas