<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<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);">
The R5 tool is meant for consortia, so while it can be used for a single institution, it can be a bit confusing to use that way.</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);">
We at UPEI developed an <a href="https://github.com/CS-4820-Library-Project/COUNTER-5-Report-Tool-2020-5.0" title="https://github.com/CS-4820-Library-Project/COUNTER-5-Report-Tool-2020-5.0">
open source tool for R5.0</a> that still works pretty well and is on that list at Project COUNTER.</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);">
This semester, I have two separate teams of 4<sup>th</sup> year CS students each developing an update for it that is going to include 5.0 and 5.1 and should be compatible with Windows, Mac, and Linux desktops.</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
If the students complete the project (they want their As in that course!), I'll be making them available on Github. I'll know for sure by May.</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The new one will be simpler and I'll be providing side tips about using an SQLite database graphical front end (Dbeaver, free) to generate complex reports across multiple content providers.</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);">
In the meantime, I'm happy to provide basic support for the current one, which also puts all of the data in an SQLite database.</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I use it heavily myself, especially as we approach the fiscal year end, to identify ebooks to purchase with last minute funds (title investigations without requests and that we don't own, and "No_License" denials).</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);">
Whatever tool you use, you want to be able to generate such reports across providers</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);">
I also wrote a very simple open source python program to pull all of the data from the Registry, which helps make it easier to start populating a spreadsheet of vendor SUSHI credentials for importing into whatever tool you use.</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The tool takes a "snapshot" of the registry as of the moment it is run. If you would like a copy of a snapshot as of right now but don't know how to run a python program, email me and I'll send the output to you.</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">Melissa Belvadi</span></div>
<div style="text-align: left; background-color: rgb(255, 255, 255);"><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">mbelvadi@upei.ca</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Make an appointment: https://mbelvadi.youcanbook.me/</div>
</div>
<div id="appendonsend"></div>
<hr style="display: inline-block; width: 98%;">
<div dir="ltr" id="divRplyFwdMsg"><span style="font-family: Calibri, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);"><b>From:</b> Eril-l <eril-l-bounces@lists.eril-l.org> on behalf of Electronic Resources in Libraries discussion list via Eril-l <eril-l@lists.eril-l.org><br>
<b>Sent:</b> Thursday, January 25, 2024 6:13 PM<br>
<b>To:</b> Electronic Resources in Libraries discussion list <eril-l@lists.eril-l.org><br>
<b>Subject:</b> Re: [Eril-l] Setting up SUSHI Harvesting for Usage Data Collection Streamline</span>
<div> </div>
</div>
<div><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div style="background-color: rgb(255, 229, 153); margin-right: 0px; margin-left: 0px; padding: 10px;">
<span style="font-family: Arial, sans-serif; font-size: 9pt; color: rgb(23, 32, 42);"><b>CAUTION:</b></span><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
</span><span style="font-family: Arial, sans-serif; font-size: 9pt; color: rgb(23, 32, 42); line-height: 10pt;">This email originated from outside of UPEI. Do not click links or open attachments unless you recognize the sender and know the content is safe.
If you are uncertain, please forward to phishing@upei.ca and delete this email.</span></div>
<span style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span>
<div><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div style="background-color: rgb(255, 153, 153); margin-right: 0px; margin-left: 0px; padding: 10px;">
<span style="font-family: Arial, sans-serif; font-size: 9pt; color: rgb(23, 32, 42);"><b>WARNING:</b></span><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
</span><span style="font-family: Arial, sans-serif; font-size: 9pt; color: rgb(23, 32, 42); line-height: 10pt;">The sender of this email could not be verified and may not match the person in the 'FROM' field. Do not click links or open attachments unless you
recognize the sender and know the content is safe. If you are uncertain, please forward to phishing@upei.ca and delete this email.</span></div>
<span style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;">The Project COUNTER Registry is your friend for setting up SUSHI. <br>
<a href="https://registry.projectcounter.org/" id="OWAed369e6e-7805-ae76-c9dd-4cf3b63def2d" class="OWAAutoLink" data-auth="NotApplicable" data-loopstyle="linkonly" style="margin-top: 0px; margin-bottom: 0px;">https://registry.projectcounter.org/</a></span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;">It will provide basic info, such as contact info for the vendor, their SUSHI server URL, the required fields, reports provided.</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;"> </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;">You will benefit from having your admin logins current. Usually the Customer ID, Requestor ID, and/or API key can be found in the COUNTER stats area of admin
sites.</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;"> </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;">Which tool will you use for harvesting? There are several available, some for free and some for a fee, and some built into other tools (i.e. SUSHI is built
into Alma). They have different levels of complexity to set up and use well. The COUNTER site lists some tools:<br>
<a href="https://www.projectcounter.org/counter-harvester-tools/" id="OWA032121ed-a781-c20b-03f5-3e4418ff0677" class="OWAAutoLink" data-auth="NotApplicable" data-loopstyle="linkonly" style="margin-top: 0px; margin-bottom: 0px;">https://www.projectcounter.org/counter-harvester-tools/</a></span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;">If you are just getting started and do not have a budget for a tool, the
<b> </b><a href="https://www.projectcounter.org/wp-content/uploads/2020/04/SUSHIHarvesterR5.zip" id="OWA48b68890-353a-59b9-f9c5-206ee01199d8" class="OWAAutoLink" data-auth="NotApplicable" data-loopstyle="linkonly" style="margin-top: 0px; margin-bottom: 0px;">R5
Harvester tool</a> is a good starting tool.<br>
If you have a small budget, I recommend CELUS. I can’t say enough to convey how much I like this tool. It will do much of the heavy lifting for getting you up on SUSHI and makes it very easy to get useful info from the harvested data.</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;"> </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;">Good luck!</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;"> </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;">Athena</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;"> </span></p>
<p style="background-color: white; margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt; color: rgb(36, 36, 36);"><b><i>Athena Hoeppner
</i></b></span><span style="font-family: Arial, sans-serif; font-size: 8pt; color: rgb(36, 36, 36);"><i>(she/her/hers)</i></span></p>
<p style="background-color: white; margin: 0in 0in 0in 0.2in; font-family: Calibri, sans-serif; font-size: 11pt;">
<span style="font-family: Arial, sans-serif; font-size: 9pt; color: rgb(36, 36, 36);">Discovery Services Librarian | University Librarian</span></p>
<p style="background-color: white; margin: 0in 0in 0in 0.2in; font-family: Calibri, sans-serif; font-size: 11pt;">
<span style="font-family: Arial, sans-serif; font-size: 9pt; color: rgb(36, 36, 36);">University of Central Florida |
</span><span style="font-family: Arial, sans-serif; font-size: 9pt; color: rgb(5, 99, 193);"><a href="mailto:athena@ucf.edu" id="OWAccb97467-dccd-0fa4-595e-a30b70fa1879" class="OWAAutoLink" data-loopstyle="linkonly" style="color: rgb(5, 99, 193); margin-top: 0px; margin-bottom: 0px;">athena@ucf.edu</a></span></p>
<p style="background-color: white; margin: 0in 0in 0in 0.2in; font-family: Calibri, sans-serif; font-size: 11pt;">
<span style="font-family: Arial, sans-serif; font-size: 9pt; color: rgb(153, 0, 255);"><a href="https://outlook.office.com/bookwithme/user/e7ed510b338643a092fb237960b6be17@ucf.edu/meetingtype/V46-JYn9vEWmqVPIUyuevA2?anonymous" id="OWA0bbd5e5b-6d29-3e39-51de-ba7620844d4d" class="OWAAutoLink" title="Original URL: https://outlook.office.com/bookwithme/user/e7ed510b338643a092fb237960b6be17@ucf.edu/meetingtype/V46-JYn9vEWmqVPIUyuevA2?anonymous. Click or tap if you trust this link." data-auth="NotApplicable" data-loopstyle="linkonly" style="color: rgb(153, 0, 255); margin-top: 0px; margin-bottom: 0px;">Schedule
Appointment</a></span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;"> </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: black;"> </span></p>
<div style="padding: 3pt 0in 0in; border-top: 1pt solid rgb(225, 225, 225);">
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);"><b>From:</b> Eril-l <eril-l-bounces@lists.eril-l.org>
<b>On Behalf Of </b>Electronic Resources in Libraries discussion list via Eril-l<br>
<b>Sent:</b> Thursday, January 25, 2024 4:37 PM<br>
<b>To:</b> eril-l@lists.eril-l.org<br>
<b>Subject:</b> [Eril-l] Setting up SUSHI Harvesting for Usage Data Collection Streamline</span></p>
</div>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);"> </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);">Hello. </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);"> </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);">I am curious how to start the process of setting UP Sushi in a much needed attempt to streamline our data collection. </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);"> </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);">I am looking on
<a href="https://www.niso.org/" id="OWA1d4069fe-6f4d-e2e2-2bc7-52822b6c1724" class="OWAAutoLink" data-auth="NotApplicable" data-loopstyle="linkonly" style="margin-top: 0px; margin-bottom: 0px;">
https://www.niso.org/</a> but still not sure what needs to come first and what questions I need to ask before we get too far ahead of ourselves. </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);"> </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);">In the past we have not used SUSHI Harvesting and I would like to incorporate this and see if it will assist our data collection process. </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);"> </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);">Any insight would be greatly appreciated. </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);"> </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(0, 0, 0);">Many thanks. <br>
--</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="font-family: Georgia, serif; font-size: 14pt; color: rgb(26, 26, 26);">Tracy M. Cole</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="font-family: Georgia, serif; font-size: 14pt; color: rgb(26, 26, 26);">Assistant Librarian, Acquisitions</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="font-family: Georgia, serif; font-size: 14pt; color: rgb(26, 26, 26);">USA Libraries Collections</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="font-family: Georgia, serif; font-size: 14pt; color: rgb(16, 60, 192);"><a href="mailto:tmcole@southalabama.edu" id="OWA56cd7caa-8821-7086-046f-96586c79617f" class="OWAAutoLink" data-loopstyle="linkonly" style="margin-top: 0px; margin-bottom: 0px;">tmcole@southalabama.edu</a></span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="font-family: Georgia, serif; font-size: 14pt; color: rgb(26, 26, 26);">P: (251) 461-1563</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="font-family: Georgia, serif; font-size: 14pt; color: rgb(26, 26, 26);">—</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="font-family: Georgia, serif; font-size: 14pt; color: rgb(2, 32, 91);">University of South Alabama</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="font-family: Georgia, serif; font-size: 14pt; color: rgb(2, 32, 91);">Marx Library </span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="font-family: Georgia, serif; font-size: 14pt; color: rgb(2, 32, 91);">5901 USA Drive North</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="font-family: Georgia, serif; font-size: 14pt; color: rgb(2, 32, 91);">Mobile, AL 36688</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="font-family: Georgia, serif; font-size: 14pt; color: rgb(16, 60, 192);"><a href="https://www.southalabama.edu/libraries/" id="OWA669bc230-951c-6aee-f16d-f4368c648c97" class="OWAAutoLink" data-auth="NotApplicable" data-loopstyle="linkonly" style="margin-top: 0px; margin-bottom: 0px;">https://www.southalabama.edu/libraries/</a></span></p>
<p style="margin: 0px 0in 0in;"><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><img id="x__x0000_i1025" style="width: 0.5763in; height: 0.4166in; margin-top: 0px; margin-bottom: 0px;" src="https://ci3.googleusercontent.com/mail-sig/AIorK4zrufsgeL5MQZxpG6cZ3sEEITDtAP9_lbJie-zRhF5j9Xt2D_tjR5sPeuNJV01Cxzk9YJLkmq4"></span></p>
</body>
</html>