- Koha - lists.katipo.co.nz

Re: [Koha] A barcode question
by Steven F.Baljkas 06 Jun '06

06 Jun '06

Tuesday, June 6, 2006 00:15 CST Dear Heidi, et al., I have actually been thinking about your question since last Tuesday when -- while editing/fixing records converted from an Excel spreadsheet into tagged MARC format using MARCEdit (an excellent tool BTW available off the LC MARC Records, Systems and Tools page at URL <http://www.loc.gov/marc/marctools.html>) -- it dawned on me that I was going to have a hell of a time trying to get barcodes into the right places once I had everything else with the records neatened up. (BTW Venkat, if you are reading mail on the general list, it is your records I have been working on; lots of problems I'll brief you on in due course.) In any case, the thought I had was that it might be possible to export the MARC tagged format into a delimited text format and then ***import that into Excel or another program that could generate field code automatically*** (I lack the ability to write scripts to perform such "automagical" feats, although I am sure that is another, probably better solution). I think Excel could do this. It would only be a matter of deciding what structure the barcodes would need to have and their length. Once the barcodes were added into the correct field, I think it would be possible to go back across the bridge as it were, export them again as delimited text, receive them into MARCEdit for checking and then convert them into true MARC. At the very worst, Heidi, I have spent a little more than a week working on the records for Venkat, and while I couldn't assign barcodes, I was reassigning a lot of accession numbers and correcting errors in call numbers, easily more than 6000 in the 12793 records edited. It is a pain to do it all manually, but it is feasible for one persistent cataloguer to add barcodes manually if need be. For the record, it would be great if Koha could automatically generate the barcodes and really super if it could know where to insert these in the MARC records (since it can export MARC it must somehow 'know'), e.g. 852 $p and 952 $p. Perhaps a customisable, Koha-flavour-based add-on to shoot for sometime in version 3.x.x? As for printout of barcodes, Heidi, wasn't there something on the listserv a week or two back, around the same time as some discussion on spine labels? I remember Joshua had reported on some progress a little while back. IIRC someone once commented that you could extract the data directly from the MySQL database to do what you are desiring, Heidi. That is, IIRC ... Anyway, HTH a little. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada ============================================================ From: "h lowe" <heidilowe(a)gmail.com> Date: 2006/06/05 Mon AM 10:14:13 CDT To: koha(a)lists.katipo.co.nz Subject: [Koha] A barcode question First of all, thank you for your time, and i apologize if this question has been asked before. I didn't find in the 2005 or 2006 archives, but I may certainly have missed it. But, here is my question: I am helping a smallish library (about 6,000 volumes) migrate to Koha. We already have an online catalog, so to speak, but no barcodes, circulation, or any of that. Basically our plan is to export the records from the old catalog into MARC format and import into Koha using the bulkmarcimport.pl . We would like the Koha to automatically generate barcodes and print them with our own printer. However, in the user guide it says we must have marc support turned off to automatically generate barcodes. Is this still true? We need to use MARC-21. So if we cannot automatically generate barcodes I would like to know, so that we can plan to buy pre-printed ones instead (if we must). Ideally, what we would like to do is have the barcodes print with the call # on the bottom, and be printed in call number order (like a shelf list of barcodes?) I would also like to know if this is possible. Thank you very much in advance, Heidi Lowe ============================================================

1 0

Volume information to items
by Lenora Oftedahl 05 Jun '06

05 Jun '06

Hi. I'm trying to figure out how to add the volume and/or year information to the item record. I'd like to show which barcode goes to which volume, but can't find the field to do this. Thanx. Lenora Vancouver, WA

1 0

A barcode question
by h lowe 05 Jun '06

05 Jun '06

First of all, thank you for your time, and i apologize if this question has been asked before. I didn't find in the 2005 or 2006 archives, but I may certainly have missed it. But, here is my question: I am helping a smallish library (about 6,000 volumes) migrate to Koha. We already have an online catalog, so to speak, but no barcodes, circulation, or any of that. Basically our plan is to export the records from the old catalog into MARC format and import into Koha using the bulkmarcimport.pl . We would like the Koha to automatically generate barcodes and print them with our own printer. However, in the user guide it says we must have marc support turned off to automatically generate barcodes. Is this still true? We need to use MARC-21. So if we cannot automatically generate barcodes I would like to know, so that we can plan to buy pre-printed ones instead (if we must). Ideally, what we would like to do is have the barcodes print with the call # on the bottom, and be printed in call number order (like a shelf list of barcodes?) I would also like to know if this is possible. Thank you very much in advance, Heidi Lowe

1 0

RE: [Koha] importing data to koha
by pscaer＠phila.k12.pa.us 04 Jun '06

04 Jun '06

Hello Shaw, We exported data from Alexandria to Koha by using the utility for sending marc records. However, the barcodes could not be attached, so it was an extra step for me to add them in. We also ran a bunch of FileMaker Pro data through Alex to convert to MARC and that worked. Good luck, Paul Scaer, Masterman Library -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ .

1 0

[junbunlee@hotmail.com: where to get the chinese version Koha]
by Chris Cormack 04 Jun '06

04 Jun '06

----- Forwarded message from ben lee <junbunlee(a)hotmail.com> ----- Dear Sir or Madam,I am a volunteer of the Vancouver International buddhist Progress Society. Our temple is planning to use Koha for our Linbrary system. Could you pleae tell us where can we get koha in tranditional chinese if available?Thank youBenjamin LiIT Voulnteer Vancouver IBPSwww.vanibps.org ----- End forwarded message ----- -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris(a)katipo.co.nz www.katipo.co.nz

1 0

importing data to koha
by Skeewhiz＠aol.com 03 Jun '06

03 Jun '06

Hi, Our school district has been using Alexandria library automation software for the last five years. We would like to export our data from Alexandria to Koha and give it a try. Is it possible to export all our library data from Alexandria to Koha? How would we begin? Shaw

1 0

Re: How do you import Book copy records?
by Stephen Hedges 02 Jun '06

02 Jun '06

Alan, you're probably right -- you'll need to modify the import script to add your holdings data. Most ILS software exports the basic MARC bibliographic and the holdings data together, with the holdings data in a 8xx or 9xx MARC tag. Stephen Alan Piercy wrote: > I wrote a library package (MySQL/PHP) several years ago for my school and > now want to migrate my Marc and Holdings data files to Koha. I plan on > creating a 2709 file from my Marc records and using something like > bulkmarcimport to import into Koha. > > But, how do I put my Holdings records into Koha? > > I have two data tables with fields as follows. Holdings records point to > a > Marc record. Since there is a MarcID dependency, it seems I should modify > bulkmarcimport to handle both tables at the same time. Does anyone have a > script that has done this? > > > MARC > ID (primary key) > Title > Author > Dewey > Isbn > > > HOLDING (identifies physical books) > ID (primary key) > MarcID (pointer to MARC.ID) > Barcode > _______________________________________________ > Koha-win32 mailing list > Koha-win32(a)nongnu.org > http://lists.nongnu.org/mailman/listinfo/koha-win32 > -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com

2 2

still looking for mysql @ localhost
by eric salayon 02 Jun '06

02 Jun '06

guys, gud day! i just successfully installed KOHA but mysql is not residing on the same pc. i'd tweaked some statements in the Install.pm (include -h $hostname to every mysql and mysqladmin commands) to make it work. but now, when im trying to search for a book, the system still looks @ localhost for the database. below is the logs: [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] DBI->connect(:) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /www/koha/intranet/modules/C4/Context.pm line 411 [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] DBI->connect(:) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /www/koha/intranet/modules/C4/Context.pm line 411 [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] Can't call method "prepare" on an undefined value at /www/koha/opac/cgi-bin/opac-main.pl line 16. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] Premature end of script headers: opac-main.pl how should i go about this? thanks in advance eric

3 7

Cupboard/ physical location of item
by Nitin Madhavan 01 Jun '06

01 Jun '06

Which field do I use to enter the physical location of the item? I am presently using the default MARC framework. Thanx Nitin

1 0

Re: [Koha] Cupboard/ physical location of item
by Yohannes Mulugeta 01 Jun '06

01 Jun '06

You can use subfield '952b' (homebranch) and '952d' (holdingbranch) to to tell your patrons about an item's physical location. cheers; Yohannes Mulugeta John F. Kennedy Memorial Library Addis Ababa University P.O.Box: 1176 Addis Ababa, Ethiopia e-mail: yohannesmulu(a)yahoo.com cell phone: 251 (0)91 1762568 Content-Type: multipart/alternative; boundary="----=_Part_6272_21468681.1149154285723" ------=_Part_6272_21468681.1149154285723 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Which field do I use to enter the physical location of the item? I am presently using the default MARC framework. Thanx Nitin ------=_Part_6272_21468681.1149154285723 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Which field do I use to enter the physical location of the item? I am presently using the default MARC framework.<br>Thanx<br>Nitin<br> ------=_Part_6272_21468681.1149154285723-- _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0