[Eril-l] Tool for de-duping local ejournal holdings?

[Le Beau, Chris]

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.

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! http://www.excel-easy.com/examples/compare-two-lists.html

Chris LeBeau
University of Missouri-Kansas City


From: Eril-l [mailto:eril-l-bounces at lists.eril-l.org] On Behalf Of Heather Shipman
Sent: Friday, March 25, 2016 12:07 PM
To: Erin Gallagher <EGALLAGHER at Rollins.edu>; eril-l at lists.eril-l.org
Subject: Re: [Eril-l] Tool for de-duping local ejournal holdings?

Hi, Erin,

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.

>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.

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.

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 didn't find a match yet, and I'd search those by hand. :( At least it's a smaller list at that point, though.

[Thumbnail2]
Heather Shipman
E-resources Acquisition Specialist
110 Olin Library, Cornell University
Heather.shipman at cornell.edu<mailto:Heather.shipman at cornell.edu> ; 607-254-1499

Please use e-resources at cornell.edu<mailto:e-resources at cornell.edu> for invoices, licenses, activation notices, and other general account information.
For technical reasons, we are transitioning our departmental contact information away from erlm-l at cornell.edu<mailto:erlm-l at cornell.edu> , to be replaced by e-resources at cornell.edu<mailto:e-resources at cornell.edu> .

From: Eril-l [mailto:eril-l-bounces at lists.eril-l.org] On Behalf Of Erin Gallagher
Sent: Friday, March 25, 2016 12:04 PM
To: eril-l at lists.eril-l.org<mailto:eril-l at lists.eril-l.org>
Subject: [Eril-l] Tool for de-duping local ejournal holdings?

Hello collective wisdom,
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.
Thank you in advance.
Erin

Erin Gallagher
Electronic Resources & Serials Librarian
Olin Library
Rollins College
1000 Holt Avenue
Winter Park, FL 32789
egallagher at rollins.edu<mailto:egallagher at rollins.edu>
(407) 975-6431





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20160325/83ef648d/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 11305 bytes
Desc: image001.jpg
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20160325/83ef648d/attachment-0001.jpg>