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
< <>> 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
    < <>> wrote:


        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
        record not in(select id from biblio.record_entry where deleted)
        ) as a
        where length(isbn) in(10,13)
        isbn in
        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>',

        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

        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 );

        Conducting Magic
        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

        I appreciate any advice.




        Chris Owens____


        Blanchester Public Library____

        110 N. Broadway____

        Blanchester, OH 45107____

        937-783-3585 <tel:937-783-3585>____

        937-783-2910 <tel:937-783-2910> (fax)____


        __ __

        __ __

Rogan R. Hamby, Data and Project Analyst
Equinox - Open Your Library <>
1-877-OPEN-ILS | <>

Jason Stephenson
Assistant Director for Technology Services
Merrimack Valley Library Consortium
4 High ST, Suite 175
North Andover, MA 01845
Phone: 978-557-5891

Please note my new email address.

Reply via email to