- Koha - lists.katipo.co.nz

Call for news for April Newsletter
by Koha Newsletter 16 May '14

16 May '14

Fellow Koha users ~ We're collecting news for the April newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- * News items can be of any length. * Anything and everything Koha. * Submit by the 26th. If you are working on an interesting project or development related to Koha, please let us know and we'll include in the gossip/society section. -- Chad Roseburg Joanne Dillon Editors, Koha Newsletter

2 1

Call for proposals: North American Koha Users Group
by nakug 16 May '14

16 May '14

Call for proposals: Please share your knowledge with the North American Koha Community this August in Wenatchee Washington. Here are some topics that have been suggested but feel free to share any other knowledge you may have. * Testing bugs * Workflow with git * Upcoming features - demos * Future of Koha - elasticsearch, plack ...other improvements. * Overview of Bootstrap in OPAC If you are attending and have topics you'd like to see covered, let us know. If there are no presentations covering your topic we can schedule a round table discussion with support vendors and developers. For more information about the upcoming meeting: http://ncrl.org/nakug Registration: http://ncrl.org/nakug_2014_reg Dates: Aug 6 - 8 [ 9th optional ] Submit your presentation here: http://ncrl.org/nakug_2014_presenter To all attending, please register or RSVP so we can plan for space. Thank you ~ Chad Roseburg Systems Librarian North Central Regional Library

1 0

Another report help question
by Nicole Engard 15 May '14

15 May '14

I have this report that shows me item with no checkouts in a number of days, but how about showing items with fewer than X checkouts in that same number of days? SELECT b.title, b.author, i.itemcallnumber, i.barcode, i.datelastseen, i.datelastborrowed, i.issues as 'total checkouts ever', i.renewals as 'total renewals ever' FROM biblio b JOIN items i USING (biblionumber) WHERE i.itemnumber NOT IN (SELECT DISTINCT itemnumber FROM statistics WHERE type = 'issue' AND (TO_DAYS(curdate())-TO_DAYS(datetime)) > <<No checkouts in X days>>) and i.dateaccessioned <= <<Acquired on or before (yyyy-mm-dd)|date>>

1 0

***UNCHECKED*** Overdue Fines..
by Jerwyn Fernandez 13 May '14

13 May '14

Good day, Hope all is well, can someone has a knowledge on how are we going to enable the e-mail messaging in KOHA? What are the things we need to configure? Thank you and best regards, -- *BE AMAZING. BE SOUTHVILLE.* Jerwyn G. Fernadez, RL Basic Education Librarian Southville International School and Colleges Tel: 825-6374 loc.117/146 *Like us https://www.facebook.com/sisc.monarchs <https://www.facebook.com/sisc.monarchs>* *Follow us https://twitter.com/SISCMonarchs <https://twitter.com/SISCMonarchs>* * www.southville.edu.ph <http://www.southville.edu.ph/>* * https://www.youtube.com/watch?v=CEeXh3JyXRg <https://www.youtube.com/watch?v=CEeXh3JyXRg>* *http://library.southville.edu.ph*<http://library.southville.edu.ph>

2 1

Job Opening at Koha Library In Reno Nevada
by Keener, Nancy 12 May '14

12 May '14

POSITION AVAILABLE INTERNET SERVICES LIBRARIAN WASHOE COUNTY LIBRARY SYSTEM RENO, NEVADA The Internet Services Librarian manages the Washoe County Library System website, oversees a popular public Internet access service, helps resolve technical issues and takes part in system-wide planning. Applicants must have a Master's degree in Library Science from an ALA accredited program and two years of professional level library experience, , with an emphasis on managing technology, OR an equivalent combination of education and experience. The successful candidate will have working knowledge of XHTML, XML, XSLT, CSS, MYSQL, PHP, or other scripting languages. Some experience with image software such as Photoshop, Fireworks or Gimp is preferred. This position requires knowledge of Integrated Library Systems. Candidates must be able to prioritize work in a busy environment and have excellent interpersonal relationship skills, with the ability to communicate effectively with people of diverse backgrounds. Salary range $55,972 - $72,758. No state income tax; PERS retirement; with medical, dental, vision, life insurance benefits currently provided at no cost to employee; longevity pay; and voluntary deferred compensation supplementary retirement program available. Applicants must complete a Washoe County Employment Application. For more information and access to the application form see the Washoe County Human Resources Department web site at http://www.washoecounty.us/humanresources/careers/jobs.htm<http://www.washoecounty.us/humanresources/careers/jobs.htm%20>. For questions call Karen Jeffers, the Recruiting Analyst at (775) 328-2078 or email KJeffers(a)washoecounty.us<mailto:KJeffers@washoecounty.us> Washoe County is located along the eastern slopes of the Sierra Nevada Mountains and is known as a great recreational area. The community has 12 physical library branches with locations in the areas of Reno, Sparks, Incline Village and Gerlach. Deadline for applying is Monday May 19, 2014. Nancy Keener Systems Librarian I.T.O.S.C. Chair Washoe County Library System Reno, Nevada 775 327-8347 nkeener(a)washoecounty.us<mailto:nkeener@washoecounty.us>

1 0

MARC 21 522 Geographic Coverage field display constant
by Elaine Bradtke 11 May '14

11 May '14

According to this: http://www.loc.gov/marc/bibliographic/bd522.html in the 522 field a blank first indicator should result in the display constant "Geographic coverage" But it doesn't seem to work in Koha (3.14.06) The contents of the field display, but not the phrase "Geographic coverage". We're testing out another import, and geographic coverage is an important part of this batch of records. I can add that statement in, pre upload, but was hoping the field would just do the right thing. Any thoughts? Other display constants in fields such as 785 seem to work fine. I didn't see a bug filed for this. -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

2 1

A dump of greeck/cyrillic records
by Zeno Tajoli 11 May '14

11 May '14

Hi to all, we are tryin to test deeply Koha and UFT-8 (bug 11944) But we need an help to use real marc21 records with no latin alphabets We know samething about greek and cyrillic alphabets, so if you use those script do [linux command line, koha user]: mysqldump -uroot -p <databasename> biblio -r biblio.dump gzip biblio.dump mysqldump -uroot -p <databasename> auth_header -r auth.dump gzip auth.dump Then write to me directly, I have a special tool for upload big files to me. If Arab/Chinease/Hindu people want to help, no problems. But we don't understand anything of their scripts Bye 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

Statistics for inter-branch activity
by Cab Vinton 10 May '14

10 May '14

Hi, All -- We're part of a 3-library coop where patrons have reciprocal borrowing privileges at any of the 3 libraries. Ideally, I'd like to be able to generate summary statistics on how patrons from each library are using these privileges, based on patrons' home library, the owner of items checked out, & where the transaction physically took place. I expected the following report to do this for me: SELECT s.datetime, i.itemcallnumber, i.itype, i.ccode, i.barcode, b.categorycode, s.type, b.cardnumber, s.branch, b.branchcode, i.homebranch FROM statistics s LEFT JOIN items i on (i.itemnumber = s.itemnumber) LEFT JOIN borrowers b ON (s.borrowernumber = b.borrowernumber) WHERE s.type in ('issue','renew','localuse') AND s.datetime BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> ORDER BY i.itype, i.ccode, i.cn_sort asc Unfortunately, for 17% of the transactions the home library of the patron is missing (b.branchcode). In our case, this amounts to some 33,000 transactions for 2013. The vast majority of these transactions (98%) are of type Local Use. (We have the RecordLocalUseOnReturn preference set to 'Record' for when items not checked out are checked in.) Can anyone explain what's going on here? Does it have something to do with how Transfers between branches are recorded by Koha? Thanks for any insight you can offer. Best, Cab Vinton, Director Plaistow Public Library Plaistow, NH

1 0

***UNCHECKED*** Importing Patron Loan History
by Arup Raychaudhury 10 May '14

10 May '14

Will there be any problem if I import transaction history through offline circulation process? I have around 500000 transactions. -- Arup Raychaudhury ------------------------------------------------- Indian Statistical Institute 203 BT Road Kolkata 700108 Phone:0-33-2575-2106

1 0

Zebra server fails to start
by Lenora Oftedahl 09 May '14

09 May '14

Our external server is running, but Koha returns 0 results for all searches. We've got the LCK files owned & grouped as Koha. We've rebuilt the index. zebra-daemon and zebraqueue-daemon refuse to start. None of the error logs show anything. Any hints? Help? Lenora A. Oftedahl StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission http://www.fishlib.org

4 3