- Koha - lists.katipo.co.nz

[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

Koha Report Library problem
by Przemek Kosiński 08 Mar '17

08 Mar '17

Hi. I noticed that on the website Koha reports (https://wiki.koha-community.org/wiki/SQL_Reports_Library) gone wrong formatting SQL reports. All reports now look like this: ---- SELECT biblio.title, biblio.author, issues ---- Any chance to correct this? Best regards, Przemek Kosinski -- ************************************************* Powiatowa i Miejska Biblioteka Publiczna w Skarżysku-Kamiennej www: www.biblioteka24.eu mail: p.kosinski(a)biblioteka24.eu *************************************************

2 1

Courtesey reminder: tomorrow is Koha-US March meeting
by Christopher Davis 07 Mar '17

07 Mar '17

Hello Colleagues, I would like to invite you to the March 2017 meeting of Koha-US held at 10:30 am Central Time at https://kslib.zoom.us/j/450230564. The agenda for this meeting is found at http://koha-us.net/index.php/Minutes2017-03-08; if you would like to add an item to this agenda, then please email your idea to me at the email address provided below. Since this is a web meeting, it is suggested that you use a microphone and webcam. I hope to see you at this meeting. Cordially, Christopher Davis Secretary, Koha-US cgdavis(a)uintah.utah.gov

1 0