Working the A to Z List

enhance journal access in the OPAC

Janet Yanosko, Patrick Armatis http://library.umd.umich.edu

Working the A to Z List

      The problem with finding journals Context Previous solution=lots of work What we came up with and how we did it Caveats Why it’s a good solution 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 2

Finding Journals is Hard

  Article databases are difficult to begin with We don’t make it much easier by requiring multiple searches to find the source journals • • • Article linker for some databases Search the catalog Ok, now search the “Online Journals List” 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 3

How UM-Dearborn handles multiple formats for Journals

 One journal, one bib record (mostly) • Decision was made long ago • • Librarians feel strongly about this Our students and faculty are used to it 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 4

Consequently:

 Importing large sets of MARC records is…complicated • • Deduplicating is a problem Limits on staff time 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 5

Why not change —use multiple bibs for each format?

   Change? What’s that? (Just kidding…sorta) Convince librarians they’re wrong Cost 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 6

Previous Solution:

 Maintain “web” locations in OPAC for online access (mainly ProQuest, JSTOR) http://wizard.umd.umich.edu/search/i?SEARCH=0014-1704  Try to get patrons to search twice for every journal title, once in the catalog, and again in the A-Z List 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 7

4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 8

Why this solution isn’t ideal

     Screens are confusing Time consuming for cataloging staff Out of date quickly Has never been comprehensive Does not provide information about journals that do not already have records in the catalog  Duplicates work done by Serials Solutions 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 9

Our Solution

  Looked around for a model: !

Can we do something similar in the catalog for the Journal Title level of access?  Can we quickly update all 856 fields each with slightly different links?

4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 10

4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 11

4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 12

4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 13

4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 14

How: gather & export data

  Create a list of records to which an 856 will be added Export OCLC numbers and 245|a fields 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 15

How: manipulate data (MS Access)

     Replace punctuation and non-alpha characters with URL Encoded versions (e.g., & %26) http://www.albionresearch.com/misc/urlencode.php

Add generic LDR Insert OCLC # into 001 Insert title into 245 Insert modified title into URL, replacing spaces between words in title with + signs 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 16

Sample record

=LDR 01467cam 2200349La 45'0 =001 ocm 10024072 =245 10$aIEEE design %26 test of computers =856 4\$uhttp://search.serialssolutions.com/?V=1.0&N=100&L=BL 7GJ4YV9N&S=T_M&C= IEEE+design+%26+test+of+computers$zCheck for U of M Dearborn online access 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 17

How: convert data

 Use Terry Reese’s MarcEdit 4.5 to convert text records to MARC records http://oregonstate.edu/~reeset/marcedit/html/index.html

4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 18

How: load data

 Create Serials Solutions load table • Protect all fields • • Match on OCLC# Insert Serials Solutions URL  Load file into catalog 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 19

Gotchas

  Load caused all headings to show up in heading reports A to Z search sometimes required the word equivalent of punctuation symbols (e.g., “and” instead of “&”) 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 20

Gotchas

 Some extra cleanup needed for titles with the same base name but different sub names • Physical Review A, B, C, D, E. 245|a for titles is simply Physical Review. A, B, C, etc is stored in subfield n. Used MS Access to list duplicate titles, then manually adjusted them 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 21

What our solution gets us

     Screens are ^ will be less Out of date quickly confusing Time consuming for cataloging staff Has never been comprehensive Does not provide information about journals that do not already have records in the catalog  Duplicates work done by Serials Solutions 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 22

Next phase

 Cleaning out old info from database • 856 links to specific databases, publisher sites • • Check-in records, 850 holdings, database-specific web locations Item records? We’re not sure yet.

 Add physical journal holdings to Serials Solutions profile 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 23

4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 24

4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 25

Why is this a good solution?

    Patrons like it Reduction in work for: • Serials • • Reference Systems Can avoid changing our record structure Inexpensive 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 26

Why might this be good for you?

   It’s fast, easy, and has low overhead Even if you employ some other solution, putting a Serials Solutions search in the 856 for print/microfilm records is a win-win It’s something that can be done while considering other options 4/29/2020 IUG 2005: Managing Access to E-Journals (I4, P5) 27