- Koha - lists.katipo.co.nz

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

Can't reach web install on Ubuntu 12.04
by Triana Carmenate 12 Apr '13

12 Apr '13

I am trying to install Koha on Ubuntu 12.04 Desktop, following the instructions from here http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages. However, when I try to access the administration website it will not open. I am using a dynamic dns. Is there anything I need to configure with apache2 to get my site running? Thanks, tcarm

4 3

Hold message
by Dagne Woldie, MS/HS Library Assistant 12 Apr '13

12 Apr '13

we have a problem on sending message to the patron holds the books. i have tested it works for afew day, then next day it doesn't, the koha can send message for item checked out and in by patrons, but not overdue notice and hold if some one know how to fix this problem, pls help me. Thanks Dagne

1 0

Can any one help me
by Dagne Woldie, MS/HS Library Assistant 11 Apr '13

11 Apr '13

If koha enable us to catalog Ethiopian collection. That books written in Amharic language. Please if any one who has such experience. please, please/ Thank you Dagne

3 2