- Koha - lists.katipo.co.nz

System Time
by Nas Yakubu 30 Oct '15

30 Oct '15

Hi Can anyone advise me on how to change the date and time in Koha? Or does Koha get these values from the Operating System?

2 2

Difficulty filling out accounting info
by library 30 Oct '15

30 Oct '15

Good morning Ever since we were upgraded to 3.20.4 I have had difficulty filling out the accounting information for each item. I have found a work around for the books as I can can fill them out using the Uncertain Prices page then edit each item later, but I cannot do this for the subscriptions. Basically as soon as I enter the vendor price the rest of the price fields change to NaN (have no idea what this means) but the Budgeted cost and total cost fields are not editable. Then I cannot save because I get the error message -Total must be a number. Could anyone give me a hint as to what is wrong so I can tell our tech support where to look. Gratefully Ann Murphy Katikati College

2 1

On how to create a report
by catarinafrc 30 Oct '15

30 Oct '15

Hey guys, My question is how can I create a report to know how many books were cataloged from Jan till now (or any other time period)? I have tried, but I find that the manual is not clear enough on this. all the reports I created were not able to give me this info.... Thanks [I still have 3.10 version, and NO I can't changed it now, so any help will be much appreciated] Thank you, -- View this message in context: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353.html Sent from the Koha-general mailing list archive at Nabble.com.

3 5

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