<div dir="ltr">Our consortium also relies on each individual library to keep their own holdings current if they so wish. Since OCLC numbers are unfortunately used inconsistently in our catalog, we have a more manual way of doing things. Using a data sync collection set up through OCLC, we submit one file for added holdings and one file of deleted holdings. We get these using a report in Evergreen and then isolate the TCNs. OCLC requires the files be in a certain format and named a very specific way with this workflow, but it works well for us. I may look into some of the more automated processes I've seen in this thread, though!<div><br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><img src="https://ci3.googleusercontent.com/mail-sig/AIorK4y44qSWrBhGjKs9a3JDgm3D0kulOrUMrSYxOtB-3WrXdtE67SX9fTIBchZv3QMgrB-59UFJ71M"><br></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 9, 2023 at 7:48 AM Katie Greenleaf Martin via Evergreen-general <<a href="mailto:evergreen-general@list.evergreen-ils.org">evergreen-general@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-8525352215512796809">
<div lang="EN-US" style="overflow-wrap: break-word;">
<div class="m_-8525352215512796809WordSection1">
<p class="MsoNormal">At SPARK, it’s largely up to the libraries to do their own maintenance, and since we just added Real Time Availability for several WorldShare clients we’ve been trying to streamline things a little more.
<u></u><u></u></p>
<p class="MsoNormal">We have report templates that give libraries a list of 035s for volumes added or removed and then they can upload that into Connexion. For libraries that have WorldShare but not Connexion we’re working with them to work with OCLC to use
Streamline Holdings on a schedule to update their holdings. <u></u><u></u></p>
<p class="MsoNormal">Katie <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> Evergreen-general <<a href="mailto:evergreen-general-bounces@list.evergreen-ils.org" target="_blank">evergreen-general-bounces@list.evergreen-ils.org</a>>
<b>On Behalf Of </b>Elaine Hardy via Evergreen-general<br>
<b>Sent:</b> Thursday, February 9, 2023 8:03 AM<br>
<b>To:</b> Evergreen Discussion Group <<a href="mailto:evergreen-general@list.evergreen-ils.org" target="_blank">evergreen-general@list.evergreen-ils.org</a>><br>
<b>Cc:</b> Elaine Hardy <<a href="mailto:ehardy@georgialibraries.org" target="_blank">ehardy@georgialibraries.org</a>><br>
<b>Subject:</b> Re: [Evergreen-general] How do you keep your OCLC holdings up to date?<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal"><span style="font-family:Tahoma,sans-serif">We send files once a month to OCLC to update holdings. Chris Sharp will have more info on how that happens. We haven't had any issues with the file not being processed within a few days. We
have had issues where passwords have expired or something else prevents the files from going through. We could do it more often under our contract with OCLC; but, a month works for our libraries.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Tahoma,sans-serif"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Tahoma,sans-serif">PINES only updates holdings and doesn't delete since Evergreen doesn't report the last copy for a system in a consortial environment where we all have separate OCLC symbols. Each system is responsible
for their own deletes and we have a report they use to help. In reality, we know that some libraries never delete their holdings. OCLC does have a new, free mini reclamation process that we hope to take advantage of again to keep holdings up to date.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Tahoma,sans-serif"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Tahoma,sans-serif">Elaine<br clear="all">
<u></u><u></u></span></p>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<table border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:5pt">
<p align="right" style="margin:0in;text-align:right"><span style="font-family:Arial,sans-serif;color:black;border:1pt none windowtext;padding:0in"><img width="75" height="75" style="width: 0.7812in; height: 0.7812in;" id="m_-8525352215512796809_x0000_i1029" src="https://lh5.googleusercontent.com/bpjlHkZIWY-VYFVLNA9ro5_6N4c7AxtzAPQhhzTKXaM1luxXME10aRo56LngwgoMXQ-OptUpmewQo8ljPZNpd7H2nZx09Xns4m_RVJ6D7NoWhha3cHDFxXExYWy2c7E0qfs3M5WC"></span><u></u><u></u></p>
</td>
<td valign="top" style="padding:5pt">
<p style="margin-right:0in;margin-bottom:0in;margin-left:9pt">
<b><span style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(30,67,155)">J. Elaine Hardy</span></b><span style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(30,67,155)">,<b>
</b>PINES and Collaborative Projects Manager</span><u></u><u></u></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p style="margin-right:0in;margin-bottom:0in;margin-left:9pt">
<b><span style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(30,67,155)">Georgia Public Library Service</span></b><u></u><u></u></p>
<p style="margin-right:0in;margin-bottom:0in;margin-left:9pt">
<span style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(30,67,155)">2872 Woodcock Blvd., Suite 250 | Atlanta, GA 30341</span><u></u><u></u></p>
<p style="margin-right:0in;margin-bottom:0in;margin-left:9pt">
<span style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(30,67,155);background:white">(404) 235-7128</span><span style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(30,67,155)"> |
<a href="mailto:ehardy@georgialibraries.org" target="_blank">ehardy@georgialibraries.org</a></span><u></u><u></u></p>
<p style="margin-right:0in;margin-bottom:0in;margin-left:9pt">
<span style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(30,67,155)">(404) 548-4241 | Cell</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p style="margin-right:0in;margin-bottom:0in;margin-left:9pt">
<a href="https://www.facebook.com/georgialibraries" target="_blank"><span style="font-size:9pt;font-family:Verdana,sans-serif;color:rgb(17,85,204);border:1pt none windowtext;padding:0in;text-decoration:none"><img border="0" width="36" height="36" style="width: 0.375in; height: 0.375in;" id="m_-8525352215512796809_x0000_i1028" src="https://lh4.googleusercontent.com/wjWdJl8zhUVb20FdmA0VXc4J9O5c0fKk1TTRabfYTrAZPyt8gtuVsgSIP_gPDaSD0mpvMRmzVxbpurZbyAzV1VrEHAKJUAZkUeSVH-CLb0KFkL6pHU_v09gN6QRKIRtUq1iR-Zbn"></span></a><span style="font-size:10pt;font-family:Verdana,sans-serif;color:black">
</span><a href="https://www.twitter.com/georgialibs" target="_blank"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(17,85,204);border:1pt none windowtext;padding:0in;text-decoration:none"><img border="0" width="35" height="35" style="width: 0.3645in; height: 0.3645in;" id="m_-8525352215512796809_x0000_i1027" src="https://lh6.googleusercontent.com/9dDBepVWGW2bIMC615q1KfmBTkk04sQENYf3r3X4IP5eYttphc5NQh1IZ4vsfVKxNeDquYf251jJKz3GP8Gs0LSo5nPIlC1gZsTcmFlhGRuaM0RSbHJXxpqqwAVJgjcKud5Jzgop"></span></a><a href="https://www.instagram.com/georgialibraries/" target="_blank"><span style="font-family:Arial,sans-serif;color:rgb(17,85,204);border:1pt none windowtext;padding:0in;text-decoration:none"><img border="0" width="37" height="37" style="width: 0.3854in; height: 0.3854in;" id="m_-8525352215512796809_x0000_i1026" src="https://lh3.googleusercontent.com/qC0XM1vBNxEXGw_lKy9Mi0CItlEXSk42qcHTINcYfBgysbcUifEX39mTV0CvllVyEzZUU7Di1U3uQ4N5hKG7244DAaWAfZIxP3HldZONwuBMo1KdTdPe_5SUXG44S8MQvRFkWJcj"></span></a><u></u><u></u></p>
</td>
</tr>
<tr style="height:21pt">
<td colspan="2" valign="top" style="padding:5pt;height:21pt">
<p style="margin:0in"><span style="font-size:7.5pt"><a href="http://georgialibraries.org/subscription" target="_blank"><i><span style="font-family:Verdana,sans-serif;color:rgb(17,85,204);background:white">Join our email list</span></i></a></span><i><span style="font-size:7.5pt;font-family:Verdana,sans-serif;color:black;background:white">
</span></i><i><span style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(67,67,67);background:white">for stories of Georgia libraries making an impact in our communities</span></i><i><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(67,67,67);background:white">.</span></i><u></u><u></u></p>
<p style="margin:0in"><u></u> <u></u></p>
<p><span style="font-family:"Comic Sans MS"">It does not do to leave a live dragon out of your calculations, if you live near him</span>.
<i>— </i><i><span style="font-family:"Comic Sans MS"">J.R.R. Tolkien</span></i><u></u><u></u></p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Wed, Feb 8, 2023 at 12:12 PM Josh Stompro via Evergreen-general <<a href="mailto:evergreen-general@list.evergreen-ils.org" target="_blank">evergreen-general@list.evergreen-ils.org</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal">Hello Benjamin, we use the OCLC Metadata api to keep our holdings up to date in OCLC on a twice daily basis. It is a process based off of a custom db table that just holds all the OCLC numbers found in our DB, and a few bash and perl scripts.
We don't try and track last copies being withdrawn, we just let them know any time an OCLC number is no longer associated with any available copies, and vice versa.<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I also had a system setup to upload files of adds and deletes, but that was such a pain because someone at OCLC had to manually process them, and randomly they would just skip doing it. Or else it would take them between 1 and 18 days
to process the file. So I had to also have a system to check if or when they actually processed it. The Metadata api simplifies that.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">The metadata api does have issues with subsumed numbers though... they will sometimes return the new OCLC number so we can update our numbers, but sometimes they won't and they just report the old number as not existing. So I think we
will have to do a manual reclamation once a year to catch those. (There is a way to get a dump of bibs that OCLC thinks you have to compare with what you actually have for free.)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">The API hasn't always been smooth going, OCLC switched servers last year and cloudflare started blocking all our requests. There was zero debugging info on our end, just dropped connections. It took months to get in touch with someone
that could actually fix it.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I'm happy to share all my code and notes if anyone wants it.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Josh<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Wed, Feb 8, 2023 at 10:31 AM Murphy, Benjamin via Evergreen-general <<a href="mailto:evergreen-general@list.evergreen-ils.org" target="_blank">evergreen-general@list.evergreen-ils.org</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div>
<p class="MsoNormal">We’ve been talking with some academic libraries about using Evergreen. An important process for them is keeping their OCLC holdings information up to date. For those of you that
use OCLC, do you have and sort of automated procedures that help you update your holdings information?<u></u><u></u></p>
<div>
<p class="MsoNormal"><span style="color:black"> </span><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Benjamin Murphy</span></b><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">NC Cardinal Program Manager</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">State Library of North Carolina</span><u></u><u></u></p>
<p class="MsoNormal"><u><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(5,99,193)"><a href="mailto:benjamin.murphy@ncdcr.gov" target="_blank"><span style="color:rgb(5,99,193)">benjamin.murphy@ncdcr.gov</span></a>
</span></u><span style="font-size:10pt;font-family:Arial,sans-serif;color:black"> |
<a href="https://statelibrary.ncdcr.gov/services-libraries/nc-cardinal" target="_blank">
<span style="color:rgb(5,99,193)">https://statelibrary.ncdcr.gov/services-libraries/nc-cardinal</span></a></span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">109 East Jones Street | 4640 Mail Service Center
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Raleigh, North Carolina 27699-4600</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-top:6pt"><span style="font-size:10pt;font-family:Arial,sans-serif">The State Library is part of the NC Department of Natural & Cultural Resources.</span><u></u><u></u></p>
<p class="MsoNormal"><i><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Email correspondence to and from this address is subject to the North Carolina Public Records Law and
may be disclosed to third parties.</span></i><u></u><u></u></p>
</div>
<div>
<div>
<blockquote style="border-top:none currentcolor;border-right:none currentcolor;border-bottom:none currentcolor;border-left:1pt solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin:5pt 0in 5pt 4.8pt">
<p class="MsoNormal"> <u></u><u></u></p>
</blockquote>
</div>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Evergreen-general mailing list<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><u></u><u></u></p>
</div>
</blockquote>
</div>
<p class="MsoNormal">_______________________________________________<br>
Evergreen-general mailing list<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><u></u><u></u></p>
</blockquote>
</div>
</div>
</div>
_______________________________________________<br>
Evergreen-general mailing list<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
</div></blockquote></div>