Setting up route database – Wavetronix Command Translator (CMD-DT) - User Guide User Manual
Page 55

54
CHAPTER 4 • ROUTES PAGE
˽
User Name / Password – Login information for the database connection
˽
Routes – Allows you to select a route to use in the trip time calculation.
The Adv. Trip component contains one property, Segment Table, which represents the table
name in the database to use for segment data.
Note
Using advanced trip times may require setting up the database tables ahead of
time—see the next section, Setting Up Route Database.
The Translator advanced trip time system contains a number of actions that can be used
between the Adv. Trip and DB components—for most travel times, however, the DC Import
action will be used, with one property for the Collector host name.
The end result of the task will be an XML file containing all travel time information for
the route, including the travel time per segment, and individual travel times for any travel
points defined in the route. When a route is selected using the Routes property on the
Route >> Adv.Trip action, the route output file will be automatically registered with the
Translator website, so that data will be displayed on the Web whenever the trip time is run.
Setting Up Route Database
The Translator Advanced Travel Time System requires a SQL Server database with a specific
table for storing segment data. The database and table can be given any name since these
fields are configurable, however typically these names are used:
Database: TravelTime
Table: Segments
The easiest way to create the database is to use the SQL Server Management Studio. Just
connect to the proper database server, right click on Databases and select New Database.
The following creation script may be used to create the table with the proper name and
fields. Connect to the proper server and select the appropriate database, then create a New
Query, paste in the following table creation script and then press the Execute button.
<<<<< Begin Script - Copy below this line >>>>>
USE [TravelTime]
GO
/****** Object: Table [dbo].[Segments] Script Date: