Sue,

There is a lot of information available about this at
http://www.library.cornell.edu/cts/elicensestudy/home.html, including data
structures others have used.

Dalene
<*><*><*><*><*><*><*><*><*><*><*><*><*><*><*><*><*><*><*><*><*><*><*>
Dalene Hawthorne, Serials Librarian
Serials Department
Stanford University Libraries
Stanford, CA  94305-6004; U.S.A.
phone: +1-650-725-1122; fax: +1-650-723-4775
email: daleneh@stanford.edu
http://library.stanford.edu/depts/ts/tsdepts/seracq/sa_depts/serials

-----Original Message-----
From: SERIALST: Serials in Libraries Discussion Forum
[mailto:SERIALST@LIST.UVM.EDU]On Behalf Of Marshall, Susan
Sent: Wednesday, October 15, 2003 4:07 PM
To: SERIALST@LIST.UVM.EDU
Subject: Legacy system to manage print and electronic journals?

Has anyone developed a legacy system to keep track of your print and
electronic journal packages and individual subscriptions?
I am looking at creating a relational database with MySQL with a web
interface.  Has anyone done something like this?

Currently, we have a huge Excel spreadsheet with the info on it but it is
very inflexible as far as reporting goes.
Also, I am not interested in using Microsoft Access.
 Any other ideas?

(We are current satisfied Serials Solutions users and will keep them but
that system is limited as far as manipulating data and reporting goes.)
(Also, I am not happy with our subscription agent who is currently
"managing" our subscriptions. I think we could save a lot of money by
keeping track on our own.....)

Sue Marshall
Electronic Resources Librarian
Montana State University
Bozeman, MT 59715
(406) 994-4313
smarshall@montana.edu