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 < [email protected]> 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 >> <[email protected] <mailto:[email protected]>> 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 >> <[email protected] <mailto:[email protected]>> >> 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:[email protected]>[email protected] >>> <mailto:[email protected]>____ >>> >>> __ __ >>> >>> __ __ >>> >>> >> >> >> >> >> -- >> -------------------------------------------------------------- >> Rogan R. Hamby, Data and Project Analyst >> Equinox - Open Your Library >> [email protected] <mailto:[email protected]> >> 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: [email protected] > > Please note my new email address. > -- -------------------------------------------------------------- Rogan R. Hamby, Data and Project Analyst Equinox - Open Your Library [email protected] 1-877-OPEN-ILS | www.esilibrary.com
