- Koha - lists.katipo.co.nz

catalog updating issues
by Scott Owen 08 Jun '16

08 Jun '16

HI all, Currently running Koha version: 3.22.06.000 OS version ('uname -a'): Linux hskoha 3.16.0-4-686-pae #1 SMP Debian 3.16.7-ckt25-2 (2016-04-08) i686 Perl interpreter: /usr/bin/perl Perl version: 5.020002 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/i386-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/i386-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/i386-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.5.49, for debian-linux-gnu (i686) using readline 6.3 Apache version: Server version: Apache/2.4.10 (Debian) Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU Every day or two (and whenever items are added to the collection), I have to run the "rebuild_zebra.pl" script to get the catalog to update. After I run the rebuild script, things will run fine for a day or two...then...searching the catalog will stop working. Any ideas on where to start on this ?

1 0

OT: Makerspaces and soldering
by Chad Roseburg 08 Jun '16

08 Jun '16

Please excuse the off-topic posting: This is a question for libraries with Makerspaces and/or offering programs involving soldering: * Insurance and liability? What do you do? * Do they fill out forms to participate? The libraries I've seen that offer soldering report that, once told that the iron is "very hot", "Do Not Touch" ...self-preservation and aversion to pain kick in and virtually eliminate accidents. But I thought I'd ask anyway. We are doing an Arduino project at the end of the month and I'm debating whether or not to pull out the soldering kits or stick to breadboards. We can take this off-list so as not to clutter ... Thank you! [ If you know of a better list for this please recommend ] -- Chad Roseburg Asst. Director / IT Automation Dept. North Central Regional Library

5 4

Handling student worker accounts
by Eric Phetteplace 08 Jun '16

08 Jun '16

Hi all, First of all, we are right now starting to migrate to Koha so I'm probably going to ask a lot of questions on this list in the coming weeks. Bear with me. If you have low-level employees who perform basic circulation work—e.g. work study students, volunteers—how do you handle their account permissions? Do you have a shared internal account with a password you periodically change? Do you edit their patron account to add necessary permissions and then later revoke them? We're trying to find a scalable way to handle this. Editing a half-dozen or so patron accounts each semester doesn't seem wise to me. But internal accounts like this are weird too, because they're not "real" patrons. For instance, I'm filling in fake barcodes because they're required but this patron will never check anything out. Also, are is there no equivalent of user "roles" in Koha—sets of permissions I can quickly apply to an account? It's one thing if I can just add a student to a "work study" role and another if I have to click a bunch of checkboxes. Best, Eric Phetteplace Systems Librarian California College of the Arts libraries.cca.edu | vault.cca.edu 510.594.3660 2>/dev/null

3 3

Monthly general IRC meeting - is on in under three hours
by David Nind 08 Jun '16

08 Jun '16

Hi everyone. The monthly general IRC meeting is on in just under three hours! Time converter for your time zone: http://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+IRC+General+M… Agenda: https://wiki.koha-community.org/wiki/General_IRC_meeting_8_June_2016 David Nind | david.nind(a)gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 m. +64 21 0537 847 | w. +64 4 8906 098

1 0

Generating a barcode list of records created by a particular user in a given time frame
by Admire Mutsikiwa 08 Jun '16

08 Jun '16

Hi I am interested in generating a barcode list of records created by a given user ( as a function of borrower number) in a given time frame. I will appreciate an SQL statement that will enable me to achieve this. Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263771117777 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>

3 4

Kohacon 2017
by Mirko Tietgen 08 Jun '16

08 Jun '16

Hello everyone, Kohacon 2016 is almost over. It was a fantastic event and I am sad to leave Thessaloniki and everyone here tomorrow. We already have a wiki page for Kohacon 2017 bids, and I invite everyone to enter their proposals to host Kohacon next year. My phone does not want to copy the link, so just do a search in the Koha wiki for kohacon17. Keep in mind that we have been in Europe this year, so we will pick a place on a different continent next year. We have not set a deadline yet (I think), we should do so at one of the next IRC meetings. Cheers from Thessaloniki, Mirko

1 1

Re: [Koha] LOC Z39.50 Connection configuration setup
by Paul A 07 Jun '16

07 Jun '16

At 09:42 AM 6/7/2016 -0400, G.C. wrote: >[snip] So, one possibility is that there is a firewall blocking the LC Z39.50 >server outright, or just your ability to access port 210. To >distinguish, you could try the following command: > >curl http://lx2.loc.gov That will always give <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"><html><head><title>403 Forbidden</title> etc, etc Try using: curl http://lx2.loc.gov:210 which should give: <?xml version="1.0"?> <zs:explainResponse xmlns:zs= etc, etc Our production Z39.50 to LoC works perfectly using lx2.loc.gov:210 LCDB USMARC utf8 Best -- Paul >If you get a response like the following: > ><!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> > > >Forbidden > > > >You don't have permission to access / on this server. > >... it means that while you are able to access the Z39.50 server on >port 80, access to port 210 is blocked. If that's the case, your next >step would be to check with your server and network administrators to >see if there is an outgoing block on port 210. > >Regards, > >Galen >-- >Galen Charlton >Infrastructure and Added Services Manager >Equinox Software, Inc. / Open Your Library >email: gmc(a)esilibrary.com >direct: +1 770-709-5581 >cell: +1 404-984-4366 >skype: gmcharlt >web: http://www.esilibrary.com/ >Supporting Koha and Evergreen: http://koha-community.org & >http://evergreen-ils.org >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >https://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

2 1

LOC Z39.50 Connection configuration setup
by Decka David 07 Jun '16

07 Jun '16

Dear Koha community, Is there anyone in the community who successfully connect to Library of Congress Z39.50 server for copy cataloguing practices or search on port 210? Maybe I could have missed out on any new changes and updates with the Library of Congress connection issues. As instruction on Wiki Koha <https://wiki.koha-community.org/wiki/Troubleshooting_Koha_as_a_Z39.50_serve r> but all seems to be unsuccessful. Can someone help advice about the this issue Decka David PNG

2 3

SQL reports - Fine generating with itemtype filter
by Suresh Kumar Tejomurtula 07 Jun '16

07 Jun '16

Dear all, I need help in generating a report related to fines. Using the below report iam able to generate the fines. I would like to add a filter to this report "itemtype" for fine report as our circulation rules are slightly different for books and journals and the complete fine reports sometimes not exactly what iam looking for. I tried adding this (SELECT itype FROM items t WHERE t.itype = 'BK') AS 'ITEMTYPE') and added items t at "from statement", but not working. As iam not much aware of sql reports, requesting help in generating report with itemtype as a filter, I would like to generate fine report on a monthly basis with itemtypes. _________________________________________________________________________________________________________________ SELECT (SELECT CONCAT('<a href=\"/cgi-bin/koha/members/ boraccount.pl?borrowernumber=',b.borrowernumber,'\">', b.surname,', ', b.firstname,'</a>') FROM borrowers b WHERE b.borrowernumber = a.borrowernumber) AS Patron, format(sum(amountoutstanding),2) AS 'Outstanding', (SELECT count(i.itemnumber) FROM issues i WHERE b.borrowernumber = i.borrowernumber) AS 'Checkouts' FROM accountlines a, borrowers b WHERE (SELECT sum(amountoutstanding) FROM accountlines a2 WHERE a2.borrowernumber = a.borrowernumber) > '0.00' AND a.borrowernumber = b.borrowernumber AND a.timestamp BETWEEN <<FINE Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> GROUP BY a.borrowernumber ORDER BY b.surname, b.firstname, Outstanding ASC _________________________________________________________________________________________________________________ -- Regards T. Suresh Kumar

1 0

Re: [Koha] Removing Boolean searching from OPAC.
by Tajoli Zeno 07 Jun '16

07 Jun '16

Hi to all, Il 07/06/2016 11:12, Raymund Delahunty ha scritto: > Thanks for this. > > I added the JQuery to the Bywater Solutions database but I still don't see this search acting as an old fashioned "left anchored" title search. > If search on ART on a title search I expect the items returned will ALL start with the word art. > > http://catalog.bywatersolutions.com/ > > But that isn't how the search is operating. Is Koha capable of offering a left anchored title search? well, as I know out-of-the-box this oprion is not present. If you do modification on you zebra configuration about title (index 'ti') I think it is possible. But I never do a similar configuration. Bye Zeno Tajoli -- Zeno Tajoli / SVILUPPO PRODOTTI/ - Automazione Biblioteche Email: z.tajoli(a)cineca.it Fax: 051/6132198 *CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)

1 0