OAPEN 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
- Upload into phpMyAdmin table "PROJECT_MUSE2"
4. Additional Information
5. Document Control
| Document ID | PRO-037 |
| Document Owner | Vincent |
| Version | 1.0 |
| Last Date of Change | March 26, 2026 |
| Next Review Due Date | |
| Version & Change Tracking |