Re: [Koha] SQL report - Date issues

2017-03-08 Thread ramirouvia .
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, '//datafield

Re: [Koha] El ExtractValue y MarcXML

2017-09-11 Thread ramirouvia .
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: > > substring(ExtractValue(marcxml,'//controlfield[@tag="008"]'), 8,4 ) AS > 'PUB DATE

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

2014-05-21 Thread ramirouvia .
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. Gre

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

2014-07-22 Thread ramirouvia .
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 GMT-03

Re: [Koha] OAI-PMH file information

2014-07-22 Thread ramirouvia .
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 : > > > What is the server address? > > > > T

Re: [Koha] Cataloging questions

2014-07-23 Thread ramirouvia .
Hi Steve: I am not sure if this will help you, but just in case... http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=ListRecords&metadataPrefix=oai_dc http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=GetRecord&identifier=SANDBOX:1&metadataPrefix=oai_dc http://koha.andrews.edu/cgi-bin/koha/oai.pl?ve

Re: [Koha] Report help

2014-07-23 Thread ramirouvia .
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] Koha 3.18 adding T-Prefix to all scanned barcodes

2015-02-11 Thread ramirouvia .
Todd: Did you check "itemBarcodeInputFilter" preference? Hope it helps, Ramiro 2015-02-11 12:23 GMT-03:00 bowmanrt : > 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 filter > which removes the T-p