Wavetronix Command Translator (CMD-DT) - User Guide User Manual

Command TranslatorUSER GUIDE

INTRODUCTION  COMMAND TRANSLATOR USER GUIDE 9Translation Jobs & ServicesTranslation tasks created in TaskBuilder are typically composed of mul

CHAPTER 9  TASKBUILDER COMPONENTS 99to log into the database. e username must have the appropriate rights for all the tables that the task will

100 CHAPTER 9  TASKBUILDER COMPONENTSle name cannot be found.Emaile Email component represents an email to be sent to a particular address conta

CHAPTER 9  TASKBUILDER COMPONENTS 101 NoteSome email systems require that the “From Address” be a recognized, valid email address on the network

102 CHAPTER 9  TASKBUILDER COMPONENTSFigure 9.6 – PDF Componente PDF component has the following properties:  File Name (Value—Filename) – e Fi

CHAPTER 9  TASKBUILDER COMPONENTS 103NoteIn the current version of TaskBuilder, only a specific set of Data components can be converted to 3 Card

104 CHAPTER 9  TASKBUILDER COMPONENTSsome examples:Place Holder Output Value[date] Nov_15_2008[time] 10_47_am[datetime] Jan_1_2008_8_03_ pm[dayofw

CHAPTER 9  TASKBUILDER COMPONENTS 105Figure 9.11 – Trip Time Componente Trip Time component has the following properties:  Start Name (Value—S

106 CHAPTER 9  TASKBUILDER COMPONENTSFigure 9.13 – Route Componente Route component has no properties.

In this chapter  Database-to-Database Action  Database-to-Data Action  Data-to-Database Action  Data-to-XML Action  Data-to-Text Action  Data-

108 CHAPTER 10  TASKBUILDER ACTIONStor as well as their corresponding properties.Database-to-Database Actione Database-to-Database (DB-to-DB) act

CHAPTER 10  TASKBUILDER ACTIONS 109Figure 10.2 – Database-to-Data Actione Database-to-Data action has the following properties:  Database (Val

110 CHAPTER 10  TASKBUILDER ACTIONSthe Database component, may contain a number of separate databases.  Table Name (Value—String) – e Table Name

CHAPTER 10  TASKBUILDER ACTIONS 111Data-to-XML Actione Data-to-XML action (see Figure 10.4) outputs the contents of the dataset in memory to an

112 CHAPTER 10  TASKBUILDER ACTIONSe Data-to-Text action has the following properties:  Add Header? (Choice) – Selecting Yes will add a header l

CHAPTER 10  TASKBUILDER ACTIONS 113NoteIn version 1.0 of TaskBuilder, only Collector trac data tables can be converted into 3 Card format. If t

114 CHAPTER 10  TASKBUILDER ACTIONSFigure 10.7 – XML-to-Data Actione XML-to-Data action has no individual properties.XML-to-XML Actione XML-to-X

CHAPTER 10  TASKBUILDER ACTIONS 115XSLT le specically designed to match the schema of the source le. When selecting a source le and transfor

116 CHAPTER 10  TASKBUILDER ACTIONS[File]-to-Email ActionAny le type can be emailed using the Email component—XML, text, Excel, PDF, HTML or 3 Ca

CHAPTER 10  TASKBUILDER ACTIONS 117NoteTaskBuilder will ignore leading and trailing white space when processing properties. If you would like sp

118 CHAPTER 10  TASKBUILDER ACTIONSNoteTaskBuilder will ignore leading and trailing white space when processing properties. If you would like spac

Part 1TranslatorChapter 1 – Using the Translator Web InterfaceChapter 2 – Job List PageChapter 3 – Users PageChapter 4 – Routes PageChapter 5 – System

CHAPTER 10  TASKBUILDER ACTIONS 119overwritten with the new le.  Remove Source Files? (Value—Yes/No) – Select Yes to delete the local source 

120 CHAPTER 10  TASKBUILDER ACTIONSFigure 10.16 – Trip-Time-to-XML Actione result XML le has the following structure:<TripTimes> <Tri

In this chapter  Database Conversion Sub-window  Mapping Sub-window  Trip Time Mapping Sub-window  Trip Time Template Sub-window  Trip Time Sub-w

122 CHAPTER 11  TASKBUILDER SUB-WINDOWSNoteThe properties of both Database components must be set before opening the Data-base Conversion sub-wind

CHAPTER 11  TASKBUILDER SUB-WINDOWS 123Database Conversion Sub-window ElementsFigure 11.1 shows the Database Conversion sub-window with the foll

124 CHAPTER 11  TASKBUILDER SUB-WINDOWS  Select the desired source column then drag the cursor from the source column to the desired destination

CHAPTER 11  TASKBUILDER SUB-WINDOWS 125Figure 11.2 – Default ValuesEach column in the destination table that does not have a mapping will be lis

126 CHAPTER 11  TASKBUILDER SUB-WINDOWSmark “Auto” for any data column that has an auto-increment trigger attached to it.NoteFailure to check the

CHAPTER 11  TASKBUILDER SUB-WINDOWS 127Figure 11.3 – MappingMapping Sub-window Elementse Mapping sub-window contains the following elements: 

128 CHAPTER 11  TASKBUILDER SUB-WINDOWS  Mapping Pairs List – e Mapping Pairs list, contained in the box at the bottom of the sub-window, is a l

CHAPTER 11  TASKBUILDER SUB-WINDOWS 129Figure 11.4 – Trip Time MappingTrip Time Mapping Sub-window ElementsAll elements except for the Destinati

130 CHAPTER 11  TASKBUILDER SUB-WINDOWSIn Trip Time mappings, ALL destination columns must have a mapping from a source column before the mapping

CHAPTER 11  TASKBUILDER SUB-WINDOWS 131Figure 11.5 – Trip Time Template  Calculation Value – e Calculation Value box allows you to choose whet

132 CHAPTER 11  TASKBUILDER SUB-WINDOWS  Done Button – e Done button saves the current mappings and closes the sub-win-dow, returning you to the

CHAPTER 11  TASKBUILDER SUB-WINDOWS 133Figure 11.6 – Trip Time Sub-window (Sensor Only)To add more than one sensor to an element, select the ele

134 CHAPTER 11  TASKBUILDER SUB-WINDOWSsensor IDs and custom names work the same as the le, right and delete buttons when edit-ing route elements

CHAPTER 11  TASKBUILDER SUB-WINDOWS 135Figure 11.8 – SmartSensor Trip TimesIn SmartSensor mode, you can see which approach each sensor lane belo

136 CHAPTER 11  TASKBUILDER SUB-WINDOWS  Editor – e Editor drop-down list allows you to assign an outside editor to the com-ponent. e editor th

CHAPTER 11  TASKBUILDER SUB-WINDOWS 137Figure 11.10 – Add Propertye Add Property window has the following elements:  Property Name – Names mus

138 CHAPTER 11  TASKBUILDER SUB-WINDOWSFigure 11.11 – Add a Custom ActionAdd Action Sub-window Elementse Add Action sub-window contains the follo

In this chapter  Logging In  Menu Bar  Context-sensitive Help  Logging Out1To access the Translator Web interface, open a Web browser and enter yo

CHAPTER 11  TASKBUILDER SUB-WINDOWS 139  Action Properties – Allows you to add, edit and delete properties for this action. (See the Creating P

140 CHAPTER 11  TASKBUILDER SUB-WINDOWS  When Run button is clicked – is setting aects the functionality of the Run toolbar button in regards t

CHAPTER 11  TASKBUILDER SUB-WINDOWS 141Components Tabe Components tab, shown in Figure 11.13, allows you to change the order of the compo-nents

142 CHAPTER 11  TASKBUILDER SUB-WINDOWSEditors Tabe Editors tab, shown in Figure 11.14, allows you to change the outside editors used to work wit

CHAPTER 11  TASKBUILDER SUB-WINDOWS 143Databases TabClicking the Oracle Support check box on this tab allows Translator to handle Oracle da-taba

In the appendix  Appendix A – Guide to Common Tasks  Appendix B – Writing SQL Queries12Appendix A – Guide to Common Tasksis section has step-by-ste

146 APPENDIXbelow. Click on Edit to bring up the DataBase Conversion sub-window.5 Select the database and table for both the source and destination

APPENDIX 147For tables on dierent database servers or dierent database types, additional components and actions will need to be added from the sou

148 APPENDIXMultiple Source Tables into One Destination Tablee many-to-one mapping requires a middle step to run correctly. Follow the steps below t

14 CHAPTER 1  USING THE TRANSLATOR WEB INTERFACEe default username is “administrator” and the default password is “password.” Be sure to change t

APPENDIX 1492 Drag DB, Data, and XML to the main task window. Create actions according to the pattern below:Figure A.6 – Database-to-XML3 Fill in

150 APPENDIXFigure A.8 – Multiple Files to EmailYou can send the same le to multiple email addresses (see Figure A.9).Figure A.9 – File to Multiple

APPENDIX 151TableOne and TableTwo, each contain four columns (the data types of these columns are usually not necessary to know):  TableOne – One,

152 APPENDIXSELECT * from TableTwo WHERE Five < 10 AND Seven >= 50SELECT * from TableOne WHERE Two = ‘Hello’ OR Two = ‘World’ere is no limit t

APPENDIX 153ExampleIf TableOne and TableTwo both contain an “ID” column in addition to their other col-umns, then the ID numbers can be matched up t

www.wavetronix.com

CHAPTER 1  USING THE TRANSLATOR WEB INTERFACE 15Figure 1.3 – Context-sensitive HelpIf you need more information, the link at the end of the help

In this chapter  Jobs  Adding and Configuring Jobs  Services  Adding and Configuring Services2Aer you’ve successfully logged into Translator, the J

18 CHAPTER 2  JOB LIST PAGEYou can also access the Job List from elsewhere in the program through the Job List link in the menu bar.e Job List pa

Command TranslatorUSER GUIDEwww.wavetronix.com  78 East 1700 South Provo, Utah 84606  801.734.7200

CHAPTER 2  JOB LIST PAGE 19  On/O – Enables or disables execution on each job. Users with the appropriate access can click on the boxes in thi

20 CHAPTER 2  JOB LIST PAGEFigure 2.4 – Job Information Pagee Job Information page has an information bar at the top, and the rest is organized i

CHAPTER 2  JOB LIST PAGE 21the rst attempt. You should be careful that the combination of this value and the # of retry attempts don’t cause th

22 CHAPTER 2  JOB LIST PAGENoteStoring too many history entries will result in poor performance; the recommended number of entries is 10–100. This

CHAPTER 2  JOB LIST PAGE 23Figure 2.7 – Tasks Section  e Tasks to Execute area lists all tasks currently associated with the job. Each task’s

24 CHAPTER 2  JOB LIST PAGEFigure 2.8 – Events Sectione rst section, labeled “Events that will trigger this job,” shows the events currently con

CHAPTER 2  JOB LIST PAGE 25Figure 2.10 – Advanced Time Schedulee Advanced tab species the job’s starting time as well as the starting/ending d

26 CHAPTER 2  JOB LIST PAGEMonthly Interval and enter the appropriate interval. If you want the job to run every January and July, then select Sel

CHAPTER 2  JOB LIST PAGE 27Under the Notify Users section, you can see the users who have already been set up to be notied, with their username

28 CHAPTER 2  JOB LIST PAGE  Running – Indicates the number of services currently running.  Stopped – Indicates the number of services that are

© 2014 Wavetronix LLC. All Rights Reserved.Wavetronix, SmartSensor, Click, Command, and all associated product names and logos are trademarks of Wavet

CHAPTER 2  JOB LIST PAGE 29Add ServiceNew services can be added by clicking on the Add Service button found under the services tab. Once in the

30 CHAPTER 2  JOB LIST PAGEFigure 2.17 – Configure Service InformationInformation BarAt the top of the Service Information page is the information

CHAPTER 2  JOB LIST PAGE 31Loge Log section displays any information that the service has written to the log. In order to give you feedback as

32 CHAPTER 2  JOB LIST PAGEfrom the notication list; this will only be available if you have the necessary privileges.Under the section marked “A

In this chapter  User List  Edit User3e Users Information page, accessed through the Users link in the menu bar, allows you to view and edit users

34 CHAPTER 3  USERS PAGEFigure 3.1 – User Information PageUser Liste rst section on the screen is the user list (see Figure 3.2). In this sectio

CHAPTER 3  USERS PAGE 35Figure 3.3 – Edit UserEdit UserTo edit a user, click on the desired user’s name in the user list; this will cause the us

36 CHAPTER 3  USERS PAGEe default for a new user includes all privileges except for “Change system noti-cations,” “Change system settings” and “

In this chapter  Routes Page  Route Toolbar  Editing a Route  Assets  Travel Points  Route Data and Overrides  Creating an Advanced Trip Time T

38 CHAPTER 4  ROUTES PAGEare usually exit ramps or other destination points.e travel time tasks calculate the time needed to travel through each

ContentsIntroduction 7Translator Web Interface 8 • TaskBuilder User Interface 8 • Translation Jobs & Services 9Part I TranslatorChapter 1 Using

CHAPTER 4  ROUTES PAGE 39NoteIn order to use routes within the Translator Advanced Travel Time System, a specific database table format must be u

40 CHAPTER 4  ROUTES PAGEFigure 4.2 – Create Route WindowDeleting RoutesTo delete existing routes, select one or more routes from the route list b

CHAPTER 4  ROUTES PAGE 41e Copy and Reverse option is available as a convenience for instances where both direc-tions of the same roadway are d

42 CHAPTER 4  ROUTES PAGERoute Configuratione elds in the upper le (see Figure 4.4) list the eight primary attributes of the route, which can be

CHAPTER 4  ROUTES PAGE 43Select either, both, or none of these options, then hit OK. More information about recali-brating segments can be found

44 CHAPTER 4  ROUTES PAGERoutes can be divided into segments which also have a start and end mile marker. Routes can be composed of any number of

CHAPTER 4  ROUTES PAGE 45selected option is not available, the segment will be combined with the opposite side instead.Figure 4.10 – Remove Segm

46 CHAPTER 4  ROUTES PAGEAssetsRoutes in Command Translator will usually require data sources to be useful in a data pro-cessing context. Data sou

CHAPTER 4  ROUTES PAGE 47Figure 4.13 – Edit Asset GroupTo add an asset manually, push the Add Asset Manually button to display the Add Asset win

48 CHAPTER 4  ROUTES PAGEFigure 4.15 – Select Collector Sensorse Collector Sensor List contains all the available sensors that are registered on

Part II TaskbuilderChapter 7 TaskBuilder User Interface 73Setting Up TaskBuilder 73 • TaskBuilder User Interface 74 • Menu and Toolbar Buttons 75 •

CHAPTER 4  ROUTES PAGE 49available above the grid (e default option is All). Selecting a new lter option will show only those sensor listings

50 CHAPTER 4  ROUTES PAGEe list of assets can be ltered by using the lter controls above the grid. You can select one or more asset groups to d

CHAPTER 4  ROUTES PAGE 51closest to an asset location are the most relevant; however users are free to map any seg-ments to any asset within the

52 CHAPTER 4  ROUTES PAGE Figure 4.18 – Travel Point TabTravel points have the following characteristics:  Name – Names must be unique  Descript

CHAPTER 4  ROUTES PAGE 53To override a travel time for a particular segment, or to add a special message to the route, click on the Override tab

54 CHAPTER 4  ROUTES PAGE  User Name / Password – Login information for the database connection  Routes – Allows you to select a route to use i

CHAPTER 4  ROUTES PAGE 5506/15/2011 10:27:27 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Segmen

In this chapter  Status Tab  Settings Tab  Support Tab  Notifications Tab  Collectors Tab  Journal Tab  Tasks Tab  TaskBuilder Tab5e System In

58 CHAPTER 5  SYSTEM PAGEFigure 5.1 – System Information and Settings PageStatus TabClick the Status link to access the Status screen (see Figure

Chapter 11 TaskBuilder Sub-windows 121Database Conversion Sub-window 121 • Mapping Sub-win-dow 126 • Trip Time Mapping Sub-window 128 • Trip Time Te

CHAPTER 5  SYSTEM PAGE 59NoteThe system will quickly become overloaded if jobs are being queued faster than they can be executed. If this happen

60 CHAPTER 5  SYSTEM PAGEInformatione Information section allows you to enter details regarding the server installation. is is especially helpfu

CHAPTER 5  SYSTEM PAGE 61time when a new memory space for executing jobs will be created. e setting controls the frequency at which the memory

62 CHAPTER 5  SYSTEM PAGEContact Information e Contact Information section provides email addresses and phone numbers for contact-ing Wavetronix,

CHAPTER 5  SYSTEM PAGE 63Collectors TabClick the Collectors link to access the Collectors screen (see Figure 5.6). e Collectors section provide

64 CHAPTER 6  HELP PAGEJournal TabClick the Journal link to access the Journal screen (see Figure 5.8). e Journal section pro-vides a list of all

CHAPTER 6  HELP PAGE 65Figure 5.9 – Tasks ScreenImport Taskse Import Task section is used to import tasks from XML format, generated by either

66 CHAPTER 5  SYSTEM PAGEFigure 5.11 – Export Tasks SectionRemove Taskse Remove Tasks section is used to remove tasks from the system (see Figure

In this chapter  About Tab  User Guide Tab  License Agreement Tab6Click the Help link to access the Help Information page. is page is divided into

68 CHAPTER 6  HELP PAGEinterface and the Translator service (see Figure 6.2). is can be useful when contacting support or upgrading the system.Fi

CHAPTER 6  HELP PAGE 69Figure 6.4 – License Agreement

Part IITaskBuilderChapter 7 – TaskBuilder User InterfaceChapter 8 – Basic TaskBuilder FunctionsChapter 9 – TaskBuilder ComponentsChapter 10 – TaskBuil

In this chapter  Setting Up TaskBuilder  TaskBuilder User Interface  TaskBuilder Menu and Toolbar Buttons  Select/Action Toolbar  Component List

74 CHAPTER 7  TASKBUILDER USER INTERFACElation is complete.  XML-to-PDF Conversions – When converting XML-to-PDF, TaskBuilder requires the Visual

CHAPTER 7  TASKBUILDER USER INTERFACE 75  Component List – Displays the available components for placement in the main task window.  Propertie

76 CHAPTER 7  TASKBUILDER USER INTERFACEOptions Menue Options menu contains the following buttons: Run Task – Opens the Debug menu and toolbar b

CHAPTER 7  TASKBUILDER USER INTERFACE 77Mode Buttonse Select/Action toolbar changes TaskBuilder from Select to Action mode and vice versa. One

78 CHAPTER 7  TASKBUILDER USER INTERFACEMain Task Windowe tabs at the bottom of the main task window allow you to switch between one or more task

In this chapter  DataTranslator Web Interface  TaskBuilder User Interface  Translation Tasks, Jobs & Servicese Command Translator soware appl

CHAPTER 7  TASKBUILDER USER INTERFACE 79Properties Areae Properties area, located below the main task window, displays one or more properties t

80 CHAPTER 7  TASKBUILDER USER INTERFACEFigure 7.5 – Property Option Dialog Windowe following property options are available:  Set at Design Tim

In this chapter  Creating a New Task  Opening an Existing Task  Viewing/Changing Task Properties  Deleting a Task  Exporting/Importing a Task  W

82 CHAPTER 8  BASIC TASKBUILDER FUNCTIONStoolbar. e Task Details sub-window will appear (see Figure 8.1). e Task Details sub-window is also call

CHAPTER 8  BASIC TASKBUILDER FUNCTIONS 83Figure 8.2 – Task ManagerTo open a task, double-click on the task name or select the task name from the

84 CHAPTER 8  BASIC TASKBUILDER FUNCTIONSExporting a TaskTaskBuilder can export one or more tasks to an XML le or directly to a running Translato

CHAPTER 8  BASIC TASKBUILDER FUNCTIONS 85Importing a TaskTaskBuilder can import tasks into its internal database either from an XML le or direc

86 CHAPTER 8  BASIC TASKBUILDER FUNCTIONSNoteImporting from a Translator Service or from a file will automatically overwrite any task of the same n

CHAPTER 8  BASIC TASKBUILDER FUNCTIONS 87  Creating multiple actions from the same start component to dierent end components. e same start co

88 CHAPTER 8  BASIC TASKBUILDER FUNCTIONSSelecting One or More Components or ActionsTo select components or actions, put TaskBuilder in Select mod

8 INTRODUCTION  COMMAND TRANSLATOR USER GUIDEFigure I.1 – Translator FunctionsTranslator Web Interfacee Translator Web interface provides detaile

CHAPTER 8  BASIC TASKBUILDER FUNCTIONS 89when the start or end component is moved. Deleting Components or ActionsTo delete components or actions

90 CHAPTER 8  BASIC TASKBUILDER FUNCTIONSCopying Components or ActionsElements can be copied and then pasted into the same task or into a dierent

CHAPTER 8  BASIC TASKBUILDER FUNCTIONS 91NoteTaskBuilder does NOT allow actions that are missing a start or end component. Any action that is le

92 CHAPTER 8  BASIC TASKBUILDER FUNCTIONS1 Click the button on the toolbar or select Run Task from the Options menu. De-pending on the congura

CHAPTER 8  BASIC TASKBUILDER FUNCTIONS 93Figure 8.9 – Error ReportDebugging a TaskFollow the steps below to go through a task step-by-step in De

94 CHAPTER 8  BASIC TASKBUILDER FUNCTIONSUsing Third-Party EditorsTaskBuilder does not support internal editing of Text, XML, HTML, SQL or PDF le

CHAPTER 8  BASIC TASKBUILDER FUNCTIONS 95ABCDEFigure 8.10 – Task ExecutionDepth-first ExecutionIn depth-rst execution each branch of the task is

In this chapter  Database (DB)  Data  XML  Email  HTML  PDF  Text  3 Card  Trip Time  File Name Place Holders  FTP  Excel  Advanced Trip

98 CHAPTER 9  TASKBUILDER COMPONENTSDatabase (DB)e Database type represents data currently within a database system on either the local or remote