- Koha - lists.katipo.co.nz

[OT] marc editor...
by Marco Gaiarin 21 Feb '05

21 Feb '05

This is not strictly a koha question but... By some week a people will arrive in my organization, with the task to pick up all the books in internal library and build a database. I can install koha for this, but the time are tight and i'm thinking if there's some simpler tools that can be used to build a marc record set (possibly scanning some Z35.80 servers, and in UNIMARC format) that then i can import in koha. Thanks. -- dott. Marco Gaiarin GNUPG Key ID: 240A3D66 Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/ Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN) gaio(at)sv.lnf.it tel +39-0434-842711 fax +39-0434-842797 Grazie, Polonia! http://thankpoland.info/

2 1

koha2marc.pl and sampledata1.2
by Ryan 21 Feb '05

21 Feb '05

A slew of questions from a koha (and perl) neophyte: (1) What is the status / function of koha2marc.pl? (with respect to following) After installing koha 2.2, I installed sampledata1.2 with no errors ( after modifying records from some tables -- biblio and biblioitems were unchanged). But now I need populate marc_biblio etc to get any search results. (2) --this seems true whether marc support is 0 or 1. Is this the expected behaviour? So I run koha2marc.pl , which fails: DBD::mysql::st execute failed: Column 'frameworkcode' cannot be null at /usr/local/koha/intranet/modules/C4/Biblio.pm line 343. DBD::mysql::st execute failed: Column 'bibid' cannot be null at /usr/local/koha/intranet/modules/C4/Biblio.pm line 459. marc_subfield_structure.frameworkcode is empty string, not null, for all records. (default marc21 structure def'n accepted at install). MARCkoha2marcBiblio($dbh,$biblionumber,$biblioitemnumber) calls MARCkoha2OneField, which expects $frameworkcode as an argument, but does not supply it. (causing the framework null error??) Any help would be greatly appreciated. thanks, ryan /ohio/usa/

2 1

Re: Re: [Koha] Db/Textworks
by Steven F. Baljkas 15 Feb '05

15 Feb '05

Monday, February 14, 2005 17:55 CST Hi, Bob, Phill, et al., Just one quick comment and one short question re: Bob's answer .... > From: Bob Ewart <bob-ewart(a)gate.net> > Date: 2005/02/12 Sat AM 07:17:33 CST > To: Phill Hardstaff <phillh(a)spc.int> > CC: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Db/Textworks > > Phill Hardstaff wrote: > > >Hi, I would love to hear from anyone who has moved data from Db/Textworks and > >Procite to Koha, I am migrating our 2 libraries who currently use these 2 > >software packages to one instance of Koha. > > > >Cheers > > > >Phill > > > > > Hi Phill > > I'm planning to move from DB/Textworks to Koha. We have about 10K books > & videos and countless serials. > > We plan to export the catalog to a comma delimited file, then write a > Perl script to convert to MARC format. You might want to check out MARCEdit off the MARC Tools page at LC at URL <http://www.loc.gov/marc/marctools.html#recordtools> It has a delimited text editor which might save you the step of writing the PERL script. Or if you don't have access to a PC to use MARCEdit on, give a shout back and I can try converting the records for you. Now, the short question viz. > Part of the problem is that one record in DBTextworks can > contain multiple book barcode numbers. Unless I missed something critical, Bob, (and please let me know if I am) I can't see why this would be a problem. The same thing is true for valid MARC records in any ILS, since one can have many copies of a book etc. on the shelves that are all attached to one MARC record and yet would have (one hopes) unique barcodes and sometimes other identification numbers (often acquisition numbers, e.g.). It's only complex in deciding where to map the barcode info (multiple 852s perhaps, unless there is someway of appending the barcode info to the $p; I guess that would depend on how the barcode info is stored in your DBTextworks). In the meanwhile, best wishes to you both as you move forward with your migrations to Koha. Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada

2 1

Re: [Koha] Librarians Helper
by Steven F. Baljkas 15 Feb '05

15 Feb '05

Sunday, February 13, 2005 22:39 CST Hi, Karl, Checking Cibbarelli's Directory of Library Automation Software, Systems, and Services (2001-2002 ed.) quickly, it seems that Librarian's Helper does not offer import or export in MARC format. As many non-MARC fans of Koha would point out quickly, however, Koha works quite fine without use of MARC records. There is, indeed, a non-MARC setting, as Koha was originally made for a library trust in New Zealand that continues to use it happily and successfully without MARC-on. I am not sure about migrating your database. I am dismayed by what I am reading in Cibbarelli's though. The supplier's comments note only that it is designed to produce catalogue cards and various labels, but NOT a true database. Are you sure you actually have a database to import into Koha? If it is at all reassuring, though, I would assume that, at the very worst, if there is a database, you should be able to extract the data (does Librarian's Helper offer ANY export options? from what I am reading in Cibbarelli's it sounds like there are none built in) from wherever it 'hides' in the program, although you may have to reformat (standardise) it substantially before Koha can handle it. If you can find any export option, I would be curious to learn more about it. Also, please feel free to give me a shout off listserv re: some cataloguing advice: I know some MLIS folks who are working/have worked on church collections and who are always willing to pass on what they've learned. Best wishes with your migration to Koha. Sincerely, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada > From: Karl Agee <kdagee2(a)yahoo.com> > Date: 2005/02/13 Sun PM 08:00:22 CST > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Librarians Helper > > Greetings. First time here. Looking at using Koha for > a church library of approx 3,000 items. The current > system is using Librarians Helper 1.0 on a compaq 286. > Going to die any day I am sure so that is why we are > looking at alternatives. > > My problem is, I dont know if koha will import this > data. I dont know if it is MARC format. > > Anybody happen to cross that bridge??? > > --Karl > > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

RE: [Koha] Db/Textworks
by Library 15 Feb '05

15 Feb '05

Hi Phill, I have moved catalog data from DB Textworks to Koha onto an online shared catalog, which you can see at http://www.infocat.org.au To move the data, I needed to transform it into USMarc format. For that transformation, I used 'Marc Transformer' a package I purchased from local DB Textworks suppliers in Melbourne. I'm happy to answer any questions you have about this. REgards, Jane Watson-Brown Scope Information Centre 830 Whitehorse Road Box Hill 3128 Australia Telephone 03 9843 2052 email: library(a)scopevic.org.au www.scopevic.org.au -----Original Message----- From: Bob Ewart [mailto:bob-ewart@gate.net] Sent: Sunday, 13 February 2005 12:18 AM To: Phill Hardstaff Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Db/Textworks Phill Hardstaff wrote: >Hi, I would love to hear from anyone who has moved data from Db/Textworks and >Procite to Koha, I am migrating our 2 libraries who currently use these 2 >software packages to one instance of Koha. > >Cheers > >Phill > > > Hi Phill I'm planning to move from DB/Textworks to Koha. We have about 10K books & videos and countless serials. We plan to export the catalog to a comma delimited file, then write a Perl script to convert to MARC format. Part of the problem is that one record in DBTextworks can contain multiple book barcode numbers. I'd be happy to work with you on the Perl scripts. Bob Ewart Stonewall Library & Archives Fort Lauderdale, FL _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha Disclaimer This email may be confidential. If you are not the intended recipient, you may not use, disseminate or disclose the information it contains. If you have received this email in error, please notify us immediately by return email (or phone +61 3 9843 3000) and delete this email. Scope (Vic) Ltd is not responsible for any unauthorised changes made to this email. While Scope uses virus scanning software, it does not warrant that this email and any attachments are virus free. Thank you. Visit our web site at www.scopevic.org.au

1 0

Librarians Helper
by Karl Agee 14 Feb '05

14 Feb '05

Greetings. First time here. Looking at using Koha for a church library of approx 3,000 items. The current system is using Librarians Helper 1.0 on a compaq 286. Going to die any day I am sure so that is why we are looking at alternatives. My problem is, I dont know if koha will import this data. I dont know if it is MARC format. Anybody happen to cross that bridge??? --Karl __________________________________ Do you Yahoo!? All your favorites on one personal page � Try My Yahoo! http://my.yahoo.com

1 0

Db/Textworks
by Phill Hardstaff 12 Feb '05

12 Feb '05

Hi, I would love to hear from anyone who has moved data from Db/Textworks and Procite to Koha, I am migrating our 2 libraries who currently use these 2 software packages to one instance of Koha. Cheers Phill -- Phill Hardstaff MCSA, CCNA, A+, Network+, Inet+, Server+, CIW Assoc. Senior Support Engineer Secretariat of the Pacific Community B.P. D5 Noumea Cedex - 98848 New Caledonia Phone +687-260141 Mobile +687 838091 Fax +687-263818 http://www.spc.int/

2 1

Installation on MacOS X Server
by Jason Fouks 11 Feb '05

11 Feb '05

I am trying to install the PERL modules onto my Mac OS X Server (Panther) and having troubles. Has anyone installed it on a Mac server? Can you point me in the right direction as to how to get it installed? Thanks much, Jason Fouks ______________________________ Jason Fouks, ACPT, CNA Stillwater Area Schools 820 Manning Avenue Lake Elmo, Minnesota 55042 Help Desk Phone: 651.351.6300 Fax: 651.351.8505 fouksj(a)stillwater.k12.mn.us http://www.stillwater.k12.mn.us "Always listen to experts. They'll tell you what can't be done and why. Then do it!" — Robert HeinLein

1 0

error on installing koha
by Eric G. Salayon 10 Feb '05

10 Feb '05

guys, good morning to all. i'd install koha in fedora core 2 linux here in our office. it encountered an error: DBD:mysql ::st execute failed: Invalid default valude for 'aqbudgetid' at scripts/updater/updatedatabase line 1025 DBD:mysql ::st execute failed: Invalid default valude for 'id' at scripts/updater/updatedatabase line 1025 what can i do to correct this? below is the section where the error happens the last line '$sth->execute($default);' is line 1025 # if it's a primary key, drop the previous pk, before altering the table my $sth; if ($key ne 'PRIMARY KEY') { $sth =$dbh->prepare("alter table $table $action $field $type $null $key $extra default ?"); } else { $sth =$dbh->prepare("alter table $table drop primary key, $action $field $type $null $key $extra default ?"); } $sth->execute($default); hope to hear asap from you guys, TIA!!! ERIC

1 0

RE: [Koha] yet another installer problem
by zero＠vtr.net 09 Feb '05

09 Feb '05

Hi Roger I'll try to give you a few pointers hope at time though... Original Message >From: Roger Horne <roger(a)hrothgar.co.uk> >To: koha(a)lists.katipo.co.nz >Subject: [Koha] yet another installer problem >Date: Sat, 5 Feb 2005 18:46:33 +0000 (GMT) > >Creating the Mysql database ... > >ERROR 1062 at line 1: Duplicate entry 'localhost-kohaadmin' for key 1 >256 ERROR 1062 at line 1: Duplicate entry '%-Koha-kohaadmin' for key 1 --- This error points that you have allready a user called "kohaadmin" set as default in a Koha ./installer.pl installation. You can remove it by entering to the Mysql console and typing DELETE FROM mysql.user WHERE User = "kohaadmin"; You may also would want to check first if the user is actually in the DB, can do it by: SELECT user, host, password FROM mysql.user; By this you'll get a table with all the info about users, etc. >/usr/bin/mysqladmin: command to server at 'localhost' failed >error 'access denied for user: kohaadmin@localhost' (using password 'YES')' > >ERROR CREATING Database Could not connect to Mysql server About this, you only should check your password spelling, may be you are entering with a different one. You allways should try entering with: # mysql -u root -p[urpass] ----> without the brackets Ok may be you know all this by now, hope could help and someone correct me if I'm wrong. You may also want to check www.kohadocs.org for further documentation about a debian based installation. cheers J0se _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

4 4