[OPEN-ILS-GENERAL] Batch deleting records

[Elaine Hardy]

​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 <
blake at 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)
>
> <cowens at blanlibrary.org>cowens at blanlibrary.org
>
>
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160616/cec70e96/attachment.html>