settings.txt

The settings file instructs Workload Modeller on:

  • Expected formats when reading in incidents and callouts. This includes Date format and Incident number formatting.

  • Overlay output settings like Symbol, scale and CRS

This txt file is included with Workload Modeller installation and can be found in C:\Program Files\Cadcorp SIS Desktop 9\Addins\Workload Modeller (x64)

Data Loader
DataFileExtension csv  
DataFieldSeparator ,  
DataHeaderRow Yes  
DataIncidentNumberScheme Retain  
Data Loader
DataFileExtension text i.e. txt, csv, etc.
DataFieldSeparator    
DataHeaderRow YES  
DataDateFormat

Variable Width in format string:

yyyy-mm-dd-HH-MM-SS

Note:

  1. case sensitivity;
  2. decimal seconds are not supported;
  3. "-" is a generic separator (spaces are not allowed in parameter values)
  4. If omitted, defaults to dd-mm-yyyy-HH-MM-SS and allows for -SS to be absent.
DataIncidentNumberScheme NONE YY YYYY  
DataIncidentsAndCalloutsCombined Yes True Note: specify DataFieldCallsignIncidentNumber rather than DataFieldIncidentIncidentNumber
IncidentNumberStripLeft integer  
DataFileEncoding Unicode, utf8, utf7, ASCII

In cases where the data files to be read are not purely 'plain text' but contain ‘non-ASCII’ characters e.g. é, or have Unicode encoding, the default (unspecified) encoding is not adequate and an encoding value must be specified.

Example:

DataFileEncoding = unicode

If the value is not one listed in the column to the left or if the line is omitted from settings.txt then Workload Modeller will use the default encoding.

Note: this setting and its value are not case sensitive, e.g. UNICODE = unicode = UnIcOdE.

Incident Data Columns
DataFieldIncidentIncidentNumber integer Mandatory
DataFieldIncidentStation integer Mandatory
DataFieldIncidentStart integer Mandatory
DataFieldIncidentEasting integer Mandatory
DataFieldIncidentNorthing integer Mandatory
DataFieldIncidentTypeOriginal integer Mandatory
DataFieldIncidentStop integer  
DataFieldIncidentTypeActual integer  
DataFieldIncidentNumRescues integer  
DataFieldIncidentNumInjuries integer  
DataFieldIncidentNumDeaths integer  
DataFieldIncidentLifeRiskMain integer  
DataFieldIncidentLifeRiskSub integer  
DataFieldIncidentLifeRisk integer  
DataCheckIncidentColumns integer  
DataFieldIncidentPropertyType integer

This is the number of the column in the incident data file used to populate the Workload Modeller column: tblIncidents.PropertyType.

Example:

DataFieldIncidentPropertyType = 12

If the value is set to 0 or if this line is omitted from settings.txt then property type data will not be read. See Property Type.

Callout Data Columns
DataFieldCallsignIncidentNumber 1  
DataFieldCallsignVehicleId 2  
DataFieldCallsignVehicleAssigned 3  
DataFieldCallsignVehicleMobilised 4  
DataFieldCallsignVehicleInAttendance 5  
DataFieldCallsignVehicleReleased 6  
Miscellaneous Settings
ViewGPointScaleOverride Decimal Number  
ViewSymbol Circle i.e. circle, diamond, etc.
Excel Formatting Settings
ExcelStationNames Yes True  
ExcelStationIdsRotate Yes True  
ExcelChartHeight integer
ExcelChartWidth integer