JSTOR Update
1. Overview and Context
This procedure updates the InvoiceNinja table in the SQL Database.
2. Triggers
The execution of this procedure is usually triggered by
3. Steps to Be Performed
3.1 Download
Sales data per product can be conveniently generated under "Reports," organized by Invoice Item. Product numbers in InvoiceNinja correspond to PBNs.
InvoiceNinja delivers CSV files. They suck.
3.2 Clean
- Open in LibreOffice
- Sort by invoice number
- delete rows with non-book data
- convert Product column to text, append 0 to PBNs
- fix InvoiceDate to 20XX-XX-01
- fix price by removing $ sign
- delete table header
- save as text CSV, comma-delimited
3.3 Upload
- Upload into phpMyAdmin table "InvoiceNinja"
4. Additional Information
5. Document Control
| Document ID | PRO-036 |
| Document Owner | Vincent |
| Version | 1.0 |
| Last Date of Change | March 26, 2026 |
| Next Review Due Date | |
| Version & Change Tracking |