Good morning Blake, I posted about this on the general list back in December. Pretty much your same question. Elaine responded that they use Excel processing to get the last copy and shared the PINES instructions. http://markmail.org/message/7snzryvgdw7kvccb http://markmail.org/message/lyfeydkl7qi4kylr
At that time Thomas posted a link via IRC to his oclc number monitoring code also. http://irc.evergreen-ils.org/evergreen/2015-12-18#i_220459 http://pastebin.com/UPtzNTw7 I would love this to be included in the reporter as a data source. I think I see how to do it but I haven’t had a chance to try to add it to the field mapper. If you want to try going down that route I would be happy to help. So far we have been using the sql I posted in my first message to get the list of last copies for each of our systems, since we each report our holding to OCLC separately. Josh Stompro - LARL IT Director From: Open-ils-dev [mailto:[email protected]] On Behalf Of Blake Henderson Sent: Tuesday, May 10, 2016 5:08 PM To: Evergreen Development Discussion List Subject: [OPEN-ILS-DEV] Reporting OCLC "Cancels" 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
