Working the A to Z List enhance journal access in the OPAC

1. Working the A to Z Listenhance journal access in the OPAC Janet Yanosko, Patrick Armatis http://library.umd.umich.edu

2. 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 IUG 2005: Managing Access to E-Journals (I4, P5)

3. 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” IUG 2005: Managing Access to E-Journals (I4, P5)

4. 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 IUG 2005: Managing Access to E-Journals (I4, P5)

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

6. Why not change—use multiple bibs for each format? • Change? What’s that? (Just kidding…sorta) • Convince librarians they’re wrong • Cost IUG 2005: Managing Access to E-Journals (I4, P5)

7. 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 IUG 2005: Managing Access to E-Journals (I4, P5)

8. IUG 2005: Managing Access to E-Journals (I4, P5)

9. 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 IUG 2005: Managing Access to E-Journals (I4, P5)

10. 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? IUG 2005: Managing Access to E-Journals (I4, P5)

11. IUG 2005: Managing Access to E-Journals (I4, P5)

12. IUG 2005: Managing Access to E-Journals (I4, P5)

13. IUG 2005: Managing Access to E-Journals (I4, P5)

14. IUG 2005: Managing Access to E-Journals (I4, P5)

15. How: gather & export data • Create a list of records to which an 856 will be added • Export OCLC numbers and 245|a fields IUG 2005: Managing Access to E-Journals (I4, P5)

16. 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 IUG 2005: Managing Access to E-Journals (I4, P5)

17. 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=BL7GJ4YV9N&S=T_M&C= IEEE+design+%26+test+of+computers$zCheck for U of M Dearborn online access IUG 2005: Managing Access to E-Journals (I4, P5)

18. How: convert data • Use Terry Reese’s MarcEdit 4.5 to convert text records to MARC recordshttp://oregonstate.edu/~reeset/marcedit/html/index.html IUG 2005: Managing Access to E-Journals (I4, P5)

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

20. 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 “&”) IUG 2005: Managing Access to E-Journals (I4, P5)

21. 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 IUG 2005: Managing Access to E-Journals (I4, P5)

22. What our solution gets us • Screens are ^will be less 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 IUG 2005: Managing Access to E-Journals (I4, P5)

23. 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 IUG 2005: Managing Access to E-Journals (I4, P5)

24. IUG 2005: Managing Access to E-Journals (I4, P5)

25. IUG 2005: Managing Access to E-Journals (I4, P5)

26. Why is this a good solution? • Patrons like it • Reduction in work for: • Serials • Reference • Systems • Can avoid changing our record structure • Inexpensive IUG 2005: Managing Access to E-Journals (I4, P5)

27. 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 IUG 2005: Managing Access to E-Journals (I4, P5)