- Koha - lists.katipo.co.nz

Report help needed
by Elaine Bradtke 16 Jul '18

16 Jul '18

This report finds Authors not linked to authorities. But it only lists their names (some of them are quite prolific, and sometimes it's only one biblio that needs checking). How can I make the following give the biblio number as well as the name? SELECT DISTINCT heading FROM ( SELECT ExtractValue(metadata, '//datafield[@tag="100"]/subfield[@code="a"]') AS heading FROM biblio_metadata WHERE length(ExtractValue(metadata, '//datafield[@tag="100"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(metadata, '//datafield[@tag="100"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(metadata, '//datafield[@tag="110"]/subfield[@code="a"]') AS heading FROM biblio_metadata WHERE length(ExtractValue(metadata, '//datafield[@tag="110"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(metadata, '//datafield[@tag="110"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(metadata, '//datafield[@tag="111"]/subfield[@code="a"]') AS heading FROM biblio_metadata WHERE length(ExtractValue(metadata, '//datafield[@tag="111"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(metadata, '//datafield[@tag="111"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(metadata, '//datafield[@tag="130"]/subfield[@code="a"]') AS heading FROM biblio_metadata WHERE length(ExtractValue(metadata, '//datafield[@tag="130"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(metadata, '//datafield[@tag="130"]/subfield[@code="9"]')) = 0 ) AS heads ORDER BY heading Thanks in advance! Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

2 2

Fwd: [Koha-devel] Sparql and koha opac (wikidata and bnf to try things)
by Claire Hernandez 16 Jul '18

16 Jul '18

Hello, I sent this mail to koha-devel and I would like to know if you think "something" about that :) https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21074 (screenshots inside) Regards, Claire. -------- Message transféré -------- Sujet : [Koha-devel] Sparql and koha opac (wikidata and bnf to try things) Date : Fri, 13 Jul 2018 16:09:41 +0200 De : Claire Hernandez <claire.hernandez(a)biblibre.com> Pour : Koha-devel(a)lists.koha-community.org Hi, I wanted to try and learn about semantic web and sparql. So I give it a try in a opac-detail view. This patch is just a poc and really not for production. I wanted to know if this type of work is relevant to you. I know in community previous work was done but maybe you can share where you are now with linked data ? Just 2 words about the dev : * Simple syspref called "Explore", 3 possibilities: nothing, Bnf (national library in france) and Wikidata * Some datas are fetched, I suppose I have an ark in my biblio * I display "simple information", there is no complicated query Possibles "next" : * Not one source (bnf or wikidata), but cross fetch between sources (ex: bnf + wikidata + europeana + geonames + whatever ;) * Having a "local triple store" or not doing real time to have information display quicker * More complicated queries to display timeline for date or exploring period, exploring "notable work" or "author collaborated with" etc. The dev is probably not as clean as you wish, and I prefer to share something to talk about - even not perfect - than nothing. I plan to write a blog post about what I learn. Tell me if you are interested, it could encourage me to do it :p Claire.

1 0

Please unsubscribe me
by Sissie DJernes 15 Jul '18

15 Jul '18

I would very much like to be unsubscribed from the Koha list for librarians. I was interested more in becoming an end user of the database, as a researcher. I do not want to work with setting up a library system. Thanks, Lucille D'Jernes

2 1

Batch restriction of patrons?
by Cab Vinton 15 Jul '18

15 Jul '18

Hi, All -- We've used the noissuescharge setting in the Circulation preferences to prevent patrons from checking items out when their fines exceed a certain amount. However, since most of our fines are relatively modest, it may take several months to reach the noissuescharge cap if a patron only has 1 or 2 items checked out. There doesn't appear to be a similar setting for blocking patrons when a particular item becomes long overdue. We can go into each patron's account & add a manual restriction, but we generally have several patrons needing this change in status. Unfortunately, it doesn't look like the Batch Patron Modification tool can be used to set patrons' debarred status (though we can set a new expiration date for their cards). I believe the Patron Import tool might be an option, but that seems too convoluted. Am I missing something? Many thanks in advance, Cab Vinton, Director Plaistow Public Library Plaistow Public Library

4 7

Moving books covers to the left
by drojup 14 Jul '18

14 Jul '18

Hi, I would like to ask if it's possible to move the books covers to the left (in the records results). Thank you. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 2

Call for News: July 2018 Newsletter
by kohanews 14 Jul '18

14 Jul '18

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. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

adding field to Marc Framework
by takan bhatt 13 Jul '18

13 Jul '18

Sirs / Madam I am currently using Koha 18.0x. In my own Marc Framework, I deleted field 700. Now I want to add this to existing frame work. I am not able to do. kindly help me Rajesh Bhatt

3 2

Chrome vs. Firefox in recent versions of Koha / Firefox
by Nick Clemens 13 Jul '18

13 Jul '18

Hi All, I was testing today in different browsers and noted that Chrome seems to be loading much faster than Firefox. In looking at the logs, I see that Chrome makes about 3 requests per page, while Firefox is making 20+ calls, mostly for .css and .js files. It seems that Firefox has changed it's caching strategy and more files are being reloaded. Has anyone else noticed this or tested using Chrome? -Nick -- Nick Clemens Sonic Screwdriver (Development Support) ByWater Solutions IRC: kidclamp

7 7

Koha authentication in cascade
by Hugo Agud 13 Jul '18

13 Jul '18

Good morning I have a doubt regarding Koha and Active Directory, If I am not wrong If a user is not in LDAP checks also the koha user's database right? Kindest Regards Hugo -- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* <http://www.orex.es/> [image: www.orex.es/koha] <http://www.orex.es/koha> [image: www.orex.es/vufind] <http://www.orex.es/vufind> Director Avda Josep Tarradelles, 134 (Centro de Negocios Infanta) 08029 - Barcelona - Tel: 933 856 138 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

Koha Notifications - Whatsapp Messaging instead of SMS Service
by Dr. Sandeep Bhavsar 12 Jul '18

12 Jul '18

Dear All Can we send Koha notifications (Circulatons/fine) on users whatsapp instead of SMS service. -- Warm Regards Dr. Sandeep Bhavsar Librarian *Prin. L. N. Welingkar Institute of Management Development & Research (AUTONOMOUS)* L Napoo Road | Matunga (CR) | Mumbai- 400 019. Tel: 022-2419 8377 | Mob: 9870 18 9999 Library Portal*: http://elearn.welingkar.org/infowe <http://elearn.welingkar.org/infowe>*

2 1