320 likes | 412 Views
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
E N D
Working the A to Z Listenhance 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 Fall MIUG: Working the A to Z List
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” Fall MIUG: Working the A to Z List
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 Fall MIUG: Working the A to Z List
Consequently: • Importing large sets of MARC records is…complicated • Deduplicating is a problem • Limits on staff time Fall MIUG: Working the A to Z List
Why not change—use multiple bibs for each format? • Change? What’s that? (Just kidding…sorta) • Convince librarians who see how patrons interact with the catalog that they’re wrong about how patrons interact with the catalog • Federated search products deduplicate results; why not the OPAC? Fall MIUG: Working the A to Z List
Previous Solution: • Maintain “web” locations in OPAC for online access (mainly ProQuest, JSTOR) http://wizard.umd.umich.edu/search/i?SEARCH=0014-1704 • Manually update holdings for online content providers • Try to get patrons to search twice for every journal title: once in the catalog, and again in the A-Z List Fall MIUG: Working the A to Z List
Why this solution isn’t ideal • Screens are confusing • Time consuming for cataloging & serials 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 Fall MIUG: Working the A to Z List
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? Fall MIUG: Working the A to Z List
How: gather & export data • Create a list of records to which an 856 will be added • Export OCLC numbers and 245|a fields Fall MIUG: Working the A to Z List
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 Fall MIUG: Working the A to Z List
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 Fall MIUG: Working the A to Z List
How: convert data • Use Terry Reese’s MarcEdit 4.5 to convert text records to MARC recordshttp://oregonstate.edu/~reeset/marcedit/html/index.html Fall MIUG: Working the A to Z List
How: load data • Create Serials Solutions load table • Protect all fields • Match on OCLC# • Insert Serials Solutions URL • Load file into catalog Fall MIUG: Working the A to Z List
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 “&”) Fall MIUG: Working the A to Z List
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 • Perhaps 222 field would have worked better? Fall MIUG: Working the A to Z List
If you can’t bring the mountain to Mohammed… • We decided to add non-electronic journals to the Serials Solutions profile Fall MIUG: Working the A to Z List
A little sleight-of-hand http://wizard.umd.umich.edu/search/j Fall MIUG: Working the A to Z List
A little sleight-of-hand /screens/srchhelp_ssj.html Fall MIUG: Working the A to Z List
A little sleight-of-hand /screens/srchhelp_ssj.html • The source code: <input type="radio" name="searching" value="http://search.serialssolutions.com/?V=1.0&L=BL7GJ4YV9N&S=T_B&C=" checked onclick="document.entry.SEARCH.focus()"> All online, print, and microfilm periodicals. <br> <input type="radio" name="searching" value="http://wizard.umd.umich.edu/search/j?SEARCH=" onclick="document.entry.SEARCH.focus()"> In library (print & microfilm) only. Fall MIUG: Working the A to Z List
A little sleight-of-hand /screens/srchhelp_ssj.html • Users don’t have to figure out which page to go to for finding journals; they decide at time of need which search to do • Native catalog search is still available if people need it Fall MIUG: Working the A to Z List
What our solution gets us • Screens are ^will be less confusing • Time consuming for cataloging & serials staff • Out of date quickly • Has never been comprehensive • Does not provide^s information about journals that do not already have records in the catalog • Duplicates work done by Serials Solutions Fall MIUG: Working the A to Z List
Next phase • Cleaning out old info from database • Check-in records, 850 holdings, database-specific web locations • Item records? We’re not sure yet. • Not sure what to do about dropdown menus which offer “periodical” search – OPAC and main web page Fall MIUG: Working the A to Z List
v. 16 1956 Fall MIUG: Working the A to Z List
Why is this a good solution? • Patrons like it • Reduction in work for: • Cataloging • Serials • Reference • Systems • Can avoid changing our record structure • Inexpensive Fall MIUG: Working the A to Z List
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 Fall MIUG: Working the A to Z List