July 2016 - Koha-devel - lists.koha-community.org

Koha Community Newsletter: July 2016
by kohanews 30 Jul '16

30 Jul '16

Fellow Koha users: The Koha Community Newsletter for June 2016 is here: https://koha-community.org/koha-community-newsletter-july-2016/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. Thanks! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

koha-common 16.06~git+20160729190213.ed61bd9b
by Mirko Tietgen 29 Jul '16

29 Jul '16

Hello everyone, I have uploaded a new master package to the Koha unstable repository. Have a nice weekend, Mirko -- Mirko Tietgen mirko(a)abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de

2 2

Moving on
by Jesse 25 Jul '16

25 Jul '16

Friends, colleagues, and that crazy guy named Kyle, I wanted to let you know that today will be my last day with ByWater Solutions. I'm taking a job with a local web application shop. I will miss working with all of you, though I plan to be involved with the Koha community going forward. Peace and good luck, -- Jesse Weaver

8 7

Re: [Koha-devel] log file of activities for admin of koha in the library
by Michael Hafen 21 Jul '16

21 Jul '16

Ok, for the Guided Reports the SQL will be something like: SELECT al.timestamp AS DateAndTime,b.surname,b.firstname,module,action FROM action_logs AS al LEFT JOIN borrowers AS b ON user = b.borrowernumber WHERE user <> 0 AND al.timestamp BETWEEN <<Between (yyyy-mmd-dd)|date>> AND <<And (yyyy-nn-dd)|date>> ORDER BY b.surname,b.firstname,al.timestamp You may want to adjust the order by with asc or desc qualifiers on the timestamp. But this only works for periods where you have the logging enabled, and only for those modules that are enabled. For example I don't see circulation when I run that SQL because I don't have logging enabled for that module. On Thu, Jul 21, 2016 at 4:46 AM, rania azad mohammed < rania.azad(a)auis.edu.krd> wrote: > Oh I see, > Can you help me on building the SQL query since I don't have a lot of > knowledge with SQL? simple report on librarian activities circulation,items > and cataloguing with date and time will be perfect > > > > On Wed, Jul 20, 2016 at 7:48 PM, Michael Hafen <michael.hafen(a)washk12.org> > wrote: > >> The action_logs table in the database could hold that information if you >> have turned on logging in the system preferences ( >> http://translate.koha-community.org/manual/3.22/en/html-desktop/#logs) >> There is a Log Viewer in Tools that may be useful for getting information >> from this table, or you can try building an SQL Report by hand. >> >> On Tue, Jul 19, 2016 at 11:45 PM, rania azad mohammed < >> rania.azad(a)auis.edu.krd> wrote: >> >>> Dear >>> >>> We are 3 admins in the library working on shifts in the library, each of >>> us log-in during her time. I want a report or log file to see all the >>> activities of each admin during a specific day. is there such report or >>> file? I tried to find it using the wiki but hopeless >>> >>> -- >>> >>> *Regards,* >>> >>> >>> *Rania Azad |* Library Manager >>> Library Department >>> http://library.auis.edu.iq/ >>> The American University of Iraq, Sulaimani >>> Office: >>> *B-G-32* Ext *1219* >>> >>> >>> >>> _______________________________________________ >>> Koha-devel mailing list >>> Koha-devel(a)lists.koha-community.org >>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >>> website : http://www.koha-community.org/ >>> git : http://git.koha-community.org/ >>> bugs : http://bugs.koha-community.org/ >>> >> >> >> >> -- >> Michael Hafen >> Washington County School District Technology Department >> Systems Analyst >> >> > > > -- > > *Regards,* > > > *Rania Azad |* Library Manager > Library Department > http://library.auis.edu.iq/ > The American University of Iraq, Sulaimani > Office: > *B-G-32* Ext *1219* > > > -- Michael Hafen Washington County School District Technology Department Systems Analyst

2 1

Re: [Koha-devel] 'Refine your search' is missing
by Luciana Coca 21 Jul '16

21 Jul '16

I solved the problem. Thanks Tomas for your help! I just changed the use_zebra_facets value in /etc/koha/koha-conf.xml 2016-07-18 12:13 GMT-03:00 Luciana Coca <lucianacoca1313(a)gmail.com>: > Hello everyone! > > I'm using Koha 3.22 on Debian 7.8. > > In Koha old versions there was an option 'Refine your search' that was > very useful when we were searching on catalog. It appeared in the > search results page. > > How can i get it back? > > Thank you for your help! > > Luciana.

3 3

Benchmarks for QA tools
by Jonathan Druart 21 Jul '16

21 Jul '16

Hi devs, During the last dev meeting [1] we discussed about the ability to add some benchmarks to the QA tools. I have written a prove of concept and push it to a branch [2]. I'd like to get feedbacks as I don't like how it works actually: 1/ It adds calls to C4 and Koha methods from the QA tools, while until now the QA tools where kind of independent of the Koha API 2/ The results are not really convincing: the time diff strongly changes from one execution to the others. I can get +15% and then -15% with the same patchset. Any ideas how we could improve them? Cheers, Jonathan [1] http://meetings.koha-community.org/2016/development_irc_meeting_13_july_201… [2] https://github.com/joubu/koha-qa-test/tree/benchmarks

1 0

Merge two Koha patron accounts
by KIS ISM 18 Jul '16

18 Jul '16

Dear Koha specialists, We have - by accident - created the new student accounts with the barcode extension -16 for the current year. Is there a SQL script that would allow me to merge two patron accounts (like xxxxx and xxxxx-16 into one account as xxxxx-16)? We are running Koha 3.16.03 Students have already checked out books on the new accounts so I can't just delete them. Thank you for your help with this. Rudy Wuthrich Kodaikanal International School

1 0

Easy sign offs...
by Mark Tompsett 15 Jul '16

15 Jul '16

Greetings, I’m focusing on the tests right now, as I want to rip out some functionality in order to refactor (turn OpacHiddenItems into a filter rather than a series of messy subroutines all over the place), and only get warnings/errors related to my destruction. To this end, I have some easy sign offs awaiting people’s perusal: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16809 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16864 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16868 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10148 -- I’m positive Nicole said she couldn’t reproduce 006 either somewhere, but I can’t find it. https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16856 GPML, Mark Tompsett

1 0

Call for News: July 2016 Newsletter
by kohanews 14 Jul '16

14 Jul '16

Fellow Koha users ~ I'm collecting news for the July 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

1 0

mailing list creation for greek koha community
by Γιάννης Κουρμούλης 13 Jul '16

13 Jul '16

dear developers list a month ago, I sent the following mail to mailman(a)lists.koha-community.org. ----- -Dear administrators - -as we are trying to establish the Greek Koha Users Group, we would also like to create the Greek koha users mailing list. I understand that we -need a "List creator's (authentication) password". Could you provide it? - -thank you ----- I have not received any response since. If any administrator of the koha mailing lists sees this, please respond... thank you ------------------------------------------------------------- Γιάννης Κουρμούλης Βιβλιοθήκη και Κέντρο Πληροφόρησης Α.Π.Θ. Ομάδα Τεχνικής Υποστήριξης Τηλ: 2310995368 Fax: 2310995364 -|Giannis Kourmoulis -|Library and Information Centre A.U.Th. -|Technical Support Team -|Tel: +302310995368 -|Fax: +302310995364 email:libsupport@lib.auth.gr -------------------------------------------------------------

2 1