Date: Mon, 17 Apr 2000 10:29:43 -0500
From: "Pennington, Buddy" <buddy.pennington@ROCKHURST.EDU>
Subject: Re: Software question (Elinore Krell)

We also use Microsoft Access for the holdings database.  We created this by
downloading the title lists from the database vendors (Academic Universe,
Pro-Quest, JSTOR, and FirstSearch), and by having our library's holdings
imported in from an early database program the previous librarian was using
to create print lists that were located at the Reference Desk.

I then wrote ASP pages that allow our users to search for journals by exact
title, title phrase or keyword searching.  They can also select the source
they want to search (our holdings only, a specific database, etc.).  The
finished product is on our home page
(http://www.rockhurst.edu/3.0/services_and_resources/library/).  Select
'Periodical Holdings' on the left and try it out!  It contains over 15,000
records and we update the database holdings twice per year (in summer and
during Christmas break).

Since we put this up, a few weeks ago, we have taken all of our print lists
'out of circulation' except for 1 copy of our holdings that we keep at the
Reference Desk for when the computers go down.  If you want to use this
approach, you will have to find someone that knows ASP programming.  It's
not too difficult if you know JavaScript (ASP is a scripting language based
on Visual Basic).  It took me about 6 weeks to get to the level of the ASP
pages on our webpage.

Buddy Pennington
Acquisitions/Serials Librarian
Rockhurst University Greenlease Library
buddy.pennington@rockhurst.edu
#816-501-4143

> ---------- Forwarded message ----------
> Date: Thu, 13 Apr 2000 11:58:11 -0500
> From: Olga M. Majewski <majewski@bridgeport.edu>
>
> I have what may seem to be an odd request, but our library needs ONE
> alphabetical list of ALL the journals we offer our students and patrons in
> print, in microforms and in electronic format, to be offered in one place,
> a sort of "one stop shopping".  We have and in-house catalog and several
> journals accessible on-line, Ebsco, our agent has supplied us with the
> electronic list of journals, but that comprises only the ones we have on
> subscription with them. Is there a software "out there" that could
> simplify this major task of reuniting some 2000 journals in one easy
> access of all formats at once? Thank you for your help.
>