Re: [Koha] El ExtractValue y MarcXML

Hi: Check this new table: http://schema.koha-community.org/17_05/tables/biblio_metadata.html There has been some changes for 17.05. Good luck, Ramiro 2017-09-11 14:23 GMT-03:00 Ian Bays : > Hi. > This works: > >

Re: [Koha] SQL report - Date issues

Try this: SELECT biblioitems.biblionumber, biblio.copyrightdate, biblioitems.marcxml FROM biblioitems JOIN biblio ON biblioitems.biblionumber=biblio.biblionumber WHERE ExtractValue( marcxml, '//datafield[@tag="505"]/*' ) = "" and biblio.copyrightdate is null and ExtractValue( marcxml,

Re: [Koha] Koha 3.18 adding T-Prefix to all scanned barcodes

Todd: Did you check itemBarcodeInputFilter preference? Hope it helps, Ramiro 2015-02-11 12:23 GMT-03:00 bowmanrt bowma...@lancastermennonite.org: We have a library system which we migrated from Follett years ago. We left all of the old barcodes with the T-prefix, and use the barcode input

Re: [Koha] Report help

Elaine: I think you should use 008 date: SELECT CASE SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag=008]'),8,2) WHEN '19' THEN 'XX' WHEN '20' THEN 'XXI' WHEN '18' THEN 'XVIII' WHEN '17' THEN 'XVII' ElSE 'OLDER' END AS bibtype, count(DISTINCT biblionumber) AS

Re: [Koha] How to make researchable only records with phisical items?

Another way would be to set up Opac Suppression: http://manual.koha-community.org/3.8/en/administration.html (1.4.1.6. OpacSuppression) http://projects.palaso.org/projects/koha/wiki/Configure This way you have to manually select which records won't index. Regards, Ramiro 2014-07-22 12:19

Re: [Koha] OAI-PMH file information

Maybe using: http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=Identify Though I can't get this to work on that server either, check if the preference: OAI-PMH is enabled in your instance. Ramiro Uviña 2014-07-22 17:24 GMT-03:00 Eric Lease Morgan eric_mor...@infomotions.com: What is the

Re: [Koha] how many biblio was modified by each staff

Hi: Try this: SELECT user AS 'user',count(user) AS 'items added' FROM action_logs WHERE module='CATALOGUING' AND info like 'BEFORE%' AND action='MODIFY' GROUP BY user; I am not sure if the string BEFORE is always for bibs, but so it seems. Maybe you can do something alike from logs, too.