<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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Gill Sans MT";
panose-1:2 11 5 2 2 1 4 2 2 3;}
/* 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;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Gill Sans MT",sans-serif;
color:#404040;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.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"><span style="font-family:"Gill Sans MT",sans-serif;color:#404040">I use Excel’s conditional formatting function to compare two title lists from two databases. I matched on titles, not ISSN, but you could do ISSN if you wish. While we can
identify overlap for full text databases with our Proquest 360 products, we lack a tool to examine indexing only databases. I wanted to compare a database to Scopus to see what the overlap was. I plan to compare to Web of Science also. I place the Scopus titles
in one column and the other database’s titles in another column on the same spreadsheet. Then follow the directions.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Gill Sans MT",sans-serif;color:#404040"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Gill Sans MT",sans-serif;color:#404040">Here is the tutorial I used to figure this out. It took a few tries to get it right, but it works. I so wish I had known this years ago when we used to pull up lists in Excel
and run an eyeball comparison! <a href="http://www.excel-easy.com/examples/compare-two-lists.html">
http://www.excel-easy.com/examples/compare-two-lists.html</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Gill Sans MT",sans-serif;color:#404040"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:"Gill Sans MT",sans-serif;color:#404040">Chris LeBeau<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Gill Sans MT",sans-serif;color:#404040">University of Missouri-Kansas City<br>
<br>
</span><span style="font-size:9.0pt;font-family:"Gill Sans MT",sans-serif;color:#404040"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-family:"Gill Sans MT",sans-serif;color:#404040"><o:p> </o:p></span></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>Heather Shipman<br>
<b>Sent:</b> Friday, March 25, 2016 12:07 PM<br>
<b>To:</b> Erin Gallagher <EGALLAGHER@Rollins.edu>; eril-l@lists.eril-l.org<br>
<b>Subject:</b> Re: [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">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 border="0" width="59" height="74" id="Picture_x0020_1" src="cid:image001.jpg@01D186BE.D1DAA310" 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">Heather.shipman@cornell.edu</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> .<b><o:p></o:p></b></span></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 [<a href="mailto:eril-l-bounces@lists.eril-l.org">mailto:eril-l-bounces@lists.eril-l.org</a>]
<b>On Behalf Of </b>Erin Gallagher<br>
<b>Sent:</b> Friday, March 25, 2016 12:04 PM<br>
<b>To:</b> <a href="mailto:eril-l@lists.eril-l.org">eril-l@lists.eril-l.org</a><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>