- Koha - lists.katipo.co.nz

tag not visible in the Add/Edit Biblio page
by John Fitzgibbon 25 Nov '05

25 Nov '05

Hi, On my server, the 090a tag is defined as "Koha Itemtype" and I have set the Koha link to biblioitems.itemtype. The only problem now is the 090 tag is not visible in the Add/Edit Biblio page. How do I make it visible here? Any help would be much appreciated. Regards John John Fitzgibbon Galway Public Library Island House Cathedral Square Galway Ireland p: 00 353 91 562471 f: 00 353 91 565039 w: http://www.galwaylibrary.ie ******************************************************************* T� eolas at� pr�obh�ideach agus r�nda sa r�omhphost seo agus aon iat�n a ghabhann leis agus is leis an duine/na daoine sin amh�in a bhfuil siad seolta chucu a bhaineann siad. Mura seola� th�, n�l t� �daraithe an r�omhphost n� aon iat�n a ghabhann leis a l�amh, a ch�ip�il n� a �s�id. M� t� an r�omhphost seo faighte agat tr� dhearmad, cuir an seolt�ir ar an eolas thr� aischur r�omhphoist agus scrios ansin � le do thoil. This e-mail and any attachment contains information which is private and confidential and is intended for the addressee only. If you are not an addressee, you are not authorised to read, copy or use the e-mail or any attachment. If you have received this e-mail in error, please notify the sender by return e-mail and then destroy it. *********************************************************************

2 1

Newbie: Windows NT server, Linux and Koha
by Fabian Kruse 25 Nov '05

25 Nov '05

Hello to all members of the group! I have been visiting the Koha site for some weeks now, reading the Wiki etc. to get more or less an idea of how it works, being a network newbie. I´m doing an internship in a big organization and right now we are searching for a system to organize our small library containing some 3000 books, growing about 100 titles a month. Koha seems to be the perfect solution in flexibility, TCO and "sympathy". My problem in convincing the people to give it a try is that all the systems in the organization work windows-based, the server on Win NT, and I do not have enough network knowledge to be able to discuss the topic with the Admin. So, here´s my question: I have right now two different solutions in mind for getting started with Koha in our office - does any of those work or do you have another idea? 1. Get a new PC, install - let´s say - Fedora Core, install Apache, Perl, PHP and Koha. Connect this system to the Windows NT server and be able to provide access to Koha to all 50 workstations of the office. There is no need to provide public access (yet), so I think the system has not be the latest server hardware, but a normal workstation would do. But: is it possible to connect the Linux PC to the Windows NT server and enable it to be accesible for ALL Windows workstations of the office?!? 2. Install Koha on Windows, as described in the manual. Z39.50 would not work as I understand it, but I think we could live without it. I would PREFER the first solution, just to let the NT server untouched. Would this work? I appreciate very much every thought on this topic; if anyone has a good weblink for a NT/Linux-network introduction I would be grateful as well. Thanks a lot and keep up the cool work! :)) Fabian

3 4

Z39.50 error
by Greg Vickers 24 Nov '05

24 Nov '05

Hi all, I am helping a library in Brisbane to install Koha and we are seeing a strange error when trying to use the Z39.50 daemon. I have not touched Koha prior to this, neither this Z39.50 thingy :) Nor much MySQL. We are using Koha 2.2.4. The errors in /usr/local/koha/logs/koha-error_log: [Wed Nov 23 22:17:00 2005] [error] [client 127.0.0.1] DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /usr/local/koha/intranet/modules/C4/Breeding.pm line 167. [Wed Nov 23 22:17:00 2005] [error] [client 127.0.0.1] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Breeding.pm line 168. I suppose there is an error in the Breeding.pm module - here is the code around these lines: 167 $sth = $dbh->prepare($query); 168 $sth->execute(@bind); 169 while (my $data = $sth->fetchrow_hashref) { Can anyone give us any pointers on this and advise us on what is happening and what we may have to do to fix it? Thanks, Greg

4 4

Reseting the database and MARC upload question
by Mikel Larreategi 23 Nov '05

23 Nov '05

Hi: I've been doing some tests uploading some MARC records to the database, both using the bulkmarcimport script and uploading a MARC file to the deposit. - Which is the difference between uploading records with bulkmarcimport and uploading a MARC file from the Intranet? - How can I reset the database in order to clear all book and item info? Thank you in advance, -- Mikel Larreategi mlarreategi(a)codesyntax.com CodeSyntax Azitaingo Industrialdea 3 K E-20600 Eibar Tel: (+34) 943 82 17 80

1 0

Z3950 server error
by Carol Ku 22 Nov '05

22 Nov '05

There have been numerous questions on getting Z3950 server to work. I am particularly interested in searching MARC at LOC database, however after I put in the host name port name for LOC, Z3950 search gives me the following message: Nothing found Still ?? requests to go. Can anyone help? --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click.

2 1

data importing problem
by venkatesh＠au-kbc.org 21 Nov '05

21 Nov '05

I try to migrate from ISS to koha. I followed your migration guide http://www.au-kbc.org/nrcf/index.htm for migration. First as test phase i used XML file (given in that doc)for importing data (xml file : docs.xml) using your python script i converted it docs.txt and finally using your oer script i creatd docs.out Now im trying to import this data in koha using the following command /usr/local/koha/intranet/scripts/misc/migration_tools/bulkmarcimport.pl -v -file docs.out but it is giving the following error Error in NEWnewbiblio : biblio.biblionumber and biblioitems.biblioitemnumber MUST have the same field number at /usr/lib/perl5/site_perl/5.8.3/C4/Biblio.pm line 1259. Content-Type: text/html Died at /usr/lib/perl5/site_perl/5.8.3/C4/Biblio.pm line 1263. Error in NEWnewbiblio : biblio.biblionumber and biblioitems.biblioitemnumber MUST have the same field number help me to solve this problem, thanks in advance Note : im attaching the error.zip file, it contains the follwoing file 1. docs.xml 2. docs.txt 3. docs.out 4. marc_converter.pl (perl script u given in doc) 5. xml_to_txt.py (python script u given in doc) 6. screen.gif (error screen shot) Your earlier reply will be very much helpful for us. Regds Venkatesh.K

2 1

koha migration : importing problem
by venkatesh k 19 Nov '05

19 Nov '05

Hi group, I try to migrate from CDS/ISIS to koha. I followed the following migration guide http://www.kohadocs.org/CDS_ISIS_to_Koha.html for migration First as test phase i used XML file (given in that doc)for importing data (xml file : docs.xml) Using your python script i converted it docs.txt and finally using the perl script i creatd docs.out Now im trying to import this data in koha using the following command /usr/local/koha/intranet/scripts/misc/migration_tools/bulkmarcimport.pl -v -file docs.out but it is giving the following error Error in NEWnewbiblio : biblio.biblionumber and biblioitems.biblioitemnumber MUST have the same field number at /usr/lib/perl5/site_perl/5.8.3/C4/Biblio.pm line 1259. Content-Type: text/html Died at /usr/lib/perl5/site_perl/5.8.3/C4/Biblio.pm line 1263. Error in NEWnewbiblio : biblio.biblionumber and biblioitems.biblioitemnumber MUST have the same field number help me to solve this problem, thanks in advance Note : im attaching the error.zip file, it contains the follwoing file 1. docs.xml 2. docs.txt 3. docs.out 4. marc_converter.pl (perl script u given in doc) 5. xml_to_txt.py (python script u given in doc) 6. screen.gif (error screen shot) Your earlier reply will be very much helpful for us. Regds Venkatesh.K

1 0

bulkmarcimport failure
by Hilary Forrest 18 Nov '05

18 Nov '05

Hello, I've installed Koha 2.2.4 on a machine running Debian 3.1 Sarge, apache2, and mysql 4.0.24. I've been trying to import data which were exported from an Inmagic database. There are about 19,000 records I want to import. Importing them all at once failed so I have tried to import in batches of about 1000 using the bulkmarcimport.pl -c MARC21 --file mydatafilename.xpo command. Each group of records takes longer than the previous group. I can import about 7 groups (sometimes more) and then get the following error: DBD::mysql::st execute failed: Duplicate entry '4035225266124136448' for key 1 at /path/to/C4/Biblio.pm line 459 ERROR ==> insert into marc-subfield_table (field names here) values (values here) I have also had errors relating to the marc_word table. This table gets quite large. Any help or ideas would be greatly appreciated. Hilary

1 0

backing up Koha
by John Fitzgibbon 18 Nov '05

18 Nov '05

Hi, I wish to backup the Koha database. If I start mysqladmin as the root, what commands do I issue to backup the files? Is there a document setting this out? Any ideas would be most appreciated. Regards John John Fitzgibbon Galway Public Library Island House Cathedral Square Galway Ireland p: 00 353 91 562471 f: 00 353 91 565039 w: http://www.galwaylibrary.ie ******************************************************************* T� eolas at� pr�obh�ideach agus r�nda sa r�omhphost seo agus aon iat�n a ghabhann leis agus is leis an duine/na daoine sin amh�in a bhfuil siad seolta chucu a bhaineann siad. Mura seola� th�, n�l t� �daraithe an r�omhphost n� aon iat�n a ghabhann leis a l�amh, a ch�ip�il n� a �s�id. M� t� an r�omhphost seo faighte agat tr� dhearmad, cuir an seolt�ir ar an eolas thr� aischur r�omhphoist agus scrios ansin � le do thoil. This e-mail and any attachment contains information which is private and confidential and is intended for the addressee only. If you are not an addressee, you are not authorised to read, copy or use the e-mail or any attachment. If you have received this e-mail in error, please notify the sender by return e-mail and then destroy it. *********************************************************************

2 1

specifying an item's item type
by John Fitzgibbon 18 Nov '05

18 Nov '05

Hi, Where in Koha do I add the item type of a book? When I click the 'Add Item' button, I'm brought to a page entitled 'New Item' which has a form that allows me to specify the item's barcode, its price, the holding library etc. but does not have a field for 'Item type'. I have set up values of 'JF' (Juvenile Fiction) and 'JNF' (Juvenile Non-Fiction) as Item types under Parameters but these are not available to me in the 'New Item' form. Any help would be much appreciated. Regards John John Fitzgibbon Galway Public Library Island House Cathedral Square Galway Ireland p: 00 353 91 562471 f: 00 353 91 565039 w: http://www.galwaylibrary.ie ******************************************************************* T� eolas at� pr�obh�ideach agus r�nda sa r�omhphost seo agus aon iat�n a ghabhann leis agus is leis an duine/na daoine sin amh�in a bhfuil siad seolta chucu a bhaineann siad. Mura seola� th�, n�l t� �daraithe an r�omhphost n� aon iat�n a ghabhann leis a l�amh, a ch�ip�il n� a �s�id. M� t� an r�omhphost seo faighte agat tr� dhearmad, cuir an seolt�ir ar an eolas thr� aischur r�omhphoist agus scrios ansin � le do thoil. This e-mail and any attachment contains information which is private and confidential and is intended for the addressee only. If you are not an addressee, you are not authorised to read, copy or use the e-mail or any attachment. If you have received this e-mail in error, please notify the sender by return e-mail and then destroy it. *********************************************************************

2 1