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...
Upload Word cover letters that use the same agreement fields and print as PDFs.
No cover letter template uploaded yet.
Manage logos, company details, and document headers and footers.
Create database backups and full restore archives.
Automatic backup: ready
Recovery backups: ready
Downloaded database backups contain the main customer, agreement, equipment and install database only. They do not include electronic-signing records, signed PDFs, or signing file storage. Use full recovery backup when you need a complete 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. Printable records PDF creates a human-readable hard-copy index of customers, linked agreements, equipment, and signed document references. Signed documents pack downloads the actual manual and electronic signed PDFs grouped by customer and agreement.
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: Database restores replace the current customer, agreement, equipment and install database only. They do not restore electronic-signing records, signed PDFs, or signing file storage. Use a full recovery backup for a complete server restore.
Use the import button for downloaded database JSON backups only. To restore electronic-signing records/files or 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 | Minimum Order Commitment | $/Kg | PPSR | PPSR status | Files |
|---|
| 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 |
|---|