[OPEN-ILS-GENERAL] Batch deleting records

[Rogan Hamby]

I will agree with that as well.  Just make sure to set it can_have_copies =
FALSE or copies will end up on it.

On Thu, Jun 16, 2016 at 12:35 PM, Jason Stephenson <
jstephenson at mvlcstaff.org> wrote:

> This is where using a separate bib source for ebook records comes in very
> handy. You can limit the SQL query to just records on that source with a
> little modification.
>
> We create a new source for every new source of ebook records here. That
> way, it is easy to update or to delete them all at once.
>
> I know that may not help you right now, but it is a good idea for the
> future.
>
>
>
> On 06/16/2016 12:13 PM, Rogan Hamby 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
>> <ehardy at georgialibraries.org <mailto:ehardy at 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 <tel:404.235.7128> Office
>>     404.548.4241 <tel:404.548.4241> Cell
>>     404.235.7201 <tel:404.235.7201> FAX
>>
>>     On Thu, Jun 16, 2016 at 11:47 AM, Blake Henderson
>>     <blake at mobiusconsortium.org <mailto: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 <tel: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
>>         MOBIUS
>>         573-234-4513 <tel:573-234-4513>
>>         877-312-3517 <tel:877-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 <tel:937-783-3585>____
>>>
>>>         937-783-2910 <tel:937-783-2910> (fax)____
>>>
>>>         <mailto:cowens at blanlibrary.org>cowens at blanlibrary.org
>>>         <mailto:cowens at blanlibrary.org>____
>>>
>>>         __ __
>>>
>>>         __ __
>>>
>>>
>>
>>
>>
>>
>> --
>> --------------------------------------------------------------
>> Rogan R. Hamby, Data and Project Analyst
>> Equinox - Open Your Library
>> rogan at esilibrary.com <mailto:rogan at esilibrary.com>
>> 1-877-OPEN-ILS | www.esilibrary.com <http://www.esilibrary.com>
>>
>>
> --
> Jason Stephenson
> Assistant Director for Technology Services
> Merrimack Valley Library Consortium
> 4 High ST, Suite 175
> North Andover, MA 01845
> Phone: 978-557-5891
> Email: jstephenson at mvlcstaff.org
>
> Please note my new email address.
>



-- 
--------------------------------------------------------------
Rogan R. Hamby, Data and Project Analyst
Equinox - Open Your Library
rogan at esilibrary.com
1-877-OPEN-ILS | www.esilibrary.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160616/cad2af8b/attachment.html>