CVreviewTool

A tool designed to help librarians research self-archiving policies around faculty publications, and aggregate those results in a tidy, edit-able PDF or HTML report that can be sent directly to faculty. For institutions conducting "CV reviews", this workflow likely sounds familiar. The tool is web-based, with a MySQL backend, and pulling in publisher policies via the SHERPA/RoMEO freely available API.

Installation Instructutions:

Edit configuration files

• rename config/app_config.php.example to app_config.php, changing values where desired
• rename config/db_config.php.example to db_config.php, reflecting the database, username, and password created in MySQL

Prepare MySQL

• Log into mysql with as root or with administrator privileges.
• Create database:
  • CREATE DATABASE CVreviewTool;
• Create user:
  • GRANT ALL PRIVILEGES ON CVreviewTool.* TO CVreviewTool@localhost IDENTIFIED BY '[PASSWORD FROM config/db_config.php]';
• Create tables:
  • Navigate to 'db' directory
  • Create tables: mysql -u [USERNAME CREATED] -p [DATABASE CREATED] < db_structure.sql

Set Permissions:

• Set permissions for directories where files are written to:
  • sudo chown -R www-data:www-data articles cvs pdfs tmp

Troubleshooting:

Can't upload CV's?

You might need to increase the PHP "upload_max_filesize" variable in your php.ini file.

License

This utility is freely available and adaptable under CC-BY license.