Imports

Review import-ready datasets, file placement guidance, table readiness, and pre-import checks for 4 P’s.

Customers
1
Properties
1
Plans
1
Inspections
8
Claims
1
Invoices
1
Payments
1

Inspections Required Checks

Expected Column(s) Resolved Column Status
customer_id / client_id customer_id OK
property_id / home_id property_id OK
inspection_number / title / name / reference_no Not found Missing

Inspections Optional Checks

Optional Column(s) Resolved Column Status
plan_id plan_id Found
status / inspection_status inspection_status Found
inspection_date / scheduled_date inspection_date Found
result / inspection_result Not found Missing

Import Rules

  1. Put imported PHP pages in the same main 4 P’s folder as your other app pages unless paths are intentionally rewritten.
  2. Verify the destination table exists before attempting any import routine.
  3. Prefer stable IDs for related records, especially customer_id, property_id, plan_id, inspection_id, claim_id, and invoice_id.
  4. Check required columns first, then optional columns, before importing batches.
  5. Back up your database before running large imports.
  6. Use system-status.php and audit.php after imports to confirm the data chain is complete.

Inspections Preview

inspections
ID Title / Reference Status Date
10 Record #10 in_progress