<div dir="ltr">Thank you to everyone who shared your process for importing and batch deleting Hoopla-like records.<div>I've passed it all along to our IT team and they are hopeful we'll get it working.</div><div><br></div><div>This is such a good community! I appreciate how generous you are with your time and knowledge,</div><div>t.<br clear="all"><div><div dir="ltr" class="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 src="https://docs.google.com/uc?export=download&id=1zVDqburqsIn44erfZsdt1gowghXksJ0C&revid=0BzY0_IcA55AaN0JUU2RnbmdWQllwRkJ4cTVnNzFvY0RkcDlRPQ" width="200" height="58"><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" style="color:rgb(17,85,204);font-family:sans-serif;font-size:small" target="_blank">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><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 23 Oct 2024 at 16:52, <<a href="mailto:evergreen-catalogers-request@list.evergreen-ils.org">evergreen-catalogers-request@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">Send Evergreen-catalogers mailing list submissions to<br>
<a href="mailto:evergreen-catalogers@list.evergreen-ils.org" target="_blank">evergreen-catalogers@list.evergreen-ils.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers</a><br>
<br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:evergreen-catalogers-request@list.evergreen-ils.org" target="_blank">evergreen-catalogers-request@list.evergreen-ils.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:evergreen-catalogers-owner@list.evergreen-ils.org" target="_blank">evergreen-catalogers-owner@list.evergreen-ils.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Evergreen-catalogers digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Batch deleting MARCs (Blake Graham-Henderson)<br>
2. Re: Batch deleting MARCs (Katie Greenleaf Martin)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Wed, 23 Oct 2024 15:37:29 -0500<br>
From: Blake Graham-Henderson <<a href="mailto:blake@mobiusconsortium.org" target="_blank">blake@mobiusconsortium.org</a>><br>
To: <a href="mailto:evergreen-catalogers@list.evergreen-ils.org" target="_blank">evergreen-catalogers@list.evergreen-ils.org</a><br>
Subject: Re: [Evergreen-catalogers] Batch deleting MARCs<br>
Message-ID:<br>
<<a href="mailto:4c8c8633-e862-4c13-b33d-add70db5386b@mobiusconsortium.org" target="_blank">4c8c8633-e862-4c13-b33d-add70db5386b@mobiusconsortium.org</a>><br>
Content-Type: text/plain; charset="utf-8"; Format="flowed"<br>
<br>
Tricia,<br>
<br>
You might be interested in this external program we developed to keep <br>
Evergreen's electronic bibs in sync with an external vendor such as <br>
Hoopla. (including removals). We ended up developing it to solve this <br>
exact problem. There's a LP report for inclusion of this script but it <br>
needs more work before it can be included in Evergreen:<br>
<br>
<a href="https://bugs.launchpad.net/evergreen/+bug/1947898" rel="noreferrer" target="_blank">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/#/" rel="noreferrer" target="_blank">https://slides.mobiusconsortium.org/blake/bib_magic/#/</a><br>
<br>
Presentation recording:<br>
<a href="https://www.youtube.com/watch?v=yGEypjsRMxA" rel="noreferrer" target="_blank">https://www.youtube.com/watch?v=yGEypjsRMxA</a><br>
<br>
NC Cardinal presented at the 2024 conference showing how their using <br>
that tool in conjunction with other methods to prune and shape the <br>
Evergreen database. I can't seem to find the slides or a recording of <br>
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/" rel="noreferrer" target="_blank">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>
-Blake-<br>
Conducting Magic<br>
Will consume any data format<br>
MOBIUS<br>
<br>
<br>
<br>
On 10/23/2024 2:20 PM, Garry Collum via Evergreen-catalogers wrote:<br>
> Just like Ruth, we have also gone to a discovery layer, but ours pulls <br>
> everything from Hoopla through an API, except music records, so it's <br>
> much less work than it used to be.<br>
><br>
> The monthly deletions spreadsheet from Hoopla contains a list of <br>
> urls.? I use a text editor to format these urls into a SQL statement <br>
> so I can get a list of the record ids from our system.<br>
><br>
> Something like this:<br>
><br>
> select distinct(record)<br>
> from asset.call_number<br>
> join asset.uri_call_number_map ucnm on ucnm.call_number = <a href="http://call_number.id" rel="noreferrer" target="_blank">call_number.id</a><br>
> join asset.uri on <a href="http://uri.id" rel="noreferrer" target="_blank">uri.id</a> = ucnm.uri<br>
> where (<br>
> ?uri.href = '<a href="https://www.hoopladigital.com/title/11780681" rel="noreferrer" target="_blank">https://www.hoopladigital.com/title/11780681</a>' or<br>
> ?uri.href = '<a href="https://www.hoopladigital.com/title/12326359" rel="noreferrer" target="_blank">https://www.hoopladigital.com/title/12326359</a>' or<br>
> ?uri.href = '<a href="https://www.hoopladigital.com/title/16968789" rel="noreferrer" target="_blank">https://www.hoopladigital.com/title/16968789</a>'<br>
> )<br>
><br>
> Once I have this list, I export the records from Evergreen and remove <br>
> the 856s using marcedit.? I then reimport them and send the records to <br>
> a bucket so they can be deleted.<br>
><br>
> Garry<br>
> ------------------------------------------------------------------------<br>
> *From:* Evergreen-catalogers <br>
> <<a href="mailto:evergreen-catalogers-bounces@list.evergreen-ils.org" target="_blank">evergreen-catalogers-bounces@list.evergreen-ils.org</a>> on behalf of <br>
> Tricia Everaert via Evergreen-catalogers <br>
> <<a href="mailto:evergreen-catalogers@list.evergreen-ils.org" target="_blank">evergreen-catalogers@list.evergreen-ils.org</a>><br>
> *Sent:* Wednesday, October 23, 2024 12:47 PM<br>
> *To:* Evergreen Community Catalogers <br>
> <<a href="mailto:evergreen-catalogers@list.evergreen-ils.org" target="_blank">evergreen-catalogers@list.evergreen-ils.org</a>><br>
> *Cc:* Tricia Everaert <<a href="mailto:teveraert@nflibrary.ca" target="_blank">teveraert@nflibrary.ca</a>><br>
> *Subject:* [Evergreen-catalogers] Batch deleting MARCs<br>
> Hello cataloguing friends!<br>
> We're looking at including Hoopla and possibly other digital records <br>
> in our catalogue, but don't want to do so until we find a way to batch <br>
> delete or automate the deletion of records for titles we no longer <br>
> have access to.<br>
> We currently have cloudLibrary MARCs in our database, and then every <br>
> month we have to manually search and delete records for titles we no <br>
> longer have by first deleting an 856 field, then delete the bib.? <br>
> Given the quantity of records we'd have from Hoopla, this workflow <br>
> wouldn't be feasible.<br>
> My question is, how do you handle the maintenance of your digital <br>
> records, and is there a way to batch delete bibs from either mrc. or <br>
> csv files?<br>
><br>
> Appreciate your thoughts,<br>
> Tricia<br>
><br>
><br>
><br>
> *Tricia Everaert*<br>
> Collections and Digital Asset Technician<br>
> Information Resources & Connections<br>
> *Niagara Falls Public Library*<br>
> 4848 Victoria Avenue, Niagara Falls, ON ?L2E 4C5<br>
> Tel?905-356-8080 x 251 <a href="mailto:teveraert@nflibrary.ca" target="_blank">teveraert@nflibrary.ca</a><br>
><br>
><br>
> CONFIDENTIALITY NOTICE: This communication and any accompanying <br>
> document(s) are confidential and may be privileged. They are intended <br>
> for the sole use of the addressee. If you receive this transmission in <br>
> error, you are advised that any disclosure, copying, distribution, or <br>
> the taking of any action in reliance upon the communication is <br>
> strictly prohibited. If you have received this communication in error, <br>
> please immediately contact or inform the sender by return e-mail or by <br>
> telephone at 905-356-8080 x248 <tel:905-356-8080%20x248>?and delete <br>
> this e-mail message and all copies. Due to the inherent risks <br>
> associated with the Internet, we assume no responsibility for <br>
> unauthorized interception of any Internet communication with you or <br>
> the transmission of computer viruses.<br>
><br>
> The Niagara Falls Public Library promotes work-life balance and the <br>
> right for its employees to disconnect outside of work hours. Please do <br>
> not feel obligated to reply to this email outside of your normal <br>
> working hours.<br>
><br>
> _______________________________________________<br>
> Evergreen-catalogers mailing list<br>
> <a href="mailto:Evergreen-catalogers@list.evergreen-ils.org" target="_blank">Evergreen-catalogers@list.evergreen-ils.org</a><br>
> <a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://list.evergreen-ils.org/pipermail/evergreen-catalogers/attachments/20241023/e44008e7/attachment-0001.htm" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/pipermail/evergreen-catalogers/attachments/20241023/e44008e7/attachment-0001.htm</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 23 Oct 2024 20:52:20 +0000<br>
From: Katie Greenleaf Martin <<a href="mailto:kgm@sparkpa.org" target="_blank">kgm@sparkpa.org</a>><br>
To: Evergreen Community Catalogers<br>
<<a href="mailto:evergreen-catalogers@list.evergreen-ils.org" target="_blank">evergreen-catalogers@list.evergreen-ils.org</a>><br>
Subject: Re: [Evergreen-catalogers] Batch deleting MARCs<br>
Message-ID:<br>
<<a href="mailto:BN8PR18MB23698804200F47DF8430F43BA54D2@BN8PR18MB2369.namprd18.prod.outlook.com" target="_blank">BN8PR18MB23698804200F47DF8430F43BA54D2@BN8PR18MB2369.namprd18.prod.outlook.com</a>><br>
<br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
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.<br>
<br>
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.<br>
<br>
I?m happy to provide more details ?<br>
Katie<br>
<br>
From: Evergreen-catalogers <<a href="mailto:evergreen-catalogers-bounces@list.evergreen-ils.org" target="_blank">evergreen-catalogers-bounces@list.evergreen-ils.org</a>> On Behalf Of Garry Collum via Evergreen-catalogers<br>
Sent: Wednesday, October 23, 2024 3:21 PM<br>
To: Evergreen Community Catalogers <<a href="mailto:evergreen-catalogers@list.evergreen-ils.org" target="_blank">evergreen-catalogers@list.evergreen-ils.org</a>><br>
Cc: Garry Collum <<a href="mailto:gcollum@hotmail.com" target="_blank">gcollum@hotmail.com</a>><br>
Subject: Re: [Evergreen-catalogers] Batch deleting MARCs<br>
<br>
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.<br>
<br>
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.<br>
<br>
Something like this:<br>
<br>
select distinct(record)<br>
from asset.call_number<br>
join asset.uri_call_number_map ucnm on ucnm.call_number = <a href="http://call_number.id" rel="noreferrer" target="_blank">call_number.id</a><br>
join asset.uri on <a href="http://uri.id" rel="noreferrer" target="_blank">uri.id</a> = ucnm.uri<br>
where (<br>
uri.href = '<a href="https://www.hoopladigital.com/title/11780681" rel="noreferrer" target="_blank">https://www.hoopladigital.com/title/11780681</a>' or<br>
uri.href = '<a href="https://www.hoopladigital.com/title/12326359" rel="noreferrer" target="_blank">https://www.hoopladigital.com/title/12326359</a>' or<br>
uri.href = '<a href="https://www.hoopladigital.com/title/16968789" rel="noreferrer" target="_blank">https://www.hoopladigital.com/title/16968789</a>'<br>
)<br>
<br>
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.<br>
<br>
Garry<br>
________________________________<br>
From: Evergreen-catalogers <<a href="mailto:evergreen-catalogers-bounces@list.evergreen-ils.org" target="_blank">evergreen-catalogers-bounces@list.evergreen-ils.org</a><mailto:<a href="mailto:evergreen-catalogers-bounces@list.evergreen-ils.org" target="_blank">evergreen-catalogers-bounces@list.evergreen-ils.org</a>>> on behalf of Tricia Everaert via Evergreen-catalogers <<a href="mailto:evergreen-catalogers@list.evergreen-ils.org" target="_blank">evergreen-catalogers@list.evergreen-ils.org</a><mailto:<a href="mailto:evergreen-catalogers@list.evergreen-ils.org" target="_blank">evergreen-catalogers@list.evergreen-ils.org</a>>><br>
Sent: Wednesday, October 23, 2024 12:47 PM<br>
To: Evergreen Community Catalogers <<a href="mailto:evergreen-catalogers@list.evergreen-ils.org" target="_blank">evergreen-catalogers@list.evergreen-ils.org</a><mailto:<a href="mailto:evergreen-catalogers@list.evergreen-ils.org" target="_blank">evergreen-catalogers@list.evergreen-ils.org</a>>><br>
Cc: Tricia Everaert <<a href="mailto:teveraert@nflibrary.ca" target="_blank">teveraert@nflibrary.ca</a><mailto:<a href="mailto:teveraert@nflibrary.ca" target="_blank">teveraert@nflibrary.ca</a>>><br>
Subject: [Evergreen-catalogers] Batch deleting MARCs<br>
<br>
Hello cataloguing friends!<br>
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.<br>
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.<br>
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?<br>
<br>
Appreciate your thoughts,<br>
Tricia<br>
<br>
<br>
<br>
<br>
Tricia Everaert<br>
Collections and Digital Asset Technician<br>
Information Resources & Connections<br>
Niagara Falls Public Library<br>
4848 Victoria Avenue, Niagara Falls, ON L2E 4C5<br>
Tel 905-356-8080 x 251 <a href="mailto:teveraert@nflibrary.ca" target="_blank">teveraert@nflibrary.ca</a><mailto:<a href="mailto:teveraert@nflibrary.ca" target="_blank">teveraert@nflibrary.ca</a>><br>
[<a href="https://docs.google.com/uc?export=download&id=1zVDqburqsIn44erfZsdt1gowghXksJ0C&revid=0BzY0_IcA55AaN0JUU2RnbmdWQllwRkJ4cTVnNzFvY0RkcDlRPQ" rel="noreferrer" target="_blank">https://docs.google.com/uc?export=download&id=1zVDqburqsIn44erfZsdt1gowghXksJ0C&revid=0BzY0_IcA55AaN0JUU2RnbmdWQllwRkJ4cTVnNzFvY0RkcDlRPQ</a>]<br>
<br>
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 905-356-8080 x248<tel:905-356-8080%20x248> 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.<br>
<br>
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.<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://list.evergreen-ils.org/pipermail/evergreen-catalogers/attachments/20241023/675133be/attachment.htm" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/pipermail/evergreen-catalogers/attachments/20241023/675133be/attachment.htm</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
Evergreen-catalogers mailing list<br>
<a href="mailto:Evergreen-catalogers@list.evergreen-ils.org" target="_blank">Evergreen-catalogers@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers</a><br>
<br>
<br>
------------------------------<br>
<br>
End of Evergreen-catalogers Digest, Vol 147, Issue 13<br>
*****************************************************<br>
</blockquote></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>