Project MUSE Update

1. Overview and Context

This procedure updates the JSTOR_Country and JSTOR_InstitutionPROJECT_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

JSTORSomewhere sendshalfway outeach amonth, monthlyMuse email reminders to vincent@punctumbooks.com with a link togenerates the downloadusage report,data butfor the linksprevious month. They can be downloaded in itthe arebackend.

currently

broken.Click So"Reports Logan InStatistics – Usage Statistics" in tothe JSTOR,top menu. Click "Run Statistics," then "Data Export." Enter the pertinent year, month, select "country" "institution," and selected"CSV," then click "PublisherSubmit." Reports" from the upper right admin drop down menu.

You need both the Book Usage by Country and by Institution reports.

JSTOR delivers XLSX files.

3.2 Clean

3.2.1

Project CountryMUSE Reportdelivers 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)
  
• ChangeAppend Reporting1 Periodcolumn Totalto intothe left, add date in YYYY-MM-01 format
  
• Delete tablecolumn headerP rows.

"punctum Save as text CSV, comma-delimited

3.2.2 Institution Report

Open in LibreOffice
Change Reporting Period Total into YYYY-MM-01 format
books" Delete table header rows. SaveCheck asall textrows CSV,have comma-delimitedproper
column count (because of comma issue)

3.3 Upload

• Upload Country report into phpMyAdmin table "JSTOR_Country"

Upload Institution report into phpMyAdmin table "JSTOR_Institution"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