- Koha - lists.katipo.co.nz

Re: [Koha] Z39.50 Bug -> marcxml_old on import_records table
by Jonathan Druart 30 Oct '15

30 Oct '15

Pedro, Please answer to the list. Yes it's the easy and lazy solution. If you want to use MySQL 5.6, you must disable STRICT_TRANS_TABLES, otherwise you will encounter some errors. But we should take care of these errors and fix them. Regards, Jonathan 2015-10-29 16:51 GMT+00:00 Pedro Amorim <pjamorim91(a)gmail.com>: > Hello Jonathan, > > Thank you for your reply. > > I have removed STRICT_TRANS_TABLES in both usr/my.cnf and etc/mysql/my.cnf > and solved the following detected bugs: > 1) Z39.50 import_records table insertion; > 2) Z30.50 server creation with empty values on timeout and order; > 3) Creating new category for patron -> Category already exists. > > And ( I imagine ) countless others. > > Let me know what you think about this, please. > > Thank you, > > Pedro Amorim > > > > 2015-10-29 7:20 GMT-01:00 Jonathan Druart > <jonathan.druart(a)bugs.koha-community.org>: >> >> See all bug 13526 and the discussion on bug 5366 >> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523 >> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5366 >> >> 2015-10-29 8:16 GMT+00:00 Jonathan Druart >> <jonathan.druart(a)bugs.koha-community.org>: >> > Hello Pedro, >> > >> > You should not use MySQL 5.6, some bugs are known: bug 13669 and bug >> > 14637, and certainly some others. >> > Until now nobody has shown a special interest for these issues. >> > >> > Regards, >> > Jonathan >> > >> > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 >> > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637 >> > >> > 2015-10-28 16:17 GMT+00:00 Pedro Amorim <pjamorim91(a)gmail.com>: >> >> Also, some other thing to note: >> >> >> >> The mysql I'm running is 5.6.25. >> >> >> >> 2015-10-28 15:14 GMT-01:00 Pedro Amorim <pjamorim91(a)gmail.com>: >> >> >> >>> Hello, >> >>> >> >>> Version: Koha 3.2002000 >> >>> >> >>> My name is Pedro Amorim and I've been implementing Koha for the first >> >>> time >> >>> for the past couple of days now. >> >>> >> >>> This is a fresh package install. >> >>> >> >>> This is a bug (I think) I stumbled upon and this is how I solved it: >> >>> When performing a Z39.50 search I kept getting no records found >> >>> despite >> >>> the fact that I knew there were records (doing a yaz-client search and >> >>> using the online demo returned results, so why didn't it return in my >> >>> installation?). >> >>> >> >>> So I found out that the records should've been inserted in the >> >>> import_records table but they weren't. Because marcxml_old wasn't >> >>> being >> >>> defined and it expected some value (NULL = NO), so I went in and >> >>> changed >> >>> the database structure to NULL = YES and everything is now working as >> >>> expected. >> >>> >> >>> I think this also has something to do with mysql STRICT_TRANS_TABLES >> >>> but I >> >>> would like some confirmation on that. >> >>> >> >>> I'm new in the whole Koha scene and don't yet know how to submit bugs. >> >>> I'm sending this mail in the hopes that someone confirms that this is >> >>> indeed a bug and document the given solution. >> >>> >> >>> Cheers >> >>> >> >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> >> Koha(a)lists.katipo.co.nz >> >> https://lists.katipo.co.nz/mailman/listinfo/koha >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha > >

1 0

Display question
by Tim Skeers 30 Oct '15

30 Oct '15

Is there an easy way to get the biblionumber of a record to display somewhere on the "normal" view for a record in the staff interface? Or would it require an actual programming change? As it is, it displays in the URL in the browser navigation window, but I would like to be able to print out a record with it showing on the printout. Thanks, Tim Timothy Skeers | Cataloger | Iowa Library Services/State Library of Iowa | 1112 E. Grand Avenue | Des Moines, Iowa | 50319 | tim.skeers(a)lib.state.ia.us | (515) 725-0605

8 7

Problems restoring a backup to a new server
by Boulier, Jack 29 Oct '15

29 Oct '15

I am attempting to setup a new server and trying to restore the file koha_library.sql.gz to the new server. I assume that the gz is a compressed file. Using the command in the terminal "mysql -uroot -p koha_library < koha_library.sql fails with the error file not found. I attempt to tar the file with tar -zxfv and get an error that it is not a valid tar file. Running Ubuntu precise1 and koha version 3.18.11.000. All help is appreciated. Jack Boulier, LRC Director 5221 Madison Ave. Sacramento, CA 95841 (916) 339-4370 Direct (916) 339-0305 FAX (916) 339-1500 Main jboulier(a)mticollege.edu

3 4

Z39.50 Bug -> marcxml_old on import_records table
by Pedro Amorim 29 Oct '15

29 Oct '15

Hello, Version: Koha 3.2002000 My name is Pedro Amorim and I've been implementing Koha for the first time for the past couple of days now. This is a fresh package install. This is a bug (I think) I stumbled upon and this is how I solved it: When performing a Z39.50 search I kept getting no records found despite the fact that I knew there were records (doing a yaz-client search and using the online demo returned results, so why didn't it return in my installation?). So I found out that the records should've been inserted in the import_records table but they weren't. Because marcxml_old wasn't being defined and it expected some value (NULL = NO), so I went in and changed the database structure to NULL = YES and everything is now working as expected. I think this also has something to do with mysql STRICT_TRANS_TABLES but I would like some confirmation on that. I'm new in the whole Koha scene and don't yet know how to submit bugs. I'm sending this mail in the hopes that someone confirms that this is indeed a bug and document the given solution. Cheers

2 3

Koha Community Newsletter: October 2015
by kohanews 29 Oct '15

29 Oct '15

Fellow Koha users: The Koha Community Newsletter for October 2015 is here: http://koha-community.org/koha-community-newsletter-october-2015/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. Thanks! Chad Roseburg Editor, Koha Community Newsletter

1 0

Fwd: Koha Offline Circulation Tool - Development
by Balaji Ravichandran 28 Oct '15

28 Oct '15

---------- Forwarded message ---------- From: Balaji Ravichandran <rbalajives(a)gmail.com> Date: 28 October 2015 at 02:12 Subject: Koha Offline Circulation Tool - Development To: dev-addons(a)mozilla.org Hi all, I am interested in doing the development process for the Koha Offline Circulation Tool - addon for firefox. I have noticed that this addon is not working well in the latest versions of firefox and I am very much in the need to fix it for the use by community. Can somebody guide me on how to start with it? I have searched for the repository for the addon but couldn't help after that.Where to go after that? How to make changes and notify the developer with it? Reference Links :- http://wiki.koha-community.org/wiki/Offline_circulation_firefox_plugin https://addons.mozilla.org/en-US/firefox/addon/koct/ http://git.koha-community.org/gitweb/?p=contrib/global.git;a=summary Thank You!!! -- Regards, Balaji Ravichandran ( பாலாஜி ) , Volunteer at Free Software Foundation - Tamilnadu, Mobile : 9790528505 My Blog - balogic.wordpress.com -- Regards, Balaji Ravichandran ( பாலாஜி ) , Volunteer at Free Software Foundation - Tamilnadu, Mobile : 9790528505 My Blog - balogic.wordpress.com

5 4

Re: [Koha] Help to assign one barcode each to 10000+ records in mrc file (Mrs. Chitralekha M. Chitale )
by Mahesh Angadi 28 Oct '15

28 Oct '15

Dear Chitralekha and all concerned Members, 1. For combining contents of various columns use "concatenate" function available in excel. For eg. using this function we can combine contents of column A + B + C and store them in column D. This function also allows you to add prefix or suffix, before or after the contents of every column. 2. With the help of this function, you can combine various scattered item data of tag 952 and store them in one single column, which in turn can be converted to mark format using MARC EDIT tool. -- Mr. Mahesh M. Angadi, Librarian, Model College, Dombivli (E).

1 0

Help to assign one barcode each to 10000+ records in mrc file
by Mrs. Chitralekha M. Chitale 28 Oct '15

28 Oct '15

Sir, For the first time I purchased e-books from a publisher. They provided me a marc file (.mrc) for all the ebook titles (10000+). I can upload it directly to my Koha after adding and editing certain fields in records and add items with subfields having same description. I can do so using marcedit 5.2 as far as all records have same description to be added in that tag / copying from another field. But my problem is adding barcode (accession number in 952$p) to these records as each record will have different barcode. I tried converting marc file in excel. There is one marc tag per column but some of the columns have multiple subfields. I inserted barcode column, item type column, location column, Now I need to convert this excel to .mrc. The issue is I am not able to map them while converting to mrk file as each tag (above 010) must have subfield. I cannot map columns with multiple subfields eg. subject headings. Help me to assign one barcode each to these 10000+ records. Mrs. Chitralekha M. Chitale Librarian, Lokmanya Tilak College of Engineering, Navi Mumbai, India

4 4

Koha 3.20.5 released
by Chris Cormack 27 Oct '15

27 Oct '15

The Koha community are proud to announce the release of Koha 3.20.5 (powered by Orijin and Nigerian Hospitality) This release is a bugfix release and contains no new features. As always you can download the tarball from download.koha-community.org or wait a little while for the packages to be released. Please go to http://koha-community.org/koha-3-20-5-released/ for the full release notes Chris

1 0

Re: [Koha] z39 no connection
by Paul A 27 Oct '15

27 Oct '15

At 12:57 PM 10/27/2015 -0400, Cindy Murdock Ames wrote: >We have noticed it here too, beginning yesterday. LoC was done for us yesterday, but up again today -- however the British Library is down today. Both of these are normally quite reliable. Paul >Cindy > >----------------------------------------------------------- >Cindy Murdock Ames >IT Services Director >Meadville Public Library | CCFLS >http://meadvillelibrary.org | http://ccfls.org > > >On Tue, Oct 27, 2015 at 6:12 AM, Mary W. Maina <mmainat22(a)gmail.com> wrote: > > > Hi people, > > > > we are experiencing problems with the z39serach we get > > > > - Connection failed to lx2.loc.gov > > > > are the servers down? or is it an internal problem from our side. > > > > > > Mary > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >https://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

1 0