Skip to main content

JSTOR Update

1. Overview and Context

This procedure updates the JSTOR_Country and JSTOR_Institution tables in the SQL Database.

2. Triggers

The execution of this procedure is usually triggered by

3. Steps to Be Performed

3.1 Download

JSTOR sends out a monthly email reminders to vincent@punctumbooks.com with a link to the download report, but the links in it are currently broken. So Log In in to JSTOR, and selected "Publisher 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 Country Report

    • Open in LibreOffice
    • Change Reporting Period Total into YYYY-MM-01 format
    • Delete table header rows.
    • Save as text CSV, comma-delimited

    3.2.2 Institution Report

    • Open in LibreOffice
    • Change Reporting Period Total into YYYY-MM-01 format
    • Delete table header rows.
    • Save as text CSV, comma-delimited

    3.3 Upload

    • UploadNavigate Country report intoto phpMyAdmin table "JSTOR_Country"
    • Uploadselect InstitutionImport tab;
    select country report intofile click "Go." archive files under Punctum Admin > Metrics > JSTOR
      Navigate to phpMyAdmin table "JSTOR_Institution"
      select Import tab; select institution report file click "Go." archive files under Punctum Admin > Metrics > JSTOR

      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
      Back to top