<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Tricia,<br>
<br>
You might be interested in this external program we developed to
keep Evergreen's electronic bibs in sync with an external vendor
such as Hoopla. (including removals). We ended up developing it to
solve this exact problem. There's a LP report for inclusion of this
script but it needs more work before it can be included in
Evergreen:<br>
<br>
<a href="https://bugs.launchpad.net/evergreen/+bug/1947898"
class="moz-txt-link-freetext">https://bugs.launchpad.net/evergreen/+bug/1947898</a><br>
<br>
I presented it for the Evergreen conference 2023:<br>
<br>
<a href="https://slides.mobiusconsortium.org/blake/bib_magic/#/"
class="moz-txt-link-freetext">https://slides.mobiusconsortium.org/blake/bib_magic/#/</a><br>
<br>
Presentation recording:<br>
<a href="https://www.youtube.com/watch?v=yGEypjsRMxA"
class="moz-txt-link-freetext">https://www.youtube.com/watch?v=yGEypjsRMxA</a><br>
<br>
NC Cardinal presented at the 2024 conference showing how their using
that tool in conjunction with other methods to prune and shape the
Evergreen database. I can't seem to find the slides or a recording
of that, but it's called "Modify a Million MARC a Month"<br>
<br>
<a
href="https://evergreen-ils.org/conference/2024-evergreen-international-online-conference/2024-program-descriptions/"
class="moz-txt-link-freetext">https://evergreen-ils.org/conference/2024-evergreen-international-online-conference/2024-program-descriptions/</a><br>
<br>
I'd be happy to answer any questions.<br>
<br>
<pre class="moz-signature" cols="72">-Blake-
Conducting Magic
Will consume any data format
MOBIUS
</pre>
<br>
<div class="moz-cite-prefix">On 10/23/2024 2:20 PM, Garry Collum via
Evergreen-catalogers wrote:<br>
</div>
<blockquote type="cite"
cite="mid:SJ2PR12MB9209F19DA7A1350C96D04057BC4D2@SJ2PR12MB9209.namprd12.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style>
<div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Just like Ruth, we have also gone to a discovery layer, but ours
pulls everything from Hoopla through an API, except music
records, so it's much less work than it used to be.</div>
<div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The monthly deletions spreadsheet from Hoopla contains a list of
urls. I use a text editor to format these urls into a SQL
statement so I can get a list of the record ids from our
system. </div>
<div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Something like this:</div>
<div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
select distinct(record)</div>
<div
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
from asset.call_number</div>
<div
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
join asset.uri_call_number_map ucnm on ucnm.call_number =
call_number.id</div>
<div
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
join asset.uri on uri.id = ucnm.uri</div>
<div
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
where (</div>
<div
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
uri.href = '<a class="moz-txt-link-freetext" href="https://www.hoopladigital.com/title/11780681">https://www.hoopladigital.com/title/11780681</a>' or</div>
<div
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
uri.href = '<a class="moz-txt-link-freetext" href="https://www.hoopladigital.com/title/12326359">https://www.hoopladigital.com/title/12326359</a>' or</div>
<div
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
uri.href = '<a class="moz-txt-link-freetext" href="https://www.hoopladigital.com/title/16968789">https://www.hoopladigital.com/title/16968789</a>'</div>
<div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
)</div>
<div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Once I have this list, I export the records from Evergreen and
remove the 856s using marcedit. I then reimport them and send
the records to a bucket so they can be deleted.</div>
<div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Garry</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif"
style="font-size:11pt" color="#000000"><b>From:</b>
Evergreen-catalogers
<a class="moz-txt-link-rfc2396E" href="mailto:evergreen-catalogers-bounces@list.evergreen-ils.org"><evergreen-catalogers-bounces@list.evergreen-ils.org></a> on
behalf of Tricia Everaert via Evergreen-catalogers
<a class="moz-txt-link-rfc2396E" href="mailto:evergreen-catalogers@list.evergreen-ils.org"><evergreen-catalogers@list.evergreen-ils.org></a><br>
<b>Sent:</b> Wednesday, October 23, 2024 12:47 PM<br>
<b>To:</b> Evergreen Community Catalogers
<a class="moz-txt-link-rfc2396E" href="mailto:evergreen-catalogers@list.evergreen-ils.org"><evergreen-catalogers@list.evergreen-ils.org></a><br>
<b>Cc:</b> Tricia Everaert <a class="moz-txt-link-rfc2396E" href="mailto:teveraert@nflibrary.ca"><teveraert@nflibrary.ca></a><br>
<b>Subject:</b> [Evergreen-catalogers] Batch deleting MARCs</font>
<div> </div>
</div>
<div>
<div dir="ltr">Hello cataloguing friends!
<div>We're looking at including Hoopla and possibly other
digital records in our catalogue, but don't want to do so
until we find a way to batch delete or automate the deletion
of records for titles we no longer have access to.</div>
<div>We currently have cloudLibrary MARCs in our database, and
then every month we have to manually search and delete
records for titles we no longer have by first deleting an
856 field, then delete the bib. Given the quantity of
records we'd have from Hoopla, this workflow wouldn't be
feasible.</div>
<div>My question is, how do you handle the maintenance of your
digital records, and is there a way to batch delete bibs
from either mrc. or csv files?</div>
<div><br>
</div>
<div>Appreciate your thoughts,</div>
<div>Tricia<br clear="all">
<div>
<div dir="ltr" class="x_gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div style="font-size:12.8px"><span>
<p dir="ltr"
style="line-height:1.38; margin-top:0pt; margin-bottom:0pt"><br>
</p>
<p dir="ltr"
style="line-height:1.38; margin-top:0pt; margin-bottom:0pt"><br>
</p>
</span></div>
<div style="font-size:12.8px"><font
color="#000000"
face="trebuchet ms, sans-serif"><b>Tricia
Everaert</b></font></div>
<div style="font-size:12.8px"><font
color="#000000"
face="trebuchet ms, sans-serif"><span
style="font-size:12.8px">Collections
and Digital Asset Technician</span></font></div>
<div style="font-size:12.8px"><font
color="#000000"
face="trebuchet ms, sans-serif"><span
style="font-size:12.8px">Information
Resources & Connections</span><br>
</font></div>
<div style="font-size:12.8px"><b><font
color="#000000"
face="trebuchet ms, sans-serif">Niagara
Falls Public Library</font></b></div>
<div style="font-size:12.8px"><font
color="#000000"
face="trebuchet ms, sans-serif">4848
Victoria Avenue, <span
style="font-size:12.8px">Niagara
Falls, ON L2E 4C5 </span></font></div>
<div style="font-size:12.8px"><font
color="#000000"
face="trebuchet ms, sans-serif">Tel 905-356-8080
x 251
<a
href="mailto:teveraert@nflibrary.ca"
target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">teveraert@nflibrary.ca</a></font></div>
<div style="font-size:12.8px"><img
width="200" height="58"
src="https://docs.google.com/uc?export=download&id=1zVDqburqsIn44erfZsdt1gowghXksJ0C&revid=0BzY0_IcA55AaN0JUU2RnbmdWQllwRkJ4cTVnNzFvY0RkcDlRPQ"
moz-do-not-send="true"><font
color="#000000"
face="trebuchet ms, sans-serif"><br>
</font></div>
<div style="font-size:12.8px"><font
color="#000000"><br>
</font></div>
<div style="font-size:12.8px"><span
style="font-family:sans-serif; font-size:small">CONFIDENTIALITY NOTICE:
This communication and any
accompanying document(s) are
confidential and may be privileged.
They are intended for the sole use of
the addressee. If you receive this
transmission in error, you are advised
that any disclosure, copying,
distribution, or the taking of any
action in reliance upon the
communication is strictly prohibited.
If you have received this
communication in error, please
immediately contact or inform the
sender by return e-mail or by
telephone at </span><a
href="tel:905-356-8080%20x248"
value="+19053568080" target="_blank"
style="color:rgb(17,85,204); font-family:sans-serif; font-size:small"
moz-do-not-send="true">905-356-8080
x248</a><span
style="font-family:sans-serif; font-size:small"> and delete this e-mail
message and all copies. Due to the
inherent risks associated with the
Internet, we assume no responsibility
for unauthorized interception of any
Internet communication with you or the
transmission of computer viruses.</span><font
color="#000000"><br>
</font></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<font face="Trebuchet" style="background-color:white">The
Niagara Falls Public Library promotes work-life balance and
the right for its employees to disconnect outside of work
hours. Please do not feel obligated to reply to this email
outside of your normal working hours.</font><br>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre wrap="" class="moz-quote-pre">_______________________________________________
Evergreen-catalogers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Evergreen-catalogers@list.evergreen-ils.org">Evergreen-catalogers@list.evergreen-ils.org</a>
<a class="moz-txt-link-freetext" href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers</a>
</pre>
</blockquote>
<br>
</body>
</html>