- Koha - lists.katipo.co.nz

Replace all existing call numbers with LoC
by Daniel Glendening 29 Mar '16

29 Mar '16

Hi, I'm working on a restructuring of a small arts non-profit library. The library currently uses an esoteric, confusing custom catalog numbering system devised by a staff member who is no longer here. We'd like to switch all our records over to LoC cataloging. We currently are using Koha 3.18.05.100 - I'm curious if it's possible to replace all our records with LoC records, in bulk, rather than editing each individually. Thanks!

7 11

Koha-related internship opportunity with stipend: Haitian Education & Leadership Program (HELP)
by Galen Charlton 29 Mar '16

29 Mar '16

[Forwarding this; please contact info(a)uhelp.net, not me, if you want more information] Position: Librarian (Volunteer – travel, housing and living stipend provided) Location: HELP Center, Port-au-Prince, Haiti Department: Student Affairs Supervisor: Deputy Country Director Duration: Eight weeks during the summer of 2016 Overview of the Position : HELP (http://uhelp.net) is seeking a French or Haitian-Creole speaking Library Science student or graduate who would supervise the overall classification of the HELP library. The focus is on migrating the entire library (approximately 3000 books) from an Excel spreadsheet to a Koha Integrated Library System (ILS). The HELP Library is a major service provided to students that allows them to have the necessary materials they need for their university classes and related research. By establishing a professional ILS (Koha), HELP staff and students will be able to more efficiently use the library resources. Summary of Responsibilities : Below are the major responsibilities and tasks, in order of priority, related to this position. Please note that this summary is not exhaustive. A- Establish a systematic process for cataloguing all the books in the HELP library and those used by the HELP Academic Department into Koha B- Train and supervise HELP student interns focusing on ILS data entry. C- Provide general library management training to select HELP staff and students. D- Provide recommendations to HELP for other library resources that would be useful for our students and staff and ideas on how those might be integrated into HELPs existing systems. Minimum Qualifications : - Education: Current MLS/MLIS/MSIS student or graduate.. - Work experience: Experience with data entry for Cataloging with an Integrated Library Systems (Koha experience preferred). You should be familiar with copy of records from other systems as well as creating new ones where no other accessible system has the book. Note: this library will be organized using Dewey Decimal. - Essential skills: Ability to teach and supervise others. Strong organizational and interpersonal skills. Ability to stay focused on task with many interesting distractions in close proximity. - Language(s): English and either French or Haitian Creole are required; Duration: The maximum length of this assignment is 2 months (preferably June and July 2016), however for the right candidate it is possible this could be a shorter commitment. The intern can end at either the end of two month or after the key goals have been met and the staff feels able to take over. Benefits: HELP will provide airfare to and from Haiti, housing near its office in Pacot, Port-au-Prince, and a $600/mo stipend to help cover other expenses. For additional information, contact info(a)uhelp.net. -- 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

1 0

SQL Query - Items with a Local Cover Image
by Craig Butosi 27 Mar '16

27 Mar '16

Hi all, Koha 3.22 on Ubuntu 14.04 LTS (package install) I`m trying to write a basic SQL query to pull all items with a local cover image. I`m running Coce now, so I no longer need to upload local cover images to Koha. I need to identify these records so I can remove their images. I have a basic query: SELECT biblionumber FROM biblioimages WHERE biblionumber AND imagefile IS NOT NULL which works, but only returns the biblionumber column from the biblioimages table. I`d like to add a call number column from the items table to this report. I`ve tried this SELECT biblionumber FROM biblioimages LEFT JOIN items ON biblioimages.biblionumber=items.itemcallnumber WHERE biblionumber AND imagefile IS NOT NULL But I get an ambiguity error, and I don`t quite understand how to apply an alias to overcome this. The error is as follows: Craig Butosi, MA, MLIS, B Mus (Hons.) LIBRARY SERVICES MANAGER the royal conservatory TELUS Centre for Performance and Learning 273 Bloor Street West Toronto, ON M5S 1W2 416.408.2824 x338 www.rcmusic.ca<https://webmail.rcmusic.ca/owa/redir.aspx?C=b481823b299d45ee94b0016389bb76e…> Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.

2 3

Packages for 3.20.10 and 3.22.5 now available
by Galen Charlton 27 Mar '16

27 Mar '16

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Hi, Packages for 3.20.10 and 3.22.5 are now available from the Koha APT repository debian.koha-community.org. As always, instructions for installing from the packages can be found at https://wiki.koha-community.org/wiki/Debian Regards, Galen - -- Galen Charlton gmcharlt(a)gmail.com -----BEGIN PGP SIGNATURE----- Version: Mailvelope v1.3.6 Comment: https://www.mailvelope.com wsFcBAEBCAAQBQJW9p9ZCRATSna3Q9mGMAAAMykP/0by02FZv9gsyma0k7bn A7s//aqdGQukGJ+5nmrsbfkMW/60qtEqV9RSn6+eYqAGe6elVZisEsBM66Yn 032h60khSgpKRwP53bSMgvEbxw+iZBdpGZvrvr1EjFkkR5dggtDheHqAr0fG GeFKh+3xD8zdU6l+YduThMDJ1dRBrZLqST9ORDsglDsT/zU71rmjUo8cx+HO aQEnUiUDAlct5Pj4GlB6UsuvDia15EkyaArO4j/OKay0PfgQS+7Bfw4dh348 8kPrFQq3SHcYn+cpruteW86gx+NLFt3bJwuEPRpOEZZGMr8UYm7RzNkUokiZ 4++o8yjr2Uq6dZQ5DGCh0jjiS3MqL73IatMWbT7hbz5aNuKcZEMsgf9rjLDI ed143x0P52lcyRXRnsx5Mbum8VyEwPWdp+qRHwhdOjxXY9v+QW8S9sYXT/wy TmTLurhSX1/EPTqzLwF/zZ+BsNNJ5ysMLegzNBCn3dZ74S4uZTZF9IADvcKm yXXBmlX9YqCO4oEzOL4vB65uzmFP7z7icQl+hwofxDetOQRUWOPImpXjvBKE zHNVbu75dsR3xTwrYiZ/Ra1xSROnAWaoY+IQEtWm8jD4JQ/DZ8/rd5d23Rsk 7ksxgEBlz3fl2Uutfb1qSBA/mS1pJj8J+rcjGbBkKwN8oKEOyyCslBx5lGjy 8D2v =U2+X -----END PGP SIGNATURE-----

1 0

Koha and letsencrypt client on Debian 8
by Indranil Das Gupta 25 Mar '16

25 Mar '16

Hi all, Koha's vhost file typically puts in both the opac and the staff client vhost definition in the same file. I've been playing with Letsencrypt and so far it only supports configurations with only one single vhost per .conf file. I've no problem handling it myself, but I would like to hear how others using / evaluating LE for use with Koha are tackling the issue. thanks -- Indranil Das Gupta L2C2 Technologies 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

2 1

koha on nginx
by Jens Brodhagen 24 Mar '16

24 Mar '16

Hello, is it possible to install koha on nginx-Webserver? Best regards Jens

1 0

Fwd: Re: errors
by Lenora Oftedahl 24 Mar '16

24 Mar '16

Apparently, our installation for Koha has been throwing a lot of these errors in the log the past couple of weeks. Any idea what we might have done to break our search function? Timeout waiting for output from CGI script /usr/share/koha/opac/cgi-bin/opac/opac-search.pl Script timed out before returning headers: opac-search.pl Koha version: 3.20.05.000 OS version ('uname -a'): Linux sequoia 3.2.0-4-686-pae #1 SMP Debian 3.2.73-2+deb7u2 i686 GNU/Linux Perl interpreter: /usr/bin/perl Perl version: 5.014002 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.5.47, for debian-linux-gnu (i686) using readline 6.2 Apache version: Zebra version: Zebra 2.0.44 (C) 1994-2010, Index Data ApS 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: 419ad759807269fdfa379799a051ed3a551c6541 Using ICU

1 0

Question about SQL query
by Lenora Oftedahl 24 Mar '16

24 Mar '16

SELECT biblio.biblionumber, SUBSTRING(biblioitems.marcxml, LOCATE('<subfield code="a">', biblioitems.marcxml, LOCATE('<datafield tag="029"', biblioitems.marcxml)+19), LOCATE('</subfield>', biblioitems.marcxml, LOCATE('<subfield code="a">', biblioitems.marcxml, LOCATE('<datafield tag="029"', biblioitems.marcxml)+19)) - LOCATE('<subfield code="a">', biblioitems.marcxml, LOCATE('<datafield tag="029"', biblioitems.marcxml)+19)) AS SNRefID FROM biblioitems, biblio WHERE biblioitems.biblionumber = biblio.biblionumber In this SQL query, what does the +19 do? I'm trying to write a report to pull out all the catalog records for a select group of documents by 029 subfield A. I think my current results are from the 035 A subfield which is not what I'm asking for.

1 0

Koha 3.22.5 security release
by Julian Maurice 24 Mar '16

24 Mar '16

The Koha community is proud to announce the release of Koha 3.22.5. This is a security release and contains many bugfixes. The full release notes are available at https://koha-community.org/koha-3-22-5-security-release/ -- Julian Maurice <julian.maurice(a)biblibre.com> BibLibre

1 0

Koha version 3.20.10
by Frédéric Demians 24 Mar '16

24 Mar '16

The Koha community is proud to announce the release of 3.20.10. This is a maintenance release and contains many bugfixes and enhancements. As always you can download the release from: http://download.koha-community.org Stay tuned for Debian/Ubuntu package availability.

1 0