[OPEN-ILS-GENERAL] Electronic title - search filter

[Blake Henderson]

Don,

This is a subject that I have recently put many hours into. This begs 
the question: "How many bibs do we have that should be flagged as 
electronic but do not have the proper MARC flags in the leader/06 and 
008/23?" We have been slowly developing methods of correcting the 
catalog. One example:

Bibs that contain 856  indicator2=0 but without the 008/23 correctly 
designated.

This query may help you identify those bibs

select id from biblio.record_entry where
id in (select record from metabib.real_full_rec where tag=$$856$$ and 
ind2=$$0$$) AND
marc ~ $$<leader>......[at]$$
and
marc !~ $$tag="008">.......................[oqs]$$
and
marc !~ $$tag="006">......[oqs]$$

This will result in a list of bib ID's that are not currently cataloged 
as Electronic but do contain an 856 with the "linking" indicators.

The mere presence of the 856 doesn't mean that the bib should be 
converted to Electronic but it's a good start. We added more logic to 
the decision making code but this query might get you started. Perhaps 
it can narrow your scope. We created an Evergreen conference proposal to 
go over our development.


-Blake-
Conducting Magic
MOBIUS
573-234-4513
877-312-3517

On 2/19/2015 12:25 PM, Donald Butterworth wrote:
> Hi Elaine,
>
> Kathy's information confirms my cataloging dilemma.
>
> Changing Form to "s" actually changes a print record into an 
> electronic record.  Technically I should add a whole new bib record 
> for the electronic version. (Lot o' work)
>
> Creating a copy/item record would be less work, and as Jennifer points 
> out you could then use the Circ Modifier as a filter. But that doesn't 
> fit into the default search filter options.
>
> There's always a problem when a cataloger gets "creative". I probably 
> should go ahead and just find a legitimate bib record for the titles 
> and be done.
>
> Oh well ...
>
> Don
>
> On Mon, Feb 16, 2015 at 8:31 AM, Hardy, Elaine 
> <ehardy at georgialibraries.org <mailto:ehardy at georgialibraries.org>> wrote:
>
>     Don,
>
>     As others have said, the search filter is for the MARC fixed field
>     Form (008/23). I don’t know if the 006/06 is also included in the
>     filter or if it can be added.
>
>     Are you adding an 856 to a record for another format rather than
>     using a MARC record for the e-resource?
>
>     /Elaine/
>
>     J. Elaine Hardy
>     PINES & Collaborative Projects Manager
>     Georgia Public Library Service
>     1800 Century Place, Ste 150
>     Atlanta, Ga. 30345-4304
>
>     404.235.7128 <tel:404.235.7128>
>     404.235.7201 <tel:404.235.7201>, fax
>     ehardy at georgialibraries.org <mailto:ehardy at georgialibraries.org>
>     www.georgialibraries.org <http://www.georgialibraries.org>
>     www.georgialibraries.org/pines <http://www.georgialibraries.org/pines>
>
>     *From:*Open-ils-general
>     [mailto:open-ils-general-bounces at list.georgialibraries.org
>     <mailto:open-ils-general-bounces at list.georgialibraries.org>] *On
>     Behalf Of *Donald Butterworth
>     *Sent:* Thursday, February 12, 2015 3:29 PM
>     *To:* Evergreen Discussion Group
>     *Subject:* [OPEN-ILS-GENERAL] Electronic title - search filter
>
>     All,
>
>     Simply adding an 856 tag to a MARC record does not make it
>     possible to do a search for the described electronic resource
>     using the Advanced Search Filter, "Item Form: Electronic". What
>     hook can be added to the bib record so that the Search Filter can
>     be used?
>
>     Thanks,
>
>     Don
>
>
>     -- 
>
>     Don Butterworth
>     Faculty Associate / Librarian III
>     B.L. Fisher Library
>     Asbury Theological Seminary
>     don.butterworth at asburyseminary.edu
>     <mailto:don.butterworth at asburyseminary.edu>
>     (859) 858-2227 <tel:%28859%29%20858-2227>
>
>
>
>
> -- 
> Don Butterworth
> Faculty Associate / Librarian III
> B.L. Fisher Library
> Asbury Theological Seminary
> don.butterworth at asburyseminary.edu 
> <mailto:don.butterworth at asburyseminary.edu>
> (859) 858-2227

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150219/f5449651/attachment-0001.html>