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

Properties Required Checks

Expected Column(s) Resolved Column Status
customer_id / client_id customer_id OK
property_name / name / title / address / street_address Not found Missing

Properties Optional Checks

Optional Column(s) Resolved Column Status
address / street_address Not found Missing
city city Found
state / region state Found
zip / zip_code / postal_code postal_code Found
status / property_status status Found

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.

Properties Preview

properties
ID Title / Reference Status Date
1 Record #1 active