<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=us-ascii">
<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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle19
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi, Erin,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’ve done this with ISSN matching using Microsoft Access. Cornell is a Voyager library, and our data queen designed an Access template that connects to all our Voyager tables, so I’m able to use Access to pull the data directly out of the
Voyager. I don’t know if you can connect like that to Alma (I’ve heard you cannot?), but you may be able to export the appropriate MARC fields out of Alma’s reports, into a spreadsheet, and then import that into an Access table.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">From Voyager, I pull the title and all the ISSNs for all our journals, and that’s one table in the Access file. (You’ll probably also want to pull whichever MARC fields indicate your holdings range, for later comparison.) You’d also import
the JSTOR list (which presumably includes ISSNs) as another table in your Access file, and then run a query that matches the two tables up by ISSN.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">It’s not going to work for any journal where there’s no ISSN at all listed in the MARC, so it’s not going to give a complete picture of how much overlap you have. I find that it catches about (*hand-waving*) 75% of the matches that really
exist. The MARC records that are missing ISSNs are generally pretty old ones.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Sometimes seeing just that much is enough to make a decision on, but if we need to be thorough, after doing that ISSN match, I’d generate a table of the JSTOR titles that
<i>didn’t</i> find a match yet, and I’d search those by hand. <span style="font-family:Wingdings">
L</span> At least it’s a smaller list at that point, though.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><img width="59" height="74" id="Picture_x0020_1" src="cid:image001.jpg@01D18695.581D0140" alt="Thumbnail2"><o:p></o:p></p>
<p class="MsoNormal">Heather Shipman<o:p></o:p></p>
<p class="MsoNormal">E-resources Acquisition Specialist<o:p></o:p></p>
<p class="MsoNormal">110 Olin Library, Cornell University<o:p></o:p></p>
<p class="MsoNormal"><a href="mailto:Heather.shipman@cornell.edu"><span style="color:#0563C1">Heather.shipman@cornell.edu</span></a> ; 607-254-1499<o:p></o:p></p>
<p class="MsoNormal"><span style="color:#44546A"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><i><span style="color:#C00000">Please use <a href="mailto:e-resources@cornell.edu">
<span style="color:#C00000">e-resources@cornell.edu</span></a> for invoices, licenses, activation notices, and other general account information.
<o:p></o:p></span></i></b></p>
<p class="MsoNormal"><span style="color:#C00000">For technical reasons, we are transitioning our departmental contact information away from
<a href="mailto:erlm-l@cornell.edu"><span style="color:#C00000">erlm-l@cornell.edu</span></a> , to be replaced by
<a href="mailto:e-resources@cornell.edu"><span style="color:#C00000">e-resources@cornell.edu</span></a> .</span><b><span style="color:#C00000"><o:p></o:p></span></b></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Eril-l [mailto:eril-l-bounces@lists.eril-l.org]
<b>On Behalf Of </b>Erin Gallagher<br>
<b>Sent:</b> Friday, March 25, 2016 12:04 PM<br>
<b>To:</b> eril-l@lists.eril-l.org<br>
<b>Subject:</b> [Eril-l] Tool for de-duping local ejournal holdings?<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hello collective wisdom,<o:p></o:p></p>
<p class="MsoNormal">We are exploring the possibility of subscribing to a couple of collections from JSTOR Arts & Sciences. These collections include around 500 journals with varying coverage dates. We assume that we have some level of coverage for some of
these journals through various other packages and aggregators. Short of searching for each of them in our URMS and manually checking our coverage against JSTOR’s list, we are not aware of a way to handle this in batch. Does anyone know of a tool or product
that would allow us to upload a file of our ejournal holdings and a file of JSTOR’s holdings and then generate a report on duplication of coverage? I know vendors can do this but I’ve never heard of such a thing for libraries. We use Ex Libris’ Alma/Primo.<o:p></o:p></p>
<p class="MsoNormal">Thank you in advance.<o:p></o:p></p>
<p class="MsoNormal">Erin<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="vertical-align:top"><span style="font-size:12.0pt;color:black">Erin Gallagher<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:top"><span style="font-size:12.0pt;color:black">Electronic Resources & Serials Librarian<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:top"><span style="font-size:12.0pt;color:black">Olin Library<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:top"><span style="font-size:12.0pt;color:black">Rollins College<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:top"><span style="font-size:12.0pt;color:black">1000 Holt Avenue<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:top"><span style="font-size:12.0pt;color:black">Winter Park, FL 32789<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:top"><u><span style="font-size:12.0pt;color:blue"><a href="mailto:egallagher@rollins.edu">egallagher@rollins.edu</a></span></u><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:top"><span style="font-size:12.0pt;color:black">(407) 975-6431<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:top"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="vertical-align:top"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="vertical-align:top"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="vertical-align:top"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>