IUG 2001 Conference Proceedings

Table of Contents

Session: E10

Web Periodical List - Plus

Doris Hendrickson, Radford University

This program provided detailed instructions on creating an interactive periodicals list that includes both a library's cataloged journals and journals in aggregator databases for which the library has full-text access. Such a comprehensive list is a solution to the problem of users who are seeking a journal article, don't find a catalog record for that journal and believe they must go elsewhere to read the article when full-text access is actually available from an aggravator database for which the library has a subscription.

Attendees were shown the Radford University periodical list search form, currently available at http://lib.radford.edu/searchform.html. Searches of this periodical list were done to illustrate three situations:
  1. 1) Holdings in the library and 4 full-text databases
  2. 2) Holdings in databases only
  3. 3) Holdings for a cataloged electronic journal-no databases

After entering the journal title, patrons retrieve summary holdings for cataloged titles through a link to the catalog record and a list of aggregator databases that include that journal with coverage dates and search hints.

The requirements to provide a similar interactive periodical list include, an Innopac system with a Web OPAC and file transfer software, a Web server and PERL (Practical Extraction and Report Language). Perl software is available at (http://www.perl.com/pub/language/info/software.html) and Perl scripts with installation instructions are available in a zippered file from (http://lib.radford.edu/programs/). The book by Paul Hoffman, Perl for Dummies, now in a 2nd ed., was recommended to gain the skills to adapt the Radford Perl scripts for use by another library.

Next, Doris showed a chart that outlined the directories to install the scripts with editing requirements. This was followed by review of an overview chart that Doris created so that Technical Services at her library could take over the operation.

A summary overview of the process includes:

Innopac review file of all periodicals:
Output two "lists" with the following fields:
LIST #1: per245 LIST #2: per246 1. Print Item #1 > 245|a Print Item #1 > 246|a 2. Print Item #2 > OCLC Print Item #2 > OCLC
3. Print Item #3 > LOCATION Print Item #3 > LOCATION
4. Print Item #4 > CALL # Print Item #4 > CALL #
5. Print Item #5 > LIB. HAS Print Item #5 > LIB. HAS
6. Print Item #6 > 856 Print Item #6 > 856
Limit by: 245|a <> Limit by: 246|a
  • Send output to "file save" and transfer to the "formatting" directory - e.g., perlist
  • Run format.pl - outputs flat file. Each line is a single delimited record:
    (All fields except title and OCLC number are repeatable)
  • Title lists from aggregator database vendors o Download title lists and run scripts as specified on http://lib.radford.edu/programs/perlist.html o Run combinenew.pl to merge all database records Programs output flat files. Each line is a single delimited record: t=title(tab)db=database1|date1|database2|date2|database3|date3. (database|date pairs are repeatable) Final data file: periodicals.data o Run combineall.pl: merges Innopac data (periodicals.datatest) with database data (journals.data) into one final file: periodicals.data: t=title||r=oclc#||l=location||c=call#||h=holdings||u=url856u|856z|db=databas o Move periodicals.data to cgi-bin directory. This is the "live" data file searched by search.cgi. This program achieved its goal of providing a solution for "one stop shopping" for access to journal articles available from both cataloged journals and aggregator databases. Libraries that are interested in providing comprehensive Web periodical access with current holdings information should view http://lib.radford.edu/searchform.html. Duplicating the process to achieve a similar result for a library's own catalog will take systems expertise or assistance, but Doris, fortunately, has provided detailed instructions to achieve this user-friendly solution.

    Wendy Baia, University of Colorado at Boulder