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

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

Re: [Koha-devel] [Koha] Introducing "Mana" (central DB project)
by Hugo Agud 13 Jul '16

13 Jul '16

Wonderful!!! 2016-07-11 23:20 GMT+02:00 Sebastian Hierl <s.hierl(a)aarome.org>: > Congratulations and looking forward! > > Sebastian > On Jul 10, 2016 9:26 AM, "Arslan Farooq" <arslanone(a)gmail.com> wrote: > > > Congratulations Paul, BibLibre, Morgane ! > > > > This will be great :-) > > > > On Wed, Jul 6, 2016 at 3:03 PM, Paul Poulain <paul.poulain(a)biblibre.com> > > wrote: > > > > > Some months ago I sent an email to koha-devel, to announce that > BibLibre > > > was planning to work on a new project, dedicated to sharing > informations > > > between Koha ( > > > https://wiki.koha-community.org/wiki/SharingDatasBetweenKohas_rfc) > > > > > > I'm proud an happy to give you feedback about this project: things are > > > moving quickly & nicely. > > > > > > * *Morgane*, our intern -alex_a being the tutor) is doing a great job > > > (you can congratulate her on #koha ;-) ) > > > * we've named this project "*Mana*". It's a Maori word (once again > :D), > > > easy to pronounce & write. > > > http://maoridictionary.co.nz/search?&keywords=mana : "*(verb)* to be > > > legal, effectual, binding, authoritative, valid." I'll ask for > > > mana.koha-community.org DNS entry soon ! > > > * as announced by Morgane, we're using the same framework as for HEA > for > > > the server side. The code is available on our git: > > > http://git.biblibre.com/biblibre/koha-mana (will be pushed later on > > > git.koha-community.org) The DB is here, some webservice are already > > here > > > & working. > > > * The koha-side is being worked, below are some screen shots. > > > * we changed some things compared to my initial RFC. Everything is on > > > trello, splitted into cards ( > https://trello.com/b/BslL6i9p/mana-biblibre > > > trello not public, claire, the owner is not here today, we'll change > the > > > status in a day or 2.) Note that there can be some French on trello, > even > > > if Morgane avoid it. > > > We plan to have MANA working at the end of august, at least for > > > subscriptions (pattern & numbering) sharing. Maybe also for SQL > reports & > > > vendors. > > > > > > Some screen shots & features descriptions: > > > > > > in subscription management, you can now *share* a subscription > pattern, > > > by sending it to Mana: > > > > > > When you click on "share", after validation, you get a *feedback*: > > > > > > > > > > > > Anyone can then retrieve the numbering pattern & frequency calculation > > > when creating a subscription (work being done this week). After the 1st > > > screen of subscription creation, Koha will automatically query mana and > > > check if there is some data available: > > > > > > > > > The librarian will then be able to see what is available and get it > > > locally in one click. > > > Every time a librarian "get it locally", a counter will be incremented > on > > > Mana. Thus, if more than 1 frequency/pattern is submitted for a given > > > title, the librarians should be able to see which one is "preferred" by > > > other librarians. > > > > > > Additional features: > > > * we will create a script that will help populate Mana from a CSV. We > > > will probably issue a RFF ("Request For File" ;-) ) later. Our idea is > > that > > > we want to launch Mana with many data already available. > > > * comment. Any librarian will be able to add a comment to a shared > data, > > > as well as marking it as "obsolete". > > > * a syspref will be added to deactivate Mana (will be ON by default) > > > > > > Feel free to ask for more informations, I would be happy to answer ! > > > > > > -- > > > Paul Poulain, Associé-gérant / co-owner > > > BibLibre, Services en logiciels libres pour les bibliothèques > > > BibLibre, Open Source software and services for libraries > > > > > > _______________________________________________ > > > Koha mailing list http://koha-community.org > > > Koha(a)lists.katipo.co.nz > > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* <http://www.orex.es/> [image: http://orex.es] <http://orex.es> <http://www.orex.es> Director Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

2 1