At MVLC I wrote scripts to handle a lot of this. I believe this covers what I have done:
http://pastebin.com/UPtzNTw7 Thomas Berezansky Assistant Network Administrator Merrimack Valley Library Consortium 4 High ST, Suite 175 North Andover, MA 01845 Phone: 978-557-8161 -----Original Message----- From: Open-ils-dev [mailto:[email protected]] On Behalf Of Elaine Hardy Sent: Wednesday, May 11, 2016 08:49 To: Evergreen Development Discussion List <[email protected]> Subject: Re: [OPEN-ILS-DEV] Reporting OCLC "Cancels" There is no easy way to find the last copy in a consortium setting in order to delete holdings in OCLC. Our instructions for deleting holdings in OCLC for PINES catalogers are at http://pines.georgialibraries.org/cataloging-deletingholdings. While PINES specific, there are instructions for using a report with pivot tables in MSExcel which might be useful for your member libraries. In order to use the report, copies/items to be deleted must be set to discard/weed status. While it adds an extra step, catalogers that use it when they are deleting large numbers of copies prefer it to the other methods. The instructions for the report begin on page 3. Elaine J. Elaine Hardy PINES & Collaborative Projects Manager Georgia Public Library Service/PINES 1800 Century Place, Ste. 150 Atlanta, GA 30045 404.235.7128 Office 404.548.4241 Cell 404.235.7201 FAX On Tue, May 10, 2016 at 6:07 PM, Blake Henderson <[email protected] <mailto:[email protected]> > wrote: All, This can't be a new problem. I am trying to create a report that will show me all of the bibs where the "last" copy for a given group of library branches was deleted. This is a standard "cancels file" for conveying the deleted holdings to places like OCLC. How is everyone doing this? I can do it in SQL easily but I want our members to be able to run the report for their custom time period for their custom branches on the fly. I don't want to run it manually. Perhaps a view? -- -Blake- Conducting Magic MOBIUS
