[OPEN-ILS-GENERAL] Notification is library is last owning on a held item? OCLC Last Copy/Withdraws
Hardy, Elaine
ehardy at georgialibraries.org
Mon Jan 4 10:24:27 EST 2016
Josh,
You can use pivot tables with existing functionality in Evergreen and
MSExcel reports to sort out the last copies deleted. Instructions for how
PINES libraries handle identifying holdings to be deleted, including the
pivot table instructions are at
http://pines.georgialibraries.org/sites/default/files/files/Deleting%20hol
dings%20In%20OCLC.pdf
Elaine
J. Elaine Hardy
PINES & Collaborative Projects Manager
Georgia Public Library Service
1800 Century Place, Ste 150
Atlanta, Ga. 30345-4304
404.235.7128
404.235.7201, fax
ehardy at georgialibraries.org
www.georgialibraries.org
www.georgialibraries.org/pines
From: Open-ils-general
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Josh Stompro
Sent: Friday, December 18, 2015 11:15 AM
To: Evergreen Discussion Group
<open-ils-general at list.georgialibraries.org>
Subject: Re: [OPEN-ILS-GENERAL] Notification is library is last owning on
a held item? OCLC Last Copy/Withdraws
I've been looking into how to handle OCLC last copies for our consortium
this week and I just wanted to run in by the group. Please let me know if
there is a better/easier way to handle this that you have found. Or if
there are any gotchas that you know of.
I searched the general list to find out what others are doing and didn't
see that there was a great built in way to do it with the reporter. So I
attempted to do it with a sql query.
There is a "Last Copy Delete Time" data source that that doesn't seem to
take the copy location into account, it works off of the bib being
deleted.
I'm wondering if this could be setup as a reporter data source to make it
easier to access. After looking at the "Hold per copy ratio by pickup and
descendants" data source that Galen just added it looks like it should be
possible.
The query selects all bib records that have one or more copies with a
discard/weed status and gives a count of the number of copies that have
that status, along with a count of all other copies on that bib that have
a status other than weed/discard. If there are no other copies then you
have removed the last copy. It scopes the search to an org unit and all
of its descendants, so it can be used for one branch, or for a system.
This method does require that you change the status of all copies you want
to get rid of to withdrawn/weed before deleting them. So your workflow
for getting rid of lost/damaged/missing/long overdue may need to be
adjusted. Or the query could look for more status types to consider
deleted and not deleted. I'm not sure what the best way to handle that
would be.
I also wasn't sure about the subqueries, if I needed to use different
table aliases than what is used in the main query, so that may be
unnecessary.
In the following query you would need to change the org unit id "101" in
the actor.org_unit_descendants to your org unit you want to scope to. And
I don't know if the asset.copy.status id numbers are uniform, so check to
make sure that 13 = your withdrawn/weed status.
SELECT bre.id,
bre.tcn_value,
Xpath('n:datafield[@tag=035]/n:subfield[@code="a"]/text()',
bre.marc :: xml, '{{n,http://www.loc.gov/MARC21/slim}}'),
Count(ac.id)
AS
withdrawn_count,
(SELECT Count(ac1.id)
FROM asset.copy ac1
JOIN asset.call_number acn1
ON ( ac1.call_number = acn1.id )
WHERE acn1.record = bre.id
AND ac1.status != 13
AND ac1.circ_lib IN (SELECT id
FROM
actor.org_unit_descendants(101))) AS
other_copies
FROM biblio.record_entry bre
JOIN asset.call_number acn
ON ( bre.id = acn.record )
JOIN asset.copy ac
ON ( acn.id = ac.call_number )
WHERE ac.status = 13
AND ac.circ_lib IN (SELECT id
FROM actor.org_unit_descendants(101))
AND (SELECT Count(ac1.id)
FROM asset.copy ac1
JOIN asset.call_number acn1
ON ( ac1.call_number = acn1.id )
WHERE acn1.record = bre.id
AND ac1.status != 13
AND ac1.circ_lib IN (SELECT id
FROM
actor.org_unit_descendants(101))) = 0
GROUP BY bre.id;
Josh Stompro - LARL IT Director
From: open-ils-general-bounces at list.georgialibraries.org
<mailto:open-ils-general-bounces at list.georgialibraries.org>
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Hardy, Elaine
Sent: Wednesday, April 02, 2014 2:19 PM
To: 'Evergreen Discussion Group'
Subject: Re: [OPEN-ILS-GENERAL] Notification is library is last owning on
a held item?
PINES would like this feature to identify when the last copy held by a
system (not a branch) is deleted from the bib record for removing OCLC
holdings as well.
Elaine
J. Elaine Hardy
PINES & Collaborative Projects Manager
Georgia Public Library Service
1800 Century Place, Ste 150
Atlanta, Ga. 30345-4304
404.235-7128
404.235-7201, fax
ehardy at georgialibraries.org <mailto:ehardy at georgialibraries.org>
www.georgialibraries.org <http://www.georgialibraries.org>
www.georgialibraries.org/pines <http://www.georgialibraries.org/pines>
From: open-ils-general-bounces at list.georgialibraries.org
<mailto:open-ils-general-bounces at list.georgialibraries.org>
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Elisabeth Keppler
Sent: Wednesday, April 02, 2014 8:06 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Notification is library is last owning on
a held item?
We'd also like to be able to identify when our own library's last copy is
being discarded or deleted so we can remove our OCLC holdings. We're on
2.4.3, if that makes a difference, and would welcome any suggestions.
I can report holds for which there is no holdable copy (which we call
"hopeless holds") if that would help you, Buzzy. Using the Hold/Copy
Ratio per Bib report source, here are the filters and displays:
We use the results to generate emails or postcards to patrons letting them
know that we're unable to fill their hold. For materials older than a
year, we include instructions on how to request ILL. The example above
filters on just our holdings rather than the entire consortium's, but
leaving off the Owning Library Name filter would fix that.
Hope that helps,
Lise Keppler
Forsyth County NC
On Tue, Apr 1, 2014 at 9:10 PM, Buzzy Nielsen <buzzy at hoodriverlibrary.org
<mailto:buzzy at hoodriverlibrary.org> > wrote:
Hi folks,
Does anyone know, is there a feature in Evergreen, whether currently in
place or in development, that would notify a library is it's the last
owning library that carries a particular held item? We have a large
consortium, 70+ libraries, and patrons can place holds on pretty much any
member library's items. It would be really helpful if there could be some
sort of alert if a library's that's the last holding one marks a held item
missing. That way, the patron's home library could notify him/her that
they're unable to get the item through the consortium.
I hope that my question makes sense!
Cheers!
Buzzy
************************************
Library Director
Hood River County Library District
502 State Street
Hood River, Oregon 97031
541-387-7062 <tel:541-387-7062>
http://hoodriverlibrary.org
--
Lise Keppler
Forsyth County Public Library
660 W 5th St
Winston Salem NC 27101
336-703-3070
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160104/63ed7a94/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 40322 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160104/63ed7a94/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 21789 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160104/63ed7a94/attachment-0003.png>
More information about the Open-ils-general
mailing list