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
- Upload Country report into phpMyAdmin table "JSTOR_Country"
- Upload Institution report into phpMyAdmin table "JSTOR_Institution"
- select Import tab;
- select file
- click "Go."
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 |