Re: [OPEN-ILS-GENERAL] Batch deleting records

: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Thursday, June 16, 2016 4:10 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Batch deleting records On 06/16/2016 05:04 PM, Josh Stompro wrote: > While we are on

Re: [OPEN-ILS-GENERAL] Batch deleting records

On 06/16/2016 05:04 PM, Josh Stompro wrote: While we are on this subject. What is the proper way to delete items, then volumes/call number, bibs via sql? I’m looking at deleting ~3000 withdrawn copies after we grab the ones that are last copies to tell OCLC about. I would rather not use the

Re: [OPEN-ILS-GENERAL] Batch deleting records

: Re: [OPEN-ILS-GENERAL] Batch deleting records Thank you all for your advice and words of caution. I would say this is yet another reason to prefer the old-fashioned book, but I wouldn't want to sound like a luddite. We will tread lightly. Chris Chris Owens Director Blanchester Public Library

Re: [OPEN-ILS-GENERAL] Batch deleting records

Title: Sincerely, Thank you all for your advice and words of caution. I would say this is yet another reason to prefer the old-fashioned book, but I wouldn't want to sound like a luddite. We will tread lightly. Chris

Re: [OPEN-ILS-GENERAL] Batch deleting records

You absolutely could have sql only generate lists based on bibs with no copies. There are a handful of caveats though all depending on their setups and workflows. It's the sort of thing that unless the person writing the script knows the cataloging workflows and issues and can anticipate the

Re: [OPEN-ILS-GENERAL] Batch deleting records

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,

Re: [OPEN-ILS-GENERAL] Batch deleting records

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 < jstephen...@mvlcstaff.org> wrote: > This is where using a separate bib source for ebook records comes in very > handy. You can limit

Re: [OPEN-ILS-GENERAL] Batch deleting records

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

Re: [OPEN-ILS-GENERAL] Batch deleting records

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

Re: [OPEN-ILS-GENERAL] Batch deleting records

​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

Re: [OPEN-ILS-GENERAL] Batch deleting records

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