Database maintenance
Check database size, compact heavy history, and prune old server backups.
| Database section | Records | Size |
|---|
Search customers, check coffee equipment availability, and see what needs attention.
Connection and version checks.
Connection: checking...
App version: checking...
Manage logos, company details, and document headers and footers.
Create database backups and full restore archives.
Automatic backup: ready
Recovery backups: ready
Full recovery backup creates a restore archive with the app files, settings, database, users, uploaded PDFs/signatures, templates, assets, and vendor files needed to rebuild the system on a fresh server.
See which backup folders are using server space before running cleanup.
| Backup area | What it contains | Files | Size | Latest file |
|---|---|---|---|---|
| Checking backup storage... | ||||
Use cleanup to prune old server backups using the app's safe keep rules. Keep the latest full recovery backup and one known-good older full backup before deleting anything manually.
Select old backup files to remove from the server.
| Backup area | File | Version | Date | Size | Status | |
|---|---|---|---|---|---|---|
| Click Refresh files to list backups. | ||||||
Restore database data, or follow the guide below for a full server recovery.
Warning: Restoring a backup will replace the current system data. Only continue if you are restoring to a test server or intentionally rolling back production.
Use the import button for downloaded database JSON backups only. To restore a downloaded FULL-*.tar.gz file, use the Disaster Recovery guide below.
Simple steps to rebuild the app if the server fails.
Users, security, templates, and database actions.
Configure safe app defaults and review locked workflow rules.
Edit the short help text shown from the question mark on each page.
Add, rename, hide, or restore values used for Coffee Gear dropdown fields. Used values are hidden instead of deleted so old records stay intact.
Upload Word templates and generate customer contracts from agreements.
No contract template uploaded yet.
| ID | Status | Date | Name | CIN7 | Source | Phone |
|---|
| ID | Status | Customer / site | Dates | Kg/Wk | Contract length in months | Total contracted kg | $/Kg | PPSR | PPSR status | Signed file(s) |
|---|
Select one or more equipment rows, then choose the customer to allocate them to.
| Lock | ID | Status | Item | Brand | Model | Serial | Customer | Install date | Funding | Depreciation Start Date | Instant write off | Purchase Cost (Ex GST) | Depn years | Residual | Current WDV | Lease monthly | Lease term | Auto CAPEX | Replacement Cost (Ex GST) |
|---|
Shows serial numbers allocated to more than one customer. Select the correct customer or unallocate the wrong record.
| Actions | ID | Status | Serial | Equipment | Current customer | Duplicate note |
|---|
| ID | Status | Item | Brand | Model | Serial | Funding | Replacement Cost (Ex GST) |
|---|
Select History on an equipment row to view its history.
| ID | Status | Agreement | Customer | Coffee gear | Install date | Return date |
|---|
| ID | Status | Agreement | Customer | Old item | New item | Date | Reason |
|---|
Reports, registers, customer packs, and internal reporting.
| Reference | Agreement | Date | Type | Customer | Equipment | Serial | Staff member |
|---|
| Contract class | Agreements | Customers | Kg/month | Value/month | Forecast kg | Forecast value |
|---|
| Customer | Site | Agreement | Type | Status | Term | Dates | Months | Kg/week | Kg/month | Price/kg | Value/month | Forecast kg | Forecast value |
|---|
| Customer | Site | Agreement | Agreement type | Status | Start date | End date | Contract length | Kg/week | Price/kg | Missing |
|---|