[Koha-devel] SQL for 856 tag in marc record

[Wagner, Jane]

Difference between the biblioitems.url field and the actual MARC 856 (in the xml)?  I don't know what makes biblioitems.url get populated, but I suspect if you load data in bulk (outside the Tools import) it doesn't happen.

Somebody had a neat trick on the IRC (chris_n?) for reading the actual MARC fields out of the XML.  That might work better.

Jane Wagner
Library Systems Analyst
PTFS Inc.
Content Management and Library Solutions
6400 Goldsboro Road, Suite 200
Bethesda, MD  20817
(301) 654-8088 x 151
jwagner at ptfs.com


-----Original Message-----
From: koha-devel-bounces at lists.koha.org [mailto:koha-devel-bounces at lists.koha.org] On Behalf Of David Schuster
Sent: Wednesday, January 27, 2010 8:32 AM
To: koha-devel at lists.koha.org
Subject: Re: [Koha-devel] SQL for 856 tag in marc record


Well I'm getting closer, but that only provided me with a response of 40 and
I know I have well over 3000 urls in records.

Wonder why the rest didn't populate?  They show up in the catalog...

David Schuster

Frederic Demians wrote:
> 
> 
>> Anyone have a suggestion on how to get at least a count of these 856's 
>> in the
>> MARC record in my database?
> 
> SELECT COUNT(url) FROM biblioitems;
> 
> will give you the number of biblio records having at least one 856. A 
> biblio record with several 856 tags will be count as 1 url.
> 
> If you want something more efficient, you could try to add an index 
> named 'url' to your zebra configuration pointing to 856$t (and even 
> other MARC subfields containing URLs). Then re-index. This PQF search 
> will return exactly all records having something in 'url' field:
> 
>   @attr 1=url @attr 2=103 ""
> 
> But same problem than with MySQL alternative. Maybe a zebra scan command 
> could help. Don't know how exactly.
> 
> --
> Frédéric
> 
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel
> 
> 

-- 
View this message in context: http://old.nabble.com/SQL-for-856-tag-in-marc-record-tp27329118p27339116.html
Sent from the Koha - Dev mailing list archive at Nabble.com.

_______________________________________________
Koha-devel mailing list
Koha-devel at lists.koha.org
http://lists.koha.org/mailman/listinfo/koha-devel