📊 Local Backup
Local Backup
Download all traceability data as a spreadsheet for offline records
Download all traceability data as a spreadsheet for offline records
📊 Batch Overview
No batches recorded yet. Start by adding a Production Log entry.
Index of all batches. Summary auto-populated from Production Log and Release Log.
| Batch # | Date | Fish (kg) | Molasses (kg) | Citric Acid (kg) | Final pH | Status |
|---|
📑 Batch Register
Master list of all batches. Click Edit to modify or Delete to remove duplicates. Batches are auto-created when a Production Log entry is saved.
| Batch # | Date | Fish (kg) | Molasses (kg) | Citric (kg) | Salt (kg) | Final pH | Status | Release Date | Notes | Actions |
|---|
🧪 Batch Production Log
A. Batch Identity
B. Ingredients
Enter fish mass and ingredients to see recipe-ratio and vessel-fill checks.
C. 2nd Molasses Addition (if applicable)
D. Citric Acid Additions
E. Foam Log
F. Supporting Documents
Tap to upload or drag images/PDFs (invoices, batch labels, certificates)
📋 Production Log History
| Batch | Date | Operator | Fish (kg) | Molasses (kg) | Citric (kg) | Salt (kg) | EM-1 (L) | Water (L) | Images |
|---|
📦 Input Register
New Input Entry
Supporting Documents
Upload invoices, certificates, declarations (PNG, JPEG, PDF)
Input Log
| Material | Supplier | Contact # | Date Recv | Cert Type | Expiry | Lot Ref | Standard | Compliant |
|---|
🌡 pH & Temperature Monitor
pH Target Reference
| Checkpoint | Target pH | Criteria |
|---|---|---|
| Day 0 (Initiation) | < 4.2 | Acidification with citric acid (4.2 or above = out of range) |
| Day 2 (48-hour) | 3.8 - 4.0 | Rapid acidification check (above 4.0 = out of range) |
| Day 3 (72-hour) | 3.6 - 3.8 | Continued fermentation (above 3.8 = out of range) |
| Day 5 | 3.5 - 3.7 | Above 3.7 = out of range |
| Week 1 / Day 7 | 3.6 - 3.8 | Above 3.8 = out of range |
| Week 2 / Day 14 | 3.6 - 3.8 | Above 3.8 = out of range |
| Release / Day 21 | < 4.0 | MANDATORY for release (4.0 or above = FAIL) |
New pH Reading
pH Log
| Batch | Checkpoint | Date | Time | pH | Temp | pH Status | Citric (ml) | Notes |
|---|
✅ Batch Release Authorisation
ECOCERT: Each batch must pass ALL criteria before release: (1) Final pH < 4.0 at Day 21, (2) Authorisation signature. A failing batch must be marked HOLD and must NOT be applied.
New Release Entry
Release Log
| Batch | Date | pH | pH Met | Volume (L) | Decision | Auth By | Auth Date | Report |
|---|
🔧 Server Setup Guide
Step 1: Upload Files to Your Server
- Upload
oo-traceability.htmlandapi.phpto the root of your website (e.g.oceanicorganics.co.za/) - Both files must be in the same directory on the server
Step 2: Server Requirements
- PHP 7.4+ (most shared hosting includes this)
- SQLite3 extension enabled (usually enabled by default)
- The web server user must have write permission to the directory (for creating
data/anduploads/folders)
Step 3: Configure API URL
- Enter your API URL below (the full URL to api.php on your server)
- Click Save & Test to verify the connection
Step 4: Verify
- The connection indicator in the header should turn green
- The database and folders are created automatically on first connection
- Data is accessible from any device that can reach your server
Automatic Folders Created
data/— contains the SQLite database (protected from direct web access)uploads/— stores uploaded images and documents
Troubleshooting
- If connection fails, check that
api.phpis accessible at the URL you entered - Ensure your hosting provider supports PHP and SQLite
- Check folder permissions: the web server needs write access
- If using cPanel, the
data/folder should be outsidepublic_html/for best security