<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<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 = 'https://www.hoopladigital.com/title/11780681' or</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
uri.href = 'https://www.hoopladigital.com/title/12326359' or</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
uri.href = 'https://www.hoopladigital.com/title/16968789'</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>
<div id="appendonsend"></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 <evergreen-catalogers-bounces@list.evergreen-ils.org> on behalf of Tricia Everaert via Evergreen-catalogers <evergreen-catalogers@list.evergreen-ils.org><br>
<b>Sent:</b> Wednesday, October 23, 2024 12:47 PM<br>
<b>To:</b> Evergreen Community Catalogers <evergreen-catalogers@list.evergreen-ils.org><br>
<b>Cc:</b> Tricia Everaert <teveraert@nflibrary.ca><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">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"><font color="#000000" face="trebuchet ms, sans-serif"><br>
</font></div>
<div style="font-size:12.8px"><font color="#000000"></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">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>
</body>
</html>