- Koha - lists.katipo.co.nz

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 09 Aug '11

09 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

Fwd: [LIS-Forum] KOHA-UoM Experience-Universal Suitability-Discussion
by Yatheesh Y 09 Aug '11

09 Aug '11

please click here to see OPAC http://libcat.mysore-univ.org/ ---------- Forwarded message ---------- From: Nabonita Guha <nabonita_g(a)hotmail.com> Date: Mon, Aug 8, 2011 at 9:34 AM Subject: Re: [LIS-Forum] KOHA-UoM Experience-Universal Suitability-Discussion To: mailman(a)ncsi.iisc.ernet.in, NCSI LIS-Forum <lis-forum(a)ncsi.iisc.ernet.in>, goudarishwar(a)googlemail.com Dear Dr. Goudar, I really appreciate the efforts you have made in implementing Koha in a University library set up. In this context, I would like to share my experience in migrating from Libsys to Koha (OS version). The migration became inevitable because the vendor of our commercial LMS stopped support even when Annual Maintenance Contract was renewed on time. Also, we have taken a decision of implementing RFID for which integration with LMS is very essential. The LMS Vendor has quoted the cost of NCIP module of Libsys exorbitantly high. These are some of the factors which has led us to switch over to Koha. Apart from this, our objective was also to fund a small bit towards the development of the software (Koha - OS version), rather than funding a commercial software by continuing its AMC. We have also evaluated several commercial and Open Source LMS and to a large extent arrived at the same results as yours. I would also like to share some of the challenges we have faced while working with Koha so far. We have implemented all the modules of Koha (Acquisition, Patrons, Cataloguing, Circulation and Reports). We found Acquisition module at a very primary stage which needs lots of customization to make it usable. Also, in most of the Koha implementation in India, I found that the Circulation and OPAC are the most used modules. We have taken the services of Rapid Radio Ahmedabad and OSSLabs for the customization of all modules of Koha, mainly acquisition module. All the customizations have been taken up by the Vendor after the approval of Koha Community and its developers before changing the source code. And the features which have been customized for our library will be a part of the source code of Koha OS version in the upcoming releases (as per the feature release schedule of Koha release manager). Some of the features that have been added to Koha acquisition and other modules are given as below: Staff member can add the the recommended title on recommender's behalf Acquisition details of the biblio item is attached with each item record in staff client. This is to enable the library staff to find out the price, discount and other acquisition related data of the item.In OPAC, name of recommender in Item details, to be captured from acquisition module for each item Export of pending (for approval) purchase suggestions in csv & print format Export new arrivals list by date range in in csv & print format, display data in compact format (preferably ISBD)Modification in Order Basket display; addition of new columnsModification of purchase suggestion list, better filtering, ordering and sortingStatus of titles in suggestion list to be marked as pending, duplication checked, available in library, approved, rejected, ordered and received. The status to be shown in recommender's OPAC profile under hi/her purchase suggestions. Sorting of suggestion list by the statuses such as pending, duplication, approved, checked etc.Export of suggestion list by status category in csv and printable format.Email notification to recommender's once his/her recommended title is received in the libraryReports in csv and printable format:Accession register Members circulation history (from individual member record)Members overdue history (from individual member record)Members checkout history (from individual member record)"Archival of exchange rates datewise; and capture of the rate for a given date during the receipt of the book with the invoice Rectification of alphabetical sorting of titles in Koha OPAC Major database fields are made available in the guided reports so that customized report can be generated from any koha modulesDuplicate search (a cumulative search interface where in we can search the records from catalogue, order baskets, rejected, and suggestion pool) when a title is recommended and listed in the suggestion list We have ensured a commitment from the service provider to make the customized feature acceptable to the Koha community and be the part of the open source stable release in due course. The grey areas in Koha: Serial control for online journals: As we have all the serials in online only format, where as the serial control module is suitable only for print only version.Guided Reports: Though we have tried to make more and more database fields available in guided report, still customized report generation is quite challenging. Looking forward to hear more success stories from professionals who have implemented Koha and migrated from commercial LMS. With best regards Nabonita -- Nabonita Guha Library-cum-Information Officer Library, Jawaharlal Nehru Centre for Advanced Scientific Research, Jakkur Post, Bangalore 560064 Karnataka, India Phone: +91-80-22082930 Email: nabonita(a)jncasr.ac.in Web: http://lib.jncasr.ac.in OPAC: http://lib.jncasr.ac.in:8081 > Date: Thu, 4 Aug 2011 16:36:10 +0530 > From: mailman(a)ncsi.iisc.ernet.in > To: lis-forum(a)ncsi.iisc.ernet.in > Subject: [LIS-Forum] KOHA-UoM Experience-Universal Suitability-Discussion > > Date: Thu, 4 Aug 2011 10:48:47 +0200 > From: Ishwar Goudar <goudarishwar(a)googlemail.com> > > Dear Professionals, > > *I invite experiences, comments and opinions of professionals in the matter > concerned to the selection of and migration to suitable Library Management > System (LMS) for different kind of libraries taking into account of all > factors like size and type of libraries, service after sale, cost factor, > customization, availability of community for development in case of Open > Source S/W, stability in the market, world wide popularity, compliance to > international standards, cost, etc.* This discussion should help > professionals for selecting suitable LMS and also for migrating from one > ILMS to other if required. I have given below a detailed account of the > entire process we did while adopting new LMS and implementing it. > * > Our Experience at University of Mysore*: > > *Background:* > > Our library had adopted Libsys 13 years back itself and was used for > creating few thousand OPAC records. Later in 2001 SLIM was used for > adding a sizable number of records to our OPAC. For some reason or the > other these LMSs were not used for other housekeeping activities. After my > joining UoM one year back I did lot of home work for choosing suitable LMS > including the continuation of Libsys and SLIM. I did not want to jump for a > new one immediately, but try the ones for which we already had > licenses although for old versions of these LMSs. I contacted both the > vendors, but failed to get favourable response, as both insisted on selling > their new versions with very high price rather than helping us to revive > the old versions. > > *Exercise for Selection of New LMS:* > > We did a serious exercise before choosing KOHA. We constituted a committee > of experts in the field to recommend the suitable LMS for UoM. We also > conducted one full day brain storming session on this matter by inviting > 7-8 librarians using different LMSs. I had also distributed 7 page list of > criteria for consideration and discussion. > > As you are aware there are number of commercial in the market and Open > Source ILMSs. The good ones under commercial category are very costly ( in > the range of 1.5 -15 lacs) depending upon the sophistication of the system, > size of the library, after sales service, their market stability, etc. Some > of them costing around 1.5-3.0 Lacs are not > suitable for bigger libraries like university libraries. > > We short listed NewGenLib and Koha based on many criteria. For the last few > years NewGenLib is available as open source LMS. However, for the last one > year or so the developers are vending an enterprises version of NewGenLib > as they claim. While the earlier version of NewGenLib is still available in > OS the developers have stopped giving service to OS version users as > indicated by their mail to me. Unfortunately we don't have NewGenLib user > community like that of KOHA for providing guidance, service, > custamisation and adding new features for its open source version. We also > don't have 3rd party service providers for NewGenLib OS version. > > We decided to go for KOHA as we felt that it is not only suitable for UoM > with all its best features and functionalities, but we can get service > support by a established third party like OSS Labs, Bangalore. More > importantly improvements in functionality and features of KOHA are ensured > due to its strong community world over. OSS Labs also has received some > international support for its contribution towards KOHA 3.4 Version. > Koha also has over a dozen vendors worldwide that provide services and > develop the software. Several libraries around the world sponsor development > and contribute to Koha in other ways like testing, documentation and even > development. *Koha has always been and will always be open source and free.* > > > *Automation Model Adopted at UoM and KOHA: * > > We have 58 libraries directly under UoM participating in our automation > program including Main Library, Libraries of 5 colleges, 13 institutions > and 36 Departments. > Once completed, the OPAC will have about 10 Lacs records. > > *OPAC is single for all libraries: Centralised database, decentralised > inputting and housekeeping activities and Universal access to OPAC; Unique > accession number for every record in the OPAC irrespective of their location > in different libraries. We also plan to issue patron ID cards with Unique ID > Number across all libraries. This card would serve as Universal card among > the group of libraries concerned. > > We have hosted our database in cloud hosting environment (Amazon C2) and > there by no expenditure on server, maintenance, manpower, air-conditioning, > etc. We pay nominal monthly rental to the server maintenance. All > participating libraries access the server directly for their housekeeping > activities. > > **Status of KOHA Implementation:* > > So for we have added about 2 lac bibliographic records from 5 participating > libraries to our OPAC. MARC 21 is strictly followed. KOHA has been in use > for Acquisition of books and other documents. Membership IDs are being > printed through KOHA. Circulation section work has been experimented > successfully on trial basis taking into > all features including creation of patron database, transactions, fine > calculations, reminders, etc. The same will be practiced next week onwards > coinciding the commencement of new academic year. We will start Serials > Control job very soon. > We are downloading bibliographic records from libraries like LOC using > Z39.50. > Anybody can access our OPAC at* http://libcat.mysore-univ.org/* > Both our library staff and users are very happy with features and > functionalites of Koha. > > *We have not even spent one third of what we would have spent for a medium > priced commercial LMS. The amount we paid to our service provider Nucsoft > (its OSS Labs unit), Bangalore** covered installation and configuration, > migration of existing data, training, little bit customisation, hosting > initially on cloud hosting environment and AMC for one year. > > *The server is 99.95% reliable, accurate and 24 hours on time without any > breaks. We need not spend our time and money and space for server, > air-conditioning and its maintenance or for system administration. The > infrastructure is also scalable, additional system resources can be procured > within minutes if required. > > *Koha Capabilities at a High Level:* > > Koha is the most advanced open source Integrated Library Management System > (ILMS) in the world. It has won many awards and is being used by thousands > of libraries. > > All modules including Cataloging, Circulation, OPAC, Acquisitions, and > Serials Control are integrated. Compared to all other LMSs the Cataloging, > OPAC and Circulation module are superior with many useful features and > functionalities. The user community loves Koha's OPAC. > > *Costs associated with Koha:* > > Many of the commercial LMSs jike costs depending upon type and size of the > library, number of housekeeping clients, number of simultaneous OPAC clients > we opt, number of participating libraries, modules used. Koha being open > source ILMS, we don't have to pay any amount for its procurement. Licensing > costs nil, no matter how many libraries or servers we use the software in or > what modules we use or how many users we have. > > However, to ensure proper installation and configuration of Koha, we may > have to spend nominal amount to get third party service, unless we ourselves > develop our expertise for installation, configuration and implementation of > KOHA at our level. > > *Vendor Support for Koha: > * > There are over a dozen vendors worldwide that support Koha including 2 or 3 > in India. > Our vendor, Nucsoft is 15 year old, ISO 9001 company with mature and modern > support processes. They operate a 12*7 support center for Koha and offer > strong service level committments. > > But at the same time we are not tied to any vendor. We can change vendors or > support the software on our own. This "No vendor lock-in" advantage of Koha > will protect us against risks such as poor service, high prices or vendor > insolvency. > > *Koha Features Summary:* > > Koha is web-based ILMS, with a MySQL database back-end. Cataloguing data > stored is in MARC and is accessible via Z39.50. The user interface is very > configurable and adaptable and has been translated into many languages. > > With integration of the powerful Zebra indexing engine, Koha became, > scalable to support tens of millions of bibliographic records and thereby > good solution for libraries of all kinds including large Academic Libraries. > > *Other Important Features of Koha include:* > > - Runs on Linux, Unix, Windows and MacOSX platform on the front-end > - Simple, clear interface for librarians and members > - Web based OPAC system (allows the public to search the catalogue in > the library and at home). > - Various Web 2.0 facilities like tagging and RSS feeds > - Union catalog facility > - Customizable search > - Can be integrated with library web site > - E-mail and/or txt patron's over dues and other notices > - Easy-to-use circulation policies, strong patron management, intuitive > navigation, and extensive permissions for staff accounts. > - Full acquisitions system including budgets and pricing information > (including supplier and currency conversion) > - Ability to cope with any number of branches, patrons, patron categories, > item > categories, items, currencies and other data (Most important) > - Serials system for magazines or news papers > - Koha is multi-tasking and enables updates of circulation, cataloguing and > issues to > occur simultaneously > - Reading lists for members > - Inbuilt facility for printing bar-codes and spine labels > - Full catalogue, circulation and acquisitions system for library stock > management. > - Supports barcode and RFID implementation including bar-code generation and > RFID > writing. > * > **Feedback on Key Koha Modules: * > > *Union catalog* > > With its Union catalog facility one can have a single OPAC for a group of > libraries. For example all libraries under one university set up including > main library, departmental libraries, constituent college libraries, > affiliated colleges can have single OPAC, but still carry on their > respective house keeping activities including book acquisition, circulation > of books etc independently without interfering in housekeeping of other > libraries in the group. > > Most importantly, the catalogue created once for one book by any of the > library, can be used by other libraries for creating their catalogue entry > without keying again the details except class and accession number. > > *OPAC > * > Search within search is a fantastic facility. The system picks up related > titles along with cover page from Google Books automatically, some time > with full or partial text and contents page. > > The users apart from enjoying browsing of titles can use simple and advance > search features like in any other ILMSs. They can also check their borrowing > details, reserve items, make suggestions for new books, etc. > > *Cataloging* > > The cataloging module being MARC21 and Z39.50 compliant, library staff can > automatically import bibliographic records from other libraries like Library > of Congress and local libraries of their choice instead of data entry again > and thereby ensure quality catalogue and saving time of library staff. > > *Circulation* > > The circulation module is one of the best features of Koha. Apart from > enabling automated transactions in the counter using bar-code or RFID the > system enables the counter staff to identify the borrower with the help of > the photograph and/or the digital signature. The system allows the > reservation of document by the users or the library > staff and also facilitates sending overdue reminders through e-mail. > > *Acquistions* > > The acquisition model is fully integrated with management of document > suggestions, approval for procurement and budget and budget under different > headings. The details of the documents already keyed in could be used for > cataloging automatically. > > *Serials* > > While there is scope for improving serials management of Koha, as it stands > it serves our purpose. The upcoming version will take care of the present > shortcomings. Various kinds of reports with statistics useful for > management, library staff and users can be generated in Koha. > > The above mentioned opinion is based on library automation experience at > NAL, Bangalore and UoM for 20 years as well my interaction with both > librarians and LIS teachers. In no way I undermine the capabilities of other > commercial/OS LMSs. > Once again I invite a detailed discussion by professional on this topic. > Please contact me if you have questions. > > Thank you, > > Dr. I.R.N. Goudar > Visiting Professor Cum Library Advisor > University of Mysore > Formerly Scientist G and Head, Information Centre at NAL, Bangalore > _______________________________________________ > LIS-Forum mailing list > LIS-Forum(a)ncsi.iisc.ernet.in > http://ncsi.iisc.ernet.in/mailman/listinfo/lis-forum > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

1 0

Error in adding recipients for routing list creation:Filter not wrking properly
by tanzeem 09 Aug '11

09 Aug '11

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 -- View this message in context: http://koha.1045719.n5.nabble.com/Error-in-adding-recipients-for-routing-li… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Koha Upgradation
by prasanth 08 Aug '11

08 Aug '11

Dear All, We are now using koha version 2.2.5 ( Koha version2.2.5 OS version ('uname -a')Linux prahari 2.6.9-78.0.8.ELsmp #1 SMP Wed Nov 19 20:05:04 EST 2008 i686 i686 i386 GNU/Linux Perl version5.008005 MySQL versionmysql Ver 14.7 Distrib 4.1.22, for redhat-linux-gnu (i686) using readline 4.3 Apache versionServer version: Apache/2.0.52 Server built: Nov 15 2008 03:52:33) and now we installing Koha version 3.2.5 but unable to transfer database old version to new.How to upgrade my koha.Please help me. Regards Prasanth Librarian Chintech Kerala,India

1 0

Re: [Koha] Patron Image display on Koha OPAC interface
by Nicole Engard 08 Aug '11

08 Aug '11

This is not a patch, but a request for someone to write some code to do what you want. Always remember to reply to all so the the entire community gets the reply and can help you out. Nicole On Mon, Aug 8, 2011 at 8:32 AM, R Sunil Kumar <sunil.kumar(a)ecoleglobal.com> wrote: > Dear Nicole, > > Can you please guide me how to use this patch and where to install the same. > > > Thanks and Regards > > R Sunil Kumar > Library Technologist > +91-9686576695 > > -----Original Message----- > From: Nicole Engard [mailto:nengard@gmail.com] > Sent: 08 August 2011 17:29 > To: sunil.kumar(a)ecoleglobal.com > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Patron Image display on Koha OPAC interface > > There is an enhancement request for this very feature: > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3516 > > Nicole > > 2011/8/8 R Sunil Kumar <sunil.kumar(a)ecoleglobal.com>: >> Hi, >> >> >> >> Anybody tried to display of patron image on OPAC interface of Koha. >> >> >> >> If so please share the details. >> >> >> >> Thanks and Regards >> >> >> >> R Sunil Kumar >> >> Library Technologist >> >> >> >> Ecole Solutions Pvt Ltd >> >> Level 15 Concorde Towers UB City 1 Vittal Mallya Road >> >> Bangalore 560001,India >> >> Mobile: +91 9686576695 Fax: +91 80 40300400 >> >> eMail: sunil.kumar(a)ecoleglobal.com Web: www.ecoleglobal.com >> >> >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> > >

1 0

Re: [Koha] Patron Image display on Koha OPAC interface
by Nicole Engard 08 Aug '11

08 Aug '11

There is an enhancement request for this very feature: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3516 Nicole 2011/8/8 R Sunil Kumar <sunil.kumar(a)ecoleglobal.com>: > Hi, > > > > Anybody tried to display of patron image on OPAC interface of Koha. > > > > If so please share the details. > > > > Thanks and Regards > > > > R Sunil Kumar > > Library Technologist > > > > Ecole Solutions Pvt Ltd > > Level 15 Concorde Towers UB City 1 Vittal Mallya Road > > Bangalore 560001,India > > Mobile: +91 9686576695 Fax: +91 80 40300400 > > eMail: sunil.kumar(a)ecoleglobal.com Web: www.ecoleglobal.com > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > >

1 0