- Koha - lists.katipo.co.nz

Weird textboxes in koha 3.10.4
by schnydszch 15 Apr '13

15 Apr '13

I have 3.10.4 installed in debian 6.x. I'm getting this weird textboxes <http://koha.1045719.n5.nabble.com/file/n5750372/weird_koha_admin.jpg> When I get to the detail of the item, I get three search textboxes instead of one. Hmm... Anybody experienced this with koha 3.10.4 Thanks and more power Koha community! -- View this message in context: http://koha.1045719.n5.nabble.com/Weird-textboxes-in-koha-3-10-4-tp5750372.… Sent from the Koha-general mailing list archive at Nabble.com.

5 5

Replacement cost deleting or changing on batch modification
by Jim Maroon 15 Apr '13

15 Apr '13

Hi, all. We are having a problem with batch modification, and I hope someone out there has found a work around or way to fix it. We have a default replacement price of $15. This is inserted in the item record when we create an item. The only time we use this is when the item is a gift and has no price attached to it. Otherwise, we use the retail price for the item. This of course flags circ when an item is lost or damaged and needs to be replaced by the patron. The problem we are having is the actual replacement price is being replaced by the default price when we do batch modification on one or multiple items. We tried taking out the default price in our settings, but then it just replaces the replacement price with nothing. Has anyone else run into this problem? If so, did you find a fix for it? I'm wondering if there is something about Koha we are missing. Thanks in advance! -- ======================================================== *Jim Maroon *

2 2

Missing biblioitems.marcxml entries while migrating from 2.2.x to 3.10.4
by Indranil Das Gupta 15 Apr '13

15 Apr '13

Hi all, An update on my previous mail on migrating a 2.2.x installation to 3.10.4. I had taken the db from 2.2.5 -> 3.0.0 -> 3.10.4 I seemed to have done OK, until I tried `koha-rebuild-zebra -f -v <instance_name>` on 3.10.4 I've about 30 bibs where I get the error like the one below: .error retrieving biblio 4358 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 539. The bibs are in the db, however, the biblioitems.marcxml field for these bibs are empty. I should additionally mention that I noted the same on 3.0.0 instance too for these specific. However, in that case i didnt see zebra complain. So, any way to generate the marcxml data for these bibs? I mean I could always re-enter the data as new bibs, steal their marcxml entry and transplant them into the ones which are missing and do a full zebra re-index. But that sounds very ugly. Is there any elegant solutions to be had? thanks in advance -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org

1 1

Koha universities that use ACQ
by Zeno Tajoli 15 Apr '13

15 Apr '13

Hi to all, If I remember well the ACQ module is used from same Universities, in particular in France. Do you know the mails of those universities ? Cheers Zeno Tajoli -- Dr. Zeno Tajoli Dipartimento Gestione delle Informazioni e della Conoscenza z.tajoli(a)cineca.it fax +39 02 2135520 CINECA - Sede operativa di Segrate

3 3

New added items not searchable on OPAC and on Staff catalog but can be checked out by barcode
by amutsikiwa 15 Apr '13

15 Apr '13

Hi I have recently uploaded 87200 item records into Koha 3.10.3 . I can search the uploaded records on both the OPAC and the staff catalog, can check then out and so on. My challenge is with new records that I am cataloguing. They are are not searchable on both the OPAC and the Staff Catalog, but can be checked out using their barcode. I have the following cron job to re-index the browsers under the Linux Koha user: */5 * * * * /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -a -z -v>/dev/null 0 1 * * * /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v -x 2>/dev/null Mr cron daemon is running. Even if I am to run the command manually, the newly added records are not searchable. Can anyone send me any pointers. Regards, Admire Mutsikiwa University of Zimbabwe

2 1

basic queries on Koha
by Malik Butta 14 Apr '13

14 Apr '13

Dear Colleagues, I am part of a team that have been tasked to implement Koha in a Mid-east university library but we are new to the product. The customer has asked a list of questions that I have no ready answer for. I am sure some learned colleagues would be so kind as to respond to the list so that I can educate the customer and educate ourselves. Many thanks in anticipation. The queries are as follows: · What library modules or solutions does Koha provide or include? · Can Koha modules be tailored to meet NITI library requirements? · Is Koha compatible with different browsers such as Google Chrome, Firefox, ie, etc.? · Does Koha provide access to resources and set up anywhere, anytime knowledge transfer with mobile and digital technology integration including iPhone and Andriod and e-readers? · Does Koha provide tracking electronic resources from point of order through licensing and final access (e.g. magazine and newspaper holdings)? · Does Koha provide automated alerts, notices and defaults? · Does Koha provide customizable e-mail alerting systems (e.g. notices to managers when actions are expected or required) · Does Koha have SMS and SharePoint functionality? · Does Koha address the barriers to resources through one-stop access (single sign on), unifying searching and access? · Can Koha be integrated with NITI finance system and trainee registry? · Does Koha have Reading Lists capability that is integrated with the virtual learning environment (VLE) and e-material? · Does Koha support Arabic text with client interface and Arabic search engine? · Does Koha support range of user self-service initiatives – selfcheck, PC reservation/print management, and general patron authentication? · Does Koha have Web-based ad hoc query tool that allows a library to develop detailed reports against its data? · Does Koha provide Offline solution during system outage or system down? Pukka Beenda

4 3

Re: [Koha] Report Help
by Manos PETRIDIS 13 Apr '13

13 Apr '13

As the original request was "I'm trying to get a report to show patrons with overdues and if there is a guarantor I want that to show too", might I propose the following modification to Bernardo Gonzalez Kriegel's reply, so that all patrons are shown in a single report: select * from ( SELECT patron.borrowernumber as borrower, patron.surname as Surname, patron.firstname as Firstname, patron.relationship as relationship, guarantor.borrowernumber as guarantor, guarantor.surname as guarantor_Surname, guarantor.firstname as guarantor_Firstname FROM borrowers as patron LEFT JOIN borrowers as guarantor ON ( patron.guarantorid = guarantor.borrowernumber ) WHERE patron.guarantorid IS NOT NULL UNION SELECT patron.borrowernumber as borrower, patron.surname as Surname, patron.firstname as Firstname, patron.relationship as relationship, '-' as guarantor, '-' as guarantor_Surname, '-' as guarantor_Firstname FROM borrowers as patron WHERE patron.guarantorid IS NULL ) tmp order by tmp.Surname, tmp.Firstname; Kind regards, Manos Petridis -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Bernardo Gonzalez Kriegel Sent: Wednesday, April 10, 2013 9:45 PM To: Nicole Engard Cc: Koha Subject: Re: [Koha] Report Help Nicole, what you need to match is p(atron).guarantorid with g(uarantor).borrowernumber, not g(uarantor).guarantorid with p(atron).borrowernumber that is what causing you to get an inverted list. For example this query will list all guarantees with corresponding guarantor (if not null), SELECT patron.surname, patron.firstname, patron.relationship, patron.guarantorid, guarantor.borrowernumber, guarantor.surname, guarantor.firstname FROM borrowers as patron LEFT JOIN borrowers as guarantor ON ( patron.guarantorid = guarantor.borrowernumber ) WHERE patron.guarantorid IS NOT NULL; Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkriegel(a)gmail.com On Wed, Apr 10, 2013 at 2:28 PM, Nicole Engard <nengard(a)gmail.com> wrote: > Sorry - I was wrong - not patrons with overdues, but expired patrons - > that's what I'm looking for. > > > On Wed, Apr 10, 2013 at 1:25 PM, Nicole Engard <nengard(a)gmail.com> wrote: > > > I'm trying to get a report to show patrons with overdues and if > > there is > a > > guarantor I want that to show too. But what's happening is the > > Guarantees are showing as the Guarantors and the Guarantor is > > showing 2 times cause > he > > has 2 Guarantees - can someone help me with my SQL: > > > > > > SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, > > p.firstname, p.dateexpiry, IFNULL(concat(g.surname, ', ', g.firstname, ' > > (', g.cardnumber, ')'),'') as guarantor, p.relationship, > > FORMAT(SUM(a.amountoutstanding),2) as due FROM borrowers p LEFT JOIN > > accountlines a USING (borrowernumber) left join borrowers g on > > (g.guarantorid=p.borrowernumber) WHERE p.dateexpiry < NOW() and > > p.surname = 'Meave' > > group by p.borrowernumber, g.borrowernumber ORDER BY p.dateexpiry > > asc ; > > > > > > > > > > > > > +--------------+-------------+------------+---------+---------------+------- -----+---------------------------------+--------------+--------+ > > | categorycode | dateofbirth | cardnumber | surname | firstname | > > dateexpiry | guarantor | relationship | due | > > > > > +--------------+-------------+------------+---------+---------------+------- -----+---------------------------------+--------------+--------+ > > | TRES | 1996-08-24 | P0012129 | Meave | Melina-Maria | > > 2008-12-04 | | parent | 5.90 | > > | TRES | 2000-08-30 | P0012128 | Meave | Phoenix-Jonas | > > 2008-12-04 | | parent | 2.30 | > > | STRICT | 1956-09-23 | P0012127 | Meave | Jose | > > 2008-12-04 | Meave, Melina-Maria (P0012129) | | 351.53 | > > | STRICT | 1956-09-23 | P0012127 | Meave | Jose | > > 2008-12-04 | Meave, Phoenix-Jonas (P0012128) | | 351.53 | > > > > > +--------------+-------------+------------+---------+---------------+------- -----+---------------------------------+--------------+--------+ > > > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Migration issues from ancient 2.2.5 to 3.x
by Indranil Das Gupta 13 Apr '13

13 Apr '13

Hi all, I intend to migrate from an ancient in-production system - 2.2.5 running on FC4 to 3.10.4 running on Debian. As the first step I'm trying to move the data into Koha 3.0. So far I've tried to follow : 1) http://wiki.koha-community.org/wiki/Upgrading_2.2 2) http://lists.katipo.co.nz/public/koha/2011-August/030213.html Here what I have done. 1. Setup a VM running Koha 3.0 on Ubuntu 8.04 2. Taken a DB dump of 2.2.5 with Drop table if exist syntax. 3. Dropped the 3.0's tables from the DB and imported the 2.2.5 db 4. Followed the instructions from the Wiki article. Thing seems to work and I can login etc. However, a whole load of system preferences are missing from the db even after going through the 22_to_30 scripts Specifically I'm missing : StaffClient TemplateEncoding : utf-8 StaffClient Intranetcolorstylesheet : blue.css (to have some blue colors. This step is not required, you can skip it) StaffClient Template : prog What do you suggest I do? tia, -indra -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org

3 3

hoո to suppress Koha modules
by tigran＠flib.sci.am 13 Apr '13

13 Apr '13

Dear List 1. I'm planning to use Koha only for developing Union Catalog of periodicals, so no need to have some of Koha modules, such as circulation, acquisition. How can I remove these modules. 2. How can I suppress /hide 'Items" module? Is it possible? thanks TIgeran

4 3

Restoring the default Marc Framework
by Beda Szukics 13 Apr '13

13 Apr '13

Hi all I altered the default marc Framework. I understand that it's not a good idea. How can I restore the original Default MARC Framework (in my case the one at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql Does simply running mysql -u koha_<instancename> -p koha_<instancename> < marc21_framework_DEFAULT.sql do the job? Or is this dangerous? cu Beda

2 4