The implementation and application of coral an open source erm system
1 / 27

The Implementation and Application of CORAL: an open source ERM system - PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

The Implementation and Application of CORAL: an open source ERM system. Jia Mi Yongming Wang VALE 2012 Annual Users’ Conference January 5, 2012. CORAL: Open Source ERM System. What is ERM System About CORAL - Centralized O nline Resources A cquisitions and Licensing

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Presentation

The Implementation and Application of CORAL: an open source ERM system

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

The Implementation and Application of CORAL: an open source ERM system

Jia Mi

Yongming Wang

VALE 2012 Annual Users’ Conference

January 5, 2012

CORAL: Open Source ERM System

  • What is ERM System

  • About CORAL

    - Centralized Online Resources Acquisitions and Licensing

  • Implementation

  • Application

What is ERM System

“Tools for managing the license agreements, related administrative information, and internal processes associated with collections of licensed electronic resources.”

Ellen Duranceau, June 2005 issue of Against the Grain

What to look for in an ERM system

  • TCNJ Library

    • FTE: 6424 (mostly undergraduate)

    • Library e-Collection:

  • - e-books (7,062)

  • - e-journals (63,361 unique)

  • - databases (93)

    • Library System: Voyager

Why TCNJ Needs ERM System

Current Practice


Web Alerts Form/Email

Binders/Paper folders


No evaluation



Current Practice

Current Practice




Not linked

Serials Solutions

Serials Solutions/EBSCO EJS

Excel files

Email/In person




Current Practice

Current Practice

Excel/Catalogue/Not recorded

Local file/Intranet







Email/Not recorded

Not recorded/Local File

Email/Local File


Local file


Centralized Online Resources Acquisitions and Licensing

  • Why we choose CORAL

  • - Web-based applications and functions- Open source, free

  • - Technology: (Apache)/PHP/MySQL,

  • - Truly Modular: all five modules are both independent and interoperable.

    • - Customization: implementation and application

  • - Support:

    • - Online documentation: User’s/Technical/Installation Guide

    • - Listserv communication (about 160 members)

    • - Online Live Demo

    • - Continuous development and bugs fixing

  • Implementation

    • Platform: Windows or Unix/Linux?

    • Technical Skills Required

    • Downloading the CORAL package

    • Installation

    • Customization


    • (Apache)/PHP/MySQL

    • Unix/Linux is preferable

    • TCNJ implementation: Ubuntu Linux Server version 10.4 on Dell PowerEdge 2900 Server. (note: remember to include GUI part when installing Ubuntu)

    • Advantages of Ubuntu:

      • Open source, free

      • Easy to install and maintain

      • And the best is: Apache/PHP/MySQL ready to use

    Technical Skills Required

    • Basic Unix/Linux commands (e.g. ls, cd, rm, mkdir, cp, chmod); vi skill is a plus but not necessary

    • Basic web application/Internet infrastructure (e.g. Understand the Document Root)

    • Minimum PHP/MySQL knowledge

    • If you really hate command line, Ubuntu has everything GUI

    Downloading the CORAL Packages

    • It’s called “Checkout,” by using SVN

    • SVN stands for Subversion: it’s a repository system with software versioning and revision control

    • Use a SVN client. We use TortoiseSVN

    • After installing TortoiseSVN, on Windows Explorer, right click and choose SVN check out, then copy over the svn url from CORAL website.

    • Check out each module (called package, e.g. resources package) separately.

    • After checking out the CORAL package, copy the whole package to your server under the document root

      • Examples: On Ubuntu, copy coral “resources” package to /var/www/coral/resources/; copy coral “licensing” package to /var/www/coral/licensing/


    • Two ways to install

      • Web install: recommended. Run each module installation from ../coral/module-name/install/index.php

      • Manual install: when web install fails

    • Under the hood: run the sql script to create and populate the database tables


    • Create Users

    • Due to lack of authentication module at this moment, we need to hard-code the Login ID in user.php

    • CORAL starting page (optional), called “main” package

    • Application customization: later Jia’s part

    CORAL Applications

    Resources Module

    Resources Module: Product Details, Local Notes, Alerts and Feedback

    CORAL: Resources Module

    Resources Module: customization fields for local use

    Licensing Module

    Licensing Module: documenting terms

    Licensing: Documenting Details

    License: Customization for local use

    CORAL: Organizations (Publishers, Providers, Vendors, Aggregators, Consortium, etc. )

    CORAL: Usage Report (JR1)

    CORAL Applications: customization

    • Locally edit/change/add variable fields values

    • Flexible: add free text for special situations

    Benefits of Using CORAL

    Questions ?

    Thank You !

    Yongming Wang

    Systems Librarian

    TCNJ Library

    Jia Mi

    Electronic Resources/Serials Librarian

    TCNJ Library

  • Login