Importing your data

Estimated reading time: 3 minutes

This guide will help you bring your data into the system using the provided Excel templates. Whether you’re importing security staff, patrol sites, or equipment, the process is the same: open the template, add your data, and your file is ready to be imported into the system.

Think of the template as a form — you fill it out, and the system takes care of the rest.

Start with the Right Template

We offer three import templates:

Equipment: https://ocbuild.blob.core.windows.net/imports/equipment_import_example.xlsx
People: https://ocbuild.blob.core.windows.net/imports/person_import_example.xlsx
Places: https://ocbuild.blob.core.windows.net/imports/place_import_example.xlsx

Always use these official templates when preparing your data. Don’t create your own spreadsheet. The system requires the exact format provided to import successfully.

Required Fields and Template Structure

Some columns in the template may not apply to your organization, and that's okay.
However:

Do not remove or rename any columns.
The system relies on the exact column layout. If you delete or change a column, the import will fail or your data will map incorrectly. To successfully import data, the following fields must be filled in:

Display Name
Type
State

Note: Type and State must match the values used in the app exactly (same spelling and capitalization). If you don’t have data for the other columns, simply leave those cells blank.

Need a custom field? Add it at the end

If you track something extra — e.g. AssignedPatrolSector or FirearmLicenseExpiry — add it as a new column at the very end of the sheet (after the last existing column).
Important: the column header must match the custom field name exactly (including upper/lower case, no extra spaces).

Field-type rules

Dropdown-like columns (like Department, Type, State) usually accept only exact system values.
- Example: if system values are Operational / Under Maintenance / Decommissioned, you must use those exact spellings and capitalization.
- Multi-value dropdowns (if any) should use commas to separate values: AccessCard,Keys.
Boolean values (per dev instructions): must be true, false, or left blank.
- Example column you might use this for: IsArmed (use true or false).
Location columns: Latitude, Longitude — use decimal degrees (e.g. 48.208174, 16.373819). Gps Zoom is typically a number (leave blank if you’re unsure).
Text or ID fields: Display Name, Number, Serial Number, Title, etc. — free text but keep consistent formatting.

When you finish filling in the template, just save it as an .xlsx file. Make sure no columns were removed, custom fields (if any) are added only at the end, and your dropdown and boolean values follow the exact format. Once that’s done, your file is ready to be imported into the system.

Importing data into your Operations Cenetr system

Now that the excel template are filled with the rigjt type of details, youa re ready to import everything into Operation sCneter. to do that:

1. Open the Swagger Page for Your Region

Choose the link that matches your region:

🇺🇸 US (East): https://api.us-east.ops.center/swagger/index.html?urls.primaryName=Resources+API
🇨🇦 Canada (Central): https://api.ca-central.ops.center/swagger/index.html?urls.primaryName=Resources+API
🇪🇺 Europe (West): https://api.eu-west.ops.center/swagger/index.html?urls.primaryName=Resources+API
🇦🇺 Australia (East): https://api.aus-east.ops.center/swagger/index.html?urls.primaryName=Resources+API

2. Authorize Yourself

Click the “Authorize” button in the top-right corner and log in using your Operations Center account credentials.

3. Choose the Correct Endpoint

Depending on what you want to import, select the appropriate endpoint:

Equipment: POST /v2/tenants/{tenantId}/equipment/imports
People: POST /v2/tenants/{tenantId}/people/imports
Places: POST /v2/tenants/{tenantId}/places/imports

Click “Try it out” on the endpoint.

4. Fill in the Required Fields

tenantId: Enter your system ID.
You can find it in your Operations Center URL, e.g.:
https://us-east.ops.center/systems/00000000-0000-0000-0000-000000000000/portal/operations
→ Your system ID is the GUID after /systems/.
format: Enter xlsx.
body: Click “Choose File” and upload your Excel file.

5. Execute the Import

Click “Execute” to start the import process.

Notes & Troubleshooting

If there’s an issue with your data, the response will explain what went wrong.
For large files (over 1000 resources), the request may time out. Don’t worry—the import will continue in the background.
We recommend keeping files under 5000 resources to avoid delays.

Need Help?

If you're still having trouble, email your prepared files to oc-support@genetec.com.
Please include the following in your message:

Your region
Your system name
Your system ID