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

[Garry Collum]

It would be nice to have the ability to check a range of bib numbers,
or just the option to start at a specific bib number.  (--beginbib
10000 --endbib 11000).

Especially for checking new records that are imported into the system.

Garry

On Wed, Jan 27, 2010 at 9:28 AM, David Schuster <dschust1 at tx.rr.com> wrote:
>
> 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.
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel