|
The AVL Server can be configured to update an MS-SQL database table with the state of each vehicle. This information is then accessible by other applications. The database is update every 10 seconds with the identity, location, and other parameters related to each vehicle.
ConnectionString: SQL connection string required to connect to the database.
Table Name: Name of table in the database where state information will be written.
Minimum Requirements for Table Name
The state table must have the following fields:
Veh ID: Char10 Permanent ID associated with vehicle
ModemID: Char10 Low level internal ID associated with the modem (sometimes same as Veh ID)
IP: Char16 IP address of last GPS report received from this vehicle.
Latitude: Float Latitude coordinate of vehicle (Northern hemisphere = positive values )
Longitude: Float Longitude coordinate of vehicle (Western hemisphere = negative values)
FixTime: DateTime Date and Time of last valid GPS report
MPH: Int Current reported vehicle speed
Notes: VarChar256 Any other notes associated with this vehicle
Label: Char10 Text used to label this vehicle on map.
|
.png)
.png){kind=small}