| Feature Creating an Internal Content Management
                        System
 By Greg Sennema
 
 Here at Calvin College, we created Hobbes, a hybrid of CMS and intranet that
  organizes Web site content and a variety of internal tools to help our librarians
  complete their daily tasks.
  When I became digital resources and reference/instruction librarian in 1999
  at the Hekman Library at Calvin College and Calvin Theological Seminary, one
  of my first tasks was to redesign the library's Web site. Like many of you
  who maintain Web links to library resources, I quickly learned that offering
  access to a large number of resources from an even larger number of static
  Web pages can never really be described as efficient or professionally fulfilling.
  In recent years, many libraries have created dynamic Web sites that are database-driven,
  that is, maintained and populated with content stored within what can be loosely
  termed a content management system (CMS). In 2001, Jed Koops, the Hekman Library
  systems programmer, and I created a CMS called Hobbes (library staff liked
  the play on the words "Calvin and Hobbes"). Since then, Hobbes has grown into
  a hybrid of CMS and intranet to include not only Web site content, but also
  a variety of internal tools used by librarians to help them complete some of
  their daily tasks.
  Hekman is a small academic library serving more than 4,200 students, 370
  faculty, and many community patrons. The majority of the library's 1.7 million
  items (books, e-books, journals, e-journals, microfiche, government documents,
  etc.) are spread across 100,000 square feet over four floors. Hekman employs
  the full-time equivalent of 17 staff, including eight professional librarians
  who also serve as liaisons to all of the college's 25 academic departments.
  Access to all library resources is provided through the online catalog (Sirsi),
  a digital media archive (Sirsi), and our Web site, the Hekman Digital Library
  (HDL). Since its creation in 1997, the HDL has grown from a mundane list of
  links and library information to the primary point of access to all of the
  library's resources. In 2001, I created the current version of the HDL.
  Calvin and Hobbes: Managing Our Content Online Hobbes is a Web-based tool that uses Common Gateway Interface (CGI) scripts
  written in Perl to store, query, and return results from data stored in a series
  of related SQL tables. Because it is Web-based, librarians can easily manage
  data without knowing Perl or SQL and can be authenticated into the system using
  the college's existing online directory. By authenticating through a continually
  updated college database of login names and passwords, we did not need to create
  our own. Users added to the Hobbes environment have immediate access without
  needing to remember yet another ID and password.
  As a CMS, I initially envisioned Hobbes as a tool to help me to efficiently
  manage the library's Web pages, specifically the growing number of subscription-based
  resources. In the months after Jed and I implemented Hobbes, we realized that
  it could be used to host tools that served the library's internal communication
  needs as well. Over the course of 2 years, we added tools as they were thought
  of and created, and placed them according to their function under tabs that
  are strung along the top of the Hobbes environment (see Figure
  1). Each librarian
  is given access to the tabs and tools she needs based on her profile within
  Hobbes. Here I will describe each tab and some of the major tools (or tables)
  placed within it. With each description, I have included our label in parentheses
  to help you compare what you are reading to the screen shots. To see how some
  of Hobbes' resources are displayed to the public, please visit the HDL at http://www.calvin.edu/library.
  Manager Tab (Manager) The Manager tab is used primarily by Jed and me to administer the contents
  within Hobbes. Since there are quite a few tools under the Manager tab (see
  Figure 1), I'll briefly explain a number of these before moving on to the functions
  of the other tabs.
  Databases (TofDbs): Each research database record stored in a table of databases
  (TofDbs) contains the following fields that allow the resources to be displayed
  on the HDL in a variety of helpful ways:
 
   	AlphabeticalBased on the first letter; can also include
      See Also references   	TypeCitation index, abstracts, full text   	AuthenticationWhether the resource is accessed through
      IP authentication, for free on the Web, on a CD-ROM, or through 
      a print index   	Full-text typeDescribes a database's full-text content,
      such as journal or newspaper articles, e-books, or even primary source
    historical documents   	VendorMost useful for our librarians   	SubjectIn our case, based on the college's academic disciplines   	Peer-reviewed/refereedHas a field where instructions
    can be included on how to limit a database search to peer-reviewed/
      refereed articles   	Citation examplesIncludes a field that shows examples
    of citation styles for material found in the database. We created a
      Web page on how to cite electronic resources, and this page displays a
    list of full-text databases. When clicked, it brings the user to an information
    page that offers examples of how to cite the full-text content. 
   	DescriptorsTerms that describe the database and its contents,
      making it possible for patrons to search for appropriate databases. However,
      we turned off the search feature on the HDL, because many patrons thought
    that by searching for a database, they were actually searching the
      contents of the database itself.  Microforms (TofMic): Web pages that describe our microform sets are stored
  as records in a table of microforms. In addition to a brief description of
  the microform set, each TofMic record includes detailed contents information.
  For some sets, this means a reel-by-reel description or a detailed bibliography.
  For sets that have individual MARC records in our online catalog, we display
  a WebCat search box that limits searches to the appropriate microform set.
  Reference (TofRef): The college's academic departments each have an assigned
  library liaison. One role of the liaison is to maintain a Web page that highlights
  library resources that are important to the department, such as databases,
  microform sets, and reference sets. Each liaison can add Web resources that
  she considers important for her departments.
  Staff (Staff): In addition to displaying staff information on the HDL, creating
  a table of staff members allows each of the librarians to be authenticated
  into Hobbes. Like TofDbs records, the staff record contains many fields that
  allow them to be used in a variety of ways:
 
   	Login name (based on the college's LDAP server)   	StatusLibrarian, support staff, student assistant   	Office location, office hours, and phone number   	ResponsibilityThese show up in the HDL's A-Z Index, so
      that users can look for, say, the cataloging librarian   	Birthday (so we all know when to expect treats!)   	Access levelThis determines the Hobbes tabs (and tables
      within the tabs) that each staff member has access to. For example, the
    circulation manager only has access to the Lib Hours, Minutes, and Lib Resources
    tabs.   A-Z Index of this Web site (A-Z Index): Entries that appear on the HDL's "A-Z
  Index of this web site" bring together records from several tables into one
  place, including the A-Z Index table, the TofDbs, TofMic, TofRef, and Staff
  table (see Figure 2).
  Icons (Icons): As Figure 2 shows, we made the A-Z Index more visually appealing
  after implementing a database of icons that is itself linked to from other
  Hobbes tables.
  E-journals (Ejournal): Based on the experience gained from implementing Hobbes,
  Jed and I decided to try our hand at managing our growing collection of e-journals.
  The Ejournal tool in Hobbes is designed to accept a collection in the form
  of batch loads of comma-delimited files (created from lists from aggregated
  databases and our own e-journal lists). Using a complicated script, the tool
  creates e-journal records for each title based on ISSN; any subsequent e-journals
  that are loaded as part of another collection are not added as unique records,
  but rather as a holding to the main e-journal record. Initially displayed to
  the public within a separate database called the E-journal Locator, we eventually
  figured out how to import these e-journal records into our online catalog,
  thereby offering our patrons one place to find all our journals, print or online.
  Passwords (Passwords): This table contains password records for resources
  that require login information, such as e-journals, database administrative
  modules, or database usage statistics. Creating one place for these allows
  the librarians to easily share this important information.
  Quotations (Quotes): The HDL home page displays a unique quote each time
  it is loaded, and each of these quotations is stored in the Quotes database.
  Additional tables control the "message of the day" (WebCat motd) that appears
  in the banner of our online catalog.
  Reference Desk Tab (RefDesk) The default Hobbes screen for the reference librarians is the RefDesk tab,
  which displays the tools they use while working at the reference desk. The
  top half of the screen displays any questions that have been submitted by a
  patron using the Ask a Librarian Web form. The librarian can choose to immediately
  answer a question or assign it to another librarian. (See Figure
  3.) Statistics
  for all these questions are internally tabulated and can be accessed in Hobbes'
  Stats tab.
  The bottom half of the RefDesk screen displays a RefBlog (a Weblog) where
  librarians post reference-related entries. RefBlog entries can also be tagged
  as sample reference questions to supply anecdotal evidence in statistical reports.
  All of the information within the RefDesk tab is searchable.
  Reference Desk Schedule Tab (RefDesk Sched) With constant shift changes being scribbled on the print copy of the reference
  desk schedule, or with shifts being missed because they could not consult the
  schedule from home, our librarians welcomed the addition of an online reference
  desk schedule in Hobbes (see Figure 4). Four weeks' worth of shifts are displayed
  at one time, and changes can be made simply by clicking on a librarian's name
  in a particular time slot.1
  Library Statistics Tab (Stats) Before Hobbes, librarians kept track of their own statistics in individual
  Microsoft Excel files, a program that many knew well enough to enter data into,
  but not well enough to creatively display or manipulate that data. Various
  statistical tables are included in the Stats tab, as is a utility to create
  reports based on date and other criteria.
  Library Meeting Minutes (Minutes) The Minutes tab displays folders that contain minutes from the various groups
  of library staff that hold regular meetings. After being completed in Microsoft
  Word, the secretary logs into Hobbes and uploads the minutes into the appropriate
  folder for future reference. Also, an e-mail with the attached minutes is distributed
  to staff members who have this preference selected in their staff table record.
  Library Resources Tab 
  (Lib Resources) While the librarians are able to share documents on a common drive on the
  campus network, it became apparent that some information could be better shared
  by being displayed within Hobbes. The Lib Resources tab contains a wide variety
  of links to resources such as a fund status report (used by liaisons to track
  departmental book budgets); employee policies; evaluation documents; and library
  labels, signs, and graphics.
  Library Hours Tab (Lib Hours) Hekman Library's hours are not easy to describe with text, so they are displayed
  on the HDL in a 2-month calendar format. After being incorporated into Hobbes,
  the tedious process of updating this Web page was replaced by a table that
  utilizes an existing calendar.
  Library News Tab (LibNews) After attending a session on RSS2 at the 2003 Computers in Libraries
  conference, it didn't take me long to wonder how we could incorporate this
  into Hobbes, and it took even less time for Jed to actually implement this
  feature. The LibNews tab displays information from RSS feeds, with the name
  of the feed on the left and the contents of the feed displayed within a box
  on the right.
  Database Maintenance 
  (DB Projects) This tab contains links to the administrative modules of five locally created
  databases.3 As with e-journals, records can be added, edited, and
  deleted, and bulk amounts of data can be imported using delimited files.
  Bookmarks (Bookmarks 
  on bar beneath the tabs) Since Hobbes displays information based on a librarian's login, we were able
  to add some tools that provided unique data for a given librarian. For example,
  each person is able to upload his or her browser bookmarks from the office
  computer to use at the reference desk or from home. Librarians are also able
  to upload liaison newsletters into Hobbes, which in turn are displayed on their
  HDL staff page.
  The Future of Hobbes Jed and I created Hobbes on the fly, with no blueprint for what the "product" would
  eventually become. Consequently, we gave many of the resources names and locations
  that made sense to us, but would potentially be quite confusing for the librarians
  who use the system, or for our successors were we to leave Calvin. ("Uh, what
  exactly is a 'Tofdbs_cit_label'?") With this in mind, most Hobbes tools have
  a text box for instructions that can uniquely identify the resource, and say
  why the tool was created and what HDL pages contain its dynamic data. (See
  Figure 1.) In the near future, I plan to flesh out these instructions as we
  consider plans to make Hobbes control the remaining HDL pages. From time to
  time, we find other ways of displaying the data, and as other tools are added,
  we rename, re-create, and reorganize some of the tabs.
  Even though Hobbes is yet another resource vying for attention in already-full
  schedules, it was not difficult to convince the librarians that Hobbes was
  something they should be using. They like that library information has been
  moved from files on a shared network directory to an environment where it can
  be stored, displayed, and manipulated for the benefit of both the library staff
  and the patrons we serve.
  The biggest challenges that we face are the maintenance required to keep
  Hobbes' information up-to-date and keeping the complex scripts working properly.
  Creating a CMS like Hobbes required extensive programming skills. Despite Hekman
  Library's relatively small size, I was fortunate that it also employed a systems
  programmer. Other libraries considering an undertaking like Hobbes would not
  only have to evaluate the skills of available employees, but also consider
  the time needed to create and maintain such a system.	
     
 
  
    | References
     1.	For additional information, see Sennema, Greg."      Managing the reference desk online." Reference
 Services Review 31 no. 3 (2003): 257263.
  2.	For additional information on RSS, see Tennant, Roy."      Feed your head: keeping up by using RSS."
 Library
        Journal 128 no. 9 (2003): 30.
  3.	You can find information on these five databases at http://www.calvin.edu/library/databases/index.stm.
        See 
  also Sennema, Greg. "  The Christian Reformed Church 
  Periodical Index: a local solution to indexing periodicals."
 Journal of Religious & Theological
  Information 5 no. 3/4 (2002): 119134.
  Further Reading       Adalian, Paul T. and Judy Swanson. "        Locally developed 
  web-enabled databases: new roles and opportunities
 for libraries."
 Reference Services Review 29 no. 3 
  (2001): 238253.
  Brown, Katrina L. and Anne M. Candreva."Managing 
  database-driven web content."
 Library Journal 
  netconnect (Fall 2002): 24.
  Browning, Paul and Mike Lowndes. "        Content management systems: who needs
        them?"
 Ariadne 30 December 
  (2001); http://www.ariadne.ac.uk/issue30/techwatch.
  Fagan, Jody Condit. "        Transition to a unified system: using Perl to
        drive library databases and enhance web site functionality."
 The Electronic
        Library 19 no. 3 (2001): 168179.
  Klein, Leo Robert. "        Your web sitemixing up web site management."
 Library
        Journal netconnect (Spring 
  2003): 28.
  Roberts, Gary. "        Designing a database-driven web site, or, the evolution
        of the Infolguana."
 Computers in Libraries 20 
  no. 9 (2000): 26.
  Westman, Stephen. "        Database-backed library web pages."
 The Electronic Library 19 no. 6 (2001): 424432.
   |  Greg Sennema is digital resources and reference/instruction librarian at Calvin
College and Calvin Theological Seminary in Grand Rapids, Mich. He holds a master's
of information studies from the University of Toronto. His e-mail address is
gsennema@calvin.edu.
 
 |