- Koha - lists.katipo.co.nz

Koha and old books
by Beda Szukics 30 Apr '13

30 Apr '13

Hi all I would like to use Koha to manage old and rare books according to the rules what habe been established by the Informationsverbund Deutschschweiz (http://kids.informationsverbund.ch/kids_deutsch/a0kidsinh.pdf) In part these rules are a translation of the AACR with some additions. As much as I have understood there are three additions to the default MARC framework that comes with Koha: 1. 752 $d is used for Place of publication in an authorized form. Therefore it is linked to a thesaurus containing authorized names of cities. 2. A new MARC-field 901 is used for persons connected with the specific item. They are specified by 8 different first indicators (autograph, marginalia, owner ... but I think 4 of them are not item-specific). 3. A new MARC-field 902 is used for corporate names connected with the item. Again there are 6 first indicators (owner, publisher ... again not all item-specific). What have I done so far? I created a new MARC framework for old book. I copied the subfields from 700 to 901, from 710 to 902 I linked 901 $a to the thesaurus PERSO_NAME, 902 $a to CORPO_NAME I added in etc/koha/zebradb/marc_defs/marc21/biblios/record.abs: melm 901$9 Cross-Reference,Koha-Auth-Number melm 901$a Author,Author:p melm 901$n Thematic-number melm 901$t Author-title,Name-and-title,Title,Title-uniform melm 901 Author,Author:p,Author-name-personal,Name,Editor,Personal-name melm 902$t Author-title,Name-and-title,Title,Title-uniform melm 902$a Name-and-title melm 902$9 Koha-Auth-Number melm 902 Author,Author:p,Corporate-name,Name (I copied those sections from 700 and 710) With these changings I can find the persons and the corporate authorities connected with the records of my old books. I can't do a specific search for them (for example: the owner of a book without having all the records in wich he/she is an author). In my next step I tried to make the authorized Place of publication usable. I created first a new type of authority record (Erscheinungs- oder Druckort), as suggested in http://kids.informationsverbund.ch/kids_deutsch/aut.pdf. I copied the framework for geographical names and added a field 152 with the subfields $d Name of the place, $6 and $8 I added in etc/koha/zebradb/marc_defs/marc21/authorities/record.abs # Ansetzung Erscheinungsort melm 152$d Name-geographic-heading:w,Name-geographic-heading:w,Name-geographic-heading:s,Name-geographic:w,Name-geographic:p,Heading:w,Heading:p,Heading:s,Heading-Main:w,Heading-Main:p,Heading-Main:s,Match:w,Match:p,Match-heading:w,Match-heading:p melm 152 Name-geographic:w,Name-geographic:p,Name-geographic:s,Heading:w,Heading:p,Heading:s,Match:w,Match:p,Match-heading:w,Match-heading:p And in etc/koha/zebradb/marc_defs/marc21/biblios/record.abs melm 752$d Name-geographic melm 752$9 Koha-Auth-Number melm 752 Name-geographic and hoped that would work too. Unfortunatly that's not the case. I can't search for the places. What is my mistake? Are my additions for the fields 901 and 902 correct? Greetings Beda

1 0

Error with Patron Image Upload - Help
by satish 30 Apr '13

30 Apr '13

Dear All, I am using Debian Squeeze 2.6.32-5-686 - Koha 3.10.03, With # perl koha_perl_deps.pl -m -u it says.... Installed Required Module is Module Name Version Version Required -------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------- Total modules reported: 0 * Module is missing or requires an upgrade. when I try to upload a patron image, it throws following error. Software error: Can't locate object method "newFromJpeg" via package "GD::Image" at /usr/local/lib/perl/5.10.1/GD/Image.pm line 81. the line 81 of /usr/local/lib/perl/5.10.1/GD/Image.pm is as shown below. 75 return unless my $fh = $pack->_make_filehandle($_[0]); 76 my $magic; 77 return unless read($fh,$magic,4); 78 return unless my $type = _image_type($magic); 79 seek($fh,0,0); 80 my $method = "newFrom${type}"; 81 return $pack->$method($fh); 82 } 83 return $pack->_new(@_); I tried the solutions provided at : http://serverfault.com/questions/343637/add-image-support-to-gd-on-debian still no .. success. Anybody has encountered the same and work around for this problem in details why it is occurring? Please help me to fix this? with thanks satish mv librarian govt. eng. college, hassan karnataka, India.

2 1

question about git install
by Samuel Desseaux 29 Apr '13

29 Apr '13

Hi! I've made a git install of koha. I've followed these instructions git clonehttp://git.koha-community.org/koha.git kohaclone cd kohaclone git checkout 3.10.04 So, when i make a git status, i've this # On branch v3.10.04 # Untracked files: # (use "git add <file>..." to include in what will be committed) # # MYMETA.json # MYMETA.yml # Makefile # blib/ # koha-tmpl/intranet-tmpl/prog/fr-FR/ # koha-tmpl/opac-tmpl/prog/fr-FR/ # pm_to_blib nothing added to commit but untracked files present (use "git add" to track) But, after installation, i'm on 3.11 (so, the next version). How can i solve this problem? Best regards samuel

1 0

Koha error
by pandu rangaswamy 29 Apr '13

29 Apr '13

Dear All, I tried to import the data(Books) from the existing koha 3.0 version to Koha version 3.10 in ubuntu 12.4. When i searched it shows only Books Biblios data only, its not showing the item details. Then i did undo the imported data, after that if i search again it shows 116 books. if i tried to edit record it shows the following error. Software error: Can't call method "title" on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 815. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. Kindly guide me to slow the error. With records M.Pandu Rangaswamy

2 1

Problem with XML::LibXSLT Module
by satish 27 Apr '13

27 Apr '13

Dear All, When I try to install the perl module - XML::LibXSLT , on Debian Squeeze 2.6.32-5-686 , for the installation of Koha 3.10.03, I am getting following error: -------------------------------------------------------------------------------------------------------------------------- Running install for module 'XML::LibXSLT' CPAN: YAML loaded ok (v0.71) Running make for S/SH/SHLOMIF/XML-LibXSLT-1.80.tar.gz CPAN: Digest::SHA loaded ok (v5.47) CPAN: Compress::Zlib loaded ok (v2.06) Checksum for /root/.cpan/sources/authors/id/S/SH/SHLOMIF/XML-LibXSLT-1.80.tar.gz ok CPAN: Archive::Tar loaded ok (v1.52) XML-LibXSLT-1.80/ XML-LibXSLT-1.80/perl-libxml-mm.h XML-LibXSLT-1.80/benchmark/ XML-LibXSLT-1.80/benchmark/Driver/ XML-LibXSLT-1.80/benchmark/Driver/Sablotron.pm XML-LibXSLT-1.80/benchmark/Driver/LibXSLT.pm XML-LibXSLT-1.80/benchmark/Driver/BaseClass.pm XML-LibXSLT-1.80/benchmark/benchmark.pl XML-LibXSLT-1.80/Changes XML-LibXSLT-1.80/LibXSLT.pm XML-LibXSLT-1.80/MANIFEST XML-LibXSLT-1.80/testcases/ XML-LibXSLT-1.80/testcases/default.conf XML-LibXSLT-1.80/example/ XML-LibXSLT-1.80/example/fatal.xsl XML-LibXSLT-1.80/example/2.xml XML-LibXSLT-1.80/example/bad3.xsl XML-LibXSLT-1.80/example/nonfatal.xsl XML-LibXSLT-1.80/example/1.xml XML-LibXSLT-1.80/example/bad2.xsl XML-LibXSLT-1.80/example/1.xsl XML-LibXSLT-1.80/example/2.xsl XML-LibXSLT-1.80/example/bad1.xsl XML-LibXSLT-1.80/Makefile.PL XML-LibXSLT-1.80/META.yml XML-LibXSLT-1.80/META.json XML-LibXSLT-1.80/README XML-LibXSLT-1.80/t/ XML-LibXSLT-1.80/t/04params.t XML-LibXSLT-1.80/t/rt71345_a.t XML-LibXSLT-1.80/t/09exslt.t XML-LibXSLT-1.80/t/06output.t XML-LibXSLT-1.80/t/03input.t XML-LibXSLT-1.80/t/08literal.t XML-LibXSLT-1.80/t/02dromeds.t XML-LibXSLT-1.80/t/06entities.t XML-LibXSLT-1.80/t/11utf8.t XML-LibXSLT-1.80/t/10functions.t XML-LibXSLT-1.80/t/05quick.t XML-LibXSLT-1.80/t/07blankdoc.t XML-LibXSLT-1.80/t/13error.t XML-LibXSLT-1.80/t/01basic.t XML-LibXSLT-1.80/t/14security.t XML-LibXSLT-1.80/t/12import.t XML-LibXSLT-1.80/t/15misc.t XML-LibXSLT-1.80/t/rt71345_b.t XML-LibXSLT-1.80/typemap XML-LibXSLT-1.80/LibXSLT.xs XML-LibXSLT-1.80/ppport.h XML-LibXSLT-1.80/perl-libxml-mm.c CPAN: File::Temp loaded ok (v0.2301) CPAN.pm: Going to build S/SH/SHLOMIF/XML-LibXSLT-1.80.tar.gz running xslt-config... ok looking for -lxslt... no libxslt not found Try setting LIBS and INC values on the command line Or get libxslt and libxml2 from http://www.libxml.org/ If you install via RPMs, make sure you also install the -devel RPMs, as this is where the headers (.h files) are. No 'Makefile' created SHLOMIF/XML-LibXSLT-1.80.tar.gz /usr/bin/perl Makefile.PL INSTALLDIRS=site -- NOT OK Running make test Make had some problems, won't test Running make install Make had some problems, won't install -------------------------------------------------------------------------------------------------------------------------- I did notice, looking for -lxslt... no libxslt not found Try setting LIBS and INC values on the command line Or get libxslt and libxml2 from http://www.libxml.org/ and tried to install libxslt and libxml2. still .. the same error. I went through many of the suggestions given at koha forum, no success. If somebody overcome this error with a fix, could please help me?? am done with most of the perl modules except this one. (Please provide me with version to be used and step by step installation procedure... ) Thank you in advance and waiting for your suggestions.. Satish MV Librarian. Govt. Engineering College, Hassan Karnataka | India.

2 2

Byte Order Mark issue importing patrons
by Coehoorn, Joel 26 Apr '13

26 Apr '13

I have a report to export a patron csv file from our student information system, suitable for use with the koha patron import tool. I want our librarians to be able to use every semester to import new freshmen and transfers to koha, without further IT assistance. They run a report, save it as a CSV file, and use that file for the import. Unfortunately, in testing this when I go to import the file I get an error message: "header row could not be parsed". I get an additional error for every row in the file, which is not surprising given the failure with the header row. I'm sure you've all heard this one before. Here's where things get different. I can open the file in Notepad++ and change the encoding to use not use a byte order mark. I save the *same file*, import that into koha, and **everything works fine**. The only thing different is the lack of a byte order mark. I cannot cause my reports tool to not use a BOM, and it's asking a lot of my librarians to edit the CSV file in this way. Is there anything I can do to tell koha to ignore that BOM? Should this be filed as a bug somewhere? In searching google on this issue, I think many others may have had this same problem in the past, but not been able to solve it. For what it's worth, I'd also love to see a koha stack exchange site, as these questions are exactly the kind of thing stack exchange excels at producing solutions for. Joel Coehoorn Director of Information Technology York College, Nebraska 402.363.5603 jcoehoorn(a)york.edu *The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society*

4 3

How to handle multiple copies/items or authors while converting excel data to MARC
by gipelibrary pune 26 Apr '13

26 Apr '13

Dear All Greetings from the GIPE Library! I have the bibliographic data in excel format. In accession Number column, I have the range of accession numbers say (23001-23005) for a single title having five copies. Will MARCEDIT take care if I separate each accession number with 'comma' or do I need to use any other special character as data separator. Similarly in Author field, I have more than one authors, say (Ranganathan, S R and Gopinath, M A and Prasad, A R D) for a single title. What should be the data separator for this field so that I can export the data from excel to MARC using MARCEDIT. Here in this case, I do not wish to use 'Comma' as it is already used for separating surname and the Initials. Awaiting your replies. Regards -- Dr Nanaji Shewale Librarian Gokhale Institute of Politics and Economics B M C C Road, Deccan Gymkhana Pune 411004 (India) T: 91 20 25679940 (Direct) T: 91 20 25654288, 25650287 Ext 401 http://www.gipe.ac.in

2 1

local use recorded / borrower
by Samuel Desseaux 26 Apr '13

26 Apr '13

Oups, error: it's when i scan a barcode of an item Hi, I've a bug on koha When i scan the card of the borrower, i've this message "local use recorded". What does it mean? Best regards samuel _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

3 3

Migrate transaction data
by gk 26 Apr '13

26 Apr '13

Dear Sir/Madam, I tried to export current circulation data from my legacy software to koha 3.8 but not successful. I tried LOAD DATA LOCAL INFILE '<PATH>/transactions.txt' INTO TABLE issues; and got the following error: ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`issues`, CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON UPDATE CASCADE). Please help me port current circulation data to koha. -- With Warm Regards *Gopalakrishna* Librarian *BMS Institute of Technology* Avalahalli, Dodballapur Main Road, Yelahanka, BANGALORE-560064 080-65369469 9741898674

1 0

String freeze for Koha 3.12
by Jared Camins-Esakov 26 Apr '13

26 Apr '13

Hello. The string freeze for Koha 3.12 will begin on May 1, next Wednesday. Any patches with string changes need to be written, signed off, and QAed before then. The absolute deadline for anything other than security fixes is 6am EST on Wednesday, May 1*. Regards, Jared Camins-Esakov [*] http://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+3.12+string+f… -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins(a)cpbibliography.com (web) http://www.cpbibliography.com/

1 0