[Koha] Message from import of records
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 of item reports, but none that seemed to fit that exactly. Thanks, Tim Timothy Skeers | Cataloger | Iowa Library Services/State Library of Iowa | 1112 E. Grand Avenue | Des Moines, Iowa | 50319 | tim.ske...@lib.state.ia.us | (515) 725-0605 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Looking to Query Indicators
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 ExtractValue(m.marcxml,'//datafield[@tag=521]/subfield[@code=a]') between Lexile between and and But I want to only query 521s that have a 8# in the indicators. My report will find all of the below: 521 2# - TARGET AUDIENCE NOTE Target audience note 4-8. 521 0# - TARGET AUDIENCE NOTE Target audience note 8.8. 521 8# - TARGET AUDIENCE NOTE Target audience note 1150 But I only want the last one. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Looking to Query Indicators
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 idea, and see what that gets you? (I'm on a flight to Kohacon, and don't want to try waiting on querying our database too much on slower wifi). Good luck! Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbr...@nekls.org The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn. ~Alvin Toffler, *Rethinking the Future* On Tue, Oct 15, 2013 at 12:20 PM, Nicole Engard neng...@gmail.com wrote: 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 ExtractValue(m.marcxml,'//datafield[@tag=521]/subfield[@code=a]') between Lexile between and and But I want to only query 521s that have a 8# in the indicators. My report will find all of the below: 521 2# - TARGET AUDIENCE NOTE Target audience note 4-8. 521 0# - TARGET AUDIENCE NOTE Target audience note 8.8. 521 8# - TARGET AUDIENCE NOTE Target audience note 1150 But I only want the last one. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Looking to Query Indicators
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 left join biblioitems m using (biblionumber) where ExtractValue(m.marcxml,'//datafield[@tag=521]/subfield[@code=a]') between Lexile between and and But I want to only query 521s that have a 8# in the indicators. My report will find all of the below: The language that ExtractValue uses is called 'xpath', and it's a way of describing paths into XML. You should make your datafield request qualified with the extra things you need. For example, a MARCXML field looks like: datafield tag=100 ind1=1 ind2= subfield code=aGravelle, Karen./subfield /datafield so the attributes you care about are 'tag' (which you already have), ind1, and ind2. Xpath lets you and/or things together, so you could use something like: //datafield[@tag=521 and @ind1=8 and @ind2= ]/subfield... More reference here: http://www.w3schools.com/xpath/default.asp but I checked the syntax of this particular answer here: http://stackoverflow.com/questions/6029232/xpath-select-multiple-attr mostly because I knew what to search for :) I haven't tested this solution, btw, but it should work. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] biblio records without items and location
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 you in advance! -- View this message in context: http://koha.1045719.n5.nabble.com/biblio-records-without-items-and-location-tp5774535.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
