New Version of A to Z List

Hi ERMes Users,

I’m Jen Holman and I work with Galadriel and William at UW-La Crosse.  I know just enough about web-enabling Access databases to be dangerous, but somewhat helpful.  We use ERMes data as a backup when our A-to-Z list (currently powered by LibData from the University of Minnesota)  goes down.  Over the summer, I updated the existing ASP code to  The code is now much simpler and should be less taxing to your web server (which must be running at least ASP.Net 2.x).

Our page looks like this:

The data come from just three tables within ERMes:

To simplify matters, I created a new database (which lives on the web server) and pulled in just those three tables.  This database is in Access 2003 format with an .mdb extension.  To update the data, I just import the tables again.

The code is very simple as well:

I use SharePoint to load the database and page to our web server.  I am not sure what problems you may encounter loading this code, but please let me know.

I also have some questions for the ERMes community.  I wonder if any other campuses are using the older code?  Will you use the new code?  Is there additional functionality you would like to see in an a-to-z list?  Would anyone want to help develop new functionality, like paging?

Please respond in the comments.

A zip file containing the code and a sample database are available for download from the ERMes web site.

1 Response to “New Version of A to Z List”

  1. 1 Audria Kirkegaard December 12, 2010 at 8:45 pm

    Have been looking at doing some SEO and improving the design on my website for a long time, so this post has been very helpful. Easy read also, so thanks!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

ERMes Website

Download the latest version of ERMes, get instructions, etc.

Author Affiliations

Galadriel Chilton, Electronic Resources Management Librarian, University of Connecticut

William Doering, Systems, Catalog & Digital Initiatives Librarian, University of Wisconsin - La Crosse

Norma J. Dowell, Library Assistant IV, Iowa State University

Jen Holman, Periodicals & Acquisitions Librarian, University of Wisconsin - La Crosse

Anna Hulseberg, Academic Librarian, Gustavus Adolphus College

ERMes Users

Alverno College Library

Baker College

Beloit College

Bethel University

Birmingham City University

Canadian Agency for Drugs and Technologies in Health

Capella University

Cardinal Stritch University

Carleton College

Carroll University

Deerfield Academy

Drake University

Florida Institute of Technology

Georgia Perimeter College

Gustavus Adolphus College

Harrisburg Area Community College

Illinois Wesleyan University

Indian Institute of Management Bangalore

Iowa State University

Irish Research eLibrary

Lincoln University (Lincoln, New Zealand)

Loyola University Health Science Library

Manhattanville College

Monterey Peninsula College

National Science Foundation

Nicolet Area Technical College

Northern Michigan University

Northwestern College

Oakton Community College

Presbyterian College

Ripon College

Rivier College

St. Norbert College

Southwestern College

Springfield College

SUNY-Rockland Community College

Technical University of Denmark

University of Alabama in Huntsville

University of Idaho

University of the Pacific - Stockton

University of Wisconsin-Colleges

University of Wisconsin-Eau Claire

University of Wisconsin-Green Bay

University of Wisconsin-La Crosse

University of Wisconsin-Oshkosh

University of Wisconsin-Platteville

University of Wisconsin-River Falls

Viterbo University

Walden University

Wisconsin Department of Employee Trust Funds

ERMes Articles & Presentations

Presentation: The ERMes Story: A Work in Progress (Galadriel Chilton) part of Open to Change: Open Source and Next Generation ILS and ERMS
ALA Annual, Washington, DC, June 2010

Presentation: The ERMes Story: A Work in Progress (Galadriel Chilton)
Minnesota Innovative Users Group Conference, October 2009

Article: ERMes: Open Source Simplicity for Your E-Resource Management By William Doering and Galadriel Chilton
Computers in Libraries 29(8), September 2009

Presentation: Keeping It All Together: One Library's Strategy for Electronic Resource Management (William Doering)
WAAL, April 2009

Presentation: Getting a Handle on E-Resource Management: An ERM Panel (Galadriel Chilton)
Library Technology Conference 2009, March 2009

Article: A Locally Created ERM: How and Why We Did It By William Doering and Galadriel Chilton
Computers in Libraries 28(8), September 2008

August 2010

%d bloggers like this: