Wavetronix Command Translator (CMD-DT) - User Guide Bedienungsanleitung Seite 55

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 156
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 54
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.
e 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.
e 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.
e end result of the task will be an XML le containing all travel time information for
the route, including the travel time per segment, and individual travel times for any travel
points dened in the route. When a route is selected using the Routes property on the
Route >> Adv.Trip action, the route output le 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
e Translator Advanced Travel Time System requires a SQL Server database with a specic
table for storing segment data. e database and table can be given any name since these
elds are congurable, however typically these names are used:
Database: TravelTime
Table: Segments
e 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.
e following creation script may be used to create the table with the proper name and
elds. 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:
Seitenansicht 54
1 2 ... 50 51 52 53 54 55 56 57 58 59 60 ... 155 156

Kommentare zu diesen Handbüchern

Keine Kommentare