- Koha - lists.katipo.co.nz

Report help
by Kerrie Stevens 15 Oct '14

15 Oct '14

Hi Everyone, I've been using the report 'Patrons with most checkouts in date range' with success, but when I try to modify it to allow me to select which campus library the patrons are from so I can get a top 20 list for any of our campus libraries, I can't get it to work - can anyone help me with this? SELECT concat(b.surname,', ',b.firstname) AS name, count(s.borrowernumber) AS checkouts FROM statistics s LEFT JOIN borrowers b USING (borrowernumber) WHERE s.datetime BETWEEN <<Top checkouts BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> GROUP BY s.borrowernumber ORDER BY count(s.borrowernumber) DESC LIMIT 20 Thank you! Kerrie Stevens COLLEGE LIBRARIAN Harvest Bible College

3 2

Bootstrap Theme Doesnt Work in Koha's OpacNav, OpacNavRight, OpacNavBottom and OpacMainUserBlock
by Alyssa Enganio Gono 15 Oct '14

15 Oct '14

I have already turn on my Bootstrap Theme in Koha. In fact, Bootstrap works when I tried to paste a sample bootstrap code in OpacHeader. But it doenst work when I tried to paste a bootstrap code in OpacNav, OpacNavRight, OpacNavBottom and OpacMainUserBlock. What should I do to enable bootstrap in this opac regions? -- View this message in context: http://koha.1045719.n5.nabble.com/Bootstrap-Theme-Doesnt-Work-in-Koha-s-Opa… Sent from the Koha-general mailing list archive at Nabble.com.

2 1

IndependentBranches - Administration option
by Alexede 14 Oct '14

14 Oct '14

Hi all, I have installed, since few months, Koha 3.16.1 on Deiban and started to use koha adding records. Now I have add a new branch (in the same databse and installation) but I vould like to use the "IndependentBranches" set to "prevent" in the Administration option. But, like the manual says, "It is important that this value be set before going live and that it NOT be changed", and infact I have started to use Koha with this option set to "Do not prevent" (i didn't know about this issue). So now, also if I set the "IndependentBranches" to "prevent", the function doesn't work and a parton of the new branch is still able to modify items, patron, ecc of the other branch. Does anyone have any suggestion? Thanks, Alessio -- View this message in context: http://koha.1045719.n5.nabble.com/IndependentBranches-Administration-option… Sent from the Koha-general mailing list archive at Nabble.com.

3 3

Integrating RFID and KOHA
by Upendra Tamang 13 Oct '14

13 Oct '14

Dear Koha administrator, We are running Koha 3.16 in Debian 6.0.8 64 bits. Recently we installed RFID system in our Library and there it says that we need to have SIP2 in Koha in order to integrate with RFID and Koha. I have no knowledge on how to enable or install SIP2. It would be grate if you help me on this. Thank you Upendra

2 1

Thank You
by BWS Johnson 11 Oct '14

11 Oct '14

Salvete! What could be better than steak and wine? Why Conference in Córdoba, of course. :D Bernardo and Tomás really raised the bar on KohaCon. Not only were the Argentines the friendliest folks on Earth, but the talks were also salient. I was so impressed with the Library School student presentations! It was awesome that the translator was on hand to help get ideas across the language barrier. Roberto from the Koha Users Group in Córdoba surely should win some sort of prize for cleverest t shirt design. What's not to like about a Kiwi sipping mate? I had gobs of fun and felt downright spoilt the entire time! A hearty thanks to all that helped to make this happen. Cheers, Brooke

1 0

Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2064.
by Mohamed Fekry Negm 11 Oct '14

11 Oct '14

Hi i got this error Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2064. in version 3.16 + ubuntu 14.04 in opac-user.pl any help

4 3

Koha demo installation
by Michael Kuhn 09 Oct '14

09 Oct '14

Please also list my Koha demo installation on the page http://koha-community.org/demo/ MARC flavor: MARC21 OPAC: http://koha.adminkuhn.ch:8001/ Staff interface: http://koha.adminkuhn.ch:8001/ Staff login: bebu / bebu Provider: Admin Kuhn GmbH (Switzerland) I also provide a single point of entry on http://adminkuhn.ch/wiki/Koha-Demoinstallation which automatically logs you in without needing any username or password. Kind regards: Michael Kuhn -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

1 0

Koha support provicer
by Michael Kuhn 09 Oct '14

09 Oct '14

Please list me as a paid Koha support provider. Company Name: Admin Kuhn GmbH Contact Person: Michael Kuhn Contact email: mik(a)adminkuhn.ch Website: http://adminkuhn.ch/wiki/Koha Telephone: +41 61 261 55 61 Address: Pappelstrasse 20, 4123 Allschwil, Switzerland Short description of services: Admin Kuhn GmbH was established in 2012 and has been providing technology support to libraries in the German speaking countries since (i. e. Germany, Switzerland, Austria). The company provides expertise in various aspects of technology in libraries from data migration, programming easy solutions to full Library Management System support. Visit the Koha demo installation with German interface: http://adminkuhn.ch/wiki/Koha-Demoinstallation Kind regards: Michael Kuhn -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

1 0

Unique entries
by Lenora Oftedahl 09 Oct '14

09 Oct '14

Ok. I have barcode set up to be a unique entry (cannot be two barcodes with the same number). But I can't remember how I did that, nor can I find instructions in the documentation. MARC Framework, Newbie Guide, searching for Unique Entry in the wiki. I know when someone tells me where to find the info, I'll be all like 'duh', but please help. Lenora StreamNet Regional Library Columbia River Inter-Tribal Fish Commission

3 2

Migrating from Spectrum
by Jeramey Valley 08 Oct '14

08 Oct '14

We are in process of migrating from Winnebago Spectrum to Koha and hitting some snags migrating our data. The MARC records for our collection will import, but does not include the holdings. I can see the holdings information in the 852 field in our original export file from Spectrum. Research indicated we should modify the file to put the holdings information in the 952 field and map accordingly. In testing trying this route, I am not seeing the 952 field importing into Koha (looking at the raw MARC file in Koha). Prior to modifying the import file to map the 852 info to 952 fields, I did see the 852 fields in Koha but they didn't appear to import or map to where they should be. Using Marcedit to modify the file. I have not created any material types or other setup information except to define the library and one "super user". New install of Debian and Koha 3.16.04.000 In between tests I am removing the Koha install, deleting the database and running the zebra reset procedures to try and keep things "clean". Any pointers or suggestions appreciated. -- Regards, Jeramey Valley Network Manager, Bullock Creek Schools valleyj(a)bcreek.org

4 6