Thanks Jason, I was looking at that function this morning and was thinking, "I wonder if Jason already created a script for this... didn't he just release an update for the pingest.pl script in the last few months? I wonder what else is there?" I found your script for deleting copies from a csv file, and the one for deleting copies from a copy bucket. Thanks for the info and for sharing your code.
http://git.mvlcstaff.org/?p=jason/evergreen_utilities.git;a=blob;f=perl/copy_delete_from_csv.pl;hb=HEAD Josh Stompro - LARL IT Director -----Original Message----- From: Open-ils-general [mailto:[email protected]] 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 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 staff client since it seems to > have problems with that many records at once. The best way is to use Perl to communicate with the OpenSRF services and to use OpenILS::Application::Cat::AssetCommon->delete_copy With the proper options, it will delete empty call numbers and bibs for you as well as return a list of holds that need to be retargeted if any copies remain. -- 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.
