Skip to main content

Project MUSE Update

1. Overview and Context

This procedure updates the PROJECT_MUSE2 table in the SQL Database.

2. Triggers

The execution of this procedure is usually triggered by

3. Steps to Be Performed

3.1 Download

Somewhere halfway each month, Muse generates the usage data for the previous month. They can be downloaded in the backend.

  • Click "Reports an Statistics – Usage Statistics" in the top menu.
  • Click "Run Statistics," then "Data Export."
  • Enter the pertinent year, month, select "country" "institution," and "CSV," then click "Submit."

3.2 Clean

Project MUSE delivers CSV files, but they don't contain proper date column. Also, commas inside editor columns create errors in displaying the CSV.

  • Open in LibreOffice (make sure to set encoding to UTF-8)
  • Append 1 column to the left, add date in YYYY-MM-01 format
  • Delete column P "punctum books"
  • Delete table header
  • Check all rows have proper column count (because of comma issue)

3.3 Upload

  • UploadNavigate intoto phpMyAdmin table "PROJECT_MUSE2"
  • select Import tab;
  • select file
  • click "Go."
archive files under Punctum Admin > Metrics > Project Muse

4. Additional Information

5. Document Control

Document ID PRO-039
Document Owner Vincent
Version 1.0
Last Date of Change March 26, 2026
Next Review Due Date
Version & Change Tracking
Back to top