GovWorx can receive Incident data on a recurring basis via CSV files transferred securely using SFTP. GovWorx hosts the SFTP server in AWS GovCloud requiring FIPS 140-2 compliant secure connections.
SFTP Connection Setup
GovWorx will generate and share an SSH private key with customer to securely connect to the server. To connect to the server and upload files use the following Connection Details. The screenshot below uses Cyberduck to test the connection.
When fully setup the customer agency should use a process that automates uploading new Incident data on a timed interval such as every 1 hour.
Connection Details
Host: 160.1.177.153
Port: 22
Username: Shared Securely Separately
SSH Private Key: Shared Securely Separately
Generate SSH Keys
The SFTP server is running in AWS Gov Cloud.
For security reasons, we only support SSH Keys. Customers will be the only holder of the SSH private key, and all GovWorx needs is the public key.
Here is a help article on how to generate those key. You keep hold of the private key and share the public key back with GovWorx Account Manager so they can finish setting up the SFTP connection.
Incident SFTP File Format
GovWorx has the ability to map the column order and transform fields sent in. A transform could be used to remove leading or trailing characters, shorten incident numbers and more.
It is expected that a single incident will have multiple rows in the file. For instance, if an incident has multiple notes and multiple responders then it is normal for there to be many rows for that one incident. The application will group the incident based on whatever column maps the SysId.
CAD Data Elements
Information on data fields required and recommended can be found here.