- Koha - lists.katipo.co.nz

Koha with remote db very slow
by Viviane Ventura 12 Mar '12

12 Mar '12

Hi, folks, My koha acessing a local database works fine. But when I try to use a remote database my Koha gets very slow. Any ideias? Thaks in advanced

1 0

Windows or browser failure on certain Koha functions
by Steve Campbell 12 Mar '12

12 Mar '12

Our small public library is learning Koha on a test system hosted by Bywater. We will go live in June. Although almost all Koha functions - staff and OPAC - work fine for us, we have found two staff functions that consistently fail on two of our computers but not on the others. So far we have not been able to identify the cause. The details are: Koha version 3.06.02.000 Host: Linux The two computers where functions fail: Hardware: IBM Think Centre and Lenovo Think Centre (both 4+ years old) OS: WIndows XP SP 3 up to date on patches Browsers: Internet Explorer 8 and Firefox 10 (current) Java: 6 Update 31 (current) The Koha functions that fail (that we've found so far) are changing the overdue actions and triggers (Home -> Tools -> Notice Triggers) and adding or editing an item record (Home -> Cataloging -> Edit <record info> -> Items). Failure mode: The Koha pages are rendered normally and all the blanks and buttons and drop downs on the pages function normally. Failure comes when you hit the Submit button (triggers) or Add Item button (item editing). The browsers' connection to the host times out after about 15 seconds. This results in errors such as "Server reset the connection," "Error 500," or simply a completely white browser window. You can use the browser Back button to return to the failed page and otherwise continue your session. These functions fail most of the time, but occasionally one will succeed. They fail only on these two machines. They fail whether you are using IE or Firefox. A public XP computer (HP with AMD processor) with the same versions of XP and the browsers never fails; our Lenovo Windows 7 all-in-ones never fail. Our Macs never fail. We have checked network connections, firewall settings, AV settings, software. Nothing we have tried cures the failures. If you know the answer or have any suggestions, we would be most grateful. Steve Campbell Trustee, Converse Free Library Lyme, New Hampshire, US

2 2

bulkmarcimport-problems!
by Magdalena Söderqvist 12 Mar '12

12 Mar '12

Hi all, my IT-expert is helping me import some marc-records which I have edited in Marc Edit. But importing the records back into Koha is not working. And the editing itself does not seem to be the problem, we get the same error message when trying to import the orginal, unedited .mrc file, which I pulled from the "tools/export.pl" page. Do the below messages contain enough information to tell what we're doing wrong? Any help is, as always, much appreciated. We are currently running version 3.6.2 on Debian Squeeze. Also: we're doing this on a copy of the database, could that be part of the problem? Cheers, Magdalena ******************** deleting biblios > > DBD::mysql: b do failed: Cannot delete or update a parent row: a > > foreign key constraint fails (`koha`.`issues`, CONSTRAINT > > `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` > > (`itemnumber`) ON UPDATE CASCADE) at ./bulkmarcimport.pl line 96. ******************* Duplicate entry 'A13150' for key 'itembarcodeidx' at /usr/share/koha/lib/C4/Items.pm line 361, <GEN16> line 804. .DBD::mysql::st execute failed: Duplicate entry 'A13151' for key 'itembarcodeidx' at /usr/share/koha/lib/C4/Items.pm line 2105, <GEN16> line 805. ERROR in _koha_new_item INSERT INTO items SET ******************** - . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Magdalena Söderqvist Librarian SIPRI Library and Documentation Department STOCKHOLM INTERNATIONAL PEACE RESEARCH INSTITUTE Signalistgatan 9 SE-169 70 Solna, Sweden Telephone: +46 8 655 97 78 Fax: +46 8 655 97 33 Email: soderqvist(a)sipri.org Internet: www.sipri.org

4 5

Koha & PowerSchool updating patron records
by Kathy Pearce 12 Mar '12

12 Mar '12

Greetings, I have been asked by the Librarians in our District if we can automate the PowerSchool data to go into Koha directly. I have been in touch with Koha and it seems to be a bit of a complex process. I have Auto Send working with other databases (AlertNow, SNAP, MealTime) but this one seems a bit more complex. Is there anyone out there that has Auto Send working with the Koha Database? Did you have to make header changes to match Koha or in Koha match PowerSchool? Thanks for your time! Sue

3 3

New koha installation at the American University of Rome
by Paolo Bizzarri 12 Mar '12

12 Mar '12

Dear Koha users, I'm happy to inform all of you that since 13th of Feb. 2012 there is a new Koha installation in production at the American University of Rome in Italy. This University is not really new to Koha. In fact, they come from a very old version (2.2) of 2006. In order to integrate the OPAC with the stylesheet of the American University of Rome web site, the graphical aspect of the Koha OPAC has been reshaped. The data migration has been done editing the imported records manually or using the MarcEdit tools. The new catalog can be reached at the following address: http://www.galileo.aur.it/ Best Regards! Paolo Bizzarri. Library IT consultant of the American University of Rome.

2 2

Report help
by Nicole Engard 12 Mar '12

12 Mar '12

I'm looking to alter this report http://wiki.koha-community.org/wiki/SQL_Reports_Library#Total_Collection_Si… to give me the count of items that were in the collection on that date - that means checking the deleted items to see what was added and deleted on the date that's entered and that's where my math gets a bit rusty. Thanks in advance! Nicole

1 0

Analytic Linkage
by Vitor Fernandes 12 Mar '12

12 Mar '12

Hi Koha community, I'm using Koha 3.2.6 and UNIMARC. I need to know how i can do analityc linkage using fields 4XX, in order to the links for relations appear in the OPAC and the Backoffice interfaces. Anyone has this working correctly? Best regards. Vitor Fernandes

1 0

Windows or browser failure on certain Koha functions
by markus.mohr＠aon.at 12 Mar '12

12 Mar '12

in Intranet 192.168.1.64 or similar Internet-Protocol-address for me ist better than 138.0.0.1

1 0

Need Barcode Wisdom
by Gwyan Rhabyt 10 Mar '12

10 Mar '12

I'm migrating a small elementary school library from Follett to Koha. All has gone well until now. Our problem is a mismatch between the barcodes as read by the scanner which give readings like T 3210 and our biblios in Koha which have the codes like T0003210. At first I thought it was the Follett 3800 scanner that was dropping the zeros, but a new generic scanner reads the same way. So what is the easiest fix? I can imagine four but none sound easy: 1) Reprogramming the scanner -- seems possible but the manual is written for a barcode expert (so many different formats and sub formats) -- how do I express the kind of change I want to make in the language of scanner firmware? 2) Batch changing the biblios from within Koha -- it seems to support batch work but you have to list the items. I can't work out how to make it change every single record. 3) Batch changing via the MySQL database -- I don't know SQL, so there is a serious learning curve 4) Going back to the MARC records, massing the barcode field there and then reimporting -- I don't know how easy that would be in MarcEdit and I am loathe to go that many steps backwards. Could anyone provide some wisdom to help? Cheers, Gwyan -- Gwyan Rhabyt Associate Professor, Art Dept. and Multimedia Graduate Program California State University East Bay President of the Board of Trustees, Pacific School District gwyan.rhabyt(a)csueastbay.edu

3 3

[KOHA] emailLibrarianWhenHoldIsPlaced sending two mails
by kamild 10 Mar '12

10 Mar '12

Hi, In system preferences I enabled emailLibrarianWhenHoldIsPlaced. I don't know why koha send two this same mail about holds. To sends mail I used exim. What may be the problem? Thx -- View this message in context: http://koha.1045719.n5.nabble.com/KOHA-emailLibrarianWhenHoldIsPlaced-sendi… Sent from the Koha-general mailing list archive at Nabble.com.

2 1