- Koha - lists.katipo.co.nz

Problems in generating reports
by Priyanka Mishra 10 Jan '06

10 Jan '06

I am facing problem in getting the reports.As I was not able to get the reports from the package ,I had plans of taking it out through queries.cananyone please tell me how do I make a batch file for the queries so that the librarian need not give individual commands to run queries ,but can execute a batch file which contains a menu for all the desired kind of reports. My work is stuck due to this .I wud really appreciate ur help -- Regards Priyanka

2 1

Koha Installation Problem
by Sakaio Manoa 10 Jan '06

10 Jan '06

Where do you normally install koha /etc/ or /var/www/html? With regard to the installer.pl - is it alright if you leave the default settings as suggested in the installer.pl during the installation? Any directions to koha installation guide or help will be very much appreciated Cheers Sakaio P Manoa SOPAC South Pacific Applied Geoscience Commission Postal Address: Private Mail Bag, GPO, Suva, Fiji Islands Street Address : Mead Road, Nabua, Fiji Islands Tel: +679 338 1377, Fax: +679 337 0040 E-Mail: <mailto:sakaio@sopac.org>: Web site: <http://www.sopac.org/> Note that the gateway to our mail server limits the size of inwward and outward messages with attachments to 1.5MB. I you need to send or receive larger messages apply compression, convert to PDF files or logically split. This e-mail is intended for its named recipients only. The author is no longer responsible if you forward this e-mail to other parties. The views expressed in this e-mail may not be the views of SOPAC.

2 1

question about how reserves work
by Cindy Murdock 10 Jan '06

10 Jan '06

Hello all, For those of you with more than one library or branch, I have a question about how reserves work. Is there only one reserve queue per biblio, regardless of how many branches have copies of the item? Stephen, how do you handle it at Nelsonville? I only have one library's records in our database presently, so I'm not able to fully try it out yet. Thanks, Cindy -- _________________________ Cindy Murdock Network Administrator Meadville Public Library | Crawford County Federated Library System meadvillelibrary.org | ccfls.org

2 1

Re: [Koha] MARC field 650
by Steven F.Baljkas 10 Jan '06

10 Jan '06

Monday, January 9, 2006 19:43 CST Hi, Wojciech, In short answer to your question, Koha is still catching up with MARC standards (the original contractor that initiated its development was MARC-phobic). It is still not clear to me if there has been a release target established for full MARC compliance yet. For the meantime, there have been various workarounds suggested (ones that, unfortunately, are not acceptable to libraries requiring full MARC compliance in their ILS: you will know your library's situation). If you check back through the Archives you will find various temporary solutions proposed, although none are complete resolutions since the 650 needs to be repeatable to cover all the data that can be in valid MARC 650 fields. Hope this helps a bit. Sincerely, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada ============================================================ From: Wojciech Zatorski <listy-in(a)zatorski.net> Date: 2006/01/09 Mon PM 01:08:47 CST To: koha(a)lists.katipo.co.nz Subject: [Koha] MARC field 650 Hello koha, I have one small question why MARC field 650 is not repeated as required MARC format? example: http://212.14.16.131:8001/cgi-bin/koha/opac-MARCdetail.pl?bib=6101 (polish template only work) is: 650 - S?owo kluczowe a Topical term or geographic name as entry element pi?te rozszerzenie UE a Topical term or geographic name as entry element Wspólna Polityka Zagraniczna i Bezpiecze?stwa a Topical term or geographic name as entry element Europejska Polityka Bezpiecze?stwa i Obrony a Topical term or geographic name as entry element umowy o patnerstwie a Topical term or geographic name as entry element Europejska Polityka S?siedztwa a Topical term or geographic name as entry element Ukraina a Topical term or geographic name as entry element Bia?oru? a Topical term or geographic name as entry element Polska a Topical term or geographic name as entry element polityka wschodnia UE a Topical term or geographic name as entry element Partnerstwo Euro?ródziemnomorskie should be: 650 - S?owo kluczowe a Topical term or geographic name as entry element pi?te rozszerzenie UE 650 - S?owo kluczowe a Topical term or geographic name as entry element Wspólna Polityka Zagraniczna i Bezpiecze?stwa (...) any idea?:) -- <wojciech(a)zatorski.net> tel. +48 509-855-239; GG: 1500861; Skype: zatorski http://www.Zatorski.Net -- While the cat is away, the mice will play. _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ============================================================

1 0

Koha 2.2.5 is available for download
by Paul POULAIN 10 Jan '06

10 Jan '06

RELEASE NOTES ============= Koha is the 1st Open-Source Integrated Library System. Released at first in New zealand, in 2000 januaray, it is maintained by a team of volunteers from around the globe, the Koha system is a full catalogue, opac, circulation and acquisitions system. Koha 2.2 is more than 247 000 lines of code, developped by more than 30 differents developpers (excluding translators). With the 2.2 version, Koha is now a mature product, with a lot of nice features. It's used in more than 100 libraries, from all kinds (public, schools, search, religious...), of all size (from 1 to 8 branches, from 1000 to 300 000 items). The developpers tools have changed. Koha is now hosted by savannah. the home page of the project is now : http://savannah.nongnu.org/projects/koha/ while you can download packages here : http://download.savannah.nongnu.org/releases/koha/ ======== WARNINGS ======== * The librarian interface is tested only with mozilla/firefox. Should work (partially) with IE. OPAC should work fine with any navigator. * The installer is *wrong* on languages available. In this release, french & english are uptodate. Other language po files are provided in the package. If you update/complete one of them, please send it at paul.poulain @ free.fr, it will be included in a 2.2.4b release ! KNOWN BUGS : ****** Critical/blocking : none see bugs.koha.org for more information. Please report any problem in bugs.koha.org Apple users : it seems there is an annoying bug in firefox, that you can have in librarian biblio search : only the 1st MARC field list is available, the others can't be opened. The problem is related and fixed here : http://www.macfixit.com/article.php?story=20051226091140372 ======= DIFFS ======= Diff 2.2.4 => 2.2.5 ******************* DB MODIFS : *********** DB structure : none DB content : none Koha opac stylesheets : none BUGFIXES === ACQUISITION === * suggestion/acquisition bugfixes : - 200 field is no more splitted in 2 parts - author is after title in UNIMARC (dirty code, but mySQL has a strange behaviour) - when the book is recieved, the suggestion is marked "available" and a mail is sent * printing stylesheet dropped ALL <p> (hiding too many things in order printing) * when a budget has no line (or an outdated line) it does not appear anymore in acquisition * orders where always attached to the last budget line, not to their real line (=depending on date) === CATALOGUE === * There was an annoying bug in search when 2 search terms were separated by 2 spaces or an "empty character" (like .,; ...) : the search was truncated and the result not correct. === CATALOGUING === * Repeated subfield in authority were not being reported in the biblio while cataloguing * when AutoBarcode=ON and MARC=ON the barcode was not calculated automatically. Now, the barcode will be calculated (and any manual entry discarded during save) * added a feature to enable reordering of subfields in MARC editor (can be considered as a bug ? at least one of my libraries think that yes !) * when a note is added to items it was not stored into non MARC-DB * permission required to use a plugin was wrong. Changed to "editcatalogue", more convenient. * if the last field was an authority, the authority report generated a javascript error (going after array size) * It was impossible to add a subfield with value 0. * additionalauthors were uncompletly deleted on biblio deletion. * (UNIMARC specific bugfix) when an editor is entered, with no ISBN, the collection plugin (225a) can find collections attached to the editor name. Note that if there are more than 1 EDITORS authority for a given editor, only the 1st will be used to create collection list. * when adding a biblio, after searching in DB and reservoir, the page manager in the result list was buggy (isbnsearch.pl) * bugfix in almost all unimarc plugins : under certain circumstances, for some digits, a value could be lost on modification (1 byte values mainly) * added a usmarc_field_952v.pl plugin (joshua) : Adds a function to autogenerate the date for dateaccessioned for usmarc * in MARC editor, if the last field of last tab was an authority, it was impossible to report the selected authority into the biblio. * deleted biblio/biblioitems/items tables had a not the same structure than their non deleted "sister". During update, a new tool modify automatically their structure to have deleted records correctly stored. === AUTHORITIES === * fixing bug in summary (separator before subfield was in fact after) * fixing bug in authority order : authorities are not ordered alphabetically instead of no order. Requires all the dataset to be retrieved, but the benefits is important ! * The "used in X biblios" button has been removed for EDITORS, as it's always 0 and does not work as EDITORS are pseudo-authorities === SERIALS === * Ordering bull-home better : by title === CIRCULATION === * minor bugfix : showing date in format from systempreferences * minor bugfix : the "edit borrower link in circulation screen was buggy === MEMBERS === === REPORTS === * Lot of bugfixes and improvements in borrower issues, catalogue issues, issues stats (not detailed, sorry, discover by yourself) === ALL === * bugfixes in ldap auth (bugfixes from 2.2.4, 2.2.3 was not buggy) === OPAC === * adding dashes in isbn in opac-detail.pl * translation bug ISSN translated to ISBN in french , very annoying mistake ! + some other translations * ordering by acquisition date was buggy. IMPROVEMENTS === ACQUISITION === * added a menu & a screen to see late issues attached to a bookseller. === CIRCULATION=== * In overdue list, Added some filter features : - filter on borrower firstname, surname or cardnumber. **This can be discussed and changed** - filter on borrowercategory - filter on itemtype - filter on branch - show all current issues. * Added a reserve management page in circulation module. It basically displays all the reservations not cancelled. * Adding a systempreference to notice the library before departure of a borrower. when borrower leaves the library in less than 'NotifiyBorrowerDeparture', the circulation desk shows it. === CATALOGUE === === CATALOGUING === * as the MARC editor begins to be really heavy, i've also added a marc_hide systempref. It hides all marc features not requested by libraries that want MARC but not too much. It hides MARC tag & subfield code, reordering buttons as well as indicators. by default, hide_marc is off === MEMBERS === === OPAC === * by default, recent acquisitions are done on 30 days. * New systempreference : OpacPasswordChange if set to Yes (default) the user can change it's password. If set to No, he can't. Useful for libraries with LDAP auth, where the password is checked in LDAP, not in Koha, thus Koha can't change it * New alternate stylesheet for OPAC : go to librarian interface >> parameters >> System preferences >> OPAC >> modify opacstylesheet and enter : /opac-tmpl/css/opac2.css === SERIALS === * ordering lists by biblio title * when adding a subscription and searching a biblio, you can filter on itemtype (useful as libraries usually have one or few itemtypes specific for serials) === SYSTEM PREFERENCES === * The export tool has been improved a lot : the library can now select a branch, and itemtype or callnumber limits. Plus the export can be limited to X records (for testing purposes before a larger export) === ALL == * online help added for some screens. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

3 2

MARC field 650
by Wojciech Zatorski 09 Jan '06

09 Jan '06

Hello koha, I have one small question why MARC field 650 is not repeated as required MARC format? example: http://212.14.16.131:8001/cgi-bin/koha/opac-MARCdetail.pl?bib=6101 (polish template only work) is: 650 - Słowo kluczowe a Topical term or geographic name as entry element piąte rozszerzenie UE a Topical term or geographic name as entry element Wspólna Polityka Zagraniczna i Bezpieczeństwa a Topical term or geographic name as entry element Europejska Polityka Bezpieczeństwa i Obrony a Topical term or geographic name as entry element umowy o patnerstwie a Topical term or geographic name as entry element Europejska Polityka Sąsiedztwa a Topical term or geographic name as entry element Ukraina a Topical term or geographic name as entry element Białoruś a Topical term or geographic name as entry element Polska a Topical term or geographic name as entry element polityka wschodnia UE a Topical term or geographic name as entry element Partnerstwo Eurośródziemnomorskie should be: 650 - Słowo kluczowe a Topical term or geographic name as entry element piąte rozszerzenie UE 650 - Słowo kluczowe a Topical term or geographic name as entry element Wspólna Polityka Zagraniczna i Bezpieczeństwa (...) any idea?:) -- <wojciech(a)zatorski.net> tel. +48 509-855-239; GG: 1500861; Skype: zatorski http://www.Zatorski.Net -- While the cat is away, the mice will play.

1 0

printing barcodes
by kael＠email.arizona.edu 07 Jan '06

07 Jan '06

Hi, When creating and printing barcodes what symbology does Koha use? From what I can tell it looks like it is using either EAN-13 or UPC-A. In the User's Guide (4.3) it says it uses EAN-128, does Koha support EAN-128? The only success I have had is when the Number System (Country Code) is 0, followed by 11 digits, and when the check digit is automatically generated. When I use other country codes, like 978, what gets scanned doesn't match with whats in the items barcode data. Thank you, Kael

2 1

Re: [Koha] Something new with bulkmarcimport.pl
by Andro Gagne 07 Jan '06

07 Jan '06

Stephen, At 07:53 PM 1/5/06 -0500, you wrote: >Andro, I've forgotten what Koha version you are using. I'm not at the museum as I write this. If I remember correctly, I'm using ver. 2.2.2. > The Biblio.pm line >numbers you list don't match my (2.2.4) Biblio.pm. > >In any case, I would guess that you have some MARC records in the file >that have errors. That's what I was thinking at first, of course. It looked like I was getting a steady stream of messages saying "DBD::mysql::db do failed: Access denied for user: 'myuserid@localhost' to database 'libcat' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 331. [or 426.]" on the screen. It looked like there were hundreds of lines of these messages--so many that I could not scroll back to the first one. But when I searched for records, I found that there were quite a few records in the database. And this was the first time I had attempted importing MARC records. To confuse matters more, the last line of the script's output, "1572 MARC record done in 731.838590145111 seconds," made me wonder whether the script was telling me 1,572 records had been imported successfully or just telling me that 1,572 records had been processed, giving me no information about successful imports. As this first import of records was done without mapping item information in the MARC records to the Koha database's item field, I could not get a report of the number of items in the OPAC. I'm hoping I can use bulkmarcimport.pl to delete all of the current records in the OPAC database so I can properly map the item information tag(s) and re-import the records. If I remember correctly, bulkmarcimport.pl has a switch that will allow me to delete the records in the OPAC. If you have any advice for me on this point, I'd be very pleased to hear it. > There is another script in the intranet/scripts/misc >directory called dumpmarc.pl that will simply list out your MARC file. But >with 1500+ records, it wouldn't be much fun looking for stray errors! I am familiar with it, as I used it to look over a number of records to make sure they looked like they were in good shape before trying to import them. However, as you can imagine, I did not examine all 1,572 of them. To resolve my issue with bulkmarcimport.pl, what I may need to do is to get a batch of only 10 records in a file, examine them in dumpmarc.pl, and then import them with bulkmarcimport.pl. If I get the same kind of screen output from bulkmarcimport.pl with those records, I will have a much more manageable situation to deal with. >You could also use this script to find the title of the last record in the >file. Do a search on that title and the Biblionumber on the screen should >equal the number of records in your catalog -- assuming you haven't yet >been doing any deleting of records. That's a very good suggestion, as I haven't deleted any of the imported records. Thanks. Best regards, Andro P. Gagné P.O. Box 715 Canandaigua, NY 14424

3 3

koha installation on mandriva 2006
by Sakaio Manoa 07 Jan '06

07 Jan '06

I have finished the installation of the PERL dependencies and koha on Mandriva 2006. Apart from running the installer.pl to install koha - Are there any other scripts that are required? I have reached the stage where it asked me to type "http://localhost:80/ and the results is "it works" however when I tried the http://localhost:8080/ <http://localhost:8080/> as instructed it gave me a 403 error. Access forbidden I am planning to replace our current CDS/ISIS system with KOHA and would very much appreciate any help to kick start my Koha implementation Cheers Sakaio P Manoa SOPAC South Pacific Applied Geoscience Commission Postal Address: Private Mail Bag, GPO, Suva, Fiji Islands Street Address : Mead Road, Nabua, Fiji Islands Tel: +679 338 1377, Fax: +679 337 0040 E-Mail: <mailto:sakaio@sopac.org>: Web site: <http://www.sopac.org/> Note that the gateway to our mail server limits the size of inwward and outward messages with attachments to 1.5MB. I you need to send or receive larger messages apply compression, convert to PDF files or logically split. This e-mail is intended for its named recipients only. The author is no longer responsible if you forward this e-mail to other parties. The views expressed in this e-mail may not be the views of SOPAC.

3 2

help with server error: error 500
by Christine Forte 07 Jan '06

07 Jan '06

hello everyone -- after 1.) having my network service down for several days and 2.) reloading mysql, i am getting the following server error on koha (on windows xp): The server encountered an internal error and was unable to complete your request. Error message: Premature end of script headers: mainpage.pl Error 500 intranet 01/06/2006 10:33:09 Apache/2.0.55 (Win32) what can i do to fix this? Christine Forte Psychology Library Director Antioch University Santa Barbara 801 Garden Street Santa Barbara, CA 93101 Phone: 805-966-5615 e-mail: cforte(a)antiochsb.edu

2 1