September 2003 - Koha - lists.katipo.co.nz

Data Conversion
by Luke Ottrey 01 Oct '03

01 Oct '03

Good Morning All, Am after some kind words of advice from anyone who may know how to do this. On IRC, I spoke with Chris and asked the question, "Can I insert direct into Koha's database for migration, or does it have to be MARC format?" Chris' response implied that since v.1.3, that its not easy to insert direct into MySQL with the information and that I should contact the list as Paul may have some advice on either how to do it or, how I can create MARC from the structure I have. At the moment, I have tab delimetered file (as per attached (column headings up the top), but with quite a few more records in the file :)). Presently, I'm just seeking to get the library up by the end of the week and superfluous data fields (cost, the 'extent' column, acquisition year etc) are irrelevant if they'll be difficult to implement. FYG, my plan is to send off MARC requests (we have a request and receive type of system for MARC records from the Department of Education), put them in the breeding farm for those records with ISBN's so we can get some more information on the books than is currently stored in the system. If anyone has any ideas and or thoughts - or could be kind enough to point me in the direction of either: a. How to import the data direct into the MySQL tables - which tables and fields? (and I do have a pretty good knowledge of MySQL etc etc) b) How to create MARC from this data (limited knowledge of PERL, PHP etc but willing to learn to make it happen) Or, if anyone had the time to create the script required that would be tops. Thanks for your time and I'm really glad to be one of the people supporting Koha in our Government education department (primary school) as an Open Source alternative to the proprietary programs out there. Photos and documentation of the implementation will be available once completed :) (BTW, currently running pre3, and will be putting pre4 on tonight) Thanks/Best Regards, Luke Ottrey, Purple Lion Ph: 0408 675 648 Fax: +61 3 9886 7349 Email: luke(a)purplelion.net Web: www.purplelion.net

2 1

Re: [Koha] biblionumber to delete
by Stephen Hedges 01 Oct '03

01 Oct '03

Serge Renaux wrote: > I try to clean our Koha mysql database after that > a librarian 'played' > with the acquisitions module. > I deleted the bilblionumber in biblio, > biblioitems, items and marc_biblio . > I can see my biblionumber still in the database > after searching with > catalogue/marc search tool. > > Do you know where can i find the biblionumber > that i have to delete / Serge, the marc_biblio table is a cross-reference between the original Koha tables (biblio, biblioitems, items, etc) and the MARC tables (marc_subfield_table and marc_word). Records in the original Koha tables have a biblionumber, while records in the MARC tables have a bibid, and the marc_biblio table keeps track of which biblionumber links to which bibid. If you are importing and adding MARC records, your bibid will generally be the same as your biblionumber. (Because of the nature of MARC records, you will almost always have one biblio and one biblioitems record for each MARC record.) I suspect what you are seeing with the MARC search tool is not the biblionumber but the bibid. Try doing a SELECT * FROM marc_subfield_table WHERE bibid = [?whatever the biblionumber was] and I bet you will see the same record you are seeing on the MARC search screen. Stephen Hedges Nelsonville Public Library

2 1

Re: [Koha] Koha documentation
by Nicholas S. Rosasco 01 Oct '03

01 Oct '03

I just sent a response to this, I hope you all got it, if not (I'm on a deadline for something), will elaborate later. Short item: Yes, there are french versions of the docs. I have the source, as does the doc controller (www.haz.cmsd.bc.ca/cgi-bin/upload, I think, for those of you with accounts on it). I have more info, and a beg/plead/hoping for assist request, which you may or mayn't have seen (silly webmail client may've eaten it)..... Nick Quoting paul POULAIN <paul.poulain(a)free.fr>: > Chris Cormack wrote: > > >On Mon, Sep 29, 2003 at 03:01:47PM +0200, Serge RENAUX said: > > > > > >>Hi, > >> > >>I have to make Koha documentation for our librarian. > >>I need to explain how circulation, acquisitions and catalogue are working. > >>Do you know if someone has made some documentations ? > >> If yes, where can i get it ? > >> > >> > >Hi Serge, > > > >Nick the Documentation manager will be able to tell you exactly what the > >state of the documentation is. > >But in 99% certain documentation for this has been written. > > > > > Better : it has been translated to french. > I'll look at where it is hidden, as I don't know yet. > > -- > Paul POULAIN > Consultant indépendant en logiciels libres > responsable francophone de koha (SIGB libre http://www.koha-fr.org) > >

1 0

Multiple Marc Records
by Gregg Ferrie 30 Sep '03

30 Sep '03

It appears from our brief look at Koha having just installed it that you can only input one Marc record at a time. Is there a way to import multiple records? Thanks all Gregg Ferrie Manager of Information Technology Administrator - Henry Grube Education Centre School District #73 Kamloops/Thompson (250) 376-2266

3 2

barcode NOT mandatory [done]
by paul POULAIN 30 Sep '03

30 Sep '03

I've created the patch that makes barcode NOT mandatory in Koha. It's in CVS, and will be in next public release. PS : for those intereseted : download CVS version somewhere. run updatedatabase script (don't forget to export PERL5LIB=/your/path/to/koha) That's all. No code involved in Koha. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

biblionumber to delete
by Serge RENAUX 30 Sep '03

30 Sep '03

Bonjour, I try to clean our Koha mysql database after that a librarian 'played' with the acquisitions module. I deleted the bilblionumber in biblio, biblioitems, items and marc_biblio . I can see my biblionumber still in the database after searching with catalogue/marc search tool. Do you know where can i find the biblionumber that i have to delete / Regards Serge -- Serge Renaux Groupe ESIEE / CCI Paris EMail:s.renaux@esiee.fr Tel:(33)1.45.92.67.46

1 0

RE: [Koha] z3950 problem found to be bug #511
by Tim Stevens 30 Sep '03

30 Sep '03

Paul, I installed the new addbiblio.tmpl and still had the problem. I did some working on the PopZ3950 function and found the real problem to be a space in the title parameter for the window.open function. Previously: newin=window.open('...', 'Z3950 Search', '....'); Now: reviously: newin=window.open('...', 'Z3950Search', '....'); And the search window pops up as it should. I don't know if this is a bug in addbiblio.tmpl or Internet Explorer, but either way the above change corrects the problem. I haven't replied yet because my search does not find anything when looking for an ISBN from the Library of Congress. I do a search from the LOC website directly and find it. So I have another issue I'm working on. Tim -----Original Message----- From: paul POULAIN [mailto:paul.poulain@free.fr] Sent: Friday, September 12, 2003 7:13 AM To: Tim Stevens Subject: Re: [Koha] z3950 problem found to be bug #511 Tim Stevens wrote: >Paul, >I just checked the cvs on sourceforge, and only saw the files I downloaded yesterday in cvs: addbiblio.pl and addbiblio.tmpl. >Am I looking in the wrong place? > > if you look through cvsweb, yes, it's a wrong place. SF has perf problems with cvsweb and show backup, not real cvs since july. cvsweb maybe 1-2 days different from "true cvs". I can see koha-tmpl/intranet-tmpl/default/en/acqui.simple/addbiblio.tmpl is in v1.22 The only difference is in the PopupZ3950() sub (end of template), that has NO MORE parameters. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

2 1

huge isbn numbers on the way!
by COURYHOUSE＠aol.com 30 Sep '03

30 Sep '03

Leave lots of room that field folks...... Check out.... <A HREF="http://publishersweekly.reviewsnews.com/index.asp?layout=article&articleid=…">http://publishersweekly.reviewsnews.com/index.asp?layout=article& articleid=CA325273&display=breakingNews&publication=publishersweekly</A> Thanks Ed Sharpe, Archivist for SMECC See the Museum's Web Site at www.smecc.org We are always looking for items to add to the museum's display and ref. library please advise if you have anything we can use. mail: Coury House / SMECC 5802 W. Palmaire Ave. Glendale Az 85301 USA 623-435-1522

2 1

Koha documentation
by Serge RENAUX 30 Sep '03

30 Sep '03

Hi, I have to make Koha documentation for our librarian. I need to explain how circulation, acquisitions and catalogue are working. Do you know if someone has made some documentations ? If yes, where can i get it ? Regards Serge -- Serge Renaux Groupe ESIEE / CCI Paris EMail:s.renaux@esiee.fr Tel:(33)1.45.92.67.46

3 2

RE: [Koha] Query
by Williams, Olwen - SAL 30 Sep '03

30 Sep '03

How about sticking with MySQL for Koha and using MyODBC (from http://www.mysql.com <http://www.mysql.com> ) to connect Access to the database Olwen Williams olwen.williams(a)safeair.co.nz -----Original Message----- From: Bernadette Cassidy [mailto:BernadetteC@burwood.org.nz] Sent: Tuesday, September 30, 2003 11:01 AM To: koha(a)lists.katipo.co.nz Subject: [Koha] Query Hi, Does anyone know of an OBCD driver which will connect Microsoft Access to Koha database? Cheers, Bernadette ___________________________________________ Bernadette Cassidy Library & Learning Coordinator Allan Bean Centre Burwood Hospital Christchurch New Zealand Tel: (03) 383 9492 Fax: (03) 383 7500 ____________________________________________________________________ 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