<html>
<head>
<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>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi, all.</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I have completed work on a harvester for COUNTER 5.1 reports and views, and am making it available as open source at:</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<a href="https://github.com/Melissa-Belvadi-Library-Projects/C5.1_Harvester">https://github.com/Melissa-Belvadi-Library-Projects/C5.1_Harvester</a></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);">
It is built entirely in python and only uses 3 third-party python packages.</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
This version does not have a GUI, so you'd run it on a command line, but it's compatible with Windows, Mac, and Linux.</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Aside from the python interpreter itself, it does not requiring "installing" anything, just copying the files into a folder,</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
and everything involved in it stays within that folder/subfolders (eg it doesn't touch the Windows Registry).</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="text-align: left; text-indent: 0px; margin: 0px; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
My intended audience is librarians/staff who do not have access to a commercial harvester and are currently getting COUNTER reports one interactive vendor dashboard at a time.</div>
<div class="elementToProof" style="text-align: left; text-indent: 0px; margin: 0px; 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);">
It uses the SUSHI API to retrieve the reports in their SUSHI "json" format and does two things with them: it converts the json into tabular tsv files compliant with COUNTER 5.1 rules, and it also saves the data into a local sqlite database. This database is
similar to MS Access if you are familiar with that - no server involved, just a file on your hard drive that you can use with any SQL querying program (including MS Access). This allows you to query your usage across all of your vendors (or at least the COP5.1
compliant ones) and all report types. So for instance, if you want to know how many total ebook uses you had across all vendors/platforms, you can get that in seconds without having to open up all of the tsv reports one at a time.</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 have written extensive documentation in the github repository, and attempted to write everything to be intelligible to regular librarians, so you don't have to know anything about python to use it.</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 am also starting to build a "library" of sqlite queries that librarians might be interested in so you don't have to figure those out yourself. I'm happy to get requests to add to that. They are in the docs part of the repository.</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 will be working this summer with a UPEI CS student to develop a GUI.</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);">
If anyone would be interested in a webinar/demo online session, I would be happy to do some - just email me directly.</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);">
Or otherwise if you have any questions, feel free to contact me directly.</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);">
<br>
</div>
<div id="Signature" class="elementToProof">
<div style="background-color: rgb(255, 255, 255); margin: 0px;">
<div style="text-align: left; font-family: Arial, Helvetica, sans-serif; font-size: 9.75pt; color: rgb(32, 33, 36);">
<span style="background-color: white;">Melissa Belvadi</span></div>
<div style="text-align: left; background-color: white; margin: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 9.75pt; color: rgb(32, 33, 36);">
Collections Librarian</div>
<div style="text-align: left; background-color: white; margin: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 9.75pt; color: rgb(32, 33, 36);">
University of Prince Edward Island</div>
<div style="text-align: left; background-color: white; margin: 0px; font-family: Arial, Helvetica, sans-serif; color: rgb(32, 33, 36);">
<span style="font-size: 9.75pt;"><a href="mailto:mbelvadi@upei.ca" data-linkindex="0" data-loopstyle="linkonly" style="margin: 0px;">mbelvadi@upei.ca</a> 9</span><span style="font-size: 12.79px;">02-566-0581</span></div>
<div style="text-align: left; background-color: white; margin: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 12.79px; color: rgb(32, 33, 36);">
ORCID iD: 0000-0002-4433-0189</div>
<div style="text-align: left; background-color: white; margin: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 9.75pt; color: rgb(32, 33, 36);">
my <a href="https://outlook.office365.com/owa/calendar/0fbab27c909e4493be65313bd66d66b6@upei.ca/5fa60af92c6d451c9ddf90c0bb11e00f15552192987609852692/calendar.html" target="_blank" title="https://outlook.office365.com/owa/calendar/0fbab27c909e4493be65313bd66d66b6@upei.ca/5fa60af92c6d451c9ddf90c0bb11e00f15552192987609852692/calendar.html" rel="noopener noreferrer" data-auth="NotApplicable" data-linkindex="1" data-loopstyle="linkonly" style="margin: 0px;">
public calendar</a></div>
<div style="text-align: left; font-family: Arial, Helvetica, sans-serif; font-size: 9.75pt; color: rgb(32, 33, 36);">
<span style="background-color: white;"><a href="https://mbelvadi.youcanbook.me/" target="_blank" rel="noopener noreferrer" data-auth="NotApplicable" data-linkindex="2" data-loopstyle="linkonly" style="margin: 0px;">Make an appointment</a> via YouCanBookMe</span></div>
</div>
<div style="text-align: left; background-color: rgb(255, 255, 255); margin: 0px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: 9.75pt; color: rgb(32, 33, 36); background-color: white;">My pronouns are
</span><span style="font-family: "Google Sans", Roboto, Arial, sans-serif; font-size: 14px; color: rgb(31, 31, 31); background-color: rgba(68, 71, 70, 0.08);">ಅವರು/ಅವರನ್ನು</span></div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 9.75pt; color: rgb(32, 33, 36);">
<span style="background-color: white;">My emails are sent during the hours that I work and I understand that you will respond during the hours that you work.</span></div>
</div>
</body>
</html>