[OPEN-ILS-DEV] Reporting OCLC "Cancels"

[Thomas Berezansky]

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:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Elaine Hardy
Sent: Wednesday, May 11, 2016 08:49
To: Evergreen Development Discussion List <open-ils-dev at list.georgialibraries.org>
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 <blake at mobiusconsortium.org <mailto:blake at mobiusconsortium.org> > 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