Data import Templates
Creation date: 6/3/2020 11:20 AM
Updated: 9/15/2022 3:22 PM
see the attached these are updated as of 3/19/2020
Knox updated 6/19/2020
Trouble shooting Knox import errors: Check the worksheet name 1st then column names
Category is not respected in the importer
Use the bulk updater to set the category correctly.
File Names:
OccupancyAdvanced
Geocode: Geo_OccupancyAdvanced_[dept_id]
Import: Import_OccupancyAdvanced_[dept_id]
Update: Update_OccupancyAdvanced_[dept_id]
OccupancyStandard
Geocode: Geo_OccupancyStandard_[dept_id]
Import: Import_OccupancyStandard_[dept_id]
Update: Update_OccupancyStandard_[dept_id]
Hydrant
Geocode: Geo_Hydrant_[dept_id]
Import: Import_Hydrant_[dept_id]
Update: Update_Hydrant_[dept_id]
Knox
Import: Import_Knox_[dept_id]
Update: Update_Knox_[dept_id]
OccupancyAdvanced (1).xlsx
OccupancyStandard (1).xlsx
Hydrant (1).xlsx
SLKnoxImportFormat_New.xlsx