- Koha - lists.katipo.co.nz

Add funds in bulk?
by Marton VILLANYI 21 Dec '16

21 Dec '16

Hi, I’m planning to add more than 100 new funds to some budgets. It would be great to import a list like one can do with patrons (e.g. a CSV file). Is there a way to do so? Or do I need to add the new funds one by one? Thanks, Márton Márton Villányi Library Institute of Science and Technology Austria Phone +43-(0)2243 9000-1115 Am Campus 1 A-3400 Klosterneuburg

2 1

Call for news: December 2016 Newsletter
by kohanews 21 Dec '16

21 Dec '16

Fellow Koha users ~ I'm collecting news for the December newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events -- **** one month back is the cut-off ***. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. -- Chad Roseburg Editor, Koha Community Newsletter

2 1

Koha Savings
by Nathan Curulla 20 Dec '16

20 Dec '16

Greetings fellow Koha users!! In a constant effort to promote Koha within the library world I am always thinking of new ways to portray the benefits of switching to an open source solution such as Koha. Now more than ever libraries need a more reasonably priced alternative to what is out there without having to give up functionality. One way I was thinking of showcasing the success of Koha was by sharing stories of current Koha users who have saved significant money by making the move, and what they have done with that extra cash as a result. Did you create a makers space with the money that was freed up? Buy new computers? Sponsor developments? If you fall into this category and are willing to share your story please contact me directly so that I can learn more!! Thank you all very much in advance and have a great Holiday! All the best, -Nate

1 0

Koha Maps
by Marshall Breeding 20 Dec '16

20 Dec '16

I have been following the discussion about how the Koha community can better market itself, including using a map display to emphasize its global impact. Naturally, I would be happy to have the map generated from Library Technology Guides to be used. Doing so would help me ensure that my registry of libraries using Koha is more complete since libraries might be more motivated to be included. Regardless of whether the Koha community decides to rely more on my mapping tool, I will continue to try to obtain data on the many libraries using Koha that are not yet registered on my site or any other database. I continue to think that Koha is most likely the most implemented ILS, but I do not yet have the data to validate that assertion. The purity of working only with open source software and open access data seems to me like an impossible goal. Richard Stallman, who I heard speak last year, takes this concept to its logical conclusion, and ends up with quite a limited realm of software or data which meet his tests for purity. Is the Koha community comfortable using the Google Map API, for example, since it is based on a closed and proprietary information infrastructure and underlying software components that may or may not be open source? Or does it plan to invent its own global mapping ecosystem? I have looked at the Hea tool and I have a hard time imagining it gaining the functionality of a global mapping visual and becoming well populated by the mechanisms provided. Since it is generated mechanically through each instance of Koha, it will be difficult to translate this data to represent the libraries that are actually using Koha in production. Many of the entries shown now (http://hea.koha-community.org/libraries) seem to be duplicates or test implementations. Its single entry for the NExpress Shared Catalog is represented by 53 libraries on my maps. I don't see hea as having the structure has the ability to represent the branches associated with a library system or consortia and many other aspects of tracking the libraries which use any given automation system. I think that many, if not the majority, of Koha implementations globally are based on older or forked versions of Koha, making it difficult or impossible for them to automatically contribute their data to Hea. I also wonder why the Koha development community would divert resources into re-creating such a tool from other efforts to develop and promote Koha. Having maintained a registry of libraries for almost two decades, my experience tells me that it is much more difficult to create and maintain a well-organized list than others might imagine. I have also just re-written the map tool on Library Technology Guides to generate the display more quickly when there are a very large number of libraries. Although it depends on how quickly the Google API responds, it now builds the maps in a few seconds, compared to almost a minute previously. I have also added some basic search selection tools at the bottom of the page: https://librarytechnology.org/libraries/map.pl?ILS=Koha I'll be interested to hear further discussion on the topic. Marshall Breeding marshall.breeding(a)librarytechnology.org<mailto:marshall.breeding@librarytechnology.org> www.librarytechnology.org/<http://www.librarytechnology.org/> twitter.com/mbreeding http://www.linkedin.com/in/breeding http://scholar.google.com/citations?user=NnvfJ5cAAAAJ

3 2

SQL for overdues / fines by borrower ?
by Scott Owen 20 Dec '16

20 Dec '16

Hi all, One of my Liberians is asking for a fine report "by borrower" that can be easily printed. ie: Borrower ID (xxxxx) Last Name, First Name: overdue_Item ---- Fine overdue_Item2 ---- Fine BorrowerID (xxxxx) Last Name, First Name: overdue_Item3 ---- Fine overdue_Item4 ---- Fine this way we don't have to use 1 sheet of paper per fine, and sometimes wind up giving the same patron 3 sheets of paper.... Wondering if someone already has this report made (and would be willing to share) Thanks, -S

2 1

Re: [Koha] Report for bibs with multiple items with item details
by Michael May 20 Dec '16

20 Dec '16

I apologize. I've figured out how to add biblionumbers to a report of all items, and then how to identify and isolate duplicates in the downloaded spreadsheet. This pretty much does what I want. Thanks for listening. :) -Mike From: Michael May Sent: Monday, December 19, 2016 12:04 PM To: 'koha(a)lists.katipo.co.nz' <koha(a)lists.katipo.co.nz> Subject: Report for bibs with multiple items with item details Hi all, I need to weed DVDs that have multiple copies, so I'm trying to find a downloadable Koha report that shows all bibs with multiple items which includes details about all of those items, like barcodes, call numbers, and loan statuses. I see reports at https://wiki.koha-community.org/wiki/SQL_Reports_Library which show bibs with item counts, but I'm hoping to get specific details about those items. Is this the right place to ask for help with this? Thank you. Mike Michael May Adult Services Librarian Carnegie-Stout Public Library 360 West 11th Street Dubuque, IA 52001-4697, USA Phone: 563-589-4225 ext. 2244 Fax: 563-589-4217 Email: mmay(a)dubuque.lib.ia.us<mailto:mmay@dubuque.lib.ia.us> Web: www.dubuque.lib.ia.us<http://www.dubuque.lib.ia.us/>

2 2

Re: [Koha] Z39.50 search - "Nothing found"
by Dimitris Antonakis 20 Dec '16

20 Dec '16

Hi Vasiliki, Did you make any changes to the Z39.50 server configuration settings? Please try to restart apache (/etc/init.d/apache2 restart) Dimitris Antonakis -- Δημήτρης Αντωνάκης

3 3

Report for bibs with multiple items with item details
by Michael May 19 Dec '16

19 Dec '16

Hi all, I need to weed DVDs that have multiple copies, so I'm trying to find a downloadable Koha report that shows all bibs with multiple items which includes details about all of those items, like barcodes, call numbers, and loan statuses. I see reports at https://wiki.koha-community.org/wiki/SQL_Reports_Library which show bibs with item counts, but I'm hoping to get specific details about those items. Is this the right place to ask for help with this? Thank you. Mike Michael May Adult Services Librarian Carnegie-Stout Public Library 360 West 11th Street Dubuque, IA 52001-4697, USA Phone: 563-589-4225 ext. 2244 Fax: 563-589-4217 Email: mmay(a)dubuque.lib.ia.us<mailto:mmay@dubuque.lib.ia.us> Web: www.dubuque.lib.ia.us<http://www.dubuque.lib.ia.us/>

1 0

Migration erros from 16.05 to 16.11
by anjoze 19 Dec '16

19 Dec '16

Just to leave some feedback. *Migration from* Koha 16.05 OS: Ubuntu 16.04 64bits Mysql 5.7 with: sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION *To:* Koha 16.11 OS Ubuntu 16.04 64bits MariaDB First I've tried to upgrade on the same machine and had tons of problems maybe because Mysql 5.7 Then on a new VM machine with MariaDB I've imported the sql backup and had this erros: DBD::mysql::db do failed: Table 'koha_koha.items_search_fields' doesn't exist [for Statement " ALTER TABLE items_search_fields DROP FOREIGN KEY items_search_fields_authorised_values_category; "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 13152. DBD::mysql::db do failed: Table 'koha_koha.items_search_fields' doesn't exist [for Statement " ALTER TABLE items_search_fields ADD CONSTRAINT `items_search_fields_authorised_values_category` FOREIGN KEY (`authorised_values_category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE; "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 13157. Until now everything look ok... ----- Koha version: 16.05.05 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/Migration-erros-from-16-05-to-16-11-tp591… Sent from the Koha-general mailing list archive at Nabble.com.

7 17

Hello,
by dev.it＠cores-mada.net 19 Dec '16

19 Dec '16

---------- Forwarded message ---------- From: <dev.it(a)cores-mada.net> Date: Fri, Dec 16, 2016 at 9:04 PM +0300 Subject: Hello, To: <koha-request(a)lists.katipo.co.nz> Hello, I connect to my koha z39.50 for updating using marcedit. I have huge problem 'cause no error from marcedit but my koha database is not updating at all. Is there prerequested to be able to do that? I can search from koha in marcedit, but record are not updated then to koha. 19:58:53-16/12 zebrasrv(5) [warn] XML: Entity: line 1: 19:58:53-16/12 zebrasrv(5) [warn] XML: parser 19:58:53-16/12 zebrasrv(5) [warn] XML: error : 19:58:53-16/12 zebrasrv(5) [warn] XML: Document is empty 19:58:53-16/12 zebrasrv(5) [warn] XML: 00840nam a2200133Ia 450000800410000010000120004124500940005326000180014765003330 19:58:53-16/12 zebrasrv(5) [warn] XML: ^ Thank you,

1 0