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

[David Schuster]

Well turns out I think I had a bad backup and reload on the test server as
the number of biblio - is about 100,000 off even...  When I do the sql on
the production server I got 16481 urls which would be more like it.

If you are interested I put this up on the wiki for check-url.pl

http://wiki.koha.org/doku.php?id=en:development:check-url_enhancements&s[]=check&s[]=url&s[]=pl

I'm working with an in house programmer to make it a better utility...  He's
added information on where to place an output file so your cataloger can
pull it up and look at it - fdemians had a great idea on how to speed up the
URL check aspect of it, but need to install another dependancy to do that I
believe.  Still looking!  open for comments!

Magnus Enger wrote:
> 
> 2010/1/27 Wagner, Jane <jwagner at ptfs.com>:
>> 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.
> 
> Isn't that the mapping defined under Administration -> MARC-links
> (/cgi-bin/koha/admin/koha2marclinks.pl)? I think this mapping is
> respected even if records are imported with bulkmarcimport.pl. But
> perhaps there is some difference in which subfield is actually used
> and which field Koha expects to find the URLs in?
> 
>> Somebody had a neat trick on the IRC (chris_n?) for reading the actual
>> MARC fields out of the XML.  That might work better.
> 
> Could this be what you are thinking of?
> http://old.nabble.com/Re%3A-Koha3%2C-loading-locale-data%2C-contribs-and-%09funcionality-p27165605.html
> 
> Regards,
> Magnus
> libriotech.no
> 
>> -----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
> _______________________________________________
> 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-tp27329118p27340284.html
Sent from the Koha - Dev mailing list archive at Nabble.com.