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] > 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 > >
