<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
<div style="padding-bottom: 10px; padding-top: 5px;">
<div style="padding:12px; border:1px solid #8D3970; background-color:#F7F9FA; color:#8D3970; font-size:14px; line-height:22px; font-family: Calibri, Arial, Helvetica, sans-serif;">
<strong>CAUTION:</strong> This e-mail originated outside the University of Southampton.
</div>
</div>
<div>
<p><font size="2" face="sans-serif">Hi James,</font><br>
<br>
<font size="2" face="sans-serif">great work, thank you!</font><br>
<br>
<font size="2" face="sans-serif">We added R&P contract information to our Journal Database JDB just very recently.</font><br>
<font size="2" face="sans-serif">Example for a record: </font><a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.jdb.uzh.ch%2Fid%2Feprint%2F36085%2F&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324912367%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=rDN2jomSoH99O%2FRbpQQOBi67WAVBtzwLMDhwZBwuZ1E%3D&reserved=0" originalSrc="https://www.jdb.uzh.ch/id/eprint/36085/" shash="dCHCPd9Yu2bxeqoetM8ZJC7U/Kgq0W4uHvR4KrQq36dHuV+x9SE11cv5h6XaaarRqMdw5MocN3la5eLbqZUVny9Gt9084ugHn7uQX7CUn+TPC5SLfLifjBDpuWDoHPu+Nv59lOV6ISuDzcH4bGB9FKiTL2qdPcI5SVb2ROxlHro="><font size="2" face="sans-serif">https://www.jdb.uzh.ch/id/eprint/36085/</font></a><font size="2" face="sans-serif"> (see at bottom of page).</font><br>
<br>
<font size="2" face="sans-serif">Also, in our repository ZORA, we use a script that uses DOI / article title / contract year list to match the R & P contract data in JDB and add it to the repository record. This information also goes into our recently built
Open Access Monitor (will be publicly accessible in June, see </font><a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftube.switch.ch%2Fvideos%2FGzzsVOcMbU&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324912367%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=4HfI53C8tpdn2l1cPL7MPGym%2BXUTdsYaMnNigZi7sn8%3D&reserved=0" originalSrc="https://tube.switch.ch/videos/GzzsVOcMbU" shash="QEIOQ6aq34sB0B6oXZihaT+TyaLjZcBsApQafz7sqdEOQ3e8yYaz9M/5bgpJY/WlBvOnyfMf3E0Zb5e61kdBd+lZTRWx+VXOgDMaAlcofLsk3D92yTXXbv7dH5BvliTIKTLH5qCYeI+5HTAnZidbBilnJ5otD26JjDluizsHGvU="><font size="2" face="sans-serif">https://tube.switch.ch/videos/GzzsVOcMbU</font></a><font size="2" face="sans-serif">, demo starts at 9'09'').</font><br>
<font size="2" face="sans-serif">The script has found some interesting things - for about 10% of the 2020 articles, the PDF was missing in the repo. For another 15% of the list, the repo item was completely missing. Requires workup by a librarian and also better
information of the researchers / submitters will be necessary (R&P contracts are still very new at University of Zurich).</font><br>
<br>
<font size="2" face="sans-serif">The missing puzzle piece will be a lookup component in the upload section of the repository that tells the submitter: "Hey, there is a R&P contract available for this journal. Please check if article is covered and if you can
upload the published PDF." Your database would be of great value for this (at least for UK libraries).</font><br>
<br>
<font size="2" face="sans-serif">Cheers,</font><br>
<br>
<font size="2" face="sans-serif">Martin</font><br>
<br>
<br>
<img width="16" height="16" src="cid:1__=4EBB0C46DFB0F8778f9e8a93df938690918c4EBB0C46DFB0F877@lotus.uzh.ch" border="0" alt="Inactive hide details for "James Kerwin via Eprints-tech" ---13/05/2021 16:14:13---CAUTION: This e-mail originated outside the "><font size="2" color="#424282" face="sans-serif">"James
Kerwin via Eprints-tech" ---13/05/2021 16:14:13---CAUTION: This e-mail originated outside the University of Southampton. Hi All,</font><br>
<br>
<font size="1" color="#5F5F5F" face="sans-serif">Von: </font><font size="1" face="sans-serif">"James Kerwin via Eprints-tech" <eprints-tech@ecs.soton.ac.uk></font><br>
<font size="1" color="#5F5F5F" face="sans-serif">An: </font><font size="1" face="sans-serif">eprints-tech@ecs.soton.ac.uk</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Datum: </font><font size="1" face="sans-serif">13/05/2021 16:14</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Betreff: </font><font size="1" face="sans-serif">[EP-tech] Red and Publish Table</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Gesendet von: </font><font size="1" face="sans-serif"><eprints-tech-bounces@ecs.soton.ac.uk></font><br>
</p>
<hr width="100%" size="2" align="left" noshade="" style="color:#8091A5; ">
<br>
<br>
<br>
<font size="2" color="#8D3970" face="Calibri"><b>CAUTION:</b></font><font size="2" color="#8D3970" face="Calibri"> This e-mail originated outside the University of Southampton.
</font><br>
<font size="3" face="serif">Hi All,</font><br>
<br>
<font size="3" face="serif">For once I offer something instead of asking for something.</font><br>
<br>
<font size="3" face="serif">I was tasked with gathering all of the journal info for those journals that are part of "read and publish" deals and create some sort of searchable table.
</font><br>
<br>
<font size="3" face="serif">Here it is:</font><br>
<br>
<a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flivrepository.liverpool.ac.uk%2Fpublishers.html&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324922364%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=hOCqjpo0oLIDX5yLffkuhkEKSlaxFhh8c2wvRh86n1I%3D&reserved=0" originalSrc="https://livrepository.liverpool.ac.uk/publishers.html" shash="zn8CGDwZAobjZz7h7QcxOPGVo6I0B150GaTUR7gKoC8iq1QkchXRtMjPVGTweQ4hKHuMlzhwBi5uNjyTwdVO6X0W/eiQP9LL+n1PTrFY8TNmbU25jsC3nJqkdwxnan1z/GlndZIQIkS49AS0TlHI1+AcerJkxyfMNWW646syCeQ="><font size="3" color="#0000FF" face="serif"><u>https://livrepository.liverpool.ac.uk/publishers.html</u></font></a><br>
<br>
<font size="3" face="serif">The hardest part, by far, has been the gathering of data. Lots of mini web scrapers etc. and far too much manual checking. To save somebody else the effort in future, the data I've found so far is here:</font><br>
<br>
<font size="3" face="serif">JSON: </font><a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flivrepository.liverpool.ac.uk%2Fjson%2Freformatted_json.txt&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324922364%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=yrWG8oUs5QoS%2FqsrkW57dB280YbpOCHaqsqBXaTNnIA%3D&reserved=0" originalSrc="https://livrepository.liverpool.ac.uk/json/reformatted_json.txt" shash="xuVBes9Lmr4HRMBy3k7NQdSOWLyYjpYladX6GPI5RhiPhl5z3H4vQ8iuhALvDOiWI5EKBe/m1Estssei24K7KaauUwG9Qz8Xoxk7GPRqkz78wEn+eMr4f7h3nHQ5Dh2h8SQuOucqCfTMdG+4y6uOxgGqtx3YlNEBWfNwS3G+x2o="><font size="3" color="#0000FF" face="serif"><u>https://livrepository.liverpool.ac.uk/json/reformatted_json.txt</u></font></a><br>
<font size="3" face="serif">Tab Delimited (e.g. open in excel if you like): </font>
<a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flivrepository.liverpool.ac.uk%2Fjson%2Freformatted.txt&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324932359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=2RPaL24T7imRhZAeo%2BWyhIJra7aBuFBwHv7n%2Fymz38Q%3D&reserved=0" originalSrc="https://livrepository.liverpool.ac.uk/json/reformatted.txt" shash="YBaJROmmBILOvyCx8zEHvh2TN19vq8lZQb+peXfO6lO0AeRVv4mRY1CwNsAynD4bpunjzhoqxi4GF8ZPN8L6DSfvHeLoyRwWJnyMw06HV2VbLGSe96QWTJE8jPrgch4GzO/EJm2L+3u4+39YajLv6kUHapIbr5inRn/yFj/iq4c="><font size="3" color="#0000FF" face="serif"><u>https://livrepository.liverpool.ac.uk/json/reformatted.txt</u></font></a><br>
<br>
<font size="3" face="serif">I used this to create the table:</font><br>
<br>
<a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdatatables.net%2Fexamples%2Fdata_sources%2Fajax.html&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324942351%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=6NqZi8pF9R6QcT4UrBHpyuo9GSHjt%2B6GdWEUlqJJS0A%3D&reserved=0" originalSrc="https://datatables.net/examples/data_sources/ajax.html" shash="UdC4Xb3fzs+GpDp9BeJpLu7XFt/gkBpV1O+PkL3ccsLE0DqoAE/4M1OcabldQSGeMMrGfHsFnI60c/7STfD6Rp8+yf2nV4I60WPkqsk8jq0z5kmFBv5tKKa50Uqn0LeAEJOYg+qfAR8BTUt5MuKHSNQFVJPPzdNn+arkiv9sTns="><font size="3" color="#0000FF" face="serif"><u>https://datatables.net/examples/data_sources/ajax.html</u></font></a><br>
<br>
<font size="3" face="serif">Specifically using Ajax/JSON to store/access the table data.</font><br>
<br>
<font size="3" face="serif">This comes with no guarantee that the data is correct, but most of it is. If anybody wants to try making this and needs any help, let me know, although I anticipate this would be a breeze for many members on the list.</font><br>
<br>
<font size="3" face="serif">Thanks,</font><br>
<font size="3" face="serif">James</font><tt><font size="2">*** Options: </font></tt><tt><font size="2"><a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a></font></tt><tt><font size="2"><br>
*** Archive: </font></tt><tt><font size="2"><a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324942351%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=YTrT17b9O5PZFGzWU5QKHTjM%2F9UmTJUqCJkg5gzIcDo%3D&reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="FOT39Zgw9ixa1EWcAi7Hql1iJpdxuyvYSmwcNtinREhWz/9+JdU2xldhemlixXkndV8BN9j3Xw2WZvamjD/+Ep2+KAZqyOzjiOjEdtUxUwN4RHvCjJe2ETwI9x/LH8CANnP8SGEzYBArIi8raOZowOefcLhfS2keJhtgucPYBbI=">http://www.eprints.org/tech.php/</a></font></tt><tt><font size="2"><br>
*** EPrints community wiki: </font></tt><tt><font size="2"><a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9cad351c70cc4b19d26a08d916a49051%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637565718324952344%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=ObFLv1moMk0XMKhWInlQ1NYUFdc1ue%2BAJZF%2BVtxM3zM%3D&reserved=0" originalSrc="http://wiki.eprints.org/" shash="rPMeTGTk9867gWHg5ssI4sPwoSWHBjMWV2WTQbVzY0Z9MeYCHzCRajP2Bd5kqjRqnyg2CR+ICJot05zcj/v7Lw+x6Po0O19DVIQlm6sq/ekoPaodFRcu62DvXPCHus+X1FsRYetcrjQ/CmBNOrp3iGoB3BZNN6HKfO5M+87IzOI=">http://wiki.eprints.org/</a></font></tt><br>
<br>
</div>
</body>
</html>