Thanks, Dalene.
I am looking at something that will replace our subscription agent which
means print and electronic titles.  Most of the work on the website
respresents electronic journal management.  Maybe they can also include the
print....
I'll will look at it more carefully in the next few days.
Great resource page!

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

-----Original Message-----
From: Dalene Hawthorne [mailto:daleneh@STANFORD.EDU]
Sent: Thursday, October 16, 2003 8:14 AM
To: SERIALST@LIST.UVM.EDU
Subject: Re: Legacy system to manage print and electronic journals?

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