InvoiceNinja 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 
 
 Metrics 
 
 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 
 
 Navigate to phpMyAdmin table "InvoiceNinja" 
 select Import tab; 
 select file 
 click "Go." 
 archive file under Punctum Admin > Metrics > 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