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
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
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
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
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
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
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
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
8 matches
Mail list logo