SJ/JEI_Import_Documents-App
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
JEI_Import_Documents-App/data/review/ocr
History
Mavis 006a324081 feat: OCR scanned PDFs and capture all 11 missing stock codes 
- Installed Tesseract OCR via winget
- Added scripts/ocr_invoices.py to OCR all PDFs via PyMuPDF
- Updated extract_invoices.py to fall back to OCR text for scanned pages
- Fixed stock-code regex to match "qty + code" pairs only (avoids spurious
  matches like bare TCT in invoice headers)
- Added merge step to combine multi-page proformas into single invoice records
- All 11 previously-missing codes now in PB:
  JEITCS12, JEITCS18, JEITCS22, JEITCL22, JEITCL92,
  JEICS17, JEICS19, JEICS27, JEICS30, JEICS34, JEICS14-P1
- Only JEITCS50 remains unlisted (genuinely never ordered)

PB now: 19 invoices, 158 stock codes, 281 line items
2026-09-18 06:12:30 +02:00
..
1.Invoice_29.05 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
1.Suppliuer Invoice feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
2.Supplier Invoice feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
2568 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
154923 Supplier Invoice feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
155655 Supplier Invoice feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
155743 Supplier Invoice feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
156092 Supplier Invoice feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
156703 Invoice feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
157610 Supplier Invoice feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
157611 Supplier Invoice feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
doc100189 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Invoice feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Invoice 161453 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Invoice 161453 from JEI DRILLING & CUTTING SOLUTIONS LTD - 14_04_2026 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Invoice 161454 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Invoice 161852 from JEI DRILLING & CUTTING SOLUTIONS LTD - 29_04_2026 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI 154923 89.10+102 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI 155655 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI 156092 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI Drilling Invoices feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Invoice 147842 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Invoice 161611 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Invoice 162609 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Invoice 162923 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Invoice 163374 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Proforma 148931 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Proforma 151346 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA PROFORMA 151778 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA PROFORMA 151779 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Quote 150731 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI Supplier Invoice feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
newdoc10018920260413143327_001 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
newJEI Drilling Invoices (1) feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Supplier Invoice feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Supplier Invoice12326 feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Supplier Invoices feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
1.Invoice_29.05.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
1.Suppliuer Invoice.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
2.Supplier Invoice.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
2568.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
154923 Supplier Invoice.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
155655 Supplier Invoice.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
155743 Supplier Invoice.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
156092 Supplier Invoice.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
156703 Invoice.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
157610 Supplier Invoice.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
157611 Supplier Invoice.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
doc100189.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Invoice 161453 from JEI DRILLING & CUTTING SOLUTIONS LTD - 14_04_2026.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Invoice 161453.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Invoice 161454.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Invoice 161852 from JEI DRILLING & CUTTING SOLUTIONS LTD - 29_04_2026.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Invoice.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI 154923 89.10+102.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI 155655.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI 156092.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI Drilling Invoices.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Invoice 147842.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Invoice 161611.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Invoice 162609.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Invoice 162923.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Invoice 163374.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Proforma 148931.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Proforma 151346.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA PROFORMA 151778.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA PROFORMA 151779.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI SA Quote 150731.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
JEI Supplier Invoice.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
newdoc10018920260413143327_001.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
newJEI Drilling Invoices (1).txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Supplier Invoice.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Supplier Invoice12326.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00
Supplier Invoices.txt feat: OCR scanned PDFs and capture all 11 missing stock codes 2026-09-18 06:12:30 +02:00