<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
@font-face
{font-family:Trebuchet;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt">What we have started doing with econtent records is to create a new record match set so that they match on the 037 (provider ID) as opposed to ISBN. We made sure that we had the Hoopla ones all separated from
other econtent records, and so now when we have the delete file, we can import it to match on the 037 and overlay the record with the URIs with the record from Hoopla’s deleted records file. Then, because the updated records have no URIs, we can put them in
a bucket from the import queue and delete them all at once. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I’m not sure if this would work with all providers, since we only manage Hoopla records centrally (since it’s the same batches for all of our members who subscribe), but it has been helping us do that management
since we implemented it this summer. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I’m happy to provide more details
</span><span style="font-size:11.0pt;font-family:"Segoe UI Emoji",sans-serif">😊</span><span style="font-size:11.0pt">
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Katie <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Evergreen-catalogers <evergreen-catalogers-bounces@list.evergreen-ils.org>
<b>On Behalf Of </b>Garry Collum via Evergreen-catalogers<br>
<b>Sent:</b> Wednesday, October 23, 2024 3:21 PM<br>
<b>To:</b> Evergreen Community Catalogers <evergreen-catalogers@list.evergreen-ils.org><br>
<b>Cc:</b> Garry Collum <gcollum@hotmail.com><br>
<b>Subject:</b> Re: [Evergreen-catalogers] Batch deleting MARCs<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black">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.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black">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. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black">Something like this:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black">select distinct(record)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black">from asset.call_number<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black">join asset.uri_call_number_map ucnm on ucnm.call_number = call_number.id<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black">join asset.uri on uri.id = ucnm.uri<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black">where (<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black"> uri.href = 'https://www.hoopladigital.com/title/11780681' or<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black"> uri.href = 'https://www.hoopladigital.com/title/12326359' or<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black"> uri.href = 'https://www.hoopladigital.com/title/16968789'<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black">)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black">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.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black">Garry<o:p></o:p></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> Evergreen-catalogers <</span><a href="mailto:evergreen-catalogers-bounces@list.evergreen-ils.org"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">evergreen-catalogers-bounces@list.evergreen-ils.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">>
on behalf of Tricia Everaert via Evergreen-catalogers <</span><a href="mailto:evergreen-catalogers@list.evergreen-ils.org"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">evergreen-catalogers@list.evergreen-ils.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">><br>
<b>Sent:</b> Wednesday, October 23, 2024 12:47 PM<br>
<b>To:</b> Evergreen Community Catalogers <</span><a href="mailto:evergreen-catalogers@list.evergreen-ils.org"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">evergreen-catalogers@list.evergreen-ils.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">><br>
<b>Cc:</b> Tricia Everaert <</span><a href="mailto:teveraert@nflibrary.ca"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">teveraert@nflibrary.ca</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">><br>
<b>Subject:</b> [Evergreen-catalogers] Batch deleting MARCs</span> <o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">Hello cataloguing friends! <o:p></o:p></p>
<div>
<p class="MsoNormal">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.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">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.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">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?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Appreciate your thoughts,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Tricia<br clear="all">
<o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p><span style="font-size:9.5pt"><o:p> </o:p></span></p>
<p><span style="font-size:9.5pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:9.5pt;font-family:"Trebuchet MS",sans-serif;color:black">Tricia Everaert</span></b><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Trebuchet MS",sans-serif;color:black">Collections and Digital Asset Technician</span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Trebuchet MS",sans-serif;color:black">Information Resources & Connections</span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:9.5pt;font-family:"Trebuchet MS",sans-serif;color:black">Niagara Falls Public Library</span></b><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Trebuchet MS",sans-serif;color:black">4848 Victoria Avenue, Niagara Falls, ON L2E 4C5 </span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Trebuchet MS",sans-serif;color:black">Tel 905-356-8080 x 251
</span><a href="mailto:teveraert@nflibrary.ca" target="_blank"><span style="font-size:9.5pt;font-family:"Trebuchet MS",sans-serif">teveraert@nflibrary.ca</span></a><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"><img border="0" width="200" height="58" style="width:2.0833in;height:.6041in" id="_x0000_i1026" src="https://docs.google.com/uc?export=download&id=1zVDqburqsIn44erfZsdt1gowghXksJ0C&revid=0BzY0_IcA55AaN0JUU2RnbmdWQllwRkJ4cTVnNzFvY0RkcDlRPQ"></span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">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" target="_blank"><span style="font-family:"Arial",sans-serif;color:#1155CC">905-356-8080 x248</span></a><span style="font-family:"Arial",sans-serif"> 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><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><br>
<span style="font-family:"Trebuchet",serif;color:black;background: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.</span><o:p></o:p></p>
</div>
</div>
</body>
</html>