- Koha - lists.katipo.co.nz

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

Can't access my newly installed koha
by Javed Sahil 07 Mar '17

07 Mar '17

---------- Forwarded message ---------- From: "Javed Sahil" <sahil.ke.paas(a)gmail.com> Date: Mar 2, 2017 2:55 PM Subject: Can't access my newly installed koha To: <koha(a)lists.ktipo.co.nz> Cc: Hello Seniors, > I am new to koha, I installed Unbuntu Server 16.04 LTS and then Koha, as > instructed on koha website. But when i try to access my koha on another > machine, it says: (Screenshot Attached). > System Maintenance > > The Koha online catalog is offline for system maintenance. We'll be back > soon! If you have any questions, please contact the site administrator > > I need your help plz. >

2 1