JSTOR Update

1. Overview and Context

This procedure updates the InvoiceNinjaJSTOR_Country and JSTOR_Institution 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

SalesJSTOR datasends perout producta canmonthly beemail convenientlyreminders generatedto undervincent@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 "Reports,"Publisher organizedReports" from the upper right admin drop down menu.

You need both the Book Usage by InvoiceCountry Item.and Productby numbersInstitution in InvoiceNinja correspond to PBNs.reports.

InvoiceNinjaJSTOR delivers CSVXLSX files. They suck.

3.2 Clean

3.2.1 Country Report

• Open in LibreOffice

Sort by invoice number
deleteChange rowsReporting withPeriod non-bookTotal datainto YYYY-MM-01 format
convert Product column to text, append 0 to PBNs fix InvoiceDate to 20XX-XX-01 fix price by removing $ sign deleteDelete table header rows. saveSave 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 "InvoiceNinja"JSTOR_Country"

Upload Institution report into phpMyAdmin table "JSTOR_Institution"

4. Additional Information

5. Document Control

Document ID	PRO-036037
Document Owner	Vincent
Version	1.0
Last Date of Change	March 26, 2026
Next Review Due Date
Version & Change Tracking