- Koha - lists.katipo.co.nz

Stuff is experimental response from cron
by Tim Koop 09 Mar '17

09 Mar '17

I get emails from my Koha server with the subject: Cron <root@audio> koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/process_message_queue.pl And the body says things like: library: given is experimental at /usr/share/koha/lib/Koha/DateUtils.pm line 133. library: when is experimental at /usr/share/koha/lib/Koha/DateUtils.pm line 134. library: when is experimental at /usr/share/koha/lib/Koha/DateUtils.pm line 139. library: when is experimental at /usr/share/koha/lib/Koha/DateUtils.pm line 144. Is this bad? Can I ignore this? They are coming every few minutes. How can I turn this off? Thanks Tim Koop

2 1

Duplicated Emails
by Tim Koop 09 Mar '17

09 Mar '17

Some of our people are complaining about getting duplicated emails. Does anybody have any ideas how to diagnose or fix this? Koha had been working fine for a long time, then suddenly started duplicating emails. Actually, only some are duplicated, or even more than twice. Others are being sent just once like normal. Thanks. Tim Koop

2 1

[Koha US] Koha-US Conference CFP
by BRANNON, CHRISTOPHER 09 Mar '17

09 Mar '17

To All Koha Users, I would like to take the opportunity to repost the invitation to everyone to participate in this year's Koha-US Annual Conference: Koha-US is calling for proposals for conference talks/presentations, round table discussions, poster sessions, etc. for its 2017 annual conference held on August 9-12 in Coeur d'Alene, Idaho, USA. The theme for this year's conference is "Koha: You Can Do It" and is in the enabling attitude of Rosie the Riveter. We are seeking proposals for diverse audiences, from new Koha users, to the most advanced Koha software developers. Please check out the proposal submission form found at https://docs.google.com/forms/d/e/1FAIpQLSfoq_J7IHoTP-KhdGp3I-FYbi0L44BWMjT… for more details. If you are not sure what you could share at this conference, think about the things you wish someone would have told you about when you were struggling or maybe think of a lesson you "learned the hard way." Maybe you could share your experiences integrating Koha into a library program. The Koha community loves to share and presenting at the conference is a great way to do just that. I would like to encourage everyone to think about what has made Koha work for you and your library, school, consortium, or office and consider sharing that experience with us at this year's conference. The thing I enjoy most about the Koha-US Users Group and our annual conference is the connections that are made. It is the group's desire to provide everyone in the Koha community with the tools and resources needed, including mentors and connections to other users, and enable them to have great success with this incredible tool. What makes Koha great isn't the code that houses all our "stuff", but the people behind it; programmers, libraries, and staff. How many software products do you have in which all of these groups get together to talk about the program and how it works, and how we can make it better? Every library has a different experience. Every library has a different approach on how to serve their patrons. What adjustments have you made to make Koha work in your environment? What have you learned that other libraries and organizations might benefit from? What workflows have you developed to streamline your Koha use? What "extras" have you done through tweaking, paid enhancements, report writing, or 3rd party vendors to make Koha even better? We want to know. If you have ideas, please share them with us. Consider sending us a proposal. Or perhaps you might consider leading one of our round table discussions. We have many ways for everyone to participate. Even if you decide not to present or lead, let us know what you want from this conference, and we'll do everything we can to fill that need. You can let us know by using the link above. To find out more about the conference and this year's location, visit http://koha-us.net/index.php/2017_Koha-US_Conference. I look forward to seeing everyone again at this year's conference. It is because we have such a fantastic community that I know "You Can Do It!" Thank you, Christopher Brannon Vice President, Koha-US cbrannon(a)cdalibrary.org<mailto:cbrannon@cdalibrary.org>

1 0

Koha new version
by Luis Moises Rojas 09 Mar '17

09 Mar '17

Hello Which is the current version of koha? 16.11.xx or 16.05.xx? -- *Luis Moisés Rojas P.*

2 1

Re: [Koha] SQL Report: List of all authority records created
by vanda koha 09 Mar '17

09 Mar '17

Hi Jane and Stefano, Many thanks for your help! It is exactly what I was looking for ;). Best regards, Vanda 2017-03-09 2:29 GMT+00:00 Jane Cothron <jcothron(a)lincolncolibrarydist.org>: > Here's one that we got from ByWater: > select authid, datecreated, > ExtractValue( marcxml, '//datafield[@tag="100"]/*') AS Personal_Name, > ExtractValue( marcxml, '//datafield[@tag="110"]/*') AS Corporate_Name, > ExtractValue( marcxml, '//datafield[@tag="111"]/*') AS Conference_Name, > ExtractValue( marcxml, '//datafield[@tag="130"]/*') AS Uniform_Title > FROM auth_header > WHERE date(datecreated) BETWEEN <<Created BETWEEN (yyyy-mm-dd)>> AND <<and > (yyyy-mm-dd)>> ORDER by authid > > On Wed, Mar 8, 2017 at 6:17 AM, vanda koha <vandakoha(a)gmail.com> wrote: > >> Hi everybody, >> >> Does anyone know how to do a SQL Report in order to get a list of all the >> authority records we have already created in a period of time? And can we >> sort >> it by alphabetical order? >> >> Many thanks. >> >> Vanda >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > > > -- > Jane Cothron > Cataloger > Lincoln County Library District > P.O. Box 2027 > Newport, Oregon 97365 > 541-265-3066 <(541)%20265-3066> (phone & fax) > jcothron(a)lincolncolibrarydist.org >

1 0

Re: [Koha] SQL Report: List of all authority records created
by Stefano Bargioni 09 Mar '17

09 Mar '17

Hi, Vanda, look at https://wiki.koha-community.org/wiki/SQL_Reports_Library#Authorities_record… <https://wiki.koha-community.org/wiki/SQL_Reports_Library#Authorities_record…> or try this (from March 1 to now): SELECT `authid`, authtypecode, concat( ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), -- PERSO ExtractValue(`marcxml`,'//datafield[@tag="110"]/*'), -- CORPO ExtractValue(`marcxml`,'//datafield[@tag="111"]/*'), -- MEETI ExtractValue(`marcxml`,'//datafield[@tag="130"]/*'), -- UNIF ExtractValue(`marcxml`,'//datafield[@tag="150"]/*') -- TOPIC ) sort FROM `auth_header` WHERE datecreated BETWEEN '2017-03-01' AND NOW() ORDER BY `authtypecode`, sort Stefano > Hi everybody, > > Does anyone know how to do a SQL Report in order to get a list of all the > authority records we have already created in a period of time? And can we sort > it by alphabetical order? > > Many thanks. > > Vanda

1 0

SQL report - Date issues
by Kerrie Stevens 08 Mar '17

08 Mar '17

I have a report that picks out items that have no contents (505) added and also have no date entered. The problem is that the report is picking up materials that do have dates entered in both the 260 or 264 fields, so it is not working 100% correctly. Can anyone give me some pointers to get it working properly? SELECT biblioitems.biblionumber, biblio.copyrightdate, biblioitems.marcxml FROM biblioitems JOIN biblio ON biblioitems.biblionumber=biblio.biblionumber WHERE biblioitems.marcxml not like "%505%" and biblio.copyrightdate is null ORDER BY biblio.copyrightdate desc Results that come back includes bibs with date entries in the 260 and 264 fields - why would they be selected as having nothing in the date field, when they clearly do? Eg: both formats: '1958' or '[19--]' might appear in the fields Thanks for any help you may provide... Kerrie Stevens Harvest Bible College

2 2

SQL Report: List of all authority records created
by vanda koha 08 Mar '17

08 Mar '17

Hi everybody, Does anyone know how to do a SQL Report in order to get a list of all the authority records we have already created in a period of time? And can we sort it by alphabetical order? Many thanks. Vanda

1 0

Where can we find e-mail notices ready to be sent
by vanda koha 08 Mar '17

08 Mar '17

Hi everybody, I have properly set the circulation rules, the item circulation alerts, defined e-mail notices and set notice/status triggers for overdue items. But now I have a doubt: where can I find the list of all notices (specially overdue notices, but also renewals, holds ready to be picked up, etc) that are ready to be sent to our users? I know some users have overdues, but I don't know where to look for the notices. Can anyone help me, please? Many thanks, Vanda

2 2

Koha Development IRC Meeting reminder - March 8, 19 UTC
by Nick Clemens 08 Mar '17

08 Mar '17

HI All! Just a reminder that tomorrow at 19 UTC is the next Koha Developers IRC meeting. Conversion to local time here: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+I… The agenda is here: https://wiki.koha-community.org/wiki/Development_IRC_meeting_8_March_2017 Please add any items you wish to talk about to the wiki. I am at code4lib this week so will miss the meeting - I hope someone will volunteer to chair :-) -Nick

2 1