Common is more accurate. I would not batch delete based on ISBNs -- unless
there is a way to write the SQL script that would only retrieve only those
records with no items attached.



J. Elaine Hardy
PINES & Collaborative Projects Manager
Georgia Public Library Service/PINES
1800 Century Place, Ste. 150
Atlanta, GA 30045

404.235.7128 Office
404.548.4241 Cell
404.235.7201 FAX

On Thu, Jun 16, 2016 at 12:13 PM, Rogan Hamby <rha...@esilibrary.com> wrote:

> I would second what Elaine just said and go a bit further.  I'd say it's
> downright common.
>
> On Thu, Jun 16, 2016 at 12:11 PM, Elaine Hardy <
> eha...@georgialibraries.org> wrote:
>
>> ​Use extreme caution with a list from ISBNs. Some bib records for print
>> versions of the title may have ISBNs for the ebook. ​
>>
>>
>>
>> J. Elaine Hardy
>> PINES & Collaborative Projects Manager
>> Georgia Public Library Service/PINES
>> 1800 Century Place, Ste. 150
>> Atlanta, GA 30045
>>
>> 404.235.7128 Office
>> 404.548.4241 Cell
>> 404.235.7201 FAX
>>
>> On Thu, Jun 16, 2016 at 11:47 AM, Blake Henderson <
>> bl...@mobiusconsortium.org> wrote:
>>
>>> Chris,
>>>
>>> You will need to get a list of record ID's. Record buckets use record
>>> ID's.
>>>
>>> The easiest way to do that would be a SQL query.
>>>
>>> Something like this:
>>>
>>> select distinct record, isbn from
>>> (
>>> select record,regexp_replace(value,$$\D$$,$$$$,$$g$$) \"isbn\",value
>>> from metabib.real_full_rec where
>>> record in
>>> (
>>> select record from asset.call_number where
>>> not deleted and
>>> label=$$##URI##$$
>>> )
>>> )
>>> and
>>> tag=$$020$$
>>> and
>>> record not in(select id from biblio.record_entry where deleted)
>>> ) as a
>>> where length(isbn) in(10,13)
>>> and
>>> isbn in
>>> ( COMMA SEPARATED ISBN LIST )
>>> order by 1;
>>>
>>>
>>> The above query has a section "COMMA SEPARATED ISBN LIST"  where you
>>> will have to fill in your list like this:
>>>
>>> '4412349854',
>>> '2390340943',
>>> '2390340943345',
>>> ....
>>> ....
>>>
>>> This will return record id's that have scoped 856 URLs. If your records
>>> do not have scoped 856's, then you will need to remove this section of the
>>> query:
>>>
>>> record in
>>> (
>>> select record from asset.call_number where
>>> not deleted and
>>> label=$$##URI##$$
>>> )
>>> )
>>> and
>>>
>>>
>>> Once you have your record ID's, then you may as well delete them in SQL
>>> (make sure the list looks correct)
>>>
>>> Delete query:
>>>
>>> delete from biblio.record_entry where id in( LIST OF IDS );
>>>
>>>
>>>
>>> -Blake-
>>> Conducting Magic
>>> MOBIUS573-234-4513877-312-3517
>>>
>>> On 6/16/2016 10:17 AM, Chris Owens wrote:
>>>
>>> Is there an "easy" way to get a multiple records (50-75) into a record
>>> bucket from a list of ISBNs? We are going to have to start deleting eBook
>>> records from our system given a list of titles with ISBNs. And I am trying
>>> to avoid doing it record by record.
>>>
>>> I appreciate any advice.
>>>
>>> Thanks,
>>>
>>> Chris
>>>
>>> --
>>>
>>> Chris Owens
>>>
>>> Director
>>>
>>> Blanchester Public Library
>>>
>>> 110 N. Broadway
>>>
>>> Blanchester, OH 45107
>>>
>>> 937-783-3585
>>>
>>> 937-783-2910 (fax)
>>>
>>> <cow...@blanlibrary.org>cow...@blanlibrary.org
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>
>
> --
> --------------------------------------------------------------
> Rogan R. Hamby, Data and Project Analyst
> Equinox - Open Your Library
> ro...@esilibrary.com
> 1-877-OPEN-ILS | www.esilibrary.com
>
>

Reply via email to
https://www.mail-archive.com/open-ils-general@list.georgialibraries.org/msg12538.html
www.mail-archive.com
crawl=CC-MAIN-2019-51
13136
application/http; msgtype=response
sha1:MX3ECXTGJU5RUUKMAKFMJAYIU3VWEUVI
<urn:uuid:f8c6cad3-226b-4157-9401-f8a012fbe3bf>
2019-12-05T23:33:39Z
72.52.77.8
text/html
sha1:AIGSH6ZVLWO2TKCZ25I3ZR5OUXQ63LCR
<urn:uuid:f2baca0a-4491-4f36-a4d9-1ed98d94d3ca>
https://www.mail-archive.com/open-ils-general@list.georgialibraries.org/msg12538.html
response
<urn:uuid:d4f0d45e-484d-4169-aa01-4c759a7828e5>
isPartOf: CC-MAIN-2019-51
publisher: Common Crawl
description: Wide crawl of the web for December 2019
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-116.ec2.internal
software: Apache Nutch 1.16 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.1-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: http://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/