OPS — Setup Connection
Configure your local secure connection to the Cloudflare Worker proxy.
Worker Proxy URL
The endpoint of your deployed Cloudflare worker.
OPS Bearer Token
Long random access token to authorize writes.
Save & Connect
O
OPS — Hamilton Council Job Importer
Simpro integration · pilot run
Not connected
OPS Internal View
1. Work Type & File Upload
Select the rollout profile, option due date, and select the Excel xlsx sheet.
Rollout work profile
Drives Job Custom Field 3 and maps corresponding cost centres.
Commercial
Residential
→ 1 cost centre will be added:
Commercial data logger
Job due date (optional)
Specifies a uniform completion date across all imported rows.
⬆
Drop your Excel spreadsheet here, or click to browse
Accepts .xlsx format (first sheet will be read)
2. Preview & Validation Results
Review rows below. Sentinels (#N/A) and missing addresses are marked.
Clear
Import Valid Rows →
Total Rows
0
Ready (Valid)
0
Has Issues
0
Target Profile
Commercial
#
Group/Seq
Property Address
Primary Contact
Service Properties
Validation
3. Simpro API Import Stream
Sending batch requests...
Cancel
Created
0
Skipped (Exists)
0
Failed
0
Remaining
0
Retry Failed
Export Import Log (CSV)
View On Dashboard →