Bulk Import / Upload

You can now bulk import / upload your own data to each module using .csv spreadsheets.

Bulk Importing / Uploading requires using the SPECIFIC .csv template for the SPECIFIC module. You can not use an excel (.xlsx, or .xls) file.

Bulk Importing /Uploading is available for the following modules:

Aed's
Assets (Items)
Cameras
Computers
Equipment
Firearms
Firearms (Off Duty)
Tasers
Vehicles

Historically if you had a bunch of new radios, tasers, or vehicles, you would send us the data and we would upload that data for you. You can now do this yourself using our new bulk import pages.

Bulk Importing / Uploading

Within each module, if you are a Manager for that module, you will see a Import XXXX button next to the Add XXXX button.

Click the Import XXXX button which takes you to the new Bulk Import page.

You MUST follow the instructions.

Step 1: Download our CSV template. (each module has a SPECIFIC template you MUST use)

Step 2: Fill in your equipment data (Year, Make, Model, etc.) - do not add OR remove columns.

Step 3: Save as .csv and upload.

Step 4: Review your data to be imported. If you see any errors or issues, go back to STEP 2

Step 5: Click Import Equipment Data.

Type, Make, and Model are Required

In Service, Active, Archive, Work Order will default to Zero if not set (1 = Active/On/True | 0 = In Active/Off/False)

Types, Makes, Models, Units, Vendors, Funding, look for EXACT matches and will create NEW values as indicated if the value does not exist

Dates should be in the format: 1/2/25

Only specific columns are available for import - assigning to employees or vehicles must be done AFTER export on the Manage Equipment page

Max number of rows you can import at a single time is 500

If you receive an error message in your attempt to upload, please email us with the exact error message and we can assist.

Common Issues

If you have extra rows or columns, you will receive errors.

If you have dates in columns designed for text, you will receive errors.

If you deleted or re-arranged columns, you will receive errors.