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

• Metrics

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

• Navigate to 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