[Koha] Message from import of records

2013-10-15 Thread Tim Skeers
We are running version 3.10.09.000. In the summary table after an import, I had a line that was number of items ignored because of duplicate barcode: 1. Is there a way to see what the barcode is? Or for that matter, if it came back with ignored bib records, etc.? The reports library has a lot

[Koha] Looking to Query Indicators

2013-10-15 Thread Nicole Engard
Hi all, Anyone know if there is a way to query a marc field based on the indicator value. I have this report (which works): select b.title, b.author, ExtractValue(m.marcxml,'//datafield[@tag=521]/subfield[@code=a]') AS lexile from biblio b left join biblioitems m using (biblionumber) where

Re: [Koha] Looking to Query Indicators

2013-10-15 Thread Heather Braum (NEKLS)
Nicole, We have a report on our system that looks for 490 tags with the 1 indicator first. Here's the SQL statement: select b.biblionumber, b.title, b.author from biblio b join biblioitems i using (biblionumber) where i.marcxml like '%datafield tag=490 ind1=1%' Maybe work with that statement

Re: [Koha] Looking to Query Indicators

2013-10-15 Thread Robin Sheat
Nicole Engard schreef op di 15-10-2013 om 12:20 [-0500]: Anyone know if there is a way to query a marc field based on the indicator value. I have this report (which works): select b.title, b.author, ExtractValue(m.marcxml,'//datafield[@tag=521]/subfield[@code=a]') AS lexile from biblio b

[Koha] biblio records without items and location

2013-10-15 Thread schnydszch
Hi all! Is it possible especially with newer versions of Koha that bibliographic records that does not have accession nos./barcode can still have location data? This is for a union catalog that does not care on accession nos./barcode of books but only on the availability of certain titles. Thank