Data import Templates

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]


Creation date: 6/3/2020 11:20 AM      Updated: 9/15/2022 3:22 PM
Files   
OccupancyAdvanced (1).xlsx
184 KB
OccupancyStandard (1).xlsx
73 KB
Hydrant (1).xlsx
61 KB
SLKnoxImportFormat_New.xlsx
5 KB
New Client setup requests