- Koha - lists.katipo.co.nz

Koha on CentOS
by Msgr. Marion J. Makarewicz 10 Aug '11

10 Aug '11

I'm sure it will be possible. Check out this thread: http://lists.katipo.co.nz/public/koha/2009-May/018195.html If you haven't done so yet, visit the Koha list archives at Nabble or another web forum. It makes it easy to search the archived posts to find similar topics under discussion: http://koha.1045719.n5.nabble.com/ I did an install on Fedora as my first trial of Koha and it worked fine. At that time I was more familiar with the Red Hat Linux distributions than Debian distributions. There was less documentation available (there is the install_fedora7 doc), and a few other things on the web, but I was able to find all the packages I needed. Most challenging was getting the Perl modules installed. Don't know if that was because of Fedora or because it was really my first time to work with CPAN. Some of the modules I had to force install. Since Koha uses Apache, php, perl and MySQL and these are all available for Centos, there is nothing inherent about the OS that would prohibit it. I install Webmin as the first custom software after normal distribution updates. Then I use Webmin to configure all the server settings and manage the databases. Marion

2 1

Summary of PhD findings and a final thank you!
by Brenda Chawner 10 Aug '11

10 Aug '11

Several years ago I invited subscribers to this email discussion list to complete a Web-based survey as part of my PhD research. Since the data gathered were anonymous, I don’t know who the individual respondents were, which means I’m sending this summary of the findings to the list rather than to individuals. I am very grateful to the people who took the time to complete the survey, and provided such interesting perspectives on what factors influenced their satisfaction with a free/libre and open source software project. The abstract for the thesis is below, outlining the research method and summarising the main findings. Abstract The purpose of this research was to identify factors that affect participants’ satisfaction with their experience of a free/libre open source software (FLOSS) project. The research built on existing models of user satisfaction from the information systems literature, and also incorporated two characteristics of FLOSS projects first identified by Ye, Nakakoji, Yamamoto, and Kishida (2005), product openness and process openness. The central research question it answered was, What factors influence participant satisfaction with a free/libre and open source application software project? Richard Stallman’s reasons for setting up the GNU project and the Free Software Foundation arose from his frustration at being forced to be a passive user of software used for a Xerox printer. These suggest that being able to be an active participant in a FLOSS project is one factor that should be examined, and therefore the first sub-question this project answers is, What types of contributions do participants make to free/libre and open source software projects? Several studies have shown that the extent of participation in a FLOSS project varies from individual to individual, and this variation leads to the second sub-question, Do the factors that influence satisfaction vary for different types of participation? If so, in what way? A preliminary conceptual model of factors affecting participant satisfaction was developed, reflecting the key concepts identified in the literature. The main theoretical goal of this research was to test the model using empirical data. The research used a sequential, mixed methods approach. The first, qualitative stage involved reviewing documents from selected projects and interviewing a purposive sample of FLOSS project participants. The second, quantitative stage involved an online survey of FLOSS project participants, and the data gathered were used to test the conceptual model. The results of the first stage showed that participation in FLOSS projects was a more complex construct than previously reported in the literature. Seven distinct categories of activities were identified: * use; * interaction with code; * supporting the community; * outreach; * sponsorship; * management; and * governance. Four attributes that modified these categories were also identified: organisational focus, role formality, remuneration, and time commitment. Data from 154 responses to the online survey were used to test the model using stepwise multiple regression, which determined the effect of each of the variables on overall participant satisfaction. Moderated regression analysis was used to test the effects of three potential moderating variables. The results showed that that perceived system complexity had the largest effect, decreasing satisfaciton if respondents perceived that the software was complex, while project openness and perceived developer communication quality accounted for the most variance in satisfaction. The main theoretical contribution of this research lies in its extension of satisfaction studies to FLOSS communities, showing that communication and openness are more important than in conventional software projects. Its practical contribution will help people involved in the management and governance of FLOSS projects to identify ways of increasing their participants’ satisfaction, which may in turn encourage them to contribute more. The final version of the thesis is available in the VUW library’s research archive at: http://researcharchive.vuw.ac.nz/bitstream/handle/10063/1710/thesis.pdf?seq… Thank you again to everyone who completed the survey. Please let me know if you have any questions about this research. -- Dr. Brenda Chawner Senior Lecturer School of Information Management Victoria University of Wellington P O Box 600, Wellington NEW ZEALAND (04) 463 5780 | fax (04) 463 5446 | Room RH423 | brenda.chawner(a)vuw.ac.nz

3 2

OpacHiddenItems being ignored?
by Richard Hills - TechnologyWise 10 Aug '11

10 Aug '11

Hi, I am hoping someone can help me with this setting as so far no matter what I set here I am unable to exclude results from the front end search system. I have set the value of OpacHiddenItems as follows: restricted: [1] However restricted items are still coming through in results. I have also tried the value "restricted: [1,2,3]" incase it was an issue with a single item being passed through. My Koha version is: 3.4.02 Thank you. -- Richard Hills TechnologyWise Ltd, Tauranga, NZ richard(a)tw.co.nz www.technologywise.co.nz ph: +64 (0)7 571 1060 fax: +64 (0)7 571 1061

2 1

Meaning of each serial issue status
by tanzeem 10 Aug '11

10 Aug '11

Please explain the meaning of each serial issue status viz. expected,arrived,late,missing,claimed,not available -- View this message in context: http://koha.1045719.n5.nabble.com/Meaning-of-each-serial-issue-status-tp468… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Migrating selected data - mainly books
by nreese 10 Aug '11

10 Aug '11

Hi all, I want to migrate data from an old Koha database to a 3.4.02 database. All I'm really needing is book data and where it is in the stacks. Has anyone done this and can give me some pointers on the main tables copy over and what pitfalls to look out for? Cheers, Nick Reese -- View this message in context: http://koha.1045719.n5.nabble.com/Migrating-selected-data-mainly-books-tp46… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Re: [Koha] Upgrading from Koha 2.2.x to Koha 3.0
by Vimal Kumar 10 Aug '11

10 Aug '11

Dear Friends, See the method I tried to upgrade Koha 2.2.x to Koha 3.x. I extorted bibliographic details as CSV format from database using SQL query trough PhpMyAdmin. Then converted CSV file to MARC 21 using MarcEdit software. I imported marc records in Koha 3.x version. In the same way, I exported patron details and imported in new koha installation But, I missed old transaction details. But I could retrieve most of the data using above mentioned way. Here is the SQL script, after necessary changes you can make use this for your purpose, items.barcode,items.dateaccessioned,items.itemcallnumber,biblioitems.isbn,biblio.author,biblio.title,biblioitems.pages,biblioitems.publishercode,biblioitems.place,biblio.copyrightdate FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) ORDER BY items.barcode ASC Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: www.vimalkumar.org Blog: http://vimalkumar.oksociety.in http://linuxhalwa.blogspot.com --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

Does anyone know how to delete patrons in bulk?
by Hartman, David W. - GBTS Library 10 Aug '11

10 Aug '11

Koha 3.05 is the version. I entered my patron list yesterday 8/3 and there was an error with the patron number (leading zeros were ignored by EXCEL). I have tried to delete using the admin command by date of last items (today 8/4) but it won't let me delete any patron records. I need to delete and reload with correct numbers. David W. Hartman Global Business Technology Strategy Library Team Disney 336N 407 828 4250 (8-222) FAX 407 828 4868

6 8

[chrisc@catalyst.net.nz: Re: Error in adding recipients for routing list creation:Filter not wrking properly]
by Chris Cormack 09 Aug '11

09 Aug '11

* tanzeem (tanzeem.mb(a)gmail.com) wrote: > I am trying to add recipients to a routing list > In the filter popup, > I gave name:t > Library: CDCLibrary(library defined by me) > Category:Any > But I get all the names instead of the filtered results > Why is it so > Hi Tanzeem It always makes it much easier to answer your questions if you tell us what version of Koha you are running There is a bug for this http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6513 Which has a patch, that is awaiting QA, and then it will be pushed up and in the next release of 3.4.x (which is 3.4.4) Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand

1 0

Brainstorm Help - Improve Reporting
by Msgr. Marion J. Makarewicz 09 Aug '11

09 Aug '11

The whole data to report question is a huge part of Koha. The web interfaced based scripts are essential that give the info desired for end users without their having to worry about code. But isn't that the question? Getting non-coders the tools to get the particular data set desired. My way around the report limitations of any canonical software (Koha included) is to connect the MySQL data to a ODBC application, either OpenOffice/BibLibre Writer document through Base with merge data (excellent for printing customized patron cards or labels) or to Word and Access. Once I set up the database queries through Base or Access, the librarians only have to click on the report they want and a dialogue box opens to filter by date or patron number or any other category that is essential to the data. The appearance of the reports is very polished because of the text editing tools available to a merge template in a document editor or a database frontend like access's reporting tools. Granted, this is mean for printouts and not for the online interface, but the librarians still like to have printed reports for many day to day operations. I did try out phpMyAdmin for a while, but generally use Access with ODBC drivers to work with the data directly. Sometimes I use Webmin's MySQL module to view the data and run the queries. Of course the most efficient way is command line SQL syntax, but front end helpers really make editing the queries easier. I know it is preferred to keep everything "in application," but this is what my brainstorm has come up with. Marion

1 0

Upgrading from Koha 2.2.x to Koha 3.0
by Barry Cannon 09 Aug '11

09 Aug '11

Hello, Is there anyone around who remembers upgrading from 2.2.x to 3.0? I have been following this -> http://wiki.koha-community.org/wiki/Upgrading_2.2 but there seems to be some omissions. The biggest problem I see is that there is no mention of where/how to run upgrade the 2.2.x directory structure to version 3.0. There is no mention of running 'make' or 'make install' for the upgrade. That would suggest that any customisations made on 2.2x will be lost. This document seems to be directed at migration to 3.0 rather than an upgrade. Does anyone remember? Thanks Barry http://www.oslo.ie

1 0